Facilities Database

City of New York

@usgov.city_of_new_york_facilities_database

Table List

1 table(4.92 MB)

Table 1

@usgov.city_of_new_york_facilities_database.table_1

4.92 MB
35387 rows
38 columns

uid Uid	facname Facname	addressnum Addressnum	streetname Streetname	address Address	city City	boro Boro	borocode Borocode	zipcode Zipcode	latitude Latitude	longitude Longitude	xcoord Xcoord	ycoord Ycoord	bin Bin	bbl Bbl	cd Cd	council Council	ct2010 Ct2010	ct2020 Ct2020	nta2010 Nta2010	nta2020 Nta2020	facgroup Facgroup	facsubgrp Facsubgrp	factype Factype	capacity Capacity	captype Captype	optype Optype	opname Opname	opabbrev Opabbrev	overlevel Overlevel	overagency Overagency	overabbrev Overabbrev	datasource Datasource	facdomain Facdomain	schooldist Schooldist	policeprct Policeprct	servarea Servarea	geometry Geometry
000081aff7e44860160371b7a6b79e9a	I.S. 075 FRANK D. PAULO	455	HUGUENOT AVENUE	455 HUGUENOT AVENUE	STATEN ISLAND	STATEN ISLAND	5	10312	40.5443465223	-74.1972025406	929441.897611	137658.337879	5079651	5060500002	503	51	17010	17014	SI48	SI0303	SCHOOLS (K-12)	PUBLIC K-12 SCHOOLS	JUNIOR HIGH-INTERMEDIATE-MIDDLE SCHOOL - PUBLIC	1579	seats	Public	NYC Department of Education	NYCDOE	City	NYC Department of Education	NYCDOE	doe_lcgms	EDUCATION, CHILD WELFARE, AND YOUTH	31	123	Local	POINT(929441.8976078033 137658.3378920555)
000105fd986377e37a8f95abfdbda92d	SUCCESS ACADEMY CS - BENSONHURST			99 AVE P-4TH FL	BROOKLYN	BROOKLYN	3	11204	40.60771735	-73.98490472	988441.425509	160684.570814		3065950033	311	44	43000	43000	BK29	BK1101	SCHOOLS (K-12)	CHARTER K-12 SCHOOLS	CHARTER SCHOOL			Public	NYC Department of Education	NYCDOE	City	NYC Department of Education	NYCDOE	nysed_activeinstitutions	EDUCATION, CHILD WELFARE, AND YOUTH	21	62	Local	POINT(988441.4255123138 160684.57081079483)
000186821f899fef28e05c9ca2182621	PLANNED PARENTHOOD BRONX HEALTH CENTER	349	EAST 149 STREET	349 EAST 149 STREET	BRONX	BRONX	2	10451	40.8168608176	-73.9197098899	1006473.88046	236891.743743	2000933	2023317501	201	17	6500	6500	BX34	BX0102	HEALTH CARE	HOSPITALS AND CLINICS	DIAGNOSTIC AND TREATMENT CENTER EXTENSION CLINIC			Non-public	Planned Parenthood of Greater New York, Inc.	Non-public	State	NYS Department of Health	NYSDOH	nysdoh_healthfacilities	HEALTH AND HUMAN SERVICES	7	40	Regional	POINT(1006473.8804678917 236891.74374437332)
0002d3b5bb64af5fbc4d28e67dd33e1a	WASHINGTON IRVING YABC	40	IRVING PLACE	40 IRVING PLACE	NEW YORK	MANHATTAN	1	10003	40.7353192172	-73.9870850667	987829.166215	207173.473929	1017828	1008720057	106	2	5000	5000	MN21	MN0602	CHILD SERVICES AND WELFARE	CHILD NUTRITION	FEEDING SITE			Non-public	Washington Irving Yabc	Non-public	City	NYC Department of Education	NYCDOE	nysed_activeinstitutions	EDUCATION, CHILD WELFARE, AND YOUTH	2	13	Local	POINT(987829.1662182808 207173.47393465042)
00056520e4c5483e13933cda8c8a736d	MARKS JCH OF BENSONHURST DAY CAMP	7802	BAY PARKWAY	7802 BAY PARKWAY	BROOKLYN	BROOKLYN	3	11214	40.6063681456	-73.9897506573	987095.937581	160192.826085	3162352	3062640030	311	44	27000	27000	BK28	BK1101	CAMPS	CAMPS	CAMP - ALL AGE			Non-public	Edith & Carl Marks Jewish Community House Bensonhurst, Inc.	Non-public	City	NYC Department of Health and Mental Hygiene	NYCDOHMH	dohmh_daycare	EDUCATION, CHILD WELFARE, AND YOUTH	20	62	Local	POINT(987095.9375667572 160192.82608127594)
0005cf2135820de8d20395875ca0e506	CENTER FOR JEWISH HISTORY	15	WEST 16 STREET	15 WEST 16 STREET	NEW YORK	MANHATTAN	1	10011	40.7380631353	-73.9938027268	985967.403942	208172.966736	1080631	1008180027	105	3	5400	5400	MN13	MN0501	CULTURAL INSTITUTIONS	OTHER CULTURAL INSTITUTIONS	HUMANITIES			Non-public	Center for Jewish History	Non-public	City	NYC Department of Cultural Affairs	NYCDCLA	dcla_culturalinstitutions	LIBRARIES AND CULTURAL PROGRAMS	2	13	Regional	POINT(985967.4039525986 208172.96673631668)
0006e49b4ecf531c88f5dec8bd7d0364	RELIANT TRANSPORTATION, INC (B2321)	297	NORMAN AVENUE	297 NORMAN AVENUE	BROOKLYN	BROOKLYN	3	11222	40.7283212706	-73.940570542	1000721.64769	204629.226745	3398537	3026120133	301	33	58900	58902	BK76	BK0101	TRANSPORTATION	BUS DEPOTS AND TERMINALS	SCHOOL BUS DEPOT	271	routes	Non-public	Reliant Transportation, Inc (B2321)	Non-public	City	NYC Department of Education	NYCDOE	doe_busroutesgarages	CORE INFRASTRUCTURE AND TRANSPORTATION	14	94	Regional	POINT(1000721.6477017403 204629.22674131393)
000898872e62bfd79bb2e5fb4f6fbb38	P.S. 195 MANHATTAN BEACH	131	IRWIN STREET	131 IRWIN STREET	BROOKLYN	BROOKLYN	3	11235	40.5802091276	-73.9436279172	999908.982653	150667.303888	3246519	3087520035	315	48	62000	62000	BK17	BK1503	SCHOOLS (K-12)	PUBLIC K-12 SCHOOLS	ELEMENTARY SCHOOL - PUBLIC	333	seats	Public	NYC Department of Education	NYCDOE	City	NYC Department of Education	NYCDOE	doe_lcgms	EDUCATION, CHILD WELFARE, AND YOUTH	22	61	Local	POINT(999908.9826469421 150667.303896904)
00093367a9d66ff799c9cc47b368dd16	EQUITY PLAYGROUND			90-10 88 AVENUE	WOODHAVEN	QUEENS	4	11421	40.6913027952	-73.8533866992	1024908.34186	191170.71569		4089290005	409	32	1800	1800	QN53	QN0905	PARKS AND PLAZAS	RECREATION AND WATERFRONT SITES	PLAYGROUND			Public	NYC Department of Parks and Recreation	NYCDPR	City	NYC Department of Parks and Recreation	NYCDPR	dpr_parksproperties	PARKS, GARDENS, AND HISTORICAL SITES	27	102	Local	POINT(1024908.3418545723 191170.71568250656)
00098ca3934642d37267e38f73e5818a	CHAMPION PARKING 52 LLC	356	WEST 52 STREET	356 WEST 52 STREET	NEW YORK	MANHATTAN	1	10019	40.7642521387	-73.9871616529	987806.396642	217714.665867	1090939	1010420054	104	3	13300	13300	MN15	MN0402	TRANSPORTATION	PARKING LOTS AND GARAGES	COMMERCIAL PARKING LOT			Non-public	Champion Parking 52 Llc	Non-public	City	NYC Department of Consumer Affairs	NYCDCA	dca_operatingbusinesses	CORE INFRASTRUCTURE AND TRANSPORTATION	2	18	Local	POINT(987806.3966374397 217714.66587781906)


CREATE TABLE table_1 (
  "uid" VARCHAR,
  "facname" VARCHAR,
  "addressnum" VARCHAR,
  "streetname" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "boro" VARCHAR,
  "borocode" BIGINT,
  "zipcode" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "bin" BIGINT,
  "bbl" BIGINT,
  "cd" BIGINT,
  "council" BIGINT,
  "ct2010" DOUBLE,
  "ct2020" DOUBLE,
  "nta2010" VARCHAR,
  "nta2020" VARCHAR,
  "facgroup" VARCHAR,
  "facsubgrp" VARCHAR,
  "factype" VARCHAR,
  "capacity" BIGINT,
  "captype" VARCHAR,
  "optype" VARCHAR,
  "opname" VARCHAR,
  "opabbrev" VARCHAR,
  "overlevel" VARCHAR,
  "overagency" VARCHAR,
  "overabbrev" VARCHAR,
  "datasource" VARCHAR,
  "facdomain" VARCHAR,
  "schooldist" DOUBLE,
  "policeprct" BIGINT,
  "servarea" VARCHAR,
  "geometry" VARCHAR
);