superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where MNG_AG_TYP = 2 and YR_EST = 1954
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2976 | 2976 | 2975 | {"type": "Polygon", "coordinates": [[[-121.95477, 37.35316], [-121.95473, 37.35322], [-121.95465, 37.35325], [-121.95422, 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]]]} | Open Access 1 | Civic Center Park | 17364 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.735 | Civic Ctr. Park | 1954 | |
5438 | 5438 | 5437 | {"type": "MultiPolygon", "coordinates": [[[[-122.13702, 37.47521], [-122.1359, 37.47525], [-122.13584, 37.47404], [-122.13697, 37.47404], [-122.13702, 37.47521]]], [[[-122.13932, 37.47327], [-122.13882, 37.47328], [-122.13882, 37.47356], [-122.13872, 37.47357], [-122.13869, 37.47328], [-122.1376, 37.4733], [-122.13758, 37.47328], [-122.13724, 37.47329], [-122.13724, 37.4732], [-122.13759, 37.47318], [-122.13756, 37.4723], [-122.13721, 37.47229], [-122.1372, 37.47221], [-122.13755, 37.47219], [-122.13755, 37.47184], [-122.13798, 37.47188], [-122.13924, 37.47186], [-122.13927, 37.47191], [-122.13932, 37.47327]]]]} | Open Access 1 | Jack Farell Park | 20303 | 1091 | East Palo Alto, City of 626 | City 2 | City Agency 2 | http://www.ci.east-palo-alto.ca.us | City 2 | 9.413 | Jack Farell Park | 1954 | |
6257 | 6257 | 6256 | {"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 | Lions Park | 21323 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 8.502 | Lions Park | 1954 | |
6730 | 6730 | 6729 | {"type": "Polygon", "coordinates": [[[-122.12711, 37.46435], [-122.12592, 37.46437], [-122.12569, 37.46356], [-122.12589, 37.46353], [-122.12569, 37.46261], [-122.12705, 37.46247], [-122.12711, 37.46435]]]} | Open Access 1 | Martin Luther King Park | 21918 | 1091 | East Palo Alto, City of 626 | City 2 | City Agency 2 | http://www.ci.east-palo-alto.ca.us | City 2 | 5.705 | Martin Luther King Park | 1954 | |
9036 | 9036 | 9035 | {"type": "Polygon", "coordinates": [[[-121.88391, 37.28787], [-121.88388, 37.28808], [-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]]]} | Open Access 1 | Roy Avenue Park | 24709 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.016 | Roy Avenue Park | 1954 | |
9122 | 9122 | 9121 | {"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 | University Sqaure Park | 26689 | 1091 | East Palo Alto, City of 626 | City 2 | City Agency 2 | http://www.ci.east-palo-alto.ca.us | City 2 | 2.762 | University Sqaure Park | 1954 | |
9495 | 9495 | 9494 | {"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 | Seminary Oaks Park | 25295 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1.897 | Seminary Oaks Park | 1954 |
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]);