units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 224
- San Diego, City of 181
- Sacramento, City of 167
- San Jose, City of 126
- Consumnes Community Services District 89
- Long Beach, City of 81
- Oakland, City of 74
- San Francisco, City and County of 73
- East Bay Regional Park District 70
- Los Angeles, County of 69
- Hayward Area Recreation and Park District 58
- Mountains Recreation and Conservation Authority 56
- Tracy, City of 56
- Valley-Wide Recreation and Park District 54
- Roseville, City of 52
- San Diego, County of 50
- Huntington Beach, City of 50
- Brentwood, City of 48
- Modesto, City of 47
- Chula Vista, City of 45
- Napa, City of 44
- Manteca, City of 44
- Stockton, City of 43
- Fresno, City of 41
- San Ramon, City of 41
- Bakersfield, City of 41
- El Dorado, County of 40
- Murrieta, City of 39
- Folsom, City of 37
- Santa Rosa, City of 36
- …
MNG_AG_TYP 15
- City Agency 5,286
- Recreation/Parks District 570
- County Agency 470
- Community Services District 151
- County Agency - Parks 129
- Open Space District 61
- Water District 30
- School District 29
- Port/Harbor District 18
- Flood District 15
- Special District - Other 9
- County Agency - Other 4
- Cemetery District 1
- Irrigation District 1
- Joint Powers Authority 1
ACCESS_TYP 4
- Open Access 6,520
- Restricted Access 188
- No Public Access 63
- Unknown Access 4
DES_TP 1
- Local Park · 6,775 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3810 | 3810 | 3809 | {"type": "Polygon", "coordinates": [[[-122.6307, 38.21993], [-122.63068, 38.22035], [-122.62958, 38.22036], [-122.62935, 38.22045], [-122.6293, 38.22056], [-122.62924, 38.22066], [-122.62902, 38.22065], [-122.62899, 38.22063], [-122.62886, 38.22061], [-122.62878, 38.22063], [-122.62846, 38.22063], [-122.62846, 38.21987], [-122.62849, 38.21982], [-122.62844, 38.21951], [-122.6285, 38.21947], [-122.62939, 38.21947], [-122.62953, 38.21953], [-122.62967, 38.21953], [-122.62973, 38.21975], [-122.62987, 38.21992], [-122.6307, 38.21993]]]} | Open Access 1 | 10133 | Grant Park | 19440 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 4.258 | Grant 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 | |
3812 | 3812 | 3811 | {"type": "Polygon", "coordinates": [[[-117.63394, 33.60507], [-117.63391, 33.60568], [-117.63388, 33.60587], [-117.63372, 33.60642], [-117.63352, 33.60685], [-117.63333, 33.60715], [-117.63272, 33.60796], [-117.63249, 33.60773], [-117.63246, 33.60773], [-117.63237, 33.60775], [-117.63215, 33.60762], [-117.63207, 33.60754], [-117.63203, 33.60747], [-117.63202, 33.60735], [-117.63223, 33.60679], [-117.63227, 33.60664], [-117.63245, 33.60642], [-117.6325, 33.60626], [-117.63258, 33.60609], [-117.63294, 33.60565], [-117.6329, 33.60553], [-117.63296, 33.60541], [-117.63289, 33.60525], [-117.63286, 33.60503], [-117.63287, 33.60498], [-117.63281, 33.60487], [-117.63291, 33.60487], [-117.6331, 33.60488], [-117.63332, 33.60494], [-117.63357, 33.60503], [-117.63369, 33.605], [-117.63394, 33.60507]]]} | Open Access 1 | 10146 | Robert A Curtis Park | 24481 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 8.168 | Robert A Curtis Park | 0 | Local Park 2 | 4 | |
3815 | 3815 | 3814 | {"type": "Polygon", "coordinates": [[[-122.64695, 41.7206], [-122.64692, 41.721], [-122.64672, 41.72116], [-122.64671, 41.72118], [-122.64664, 41.72119], [-122.64635, 41.72104], [-122.64633, 41.721], [-122.64635, 41.7209], [-122.64635, 41.72058], [-122.64695, 41.7206]]]} | Open Access 1 | 25378 | Lewis Park | 21194 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | Siskiyou 28 | 0.701 | Lewis Park | 0 | Local Park 2 | 4 | |
3816 | 3816 | 3815 | {"type": "Polygon", "coordinates": [[[-122.64386, 41.73274], [-122.64364, 41.73323], [-122.64065, 41.73257], [-122.64096, 41.73184], [-122.64135, 41.73194], [-122.6415, 41.73169], [-122.64242, 41.73188], [-122.64237, 41.73202], [-122.64237, 41.73208], [-122.6431, 41.73226], [-122.64354, 41.73235], [-122.64343, 41.73264], [-122.64386, 41.73274]]]} | Open Access 1 | 25379 | Minor Street Park | 22270 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | Siskiyou 28 | 5.961 | Minor Street Park | 0 | Local Park 2 | 4 | |
3818 | 3818 | 3817 | {"type": "Polygon", "coordinates": [[[-122.13417, 37.15393], [-122.13375, 37.15388], [-122.13379, 37.15364], [-122.13411, 37.15359], [-122.13417, 37.15393]]]} | Open Access 1 | 35183 | Garrahan Park | 28532 | 2009 | Boulder Creek Recreation and Park District 688 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/#!parks/ccjp | Santa Cruz 5 | 0.257 | Garrahan Park | 0 | Local Park 2 | 4 |
3819 | 3819 | 3818 | {"type": "Polygon", "coordinates": [[[-122.13458, 37.15391], [-122.13422, 37.15419], [-122.1342, 37.1541], [-122.13422, 37.15394], [-122.13417, 37.15393], [-122.13411, 37.15359], [-122.13379, 37.15364], [-122.13383, 37.15347], [-122.13395, 37.15311], [-122.13418, 37.15278], [-122.13458, 37.15237], [-122.13458, 37.15391]]]} | Open Access 1 | 35184 | Garrahan Park | 28532 | 2009 | Boulder Creek Recreation and Park District 688 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/#!parks/ccjp | Santa Cruz 5 | 1.947 | Garrahan Park | 0 | Local Park 2 | 4 |
3820 | 3820 | 3819 | {"type": "Polygon", "coordinates": [[[-117.07294, 33.13624], [-117.07138, 33.13696], [-117.07093, 33.13639], [-117.07125, 33.13623], [-117.07102, 33.13594], [-117.07231, 33.13531], [-117.07294, 33.13624]]]} | Open Access 1 | 45221 | Grove Park | 19534 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/grove-park.aspx | San Diego 4 | 4.561 | Grove Park | 0 | Local Park 2 | 4 |
3828 | 3828 | 3827 | {"type": "Polygon", "coordinates": [[[-121.92036, 36.5399], [-121.92029, 36.54173], [-121.91957, 36.54172], [-121.91936, 36.54168], [-121.91869, 36.54107], [-121.91884, 36.54097], [-121.91884, 36.54095], [-121.91806, 36.54023], [-121.91808, 36.5398], [-121.91905, 36.54025], [-121.91944, 36.54023], [-121.92036, 36.5399]]]} | Open Access 1 | 45290 | Rio Park | 24385 | 1046 | Carmel-by-the-Sea, City of 535 | City 2 | City Agency 2 | http://www.carmelcalifornia.com/ | City 2 | 1046 | Carmel-by-the-Sea, City of 528 | City 2 | City Agency 2 | Monterey 14 | 6.651 | Rio 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 | |
3832 | 3832 | 3831 | {"type": "Polygon", "coordinates": [[[-121.93195, 36.46898], [-121.92968, 36.47], [-121.92918, 36.46978], [-121.92903, 36.46952], [-121.92991, 36.46851], [-121.93056, 36.46842], [-121.9307, 36.46829], [-121.93172, 36.46882], [-121.93195, 36.46898]]]} | Open Access 1 | 45334 | County Park | 17715 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 6.297 | County Park | 0 | Local Park 2 | 4 | |
3836 | 3836 | 3835 | {"type": "Polygon", "coordinates": [[[-121.79521, 37.26427], [-121.79424, 37.26476], [-121.79239, 37.26413], [-121.79167, 37.2636], [-121.7931, 37.26341], [-121.79449, 37.26319], [-121.79503, 37.26315], [-121.79521, 37.26427]]]} | Open Access 1 | 45387 | Shady Oaks Park | 27915 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/Facilities/Facility/Details/Shady-Oaks-Park-157 | Santa Clara 19 | 8.29 | Shady Oaks Park | 0 | Local Park 2 | 4 |
3837 | 3837 | 3836 | {"type": "Polygon", "coordinates": [[[-121.81525, 37.30826], [-121.81558, 37.30859], [-121.81559, 37.30863], [-121.81499, 37.30902], [-121.81463, 37.30865], [-121.81525, 37.30826]]]} | Open Access 1 | 45391 | West Evergreen Park | 27916 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/Facilities?clear=True | Santa Clara 19 | 0.9 | West Evergreen Park | 0 | Local Park 2 | 4 |
3839 | 3839 | 3838 | {"type": "Polygon", "coordinates": [[[-117.83849, 34.61111], [-117.83844, 34.61122], [-117.83629, 34.61123], [-117.83631, 34.61635], [-117.8355, 34.61634], [-117.83549, 34.61306], [-117.83548, 34.61288], [-117.83541, 34.61251], [-117.83529, 34.61217], [-117.8348, 34.61124], [-117.8346, 34.61086], [-117.83444, 34.61059], [-117.83432, 34.61046], [-117.83412, 34.6103], [-117.83399, 34.61024], [-117.83363, 34.61011], [-117.83351, 34.61008], [-117.83185, 34.6085], [-117.83127, 34.6083], [-117.82893, 34.60825], [-117.82623, 34.60825], [-117.82514, 34.60681], [-117.82557, 34.60661], [-117.82567, 34.60658], [-117.82681, 34.60652], [-117.82705, 34.60648], [-117.82743, 34.60639], [-117.82795, 34.6062], [-117.82811, 34.60612], [-117.82829, 34.60603], [-117.82856, 34.60584], [-117.82856, 34.60583], [-117.82814, 34.60543], [-117.82814, 34.60539], [-117.8281, 34.60533], [-117.82805, 34.6053], [-117.82799, 34.60529], [-117.82755, 34.60489], [-117.82881, 34.60398], [-117.82949, 34.60318], [-117.82979, 34.60335], [-117.83009, 34.60355], [-117.83037, 34.60377], [-117.83062, 34.604], [-117.8308, 34.60419], [-117.83296, 34.60663], [-117.83319, 34.60687], [-117.83344, 34.60708], [-117.83363, 34.60723], [-117.83392, 34.60744], [-117.83421, 34.60761], [-117.8347, 34.60786], [-117.8352, 34.60806], [-117.83588, 34.60825], [-117.83805, 34.60874], [-117.83794, 34.60908], [-117.83794, 34.61049], [-117.83849, 34.61111]]]} | Open Access 1 | 45402 | Stephen Sorensen Park | 28178 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Stephen_Sorensen_Park | Los Angeles 6 | 108.11 | Stephen Sorensen Park | 0 | Local Park 2 | 4 |
3841 | 3841 | 3840 | {"type": "Polygon", "coordinates": [[[-118.49445, 34.01125], [-118.49443, 34.01131], [-118.49405, 34.01142], [-118.4937, 34.01157], [-118.49296, 34.01203], [-118.49172, 34.01097], [-118.49255, 34.01029], [-118.49304, 34.01073], [-118.49346, 34.0104], [-118.49445, 34.01125]]]} | Open Access 1 | 45421 | Tongva Park | 28201 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://www.smgov.net/Departments/CCS/content.aspx?id=32599 | Los Angeles 6 | 6.161 | Tongva Park | 0 | Local Park 2 | 4 |
3842 | 3842 | 3841 | {"type": "Polygon", "coordinates": [[[-117.01532, 33.78362], [-117.0139, 33.78363], [-117.01408, 33.7834], [-117.01418, 33.78331], [-117.01424, 33.78315], [-117.01446, 33.78269], [-117.0146, 33.78223], [-117.01465, 33.78198], [-117.01467, 33.78168], [-117.01467, 33.78078], [-117.0147, 33.78058], [-117.01466, 33.78048], [-117.01466, 33.78011], [-117.01522, 33.78011], [-117.01529, 33.78017], [-117.01532, 33.78362]]]} | Open Access 1 | 45431 | Catalpa Park | 28229 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 6.935 | Catalpa Park | 0 | Local Park 2 | 4 |
3844 | 3844 | 3843 | {"type": "Polygon", "coordinates": [[[-116.96921, 33.78085], [-116.96805, 33.78184], [-116.96692, 33.78091], [-116.96758, 33.78035], [-116.9692, 33.78035], [-116.96921, 33.78085]]]} | Open Access 1 | 45450 | Francisco Estudillo Heritage Park | 28249 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | Riverside 10 | 5.384 | Francisco Estudillo Heritage Park | 0 | Local Park 2 | 4 |
3846 | 3846 | 3845 | {"type": "Polygon", "coordinates": [[[-117.22388, 32.93759], [-117.22376, 32.93764], [-117.22348, 32.9376], [-117.22333, 32.93761], [-117.22215, 32.93794], [-117.22194, 32.93802], [-117.22151, 32.93822], [-117.22151, 32.93456], [-117.22388, 32.93457], [-117.22388, 32.93759]]]} | No Public Access 3 | 46811 | Neighborhood 8 Neighborhood Park | 30272 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 19.773 | Neighborhood 8 Neighborhood Park | 0 | Local Park 2 | 4 | |
3848 | 3848 | 3847 | {"type": "Polygon", "coordinates": [[[-117.04738, 32.55364], [-117.04717, 32.55399], [-117.04686, 32.55386], [-117.04707, 32.55351], [-117.04738, 32.55364]]]} | Open Access 1 | 46812 | San Ysidro Mini Park | 32781 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.354 | San Ysidro MP | 0 | Local Park 2 | 4 | |
3849 | 3849 | 3848 | {"type": "MultiPolygon", "coordinates": [[[[-120.08509, 34.61217], [-120.08485, 34.61225], [-120.08464, 34.61234], [-120.08421, 34.61266], [-120.08416, 34.61268], [-120.08416, 34.61217], [-120.08509, 34.61217]]], [[[-120.08517, 34.61149], [-120.08516, 34.61204], [-120.0845, 34.61203], [-120.08451, 34.61148], [-120.08517, 34.61149]]], [[[-120.08606, 34.6115], [-120.08594, 34.61162], [-120.08572, 34.61198], [-120.08555, 34.61204], [-120.08543, 34.61204], [-120.08543, 34.61149], [-120.08606, 34.6115]]], [[[-120.08723, 34.61005], [-120.08718, 34.61013], [-120.08634, 34.61118], [-120.08635, 34.6112], [-120.08626, 34.61128], [-120.08554, 34.61129], [-120.08554, 34.61123], [-120.08561, 34.61111], [-120.0859, 34.61112], [-120.08608, 34.61102], [-120.08625, 34.6111], [-120.08632, 34.61104], [-120.08622, 34.61074], [-120.08647, 34.61044], [-120.0867, 34.61044], [-120.08691, 34.61018], [-120.08706, 34.61005], [-120.08723, 34.61005]]]]} | Open Access 1 | 626 | Santa Ynez Park | 25143 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.195 | Santa Ynez 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]);