units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
18 rows where AGNCY_TYP = 2, MNG_AGENCY = 368 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
DES_TP 5
- Local Park 13
- Local Other or Unknown 2
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency · 18 ✖
MNG_AGENCY 1
- Sonoma, City of · 18 ✖
ACCESS_TYP 1
- Open Access 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1481 | 1481 | 1480 | {"type": "Polygon", "coordinates": [[[-122.46756, 38.28916], [-122.46746, 38.29018], [-122.46741, 38.29045], [-122.46743, 38.29049], [-122.4674, 38.2906], [-122.46684, 38.29058], [-122.46677, 38.29073], [-122.46652, 38.29072], [-122.46649, 38.29089], [-122.46596, 38.29083], [-122.4661, 38.2899], [-122.46622, 38.2899], [-122.46635, 38.28903], [-122.46756, 38.28916]]]} | Open Access 1 | 10169 | Eraldi Park | 18692 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 5.179 | Eraldi Park | 0 | Local Park 2 | 4 | |
3535 | 3535 | 3534 | {"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 | 28218 | Sonoma Garden Park | 25611 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 6.173 | Sonoma Garden Park | 0 | Local Park 2 | 4 | |
3811 | 3811 | 3810 | {"type": "Polygon", "coordinates": [[[-122.46979, 38.29855], [-122.46968, 38.29918], [-122.46947, 38.29916], [-122.46943, 38.29938], [-122.46936, 38.29938], [-122.46939, 38.29915], [-122.46885, 38.29909], [-122.46885, 38.29895], [-122.46881, 38.29885], [-122.46889, 38.29885], [-122.46895, 38.2985], [-122.46979, 38.29855]]]} | Open Access 1 | 10145 | Olsen Park | 23138 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 1.303 | Olsen Park | 0 | Local Park 2 | 4 | |
4512 | 4512 | 4511 | {"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 | 10157 | The Plaza | 26291 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 7.947 | The Plaza | 0 | Local Park 2 | 4 | |
7855 | 7855 | 7854 | {"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 | 10259 | Pinelli Park | 23689 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 0.466 | Pinelli Park | 0 | Local Park 2 | 4 | |
7902 | 7902 | 7901 | {"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 | 10182 | Hertenstein Park | 19880 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 0.882 | Hertenstein Park | 0 | Local Park 2 | 4 | |
7903 | 7903 | 7902 | {"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 | 10194 | Madera Park | 21653 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 3.699 | Madera Park | 0 | Local Park 2 | 4 | |
7904 | 7904 | 7903 | {"type": "MultiPolygon", "coordinates": [[[[-122.46512, 38.27988], [-122.4651, 38.27996], [-122.46449, 38.27991], [-122.46435, 38.28012], [-122.46401, 38.28075], [-122.4642, 38.28083], [-122.46441, 38.28083], [-122.46445, 38.28084], [-122.46439, 38.28094], [-122.46407, 38.28083], [-122.46367, 38.2815], [-122.46336, 38.28146], [-122.46331, 38.28144], [-122.4633, 38.2814], [-122.46342, 38.28096], [-122.46343, 38.2808], [-122.4634, 38.28064], [-122.46358, 38.28062], [-122.46366, 38.28059], [-122.4637, 38.28053], [-122.46372, 38.2804], [-122.46369, 38.28024], [-122.4637, 38.28008], [-122.46375, 38.27975], [-122.4633, 38.27971], [-122.46328, 38.27978], [-122.46099, 38.27956], [-122.46111, 38.2788], [-122.46147, 38.27877], [-122.46165, 38.27878], [-122.46169, 38.27884], [-122.46182, 38.27896], [-122.46265, 38.27904], [-122.46274, 38.27902], [-122.4628, 38.27897], [-122.46285, 38.27888], [-122.46288, 38.27873], [-122.46282, 38.27867], [-122.46313, 38.2787], [-122.46305, 38.27875], [-122.46304, 38.27883], [-122.46342, 38.27886], [-122.46337, 38.27921], [-122.46365, 38.27923], [-122.46363, 38.27936], [-122.46369, 38.27946], [-122.46376, 38.2795], [-122.46385, 38.27953], [-122.46403, 38.27955], [-122.464, 38.27977], [-122.46512, 38.27988]]], [[[-122.46555, 38.27992], [-122.46554, 38.28], [-122.46551, 38.27999], [-122.46552, 38.27992], [-122.46555, 38.27992]]]]} | Open Access 1 | 10206 | Carter Park | 16925 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 7.493 | Carter Park | 0 | Local Park 2 | 4 | |
7905 | 7905 | 7904 | {"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.45669, 38.27857], [-122.45662, 38.27854], [-122.45656, 38.27835], [-122.45648, 38.27822], [-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.27778], [-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.45727, 38.285], [-122.4572, 38.28499], [-122.45725, 38.28468], [-122.45772, 38.28472]]]]} | Open Access 1 | 10218 | Nathanson Creek Park | 22637 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 4.455 | Nathanson Creek Park | 0 | Local Park 2 | 4 | |
8546 | 8546 | 8545 | {"type": "Polygon", "coordinates": [[[-122.46693, 38.30034], [-122.46669, 38.30196], [-122.46421, 38.30171], [-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.30404], [-122.45984, 38.30399], [-122.4591, 38.30422], [-122.45883, 38.30433], [-122.45868, 38.30433], [-122.45853, 38.30415], [-122.45807, 38.30389], [-122.45796, 38.30393], [-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.45842, 38.29949], [-122.45782, 38.29943], [-122.45789, 38.299], [-122.46086, 38.29926], [-122.46084, 38.29943], [-122.46133, 38.29947], [-122.46127, 38.29987], [-122.46151, 38.2999], [-122.46144, 38.30037], [-122.46147, 38.30101], [-122.46205, 38.30101], [-122.46231, 38.30092], [-122.46241, 38.30032], [-122.46282, 38.29997], [-122.46316, 38.29964], [-122.46447, 38.30004], [-122.46447, 38.30009], [-122.46693, 38.30034]]]} | Open Access 1 | 13478 | Montini | 28211 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | http://www.sonomacity.org/default.aspx?PageId=580 | Sonoma 16 | 96.385 | Montini | None 715 | ||
11277 | 11277 | 11276 | {"type": "Polygon", "coordinates": [[[-122.45816, 38.29594], [-122.45793, 38.29742], [-122.45582, 38.29721], [-122.45611, 38.29535], [-122.45646, 38.29538], [-122.4565, 38.29537], [-122.45788, 38.2955], [-122.45781, 38.2959], [-122.45816, 38.29594]]]} | Open Access 1 | 23640 | Depot Park | 18101 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 9.326 | Depot Park | 0 | Local Park 2 | 4 | |
11498 | 11498 | 11497 | {"type": "Polygon", "coordinates": [[[-122.4605, 38.29716], [-122.4602, 38.29918], [-122.46023, 38.2992], [-122.45789, 38.299], [-122.45816, 38.29724], [-122.45865, 38.29728], [-122.45874, 38.2967], [-122.4605, 38.29716]]]} | Open Access 1 | 23639 | Dog Park | 18184 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 11.769 | Dog Park | 0 | Local Park 2 | 4 | |
11557 | 11557 | 11556 | {"type": "Polygon", "coordinates": [[[-122.44779, 38.2892], [-122.44774, 38.28951], [-122.44713, 38.28945], [-122.44719, 38.28909], [-122.44773, 38.28914], [-122.44777, 38.28916], [-122.44779, 38.2892]]]} | Open Access 1 | 23645 | Armstrong Park | 15597 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 0.539 | Armstrong Park | 0 | Local Park 2 | 4 | |
12469 | 12469 | 12468 | {"type": "Polygon", "coordinates": [[[-122.4529, 38.2874], [-122.4529, 38.28742], [-122.45252, 38.28738], [-122.45247, 38.28767], [-122.45244, 38.28767], [-122.45248, 38.28737], [-122.45147, 38.28727], [-122.45139, 38.28757], [-122.45136, 38.28757], [-122.45142, 38.28727], [-122.45114, 38.28724], [-122.45117, 38.28695], [-122.45122, 38.28695], [-122.45126, 38.28706], [-122.4513, 38.28711], [-122.45144, 38.2872], [-122.45159, 38.28701], [-122.45161, 38.28702], [-122.45148, 38.28722], [-122.45163, 38.28726], [-122.45175, 38.28726], [-122.4519, 38.28723], [-122.45207, 38.28711], [-122.4521, 38.28706], [-122.45215, 38.28692], [-122.45217, 38.28681], [-122.45247, 38.28684], [-122.45245, 38.28703], [-122.45245, 38.2871], [-122.45247, 38.28715], [-122.45254, 38.28725], [-122.45261, 38.2873], [-122.45281, 38.28713], [-122.45283, 38.28714], [-122.45264, 38.28733], [-122.45277, 38.28739], [-122.4529, 38.2874]]]} | Open Access 1 | 28213 | El Prado Common | 18531 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 0.857 | El Prado Common | None 1086 | |||
12470 | 12470 | 12469 | {"type": "Polygon", "coordinates": [[[-122.45612, 38.28936], [-122.45618, 38.28958], [-122.45611, 38.28984], [-122.45603, 38.28983], [-122.45611, 38.28936], [-122.45612, 38.28936]]]} | Open Access 1 | 28214 | Grinstead Park | 19520 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 0.088 | Grinstead Park | 0 | Local Park 2 | 4 | |
12471 | 12471 | 12470 | {"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 | 28216 | Sonoma Valley Oaks | 25618 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 1.189 | Sonoma Valley Oaks | None 1087 | |||
13762 | 13762 | 13761 | {"type": "Polygon", "coordinates": [[[-122.44326, 38.2855], [-122.44321, 38.28582], [-122.4422, 38.28573], [-122.44253, 38.28549], [-122.44264, 38.28551], [-122.44274, 38.2855], [-122.44281, 38.28545], [-122.44326, 38.2855]]]} | Open Access 1 | 36282 | Sonoma holding 2 | 25613 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 0.635 | Sonoma holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13805 | 13805 | 13804 | {"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 | 36376 | Sonoma holding 1 | 25612 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 1.524 | Sonoma holding 1 | 0 | Local Other or Unknown 14 | 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]);