units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
204 rows where ACCESS_TYP = 4 and DES_TP = 14 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, COUNTY
MNG_AGENCY 19
- Mountains Recreation and Conservation Authority 118
- Yuba County Water Agency 48
- Santa Barbara, City of 9
- Santa Barbara, County of 8
- Santa Barbara Flood Control and Water Conserv. District 4
- Los Angeles, City of 2
- Carpinteria, City of 2
- Ramona Municipal Water District 2
- San Diego, County of 1
- Clovis, City of 1
- Guadalupe, City of 1
- Sacramento, County of 1
- Rio Dell, City of 1
- Sacramento and San Joaquin Drainage District 1
- Orange County Water District 1
- Helix Water District 1
- Santa Ynez River Water Conservation District 1
- Western Riverside County Regional Conservation Authority 1
- North County Transit District 1
MNG_AG_TYP 6
DES_TP 1
- Local Other or Unknown · 204 ✖
ACCESS_TYP 1
- Unknown Access · 204 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14716 | 14716 | 14715 | {"type": "Polygon", "coordinates": [[[-116.38556, 32.97589], [-116.38485, 32.97959], [-116.38064, 32.97968], [-116.37621, 32.97986], [-116.37679, 32.97617], [-116.3768, 32.9758], [-116.38134, 32.97552], [-116.38136, 32.97593], [-116.38556, 32.97589]]]} | Unknown Access 4 | 47814 | Unnamed site - San Diego, County of | 31715 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 87.174 | 0 | Local Other or Unknown 14 | 4 | ||
4769 | 4769 | 4768 | {"type": "Polygon", "coordinates": [[[-124.10344, 40.4928], [-124.10326, 40.49301], [-124.10325, 40.49313], [-124.10297, 40.49314], [-124.10296, 40.49296], [-124.103, 40.49297], [-124.10313, 40.4928], [-124.10344, 40.4928]]]} | Unknown Access 4 | 46929 | Unnamed site - Rio Dell, City of | 30545 | 1435 | Rio Dell, City of 642 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | Humboldt 45 | 0.236 | 0 | Local Other or Unknown 14 | 4 | ||
4759 | 4759 | 4758 | {"type": "Polygon", "coordinates": [[[-116.89337, 32.86769], [-116.89335, 32.87083], [-116.89269, 32.87075], [-116.89171, 32.87067], [-116.89084, 32.87071], [-116.88852, 32.8713], [-116.88757, 32.87172], [-116.88715, 32.87197], [-116.88627, 32.87239], [-116.88579, 32.87264], [-116.88517, 32.87306], [-116.88341, 32.87378], [-116.88276, 32.87409], [-116.88211, 32.8745], [-116.88159, 32.87481], [-116.88042, 32.87556], [-116.87951, 32.87611], [-116.87854, 32.87675], [-116.87777, 32.87717], [-116.87882, 32.87389], [-116.88144, 32.87294], [-116.88354, 32.87188], [-116.88375, 32.87177], [-116.88407, 32.87153], [-116.88412, 32.87153], [-116.88423, 32.87144], [-116.88619, 32.86953], [-116.88642, 32.86932], [-116.88665, 32.86914], [-116.88691, 32.86897], [-116.88719, 32.86882], [-116.88743, 32.86871], [-116.88787, 32.86854], [-116.88831, 32.86843], [-116.89254, 32.868], [-116.89295, 32.86788], [-116.89337, 32.86769]]]} | Unknown Access 4 | 46690 | Unnamed site - Helix Water District | 30035 | 2046 | Helix Water District 777 | Special District 4 | Water District 13 | http://www.hwd.com | Special District 4 | 2046 | Helix Water District 757 | Special District 4 | Water District 13 | San Diego 4 | 97.198 | 0 | Local Other or Unknown 14 | 4 | ||
4718 | 4718 | 4717 | {"type": "Polygon", "coordinates": [[[-118.28418, 34.23377], [-118.28386, 34.23376], [-118.28045, 34.23393], [-118.27981, 34.23393], [-118.27976, 34.22908], [-118.27539, 34.22911], [-118.27538, 34.22816], [-118.28411, 34.2281], [-118.28418, 34.23377]]]} | Unknown Access 4 | 46522 | Unnamed site - Los Angeles, City of | 29809 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 73.646 | 0 | Local Other or Unknown 14 | 4 | ||
15516 | 15516 | 15515 | {"type": "MultiPolygon", "coordinates": [[[[-118.32788, 34.25114], [-118.32274, 34.2498], [-118.32247, 34.24892], [-118.32243, 34.24892], [-118.32214, 34.24798], [-118.32193, 34.24741], [-118.32174, 34.24699], [-118.32152, 34.24658], [-118.3211, 34.24592], [-118.32081, 34.24554], [-118.32051, 34.24517], [-118.32018, 34.24482], [-118.31982, 34.24448], [-118.31945, 34.24416], [-118.31906, 34.24385], [-118.31864, 34.24356], [-118.31808, 34.24321], [-118.31762, 34.24296], [-118.317, 34.24267], [-118.31652, 34.24247], [-118.31585, 34.24224], [-118.315, 34.24201], [-118.31212, 34.2414], [-118.31148, 34.24125], [-118.31101, 34.24111], [-118.31055, 34.24095], [-118.3101, 34.24077], [-118.30966, 34.24057], [-118.30896, 34.24019], [-118.3083, 34.23977], [-118.30374, 34.23646], [-118.30332, 34.23618], [-118.30289, 34.23591], [-118.30244, 34.23566], [-118.30198, 34.23543], [-118.30152, 34.23523], [-118.30087, 34.23499], [-118.30019, 34.23478], [-118.2996, 34.23463], [-118.2989, 34.2345], [-118.29819, 34.23441], [-118.29765, 34.23437], [-118.29693, 34.23435], [-118.29623, 34.23437], [-118.2962, 34.2339], [-118.29657, 34.23322], [-118.29648, 34.23295], [-118.29674, 34.2329], [-118.29728, 34.23289], [-118.29747, 34.23286], [-118.29763, 34.23282], [-118.29824, 34.23261], [-118.2986, 34.23263], [-118.29898, 34.23269], [-118.2993, 34.23277], [-118.2997, 34.23291], [-118.3001, 34.23309], [-118.3003, 34.23316], [-118.30163, 34.23351], [-118.30227, 34.23364], [-118.30351, 34.23379], [-118.30382, 34.23387], [-118.30402, 34.23394], [-118.30418, 34.23403], [-118.30515, 34.2347], [-118.30533, 34.2348], [-118.30569, 34.23494], [-118.30608, 34.23501], [-118.30641, 34.23501], [-118.30674, 34.23496], [-118.307, 34.23488], [-118.30749, 34.23467], [-118.30766, 34.23463], [-118.31037, 34.23445], [-118.31057, 34.23439], [-118.31098, 34.23419], [-118.31116, 34.23415], [-118.31135, 34.23416], [-118.31289, 34.23452], [-118.31307, 34.23452], [-118.31358, 34.23445], [-118.31375, 34.23446], [-118.31383, 34.23448], [-118.31383, 34.23581], [-118.31381, 34.23755], [-118.3198, 34.23758], [-118.31981, 34.23711], [-118.32024, 34.23729], [-118.32023, 34.23766], [-118.31938, 34.23839], [-118.31912, 34.23875], [-118.31955, 34.23953], [-118.32114, 34.23952], [-118.32237, 34.24026], [-118.32233, 34.24325], [-118.32411, 34.2432], [-118.32788, 34.25114]]], [[[-118.31383, 34.23431], [-118.31357, 34.23429], [-118.31305, 34.23435], [-118.3129, 34.23435], [-118.31139, 34.234], [-118.31115, 34.23399], [-118.31089, 34.23404], [-118.31048, 34.23424], [-118.31033, 34.23428], [-118.30762, 34.23446], [-118.30741, 34.23452], [-118.30691, 34.23473], [-118.30671, 34.23479], [-118.30642, 34.23484], [-118.30615, 34.23485], [-118.30578, 34.23479], [-118.30543, 34.23466], [-118.30528, 34.23457], [-118.30432, 34.23391], [-118.30407, 34.23378], [-118.3045, 34.23382], [-118.30494, 34.2338], [-118.30523, 34.23376], [-118.30632, 34.23354], [-118.30675, 34.2335], [-118.30719, 34.23352], [-118.30817, 34.23368], [-118.30847, 34.2337], [-118.30883, 34.23369], [-118.30913, 34.23366], [-118.30942, 34.2336], [-118.31019, 34.2334], [-118.31044, 34.23334], [-118.31074, 34.23331], [-118.31109, 34.23331], [-118.31157, 34.23338], [-118.31215, 34.23354], [-118.3125, 34.23362], [-118.31346, 34.23371], [-118.31383, 34.23378], [-118.31383, 34.23431]]], [[[-118.32181, 34.24954], [-118.32023, 34.24912], [-118.32023, 34.24885], [-118.31914, 34.24884], [-118.31477, 34.24768], [-118.31483, 34.24349], [-118.31371, 34.24354], [-118.31366, 34.24739], [-118.31147, 34.2468], [-118.31149, 34.24357], [-118.30931, 34.24364], [-118.3093, 34.24484], [-118.30829, 34.24484], [-118.30829, 34.24596], [-118.30491, 34.24506], [-118.30492, 34.24378], [-118.30503, 34.24377], [-118.30502, 34.24296], [-118.30556, 34.24288], [-118.30665, 34.24141], [-118.3061, 34.24015], [-118.30692, 34.2396], [-118.30796, 34.24034], [-118.30853, 34.2407], [-118.30929, 34.2411], [-118.31008, 34.24145], [-118.31091, 34.24174], [-118.3116, 34.24192], [-118.31467, 34.24257], [-118.31546, 34.24278], [-118.31608, 34.24299], [-118.31668, 34.24323], [-118.31722, 34.24349], [-118.31778, 34.2438], [-118.31818, 34.24405], [-118.31856, 34.24432], [-118.31892, 34.2446], [-118.31927, 34.2449], [-118.3196, 34.24521], [-118.3199, 34.24554], [-118.32019, 34.24588], [-118.32045, 34.24624], [-118.32069, 34.2466], [-118.32091, 34.24697], [-118.32122, 34.24762], [-118.32142, 34.24814], [-118.32171, 34.24907], [-118.32167, 34.24909], [-118.32181, 34.24954]]], [[[-118.30829, 34.24639], [-118.30829, 34.24709], [-118.30809, 34.24704], [-118.30747, 34.2467], [-118.30743, 34.24663], [-118.30739, 34.24634], [-118.30736, 34.24627], [-118.30728, 34.24618], [-118.30716, 34.24613], [-118.30707, 34.24612], [-118.30698, 34.24614], [-118.30615, 34.24647], [-118.30606, 34.24651], [-118.30591, 34.24663], [-118.30534, 34.24562], [-118.30829, 34.24639]]], [[[-118.30725, 34.24657], [-118.3072, 34.24639], [-118.3072, 34.24639], [-118.30723, 34.24639], [-118.30725, 34.24657]]], [[[-118.31366, 34.24782], [-118.31365, 34.24835], [-118.31337, 34.24831], [-118.31268, 34.24835], [-118.31256, 34.24832], [-118.31245, 34.24826], [-118.31261, 34.24754], [-118.31366, 34.24782]]], [[[-118.31743, 34.24883], [-118.31475, 34.24882], [-118.31476, 34.24811], [-118.31476, 34.24811], [-118.31743, 34.24883]]], [[[-118.32258, 34.25247], [-118.32018, 34.25246], [-118.32023, 34.24955], [-118.32195, 34.25001], [-118.32237, 34.25136], [-118.32258, 34.25192], [-118.32258, 34.25247]]], [[[-118.32851, 34.25262], [-118.32832, 34.25597], [-118.32778, 34.25641], [-118.32748, 34.25627], [-118.32733, 34.25616], [-118.32721, 34.25603], [-118.32672, 34.25592], [-118.32647, 34.25565], [-118.32649, 34.25532], [-118.32629, 34.25541], [-118.32623, 34.25541], [-118.32616, 34.25533], [-118.32665, 34.25502], [-118.3269, 34.25475], [-118.3272, 34.25454], [-118.3281, 34.254], [-118.32798, 34.2536], [-118.32812, 34.25287], [-118.32776, 34.25256], [-118.32709, 34.25239], [-118.32678, 34.25225], [-118.32659, 34.25202], [-118.32646, 34.25156], [-118.32619, 34.25128], [-118.32592, 34.25118], [-118.32529, 34.25124], [-118.32518, 34.25131], [-118.32498, 34.25174], [-118.32479, 34.25207], [-118.32461, 34.25251], [-118.32433, 34.25283], [-118.32486, 34.25394], [-118.32485, 34.25396], [-118.32449, 34.25355], [-118.32413, 34.25309], [-118.32389, 34.25272], [-118.32361, 34.25222], [-118.32342, 34.25184], [-118.32326, 34.25145], [-118.32289, 34.25027], [-118.32805, 34.25162], [-118.32851, 34.25262]]]]} | Unknown Access 4 | 46477 | Unnamed site - Desert and Mountain Conservation Authority | 29750 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 570.486 | 0 | Local Other or Unknown 14 | 4 | ||
15589 | 15589 | 15588 | {"type": "Polygon", "coordinates": [[[-118.00977, 34.00681], [-118.00047, 34.02256], [-117.99322, 34.01961], [-117.99553, 34.01569], [-117.99582, 34.0158], [-117.99633, 34.01493], [-117.99605, 34.0148], [-118.00515, 33.99931], [-118.00592, 33.99969], [-118.00608, 33.99979], [-118.00624, 33.99992], [-118.00635, 34.00003], [-118.00702, 34.00098], [-118.00716, 34.00115], [-118.00742, 34.00135], [-118.00767, 34.00147], [-118.0079, 34.00193], [-118.00888, 34.00585], [-118.00977, 34.00681]]]} | Unknown Access 4 | 6546 | Hacienda Hills Open Space - Sanitation District | 29676 | 2139 | Sanitation Districts of Los Angeles County 290 | Special District 4 | Sanitation District 18 | http://www.lacsd.org/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 419.341 | Hacienda Hills OS - Sanitation District | 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 | ||
4504 | 4504 | 4503 | {"type": "MultiPolygon", "coordinates": [[[[-118.27189, 34.25899], [-118.2716, 34.25922], [-118.2716, 34.25779], [-118.27178, 34.25778], [-118.27189, 34.25756], [-118.27189, 34.25899]]], [[[-118.27237, 34.25554], [-118.27236, 34.25643], [-118.27206, 34.25642], [-118.27207, 34.25578], [-118.27217, 34.25566], [-118.27237, 34.25554]]], [[[-118.27285, 34.2587], [-118.27285, 34.25987], [-118.27263, 34.25987], [-118.27263, 34.25887], [-118.27285, 34.2587]]], [[[-118.27406, 34.25636], [-118.27354, 34.2563], [-118.27351, 34.25638], [-118.27362, 34.25645], [-118.27348, 34.25653], [-118.27348, 34.25563], [-118.27335, 34.25554], [-118.27335, 34.25468], [-118.27359, 34.25468], [-118.27359, 34.25569], [-118.27369, 34.25576], [-118.27406, 34.25565], [-118.27406, 34.25636]]]]} | Unknown Access 4 | 6855 | 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 | 3.721 | 0 | Local Other or Unknown 14 | 4 | ||
4511 | 4511 | 4510 | {"type": "Polygon", "coordinates": [[[-118.75427, 34.16206], [-118.7528, 34.16289], [-118.75305, 34.16324], [-118.75218, 34.16381], [-118.75052, 34.1638], [-118.75016, 34.1634], [-118.74922, 34.16397], [-118.74932, 34.16485], [-118.74577, 34.16484], [-118.74578, 34.15444], [-118.75019, 34.15445], [-118.75017, 34.15687], [-118.75077, 34.15683], [-118.75171, 34.15863], [-118.75245, 34.15924], [-118.75258, 34.15956], [-118.75315, 34.16008], [-118.75269, 34.16057], [-118.75282, 34.16118], [-118.75304, 34.16161], [-118.75416, 34.1616], [-118.75427, 34.16206]]]} | Unknown Access 4 | 7093 | 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 | 154.044 | 0 | Local Other or Unknown 14 | 4 | ||
4717 | 4717 | 4716 | {"type": "MultiPolygon", "coordinates": [[[[-118.28411, 34.2281], [-118.27538, 34.22816], [-118.27531, 34.22178], [-118.28404, 34.22172], [-118.28411, 34.2281]]], [[[-118.28844, 34.22398], [-118.28698, 34.22399], [-118.28696, 34.22261], [-118.28842, 34.2226], [-118.28844, 34.22398]]]]} | Unknown Access 4 | 46232 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 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 | 145.787 | 0 | Local Other or Unknown 14 | 4 | ||
4719 | 4719 | 4718 | {"type": "Polygon", "coordinates": [[[-118.74907, 34.06809], [-118.74798, 34.0681], [-118.74796, 34.06714], [-118.74905, 34.06714], [-118.74907, 34.06809]]]} | Unknown Access 4 | 46299 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 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 | 2.649 | 0 | Local Other or Unknown 14 | 4 | ||
4720 | 4720 | 4719 | {"type": "MultiPolygon", "coordinates": [[[[-118.56182, 34.13031], [-118.56164, 34.13032], [-118.56143, 34.13032], [-118.56123, 34.13029], [-118.56106, 34.13025], [-118.56165, 34.13023], [-118.56182, 34.13031]]], [[[-118.56397, 34.13076], [-118.56369, 34.1306], [-118.56322, 34.13042], [-118.56305, 34.13032], [-118.56291, 34.13028], [-118.56277, 34.13028], [-118.56259, 34.13021], [-118.56397, 34.13019], [-118.56397, 34.13076]]]]} | Unknown Access 4 | 46300 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 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 | 0.975 | 0 | Local Other or Unknown 14 | 4 | ||
4712 | 4712 | 4711 | {"type": "Polygon", "coordinates": [[[-118.3348, 34.47457], [-118.33031, 34.47454], [-118.33057, 34.47368], [-118.33068, 34.47342], [-118.33085, 34.47319], [-118.33177, 34.47219], [-118.33185, 34.47206], [-118.33189, 34.47193], [-118.33191, 34.47178], [-118.33188, 34.47164], [-118.33164, 34.47101], [-118.33169, 34.47099], [-118.33165, 34.47051], [-118.33145, 34.46989], [-118.33163, 34.46853], [-118.33139, 34.46785], [-118.33212, 34.46785], [-118.33211, 34.4674], [-118.33438, 34.46714], [-118.33437, 34.4673], [-118.3348, 34.47457]]]} | Unknown Access 4 | 46211 | Unnamed site - Santa Clarita Watershed Recreation and Conservation Authority | 29506 | 2390 | Santa Clarita Watershed Recreation and Conservation Authority 776 | Special District 4 | Recreation/Parks District 4 | http://smmc.ca.gov/SCWRCA.asp | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 58.139 | 0 | Local Other or Unknown 14 | 4 | ||
3896 | 3896 | 3895 | {"type": "Polygon", "coordinates": [[[-118.57142, 34.12782], [-118.57142, 34.12931], [-118.56528, 34.12931], [-118.5662, 34.12783], [-118.57142, 34.12782]]]} | Unknown Access 4 | 45829 | Steers Property | 28848 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 21.351 | Steers Property | 0 | Local Other or Unknown 14 | 4 | |
4487 | 4487 | 4486 | {"type": "Polygon", "coordinates": [[[-117.65095, 33.91007], [-117.65019, 33.91006], [-117.64981, 33.90897], [-117.65009, 33.9089], [-117.65007, 33.90881], [-117.65045, 33.90848], [-117.65044, 33.90828], [-117.64965, 33.9076], [-117.64926, 33.90648], [-117.65093, 33.90642], [-117.65095, 33.91007]]]} | Unknown Access 4 | 4844 | Unnamed site - Orange County Water District | 28653 | 2105 | Orange County Water District 768 | Special District 4 | Water District 13 | http://www.ocwd.com/ | Special District 4 | 2105 | Orange County Water District 749 | Special District 4 | Water District 13 | Riverside 10 | 9.715 | 0 | Local Other or Unknown 14 | 4 | ||
1208 | 1208 | 1207 | {"type": "Polygon", "coordinates": [[[-118.6372, 34.36427], [-118.62414, 34.36475], [-118.62394, 34.35736], [-118.63275, 34.35717], [-118.63292, 34.36076], [-118.63708, 34.36067], [-118.6372, 34.36427]]]} | Unknown Access 4 | 8425 | 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 | 201.929 | 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 | ||
4489 | 4489 | 4488 | {"type": "MultiPolygon", "coordinates": [[[[-118.21759, 34.10846], [-118.21735, 34.1085], [-118.21726, 34.10813], [-118.21751, 34.10809], [-118.21759, 34.10846]]], [[[-118.21918, 34.10822], [-118.21901, 34.10857], [-118.21832, 34.10834], [-118.21784, 34.10842], [-118.21775, 34.10805], [-118.21837, 34.10795], [-118.21918, 34.10822]]]]} | Unknown Access 4 | 4922 | 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 | 1.517 | 0 | Local Other or Unknown 14 | 4 | ||
4507 | 4507 | 4506 | {"type": "Polygon", "coordinates": [[[-118.37116, 34.12047], [-118.37096, 34.12061], [-118.37088, 34.12062], [-118.37083, 34.12058], [-118.37088, 34.12031], [-118.37103, 34.12024], [-118.37116, 34.12047]]]} | Unknown Access 4 | 6890 | 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 | 0.191 | 0 | Local Other or Unknown 14 | 4 | ||
4514 | 4514 | 4513 | {"type": "Polygon", "coordinates": [[[-118.36336, 34.26205], [-118.36208, 34.26532], [-118.36242, 34.26582], [-118.36086, 34.2658], [-118.36086, 34.2641], [-118.36323, 34.26203], [-118.36336, 34.26205]]]} | Unknown Access 4 | 12349 | 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 | 10.984 | 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]);