units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
83 rows where MNG_AGENCY = 29 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
DES_TP 10
- Local Park 34
- Local Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 43
MNG_AGENCY 1
- Santa Rosa, City of · 43 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |
2051 | 2051 | 2050 | {"type": "Polygon", "coordinates": [[[-122.71534, 38.43546], [-122.71239, 38.43614], [-122.7121, 38.43498], [-122.71507, 38.43425], [-122.71534, 38.43546]]]} | Open Access 1 | 17125 | Juilliard Park | 32824 | 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.875 | Juilliard Park | 0 | Local Park 2 | 4 | |
3463 | 3463 | 3462 | {"type": "Polygon", "coordinates": [[[-122.81258, 38.40688], [-122.81095, 38.40685], [-122.81097, 38.4091], [-122.81254, 38.40914], [-122.81254, 38.4196], [-122.81121, 38.4196], [-122.81123, 38.42122], [-122.81049, 38.42124], [-122.81052, 38.42267], [-122.80968, 38.42267], [-122.80969, 38.42059], [-122.80968, 38.42058], [-122.80889, 38.42059], [-122.80889, 38.42267], [-122.80642, 38.42269], [-122.80108, 38.42268], [-122.79501, 38.42272], [-122.79499, 38.41973], [-122.80359, 38.4197], [-122.80349, 38.41056], [-122.80349, 38.4086], [-122.80676, 38.40743], [-122.80677, 38.40815], [-122.80678, 38.40816], [-122.80709, 38.40804], [-122.80708, 38.40732], [-122.80753, 38.40716], [-122.80755, 38.40779], [-122.80756, 38.4078], [-122.80855, 38.40771], [-122.81023, 38.40712], [-122.81024, 38.4062], [-122.81245, 38.40541], [-122.81259, 38.40564], [-122.81258, 38.40688]]]} | No Public Access 3 | 25346 | Kelly Farm | 20586 | 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 | 368.971 | Kelly Farm | None 288 | |||
3704 | 3704 | 3703 | {"type": "Polygon", "coordinates": [[[-122.76936, 38.43528], [-122.7686, 38.43533], [-122.76803, 38.43541], [-122.76769, 38.43551], [-122.76768, 38.4354], [-122.76753, 38.43421], [-122.76921, 38.43412], [-122.76936, 38.43528]]]} | Open Access 1 | 10436 | Live Oak Park | 21370 | 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.842 | Live Oak 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 | |
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 | |
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 | |
2295 | 2295 | 2294 | {"type": "Polygon", "coordinates": [[[-122.75088, 38.45585], [-122.75084, 38.45588], [-122.75076, 38.45647], [-122.75075, 38.45755], [-122.74783, 38.45898], [-122.74765, 38.45912], [-122.74747, 38.45933], [-122.74741, 38.45951], [-122.74739, 38.45969], [-122.74536, 38.45968], [-122.74536, 38.45837], [-122.74552, 38.45829], [-122.74565, 38.45773], [-122.74604, 38.45735], [-122.74659, 38.45735], [-122.74654, 38.45765], [-122.74751, 38.45765], [-122.7478, 38.45762], [-122.74779, 38.45737], [-122.74839, 38.45733], [-122.74838, 38.45652], [-122.74829, 38.45649], [-122.74831, 38.45648], [-122.74831, 38.45584], [-122.74823, 38.45583], [-122.74823, 38.45502], [-122.75085, 38.45501], [-122.75088, 38.45585]]]} | Open Access 1 | 18259 | Northwest Community Park | 22896 | 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 | 32.067 | Northwest Community 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 | |
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 | |
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 | |
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 | |
1513 | 1513 | 1512 | {"type": "Polygon", "coordinates": [[[-122.66983, 38.44622], [-122.66942, 38.44646], [-122.66856, 38.44559], [-122.66888, 38.44549], [-122.66888, 38.44548], [-122.66836, 38.44493], [-122.66851, 38.44486], [-122.66983, 38.44622]]]} | Open Access 1 | 10798 | Peter Springs Park | 23629 | 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.6 | Peter Springs Park | 0 | Local Park 2 | 4 | |
1487 | 1487 | 1486 | {"type": "Polygon", "coordinates": [[[-122.76629, 38.45731], [-122.76628, 38.45882], [-122.76465, 38.45882], [-122.76464, 38.45793], [-122.76534, 38.45792], [-122.76553, 38.45789], [-122.76572, 38.4578], [-122.76589, 38.45769], [-122.76613, 38.45742], [-122.76629, 38.45731]]]} | Open Access 1 | 10402 | Peterson Lane Park | 23632 | 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.051 | Peterson Lane 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 | |
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 | |
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 | |
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 |
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]);