units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 1954
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_WEB
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1818 | 1818 | 1817 | {"type": "Polygon", "coordinates": [[[-121.8839, 37.2883], [-121.88362, 37.28834], [-121.88342, 37.28845], [-121.8832, 37.28805], [-121.88353, 37.28762], [-121.88367, 37.28739], [-121.8837, 37.28739], [-121.88371, 37.28755], [-121.88377, 37.2877], [-121.88391, 37.28787], [-121.88388, 37.28808], [-121.8839, 37.2883]]]} | Open Access 1 | 15657 | Roy Avenue Park | 24709 | 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 | 1.016 | Roy Avenue Park | 1954 | Local Park 2 | 4 | |
1869 | 1869 | 1868 | {"type": "Polygon", "coordinates": [[[-122.40706, 37.62384], [-122.40529, 37.62418], [-122.40408, 37.62412], [-122.40388, 37.62311], [-122.40617, 37.62255], [-122.40706, 37.62384]]]} | Open Access 1 | 14391 | Lions Park | 21323 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 8.503 | Lions Park | 1954 | Local Park 2 | 4 | |
3411 | 3411 | 3410 | {"type": "Polygon", "coordinates": [[[-122.13932, 37.47327], [-122.13881, 37.47328], [-122.13882, 37.47356], [-122.13872, 37.47357], [-122.1387, 37.47328], [-122.1376, 37.4733], [-122.13759, 37.47328], [-122.13724, 37.47329], [-122.13724, 37.4732], [-122.13759, 37.47318], [-122.13756, 37.47229], [-122.13721, 37.47229], [-122.1372, 37.47221], [-122.13756, 37.4722], [-122.13755, 37.47184], [-122.13798, 37.47188], [-122.13924, 37.47186], [-122.13927, 37.47191], [-122.13932, 37.47327]]]} | Open Access 1 | 24981 | Jack Farell Park | 20303 | 1091 | East Palo Alto, City of 637 | City 2 | City Agency 2 | http://www.ci.east-palo-alto.ca.us | City 2 | 1091 | East Palo Alto, City of 626 | City 2 | City Agency 2 | San Mateo 15 | 6.149 | Jack Farell Park | 1954 | Local Park 2 | 4 | |
8717 | 8717 | 8716 | {"type": "Polygon", "coordinates": [[[-121.95423, 37.35323], [-121.95394, 37.35323], [-121.95366, 37.35326], [-121.95353, 37.35304], [-121.95364, 37.35294], [-121.95358, 37.35256], [-121.95439, 37.35255], [-121.95447, 37.35257], [-121.95476, 37.35308], [-121.95477, 37.35316], [-121.95473, 37.35322], [-121.95465, 37.35326], [-121.95423, 37.35323]]]} | Open Access 1 | 14149 | Civic Center Park | 17364 | 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.735 | Civic Ctr. Park | 1954 | Local Park 2 | 4 | |
8801 | 8801 | 8800 | {"type": "Polygon", "coordinates": [[[-122.13702, 37.47521], [-122.1359, 37.47525], [-122.13584, 37.47404], [-122.13697, 37.47404], [-122.13702, 37.47521]]]} | Open Access 1 | 14323 | Jack Farell Park | 20303 | 1091 | East Palo Alto, City of 637 | City 2 | City Agency 2 | http://www.ci.east-palo-alto.ca.us | City 2 | 1091 | East Palo Alto, City of 626 | City 2 | City Agency 2 | San Mateo 15 | 3.249 | Jack Farell Park | 1954 | Local Park 2 | 4 | |
8802 | 8802 | 8801 | {"type": "Polygon", "coordinates": [[[-122.13273, 37.45969], [-122.132, 37.4597], [-122.1319, 37.45823], [-122.13267, 37.45821], [-122.13275, 37.45936], [-122.13273, 37.45969]]]} | Open Access 1 | 14325 | University Sqaure Park | 26689 | 1091 | East Palo Alto, City of 637 | City 2 | City Agency 2 | http://www.ci.east-palo-alto.ca.us | City 2 | 1091 | East Palo Alto, City of 626 | City 2 | City Agency 2 | San Mateo 15 | 2.762 | University Sqaure Park | 1954 | Local Park 2 | 4 | |
8803 | 8803 | 8802 | {"type": "Polygon", "coordinates": [[[-122.12711, 37.46435], [-122.12592, 37.46437], [-122.12569, 37.46356], [-122.12589, 37.46354], [-122.12569, 37.46261], [-122.12705, 37.46247], [-122.12711, 37.46435]]]} | Open Access 1 | 14327 | Martin Luther King Park | 21918 | 1091 | East Palo Alto, City of 637 | City 2 | City Agency 2 | http://www.ci.east-palo-alto.ca.us | City 2 | 1091 | East Palo Alto, City of 626 | City 2 | City Agency 2 | San Mateo 15 | 5.703 | Martin Luther King Park | 1954 | Local Park 2 | 4 | |
9331 | 9331 | 9330 | {"type": "Polygon", "coordinates": [[[-122.16632, 37.45965], [-122.16591, 37.45985], [-122.16583, 37.45981], [-122.1657, 37.45978], [-122.16499, 37.45985], [-122.1649, 37.45987], [-122.16476, 37.45983], [-122.16514, 37.45907], [-122.16626, 37.45942], [-122.16632, 37.45965]]]} | Open Access 1 | 15562 | Seminary Oaks Park | 25295 | 1202 | Menlo Park, City of 221 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | San Mateo 15 | 1.897 | Seminary Oaks Park | 1954 | 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]);