units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,989 rows where DES_TP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 109
- Los Angeles, City of 49
- Mountains Recreation and Conservation Authority 37
- Conejo Open Space Conservation Agency 28
- San Francisco, City and County of 26
- East Bay Regional Park District 21
- Los Angeles, County of 20
- Davis, City of 20
- San Luis Obispo, City of 17
- Santa Clarita, City of 17
- Thousand Oaks, City of 14
- Sacramento, City of 14
- Glendale, City of 13
- Vacaville, City of 12
- Long Beach, City of 12
- Tiburon, Town of 12
- Sunrise Recreation and Park District 12
- Santa Barbara, County of 11
- Santa Cruz, City of 11
- San Marcos, City of 10
- Los Angeles - Department of Parks and Recreation, County of 9
- Sacramento, County of 9
- Las Virgenes Municipal Water District 8
- East Bay Municipal Utility District 8
- Littlerock Creek Irrigation District 8
- Oakland, City of 7
- Poway, City of 7
- Roseville, City of 7
- Rancho Simi Recreation and Park District 6
- Carlsbad, City of 6
- …
MNG_AG_TYP 17
- City Agency 751
- Recreation/Parks District 112
- County Agency 74
- Open Space District 66
- Water District 34
- County Agency - Parks 21
- Irrigation District 14
- Community Services District 8
- County Agency - Other 3
- Flood District 3
- School District 2
- Cemetery District 1
- Port/Harbor District 1
- Sanitation District 1
- Special District - Other 1
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 887
- Restricted Access 147
- No Public Access 51
- Unknown Access 9
DES_TP 1
- Local Recreation Area · 1,094 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9463 | 9463 | 9462 | {"type": "Polygon", "coordinates": [[[-118.7507, 34.16758], [-118.75065, 34.16768], [-118.75057, 34.16764], [-118.75062, 34.16755], [-118.7507, 34.16758]]]} | No Public Access 3 | 12424 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.027 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
9464 | 9464 | 9463 | {"type": "Polygon", "coordinates": [[[-118.85099, 34.21159], [-118.8503, 34.21154], [-118.8503, 34.21143], [-118.84988, 34.21124], [-118.84971, 34.21097], [-118.84963, 34.21041], [-118.84965, 34.21015], [-118.84964, 34.20969], [-118.84969, 34.20932], [-118.84971, 34.20895], [-118.84985, 34.20843], [-118.85001, 34.20788], [-118.85019, 34.20741], [-118.85041, 34.20703], [-118.85075, 34.20653], [-118.85074, 34.21121], [-118.85099, 34.21159]]]} | Open Access 1 | 15840 | Fiore Playfield | 18906 | 1347 | Thousand Oaks, City of 428 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | Ventura 8 | 10.483 | Fiore Playfield | 0 | Local Recreation Area 3 | 4 | |
9467 | 9467 | 9466 | {"type": "Polygon", "coordinates": [[[-118.79539, 34.10451], [-118.79505, 34.10457], [-118.79501, 34.10437], [-118.79516, 34.10434], [-118.79538, 34.10447], [-118.79539, 34.10451]]]} | No Public Access 3 | 12425 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.136 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
9469 | 9469 | 9468 | {"type": "Polygon", "coordinates": [[[-118.66968, 34.13331], [-118.66965, 34.13376], [-118.66961, 34.13403], [-118.6695, 34.13402], [-118.66949, 34.13387], [-118.66933, 34.13366], [-118.6693, 34.13358], [-118.66931, 34.1335], [-118.66934, 34.13343], [-118.6694, 34.13337], [-118.6696, 34.13328], [-118.66963, 34.13328], [-118.66968, 34.13331]]]} | No Public Access 3 | 12426 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.465 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
9475 | 9475 | 9474 | {"type": "Polygon", "coordinates": [[[-121.99706, 37.85874], [-121.99272, 37.85889], [-121.99271, 37.85879], [-121.99179, 37.85882], [-121.99177, 37.85859], [-121.99113, 37.85861], [-121.99114, 37.85894], [-121.98799, 37.85902], [-121.98802, 37.85534], [-121.98347, 37.85552], [-121.9834, 37.85198], [-121.98093, 37.85206], [-121.98203, 37.84983], [-121.98481, 37.84974], [-121.98472, 37.84989], [-121.98475, 37.85233], [-121.98792, 37.85218], [-121.98792, 37.85182], [-121.99283, 37.85166], [-121.99236, 37.85244], [-121.99237, 37.8527], [-121.99281, 37.85361], [-121.99269, 37.85461], [-121.9942, 37.85475], [-121.99566, 37.85534], [-121.99601, 37.85511], [-121.997, 37.85504], [-121.99706, 37.85874]]]} | Open Access 1 | 17309 | Las Trampas/Diablo Regional Trail | 21069 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 174.441 | Las Trampas/Diablo Reg. Trail | 1976 | Local Recreation Area 3 | 4 | |
9485 | 9485 | 9484 | {"type": "Polygon", "coordinates": [[[-121.68811, 38.16638], [-121.68698, 38.16787], [-121.68549, 38.16698], [-121.68678, 38.16568], [-121.68811, 38.16638]]]} | Open Access 1 | 15913 | Egbert Field | 18465 | 1276 | Rio Vista, City of 327 | City 2 | City Agency 2 | http://riovistacity.com/parks-dept/ | City 2 | 1276 | Rio Vista, City of 324 | City 2 | City Agency 2 | Solano 26 | 7.057 | Egbert Field | 0 | Local Recreation Area 3 | 4 | |
9491 | 9491 | 9490 | {"type": "MultiPolygon", "coordinates": [[[[-122.09248, 37.63911], [-122.0841, 37.6505], [-122.08146, 37.65183], [-122.07932, 37.65272], [-122.07691, 37.65391], [-122.07795, 37.65562], [-122.07648, 37.65631], [-122.07596, 37.6575], [-122.07548, 37.65686], [-122.0758, 37.65603], [-122.07718, 37.65545], [-122.07612, 37.65385], [-122.07844, 37.65278], [-122.07985, 37.65207], [-122.08117, 37.65159], [-122.08237, 37.65106], [-122.0835, 37.65035], [-122.09167, 37.63886], [-122.09176, 37.63896], [-122.09222, 37.63912], [-122.09248, 37.63911]]], [[[-122.09853, 37.63425], [-122.09587, 37.63524], [-122.0951, 37.63524], [-122.09477, 37.63517], [-122.09827, 37.63389], [-122.09853, 37.63425]]], [[[-122.10894, 37.62975], [-122.10565, 37.63124], [-122.0989, 37.63411], [-122.09867, 37.63374], [-122.10872, 37.62921], [-122.10894, 37.62975]]]]} | Open Access 1 | 15886 | Eden Greenway | 18427 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 54.736 | Eden Greenway | 1970 | Local Recreation Area 3 | 4 | |
9501 | 9501 | 9500 | {"type": "Polygon", "coordinates": [[[-122.44471, 37.74683], [-122.4447, 37.74687], [-122.44467, 37.7469], [-122.44451, 37.74695], [-122.44426, 37.74709], [-122.44415, 37.74719], [-122.44401, 37.74738], [-122.44342, 37.74741], [-122.44391, 37.74694], [-122.44406, 37.74685], [-122.44409, 37.74683], [-122.44413, 37.74684], [-122.44415, 37.74681], [-122.44447, 37.74677], [-122.44465, 37.74678], [-122.44468, 37.7468], [-122.44471, 37.74683]]]} | Open Access 1 | 15912 | Portola Open Space | 23909 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.814 | Portola OS | 0 | Local Recreation Area 3 | 4 | |
9508 | 9508 | 9507 | {"type": "Polygon", "coordinates": [[[-120.64765, 35.28009], [-120.64706, 35.28043], [-120.64684, 35.28024], [-120.64756, 35.28002], [-120.64765, 35.28009]]]} | Open Access 1 | 17375 | Lizzie Street Open Space | 21387 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.329 | Lizzie Street OS | 0 | Local Recreation Area 3 | 4 | |
9521 | 9521 | 9520 | {"type": "Polygon", "coordinates": [[[-118.32587, 33.74145], [-118.32586, 33.74173], [-118.32563, 33.74185], [-118.32541, 33.7416], [-118.32474, 33.74161], [-118.32422, 33.74153], [-118.32393, 33.74164], [-118.32391, 33.74158], [-118.32401, 33.74154], [-118.32401, 33.74153], [-118.32329, 33.74095], [-118.32212, 33.74084], [-118.3217, 33.74095], [-118.32093, 33.74221], [-118.32075, 33.74221], [-118.32176, 33.74053], [-118.32318, 33.74066], [-118.32402, 33.74133], [-118.32477, 33.74147], [-118.32587, 33.74145]]]} | Open Access 1 | 47832 | Colinita Trail | 31775 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 3.136 | Colinita Trail | 0 | Local Recreation Area 3 | 4 | |
9524 | 9524 | 9523 | {"type": "Polygon", "coordinates": [[[-122.49333, 38.50768], [-122.49296, 38.50786], [-122.49183, 38.50759], [-122.49114, 38.50768], [-122.49113, 38.50772], [-122.49114, 38.50773], [-122.49184, 38.50764], [-122.4929, 38.5079], [-122.49098, 38.5088], [-122.49102, 38.50907], [-122.491, 38.50922], [-122.49111, 38.50939], [-122.49104, 38.50958], [-122.49103, 38.50969], [-122.49109, 38.50985], [-122.49117, 38.50995], [-122.49131, 38.51002], [-122.49138, 38.51015], [-122.49154, 38.5103], [-122.49176, 38.51044], [-122.49192, 38.51051], [-122.492, 38.51069], [-122.49219, 38.51095], [-122.49231, 38.51104], [-122.49215, 38.51106], [-122.49185, 38.51078], [-122.49147, 38.5106], [-122.49134, 38.51062], [-122.49123, 38.51052], [-122.4911, 38.51045], [-122.49096, 38.51045], [-122.49034, 38.5106], [-122.49018, 38.51059], [-122.49018, 38.51015], [-122.49013, 38.50988], [-122.48998, 38.50966], [-122.48996, 38.50957], [-122.48978, 38.5094], [-122.48972, 38.5094], [-122.48965, 38.50949], [-122.48944, 38.50929], [-122.48909, 38.50891], [-122.48809, 38.50959], [-122.48786, 38.50934], [-122.48797, 38.50927], [-122.48838, 38.50825], [-122.4881, 38.50806], [-122.48589, 38.50731], [-122.48671, 38.50627], [-122.48724, 38.50668], [-122.4877, 38.50671], [-122.48799, 38.50689], [-122.4889, 38.50694], [-122.48919, 38.50685], [-122.48964, 38.50654], [-122.48983, 38.50626], [-122.48995, 38.50621], [-122.49019, 38.50616], [-122.49057, 38.50612], [-122.49087, 38.5062], [-122.49088, 38.50637], [-122.4912, 38.50642], [-122.49241, 38.50717], [-122.493, 38.50732], [-122.49333, 38.50768]]]} | No Public Access 3 | 15977 | Lower Reservoir | 21564 | 1290 | Saint Helena, City of 422 | City 2 | City Agency 2 | http://cityofsthelena.org/parks-recreation | City 2 | 1290 | Saint Helena, City of 416 | City 2 | City Agency 2 | Napa 11 | 34.792 | Lower Reservoir | 0 | Local Recreation Area 3 | 4 | |
9525 | 9525 | 9524 | {"type": "MultiPolygon", "coordinates": [[[[-122.43837, 38.49699], [-122.43988, 38.49829], [-122.44033, 38.49865], [-122.43614, 38.50173], [-122.43599, 38.50173], [-122.43555, 38.50177], [-122.43473, 38.50177], [-122.4346, 38.50175], [-122.4345, 38.5017], [-122.43442, 38.50161], [-122.43423, 38.50124], [-122.43401, 38.50105], [-122.4339, 38.50097], [-122.4338, 38.50074], [-122.4337, 38.50062], [-122.43318, 38.50009], [-122.43294, 38.49986], [-122.4327, 38.49966], [-122.4325, 38.49925], [-122.43254, 38.49869], [-122.43253, 38.49819], [-122.43249, 38.4981], [-122.4324, 38.49799], [-122.43222, 38.49783], [-122.43211, 38.49776], [-122.43189, 38.49766], [-122.43167, 38.49762], [-122.43154, 38.4976], [-122.43098, 38.49761], [-122.43134, 38.49755], [-122.43134, 38.49754], [-122.43114, 38.49743], [-122.43352, 38.49571], [-122.4369, 38.49338], [-122.43828, 38.49458], [-122.4368, 38.49571], [-122.43837, 38.49699]]], [[[-122.46464, 38.51291], [-122.46285, 38.51541], [-122.46252, 38.5151], [-122.46227, 38.51482], [-122.46185, 38.51443], [-122.46164, 38.51433], [-122.46151, 38.51431], [-122.46109, 38.51427], [-122.46078, 38.51426], [-122.46232, 38.51217], [-122.46227, 38.51226], [-122.46298, 38.51254], [-122.46311, 38.51237], [-122.46464, 38.51291]]]]} | No Public Access 3 | 15980 | St Helena Wastewater Treatment Field | 25762 | 1290 | Saint Helena, City of 422 | City 2 | City Agency 2 | http://cityofsthelena.org/parks-recreation | City 2 | 1290 | Saint Helena, City of 416 | City 2 | City Agency 2 | Napa 11 | 108.217 | St Helena Wastewater Treatment Field | 0 | Local Recreation Area 3 | 4 | |
9526 | 9526 | 9525 | {"type": "Polygon", "coordinates": [[[-122.49213, 38.55407], [-122.4921, 38.55514], [-122.49007, 38.55516], [-122.49014, 38.55796], [-122.49014, 38.55878], [-122.48984, 38.5588], [-122.48659, 38.56392], [-122.48242, 38.5639], [-122.48233, 38.55908], [-122.48077, 38.55917], [-122.48076, 38.55875], [-122.47996, 38.55875], [-122.47995, 38.55606], [-122.48094, 38.55589], [-122.48093, 38.55317], [-122.48554, 38.55315], [-122.48553, 38.55216], [-122.48468, 38.55149], [-122.48316, 38.5515], [-122.48315, 38.55125], [-122.4831, 38.5512], [-122.48307, 38.55064], [-122.48356, 38.55098], [-122.48489, 38.5514], [-122.48496, 38.55146], [-122.48498, 38.55149], [-122.48552, 38.55192], [-122.48553, 38.55191], [-122.48813, 38.55396], [-122.48848, 38.5542], [-122.48872, 38.55429], [-122.48904, 38.55434], [-122.48961, 38.55429], [-122.49008, 38.55422], [-122.49213, 38.55407]]]} | No Public Access 3 | 15982 | Bell Canyon Reservoir | 15971 | 1290 | Saint Helena, City of 422 | City 2 | City Agency 2 | http://cityofsthelena.org/parks-recreation | City 2 | 1290 | Saint Helena, City of 416 | City 2 | City Agency 2 | Napa 11 | 206.019 | Bell Canyon Reservoir | 0 | Local Recreation Area 3 | 4 | |
9527 | 9527 | 9526 | {"type": "Polygon", "coordinates": [[[-122.61605, 38.62512], [-122.61376, 38.62739], [-122.60677, 38.62506], [-122.60683, 38.62492], [-122.60683, 38.62491], [-122.60407, 38.62493], [-122.60408, 38.62146], [-122.59921, 38.62147], [-122.59909, 38.61781], [-122.60673, 38.61786], [-122.61018, 38.6186], [-122.61047, 38.6187], [-122.6109, 38.61796], [-122.61335, 38.61401], [-122.6132, 38.61741], [-122.61476, 38.62026], [-122.61398, 38.62097], [-122.61602, 38.62399], [-122.61605, 38.62512]]]} | No Public Access 3 | 15986 | Kimball Reservoir | 20646 | 1042 | Calistoga, City of 774 | City 2 | City Agency 2 | http://www.ci.calistoga.ca.us/ | City 2 | 1042 | Calistoga, City of 755 | City 2 | City Agency 2 | Napa 11 | 258.548 | Kimball Reservoir | 0 | Local Recreation Area 3 | 4 | |
9533 | 9533 | 9532 | {"type": "MultiPolygon", "coordinates": [[[[-122.51315, 38.05379], [-122.51268, 38.05366], [-122.51238, 38.05376], [-122.51214, 38.05378], [-122.51202, 38.0536], [-122.51195, 38.05346], [-122.51195, 38.05327], [-122.51223, 38.05306], [-122.51217, 38.05276], [-122.51304, 38.05286], [-122.51315, 38.05326], [-122.51315, 38.05379]]], [[[-122.51392, 38.05262], [-122.51377, 38.05276], [-122.51341, 38.05284], [-122.51323, 38.0528], [-122.51308, 38.05257], [-122.51302, 38.05234], [-122.51312, 38.05205], [-122.51344, 38.05197], [-122.5138, 38.05213], [-122.51392, 38.05262]]]]} | Open Access 1 | 16047 | Hamilton Officers Club | 19617 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 3.73 | Hamilton Officers Club | 0 | Local Recreation Area 3 | 4 | |
9534 | 9534 | 9533 | {"type": "MultiPolygon", "coordinates": [[[[-118.32508, 33.74836], [-118.32478, 33.74839], [-118.32442, 33.74859], [-118.3242, 33.74879], [-118.32384, 33.74839], [-118.32179, 33.74742], [-118.32161, 33.74723], [-118.32105, 33.74759], [-118.32094, 33.74748], [-118.3215, 33.74711], [-118.32094, 33.7465], [-118.32031, 33.74623], [-118.3199, 33.74579], [-118.31989, 33.7457], [-118.32, 33.74568], [-118.3201, 33.74562], [-118.32024, 33.74572], [-118.32031, 33.74572], [-118.32037, 33.74575], [-118.32054, 33.74589], [-118.32066, 33.74602], [-118.32075, 33.74605], [-118.32085, 33.74605], [-118.32097, 33.74599], [-118.32102, 33.7459], [-118.32101, 33.74581], [-118.32091, 33.74564], [-118.32093, 33.74564], [-118.32142, 33.74604], [-118.32229, 33.74651], [-118.32269, 33.74631], [-118.32274, 33.74637], [-118.32235, 33.74655], [-118.32235, 33.74656], [-118.32345, 33.74762], [-118.32367, 33.74772], [-118.32395, 33.74742], [-118.32419, 33.74758], [-118.32394, 33.74788], [-118.32439, 33.74816], [-118.32474, 33.74814], [-118.32486, 33.74801], [-118.32498, 33.74812], [-118.32504, 33.74824], [-118.32508, 33.74836]]], [[[-118.32085, 33.74589], [-118.32081, 33.74592], [-118.32078, 33.74592], [-118.32066, 33.74579], [-118.32054, 33.74569], [-118.32074, 33.74566], [-118.32085, 33.74585], [-118.32085, 33.74589]]]]} | Open Access 1 | 47835 | Sienna Loop Trail | 31777 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 9.915 | Sienna Loop Trail | 0 | Local Recreation Area 3 | 4 | |
9545 | 9545 | 9544 | {"type": "Polygon", "coordinates": [[[-122.46118, 37.87759], [-122.45971, 37.87832], [-122.45958, 37.87819], [-122.45957, 37.87799], [-122.45885, 37.87784], [-122.45815, 37.87728], [-122.45822, 37.87699], [-122.45809, 37.87672], [-122.45816, 37.87668], [-122.45819, 37.87673], [-122.45856, 37.87686], [-122.45859, 37.87692], [-122.45916, 37.87712], [-122.45932, 37.87708], [-122.45968, 37.87719], [-122.45991, 37.87676], [-122.46026, 37.87689], [-122.46044, 37.87756], [-122.46109, 37.87757], [-122.46118, 37.87759]]]} | Open Access 1 | 16017 | Point Tiburon Marsh Open Space | 31727 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 5.403 | Point Tiburon Marsh OS | 0 | Local Recreation Area 3 | 4 | |
9548 | 9548 | 9547 | {"type": "Polygon", "coordinates": [[[-118.31871, 33.75148], [-118.3186, 33.75159], [-118.3186, 33.7517], [-118.31842, 33.75196], [-118.31843, 33.74806], [-118.31846, 33.74607], [-118.31864, 33.74623], [-118.31866, 33.74651], [-118.31866, 33.7466], [-118.31862, 33.74662], [-118.31859, 33.75138], [-118.31871, 33.75148]]]} | Open Access 1 | 47839 | Lorraine Trail | 31782 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 2.557 | Lorraine Trail | 0 | Local Recreation Area 3 | 4 | |
9561 | 9561 | 9560 | {"type": "Polygon", "coordinates": [[[-122.55636, 38.10843], [-122.55629, 38.10852], [-122.55601, 38.10863], [-122.55542, 38.10906], [-122.5552, 38.10902], [-122.55477, 38.10847], [-122.555, 38.10787], [-122.55636, 38.10843]]]} | Open Access 1 | 16068 | Humman Field | 20147 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 2.401 | Humman Field | 0 | Local Recreation Area 3 | 4 | |
9576 | 9576 | 9575 | {"type": "Polygon", "coordinates": [[[-122.61166, 38.265], [-122.61098, 38.26576], [-122.60488, 38.26235], [-122.6057, 38.26144], [-122.60662, 38.26161], [-122.60843, 38.26232], [-122.60952, 38.26339], [-122.61136, 38.26423], [-122.61166, 38.265]]]} | Open Access 1 | 47844 | Petaluma Community Sports Fields | 31786 | 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 | http://cityofpetaluma.net/parksnrec/parks-pages/petaluma-comm-sport-fields.html | Sonoma 16 | 24.892 | Petaluma Community Sports Fields | 2015 | Local Recreation Area 3 | 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]);