units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,640 rows where ACCESS_TYP = 1 and DES_TP = 3 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 1,640 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16865 | 16865 | 16864 | {"type": "Polygon", "coordinates": [[[-122.05729, 37.69054], [-122.05732, 37.69085], [-122.05729, 37.69148], [-122.05633, 37.69209], [-122.05634, 37.6921], [-122.05717, 37.69218], [-122.05717, 37.69221], [-122.05697, 37.6922], [-122.05678, 37.69223], [-122.05659, 37.69231], [-122.05652, 37.6924], [-122.05651, 37.69247], [-122.05681, 37.69276], [-122.05683, 37.69285], [-122.054, 37.69283], [-122.05267, 37.69268], [-122.05186, 37.69251], [-122.05066, 37.6925], [-122.04958, 37.69254], [-122.04867, 37.69261], [-122.04792, 37.69283], [-122.04737, 37.69305], [-122.04695, 37.69323], [-122.04462, 37.69495], [-122.04445, 37.69518], [-122.0443, 37.69495], [-122.04441, 37.69486], [-122.0444, 37.69484], [-122.04436, 37.69484], [-122.04435, 37.69471], [-122.04447, 37.69457], [-122.04474, 37.69442], [-122.04516, 37.69407], [-122.04494, 37.69362], [-122.04498, 37.69344], [-122.04451, 37.69339], [-122.0444, 37.69311], [-122.04449, 37.69281], [-122.04454, 37.69281], [-122.04455, 37.6928], [-122.04437, 37.69253], [-122.04448, 37.69232], [-122.04501, 37.69184], [-122.0468, 37.69227], [-122.04681, 37.69226], [-122.04649, 37.69079], [-122.04436, 37.68999], [-122.0459, 37.68885], [-122.04634, 37.68978], [-122.04766, 37.69015], [-122.04857, 37.69003], [-122.04902, 37.69009], [-122.04925, 37.69005], [-122.04971, 37.68979], [-122.0496, 37.68951], [-122.05131, 37.68901], [-122.05114, 37.68863], [-122.05124, 37.68858], [-122.05202, 37.69024], [-122.0525, 37.69017], [-122.05276, 37.68967], [-122.05267, 37.6895], [-122.05299, 37.6894], [-122.05313, 37.68929], [-122.05364, 37.68902], [-122.05376, 37.68926], [-122.05485, 37.68961], [-122.05486, 37.6896], [-122.05485, 37.68952], [-122.05486, 37.68945], [-122.05493, 37.68947], [-122.05512, 37.68946], [-122.05515, 37.6897], [-122.05513, 37.6897], [-122.05511, 37.68989], [-122.0562, 37.68985], [-122.05698, 37.69056], [-122.05729, 37.69054]]]} | Open Access 1 | 49046 | Don Castro Regional Recreation Area | 18199 | 2000 | Alameda County Flood Control and Water Conservation District 771 | Special District 4 | Flood District 8 | http://acfloodcontrol.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | https://www.ebparks.org/parks/don_castro/ | Alameda 17 | 91.383 | Don Castro Reg. Rec. Area | 1969 | Local Recreation Area 3 | 4 |
10105 | 10105 | 10104 | {"type": "MultiPolygon", "coordinates": [[[[-121.97369, 37.93539], [-121.97365, 37.93544], [-121.96855, 37.93551], [-121.96867, 37.93545], [-121.97369, 37.93539]]], [[[-121.96826, 37.93546], [-121.96797, 37.93555], [-121.96726, 37.9357], [-121.96694, 37.93579], [-121.96664, 37.93591], [-121.96636, 37.93605], [-121.9661, 37.93622], [-121.96586, 37.93641], [-121.96569, 37.93657], [-121.96412, 37.93819], [-121.96404, 37.93818], [-121.96563, 37.93653], [-121.96585, 37.93633], [-121.9661, 37.93614], [-121.96637, 37.93598], [-121.96666, 37.93583], [-121.96696, 37.93572], [-121.96728, 37.93563], [-121.96782, 37.93553], [-121.96807, 37.93546], [-121.96826, 37.93546]]], [[[-121.96407, 37.93824], [-121.96335, 37.93918], [-121.96327, 37.9393], [-121.96312, 37.9396], [-121.96305, 37.93961], [-121.96316, 37.93934], [-121.96329, 37.93915], [-121.96399, 37.93823], [-121.96407, 37.93824]]], [[[-121.963, 37.93975], [-121.96304, 37.93978], [-121.96305, 37.93982], [-121.96283, 37.94043], [-121.96271, 37.94113], [-121.96265, 37.94118], [-121.96266, 37.94099], [-121.96275, 37.9405], [-121.96283, 37.9402], [-121.963, 37.93975]]], [[[-121.967, 37.94522], [-121.96692, 37.94523], [-121.96688, 37.94515], [-121.96663, 37.94479], [-121.96609, 37.94436], [-121.96423, 37.94346], [-121.96463, 37.94293], [-121.96447, 37.94288], [-121.96422, 37.94261], [-121.9641, 37.94241], [-121.96396, 37.94225], [-121.96369, 37.94199], [-121.96305, 37.94148], [-121.96287, 37.94147], [-121.9629, 37.94142], [-121.96307, 37.94142], [-121.96377, 37.94198], [-121.96401, 37.94221], [-121.96416, 37.94238], [-121.96429, 37.94259], [-121.96452, 37.94283], [-121.96475, 37.9429], [-121.96435, 37.94345], [-121.96617, 37.94432], [-121.96669, 37.94476], [-121.96695, 37.94513], [-121.967, 37.94522]]], [[[-121.96761, 37.94557], [-121.96754, 37.94563], [-121.96714, 37.94565], [-121.96699, 37.94536], [-121.96707, 37.94535], [-121.9672, 37.94559], [-121.96761, 37.94557]]], [[[-122.08253, 37.97602], [-122.08247, 37.97608], [-122.08181, 37.97609], [-122.08181, 37.97604], [-122.08253, 37.97602]]], [[[-122.08523, 37.97718], [-122.08516, 37.97722], [-122.08511, 37.97722], [-122.08497, 37.97714], [-122.08485, 37.9771], [-122.08446, 37.97706], [-122.08405, 37.97641], [-122.08396, 37.97618], [-122.08386, 37.97606], [-122.08269, 37.97608], [-122.08276, 37.97602], [-122.08396, 37.976], [-122.08396, 37.97605], [-122.08403, 37.97614], [-122.08409, 37.97627], [-122.08413, 37.97639], [-122.08447, 37.97693], [-122.08458, 37.977], [-122.08484, 37.97704], [-122.08507, 37.97712], [-122.08514, 37.97711], [-122.08523, 37.97718]]]]} | Open Access 1 | 49044 | California Riding and Hiking Trail | 33750 | 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 | https://www.ebparks.org/parks/trails/california/default.htm | Contra Costa 12 | 3.625 | California Riding and Hiking Trail | 1982 | Local Recreation Area 3 | 4 |
16813 | 16813 | 16812 | {"type": "MultiPolygon", "coordinates": [[[[-121.24935, 38.79757], [-121.24887, 38.7976], [-121.24888, 38.79736], [-121.24862, 38.79729], [-121.2486, 38.79701], [-121.24788, 38.79639], [-121.24756, 38.79629], [-121.24638, 38.79603], [-121.24591, 38.79611], [-121.24558, 38.79621], [-121.24526, 38.79664], [-121.24512, 38.79694], [-121.24485, 38.79709], [-121.24378, 38.7975], [-121.24094, 38.79876], [-121.24094, 38.79877], [-121.24112, 38.79902], [-121.24073, 38.79922], [-121.24054, 38.79896], [-121.23974, 38.79931], [-121.23958, 38.79911], [-121.23981, 38.7985], [-121.23945, 38.79817], [-121.2406, 38.79786], [-121.24375, 38.79649], [-121.2443, 38.79581], [-121.24429, 38.7958], [-121.2442, 38.7958], [-121.24484, 38.79531], [-121.24604, 38.79445], [-121.24636, 38.79473], [-121.24652, 38.79518], [-121.24729, 38.79541], [-121.2479, 38.79543], [-121.24805, 38.79534], [-121.24878, 38.79605], [-121.24909, 38.79654], [-121.24928, 38.79708], [-121.24934, 38.79735], [-121.24935, 38.79757]]], [[[-121.25255, 38.7998], [-121.25223, 38.80002], [-121.25251, 38.80029], [-121.25098, 38.80127], [-121.24815, 38.80405], [-121.24782, 38.80431], [-121.24743, 38.80455], [-121.24494, 38.8056], [-121.24452, 38.80574], [-121.24407, 38.80574], [-121.24396, 38.80605], [-121.24361, 38.80596], [-121.2433, 38.80581], [-121.24304, 38.80562], [-121.24284, 38.80538], [-121.24271, 38.80511], [-121.24237, 38.80408], [-121.24228, 38.80386], [-121.24216, 38.80366], [-121.242, 38.80347], [-121.24184, 38.80331], [-121.24168, 38.80319], [-121.24194, 38.80296], [-121.24086, 38.80233], [-121.24045, 38.80189], [-121.24021, 38.80132], [-121.24015, 38.8003], [-121.24006, 38.80006], [-121.24075, 38.79973], [-121.24057, 38.79946], [-121.24109, 38.79923], [-121.24126, 38.79947], [-121.24142, 38.79983], [-121.24149, 38.80031], [-121.24174, 38.80044], [-121.24236, 38.80036], [-121.24253, 38.80015], [-121.2423, 38.79946], [-121.2421, 38.79913], [-121.24418, 38.79821], [-121.24535, 38.79776], [-121.24594, 38.79761], [-121.24654, 38.79765], [-121.2474, 38.79783], [-121.24743, 38.79896], [-121.24579, 38.79935], [-121.24484, 38.79916], [-121.24397, 38.7995], [-121.244, 38.80063], [-121.24357, 38.80114], [-121.24342, 38.80191], [-121.24445, 38.80209], [-121.24565, 38.80187], [-121.24573, 38.80237], [-121.24541, 38.80249], [-121.24543, 38.80279], [-121.24583, 38.80285], [-121.2465, 38.80259], [-121.24734, 38.80186], [-121.24764, 38.80162], [-121.24906, 38.80072], [-121.24952, 38.80026], [-121.25005, 38.79988], [-121.2504, 38.79967], [-121.25064, 38.79948], [-121.25112, 38.799], [-121.25148, 38.79878], [-121.25255, 38.7998]]], [[[-121.26336, 38.7949], [-121.26216, 38.79573], [-121.26081, 38.79691], [-121.25822, 38.79824], [-121.25393, 38.79935], [-121.25344, 38.79967], [-121.25314, 38.79939], [-121.25282, 38.7996], [-121.25177, 38.7986], [-121.2521, 38.7984], [-121.25393, 38.79763], [-121.25471, 38.79763], [-121.25541, 38.7972], [-121.25571, 38.79678], [-121.25665, 38.79627], [-121.25694, 38.7964], [-121.25724, 38.79647], [-121.25756, 38.79649], [-121.25786, 38.79645], [-121.25816, 38.79633], [-121.25931, 38.79573], [-121.25953, 38.79557], [-121.26037, 38.79477], [-121.26072, 38.7945], [-121.26198, 38.79366], [-121.26336, 38.7949]]]]} | Open Access 1 | 49034 | Sunset Whitney Recreation Area | 33741 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | https://www.rocklin.ca.us/news/west-trails-sunset-whitney-rec-area-now-open | Placer 35 | 178.722 | Sunset Whitney Rec. Area | 2018 | Local Recreation Area 3 | 4 |
10033 | 10033 | 10032 | {"type": "Polygon", "coordinates": [[[-118.99143, 34.15817], [-118.99103, 34.15857], [-118.99079, 34.15858], [-118.99057, 34.15855], [-118.99035, 34.15849], [-118.99016, 34.1584], [-118.98998, 34.15826], [-118.98983, 34.1581], [-118.98903, 34.15682], [-118.98894, 34.1567], [-118.98881, 34.15658], [-118.98867, 34.15647], [-118.98851, 34.15638], [-118.98833, 34.15631], [-118.98984, 34.15631], [-118.99122, 34.15735], [-118.99143, 34.15817]]]} | Open Access 1 | 49022 | Vista Del Mar Open Space | 33722 | 1347 | Thousand Oaks, City of 428 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/vista-del-mar.html | Ventura 8 | 8.702 | Vista Del Mar OS | 2008 | Local Recreation Area 3 | 4 |
15391 | 15391 | 15390 | {"type": "Polygon", "coordinates": [[[-118.96432, 34.19047], [-118.96431, 34.19886], [-118.95984, 34.19957], [-118.95976, 34.19948], [-118.95916, 34.19971], [-118.95836, 34.19959], [-118.95836, 34.19945], [-118.95848, 34.19888], [-118.95918, 34.19877], [-118.95999, 34.19653], [-118.96333, 34.19652], [-118.96333, 34.19525], [-118.96347, 34.19524], [-118.96347, 34.19389], [-118.96193, 34.19396], [-118.96116, 34.19173], [-118.96135, 34.19081], [-118.96021, 34.1908], [-118.96029, 34.19047], [-118.96432, 34.19047]]]} | Open Access 1 | 49021 | Vallecito Open Space | 33721 | 1347 | Thousand Oaks, City of 428 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/vallecito.html | Ventura 8 | 66.788 | Vallecito OS | 0 | Local Recreation Area 3 | 4 |
16134 | 16134 | 16133 | {"type": "MultiPolygon", "coordinates": [[[[-118.84396, 34.18135], [-118.84354, 34.18198], [-118.84351, 34.18206], [-118.84351, 34.18217], [-118.84286, 34.18235], [-118.84309, 34.18273], [-118.84379, 34.18315], [-118.84304, 34.18341], [-118.84304, 34.18415], [-118.84239, 34.18414], [-118.84224, 34.18387], [-118.84189, 34.18386], [-118.84152, 34.18352], [-118.84135, 34.18332], [-118.84135, 34.1833], [-118.84121, 34.18314], [-118.84115, 34.18291], [-118.84074, 34.18309], [-118.84072, 34.18302], [-118.84106, 34.18289], [-118.84133, 34.18271], [-118.84151, 34.18244], [-118.84161, 34.18221], [-118.84195, 34.18161], [-118.84184, 34.18131], [-118.84152, 34.18114], [-118.84126, 34.18108], [-118.84118, 34.18118], [-118.8411, 34.18136], [-118.84118, 34.18156], [-118.84117, 34.18164], [-118.84123, 34.18172], [-118.84124, 34.18177], [-118.84095, 34.18227], [-118.84079, 34.18205], [-118.84039, 34.1822], [-118.84023, 34.18199], [-118.84051, 34.1817], [-118.84026, 34.18154], [-118.84012, 34.18139], [-118.84024, 34.18109], [-118.83985, 34.18096], [-118.83994, 34.18076], [-118.84009, 34.18053], [-118.84026, 34.18031], [-118.84043, 34.18014], [-118.84058, 34.18024], [-118.84111, 34.18], [-118.84138, 34.17997], [-118.84183, 34.18008], [-118.84195, 34.17982], [-118.84207, 34.17986], [-118.84208, 34.18023], [-118.84237, 34.18038], [-118.84253, 34.18057], [-118.84262, 34.18064], [-118.84349, 34.18106], [-118.84366, 34.18122], [-118.84396, 34.18135]]], [[[-118.84498, 34.1851], [-118.84497, 34.18522], [-118.84444, 34.18605], [-118.84354, 34.18677], [-118.84318, 34.18754], [-118.84257, 34.18754], [-118.84259, 34.18749], [-118.8427, 34.18743], [-118.84273, 34.18736], [-118.84271, 34.18728], [-118.84267, 34.18724], [-118.84261, 34.18721], [-118.84249, 34.18722], [-118.84236, 34.18732], [-118.84232, 34.18732], [-118.84226, 34.18729], [-118.84233, 34.18718], [-118.84246, 34.1871], [-118.84258, 34.18708], [-118.84258, 34.18704], [-118.84239, 34.1865], [-118.84229, 34.18626], [-118.84234, 34.1858], [-118.84223, 34.18549], [-118.8419, 34.18558], [-118.84175, 34.18566], [-118.84152, 34.186], [-118.84152, 34.18607], [-118.84158, 34.18616], [-118.84157, 34.1864], [-118.84141, 34.1864], [-118.84105, 34.18649], [-118.84099, 34.18657], [-118.84113, 34.18677], [-118.84109, 34.18687], [-118.8413, 34.18703], [-118.84128, 34.1871], [-118.84144, 34.18728], [-118.84147, 34.18736], [-118.84179, 34.18748], [-118.84121, 34.18748], [-118.84126, 34.18753], [-118.84015, 34.18752], [-118.84, 34.1874], [-118.83982, 34.18732], [-118.83977, 34.18699], [-118.83945, 34.1867], [-118.83933, 34.18648], [-118.83919, 34.18633], [-118.8391, 34.18627], [-118.83893, 34.18621], [-118.83878, 34.18622], [-118.83854, 34.18632], [-118.8385, 34.18632], [-118.83837, 34.18645], [-118.83833, 34.18655], [-118.83832, 34.18668], [-118.83834, 34.18669], [-118.83838, 34.18684], [-118.83853, 34.18699], [-118.83862, 34.18724], [-118.83908, 34.18716], [-118.83919, 34.18724], [-118.83932, 34.18732], [-118.83946, 34.18737], [-118.8397, 34.18743], [-118.83987, 34.18752], [-118.83766, 34.1875], [-118.83768, 34.1857], [-118.83852, 34.18489], [-118.83876, 34.18503], [-118.83878, 34.18524], [-118.8395, 34.18524], [-118.83954, 34.18467], [-118.83956, 34.1845], [-118.83926, 34.18397], [-118.83872, 34.18397], [-118.83868, 34.18374], [-118.83868, 34.18362], [-118.83871, 34.18353], [-118.83876, 34.18345], [-118.83897, 34.18323], [-118.83905, 34.18313], [-118.83926, 34.18258], [-118.83966, 34.18268], [-118.83969, 34.18262], [-118.8398, 34.18261], [-118.83991, 34.18231], [-118.84011, 34.18209], [-118.8402, 34.18219], [-118.84026, 34.1823], [-118.84048, 34.18285], [-118.84023, 34.18292], [-118.84014, 34.18311], [-118.84034, 34.18349], [-118.84038, 34.1835], [-118.84042, 34.18359], [-118.84053, 34.18372], [-118.84059, 34.18372], [-118.84097, 34.18414], [-118.83989, 34.18414], [-118.84007, 34.18453], [-118.84019, 34.18506], [-118.84498, 34.1851]]]]} | Open Access 1 | 49020 | Gilder Hill Open Space | 33720 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/glider-hill.html | Ventura 8 | 60.783 | Gilder Hill OS | 0 | Local Recreation Area 3 | 4 |
16107 | 16107 | 16106 | {"type": "Polygon", "coordinates": [[[-118.94813, 34.15608], [-118.94801, 34.15654], [-118.94796, 34.15651], [-118.94753, 34.15644], [-118.94739, 34.15666], [-118.94763, 34.15685], [-118.94757, 34.15709], [-118.94744, 34.15715], [-118.94721, 34.15691], [-118.94702, 34.15681], [-118.94667, 34.15716], [-118.9465, 34.15711], [-118.9464, 34.15718], [-118.94593, 34.15673], [-118.94618, 34.15659], [-118.94637, 34.15653], [-118.94677, 34.15651], [-118.94722, 34.15658], [-118.94733, 34.15638], [-118.94737, 34.15598], [-118.94755, 34.15596], [-118.94774, 34.15596], [-118.94792, 34.156], [-118.94813, 34.15608]]]} | Open Access 1 | 49018 | Deer Ridge Open Space | 33719 | 1347 | Thousand Oaks, City of 428 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/deer-ridge.html | Ventura 8 | 2.769 | Deer Ridge OS | 0 | Local Recreation Area 3 | 4 |
9389 | 9389 | 9388 | {"type": "Polygon", "coordinates": [[[-118.83657, 34.29536], [-118.83657, 34.29613], [-118.8359, 34.29629], [-118.83565, 34.29638], [-118.83538, 34.29651], [-118.83513, 34.29664], [-118.83522, 34.29677], [-118.83504, 34.29686], [-118.83492, 34.29671], [-118.83413, 34.29688], [-118.8339, 34.2969], [-118.83353, 34.2969], [-118.83327, 34.29693], [-118.83302, 34.297], [-118.83262, 34.29715], [-118.83211, 34.29728], [-118.83196, 34.29734], [-118.83183, 34.29745], [-118.83165, 34.29778], [-118.83188, 34.29808], [-118.83255, 34.298], [-118.83327, 34.29778], [-118.83446, 34.29787], [-118.83274, 34.29841], [-118.83204, 34.29848], [-118.83186, 34.29882], [-118.83129, 34.29939], [-118.83094, 34.29989], [-118.83057, 34.29987], [-118.83049, 34.29994], [-118.83047, 34.30022], [-118.83058, 34.30062], [-118.83067, 34.30074], [-118.82259, 34.30074], [-118.82259, 34.30255], [-118.82044, 34.30255], [-118.82087, 34.30152], [-118.82109, 34.30001], [-118.82101, 34.29947], [-118.8199, 34.29764], [-118.81979, 34.29703], [-118.82033, 34.29642], [-118.82099, 34.29625], [-118.82168, 34.29571], [-118.8224, 34.295], [-118.82239, 34.2945], [-118.82176, 34.29316], [-118.82145, 34.29225], [-118.82257, 34.29252], [-118.82372, 34.29312], [-118.82398, 34.29306], [-118.82412, 34.29333], [-118.82471, 34.29332], [-118.82458, 34.29376], [-118.82506, 34.29392], [-118.82574, 34.29357], [-118.82549, 34.29323], [-118.82667, 34.29253], [-118.82714, 34.29282], [-118.82887, 34.29263], [-118.82958, 34.29264], [-118.83004, 34.29268], [-118.83041, 34.29261], [-118.83076, 34.2928], [-118.8321, 34.29285], [-118.83367, 34.29329], [-118.83395, 34.29385], [-118.83449, 34.29436], [-118.8355, 34.29416], [-118.8361, 34.29363], [-118.83645, 34.29381], [-118.83655, 34.29426], [-118.83646, 34.29535], [-118.83657, 34.29536]], [[-118.8311, 34.29578], [-118.8312, 34.29585], [-118.83136, 34.29587], [-118.83178, 34.29553], [-118.8313, 34.2952], [-118.83078, 34.29555], [-118.8311, 34.29578]]]} | Open Access 1 | 49013 | City of Moorpark Open Space | 33711 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 255.937 | City of Moorpark OS | 0 | Local Recreation Area 3 | 4 | |
16114 | 16114 | 16113 | {"type": "Polygon", "coordinates": [[[-118.95456, 34.20563], [-118.947, 34.21744], [-118.94068, 34.21679], [-118.93523, 34.2145], [-118.93489, 34.21376], [-118.93554, 34.21268], [-118.93715, 34.21253], [-118.93816, 34.21187], [-118.93877, 34.21239], [-118.93943, 34.21233], [-118.93948, 34.21228], [-118.9399, 34.21229], [-118.94125, 34.21217], [-118.9419, 34.21156], [-118.9411, 34.21014], [-118.94059, 34.21007], [-118.9409, 34.2098], [-118.94046, 34.20903], [-118.93946, 34.20762], [-118.93858, 34.20769], [-118.93875, 34.20633], [-118.93701, 34.20526], [-118.93646, 34.2055], [-118.93639, 34.20488], [-118.93566, 34.205], [-118.93474, 34.20443], [-118.93467, 34.20405], [-118.93546, 34.20316], [-118.93678, 34.2034], [-118.93787, 34.20255], [-118.93816, 34.20153], [-118.93787, 34.20107], [-118.93714, 34.20139], [-118.93629, 34.20005], [-118.93492, 34.20012], [-118.93491, 34.19935], [-118.93556, 34.19889], [-118.93535, 34.19856], [-118.93347, 34.19823], [-118.93221, 34.19836], [-118.93293, 34.19684], [-118.93433, 34.19687], [-118.93434, 34.19708], [-118.9364, 34.19708], [-118.93639, 34.1979], [-118.93674, 34.1979], [-118.93696, 34.19814], [-118.93738, 34.19813], [-118.93739, 34.19708], [-118.93855, 34.19708], [-118.9387, 34.19763], [-118.93891, 34.19795], [-118.93868, 34.19814], [-118.93855, 34.19829], [-118.93854, 34.20564], [-118.95456, 34.20563]]]} | Open Access 1 | 49002 | Conejo Canyons Open Space | 30794 | 1347 | Thousand Oaks, City of 428 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/open-space.html | Ventura 8 | 410.746 | Conejo Canyons OS | 0 | Local Recreation Area 3 | 4 |
7255 | 7255 | 7254 | {"type": "Polygon", "coordinates": [[[-121.92427, 37.74849], [-121.92332, 37.74921], [-121.92193, 37.74844], [-121.91908, 37.7461], [-121.92388, 37.7469], [-121.92427, 37.74849]]]} | Open Access 1 | 48922 | Dougherty Valley Ridge Trail | 33643 | 2031 | East Bay Municipal Utility District 433 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail | Contra Costa 12 | 17.382 | Dougherty Valley Ridge Trail | 0 | Local Recreation Area 3 | 4 |
7254 | 7254 | 7253 | {"type": "MultiPolygon", "coordinates": [[[[-121.92276, 37.73954], [-121.92256, 37.73979], [-121.92249, 37.73962], [-121.92245, 37.73928], [-121.92232, 37.73901], [-121.92181, 37.73883], [-121.92146, 37.73929], [-121.92096, 37.74024], [-121.92102, 37.74085], [-121.921, 37.74106], [-121.92086, 37.74144], [-121.9209, 37.74166], [-121.92088, 37.74171], [-121.92061, 37.74195], [-121.92053, 37.7422], [-121.92049, 37.74258], [-121.9205, 37.74268], [-121.92053, 37.74278], [-121.92058, 37.74286], [-121.92136, 37.74378], [-121.92147, 37.74422], [-121.92148, 37.74431], [-121.92146, 37.7444], [-121.92138, 37.74453], [-121.9213, 37.74459], [-121.9211, 37.7447], [-121.921, 37.74482], [-121.92092, 37.74535], [-121.92094, 37.7455], [-121.92092, 37.7457], [-121.92071, 37.74637], [-121.91927, 37.74613], [-121.91968, 37.74602], [-121.91984, 37.74603], [-121.92007, 37.7457], [-121.92025, 37.74584], [-121.92066, 37.74583], [-121.92071, 37.74569], [-121.92042, 37.74544], [-121.92047, 37.74537], [-121.92045, 37.74529], [-121.92075, 37.74515], [-121.92082, 37.74491], [-121.92083, 37.7446], [-121.92073, 37.7445], [-121.92078, 37.74446], [-121.9208, 37.7444], [-121.92088, 37.7444], [-121.92123, 37.74428], [-121.9212, 37.74406], [-121.92109, 37.74379], [-121.9207, 37.74358], [-121.92073, 37.74349], [-121.92068, 37.74342], [-121.92078, 37.74333], [-121.92065, 37.74309], [-121.91977, 37.74301], [-121.91985, 37.74232], [-121.9201, 37.74232], [-121.92032, 37.74197], [-121.92017, 37.74139], [-121.92017, 37.74113], [-121.92062, 37.74071], [-121.92054, 37.74037], [-121.92035, 37.74031], [-121.92036, 37.74026], [-121.92035, 37.74022], [-121.92058, 37.74012], [-121.92075, 37.73983], [-121.92098, 37.73938], [-121.92089, 37.73929], [-121.92106, 37.73914], [-121.9213, 37.73889], [-121.9215, 37.73864], [-121.92162, 37.73848], [-121.92173, 37.73867], [-121.92185, 37.7385], [-121.92201, 37.73855], [-121.92228, 37.73867], [-121.92246, 37.73881], [-121.92256, 37.73893], [-121.92262, 37.73906], [-121.92276, 37.73954]]], [[[-121.92287, 37.73974], [-121.9226, 37.73986], [-121.92258, 37.73982], [-121.92277, 37.73957], [-121.92287, 37.73974]]]]} | Open Access 1 | 48921 | Dougherty Valley Ridge Trail | 33643 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail | Contra Costa 12 | 10.256 | Dougherty Valley Ridge Trail | 0 | Local Recreation Area 3 | 4 |
7251 | 7251 | 7250 | {"type": "Polygon", "coordinates": [[[-121.92994, 37.74522], [-121.92625, 37.74667], [-121.92569, 37.74579], [-121.92458, 37.74623], [-121.92512, 37.74711], [-121.92071, 37.74637], [-121.92092, 37.7457], [-121.92094, 37.7455], [-121.92092, 37.74535], [-121.921, 37.74482], [-121.9211, 37.7447], [-121.9213, 37.74459], [-121.92141, 37.74449], [-121.92146, 37.7444], [-121.92148, 37.74426], [-121.92136, 37.74378], [-121.92055, 37.74282], [-121.9205, 37.74268], [-121.92049, 37.74258], [-121.92053, 37.7422], [-121.92061, 37.74194], [-121.92088, 37.74171], [-121.9209, 37.74166], [-121.92086, 37.74144], [-121.921, 37.74106], [-121.92102, 37.74085], [-121.92096, 37.74024], [-121.92146, 37.73929], [-121.92181, 37.73883], [-121.92232, 37.73901], [-121.92245, 37.73928], [-121.92249, 37.73962], [-121.92256, 37.73977], [-121.92257, 37.73977], [-121.92276, 37.73954], [-121.92277, 37.73957], [-121.92258, 37.73982], [-121.9226, 37.73986], [-121.92258, 37.74002], [-121.9226, 37.74014], [-121.9227, 37.7404], [-121.92283, 37.74054], [-121.92298, 37.74068], [-121.92344, 37.74066], [-121.92396, 37.74073], [-121.92441, 37.74073], [-121.9246, 37.74075], [-121.9248, 37.74079], [-121.92491, 37.74089], [-121.92502, 37.74095], [-121.92519, 37.74109], [-121.92534, 37.74126], [-121.92543, 37.74145], [-121.92548, 37.74167], [-121.92547, 37.74189], [-121.92553, 37.74205], [-121.92563, 37.74213], [-121.92575, 37.74238], [-121.9259, 37.74263], [-121.92617, 37.74292], [-121.92625, 37.74304], [-121.92638, 37.74333], [-121.92669, 37.74351], [-121.92698, 37.74389], [-121.92725, 37.74414], [-121.92715, 37.74428], [-121.92706, 37.74444], [-121.92692, 37.74464], [-121.92691, 37.74469], [-121.92692, 37.74481], [-121.92801, 37.74475], [-121.92843, 37.74481], [-121.92869, 37.74482], [-121.92892, 37.74479], [-121.9294, 37.74467], [-121.92994, 37.74522]]]} | Open Access 1 | 48920 | Dougherty Valley Ridge Trail | 33643 | 2300 | Geologic Hazard Abatement District (San Ramon) 853 | Special District 4 | Special District - Other 26 | http://www.sanramon.ca.gov/engr/ghad.html | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail | Contra Costa 12 | 89.586 | Dougherty Valley Ridge Trail | 0 | Local Recreation Area 3 | 4 |
6278 | 6278 | 6277 | {"type": "Polygon", "coordinates": [[[-117.46707, 33.74589], [-117.46683, 33.74759], [-117.46525, 33.74744], [-117.46517, 33.7471], [-117.46503, 33.74677], [-117.46348, 33.7442], [-117.46334, 33.744], [-117.4632, 33.74382], [-117.4632, 33.74376], [-117.46365, 33.74339], [-117.46373, 33.74335], [-117.46383, 33.74332], [-117.46405, 33.74329], [-117.46541, 33.7433], [-117.46601, 33.74403], [-117.46707, 33.74589]]]} | Open Access 1 | 48881 | Deleo Regional Sports Park | 33602 | 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 | https://rivcoccsd.org/new-page-2 | Riverside 10 | 24.913 | Deleo Reg. Sports Park | 0 | Local Recreation Area 3 | 4 |
6265 | 6265 | 6264 | {"type": "Polygon", "coordinates": [[[-117.53184, 33.83651], [-117.52781, 33.83658], [-117.52781, 33.83602], [-117.52859, 33.836], [-117.52865, 33.83597], [-117.52865, 33.83594], [-117.52861, 33.83541], [-117.52852, 33.83513], [-117.52837, 33.83487], [-117.52794, 33.83501], [-117.52726, 33.83357], [-117.52752, 33.83343], [-117.5276, 33.83344], [-117.52778, 33.83335], [-117.5278, 33.83328], [-117.52925, 33.83254], [-117.53, 33.83352], [-117.53166, 33.83607], [-117.53184, 33.83651]]]} | Open Access 1 | 48877 | El Cerrito Sports Park | 33598 | 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 | https://www.coronaca.gov/Home/Components/FacilityDirectory/FacilityDirectory/95/580 | Riverside 10 | 26.334 | El Cerrito Sports Park | 0 | Local Recreation Area 3 | 4 |
14329 | 14329 | 14328 | {"type": "Polygon", "coordinates": [[[-122.38715, 41.43835], [-122.38702, 41.43886], [-122.38616, 41.43867], [-122.38561, 41.43852], [-122.38556, 41.43846], [-122.38554, 41.43836], [-122.38559, 41.43811], [-122.38715, 41.43835]]]} | Open Access 1 | 48856 | Weed Skate Park | 33576 | 2352 | Weed Recreation and Parks District 1109 | Special District 4 | Recreation/Parks District 4 | http://weedrec.org/?page_id=45 | Special District 4 | 2352 | Weed Recreation and Parks District 1063 | Special District 4 | Recreation/Parks District 4 | https://www.northwestskater.com/weed.html | Siskiyou 28 | 1.645 | Weed Skate Park | 0 | Local Recreation Area 3 | 4 |
14131 | 14131 | 14130 | {"type": "Polygon", "coordinates": [[[-119.32522, 36.15647], [-119.32197, 36.1564], [-119.32208, 36.15273], [-119.32208, 36.15273], [-119.32522, 36.15647]]]} | Open Access 1 | 48851 | Elk Bayou Soccer Complex | 33571 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | https://www.tulare.ca.gov/Home/Components/FacilityDirectory/FacilityDirectory/22/155 | Tulare 29 | 14.659 | Elk Bayou Soccer Complex | 0 | Local Recreation Area 3 | 4 |
4428 | 4428 | 4427 | {"type": "Polygon", "coordinates": [[[-122.36952, 40.67363], [-122.36948, 40.67469], [-122.36818, 40.67463], [-122.36816, 40.6744], [-122.36828, 40.67405], [-122.36842, 40.67378], [-122.3686, 40.67367], [-122.36884, 40.67359], [-122.36924, 40.67359], [-122.36952, 40.67363]]]} | Open Access 1 | 48847 | Wynne Price Park and Baseball Field | 33567 | 1438 | Shasta Lake, City of 324 | City 2 | City Agency 2 | http://www.ci.shasta-lake.ca.us/index.aspx?nid=253 | City 2 | 1438 | Shasta Lake, City of 321 | City 2 | City Agency 2 | https://cityofshastalake.org/553/Parks | Shasta 27 | 2.932 | Wynne Price Park and Baseball Field | 0 | Local Recreation Area 3 | 4 |
3977 | 3977 | 3976 | {"type": "Polygon", "coordinates": [[[-121.85453, 37.34889], [-121.85442, 37.34894], [-121.85423, 37.34868], [-121.85434, 37.34863], [-121.85453, 37.34889]]]} | Open Access 1 | 48844 | San Antonio Tot Lot | 33564 | 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 | https://www.sanjoseca.gov/Home/Components/FacilityDirectory/FacilityDirectory/2945/37 | Santa Clara 19 | 0.09 | San Antonio Tot Lot | 0 | Local Recreation Area 3 | 4 |
13544 | 13544 | 13543 | {"type": "Polygon", "coordinates": [[[-117.63464, 33.44433], [-117.63368, 33.44513], [-117.63359, 33.44529], [-117.63357, 33.44527], [-117.63343, 33.44529], [-117.63333, 33.44533], [-117.63317, 33.44552], [-117.63307, 33.44557], [-117.63301, 33.44552], [-117.63294, 33.44537], [-117.63296, 33.44526], [-117.63278, 33.44448], [-117.63247, 33.44421], [-117.63228, 33.44418], [-117.63214, 33.44405], [-117.63214, 33.444], [-117.63222, 33.44385], [-117.63236, 33.44332], [-117.6324, 33.44296], [-117.63253, 33.44286], [-117.63261, 33.44289], [-117.63314, 33.4433], [-117.63313, 33.44335], [-117.63427, 33.4443], [-117.63438, 33.44434], [-117.63448, 33.44433], [-117.63456, 33.44428], [-117.63464, 33.44433]]]} | Open Access 1 | 48827 | Jim Johnson Memorial Sports Park | 33546 | 6132 | Marblehead Development Partners LLC 1045 | Private 7 | Home Owners Association 16 | Private 14 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/187/2783 | Orange 3 | 7.375 | Jim Johnson Memorial Sports Park | 0 | Local Recreation Area 3 | 4 | |
13496 | 13496 | 13495 | {"type": "Polygon", "coordinates": [[[-117.61267, 33.45818], [-117.61235, 33.45862], [-117.61242, 33.45866], [-117.6122, 33.45896], [-117.61217, 33.45895], [-117.61187, 33.45933], [-117.61189, 33.45935], [-117.61164, 33.45962], [-117.61136, 33.45988], [-117.61091, 33.46023], [-117.61058, 33.46044], [-117.61005, 33.46072], [-117.6077, 33.46174], [-117.60716, 33.462], [-117.60666, 33.4623], [-117.60562, 33.46305], [-117.60511, 33.4634], [-117.60478, 33.4636], [-117.60468, 33.46358], [-117.60409, 33.46281], [-117.60379, 33.46232], [-117.60362, 33.46197], [-117.60347, 33.4616], [-117.60329, 33.46104], [-117.60325, 33.46083], [-117.6033, 33.46081], [-117.60311, 33.45993], [-117.60308, 33.45981], [-117.60303, 33.45981], [-117.60295, 33.45954], [-117.60303, 33.45951], [-117.60297, 33.45933], [-117.60275, 33.45878], [-117.60266, 33.4588], [-117.60234, 33.4582], [-117.61267, 33.45818]]]} | Open Access 1 | 48826 | Vista Hermosa Sports Park | 33545 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/61/2783 | Orange 3 | 80.721 | Vista Hermosa Sports Park | 0 | 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]);