units_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 | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1644 | 1644 | 1643 | {"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 | 14134 | Agnew Park | 15287 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 1.999 | Agnew Park | 1973 | Local Park 2 | 4 | |
1647 | 1647 | 1646 | {"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.34679], [-121.98981, 37.34711], [-121.98982, 37.3452], [-121.99311, 37.34513], [-121.99345, 37.34515]]]} | Open Access 1 | 14174 | Earl R. Carmichael Park | 18352 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 8.11 | Earl R. Carmichael Park | 1973 | Local Park 2 | 4 | |
8699 | 8699 | 8698 | {"type": "Polygon", "coordinates": [[[-121.9766, 37.37015], [-121.97596, 37.37005], [-121.97532, 37.3699], [-121.97545, 37.36958], [-121.97534, 37.36893], [-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 | 14137 | Bracher Park | 16320 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 3.503 | Bracher Park | 1973 | Local Park 2 | 4 | |
8709 | 8709 | 8708 | {"type": "Polygon", "coordinates": [[[-121.94701, 37.38786], [-121.94445, 37.38895], [-121.94437, 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.38742], [-121.94695, 37.38768], [-121.94697, 37.38777], [-121.94701, 37.38786]]]} | Open Access 1 | 14136 | Montague Park | 22381 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 7.197 | Montague Park | 1973 | Local Park 2 | 4 | |
8714 | 8714 | 8713 | {"type": "Polygon", "coordinates": [[[-121.98997, 37.32963], [-121.98969, 37.33024], [-121.98951, 37.33049], [-121.98936, 37.33064], [-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.989, 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 | 14170 | Maywood Park | 21983 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 7.309 | Maywood Park | 1973 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);