superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where MNG_AGENCY = 179
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11020 | 11020 | 11019 | {"type": "Polygon", "coordinates": [[[-122.18181, 37.72332], [-122.18154, 37.72346], [-122.18135, 37.72327], [-122.18161, 37.72312], [-122.18181, 37.72332]]]} | Open Access 1 | Warden Park | 27255 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 0.199 | Warden Park | ||
11030 | 11030 | 11029 | {"type": "Polygon", "coordinates": [[[-122.14785, 37.69505], [-122.14561, 37.69512], [-122.14527, 37.69542], [-122.14472, 37.69503], [-122.1447, 37.69334], [-122.14783, 37.69326], [-122.14785, 37.69505]]]} | Open Access 1 | Washington Manor | 27270 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 13.828 | Washington Manor | ||
15186 | 15186 | 15185 | {"type": "Polygon", "coordinates": [[[-122.16394, 37.70921], [-122.16246, 37.7098], [-122.16258, 37.71016], [-122.16137, 37.7106], [-122.16086, 37.7098], [-122.16058, 37.70911], [-122.15938, 37.70732], [-122.15942, 37.70726], [-122.16072, 37.70679], [-122.16394, 37.70921]]]} | Open Access 1 | Pacific Recreation Complex | 23304 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 19.224 | Pacific Rec. Complex |
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]);