superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where MNG_AGENCY = 395 and YR_EST = 1973
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
747 | 747 | 746 | {"type": "Polygon", "coordinates": [[[-121.96249, 37.39315], [-121.96184, 37.39343], [-121.96118, 37.39246], [-121.96183, 37.39218], [-121.96249, 37.39315]]]} | Open Access 1 | Agnew Park | 15287 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.999 | Agnew Park | 1973 | |
2196 | 2196 | 2195 | {"type": "Polygon", "coordinates": [[[-121.9766, 37.37015], [-121.97596, 37.37005], [-121.97532, 37.3699], [-121.97545, 37.36958], [-121.97534, 37.36894], [-121.97528, 37.36883], [-121.97562, 37.36873], [-121.97577, 37.36875], [-121.97588, 37.36871], [-121.97638, 37.36873], [-121.9766, 37.37015]]]} | Open Access 1 | Bracher Park | 16320 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 3.503 | Bracher Park | 1973 | |
3777 | 3777 | 3776 | {"type": "Polygon", "coordinates": [[[-121.99345, 37.34515], [-121.99312, 37.3453], [-121.99136, 37.34629], [-121.99125, 37.34633], [-121.99079, 37.34645], [-121.99029, 37.34667], [-121.99012, 37.3468], [-121.98981, 37.34711], [-121.98982, 37.3452], [-121.99311, 37.34513], [-121.99345, 37.34515]]]} | Open Access 1 | Earl R. Carmichael Park | 18352 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 8.11 | Earl R. Carmichael Park | 1973 | |
6786 | 6786 | 6785 | {"type": "Polygon", "coordinates": [[[-121.98997, 37.32963], [-121.98969, 37.33024], [-121.98951, 37.33049], [-121.98935, 37.33065], [-121.98918, 37.33078], [-121.98864, 37.33106], [-121.98806, 37.33073], [-121.98785, 37.33064], [-121.9876, 37.33055], [-121.98719, 37.33046], [-121.9863, 37.33037], [-121.98626, 37.33034], [-121.98624, 37.33031], [-121.98632, 37.32911], [-121.98635, 37.32896], [-121.98641, 37.32882], [-121.98658, 37.32851], [-121.9866, 37.32973], [-121.98899, 37.33013], [-121.98919, 37.32973], [-121.98924, 37.32975], [-121.98932, 37.32977], [-121.9894, 37.32974], [-121.98945, 37.3297], [-121.98946, 37.32962], [-121.98939, 37.32953], [-121.98939, 37.3295], [-121.9894, 37.32947], [-121.98997, 37.32963]]]} | Open Access 1 | Maywood Park | 21983 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 7.322 | Maywood Park | 1973 | |
7116 | 7116 | 7115 | {"type": "Polygon", "coordinates": [[[-121.94701, 37.38786], [-121.94445, 37.38895], [-121.94438, 37.38881], [-121.94432, 37.38867], [-121.94427, 37.38843], [-121.94427, 37.38788], [-121.94664, 37.38686], [-121.9469, 37.38724], [-121.94694, 37.38733], [-121.94695, 37.38743], [-121.94695, 37.38768], [-121.94697, 37.38777], [-121.94701, 37.38786]]]} | Open Access 1 | Montague Park | 22381 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 7.197 | Montague Park | 1973 |
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]);