units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
58 rows where DES_TP = 3 and MNG_AGENCY = 27 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, COUNTY, YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 58 ✖
DES_TP 1
- Local Recreation Area · 58 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12859 | 12859 | 12858 | {"type": "Polygon", "coordinates": [[[-118.86847, 34.16213], [-118.86844, 34.16602], [-118.86617, 34.16601], [-118.86505, 34.16542], [-118.86467, 34.16666], [-118.86465, 34.16679], [-118.86444, 34.16674], [-118.8643, 34.16664], [-118.86415, 34.16656], [-118.86399, 34.16651], [-118.86322, 34.16645], [-118.86311, 34.1664], [-118.86303, 34.1663], [-118.86238, 34.16652], [-118.86152, 34.16653], [-118.86127, 34.16711], [-118.86113, 34.1681], [-118.86098, 34.16814], [-118.86105, 34.1684], [-118.85971, 34.16867], [-118.85992, 34.16927], [-118.86095, 34.16976], [-118.86073, 34.17007], [-118.86031, 34.16996], [-118.85986, 34.17012], [-118.8591, 34.17141], [-118.85928, 34.17173], [-118.85655, 34.17177], [-118.85652, 34.16546], [-118.85073, 34.16559], [-118.85068, 34.16209], [-118.86847, 34.16213]]]} | Open Access 1 | 47120 | Conejo Ridge Open Space | 30797 | 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 | http://www.conejo-openspace.org/open_space_areas_in_TO.htm#Conejo Ridge | Ventura 8 | 227.814 | Conejo Ridge OS | 0 | Local Recreation Area 3 | 4 |
16220 | 16220 | 16219 | {"type": "Polygon", "coordinates": [[[-118.81321, 34.22577], [-118.81138, 34.22607], [-118.81104, 34.22615], [-118.81059, 34.22627], [-118.81008, 34.22645], [-118.80664, 34.22777], [-118.80625, 34.2279], [-118.80583, 34.22803], [-118.80539, 34.22812], [-118.80369, 34.22842], [-118.80355, 34.22796], [-118.80212, 34.22823], [-118.80211, 34.22825], [-118.80223, 34.22868], [-118.80208, 34.22871], [-118.80208, 34.22874], [-118.79941, 34.22925], [-118.7995, 34.22897], [-118.80048, 34.22863], [-118.80046, 34.2282], [-118.79995, 34.22726], [-118.79988, 34.22665], [-118.79908, 34.22666], [-118.7983, 34.22653], [-118.79791, 34.227], [-118.79723, 34.2275], [-118.79622, 34.22745], [-118.79588, 34.22709], [-118.7956, 34.22711], [-118.79516, 34.22703], [-118.79506, 34.22703], [-118.79497, 34.22706], [-118.79489, 34.2271], [-118.79483, 34.22716], [-118.79479, 34.22723], [-118.79482, 34.22713], [-118.79369, 34.2268], [-118.79343, 34.22784], [-118.79301, 34.22826], [-118.79284, 34.22956], [-118.79285, 34.23025], [-118.79369, 34.23135], [-118.79397, 34.23194], [-118.79246, 34.23316], [-118.79225, 34.23329], [-118.79202, 34.23348], [-118.79183, 34.23335], [-118.79161, 34.23326], [-118.79139, 34.23319], [-118.79115, 34.23316], [-118.79113, 34.23298], [-118.79025, 34.23262], [-118.78987, 34.23256], [-118.78959, 34.23243], [-118.78899, 34.23232], [-118.78899, 34.23223], [-118.7886, 34.2321], [-118.78857, 34.23207], [-118.78857, 34.23195], [-118.78862, 34.23176], [-118.78863, 34.23155], [-118.7886, 34.23142], [-118.78846, 34.23118], [-118.78848, 34.23092], [-118.78943, 34.23057], [-118.78944, 34.23056], [-118.78879, 34.22977], [-118.7881, 34.22986], [-118.78803, 34.22992], [-118.78744, 34.2297], [-118.78732, 34.22995], [-118.78724, 34.23021], [-118.78703, 34.23053], [-118.78699, 34.23052], [-118.7867, 34.231], [-118.78657, 34.23139], [-118.78663, 34.23142], [-118.78655, 34.23204], [-118.78637, 34.23236], [-118.78644, 34.23264], [-118.78631, 34.23263], [-118.78638, 34.23316], [-118.78654, 34.23352], [-118.78627, 34.23418], [-118.7858, 34.23449], [-118.78579, 34.23503], [-118.7859, 34.23505], [-118.78588, 34.23523], [-118.78519, 34.23565], [-118.78493, 34.23577], [-118.78453, 34.23607], [-118.78447, 34.23609], [-118.78443, 34.23607], [-118.78414, 34.23585], [-118.78178, 34.23418], [-118.78245, 34.23199], [-118.78164, 34.23159], [-118.77959, 34.23209], [-118.77824, 34.23137], [-118.77717, 34.23188], [-118.77229, 34.22226], [-118.77649, 34.21612], [-118.77671, 34.21693], [-118.77821, 34.2173], [-118.77974, 34.21742], [-118.78024, 34.21784], [-118.78334, 34.21675], [-118.78437, 34.21713], [-118.78658, 34.21678], [-118.78743, 34.21744], [-118.78932, 34.21781], [-118.79175, 34.21748], [-118.79495, 34.21742], [-118.79582, 34.21825], [-118.79583, 34.22086], [-118.79855, 34.22203], [-118.79886, 34.22263], [-118.79993, 34.22253], [-118.80045, 34.22301], [-118.80178, 34.22244], [-118.80258, 34.22255], [-118.80432, 34.2236], [-118.80479, 34.22333], [-118.80625, 34.2242], [-118.80733, 34.22335], [-118.80812, 34.22432], [-118.80885, 34.22462], [-118.80938, 34.22445], [-118.81046, 34.22448], [-118.81151, 34.22391], [-118.812, 34.22512], [-118.81313, 34.22547], [-118.81321, 34.22577]]]} | Open Access 1 | 45156 | Wood Ranch Open Space | 27679 | 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 | Ventura 8 | 967.477 | Wood Ranch OS | 0 | Local Recreation Area 3 | 4 | |
15308 | 15308 | 15307 | {"type": "Polygon", "coordinates": [[[-118.80384, 34.13634], [-118.80042, 34.13935], [-118.78741, 34.13631], [-118.777, 34.13531], [-118.77703, 34.13029], [-118.77642, 34.13028], [-118.77627, 34.13026], [-118.77605, 34.13018], [-118.77593, 34.1301], [-118.77583, 34.13001], [-118.77548, 34.12953], [-118.77573, 34.1294], [-118.77599, 34.12923], [-118.77622, 34.12904], [-118.77644, 34.12884], [-118.77663, 34.12862], [-118.77679, 34.12839], [-118.77694, 34.12813], [-118.77704, 34.12788], [-118.77712, 34.12763], [-118.77717, 34.12737], [-118.77785, 34.12235], [-118.77798, 34.12189], [-118.77811, 34.1216], [-118.77826, 34.12131], [-118.77855, 34.12091], [-118.77877, 34.12065], [-118.77951, 34.12141], [-118.79034, 34.12722], [-118.79411, 34.13556], [-118.80384, 34.13634]]]} | Unknown Access 4 | 46454 | Truinfo Canyon Open Space | 29730 | 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 | 525.504 | Truinfo Canyon OS | 0 | Local Recreation Area 3 | 4 | |
14913 | 14913 | 14912 | {"type": "Polygon", "coordinates": [[[-118.78769, 34.06358], [-118.78345, 34.06357], [-118.78333, 34.0599], [-118.78336, 34.05624], [-118.78756, 34.05629], [-118.78747, 34.05991], [-118.78769, 34.06358]]]} | Open Access 1 | 45480 | Stone Open Space | 28311 | 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 | 77.428 | Stone OS | 0 | Local Recreation Area 3 | 4 | |
2390 | 2390 | 2389 | {"type": "Polygon", "coordinates": [[[-118.71787, 34.45684], [-118.71569, 34.45684], [-118.71568, 34.46041], [-118.71122, 34.4604], [-118.70698, 34.46033], [-118.70695, 34.45676], [-118.70268, 34.45668], [-118.70267, 34.45669], [-118.70272, 34.46026], [-118.69843, 34.46019], [-118.6982, 34.45301], [-118.70692, 34.45318], [-118.70696, 34.44953], [-118.71123, 34.44959], [-118.71339, 34.44958], [-118.71341, 34.45326], [-118.71611, 34.45327], [-118.71787, 34.45684]]]} | Unknown Access 4 | 11474 | Holser Canyon Open Space | 29737 | 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 | 345.8 | Holser Canyon OS | 0 | Local Recreation Area 3 | 4 | |
4968 | 4968 | 4967 | {"type": "Polygon", "coordinates": [[[-118.71248, 34.03389], [-118.70398, 34.03454], [-118.70393, 34.0343], [-118.70397, 34.03422], [-118.70403, 34.03416], [-118.70414, 34.03411], [-118.70431, 34.03394], [-118.70437, 34.0339], [-118.70442, 34.03379], [-118.70448, 34.03372], [-118.70461, 34.03364], [-118.70472, 34.03338], [-118.70472, 34.03331], [-118.70468, 34.03314], [-118.70469, 34.03307], [-118.70477, 34.03297], [-118.705, 34.03281], [-118.7051, 34.03271], [-118.70524, 34.03269], [-118.70519, 34.03253], [-118.70428, 34.03261], [-118.70425, 34.03255], [-118.70422, 34.03252], [-118.70413, 34.0325], [-118.70407, 34.03252], [-118.70399, 34.03258], [-118.70387, 34.0326], [-118.70355, 34.03271], [-118.70331, 34.0326], [-118.70313, 34.03263], [-118.70212, 34.03299], [-118.70175, 34.03306], [-118.70165, 34.03312], [-118.70161, 34.03318], [-118.70147, 34.03323], [-118.70145, 34.03306], [-118.7015, 34.0329], [-118.7016, 34.03278], [-118.70168, 34.03272], [-118.70209, 34.03251], [-118.70217, 34.03245], [-118.70248, 34.03199], [-118.70245, 34.03197], [-118.70227, 34.03125], [-118.70295, 34.03108], [-118.70294, 34.03101], [-118.70615, 34.03022], [-118.70644, 34.03017], [-118.70672, 34.03014], [-118.70718, 34.03015], [-118.70768, 34.03024], [-118.70867, 34.03057], [-118.70948, 34.03078], [-118.71223, 34.03139], [-118.71248, 34.03389]]]} | Open Access 1 | 7233 | Malibu Bluffs Open Space | 32628 | 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 | 81.031 | Malibu Bluffs OS | 0 | Local Recreation Area 3 | 4 | |
4982 | 4982 | 4981 | {"type": "Polygon", "coordinates": [[[-118.69531, 34.53365], [-118.68395, 34.54742], [-118.66213, 34.52116], [-118.67143, 34.51291], [-118.67786, 34.51284], [-118.67792, 34.52747], [-118.69514, 34.52747], [-118.69531, 34.53365]]]} | Open Access 1 | 48529 | Temescal Ranch Open Space | 33243 | 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 | 1228.189 | Temescal Ranch OS | 2018 | Local Recreation Area 3 | 4 | |
16068 | 16068 | 16067 | {"type": "Polygon", "coordinates": [[[-118.68919, 34.06009], [-118.68919, 34.06354], [-118.68048, 34.06325], [-118.68047, 34.06006], [-118.68919, 34.06009]]]} | Open Access 1 | 7229 | Malibu Canyon - Bovenzi Open Space | 21703 | 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 | 73.258 | Malibu Canyon - Bovenzi OS | 0 | Local Recreation Area 3 | 4 | |
16039 | 16039 | 16038 | {"type": "Polygon", "coordinates": [[[-118.68902, 34.06837], [-118.68849, 34.06824], [-118.68825, 34.06823], [-118.68834, 34.06814], [-118.6882, 34.06803], [-118.68796, 34.06733], [-118.68796, 34.06719], [-118.689, 34.06726], [-118.68902, 34.06837]]]} | Open Access 1 | 6471 | Blue Onyx Open Space | 16185 | 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.384 | Blue Onyx OS | 0 | Local Recreation Area 3 | 4 | |
7007 | 7007 | 7006 | {"type": "Polygon", "coordinates": [[[-118.68834, 34.06814], [-118.68825, 34.06823], [-118.68816, 34.06824], [-118.68824, 34.06815], [-118.68815, 34.06807], [-118.68809, 34.06805], [-118.68753, 34.06822], [-118.68752, 34.0673], [-118.68796, 34.06733], [-118.6882, 34.06803], [-118.68834, 34.06814]]]} | Open Access 1 | 6468 | Blue Onyx Open Space | 16185 | 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.211 | Blue Onyx OS | 0 | Local Recreation Area 3 | 4 | |
7006 | 7006 | 7005 | {"type": "Polygon", "coordinates": [[[-118.68703, 34.06893], [-118.68702, 34.07066], [-118.68603, 34.07063], [-118.68604, 34.06901], [-118.68673, 34.06901], [-118.68688, 34.06898], [-118.68703, 34.06893]]]} | Open Access 1 | 6467 | Malibu Canyon Piuma Ridge Open Space | 21704 | 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 | 4.135 | Malibu Canyon Piuma Ridge OS | 0 | Local Recreation Area 3 | 4 | |
16072 | 16072 | 16071 | {"type": "Polygon", "coordinates": [[[-118.68396, 34.04189], [-118.68229, 34.04179], [-118.68173, 34.04176], [-118.68178, 34.0414], [-118.68203, 34.04139], [-118.68209, 34.0415], [-118.68391, 34.0416], [-118.68396, 34.04189]]]} | Open Access 1 | 7232 | Hendler Open Space | 19817 | 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.661 | Hendler OS | 0 | Local Recreation Area 3 | 4 | |
16263 | 16263 | 16262 | {"type": "Polygon", "coordinates": [[[-118.6587, 34.05186], [-118.65574, 34.05186], [-118.65572, 34.0492], [-118.65578, 34.04919], [-118.65576, 34.04829], [-118.65868, 34.04827], [-118.6587, 34.05186]]]} | Unknown Access 4 | 46376 | Carbon Canyon Open Space | 29656 | 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.736 | Carbon Canyon OS | 0 | Local Recreation Area 3 | 4 | |
6864 | 6864 | 6863 | {"type": "Polygon", "coordinates": [[[-118.6568, 34.21294], [-118.65513, 34.21294], [-118.65513, 34.21258], [-118.65501, 34.21255], [-118.65501, 34.21249], [-118.65514, 34.21247], [-118.65521, 34.21216], [-118.65486, 34.21197], [-118.65513, 34.21137], [-118.65534, 34.21143], [-118.65627, 34.21214], [-118.65639, 34.21229], [-118.65654, 34.21258], [-118.6568, 34.21294]]]} | Open Access 1 | 5496 | Bell Canyon Open Space | 15969 | 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 | 4.298 | Bell Canyon OS | 0 | Local Recreation Area 3 | 4 | |
1440 | 1440 | 1439 | {"type": "Polygon", "coordinates": [[[-118.64876, 34.13111], [-118.64858, 34.13138], [-118.64815, 34.13161], [-118.64807, 34.13167], [-118.64806, 34.13091], [-118.6487, 34.13091], [-118.64871, 34.13102], [-118.64876, 34.13111]]]} | Open Access 1 | 12480 | MRCA Calabasas Open Space | 22568 | 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.921 | MRCA Calabasas OS | 0 | Local Recreation Area 3 | 4 | |
1069 | 1069 | 1068 | {"type": "Polygon", "coordinates": [[[-118.64067, 34.06497], [-118.64065, 34.06495], [-118.64055, 34.065], [-118.6405, 34.06505], [-118.64048, 34.06512], [-118.6405, 34.06525], [-118.64059, 34.06544], [-118.63925, 34.0655], [-118.6403, 34.06406], [-118.64038, 34.06412], [-118.64057, 34.0642], [-118.64081, 34.06442], [-118.64085, 34.06449], [-118.64086, 34.06455], [-118.64083, 34.06472], [-118.64088, 34.06484], [-118.64087, 34.06487], [-118.64083, 34.06492], [-118.64067, 34.06497]]]} | Open Access 1 | 6433 | Las Flores Canyon Open Space | 21048 | 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 | 3.131 | Las Flores Canyon OS | 0 | Local Recreation Area 3 | 4 | |
16238 | 16238 | 16237 | {"type": "Polygon", "coordinates": [[[-118.59318, 34.11022], [-118.59279, 34.1103], [-118.59258, 34.11025], [-118.59278, 34.11018], [-118.59292, 34.11008], [-118.59301, 34.11007], [-118.59318, 34.11022]]]} | Open Access 1 | 46147 | Topanga Open Space | 26408 | 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.17 | Topanga OS | 0 | Local Recreation Area 3 | 4 | |
7242 | 7242 | 7241 | {"type": "Polygon", "coordinates": [[[-118.57098, 34.15161], [-118.5709, 34.1527], [-118.57041, 34.15261], [-118.57021, 34.15331], [-118.56909, 34.15368], [-118.56414, 34.15241], [-118.56436, 34.1514], [-118.56346, 34.15075], [-118.56364, 34.14998], [-118.566, 34.15044], [-118.57098, 34.15161]]]} | Open Access 1 | 6415 | Corbin Canyon Open Space | 17634 | 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 | 40.214 | Corbin Canyon OS | 0 | Local Recreation Area 3 | 4 | |
6869 | 6869 | 6868 | {"type": "Polygon", "coordinates": [[[-118.50367, 34.10168], [-118.50057, 34.10248], [-118.50004, 34.10211], [-118.50262, 34.10136], [-118.50288, 34.10094], [-118.50293, 34.10121], [-118.5034, 34.10109], [-118.50341, 34.10111], [-118.50294, 34.10124], [-118.50307, 34.10152], [-118.50353, 34.10137], [-118.50354, 34.1014], [-118.50309, 34.10155], [-118.50312, 34.10179], [-118.50366, 34.10165], [-118.50367, 34.10168]]]} | Open Access 1 | 6375 | Mandeville East Open Space | 21741 | 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 | 4.165 | Mandeville East OS | 0 | Local Recreation Area 3 | 4 | |
16248 | 16248 | 16247 | {"type": "Polygon", "coordinates": [[[-118.44985, 34.49555], [-118.44095, 34.49537], [-118.44088, 34.48111], [-118.44536, 34.48112], [-118.44537, 34.48476], [-118.44984, 34.48473], [-118.44985, 34.49555]]]} | Unknown Access 4 | 46434 | Texas Canyon Open Space | 29702 | 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 | 281.429 | Texas Canyon OS | 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]);