units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where DES_TP = 2, MNG_AG_TYP = 2 and YR_EST = 1976
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
283 | 283 | 282 | {"type": "Polygon", "coordinates": [[[-121.83395, 37.28668], [-121.83326, 37.28716], [-121.83159, 37.28524], [-121.83237, 37.2848], [-121.83246, 37.28472], [-121.83255, 37.28474], [-121.83263, 37.28484], [-121.83263, 37.28489], [-121.83258, 37.28503], [-121.83268, 37.28506], [-121.83261, 37.28527], [-121.83299, 37.28536], [-121.83302, 37.2853], [-121.83308, 37.28531], [-121.83315, 37.2851], [-121.83366, 37.28521], [-121.83379, 37.28482], [-121.83386, 37.28484], [-121.83388, 37.28486], [-121.8339, 37.28555], [-121.83392, 37.28556], [-121.83395, 37.28668]]]} | Open Access 1 | 962 | Solari Park | 25596 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 7.564 | Solari Park | 1976 | Local Park 2 | 4 | |
1923 | 1923 | 1922 | {"type": "Polygon", "coordinates": [[[-121.95636, 37.23168], [-121.95495, 37.23478], [-121.95379, 37.23478], [-121.95392, 37.23451], [-121.95402, 37.23449], [-121.95449, 37.23345], [-121.95517, 37.23149], [-121.95636, 37.23168]]]} | Open Access 1 | 14891 | Blossom Hill Park | 16173 | 1190 | Los Gatos, Town of 454 | City 2 | City Agency 2 | http://www.losgatosca.gov/48/Parks-and-Public-Works | City 2 | 1190 | Los Gatos, Town of 448 | City 2 | City Agency 2 | Santa Clara 19 | 8.84 | Blossom Hill Park | 1976 | Local Park 2 | 4 | |
4955 | 4955 | 4954 | {"type": "Polygon", "coordinates": [[[-122.28849, 37.84349], [-122.28816, 37.84358], [-122.28806, 37.84325], [-122.28838, 37.84316], [-122.28849, 37.84349]]]} | Open Access 1 | 14777 | 61st Street Mini Park | 15207 | 1098 | Emeryville, City of 790 | City 2 | City Agency 2 | http://www.ci.emeryville.ca.us/158/City-Parks | City 2 | 1098 | Emeryville, City of 769 | City 2 | City Agency 2 | Alameda 17 | 0.282 | 61st Street MP | 1976 | Local Park 2 | 4 | |
6451 | 6451 | 6450 | {"type": "Polygon", "coordinates": [[[-121.87834, 37.35953], [-121.87826, 37.35958], [-121.87795, 37.35929], [-121.87664, 37.36016], [-121.87692, 37.36045], [-121.87668, 37.36061], [-121.87601, 37.36039], [-121.87538, 37.36015], [-121.8747, 37.35988], [-121.87397, 37.35955], [-121.87427, 37.35876], [-121.87405, 37.35604], [-121.87435, 37.35406], [-121.87456, 37.35424], [-121.87443, 37.35524], [-121.87498, 37.35558], [-121.87596, 37.35539], [-121.87636, 37.35567], [-121.87687, 37.35616], [-121.87698, 37.35629], [-121.87713, 37.35652], [-121.87749, 37.35687], [-121.877, 37.35719], [-121.8764, 37.35761], [-121.87668, 37.35791], [-121.87834, 37.35953]]]} | Open Access 1 | 1981 | Watson Park | 30905 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | https://www.sanjoseca.gov/Facilities/Facility/Details/126 | Santa Clara 19 | 34.437 | Watson Park | 1976 | Local Park 2 | 4 |
8612 | 8612 | 8611 | {"type": "Polygon", "coordinates": [[[-121.89133, 37.27171], [-121.89131, 37.27178], [-121.89127, 37.27183], [-121.8895, 37.27229], [-121.88941, 37.27229], [-121.88931, 37.27223], [-121.88877, 37.27087], [-121.88877, 37.27083], [-121.8888, 37.27079], [-121.88885, 37.27077], [-121.89064, 37.2703], [-121.89071, 37.27031], [-121.89076, 37.27033], [-121.89079, 37.27036], [-121.89133, 37.27171]]]} | Open Access 1 | 13724 | Paul Moore Park | 23532 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 8.249 | Paul Moore Park | 1976 | Local Park 2 | 4 | |
9054 | 9054 | 9053 | {"type": "Polygon", "coordinates": [[[-121.91011, 37.40994], [-121.91009, 37.41003], [-121.9095, 37.41015], [-121.90941, 37.41], [-121.90867, 37.40911], [-121.90724, 37.40947], [-121.90723, 37.40948], [-121.90771, 37.41067], [-121.90759, 37.41079], [-121.90749, 37.41075], [-121.90735, 37.41075], [-121.90713, 37.41018], [-121.90715, 37.41006], [-121.90696, 37.40958], [-121.90689, 37.40951], [-121.90669, 37.40903], [-121.90679, 37.40894], [-121.90681, 37.40887], [-121.90677, 37.40879], [-121.90663, 37.40877], [-121.90657, 37.40878], [-121.907, 37.40831], [-121.90718, 37.40836], [-121.90782, 37.40801], [-121.90783, 37.40794], [-121.90783, 37.40785], [-121.9079, 37.40787], [-121.90815, 37.40772], [-121.90926, 37.40894], [-121.90956, 37.40879], [-121.90978, 37.40905], [-121.90992, 37.40936], [-121.91011, 37.40994]]]} | Open Access 1 | 14985 | Pinewood Park | 23694 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 9.896 | Pinewood Park | 1976 | Local Park 2 | 4 | |
9134 | 9134 | 9133 | {"type": "Polygon", "coordinates": [[[-121.85206, 37.22045], [-121.8521, 37.2206], [-121.85216, 37.22075], [-121.85214, 37.22081], [-121.8513, 37.22106], [-121.85106, 37.22121], [-121.8508, 37.22148], [-121.85074, 37.22148], [-121.85006, 37.22132], [-121.85011, 37.22032], [-121.85206, 37.22045]]]} | Open Access 1 | 16764 | Graystone Park | 19454 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 3.92 | Graystone Park | 1976 | 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]);