units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
83 rows where MNG_AGENCY = 29 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP 6
- Local Park 56
- Local Recreation Area 3
- Local Conservation Area 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
AGNCY_LEV 2 ✖
- City 62
- Special District 1
MNG_AG_TYP 1
- City Agency 63
MNG_AGENCY 1
- Santa Rosa, City of · 63 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1302 | 1302 | 1301 | {"type": "Polygon", "coordinates": [[[-122.7616, 38.42519], [-122.7609, 38.42525], [-122.76082, 38.42464], [-122.76085, 38.4246], [-122.76086, 38.42454], [-122.76083, 38.42446], [-122.7608, 38.42413], [-122.76146, 38.42409], [-122.7616, 38.42519]]]} | Open Access 1 | 10458 | Village Green Park | 27116 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 1.837 | Village Green Park | 0 | Local Park 2 | 4 | |
3787 | 3787 | 3786 | {"type": "Polygon", "coordinates": [[[-122.74779, 38.41384], [-122.74776, 38.41392], [-122.74768, 38.41398], [-122.74755, 38.41404], [-122.74741, 38.41408], [-122.74658, 38.41414], [-122.74636, 38.41413], [-122.74616, 38.41406], [-122.74611, 38.41399], [-122.74614, 38.41383], [-122.7461, 38.41346], [-122.74617, 38.41339], [-122.74759, 38.41329], [-122.74767, 38.41334], [-122.74771, 38.41366], [-122.74779, 38.41384]]]} | Open Access 1 | 10482 | Pear Blossom Park | 23546 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 2.869 | Pear Blossom Park | 0 | Local Park 2 | 4 | |
1497 | 1497 | 1496 | {"type": "Polygon", "coordinates": [[[-122.73927, 38.40898], [-122.73867, 38.40899], [-122.738, 38.40906], [-122.73765, 38.40913], [-122.73678, 38.40934], [-122.73673, 38.40907], [-122.73673, 38.40862], [-122.73676, 38.40856], [-122.73679, 38.40856], [-122.73922, 38.40855], [-122.73926, 38.40859], [-122.73927, 38.40898]]]} | Open Access 1 | 10498 | Bellevue Ranch | 15988 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 3.292 | Bellevue Ranch | 0 | Local Park 2 | 4 | |
1499 | 1499 | 1498 | {"type": "Polygon", "coordinates": [[[-122.71082, 38.40228], [-122.71082, 38.40279], [-122.7105, 38.40279], [-122.7105, 38.40224], [-122.71077, 38.40224], [-122.71082, 38.40228]]]} | Open Access 1 | 10510 | Red Hawk Park | 24222 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 0.419 | Red Hawk Park | 0 | Local Park 2 | 4 | |
4937 | 4937 | 4936 | {"type": "Polygon", "coordinates": [[[-122.70759, 38.41914], [-122.70759, 38.41914], [-122.70755, 38.42031], [-122.70739, 38.42027], [-122.70713, 38.42014], [-122.70689, 38.41994], [-122.70666, 38.41953], [-122.70667, 38.41945], [-122.7068, 38.41934], [-122.70705, 38.41921], [-122.70739, 38.41913], [-122.70759, 38.41914]]]} | Open Access 1 | 10522 | Colgan Creek Park | 17495 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 1.808 | Colgan Creek Park | 0 | Local Park 2 | 4 | |
1502 | 1502 | 1501 | {"type": "Polygon", "coordinates": [[[-122.70489, 38.42844], [-122.70386, 38.4288], [-122.7029, 38.42713], [-122.70284, 38.42692], [-122.70304, 38.4268], [-122.70316, 38.42678], [-122.7032, 38.42675], [-122.70329, 38.42672], [-122.70344, 38.42671], [-122.70354, 38.42665], [-122.70377, 38.42657], [-122.70384, 38.42664], [-122.70384, 38.42669], [-122.70397, 38.42686], [-122.70489, 38.42844]]]} | Open Access 1 | 10533 | Martin Luther King Park | 21919 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 5.524 | Martin Luther King Park | 0 | Local Park 2 | 4 | |
3791 | 3791 | 3790 | {"type": "Polygon", "coordinates": [[[-122.71576, 38.42959], [-122.71543, 38.42962], [-122.71528, 38.42723], [-122.71532, 38.42722], [-122.71576, 38.42959]]]} | Open Access 1 | 10545 | South Davis Park | 25647 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 1.083 | South Davis Park | 0 | Local Park 2 | 4 | |
3830 | 3830 | 3829 | {"type": "Polygon", "coordinates": [[[-122.71934, 38.43449], [-122.71922, 38.4345], [-122.71889, 38.43457], [-122.71873, 38.43463], [-122.71837, 38.43469], [-122.71826, 38.43438], [-122.7183, 38.43434], [-122.71915, 38.43414], [-122.7192, 38.43418], [-122.71929, 38.43442], [-122.71934, 38.43449]]]} | Open Access 1 | 10556 | Olive Park | 23127 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 0.851 | Olive Park | 0 | Local Park 2 | 4 | |
4895 | 4895 | 4894 | {"type": "Polygon", "coordinates": [[[-122.71147, 38.43682], [-122.71061, 38.43738], [-122.70939, 38.43825], [-122.7091, 38.43839], [-122.70903, 38.43829], [-122.70954, 38.43791], [-122.70968, 38.43784], [-122.70976, 38.43784], [-122.70988, 38.43779], [-122.71003, 38.43765], [-122.70999, 38.43739], [-122.71051, 38.43731], [-122.71145, 38.43674], [-122.71147, 38.43682]]]} | Open Access 1 | 10567 | Sonoma Avenue Park | 25606 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 1.008 | Sonoma Avenue Park | 0 | Local Park 2 | 4 | |
1491 | 1491 | 1490 | {"type": "Polygon", "coordinates": [[[-122.7096, 38.43788], [-122.70954, 38.43791], [-122.70929, 38.4381], [-122.70925, 38.43795], [-122.70895, 38.43799], [-122.70876, 38.43769], [-122.70873, 38.43762], [-122.70874, 38.4376], [-122.7088, 38.43759], [-122.70951, 38.4375], [-122.7096, 38.43788]]]} | Open Access 1 | 10579 | Rae Park | 24071 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 0.782 | Rae Park | 0 | Local Park 2 | 4 | |
1492 | 1492 | 1491 | {"type": "Polygon", "coordinates": [[[-122.72142, 38.43789], [-122.72122, 38.43798], [-122.72083, 38.43747], [-122.72102, 38.43739], [-122.72142, 38.43789]]]} | Open Access 1 | 10590 | Railroad Depot Park | 32921 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | https://srcity.org/Facilities/Facility/Details/Railroad-Depot-Park-97 | Sonoma 16 | 0.326 | Railroad Depot Park | 0 | Local Park 2 | 4 |
1493 | 1493 | 1492 | {"type": "Polygon", "coordinates": [[[-122.72736, 38.43806], [-122.72694, 38.43821], [-122.72682, 38.43805], [-122.7265, 38.43817], [-122.72622, 38.43778], [-122.72694, 38.43746], [-122.72736, 38.43806]]]} | Open Access 1 | 10601 | DeMeo Park | 18080 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 1.14 | DeMeo Park | 0 | Local Park 2 | 4 | |
1495 | 1495 | 1494 | {"type": "Polygon", "coordinates": [[[-122.72547, 38.44105], [-122.72507, 38.44108], [-122.72464, 38.44045], [-122.72539, 38.44038], [-122.72547, 38.44105]]]} | Open Access 1 | 10616 | DeTurk Park | 18123 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 0.923 | DeTurk Park | 0 | Local Park 2 | 4 | |
1504 | 1504 | 1503 | {"type": "Polygon", "coordinates": [[[-122.74197, 38.43694], [-122.74187, 38.43693], [-122.74179, 38.43719], [-122.74176, 38.43718], [-122.74183, 38.43691], [-122.74053, 38.43668], [-122.74052, 38.43665], [-122.74049, 38.43665], [-122.74048, 38.43651], [-122.74046, 38.43647], [-122.74041, 38.43638], [-122.74036, 38.43634], [-122.74029, 38.43618], [-122.74135, 38.43611], [-122.74131, 38.43586], [-122.74135, 38.43587], [-122.7414, 38.43611], [-122.74185, 38.43607], [-122.74197, 38.43694]]]} | Open Access 1 | 10628 | Westgate Park | 32920 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 2.451 | Westgate Park | 0 | Local Park 2 | 4 | |
1505 | 1505 | 1504 | {"type": "Polygon", "coordinates": [[[-122.73719, 38.44047], [-122.73597, 38.44051], [-122.73603, 38.44154], [-122.7343, 38.4416], [-122.7342, 38.43999], [-122.73707, 38.43986], [-122.73708, 38.43996], [-122.73716, 38.43995], [-122.73719, 38.44047]]]} | Open Access 1 | 10640 | Jacobs Park | 20329 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 8.507 | Jacobs Park | 0 | Local Park 2 | 4 | |
7925 | 7925 | 7924 | {"type": "Polygon", "coordinates": [[[-122.74343, 38.44794], [-122.74343, 38.44831], [-122.74298, 38.44832], [-122.743, 38.44868], [-122.74102, 38.44879], [-122.74092, 38.44747], [-122.74293, 38.44734], [-122.74299, 38.44795], [-122.74343, 38.44794]]]} | Open Access 1 | 10652 | Jennings Park | 20390 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 6.805 | Jennings Park | 0 | Local Park 2 | 4 | |
7926 | 7926 | 7925 | {"type": "Polygon", "coordinates": [[[-122.73678, 38.44783], [-122.73649, 38.44785], [-122.73648, 38.44771], [-122.73672, 38.44771], [-122.73677, 38.44775], [-122.73678, 38.44783]]]} | Open Access 1 | 10664 | Haydn Village Park | 19753 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 0.09 | Haydn Village Park | 0 | Local Park 2 | 4 | |
1506 | 1506 | 1505 | {"type": "Polygon", "coordinates": [[[-122.7493, 38.45103], [-122.74879, 38.45105], [-122.74793, 38.45105], [-122.74799, 38.45086], [-122.74798, 38.45076], [-122.74856, 38.45078], [-122.74855, 38.45051], [-122.74885, 38.45051], [-122.74889, 38.45078], [-122.74929, 38.45078], [-122.7493, 38.45103]]]} | Open Access 1 | 10676 | Brendon Park | 16349 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 1.071 | Brendon Park | 0 | Local Park 2 | 4 | |
1507 | 1507 | 1506 | {"type": "Polygon", "coordinates": [[[-122.76048, 38.46948], [-122.76047, 38.46866], [-122.76257, 38.46867], [-122.76262, 38.4687], [-122.76263, 38.46944], [-122.76261, 38.46948], [-122.76218, 38.46953], [-122.76187, 38.46955], [-122.76156, 38.46954], [-122.76094, 38.46948], [-122.76048, 38.46948]]]} | Open Access 1 | 10687 | Pioneer Park | 23734 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 4.352 | Pioneer Park | 0 | Local Park 2 | 4 | |
7922 | 7922 | 7921 | {"type": "Polygon", "coordinates": [[[-122.74875, 38.47854], [-122.74847, 38.4785], [-122.74774, 38.47848], [-122.74764, 38.47838], [-122.74756, 38.47836], [-122.74744, 38.47839], [-122.74717, 38.47833], [-122.74716, 38.47697], [-122.74722, 38.47692], [-122.7478, 38.47691], [-122.74855, 38.47695], [-122.74864, 38.47728], [-122.74879, 38.47755], [-122.74887, 38.47785], [-122.74887, 38.47811], [-122.74883, 38.47835], [-122.74875, 38.47854]]]} | Open Access 1 | 10695 | Coffey Park | 17476 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 5.869 | Coffey Park | 0 | 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]);