units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
221 rows where DES_TP = 14 and LAYER = 3 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, COUNTY, YR_EST
MNG_AGENCY 26
- Butte, County of 52
- Santa Barbara, County of 39
- Lake, County of 36
- Orange, County of 21
- Monterey, County of 18
- Los Angeles, County of 11
- Sacramento, County of 6
- San Francisco - Public Utilities Commission, City and County of 5
- Ventura, County of 5
- Santa Cruz, County of 4
- San Diego, County of 4
- Tulare, County of 3
- Riverside, County of 3
- Merced, County of 2
- Sonoma County Regional Parks Dept., County of 1
- Placer, County of 1
- Imperial, County of 1
- San Bernardino, County of 1
- Napa, County of 1
- Yolo, County of 1
- Humboldt, County of 1
- Tehama, County of 1
- Orange County Department of Education, County of 1
- Trinity, County of 1
- Marin, County of 1
- Solano, County of 1
ACCESS_TYP 4
MNG_AG_TYP 3
DES_TP 1
- Local Other or Unknown · 221 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5832 | 5832 | 5831 | {"type": "MultiPolygon", "coordinates": [[[[-120.50973, 34.63798], [-120.51286, 34.63889], [-120.51323, 34.63901], [-120.51359, 34.63917], [-120.51515, 34.64001], [-120.51622, 34.64005], [-120.51655, 34.6402], [-120.51656, 34.64047], [-120.51688, 34.64047], [-120.51753, 34.64052], [-120.51833, 34.64072], [-120.52173, 34.64176], [-120.52245, 34.64197], [-120.52267, 34.64203], [-120.52322, 34.64208], [-120.52367, 34.64208], [-120.52411, 34.642], [-120.52453, 34.64184], [-120.52473, 34.64174], [-120.52491, 34.64162], [-120.52509, 34.64148], [-120.52526, 34.64133], [-120.5254, 34.64117], [-120.52499, 34.64091], [-120.52532, 34.64066], [-120.52591, 34.641], [-120.52569, 34.64131], [-120.52561, 34.64127], [-120.52529, 34.64159], [-120.5251, 34.64174], [-120.5249, 34.64187], [-120.52468, 34.64198], [-120.52446, 34.64208], [-120.52423, 34.64216], [-120.524, 34.64221], [-120.52376, 34.64225], [-120.52326, 34.64226], [-120.52306, 34.64225], [-120.52266, 34.64219], [-120.52244, 34.64213], [-120.5177, 34.64076], [-120.51683, 34.64065], [-120.51662, 34.64071], [-120.51561, 34.64118], [-120.51546, 34.64157], [-120.51524, 34.64229], [-120.51503, 34.64383], [-120.51517, 34.64385], [-120.51518, 34.64407], [-120.51465, 34.64397], [-120.51466, 34.64381], [-120.51481, 34.64378], [-120.515, 34.64223], [-120.5152, 34.64136], [-120.5152, 34.64105], [-120.51524, 34.64024], [-120.51359, 34.63934], [-120.5132, 34.63917], [-120.51278, 34.63903], [-120.50968, 34.63817], [-120.50816, 34.6378], [-120.50809, 34.63772], [-120.50496, 34.63692], [-120.50458, 34.63679], [-120.5044, 34.63671], [-120.50407, 34.63649], [-120.50378, 34.63623], [-120.50366, 34.63607], [-120.50355, 34.63591], [-120.50337, 34.63556], [-120.50306, 34.63472], [-120.50291, 34.63448], [-120.50259, 34.63415], [-120.50216, 34.63439], [-120.50154, 34.63387], [-120.50279, 34.63315], [-120.50329, 34.63373], [-120.50277, 34.63406], [-120.50309, 34.63452], [-120.50321, 34.63473], [-120.50355, 34.63565], [-120.50374, 34.63597], [-120.50398, 34.63625], [-120.50427, 34.63649], [-120.50459, 34.63667], [-120.50494, 34.6368], [-120.50702, 34.63734], [-120.5071, 34.63728], [-120.50758, 34.63739], [-120.50763, 34.63748], [-120.50973, 34.63798]]], [[[-120.51511, 34.64666], [-120.51511, 34.6469], [-120.51439, 34.64689], [-120.51439, 34.64665], [-120.51459, 34.64664], [-120.51462, 34.64418], [-120.51492, 34.64425], [-120.51488, 34.64664], [-120.51511, 34.64666]]], [[[-120.5152, 34.64717], [-120.51519, 34.64736], [-120.51495, 34.64736], [-120.5148, 34.66139], [-120.51441, 34.66139], [-120.51444, 34.65983], [-120.5145, 34.65944], [-120.51456, 34.65417], [-120.51455, 34.64736], [-120.51434, 34.64735], [-120.51434, 34.64716], [-120.5152, 34.64717]]], [[[-120.51427, 34.66507], [-120.5144, 34.66155], [-120.5148, 34.66156], [-120.51468, 34.66508], [-120.51458, 34.66933], [-120.51472, 34.66934], [-120.51467, 34.67235], [-120.5146, 34.67337], [-120.51462, 34.67357], [-120.51469, 34.67382], [-120.51479, 34.67405], [-120.51525, 34.67468], [-120.51541, 34.67475], [-120.51554, 34.67482], [-120.51677, 34.67601], [-120.5155, 34.67603], [-120.51524, 34.67584], [-120.51453, 34.67574], [-120.51455, 34.67434], [-120.51437, 34.67417], [-120.51427, 34.67403], [-120.5142, 34.67387], [-120.51415, 34.6737], [-120.51414, 34.67333], [-120.51419, 34.6687], [-120.51427, 34.66507]]]]} | Unknown Access 4 | 159 | Rodeo-San Pascual Flood Control Channel | 24548 | 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 | 53.121 | Rodeo-San Pascual Flood Control Channel | 0 | Local Other or Unknown 14 | 4 | |
5884 | 5884 | 5883 | {"type": "MultiPolygon", "coordinates": [[[[-119.79426, 34.4463], [-119.79411, 34.44637], [-119.79361, 34.44738], [-119.79382, 34.4476], [-119.7938, 34.44786], [-119.79343, 34.44803], [-119.79298, 34.44802], [-119.79241, 34.44812], [-119.79224, 34.44837], [-119.79212, 34.44829], [-119.79226, 34.44801], [-119.7925, 34.44786], [-119.79254, 34.44769], [-119.79277, 34.44765], [-119.79284, 34.44779], [-119.79309, 34.44778], [-119.79324, 34.44775], [-119.79335, 34.44763], [-119.79341, 34.44749], [-119.79326, 34.44738], [-119.79339, 34.44722], [-119.79373, 34.44669], [-119.79374, 34.44663], [-119.79372, 34.44657], [-119.79404, 34.44609], [-119.79426, 34.4463]]], [[[-119.79691, 34.446], [-119.79567, 34.446], [-119.79525, 34.44612], [-119.79527, 34.44646], [-119.79515, 34.44653], [-119.79497, 34.44665], [-119.79437, 34.44639], [-119.79559, 34.44572], [-119.79691, 34.44574], [-119.79691, 34.446]]], [[[-119.80544, 34.44219], [-119.80546, 34.44288], [-119.80541, 34.44301], [-119.8053, 34.44297], [-119.80522, 34.44319], [-119.805, 34.44321], [-119.80514, 34.44286], [-119.80505, 34.44237], [-119.80464, 34.44245], [-119.80463, 34.44244], [-119.80339, 34.4427], [-119.80252, 34.44299], [-119.80242, 34.443], [-119.80218, 34.44295], [-119.80205, 34.44296], [-119.80193, 34.44301], [-119.80184, 34.4431], [-119.80166, 34.44341], [-119.80163, 34.44356], [-119.79959, 34.44377], [-119.79958, 34.44402], [-119.80165, 34.44381], [-119.80166, 34.44387], [-119.80164, 34.4439], [-119.80152, 34.444], [-119.80123, 34.44433], [-119.79955, 34.44431], [-119.79955, 34.44426], [-119.79932, 34.44426], [-119.79926, 34.44428], [-119.79891, 34.44452], [-119.79893, 34.44461], [-119.79879, 34.44464], [-119.79864, 34.44471], [-119.79829, 34.44493], [-119.79811, 34.44503], [-119.79791, 34.4451], [-119.7977, 34.44513], [-119.79719, 34.4451], [-119.79715, 34.44507], [-119.79716, 34.44489], [-119.79744, 34.44489], [-119.79768, 34.44487], [-119.79791, 34.44481], [-119.79813, 34.44471], [-119.79833, 34.44457], [-119.79906, 34.44389], [-119.79918, 34.44383], [-119.79934, 34.44379], [-119.79935, 34.44374], [-119.80041, 34.44361], [-119.8009, 34.44357], [-119.80091, 34.44337], [-119.80083, 34.44331], [-119.80078, 34.44324], [-119.80077, 34.44317], [-119.80078, 34.44304], [-119.80079, 34.44298], [-119.80084, 34.44291], [-119.80095, 34.44281], [-119.80101, 34.44277], [-119.8013, 34.44273], [-119.80157, 34.44261], [-119.80241, 34.44243], [-119.8022, 34.44256], [-119.80194, 34.44281], [-119.80286, 34.44279], [-119.80297, 34.44269], [-119.80544, 34.44219]]]]} | Unknown Access 4 | 290 | San Antonio Creek | 24828 | 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 | 12.836 | San Antonio Creek | 0 | Local Other or Unknown 14 | 4 | |
133 | 133 | 132 | {"type": "Polygon", "coordinates": [[[-119.74246, 34.44054], [-119.74244, 34.44072], [-119.74241, 34.44073], [-119.74215, 34.44091], [-119.74194, 34.44113], [-119.74168, 34.44129], [-119.74157, 34.44128], [-119.7414, 34.44128], [-119.74181, 34.44101], [-119.74204, 34.44079], [-119.74227, 34.44062], [-119.74234, 34.44054], [-119.74246, 34.44054]]]} | Unknown Access 4 | 414 | San Roque Creek | 24990 | 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 | 0.477 | San Roque Creek | 0 | Local Other or Unknown 14 | 4 | |
5923 | 5923 | 5922 | {"type": "Polygon", "coordinates": [[[-122.1385, 37.48163], [-122.13828, 37.48212], [-122.13754, 37.48296], [-122.13725, 37.48334], [-122.13641, 37.48427], [-122.13358, 37.48639], [-122.13244, 37.48637], [-122.12668, 37.4898], [-122.12636, 37.48978], [-122.12589, 37.4898], [-122.1259, 37.48918], [-122.12601, 37.48639], [-122.12719, 37.48574], [-122.12827, 37.48519], [-122.13007, 37.48435], [-122.1312, 37.48388], [-122.13088, 37.48337], [-122.13108, 37.4829], [-122.13274, 37.48232], [-122.13331, 37.48262], [-122.1338, 37.48271], [-122.13422, 37.48259], [-122.13498, 37.48243], [-122.13544, 37.48231], [-122.13605, 37.48227], [-122.13669, 37.48211], [-122.13741, 37.48183], [-122.1385, 37.48163]]]} | Restricted Access 2 | 455 | San Mateo Properties | 24954 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 94.811 | San Mateo Properties | 1930 | Local Other or Unknown 14 | 4 | |
5988 | 5988 | 5987 | {"type": "Polygon", "coordinates": [[[-119.52661, 34.41577], [-119.52628, 34.41577], [-119.52622, 34.41481], [-119.52623, 34.41435], [-119.5263, 34.41401], [-119.52657, 34.41394], [-119.52646, 34.41475], [-119.52646, 34.41518], [-119.52661, 34.41577]]]} | Open Access 1 | 595 | Santa Monica Creek | 25116 | 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 | 1.173 | Santa Monica Creek | 0 | Local Other or Unknown 14 | 4 | |
4473 | 4473 | 4472 | {"type": "MultiPolygon", "coordinates": [[[[-121.97217, 36.95571], [-121.97161, 36.95571], [-121.97067, 36.95684], [-121.96972, 36.95745], [-121.96972, 36.9572], [-121.96985, 36.95709], [-121.97002, 36.95701], [-121.97017, 36.95688], [-121.97046, 36.95667], [-121.97057, 36.95657], [-121.97068, 36.9564], [-121.97079, 36.9563], [-121.9709, 36.95613], [-121.97105, 36.95599], [-121.9711, 36.95587], [-121.97115, 36.95582], [-121.97122, 36.95566], [-121.97128, 36.95558], [-121.9715, 36.95551], [-121.97151, 36.95549], [-121.97172, 36.95544], [-121.97193, 36.95527], [-121.97196, 36.9553], [-121.97173, 36.9555], [-121.97217, 36.9556], [-121.97217, 36.95571]]], [[[-121.97325, 36.95473], [-121.97294, 36.95463], [-121.97273, 36.95464], [-121.97267, 36.95471], [-121.97265, 36.95471], [-121.97264, 36.95469], [-121.97275, 36.95462], [-121.97288, 36.95459], [-121.97305, 36.95462], [-121.97324, 36.95471], [-121.97325, 36.95473]]]]} | Open Access 1 | 1619 | Unnamed site - Santa Cruz, County of | 28666 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.964 | 0 | Local Other or Unknown 14 | 4 | ||
5279 | 5279 | 5278 | {"type": "Polygon", "coordinates": [[[-117.25814, 33.7139], [-117.25811, 33.71948], [-117.25803, 33.72838], [-117.24077, 33.72856], [-117.24065, 33.72142], [-117.24062, 33.71414], [-117.25808, 33.71387], [-117.25809, 33.7139], [-117.25814, 33.7139]]]} | Open Access 1 | 2650 | Kabian Park Property | 20539 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 640.487 | Kabian Park Property | 0 | Local Other or Unknown 14 | 4 | |
6620 | 6620 | 6619 | {"type": "MultiPolygon", "coordinates": [[[[-119.50852, 34.39516], [-119.50697, 34.39588], [-119.50689, 34.39577], [-119.5075, 34.3955], [-119.50841, 34.395], [-119.50852, 34.39516]]], [[[-119.50986, 34.39487], [-119.50965, 34.39489], [-119.50944, 34.39484], [-119.50927, 34.39472], [-119.50912, 34.39453], [-119.50904, 34.39446], [-119.50888, 34.39438], [-119.50873, 34.39436], [-119.5086, 34.39437], [-119.50821, 34.39482], [-119.50804, 34.39483], [-119.50784, 34.39456], [-119.50791, 34.39452], [-119.50809, 34.39429], [-119.50817, 34.39415], [-119.50814, 34.39411], [-119.50831, 34.39392], [-119.50859, 34.39368], [-119.50859, 34.3931], [-119.50876, 34.39344], [-119.50894, 34.39363], [-119.50974, 34.39478], [-119.5098, 34.39476], [-119.50986, 34.39487]]]]} | Unknown Access 4 | 4305 | Carpinteria Creek | 16896 | 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.634 | Carpinteria Creek | 0 | Local Other or Unknown 14 | 4 | |
6832 | 6832 | 6831 | {"type": "MultiPolygon", "coordinates": [[[[-122.40617, 37.71487], [-122.40605, 37.71513], [-122.40573, 37.71504], [-122.40583, 37.71478], [-122.40549, 37.71466], [-122.40564, 37.71442], [-122.40582, 37.71449], [-122.40603, 37.71454], [-122.40593, 37.7148], [-122.40617, 37.71487]]], [[[-122.40653, 37.71572], [-122.40641, 37.71598], [-122.40609, 37.71589], [-122.4062, 37.71564], [-122.40612, 37.71561], [-122.40624, 37.71535], [-122.40639, 37.7154], [-122.40629, 37.71566], [-122.40653, 37.71572]]], [[[-122.40689, 37.71658], [-122.40678, 37.71684], [-122.40645, 37.71675], [-122.40656, 37.71649], [-122.40632, 37.71642], [-122.40643, 37.71616], [-122.40676, 37.71625], [-122.40665, 37.71651], [-122.40689, 37.71658]]]]} | Open Access 1 | 5446 | Reis Tract Lots - Tucker | 24285 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Francisco 13 | 1.334 | Reis Tract Lots - Tucker | 0 | Local Other or Unknown 14 | 4 | |
6833 | 6833 | 6832 | {"type": "MultiPolygon", "coordinates": [[[[-122.4062, 37.71304], [-122.40605, 37.71328], [-122.40613, 37.71332], [-122.40597, 37.71356], [-122.40582, 37.7135], [-122.40597, 37.71327], [-122.40589, 37.71323], [-122.40605, 37.71298], [-122.4062, 37.71304]]], [[[-122.40652, 37.71237], [-122.40637, 37.71261], [-122.40644, 37.71265], [-122.40629, 37.71289], [-122.40614, 37.71283], [-122.40628, 37.7126], [-122.40621, 37.71256], [-122.40636, 37.71231], [-122.40652, 37.71237]]]]} | Open Access 1 | 5452 | Reis Tract Lots - Arleta Ii | 24284 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Francisco 13 | 0.462 | Reis Tract Lots - Arleta Ii | 0 | Local Other or Unknown 14 | 4 | |
5313 | 5313 | 5312 | {"type": "Polygon", "coordinates": [[[-122.40596, 37.71374], [-122.40581, 37.71398], [-122.40589, 37.71402], [-122.40573, 37.71427], [-122.4055, 37.71418], [-122.40565, 37.71394], [-122.40558, 37.7139], [-122.40573, 37.71365], [-122.40596, 37.71374]]]} | Open Access 1 | 6024 | Reis Tract Lots - Arleta I | 24283 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Francisco 13 | 0.348 | Reis Tract Lots - Arleta I | 0 | Local Other or Unknown 14 | 4 | |
1149 | 1149 | 1148 | {"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]} | Restricted Access 2 | 6734 | Hillcrest And Ocean View Lots | 19962 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 0.08 | Hillcrest And Ocean View Lots | 0 | Local Other or Unknown 14 | 4 | |
4519 | 4519 | 4518 | {"type": "Polygon", "coordinates": [[[-117.6523, 33.73705], [-117.6424, 33.73701], [-117.64238, 33.73346], [-117.64935, 33.7315], [-117.65064, 33.73322], [-117.652, 33.73296], [-117.65104, 33.73389], [-117.6515, 33.73494], [-117.6523, 33.73705]]]} | Restricted Access 2 | 12713 | Unnamed site - Orange County Department of Education, County of | 28651 | 313 | Orange County Department of Education, County of 770 | County 3 | County Agency - Other 9 | http://www.ocde.us/ | County 3 | 313 | Orange County Department of Education, County of 751 | County 3 | County Agency - Other 8 | Orange 3 | 105.765 | 0 | Local Other or Unknown 14 | 4 | ||
4863 | 4863 | 4862 | {"type": "MultiPolygon", "coordinates": [[[[-119.70446, 34.41592], [-119.70424, 34.41613], [-119.70413, 34.41605], [-119.70419, 34.41599], [-119.70419, 34.41598], [-119.70404, 34.41596], [-119.70425, 34.41577], [-119.70446, 34.41592]]], [[[-119.70685, 34.41659], [-119.70669, 34.41678], [-119.7063, 34.4165], [-119.70614, 34.41646], [-119.70575, 34.41648], [-119.70547, 34.41645], [-119.70524, 34.41628], [-119.70536, 34.41617], [-119.70546, 34.41624], [-119.70567, 34.4163], [-119.70578, 34.41631], [-119.70609, 34.4163], [-119.70614, 34.41611], [-119.70651, 34.41638], [-119.70658, 34.4164], [-119.70685, 34.41659]]], [[[-119.70983, 34.41818], [-119.70962, 34.41838], [-119.70935, 34.41819], [-119.70897, 34.41794], [-119.70718, 34.41712], [-119.70694, 34.41694], [-119.70715, 34.41674], [-119.70759, 34.41702], [-119.70878, 34.41758], [-119.70922, 34.41781], [-119.70983, 34.41818]]], [[[-119.71422, 34.42244], [-119.71392, 34.42193], [-119.71369, 34.42125], [-119.71359, 34.42118], [-119.7136, 34.42116], [-119.71335, 34.42103], [-119.71095, 34.41928], [-119.71092, 34.41929], [-119.71027, 34.41881], [-119.71045, 34.41863], [-119.71376, 34.42102], [-119.71375, 34.42104], [-119.71445, 34.42169], [-119.71451, 34.42176], [-119.71457, 34.42188], [-119.71459, 34.422], [-119.71458, 34.42209], [-119.71452, 34.42226], [-119.71422, 34.42244]]], [[[-119.71602, 34.42306], [-119.71596, 34.42311], [-119.71571, 34.42293], [-119.71503, 34.42272], [-119.71492, 34.42281], [-119.71462, 34.42268], [-119.7148, 34.42245], [-119.71508, 34.42266], [-119.71527, 34.42272], [-119.71547, 34.42272], [-119.71565, 34.42277], [-119.71602, 34.42306]]], [[[-119.71871, 34.4248], [-119.71859, 34.42481], [-119.71853, 34.42497], [-119.7185, 34.42501], [-119.7185, 34.42485], [-119.71848, 34.42476], [-119.7184, 34.42456], [-119.71827, 34.42439], [-119.71817, 34.42433], [-119.71797, 34.4243], [-119.71792, 34.42426], [-119.71803, 34.42416], [-119.71837, 34.42443], [-119.71871, 34.4248]]], [[[-119.71973, 34.42579], [-119.71956, 34.42597], [-119.71905, 34.42559], [-119.71906, 34.42556], [-119.71868, 34.42528], [-119.71893, 34.42505], [-119.71881, 34.42495], [-119.71886, 34.42491], [-119.71973, 34.42579]]], [[[-119.72436, 34.42678], [-119.72408, 34.42674], [-119.7239, 34.42666], [-119.72379, 34.42667], [-119.72365, 34.42666], [-119.72345, 34.42659], [-119.72288, 34.42652], [-119.72194, 34.42634], [-119.72175, 34.42632], [-119.72189, 34.42619], [-119.72247, 34.42632], [-119.72345, 34.42645], [-119.7239, 34.42657], [-119.72436, 34.42678]]]]} | Unknown Access 4 | 14691 | El Mission Creek | 18513 | 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 | 9.467 | El Mission Creek | 0 | Local Other or Unknown 14 | 4 | |
9009 | 9009 | 9008 | {"type": "Polygon", "coordinates": [[[-122.65202, 38.35073], [-122.64218, 38.35079], [-122.64218, 38.35016], [-122.64159, 38.34812], [-122.64149, 38.34804], [-122.64161, 38.34773], [-122.64163, 38.34714], [-122.64171, 38.34669], [-122.64214, 38.34583], [-122.64266, 38.34517], [-122.64337, 38.34455], [-122.64507, 38.34235], [-122.64514, 38.34205], [-122.64511, 38.34176], [-122.64494, 38.3412], [-122.6448, 38.34093], [-122.64492, 38.34076], [-122.64516, 38.34051], [-122.64545, 38.34014], [-122.64715, 38.34466], [-122.65121, 38.34968], [-122.65166, 38.34996], [-122.65202, 38.35073]]]} | Open Access 1 | 14914 | Crane Creek | 17756 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 129.999 | Crane Creek | 1974 | Local Other or Unknown 14 | 4 | |
9811 | 9811 | 9810 | {"type": "MultiPolygon", "coordinates": [[[[-119.78388, 34.43252], [-119.78345, 34.43278], [-119.78231, 34.43354], [-119.78143, 34.43378], [-119.78052, 34.4337], [-119.78052, 34.43358], [-119.78135, 34.43364], [-119.78158, 34.43361], [-119.78213, 34.43346], [-119.78241, 34.43332], [-119.78376, 34.43242], [-119.78381, 34.43241], [-119.78385, 34.43243], [-119.78388, 34.43248], [-119.78388, 34.43252]]], [[[-119.79498, 34.42774], [-119.79162, 34.42959], [-119.7874, 34.43078], [-119.78626, 34.43109], [-119.78625, 34.43108], [-119.78589, 34.43127], [-119.78408, 34.43239], [-119.78411, 34.4321], [-119.78448, 34.43201], [-119.78536, 34.43149], [-119.78544, 34.43143], [-119.7857, 34.43115], [-119.7862, 34.43068], [-119.78689, 34.43049], [-119.78694, 34.43059], [-119.79145, 34.42935], [-119.79203, 34.42903], [-119.79202, 34.42901], [-119.79462, 34.42757], [-119.79483, 34.42761], [-119.79498, 34.42774]]]]} | Unknown Access 4 | 16760 | Atascadero Creek | 15661 | 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 | 9.641 | Atascadero Creek | 0 | Local Other or Unknown 14 | 4 | |
10124 | 10124 | 10123 | {"type": "MultiPolygon", "coordinates": [[[[-119.80818, 34.42783], [-119.80793, 34.42827], [-119.80768, 34.42863], [-119.80753, 34.42918], [-119.80753, 34.42957], [-119.80738, 34.43021], [-119.80738, 34.43068], [-119.80766, 34.43127], [-119.80766, 34.43204], [-119.80759, 34.43228], [-119.80758, 34.43254], [-119.80761, 34.43273], [-119.80782, 34.43341], [-119.80783, 34.43357], [-119.80781, 34.43369], [-119.80775, 34.43386], [-119.80769, 34.43396], [-119.80749, 34.43418], [-119.80694, 34.43476], [-119.80655, 34.43475], [-119.80662, 34.43457], [-119.80671, 34.43458], [-119.80679, 34.43454], [-119.80682, 34.43449], [-119.80683, 34.43443], [-119.8069, 34.43442], [-119.80717, 34.43408], [-119.80713, 34.4338], [-119.80705, 34.43375], [-119.80706, 34.43369], [-119.80705, 34.43363], [-119.80714, 34.43359], [-119.80722, 34.43323], [-119.80737, 34.43319], [-119.80729, 34.43293], [-119.80721, 34.43289], [-119.80724, 34.4328], [-119.80719, 34.43256], [-119.80717, 34.43226], [-119.80724, 34.43176], [-119.80724, 34.43145], [-119.80722, 34.43129], [-119.80709, 34.4308], [-119.80705, 34.43058], [-119.80703, 34.43036], [-119.80703, 34.43014], [-119.80712, 34.42909], [-119.8072, 34.42878], [-119.80735, 34.42839], [-119.80738, 34.42824], [-119.80739, 34.42809], [-119.80737, 34.42787], [-119.80818, 34.42783]]], [[[-119.80555, 34.44363], [-119.80546, 34.44368], [-119.80534, 34.44379], [-119.80523, 34.44397], [-119.80497, 34.44513], [-119.80464, 34.4451], [-119.80449, 34.44531], [-119.80419, 34.44525], [-119.80402, 34.4453], [-119.80393, 34.44547], [-119.80358, 34.44532], [-119.80365, 34.44499], [-119.8039, 34.44475], [-119.80438, 34.44456], [-119.80474, 34.44427], [-119.8046, 34.44386], [-119.80481, 34.44368], [-119.80527, 34.44343], [-119.80532, 34.44334], [-119.80551, 34.44332], [-119.80555, 34.44363]]], [[[-119.80378, 34.44592], [-119.80366, 34.4463], [-119.80325, 34.44624], [-119.80324, 34.44625], [-119.80335, 34.44727], [-119.80368, 34.44726], [-119.80373, 34.44775], [-119.80371, 34.44782], [-119.80365, 34.44786], [-119.80355, 34.44789], [-119.80349, 34.44795], [-119.80328, 34.4479], [-119.80257, 34.44813], [-119.80238, 34.44837], [-119.80211, 34.44842], [-119.80196, 34.44856], [-119.80178, 34.44857], [-119.80166, 34.44894], [-119.80137, 34.44905], [-119.8013, 34.44915], [-119.80126, 34.44928], [-119.80139, 34.44946], [-119.80159, 34.44962], [-119.80128, 34.44962], [-119.80088, 34.44918], [-119.80098, 34.44907], [-119.8012, 34.44877], [-119.80138, 34.44859], [-119.80223, 34.44801], [-119.8023, 34.44795], [-119.80235, 34.44786], [-119.80262, 34.44773], [-119.80269, 34.44762], [-119.80241, 34.44694], [-119.8021, 34.44669], [-119.80182, 34.4467], [-119.80174, 34.44684], [-119.80123, 34.44716], [-119.80119, 34.44729], [-119.80113, 34.44766], [-119.80087, 34.44796], [-119.80047, 34.44833], [-119.80041, 34.44828], [-119.80029, 34.44828], [-119.80051, 34.44786], [-119.80059, 34.44762], [-119.80067, 34.44731], [-119.80079, 34.44707], [-119.80091, 34.44694], [-119.8015, 34.44645], [-119.80169, 34.44626], [-119.80199, 34.44589], [-119.80212, 34.44575], [-119.80256, 34.44575], [-119.80304, 34.44557], [-119.80355, 34.44549], [-119.80368, 34.44556], [-119.80351, 34.44585], [-119.80378, 34.44592]]], [[[-119.7952, 34.45576], [-119.79519, 34.45606], [-119.79483, 34.45606], [-119.79478, 34.45662], [-119.79471, 34.45677], [-119.79433, 34.45736], [-119.79434, 34.45737], [-119.79472, 34.45738], [-119.79463, 34.45757], [-119.79373, 34.45755], [-119.7937, 34.45659], [-119.79444, 34.45608], [-119.79437, 34.45575], [-119.7952, 34.45576]]], [[[-119.79526, 34.4592], [-119.79501, 34.45939], [-119.79428, 34.45963], [-119.79402, 34.45956], [-119.79374, 34.45963], [-119.79341, 34.45957], [-119.79319, 34.45991], [-119.79298, 34.45997], [-119.79289, 34.45965], [-119.79349, 34.45947], [-119.79401, 34.45938], [-119.79428, 34.45928], [-119.79438, 34.45922], [-119.79483, 34.45924], [-119.79525, 34.45902], [-119.79526, 34.4592]]]]} | Unknown Access 4 | 17594 | Maria Ygnacia Creek | 21810 | 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 | 28.798 | Maria Ygnacia Creek | 0 | Local Other or Unknown 14 | 4 | |
10200 | 10200 | 10199 | {"type": "MultiPolygon", "coordinates": [[[[-122.12695, 37.15886], [-122.12688, 37.15908], [-122.12693, 37.15949], [-122.12686, 37.1596], [-122.12676, 37.15972], [-122.12663, 37.15982], [-122.12646, 37.15991], [-122.12603, 37.16008], [-122.12577, 37.16023], [-122.12556, 37.16043], [-122.12542, 37.16067], [-122.12536, 37.16093], [-122.12534, 37.16109], [-122.1253, 37.16125], [-122.12469, 37.16238], [-122.12442, 37.16276], [-122.12403, 37.16305], [-122.12382, 37.16311], [-122.12368, 37.16339], [-122.12366, 37.16406], [-122.12331, 37.16443], [-122.12297, 37.16476], [-122.12282, 37.16546], [-122.11806, 37.16587], [-122.11653, 37.16016], [-122.11657, 37.15906], [-122.12571, 37.15915], [-122.12695, 37.15886]]], [[[-122.13103, 37.16474], [-122.13043, 37.16479], [-122.12301, 37.16544], [-122.12314, 37.16482], [-122.12374, 37.16422], [-122.12388, 37.164], [-122.12399, 37.16337], [-122.12412, 37.16317], [-122.12456, 37.16284], [-122.12467, 37.16271], [-122.12485, 37.16244], [-122.1251, 37.162], [-122.12546, 37.16129], [-122.1255, 37.16116], [-122.12553, 37.16093], [-122.12561, 37.16064], [-122.12581, 37.16039], [-122.12611, 37.1602], [-122.12648, 37.16009], [-122.1268, 37.15992], [-122.12704, 37.15968], [-122.12714, 37.15952], [-122.12708, 37.15901], [-122.12714, 37.15882], [-122.13035, 37.15808], [-122.13103, 37.16474]]]]} | Open Access 1 | 17835 | Miller Property County Park | 22248 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 208.728 | Miller Property County Park | 0 | Local Other or Unknown 14 | 4 | |
10361 | 10361 | 10360 | {"type": "Polygon", "coordinates": [[[-120.11686, 34.66391], [-120.11686, 34.66443], [-120.11666, 34.66443], [-120.11667, 34.6639], [-120.11686, 34.66391]]]} | Open Access 1 | 18384 | Alamo Pintado Creek | 15318 | 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 | 0.262 | Alamo Pintado Creek | 0 | Local Other or Unknown 14 | 4 | |
10537 | 10537 | 10536 | {"type": "Polygon", "coordinates": [[[-117.11988, 33.71789], [-117.11539, 33.71793], [-117.11537, 33.72508], [-117.11986, 33.72504], [-117.11979, 33.72862], [-117.1023, 33.72895], [-117.10226, 33.72172], [-117.10216, 33.7145], [-117.10576, 33.71446], [-117.10651, 33.71438], [-117.11099, 33.71433], [-117.11139, 33.71453], [-117.11318, 33.71473], [-117.11586, 33.71436], [-117.11982, 33.71433], [-117.11988, 33.71789]]]} | Open Access 1 | 18750 | Double Butte Park Property | 18237 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 560.311 | Double Butte Park Property | 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]);