superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where MNG_AGENCY = 215
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
493 | 493 | 492 | {"type": "Polygon", "coordinates": [[[-120.73039, 37.37147], [-120.73038, 37.37207], [-120.73005, 37.37207], [-120.72997, 37.37203], [-120.72969, 37.37208], [-120.72899, 37.37208], [-120.729, 37.37138], [-120.72985, 37.37139], [-120.73007, 37.37142], [-120.7302, 37.37147], [-120.73039, 37.37147]]]} | Open Access 1 | Frederick Worden Park | https://www.livingstoncity.com/index.asp?Type=B_BASIC&SEC=%7BCF892827-E8A2-4A7D-AE4A-C5FB926EE204%7D&DE=%7B27875D5D-2DDD-4E2A-BDEE-B2B4C34F36A1%7D | 33509 | 1179 | Livingston, City of 215 | City 2 | City Agency 2 | http://www.livingstoncity.com/ | City 2 | 2.237 | Frederick Worden Park | |
499 | 499 | 498 | {"type": "Polygon", "coordinates": [[[-120.71049, 37.39404], [-120.70947, 37.39405], [-120.70947, 37.39319], [-120.71033, 37.39321], [-120.71033, 37.39336], [-120.71037, 37.39347], [-120.71046, 37.39362], [-120.71048, 37.39372], [-120.71049, 37.39404]]]} | Open Access 1 | Don Meyer Park | https://www.livingstoncity.com/index.asp?Type=B_BASIC&SEC=%7BCF892827-E8A2-4A7D-AE4A-C5FB926EE204%7D&DE=%7B27875D5D-2DDD-4E2A-BDEE-B2B4C34F36A1%7D | 33510 | 1179 | Livingston, City of 215 | City 2 | City Agency 2 | http://www.livingstoncity.com/ | City 2 | 1.955 | Don Meyer Park | |
500 | 500 | 499 | {"type": "Polygon", "coordinates": [[[-120.70774, 37.37509], [-120.70769, 37.37584], [-120.70689, 37.37578], [-120.70694, 37.37503], [-120.70774, 37.37509]]]} | Open Access 1 | Singh Park | 33511 | 1179 | Livingston, City of 215 | City 2 | City Agency 2 | http://www.livingstoncity.com/ | City 2 | 1.458 | Singh Park | ||
1531 | 1531 | 1530 | {"type": "Polygon", "coordinates": [[[-120.73107, 37.37865], [-120.72983, 37.37865], [-120.72981, 37.37893], [-120.72971, 37.37898], [-120.72966, 37.37903], [-120.72963, 37.37909], [-120.72965, 37.37918], [-120.72964, 37.37954], [-120.72957, 37.3796], [-120.72862, 37.37959], [-120.72856, 37.37955], [-120.72857, 37.37907], [-120.72853, 37.379], [-120.72843, 37.37894], [-120.72842, 37.37865], [-120.72754, 37.37865], [-120.72756, 37.37787], [-120.72845, 37.37787], [-120.72857, 37.37793], [-120.72867, 37.37793], [-120.72875, 37.37789], [-120.72879, 37.37783], [-120.72879, 37.37776], [-120.72874, 37.3777], [-120.72894, 37.37753], [-120.72951, 37.37793], [-120.72985, 37.37814], [-120.73018, 37.37826], [-120.73076, 37.37842], [-120.73107, 37.37865]]]} | Open Access 1 | Arakelian Park | 15551 | 1179 | Livingston, City of 215 | City 2 | City Agency 2 | http://www.livingstoncity.com/ | City 2 | 8.091 | Arakelian Park | ||
5421 | 5421 | 5420 | {"type": "Polygon", "coordinates": [[[-120.71882, 37.39087], [-120.71829, 37.39134], [-120.71804, 37.39108], [-120.71769, 37.39086], [-120.71797, 37.39057], [-120.71824, 37.39065], [-120.71876, 37.39058], [-120.71882, 37.39087]]]} | Open Access 1 | Lucero Park | 21578 | 1179 | Livingston, City of 215 | City 2 | City Agency 2 | http://www.livingstoncity.com/ | City 2 | 1.205 | Lucero Park | ||
6309 | 6309 | 6308 | {"type": "Polygon", "coordinates": [[[-120.72329, 37.37722], [-120.72327, 37.37858], [-120.72104, 37.37854], [-120.72106, 37.37768], [-120.72094, 37.37766], [-120.72094, 37.37753], [-120.72296, 37.37755], [-120.72298, 37.37722], [-120.72329, 37.37722]]]} | Open Access 1 | Livingston Memorial Park | 21384 | 1179 | Livingston, City of 215 | City 2 | City Agency 2 | http://www.livingstoncity.com/ | City 2 | 5.828 | Livingston Memorial Park | ||
6310 | 6310 | 6309 | {"type": "Polygon", "coordinates": [[[-120.70787, 37.3895], [-120.70505, 37.38952], [-120.70508, 37.38762], [-120.70787, 37.38761], [-120.70787, 37.3895]]]} | Open Access 1 | Livingston Sports Complex | 21385 | 1179 | Livingston, City of 215 | City 2 | City Agency 2 | http://www.livingstoncity.com/ | City 2 | 12.916 | Livingston Sports Complex | ||
11788 | 11788 | 11787 | {"type": "Polygon", "coordinates": [[[-120.7368, 37.38008], [-120.73483, 37.38008], [-120.7349, 37.37987], [-120.73493, 37.37952], [-120.73494, 37.37898], [-120.73499, 37.37865], [-120.73679, 37.37865], [-120.7368, 37.38008]]]} | Open Access 1 | Joseph Gallo Park | http://www.livingstoncity.com/index.asp?Type=B_BASIC&SEC={CF892827-E8A2-4A7D-AE4A-C5FB926EE204}&DE={27875D5D-2DDD-4E2A-BDEE-B2B4C34F36A1} | 28408 | 1179 | Livingston, City of 215 | City 2 | City Agency 2 | http://www.livingstoncity.com/ | City 2 | 6.477 | Joseph Gallo Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);