units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
83 rows where MNG_AGENCY = 29 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
DES_TP 14
- Local Park 68
- Local Recreation Area 3
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 83
MNG_AGENCY 1
- Santa Rosa, City of · 83 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14487 | 14487 | 14486 | {"type": "Polygon", "coordinates": [[[-122.71421, 38.43614], [-122.71396, 38.4362], [-122.71382, 38.43581], [-122.71408, 38.43575], [-122.71421, 38.43614]]]} | Open Access 1 | 48271 | Church of One Tree | 32825 | 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/633/Church-of-One-Tree | Sonoma 16 | 0.253 | Church of One Tree | None 1234 | ||
14486 | 14486 | 14485 | {"type": "Polygon", "coordinates": [[[-122.71198, 38.44182], [-122.71187, 38.44186], [-122.7117, 38.44163], [-122.71179, 38.44159], [-122.71198, 38.44182]]]} | Open Access 1 | 48270 | Jeju Way | 32823 | 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.075 | Jeju Way | None 1233 | |||
14485 | 14485 | 14484 | {"type": "Polygon", "coordinates": [[[-122.69406, 38.42745], [-122.69385, 38.42747], [-122.69367, 38.42746], [-122.69322, 38.42733], [-122.69295, 38.42728], [-122.69276, 38.42728], [-122.69252, 38.42729], [-122.6925, 38.42728], [-122.69245, 38.42715], [-122.69226, 38.4268], [-122.6925, 38.4267], [-122.69262, 38.42662], [-122.69274, 38.42651], [-122.6928, 38.42637], [-122.69306, 38.42644], [-122.69312, 38.42649], [-122.69314, 38.42658], [-122.69322, 38.42669], [-122.69329, 38.42675], [-122.69343, 38.42681], [-122.69351, 38.42687], [-122.69368, 38.42704], [-122.69378, 38.42716], [-122.69384, 38.42728], [-122.694, 38.42736], [-122.69406, 38.42745]]]} | Open Access 1 | 48269 | Dauenhauer Park | 32822 | 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/Dauenhauer-Park-59 | Sonoma 16 | 2.291 | Dauenhauer Park | 0 | Local Park 2 | 4 |
14159 | 14159 | 14158 | {"type": "Polygon", "coordinates": [[[-122.75048, 38.43421], [-122.74811, 38.43393], [-122.74801, 38.43312], [-122.75043, 38.43316], [-122.75037, 38.43323], [-122.75048, 38.43421]]]} | Restricted Access 2 | 44115 | J.X. Wilson Park | 31385 | 2307 | Wright Elementary School District 1089 | Special District 4 | School District 14 | http://www.wrightesd.org/site/default.aspx?PageID=1 | Special District 4 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 5.235 | J.X. Wilson Park | 0 | Local Park 2 | 4 | |
12756 | 12756 | 12755 | {"type": "Polygon", "coordinates": [[[-122.71297, 38.43721], [-122.7128, 38.43723], [-122.71289, 38.43736], [-122.71246, 38.4374], [-122.71245, 38.43726], [-122.71248, 38.43725], [-122.71247, 38.43715], [-122.71295, 38.43713], [-122.71297, 38.43721]]]} | Open Access 1 | 29787 | Prince Memorial Greenway | 24005 | 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.243 | Prince Memorial Greenway | 0 | Local Recreation Area 3 | 4 | |
12755 | 12755 | 12754 | {"type": "Polygon", "coordinates": [[[-122.71212, 38.43656], [-122.7117, 38.43671], [-122.71147, 38.43682], [-122.71142, 38.43649], [-122.71151, 38.43656], [-122.71162, 38.43657], [-122.71167, 38.43655], [-122.71171, 38.43652], [-122.71173, 38.43645], [-122.71168, 38.43638], [-122.71161, 38.43636], [-122.71132, 38.43638], [-122.71122, 38.43594], [-122.71127, 38.43592], [-122.7112, 38.43553], [-122.71192, 38.43544], [-122.7121, 38.43627], [-122.71212, 38.43656]]]} | Open Access 1 | 29786 | Burbank Home & Gardens | 16508 | 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.036 | Burbank Home & Gardens | 0 | Local Park 2 | 4 | |
12738 | 12738 | 12737 | {"type": "Polygon", "coordinates": [[[-122.71295, 38.43713], [-122.71249, 38.43715], [-122.71244, 38.43683], [-122.71245, 38.43674], [-122.71249, 38.43672], [-122.71284, 38.43664], [-122.71295, 38.43713]]]} | Open Access 1 | 29788 | Prince Gateway Park | 24004 | 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.483 | Prince Gateway Park | 0 | Local Park 2 | 4 | |
12079 | 12079 | 12078 | {"type": "Polygon", "coordinates": [[[-122.71434, 38.4402], [-122.71349, 38.44058], [-122.71304, 38.43997], [-122.71388, 38.43959], [-122.71434, 38.4402]]]} | Open Access 1 | 24851 | Old Courthouse Square | 32918 | 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.67 | Old Courthouse Square | 0 | Local Park 2 | 4 | |
11555 | 11555 | 11554 | {"type": "Polygon", "coordinates": [[[-122.66792, 38.46122], [-122.66782, 38.46129], [-122.66773, 38.46132], [-122.66731, 38.46157], [-122.66726, 38.46163], [-122.66714, 38.4613], [-122.66776, 38.46098], [-122.66792, 38.46122]]]} | Open Access 1 | 23641 | Trailhead Park | 26509 | 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.533 | Trailhead Park | 0 | Local Park 2 | 4 | |
11383 | 11383 | 11382 | {"type": "Polygon", "coordinates": [[[-122.74784, 38.42357], [-122.74779, 38.42358], [-122.74773, 38.42348], [-122.74765, 38.42339], [-122.74745, 38.42324], [-122.74732, 38.42319], [-122.7472, 38.42314], [-122.74692, 38.42311], [-122.74678, 38.42311], [-122.74658, 38.42315], [-122.74658, 38.42303], [-122.74772, 38.42294], [-122.74777, 38.42298], [-122.74784, 38.42357]]]} | Open Access 1 | 28192 | Cook Park | 17617 | 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.672 | Cook Park | 0 | Local Park 2 | 4 | |
10358 | 10358 | 10357 | {"type": "Polygon", "coordinates": [[[-122.65695, 38.47237], [-122.65661, 38.47241], [-122.65663, 38.4726], [-122.65583, 38.47267], [-122.65577, 38.47231], [-122.65546, 38.47228], [-122.65536, 38.47187], [-122.65566, 38.47179], [-122.65568, 38.47108], [-122.6564, 38.47113], [-122.65656, 38.47214], [-122.65693, 38.47223], [-122.65695, 38.47237]]]} | Open Access 1 | 18289 | Oak Lake Green Park | 22985 | 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.464 | Oak Lake Green Park | 0 | Local Park 2 | 4 | |
10343 | 10343 | 10342 | {"type": "Polygon", "coordinates": [[[-122.66467, 38.42516], [-122.66241, 38.42639], [-122.66227, 38.4263], [-122.66226, 38.42719], [-122.65949, 38.42718], [-122.65908, 38.42721], [-122.65845, 38.42668], [-122.65832, 38.42654], [-122.65644, 38.4244], [-122.65601, 38.42344], [-122.65578, 38.42204], [-122.65565, 38.42202], [-122.65546, 38.42204], [-122.65549, 38.4217], [-122.65548, 38.42103], [-122.65551, 38.41987], [-122.65565, 38.41987], [-122.65588, 38.4191], [-122.65722, 38.41788], [-122.65756, 38.41741], [-122.6573, 38.4169], [-122.65799, 38.41691], [-122.6584, 38.41785], [-122.65968, 38.41786], [-122.65969, 38.41989], [-122.66115, 38.4199], [-122.66231, 38.41954], [-122.66239, 38.41954], [-122.66292, 38.41936], [-122.66368, 38.41889], [-122.66412, 38.4193], [-122.6643, 38.41953], [-122.66441, 38.4197], [-122.66452, 38.41991], [-122.66463, 38.42017], [-122.66468, 38.42039], [-122.66472, 38.42062], [-122.66473, 38.42089], [-122.66471, 38.42112], [-122.6646, 38.42152], [-122.66438, 38.42201], [-122.66428, 38.42228], [-122.66368, 38.42219], [-122.66363, 38.42242], [-122.6636, 38.42265], [-122.66358, 38.42288], [-122.6636, 38.42317], [-122.66364, 38.42345], [-122.66372, 38.42373], [-122.66392, 38.42421], [-122.66406, 38.42445], [-122.66427, 38.42473], [-122.66467, 38.42516]]]} | Restricted Access 2 | 29799 | Bennett Valley Municipal Golf Course | 33093 | 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 | 150.922 | Bennett Valley Municipal GC | 0 | Local Recreation Area 3 | 4 | |
9438 | 9438 | 9437 | {"type": "Polygon", "coordinates": [[[-122.69985, 38.43896], [-122.69973, 38.43922], [-122.69957, 38.43929], [-122.69935, 38.43966], [-122.69914, 38.43967], [-122.69902, 38.43988], [-122.69885, 38.43999], [-122.69873, 38.43998], [-122.69789, 38.44012], [-122.69763, 38.44002], [-122.69723, 38.44004], [-122.69707, 38.44015], [-122.69663, 38.44035], [-122.69639, 38.44033], [-122.69625, 38.44048], [-122.69587, 38.44045], [-122.69574, 38.44049], [-122.69535, 38.44019], [-122.69525, 38.44048], [-122.69476, 38.44073], [-122.69456, 38.44078], [-122.6943, 38.44094], [-122.69388, 38.44108], [-122.69413, 38.44091], [-122.69326, 38.44], [-122.69282, 38.43949], [-122.69287, 38.43943], [-122.69297, 38.43927], [-122.69313, 38.43917], [-122.69334, 38.43912], [-122.69332, 38.43909], [-122.69351, 38.43888], [-122.69374, 38.43866], [-122.69372, 38.43861], [-122.6941, 38.43834], [-122.69447, 38.43846], [-122.69494, 38.43873], [-122.69546, 38.43892], [-122.69586, 38.43913], [-122.69611, 38.43929], [-122.6965, 38.43937], [-122.69668, 38.43929], [-122.69683, 38.4391], [-122.6971, 38.43881], [-122.69764, 38.43904], [-122.69809, 38.43902], [-122.69859, 38.43876], [-122.69924, 38.43896], [-122.69985, 38.43896]]]} | Open Access 1 | 15780 | Doyle Park | 18260 | 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 | 21.595 | Doyle Park | 0 | Local Park 2 | 4 | |
7944 | 7944 | 7943 | {"type": "Polygon", "coordinates": [[[-122.66325, 38.43481], [-122.66313, 38.43483], [-122.66294, 38.43482], [-122.6628, 38.43441], [-122.66269, 38.43428], [-122.66239, 38.43407], [-122.66209, 38.43431], [-122.66145, 38.43385], [-122.66126, 38.43385], [-122.66119, 38.4338], [-122.66084, 38.43381], [-122.66107, 38.4331], [-122.66125, 38.43277], [-122.66103, 38.43254], [-122.66094, 38.43234], [-122.66074, 38.43231], [-122.66046, 38.43221], [-122.66054, 38.43203], [-122.66093, 38.43212], [-122.66114, 38.4322], [-122.66121, 38.43233], [-122.66144, 38.43253], [-122.66168, 38.4325], [-122.66175, 38.43255], [-122.66164, 38.43256], [-122.66163, 38.43258], [-122.66183, 38.43275], [-122.66187, 38.43282], [-122.66187, 38.43315], [-122.66189, 38.43321], [-122.66195, 38.43331], [-122.66209, 38.43341], [-122.6624, 38.43352], [-122.66254, 38.43363], [-122.66264, 38.43378], [-122.66295, 38.43402], [-122.66313, 38.43412], [-122.66315, 38.43419], [-122.6632, 38.43424], [-122.66317, 38.43453], [-122.66325, 38.43481]]]} | Open Access 1 | 10790 | Strawberry Park | 25916 | 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.361 | Strawberry Park | 0 | Local Park 2 | 4 | |
7941 | 7941 | 7940 | {"type": "Polygon", "coordinates": [[[-122.67197, 38.43672], [-122.67163, 38.43671], [-122.67165, 38.43646], [-122.67173, 38.43598], [-122.67152, 38.43563], [-122.67188, 38.43551], [-122.67205, 38.4358], [-122.67208, 38.43593], [-122.67208, 38.43604], [-122.67204, 38.43622], [-122.67197, 38.43672]]]} | Open Access 1 | 10783 | Matanzas Park | 21948 | 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.031 | Matanzas Park | 0 | Local Park 2 | 4 | |
7940 | 7940 | 7939 | {"type": "Polygon", "coordinates": [[[-122.67335, 38.42801], [-122.67288, 38.42828], [-122.67285, 38.42825], [-122.67287, 38.42816], [-122.67286, 38.42812], [-122.67279, 38.42807], [-122.67269, 38.42808], [-122.67264, 38.42812], [-122.67263, 38.42817], [-122.67267, 38.42825], [-122.67275, 38.42834], [-122.67152, 38.42905], [-122.6715, 38.42775], [-122.67151, 38.42747], [-122.67241, 38.42746], [-122.67242, 38.42735], [-122.67303, 38.42735], [-122.67304, 38.42768], [-122.67335, 38.42801]]]} | Open Access 1 | 10778 | Mesquite Park | 22186 | 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.466 | Mesquite Park | 0 | Local Park 2 | 4 | |
7938 | 7938 | 7937 | {"type": "Polygon", "coordinates": [[[-122.69702, 38.44707], [-122.69666, 38.44712], [-122.69664, 38.44728], [-122.69643, 38.44733], [-122.69631, 38.4472], [-122.69599, 38.44727], [-122.69594, 38.44715], [-122.69636, 38.44706], [-122.69699, 38.44694], [-122.69702, 38.44707]]]} | Open Access 1 | 10769 | Eastside Park | 18400 | 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 | Eastside Park | 0 | Local Park 2 | 4 | |
7935 | 7935 | 7934 | {"type": "Polygon", "coordinates": [[[-122.70955, 38.4434], [-122.70874, 38.44377], [-122.70831, 38.44322], [-122.70831, 38.44319], [-122.70912, 38.4428], [-122.70955, 38.4434]]]} | Open Access 1 | 10757 | Fremont Park | 19102 | 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.548 | Fremont Park | 2000 | Local Park 2 | 4 | |
7934 | 7934 | 7933 | {"type": "Polygon", "coordinates": [[[-122.70898, 38.449], [-122.70895, 38.44953], [-122.70824, 38.44951], [-122.70826, 38.44898], [-122.70898, 38.449]]]} | Open Access 1 | 10752 | North Park | 22842 | 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.916 | North Park | 0 | Local Park 2 | 4 | |
7933 | 7933 | 7932 | {"type": "Polygon", "coordinates": [[[-122.7143, 38.4539], [-122.71426, 38.45392], [-122.71394, 38.45391], [-122.71397, 38.45335], [-122.7143, 38.45336], [-122.71433, 38.45338], [-122.7143, 38.4539]]]} | Open Access 1 | 10750 | Humboldt Park | 20146 | 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.482 | Humboldt 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]);