units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,190 rows where DES_TP = 14 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 152
- Ventura, City of 106
- Butte, County of 52
- Yuba County Water Agency 48
- Roseville, City of 46
- Lake, County of 36
- Santa Barbara, County of 35
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Orange, County of 21
- Napa, City of 21
- Monterey, County of 18
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 14
- Lompoc, City of 14
- Los Angeles County Flood Control District 13
- Santa Cruz, City of 12
- Oroville, City of 12
- Los Angeles, County of 11
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Santa Barbara Flood Control and Water Conserv. District 10
- Guadalupe, City of 10
- Santa Maria, City of 9
- San Lorenzo Valley Water District 9
- …
MNG_AG_TYP 15
- City Agency 652
- County Agency 210
- Open Space District 155
- Water District 77
- Flood District 29
- Recreation/Parks District 28
- County Agency - Other 5
- Irrigation District 4
- Sanitation District 3
- Community Services District 2
- County Agency - Parks 1
- Special District - Other 1
- Metropolitan Planning Organization 1
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 855
- Unknown Access 198
- No Public Access 88
- Restricted Access 29
DES_TP 1
- Local Other or Unknown · 1,170 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5966 | 5966 | 5965 | {"type": "Polygon", "coordinates": [[[-116.99908, 32.56479], [-116.99905, 32.56803], [-116.99907, 32.56804], [-116.99876, 32.56801], [-116.99722, 32.568], [-116.99712, 32.56796], [-116.99709, 32.56789], [-116.99699, 32.56788], [-116.99702, 32.56465], [-116.99704, 32.5646], [-116.99907, 32.56465], [-116.99908, 32.56479]]]} | Open Access 1 | 1051 | Otay Mitigation Site | 23242 | 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 | 17.892 | Otay Mitigation Site | 0 | Local Other or Unknown 14 | 4 | |
6117 | 6117 | 6116 | {"type": "MultiPolygon", "coordinates": [[[[-116.98689, 32.83198], [-116.98676, 32.83215], [-116.98688, 32.83237], [-116.98633, 32.83237], [-116.98582, 32.83156], [-116.98607, 32.83162], [-116.98636, 32.83172], [-116.9866, 32.83182], [-116.98689, 32.83198]]], [[[-116.99272, 32.83496], [-116.99251, 32.8352], [-116.9923, 32.83491], [-116.99218, 32.83479], [-116.99185, 32.83455], [-116.99147, 32.83438], [-116.99132, 32.83434], [-116.991, 32.83429], [-116.99099, 32.8343], [-116.99099, 32.83449], [-116.98958, 32.83452], [-116.98958, 32.8339], [-116.99016, 32.83389], [-116.9907, 32.83397], [-116.99102, 32.83397], [-116.9914, 32.83405], [-116.99156, 32.8341], [-116.99173, 32.83417], [-116.99207, 32.83433], [-116.99246, 32.83464], [-116.99265, 32.83484], [-116.99272, 32.83496]]], [[[-116.99677, 32.83852], [-116.9964, 32.83852], [-116.99615, 32.83825], [-116.99592, 32.83806], [-116.99576, 32.83797], [-116.99506, 32.83768], [-116.99402, 32.83703], [-116.99377, 32.83685], [-116.99347, 32.83648], [-116.99315, 32.83603], [-116.99263, 32.83534], [-116.99283, 32.83511], [-116.99289, 32.83516], [-116.99337, 32.83577], [-116.99379, 32.83635], [-116.99416, 32.83677], [-116.99457, 32.83705], [-116.99512, 32.8374], [-116.99599, 32.83778], [-116.99626, 32.83795], [-116.99647, 32.83814], [-116.99668, 32.83838], [-116.99677, 32.83852]]]]} | Open Access 1 | 1086 | Forrester Creek | 19002 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | San Diego 4 | 8.757 | Forrester Creek | 0 | Local Other or Unknown 14 | 4 | |
6143 | 6143 | 6142 | {"type": "MultiPolygon", "coordinates": [[[[-117.2322, 33.14229], [-117.23213, 33.1423], [-117.23079, 33.14226], [-117.23016, 33.14279], [-117.23009, 33.14283], [-117.2299, 33.1429], [-117.22971, 33.14288], [-117.22965, 33.14293], [-117.22956, 33.1429], [-117.22942, 33.14281], [-117.22936, 33.14273], [-117.22838, 33.14284], [-117.22763, 33.14285], [-117.22742, 33.14382], [-117.22664, 33.14584], [-117.22578, 33.14584], [-117.22575, 33.14586], [-117.22578, 33.14672], [-117.22545, 33.14622], [-117.22543, 33.14499], [-117.22545, 33.14498], [-117.22571, 33.14438], [-117.22564, 33.14354], [-117.22553, 33.14314], [-117.22408, 33.14364], [-117.22366, 33.14366], [-117.22358, 33.14375], [-117.22341, 33.14374], [-117.22319, 33.14375], [-117.22294, 33.14384], [-117.22269, 33.14399], [-117.22261, 33.14408], [-117.22254, 33.14418], [-117.22244, 33.14426], [-117.22254, 33.1444], [-117.22213, 33.14452], [-117.22193, 33.14451], [-117.22167, 33.14427], [-117.22102, 33.14438], [-117.22071, 33.14439], [-117.22026, 33.14457], [-117.21977, 33.14473], [-117.21939, 33.14498], [-117.21909, 33.14516], [-117.21864, 33.14481], [-117.21879, 33.14463], [-117.21953, 33.14425], [-117.21971, 33.14417], [-117.21927, 33.1437], [-117.2198, 33.14346], [-117.22013, 33.14311], [-117.22065, 33.14288], [-117.2207, 33.1429], [-117.22156, 33.1426], [-117.22174, 33.14268], [-117.22244, 33.14249], [-117.2225, 33.14252], [-117.22325, 33.1423], [-117.22326, 33.14226], [-117.22301, 33.14137], [-117.22304, 33.14137], [-117.22341, 33.14217], [-117.22355, 33.14222], [-117.22536, 33.14182], [-117.22552, 33.14168], [-117.22571, 33.14182], [-117.22573, 33.14223], [-117.23002, 33.14216], [-117.22998, 33.14032], [-117.23034, 33.14013], [-117.23039, 33.14013], [-117.23078, 33.14048], [-117.23149, 33.14103], [-117.2317, 33.14126], [-117.23193, 33.14159], [-117.23208, 33.14189], [-117.2322, 33.14229]]], [[[-117.24385, 33.13544], [-117.24359, 33.13527], [-117.24107, 33.13527], [-117.24034, 33.13552], [-117.23979, 33.13609], [-117.23808, 33.138], [-117.23711, 33.13816], [-117.23713, 33.13888], [-117.23625, 33.1395], [-117.23444, 33.14101], [-117.23228, 33.14173], [-117.23214, 33.14146], [-117.23193, 33.14116], [-117.2317, 33.14091], [-117.23142, 33.14066], [-117.23315, 33.14025], [-117.2341, 33.13943], [-117.23428, 33.13863], [-117.23426, 33.13694], [-117.23613, 33.13594], [-117.23662, 33.13558], [-117.2372, 33.13568], [-117.23806, 33.13524], [-117.23805, 33.13501], [-117.23859, 33.135], [-117.24377, 33.13497], [-117.24385, 33.13544]]], [[[-117.2461, 33.13659], [-117.24526, 33.13547], [-117.24439, 33.13552], [-117.24438, 33.13503], [-117.24439, 33.13496], [-117.246, 33.13495], [-117.2461, 33.13659]]]]} | Open Access 1 | 1138 | Agua Hedionda Creek | 15293 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 113.24 | Agua Hedionda Creek | 0 | Local Other or Unknown 14 | 4 |
4470 | 4470 | 4469 | {"type": "Polygon", "coordinates": [[[-116.37329, 33.19965], [-116.36458, 33.19964], [-116.36453, 33.19257], [-116.37324, 33.19257], [-116.37329, 33.19965]]]} | Restricted Access 2 | 1194 | Unnamed site - Borrego Water District | 28622 | 2008 | Borrego Water District 764 | Special District 4 | Water District 13 | http://www.borregowd.org/ | Special District 4 | 2008 | Borrego Water District 745 | Special District 4 | Water District 13 | San Diego 4 | 157.534 | 0 | Local Other or Unknown 14 | 4 | ||
364 | 364 | 363 | {"type": "Polygon", "coordinates": [[[-119.67342, 34.42333], [-119.67318, 34.42356], [-119.67274, 34.42324], [-119.67299, 34.42301], [-119.67342, 34.42333]]]} | Unknown Access 4 | 1276 | Sycamore Creek | 26121 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 0.446 | Sycamore Creek | 0 | Local Other or Unknown 14 | 4 | |
6250 | 6250 | 6249 | {"type": "Polygon", "coordinates": [[[-117.1192, 33.10579], [-117.11901, 33.10627], [-117.11885, 33.10655], [-117.11637, 33.10688], [-117.11677, 33.10621], [-117.11701, 33.10622], [-117.11704, 33.1061], [-117.11691, 33.10609], [-117.11713, 33.10571], [-117.11708, 33.10568], [-117.1178, 33.10446], [-117.1192, 33.10579]]]} | No Public Access 3 | 1410 | Escondido Creek | 18706 | 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 | San Diego 4 | 8.905 | Escondido Creek | 0 | Local Other or Unknown 14 | 4 | |
6332 | 6332 | 6331 | {"type": "MultiPolygon", "coordinates": [[[[-121.79513, 37.31362], [-121.79476, 37.31367], [-121.79477, 37.3137], [-121.79469, 37.31372], [-121.79464, 37.31371], [-121.7946, 37.31372], [-121.79456, 37.31379], [-121.79447, 37.31386], [-121.79431, 37.31361], [-121.7943, 37.31344], [-121.79412, 37.313], [-121.79392, 37.31287], [-121.7937, 37.31288], [-121.79326, 37.31307], [-121.79312, 37.31309], [-121.79279, 37.31299], [-121.79261, 37.31307], [-121.79255, 37.31312], [-121.79245, 37.31317], [-121.79239, 37.31317], [-121.7922, 37.31312], [-121.79212, 37.31295], [-121.79171, 37.31263], [-121.79165, 37.31261], [-121.7913, 37.31252], [-121.79079, 37.31267], [-121.79074, 37.31254], [-121.79032, 37.31187], [-121.7896, 37.31155], [-121.78932, 37.31129], [-121.7891, 37.31138], [-121.78884, 37.31135], [-121.78875, 37.31136], [-121.78864, 37.31135], [-121.78854, 37.31142], [-121.7883, 37.31151], [-121.78815, 37.31155], [-121.78811, 37.31154], [-121.78808, 37.31152], [-121.788, 37.31142], [-121.78758, 37.31103], [-121.78743, 37.31095], [-121.78726, 37.31091], [-121.78717, 37.31087], [-121.78691, 37.31065], [-121.78661, 37.31041], [-121.78648, 37.31036], [-121.78616, 37.31027], [-121.78597, 37.3101], [-121.78579, 37.30986], [-121.78572, 37.30982], [-121.78566, 37.3098], [-121.78549, 37.30979], [-121.78546, 37.30977], [-121.7854, 37.30959], [-121.78523, 37.3095], [-121.78501, 37.30944], [-121.7849, 37.30946], [-121.78464, 37.30953], [-121.78458, 37.30953], [-121.78455, 37.30953], [-121.78452, 37.30943], [-121.78449, 37.3094], [-121.78439, 37.30934], [-121.78428, 37.30933], [-121.78418, 37.30935], [-121.7841, 37.30934], [-121.78403, 37.30934], [-121.78391, 37.30933], [-121.78382, 37.30929], [-121.7837, 37.30922], [-121.78359, 37.30908], [-121.78349, 37.309], [-121.78339, 37.309], [-121.78317, 37.30906], [-121.78306, 37.30906], [-121.78238, 37.3089], [-121.78217, 37.30878], [-121.78198, 37.30865], [-121.78179, 37.30857], [-121.78133, 37.30848], [-121.78132, 37.30834], [-121.78123, 37.30824], [-121.78115, 37.30823], [-121.78111, 37.30824], [-121.78092, 37.30824], [-121.78086, 37.30822], [-121.78069, 37.30812], [-121.78057, 37.30801], [-121.78047, 37.30785], [-121.78044, 37.30759], [-121.78046, 37.30744], [-121.78039, 37.30734], [-121.78033, 37.30729], [-121.78025, 37.30727], [-121.77989, 37.30733], [-121.77981, 37.30733], [-121.77978, 37.30734], [-121.77967, 37.30734], [-121.7796, 37.30727], [-121.77959, 37.30724], [-121.77961, 37.30722], [-121.77961, 37.30719], [-121.7797, 37.3071], [-121.77973, 37.30702], [-121.77951, 37.30661], [-121.77937, 37.30649], [-121.77921, 37.3064], [-121.77913, 37.30632], [-121.77907, 37.30629], [-121.77891, 37.30615], [-121.77889, 37.30612], [-121.77887, 37.30602], [-121.77888, 37.30599], [-121.77899, 37.3059], [-121.77904, 37.30584], [-121.77907, 37.30576], [-121.77905, 37.30567], [-121.7789, 37.30558], [-121.77878, 37.30554], [-121.77855, 37.30551], [-121.77839, 37.30551], [-121.77831, 37.30547], [-121.77831, 37.30544], [-121.77837, 37.30535], [-121.77837, 37.30529], [-121.77834, 37.30523], [-121.77824, 37.30515], [-121.77808, 37.30506], [-121.77794, 37.30501], [-121.77782, 37.30497], [-121.7777, 37.30498], [-121.77761, 37.30494], [-121.77766, 37.30485], [-121.77783, 37.30474], [-121.77789, 37.30466], [-121.77781, 37.30455], [-121.77768, 37.30447], [-121.77761, 37.30431], [-121.7776, 37.30421], [-121.77757, 37.30409], [-121.77753, 37.30405], [-121.77751, 37.30399], [-121.77754, 37.30393], [-121.77757, 37.3039], [-121.77775, 37.30391], [-121.77789, 37.30388], [-121.77789, 37.30386], [-121.77782, 37.30374], [-121.77782, 37.30369], [-121.77798, 37.30364], [-121.77798, 37.30363], [-121.77753, 37.30333], [-121.77738, 37.30328], [-121.77731, 37.30324], [-121.77723, 37.30308], [-121.77723, 37.30304], [-121.77669, 37.30253], [-121.77666, 37.30255], [-121.77657, 37.30257], [-121.7765, 37.30256], [-121.77638, 37.30245], [-121.77622, 37.3024], [-121.77608, 37.30239], [-121.77604, 37.30239], [-121.7759, 37.30246], [-121.77581, 37.30246], [-121.77574, 37.30239], [-121.77573, 37.30233], [-121.77574, 37.30222], [-121.77576, 37.30217], [-121.77574, 37.30213], [-121.7757, 37.30211], [-121.77557, 37.30209], [-121.77538, 37.30215], [-121.77527, 37.30223], [-121.77517, 37.30222], [-121.77501, 37.30216], [-121.77479, 37.30199], [-121.77461, 37.30183], [-121.77459, 37.30174], [-121.77462, 37.30166], [-121.77473, 37.30159], [-121.77499, 37.30148], [-121.77523, 37.30143], [-121.7753, 37.30137], [-121.77533, 37.30132], [-121.77532, 37.30129], [-121.77523, 37.30123], [-121.77515, 37.30123], [-121.77505, 37.30119], [-121.77502, 37.30113], [-121.77491, 37.30099], [-121.77486, 37.30094], [-121.77483, 37.30094], [-121.7748, 37.30091], [-121.77476, 37.30076], [-121.77471, 37.30074], [-121.77453, 37.30052], [-121.77436, 37.30045], [-121.77402, 37.30046], [-121.77392, 37.30043], [-121.77382, 37.30037], [-121.77377, 37.3003], [-121.77375, 37.30021], [-121.77377, 37.30012], [-121.7738, 37.30004], [-121.7738, 37.29995], [-121.77375, 37.2999], [-121.77362, 37.29982], [-121.77352, 37.2998], [-121.77343, 37.29981], [-121.77337, 37.29979], [-121.77333, 37.29972], [-121.7733, 37.29959], [-121.77323, 37.29952], [-121.77306, 37.29943], [-121.77281, 37.29936], [-121.77262, 37.29933], [-121.7724, 37.29933], [-121.77143, 37.29824], [-121.77189, 37.29826], [-121.77206, 37.29815], [-121.77208, 37.29809], [-121.77205, 37.29802], [-121.77255, 37.29797], [-121.77261, 37.29825], [-121.77222, 37.29849], [-121.77222, 37.2985], [-121.77245, 37.29874], [-121.77281, 37.29905], [-121.77299, 37.29908], [-121.77344, 37.29932], [-121.77374, 37.29968], [-121.77401, 37.29991], [-121.77458, 37.30021], [-121.77474, 37.30033], [-121.7754, 37.30097], [-121.77544, 37.30099], [-121.77545, 37.30104], [-121.77545, 37.30126], [-121.77544, 37.30138], [-121.77535, 37.30151], [-121.77525, 37.3016], [-121.77521, 37.30171], [-121.77506, 37.30181], [-121.77513, 37.3019], [-121.77521, 37.30192], [-121.77548, 37.3019], [-121.77575, 37.30195], [-121.77623, 37.30225], [-121.77646, 37.30227], [-121.77656, 37.30224], [-121.77662, 37.3022], [-121.77671, 37.3021], [-121.77693, 37.30202], [-121.77702, 37.30202], [-121.77709, 37.30206], [-121.77715, 37.30215], [-121.77712, 37.30237], [-121.77725, 37.30287], [-121.77784, 37.30328], [-121.7782, 37.30355], [-121.77825, 37.30356], [-121.77806, 37.30403], [-121.77798, 37.30435], [-121.77805, 37.30461], [-121.77807, 37.30488], [-121.77831, 37.30498], [-121.77842, 37.30521], [-121.77923, 37.30568], [-121.77927, 37.30583], [-121.77921, 37.30596], [-121.77926, 37.30619], [-121.77967, 37.30648], [-121.78001, 37.30627], [-121.78016, 37.30623], [-121.78042, 37.30665], [-121.7803, 37.30671], [-121.78061, 37.30724], [-121.78053, 37.30737], [-121.78068, 37.30746], [-121.78072, 37.3076], [-121.78063, 37.30782], [-121.7809, 37.30804], [-121.78107, 37.30816], [-121.78123, 37.30813], [-121.78152, 37.30826], [-121.782, 37.30855], [-121.78226, 37.3086], [-121.78243, 37.30861], [-121.78257, 37.30886], [-121.78363, 37.30898], [-121.78422, 37.30917], [-121.78461, 37.30939], [-121.78526, 37.30929], [-121.78687, 37.31049], [-121.78755, 37.31086], [-121.78775, 37.31104], [-121.78779, 37.31116], [-121.78809, 37.31143], [-121.78864, 37.31114], [-121.78933, 37.31114], [-121.78991, 37.31117], [-121.79097, 37.31167], [-121.79112, 37.31226], [-121.79127, 37.31243], [-121.79175, 37.31255], [-121.79217, 37.31284], [-121.79244, 37.31296], [-121.79312, 37.31288], [-121.79345, 37.3127], [-121.79379, 37.31264], [-121.79406, 37.31267], [-121.79426, 37.31275], [-121.79438, 37.31282], [-121.7945, 37.31294], [-121.79473, 37.31291], [-121.79483, 37.31335], [-121.79509, 37.3135], [-121.79513, 37.31362]]], [[[-121.79481, 37.31439], [-121.7948, 37.31438], [-121.79471, 37.31425], [-121.79459, 37.31405], [-121.79481, 37.31439]]], [[[-121.79613, 37.31524], [-121.79613, 37.31524], [-121.79552, 37.31485], [-121.79588, 37.31504], [-121.79613, 37.31524]]], [[[-121.81151, 37.32935], [-121.81079, 37.33037], [-121.81076, 37.33045], [-121.81054, 37.33075], [-121.81035, 37.33126], [-121.8103, 37.33171], [-121.81034, 37.33223], [-121.81044, 37.33254], [-121.81064, 37.33281], [-121.81066, 37.33285], [-121.80993, 37.3331], [-121.80973, 37.33296], [-121.80954, 37.33262], [-121.80947, 37.33232], [-121.80943, 37.33195], [-121.80941, 37.33192], [-121.80949, 37.3313], [-121.80969, 37.33063], [-121.81024, 37.32976], [-121.81034, 37.32966], [-121.8104, 37.32944], [-121.81038, 37.32932], [-121.81034, 37.32919], [-121.80883, 37.32715], [-121.80873, 37.32712], [-121.80867, 37.32713], [-121.80862, 37.32709], [-121.80852, 37.32708], [-121.8077, 37.32482], [-121.80725, 37.32413], [-121.80355, 37.32011], [-121.80209, 37.3185], [-121.80088, 37.31775], [-121.79936, 37.31738], [-121.79859, 37.31709], [-121.79827, 37.31694], [-121.79787, 37.31671], [-121.79678, 37.3159], [-121.79656, 37.31569], [-121.79666, 37.31563], [-121.79685, 37.3158], [-121.79706, 37.31566], [-121.79718, 37.31568], [-121.79757, 37.31567], [-121.79833, 37.31623], [-121.79881, 37.31647], [-121.79921, 37.31657], [-121.79973, 37.31676], [-121.80033, 37.31684], [-121.80091, 37.31705], [-121.80124, 37.31704], [-121.80168, 37.31721], [-121.80265, 37.31783], [-121.80336, 37.31814], [-121.80365, 37.31844], [-121.80622, 37.32093], [-121.80628, 37.3213], [-121.80715, 37.32227], [-121.80764, 37.32306], [-121.80701, 37.32343], [-121.807, 37.32344], [-121.80917, 37.3257], [-121.80976, 37.32687], [-121.81151, 37.32935]]]]} | Restricted Access 2 | 1501 | Thompson Creek | 26312 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | Santa Clara 19 | 75.045 | Thompson Creek | 1930 | 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 | ||
3178 | 3178 | 3177 | {"type": "Polygon", "coordinates": [[[-121.93307, 36.98817], [-121.93305, 36.9883], [-121.93244, 36.98822], [-121.93247, 36.98809], [-121.93307, 36.98817]]]} | Open Access 1 | 1913 | Willowbrook Park - Soquel Creek Water District | 27591 | 2157 | Soquel Creek Water District 592 | Special District 4 | Water District 13 | http://www.soquelcreekwater.org/ | Special District 4 | 2157 | Soquel Creek Water District 582 | Special District 4 | Water District 13 | Santa Cruz 5 | 0.197 | Willowbrook Park - Soquel Creek Water District | 0 | Local Other or Unknown 14 | 4 | |
6428 | 6428 | 6427 | {"type": "Polygon", "coordinates": [[[-121.33786, 36.47151], [-121.33187, 36.47323], [-121.3318, 36.46281], [-121.3377, 36.46284], [-121.33786, 36.47151]]]} | No Public Access 3 | 1938 | Windmill Property | 27628 | 1336 | Soledad, City of 485 | City 2 | City Agency 2 | http://www.cityofsoledad.com/ | City 2 | 1336 | Soledad, City of 476 | City 2 | City Agency 2 | Monterey 14 | 139.773 | Windmill Property | 0 | Local Other or Unknown 14 | 4 | |
6466 | 6466 | 6465 | {"type": "Polygon", "coordinates": [[[-117.27321, 33.19], [-117.27305, 33.19012], [-117.27292, 33.19077], [-117.27299, 33.19089], [-117.27235, 33.19118], [-117.2714, 33.19154], [-117.26883, 33.19256], [-117.26869, 33.1927], [-117.26711, 33.19335], [-117.26697, 33.19342], [-117.26694, 33.19342], [-117.26676, 33.1935], [-117.26638, 33.19358], [-117.26615, 33.1936], [-117.26629, 33.19355], [-117.26664, 33.19337], [-117.26697, 33.19316], [-117.26841, 33.19181], [-117.26877, 33.19148], [-117.26933, 33.19093], [-117.26955, 33.19073], [-117.26992, 33.19051], [-117.27046, 33.19024], [-117.2708, 33.19001], [-117.27135, 33.18936], [-117.27148, 33.18924], [-117.27166, 33.18908], [-117.27193, 33.18894], [-117.27225, 33.18882], [-117.27306, 33.18867], [-117.27321, 33.19]]]} | Open Access 1 | 2018 | Buena Vista Creek | 16484 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 24.565 | Buena Vista Creek | 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 | |
4474 | 4474 | 4473 | {"type": "Polygon", "coordinates": [[[-118.79355, 34.05992], [-118.79347, 34.06171], [-118.78758, 34.06172], [-118.78748, 34.05991], [-118.79355, 34.05992]], [[-118.78798, 34.06012], [-118.78789, 34.06023], [-118.78799, 34.06049], [-118.78817, 34.06057], [-118.78837, 34.06052], [-118.78844, 34.0604], [-118.78835, 34.06025], [-118.78816, 34.06007], [-118.78798, 34.06012]]]} | Open Access 1 | 2664 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 26.845 | 0 | Local Other or Unknown 14 | 4 | ||
6548 | 6548 | 6547 | {"type": "Polygon", "coordinates": [[[-122.27836, 38.16698], [-122.27244, 38.16694], [-122.27213, 38.16617], [-122.26881, 38.16606], [-122.26808, 38.16422], [-122.27137, 38.16431], [-122.27832, 38.16431], [-122.27836, 38.16698]]]} | No Public Access 3 | 3636 | American Canyon Property | 15448 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 55.469 | American Canyon Property | 0 | Local Other or Unknown 14 | 4 | |
4477 | 4477 | 4476 | {"type": "MultiPolygon", "coordinates": [[[[-118.78326, 34.06724], [-118.78319, 34.06725], [-118.78314, 34.0671], [-118.78304, 34.06698], [-118.78289, 34.06691], [-118.78273, 34.06689], [-118.78256, 34.06692], [-118.78178, 34.06725], [-118.78103, 34.06725], [-118.781, 34.06673], [-118.78097, 34.06659], [-118.7809, 34.06646], [-118.7805, 34.06596], [-118.78035, 34.06587], [-118.78017, 34.06584], [-118.78, 34.06587], [-118.77985, 34.06595], [-118.77974, 34.06609], [-118.77971, 34.06624], [-118.77976, 34.06638], [-118.77983, 34.06647], [-118.78016, 34.06665], [-118.78026, 34.06677], [-118.78029, 34.06691], [-118.78028, 34.06725], [-118.77923, 34.06725], [-118.77921, 34.06359], [-118.78113, 34.06358], [-118.78102, 34.06375], [-118.78099, 34.0639], [-118.78101, 34.064], [-118.78106, 34.06409], [-118.78119, 34.0642], [-118.78136, 34.06425], [-118.78148, 34.06425], [-118.7816, 34.06422], [-118.78196, 34.06408], [-118.78208, 34.06408], [-118.78218, 34.06412], [-118.78222, 34.06417], [-118.78225, 34.06424], [-118.78233, 34.06476], [-118.7823, 34.06483], [-118.78215, 34.06496], [-118.78205, 34.06511], [-118.78202, 34.06522], [-118.78203, 34.06579], [-118.78202, 34.06588], [-118.78198, 34.06596], [-118.78172, 34.06625], [-118.78167, 34.06634], [-118.78164, 34.06644], [-118.78166, 34.06658], [-118.78172, 34.06667], [-118.7818, 34.06674], [-118.78189, 34.06679], [-118.78201, 34.06682], [-118.78218, 34.06681], [-118.78277, 34.06668], [-118.78292, 34.06668], [-118.78301, 34.06671], [-118.78314, 34.06679], [-118.78322, 34.06691], [-118.78326, 34.06724]]], [[[-118.78083, 34.06725], [-118.78047, 34.06725], [-118.78048, 34.06686], [-118.78044, 34.0667], [-118.78037, 34.0666], [-118.78029, 34.06652], [-118.77999, 34.06637], [-118.77995, 34.06632], [-118.77992, 34.06627], [-118.77991, 34.0662], [-118.77993, 34.06614], [-118.78003, 34.06604], [-118.7801, 34.06601], [-118.78017, 34.066], [-118.78025, 34.06601], [-118.78031, 34.06604], [-118.78036, 34.06609], [-118.78072, 34.06654], [-118.78078, 34.06664], [-118.78081, 34.06675], [-118.78083, 34.06725]]], [[[-118.78356, 34.06724], [-118.78346, 34.06724], [-118.78343, 34.06693], [-118.78337, 34.06678], [-118.78325, 34.06665], [-118.78308, 34.06656], [-118.78294, 34.06652], [-118.78274, 34.06651], [-118.78206, 34.06666], [-118.78195, 34.06663], [-118.78187, 34.06656], [-118.78184, 34.06647], [-118.78186, 34.06638], [-118.78215, 34.06605], [-118.78221, 34.0659], [-118.78222, 34.06519], [-118.78229, 34.06508], [-118.78244, 34.06495], [-118.7825, 34.06487], [-118.78253, 34.06477], [-118.78252, 34.06468], [-118.78243, 34.06416], [-118.78234, 34.06403], [-118.78225, 34.06396], [-118.78208, 34.06391], [-118.78196, 34.06391], [-118.78184, 34.06394], [-118.78144, 34.06408], [-118.78132, 34.06407], [-118.78123, 34.06401], [-118.78119, 34.06392], [-118.78119, 34.06385], [-118.78137, 34.06358], [-118.78345, 34.06357], [-118.78356, 34.06724]]], [[[-118.78299, 34.06725], [-118.78261, 34.06725], [-118.78223, 34.06725], [-118.78265, 34.06707], [-118.78275, 34.06705], [-118.78283, 34.06706], [-118.78292, 34.06711], [-118.78296, 34.06716], [-118.78299, 34.06725]]]]} | Open Access 1 | 3750 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 34.504 | 0 | Local Other or Unknown 14 | 4 | ||
6601 | 6601 | 6600 | {"type": "MultiPolygon", "coordinates": [[[[-119.50722, 34.39559], [-119.50661, 34.3957], [-119.50574, 34.39635], [-119.5055, 34.39636], [-119.50526, 34.39632], [-119.50526, 34.39623], [-119.50539, 34.39622], [-119.50563, 34.39619], [-119.50586, 34.39611], [-119.50597, 34.39606], [-119.50676, 34.39552], [-119.50722, 34.39559]]], [[[-119.51198, 34.39382], [-119.51152, 34.39386], [-119.51141, 34.39389], [-119.51064, 34.3943], [-119.51039, 34.39448], [-119.51014, 34.39416], [-119.51121, 34.39348], [-119.51144, 34.3934], [-119.51198, 34.39382]]]]} | Unknown Access 4 | 4238 | Carpinteria Creek | 16897 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 2.293 | Carpinteria Creek | 0 | Local Other or Unknown 14 | 4 | |
4481 | 4481 | 4480 | {"type": "Polygon", "coordinates": [[[-118.36745, 34.34431], [-118.36743, 34.34613], [-118.36606, 34.34614], [-118.36599, 34.34579], [-118.36591, 34.34567], [-118.36583, 34.34561], [-118.36568, 34.34555], [-118.36509, 34.34549], [-118.36511, 34.34439], [-118.36643, 34.34432], [-118.36745, 34.34431]]]} | Open Access 1 | 4296 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 9.278 | 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 | |
4482 | 4482 | 4481 | {"type": "Polygon", "coordinates": [[[-118.82809, 34.1109], [-118.82374, 34.11089], [-118.82373, 34.10731], [-118.82808, 34.10728], [-118.82809, 34.1109]]]} | Unknown Access 4 | 4333 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 39.614 | 0 | Local Other or Unknown 14 | 4 | ||
4483 | 4483 | 4482 | {"type": "Polygon", "coordinates": [[[-118.83243, 34.10717], [-118.83243, 34.10853], [-118.82873, 34.10863], [-118.82809, 34.10863], [-118.82808, 34.10727], [-118.82875, 34.10727], [-118.83243, 34.10717]]]} | Unknown Access 4 | 4342 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 14.94 | 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]);