superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
18 rows where MNG_AGENCY = 368
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5084 | 5084 | 5083 | {"type": "MultiPolygon", "coordinates": [[[[-122.46731, 38.28258], [-122.46729, 38.28272], [-122.46688, 38.28263], [-122.4668, 38.28253], [-122.46731, 38.28258]]], [[[-122.46815, 38.28261], [-122.4681, 38.28322], [-122.46768, 38.28297], [-122.46743, 38.2829], [-122.46745, 38.28256], [-122.46815, 38.28261]]]]} | Open Access 1 | Hertenstein Park | 19880 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 0.882 | Hertenstein Park | ||
6515 | 6515 | 6514 | {"type": "Polygon", "coordinates": [[[-122.46604, 38.27643], [-122.4658, 38.27801], [-122.4656, 38.278], [-122.46521, 38.28026], [-122.46506, 38.28023], [-122.46549, 38.27776], [-122.46543, 38.27757], [-122.4653, 38.27734], [-122.46509, 38.27716], [-122.465, 38.27703], [-122.46493, 38.27683], [-122.46496, 38.27635], [-122.46604, 38.27643]]]} | Open Access 1 | Madera Park | 21653 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 3.7 | Madera Park | ||
7307 | 7307 | 7306 | {"type": "MultiPolygon", "coordinates": [[[[-122.45661, 38.28445], [-122.45568, 38.28434], [-122.45583, 38.28349], [-122.45626, 38.28353], [-122.45613, 38.28365], [-122.45606, 38.28377], [-122.45611, 38.28395], [-122.45638, 38.28416], [-122.45656, 38.28427], [-122.45661, 38.28445]]], [[[-122.45749, 38.27837], [-122.45745, 38.27859], [-122.45693, 38.27902], [-122.45674, 38.279], [-122.4568, 38.27859], [-122.45662, 38.27854], [-122.45656, 38.27835], [-122.45648, 38.27823], [-122.45624, 38.27799], [-122.45615, 38.27785], [-122.45609, 38.27771], [-122.45596, 38.27661], [-122.45618, 38.27663], [-122.45621, 38.27694], [-122.45632, 38.27727], [-122.45629, 38.27777], [-122.45639, 38.27779], [-122.45652, 38.27791], [-122.45675, 38.27797], [-122.45694, 38.27787], [-122.45713, 38.27789], [-122.45727, 38.27822], [-122.45749, 38.27837]]], [[[-122.45772, 38.28472], [-122.45761, 38.28545], [-122.4572, 38.2854], [-122.45726, 38.28501], [-122.4572, 38.28499], [-122.45725, 38.28468], [-122.45772, 38.28472]]]]} | Open Access 1 | Nathanson Creek Park | 22637 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 4.458 | Nathanson Creek Park | ||
7685 | 7685 | 7684 | {"type": "Polygon", "coordinates": [[[-122.46979, 38.29855], [-122.46968, 38.29918], [-122.46947, 38.29916], [-122.46943, 38.29938], [-122.46936, 38.29938], [-122.46938, 38.29915], [-122.46885, 38.29909], [-122.46885, 38.29895], [-122.46881, 38.29885], [-122.46889, 38.29884], [-122.46895, 38.2985], [-122.46979, 38.29855]]]} | Open Access 1 | Olsen Park | 23138 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1.308 | Olsen Park | ||
8155 | 8155 | 8154 | {"type": "Polygon", "coordinates": [[[-122.45045, 38.28734], [-122.45043, 38.28747], [-122.45007, 38.28744], [-122.44989, 38.28741], [-122.44968, 38.28734], [-122.44972, 38.28703], [-122.45015, 38.28707], [-122.45011, 38.28731], [-122.45045, 38.28734]]]} | Open Access 1 | Pinelli Park | 23689 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 0.468 | Pinelli Park | ||
8319 | 8319 | 8318 | {"type": "Polygon", "coordinates": [[[-122.45162, 38.27731], [-122.45153, 38.27787], [-122.45149, 38.27788], [-122.45077, 38.27782], [-122.45073, 38.27779], [-122.45082, 38.27722], [-122.45086, 38.2772], [-122.45159, 38.27727], [-122.45162, 38.27731]]]} | Open Access 1 | Sonoma Valley Oaks | 25618 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1.188 | Sonoma Valley Oaks | ||
9771 | 9771 | 9770 | {"type": "Polygon", "coordinates": [[[-122.44112, 38.28032], [-122.44096, 38.28136], [-122.43854, 38.28113], [-122.43869, 38.28008], [-122.44112, 38.28032]]]} | Open Access 1 | Sonoma Garden Park | 25611 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 6.173 | Sonoma Garden Park | ||
9772 | 9772 | 9771 | {"type": "Polygon", "coordinates": [[[-122.44718, 38.28907], [-122.447, 38.29026], [-122.44655, 38.29023], [-122.44662, 38.28979], [-122.44643, 38.28956], [-122.44649, 38.28952], [-122.44655, 38.28942], [-122.4466, 38.2891], [-122.44671, 38.28903], [-122.44718, 38.28907]]]} | Open Access 1 | Sonoma holding 1 | 25612 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1.525 | Sonoma holding 1 | ||
9773 | 9773 | 9772 | {"type": "Polygon", "coordinates": [[[-122.44326, 38.2855], [-122.44321, 38.28582], [-122.4422, 38.28573], [-122.44253, 38.28549], [-122.44263, 38.28551], [-122.44274, 38.2855], [-122.44281, 38.28545], [-122.44326, 38.2855]]]} | Open Access 1 | Sonoma holding 2 | 25613 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 0.635 | Sonoma holding 2 | ||
10317 | 10317 | 10316 | {"type": "Polygon", "coordinates": [[[-122.45886, 38.29215], [-122.45854, 38.29374], [-122.4565, 38.29353], [-122.45686, 38.29192], [-122.45886, 38.29215]]]} | Open Access 1 | The Plaza | 26291 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 7.946 | The Plaza | ||
11655 | 11655 | 11654 | {"type": "Polygon", "coordinates": [[[-122.46693, 38.30034], [-122.46669, 38.30196], [-122.46421, 38.30172], [-122.46377, 38.30465], [-122.46378, 38.30466], [-122.46397, 38.30468], [-122.46386, 38.30546], [-122.46331, 38.30541], [-122.46315, 38.30629], [-122.46242, 38.30611], [-122.46207, 38.30612], [-122.46094, 38.30568], [-122.46075, 38.30539], [-122.46055, 38.30524], [-122.46058, 38.30479], [-122.46033, 38.30464], [-122.45995, 38.30502], [-122.45974, 38.30491], [-122.45992, 38.30405], [-122.45985, 38.304], [-122.4591, 38.30422], [-122.45883, 38.30433], [-122.45868, 38.30433], [-122.45853, 38.30415], [-122.45807, 38.3039], [-122.45796, 38.30394], [-122.45788, 38.30405], [-122.45737, 38.30412], [-122.45704, 38.30414], [-122.45736, 38.30252], [-122.45778, 38.2997], [-122.45839, 38.29975], [-122.45841, 38.29949], [-122.45782, 38.29943], [-122.45789, 38.299], [-122.46086, 38.29926], [-122.46085, 38.29943], [-122.46133, 38.29947], [-122.46128, 38.29986], [-122.46151, 38.2999], [-122.46144, 38.30037], [-122.46148, 38.30101], [-122.46205, 38.30101], [-122.4623, 38.30092], [-122.46241, 38.30032], [-122.46282, 38.29997], [-122.46316, 38.29964], [-122.46447, 38.30004], [-122.46448, 38.30009], [-122.46693, 38.30034]]]} | Open Access 1 | Montini | http://www.sonomacity.org/default.aspx?PageId=580 | 28211 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 96.438 | Montini | |
14251 | 14251 | 14250 | {"type": "Polygon", "coordinates": [[[-122.45618, 38.28958], [-122.45611, 38.28984], [-122.45603, 38.28983], [-122.45611, 38.28936], [-122.45612, 38.28936], [-122.45618, 38.28958]]]} | Open Access 1 | Grinstead Park | 19520 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 0.088 | Grinstead Park |
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]);