units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
859 rows where ACCESS_TYP = 1 and DES_TP = 14 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP, DES_TP
MNG_AGENCY >30
- Ventura, City of 106
- Butte, County of 52
- Roseville, City of 46
- Lake, County of 36
- Poway, City of 35
- Santa Barbara, County of 30
- Mountains Recreation and Conservation Authority 30
- Irvine, City of 29
- California City, City of 25
- Encinitas, City of 21
- Orange, County of 21
- Monterey, County of 17
- Seaside, City of 16
- Lompoc, City of 14
- Napa, City of 13
- Santa Cruz, City of 12
- Oroville, City of 12
- Mammoth Lakes, Town of 11
- Rocklin, City of 11
- Auburn, City of 11
- Los Angeles, City of 10
- Los Angeles, County of 9
- Santa Maria, City of 9
- Guadalupe, City of 9
- San Lorenzo Valley Water District 8
- La Selva Beach Recreation District 8
- San Diego, City of 7
- Scotts Valley, City of 7
- Watsonville, City of 6
- San Luis Obispo, City of 6
- …
ACCESS_TYP 1
- Open Access · 859 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4469 | 4469 | 4468 | {"type": "Polygon", "coordinates": [[[-117.06249, 32.75242], [-117.06211, 32.75251], [-117.06106, 32.75279], [-117.06087, 32.75234], [-117.0624, 32.75219], [-117.06249, 32.75242]]]} | Open Access 1 | 94 | Unnamed site - San Diego, City of | 28704 | 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 | 1.367 | 0 | Local Other or Unknown 14 | 4 | ||
5870 | 5870 | 5869 | {"type": "Polygon", "coordinates": [[[-121.86762, 37.40876], [-121.8673, 37.40914], [-121.86705, 37.40917], [-121.86399, 37.40917], [-121.86362, 37.40915], [-121.86337, 37.40916], [-121.863, 37.40924], [-121.86265, 37.4094], [-121.86231, 37.40952], [-121.86218, 37.40956], [-121.86184, 37.4096], [-121.86169, 37.40964], [-121.86155, 37.40971], [-121.86142, 37.4098], [-121.86128, 37.40993], [-121.86122, 37.40996], [-121.86119, 37.41], [-121.86101, 37.41017], [-121.86085, 37.41039], [-121.86069, 37.4107], [-121.86053, 37.41085], [-121.86026, 37.41105], [-121.86008, 37.41115], [-121.85954, 37.41138], [-121.85917, 37.41151], [-121.85895, 37.41163], [-121.85883, 37.41174], [-121.85854, 37.41212], [-121.85837, 37.41242], [-121.85817, 37.41268], [-121.85801, 37.41296], [-121.85746, 37.41395], [-121.85741, 37.4141], [-121.85738, 37.41423], [-121.85732, 37.41436], [-121.85723, 37.41449], [-121.85708, 37.41462], [-121.85698, 37.41475], [-121.85678, 37.41508], [-121.85672, 37.41513], [-121.85655, 37.41521], [-121.85633, 37.4156], [-121.85611, 37.41527], [-121.85724, 37.4133], [-121.85729, 37.41313], [-121.8575, 37.41286], [-121.8579, 37.41214], [-121.85814, 37.41177], [-121.85844, 37.41144], [-121.85879, 37.41114], [-121.85895, 37.41104], [-121.85941, 37.41081], [-121.85915, 37.41044], [-121.85829, 37.40994], [-121.85823, 37.40999], [-121.85769, 37.40992], [-121.85757, 37.41], [-121.85719, 37.40977], [-121.85797, 37.40946], [-121.85839, 37.40936], [-121.8588, 37.40923], [-121.86014, 37.40863], [-121.86019, 37.40864], [-121.86022, 37.40866], [-121.8607, 37.40934], [-121.86073, 37.40944], [-121.86081, 37.40948], [-121.86088, 37.40948], [-121.86091, 37.40951], [-121.86099, 37.40945], [-121.86144, 37.40924], [-121.86179, 37.40915], [-121.86219, 37.4091], [-121.8623, 37.40906], [-121.86258, 37.40891], [-121.86276, 37.40884], [-121.86297, 37.40878], [-121.86331, 37.40874], [-121.86363, 37.40875], [-121.8642, 37.40879], [-121.86683, 37.40879], [-121.86725, 37.40881], [-121.86762, 37.40876]]]} | Open Access 1 | 246 | Berryessa Creek | 16036 | 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 | Santa Clara 19 | 25.184 | Berryessa Creek | 1979 | 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 | |
5990 | 5990 | 5989 | {"type": "MultiPolygon", "coordinates": [[[[-119.5293, 34.4012], [-119.5292, 34.40139], [-119.52908, 34.40167], [-119.52915, 34.4018], [-119.52905, 34.40199], [-119.52881, 34.40192], [-119.52912, 34.40112], [-119.5293, 34.4012]]], [[[-119.5289, 34.40218], [-119.52879, 34.40304], [-119.52879, 34.40348], [-119.52865, 34.40345], [-119.52865, 34.40307], [-119.52876, 34.40214], [-119.5289, 34.40218]]], [[[-119.52886, 34.40434], [-119.52884, 34.40463], [-119.52873, 34.40461], [-119.52875, 34.40449], [-119.52868, 34.40447], [-119.52866, 34.404], [-119.52868, 34.404], [-119.52886, 34.40434]]], [[[-119.52876, 34.40482], [-119.52868, 34.40513], [-119.52842, 34.40587], [-119.52806, 34.4067], [-119.52792, 34.40707], [-119.52795, 34.40708], [-119.5279, 34.40723], [-119.52782, 34.40744], [-119.5274, 34.40831], [-119.52726, 34.40872], [-119.52711, 34.40929], [-119.5266, 34.41374], [-119.5263, 34.41385], [-119.52635, 34.41365], [-119.52678, 34.40968], [-119.52686, 34.40923], [-119.52698, 34.40879], [-119.52713, 34.40837], [-119.52808, 34.40625], [-119.52833, 34.40556], [-119.52858, 34.4048], [-119.52876, 34.40482]]], [[[-119.52796, 34.42581], [-119.52762, 34.42608], [-119.52787, 34.42631], [-119.52779, 34.42645], [-119.52752, 34.42646], [-119.52752, 34.42634], [-119.52731, 34.4262], [-119.52769, 34.42541], [-119.52761, 34.42489], [-119.52731, 34.42485], [-119.52677, 34.42469], [-119.52676, 34.4245], [-119.52655, 34.42433], [-119.52618, 34.42437], [-119.52604, 34.42421], [-119.52557, 34.42425], [-119.52537, 34.42401], [-119.52509, 34.42402], [-119.52507, 34.42393], [-119.52538, 34.42387], [-119.52549, 34.42355], [-119.52539, 34.42323], [-119.52547, 34.4227], [-119.52599, 34.42123], [-119.52575, 34.42096], [-119.52564, 34.42069], [-119.52583, 34.42065], [-119.52588, 34.42077], [-119.526, 34.42077], [-119.52629, 34.42028], [-119.52629, 34.41998], [-119.52656, 34.41997], [-119.52684, 34.41942], [-119.52669, 34.4191], [-119.52673, 34.41863], [-119.52703, 34.41834], [-119.52701, 34.41806], [-119.5268, 34.41746], [-119.52644, 34.4166], [-119.52632, 34.4164], [-119.52628, 34.41577], [-119.52661, 34.41577], [-119.52674, 34.41652], [-119.52705, 34.41732], [-119.52731, 34.41768], [-119.52766, 34.41829], [-119.52759, 34.41936], [-119.52738, 34.41936], [-119.52686, 34.42026], [-119.52696, 34.42048], [-119.5268, 34.42071], [-119.52685, 34.42101], [-119.5272, 34.42146], [-119.52749, 34.42167], [-119.52745, 34.42187], [-119.52772, 34.42235], [-119.52772, 34.42348], [-119.52738, 34.42419], [-119.52727, 34.42434], [-119.52743, 34.42449], [-119.52781, 34.42464], [-119.52803, 34.42496], [-119.5281, 34.42531], [-119.52796, 34.42581]], [[-119.52669, 34.42195], [-119.52704, 34.42197], [-119.52707, 34.42164], [-119.52672, 34.42112], [-119.52662, 34.42057], [-119.52656, 34.42055], [-119.52637, 34.42076], [-119.52639, 34.42128], [-119.52666, 34.42157], [-119.52669, 34.42195]]]]} | Open Access 1 | 599 | Santa Monica Creek | 25118 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 31.846 | Santa Monica Creek | 0 | Local Other or Unknown 14 | 4 | |
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 |
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 | |
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 | ||
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 | ||
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 | ||
4485 | 4485 | 4484 | {"type": "Polygon", "coordinates": [[[-116.23302, 33.58134], [-116.23293, 33.58128], [-116.23136, 33.57741], [-116.23092, 33.57648], [-116.22951, 33.57441], [-116.22812, 33.57509], [-116.22717, 33.57368], [-116.22436, 33.5737], [-116.22436, 33.57461], [-116.22274, 33.57463], [-116.22139, 33.57376], [-116.22098, 33.57302], [-116.22093, 33.57256], [-116.22053, 33.57243], [-116.22029, 33.57202], [-116.21854, 33.57148], [-116.21604, 33.57082], [-116.21605, 33.56939], [-116.22448, 33.56938], [-116.22417, 33.57223], [-116.22418, 33.57224], [-116.22904, 33.56937], [-116.233, 33.56936], [-116.23299, 33.57257], [-116.23302, 33.58134]]]} | Open Access 1 | 4461 | Unnamed site - Riverside County Regional Park and Open Space District | 28656 | 2123 | Riverside County Regional Park and Open Space District 262 | Special District 4 | Recreation/Parks District 4 | http://www.riversidecountyparks.org/ | Special District 4 | 2123 | Riverside County Regional Park and Open Space District 258 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 187.128 | 0 | Local Other or Unknown 14 | 4 | ||
6737 | 6737 | 6736 | {"type": "Polygon", "coordinates": [[[-122.03598, 37.62441], [-122.03477, 37.62527], [-122.02785, 37.61905], [-122.0275, 37.61927], [-122.02683, 37.61864], [-122.02714, 37.61843], [-122.02714, 37.61841], [-122.02541, 37.61685], [-122.02383, 37.61546], [-122.025, 37.61493], [-122.02533, 37.61507], [-122.02541, 37.61558], [-122.02606, 37.61578], [-122.02551, 37.6161], [-122.02551, 37.61612], [-122.02586, 37.61626], [-122.02596, 37.61635], [-122.0261, 37.61629], [-122.02619, 37.6165], [-122.027, 37.61691], [-122.02703, 37.61697], [-122.02748, 37.61694], [-122.02752, 37.61708], [-122.0276, 37.61722], [-122.02769, 37.61732], [-122.02793, 37.61754], [-122.02831, 37.61728], [-122.02844, 37.61738], [-122.029, 37.61799], [-122.02907, 37.61807], [-122.02902, 37.61828], [-122.02923, 37.61868], [-122.02909, 37.61922], [-122.02966, 37.6193], [-122.02981, 37.61926], [-122.03015, 37.61907], [-122.0305, 37.61923], [-122.03127, 37.62017], [-122.03116, 37.62025], [-122.03122, 37.62063], [-122.03175, 37.62081], [-122.03201, 37.62079], [-122.03174, 37.62155], [-122.03264, 37.62176], [-122.0328, 37.62189], [-122.03275, 37.62243], [-122.03287, 37.62265], [-122.03458, 37.62408], [-122.03509, 37.62432], [-122.03598, 37.62441]]]} | Open Access 1 | 5068 | Taper Park Property | 26183 | 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 | 39.626 | Taper Park Property | 1975 | 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 | |
740 | 740 | 739 | {"type": "MultiPolygon", "coordinates": [[[[-122.43261, 37.73842], [-122.43248, 37.73852], [-122.4324, 37.73848], [-122.43211, 37.73825], [-122.432, 37.7382], [-122.43185, 37.73817], [-122.43168, 37.73818], [-122.43124, 37.7383], [-122.43104, 37.73798], [-122.43159, 37.73777], [-122.43195, 37.73779], [-122.43261, 37.73842]]], [[[-122.43549, 37.74395], [-122.43519, 37.74397], [-122.43518, 37.7439], [-122.435, 37.74391], [-122.43495, 37.74329], [-122.43544, 37.74326], [-122.43547, 37.74327], [-122.43549, 37.74395]]]]} | Open Access 1 | 5519 | Diamond Hights Lot3 | 18142 | 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 | 2.023 | Diamond Hights Lot3 | 0 | Local Other or Unknown 14 | 4 | |
4492 | 4492 | 4491 | {"type": "Polygon", "coordinates": [[[-118.35128, 33.78024], [-118.35122, 33.78036], [-118.35108, 33.78051], [-118.35086, 33.78065], [-118.35069, 33.7807], [-118.35057, 33.78035], [-118.35093, 33.78032], [-118.35092, 33.78], [-118.35108, 33.78], [-118.35119, 33.78003], [-118.35127, 33.78011], [-118.35128, 33.78024]]]} | Open Access 1 | 5914 | Unnamed site - Westfield Recreation and Park District | 28676 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.653 | 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]);