units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
149 rows where ACCESS_TYP = 4 and MNG_AGENCY = 27 sorted by DES_TP
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, COUNTY, GAP_STS
DES_TP 23
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 149 ✖
ACCESS_TYP 1
- Unknown Access · 149 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15240 | 15240 | 15239 | {"type": "Polygon", "coordinates": [[[-118.62073, 34.19735], [-118.62041, 34.19737], [-118.6201, 34.19741], [-118.6198, 34.19749], [-118.6194, 34.19763], [-118.6194, 34.19749], [-118.6193, 34.19749], [-118.6193, 34.19743], [-118.61926, 34.19743], [-118.61925, 34.19737], [-118.6188, 34.19737], [-118.6188, 34.19735], [-118.62073, 34.19735]]]} | Unknown Access 4 | 46238 | Bell Creek Park | 29516 | 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.384 | Bell Creek Park | 0 | Local Park 2 | 4 | |
15272 | 15272 | 15271 | {"type": "Polygon", "coordinates": [[[-118.60349, 34.03929], [-118.60304, 34.03933], [-118.60253, 34.03932], [-118.60254, 34.03911], [-118.60277, 34.03913], [-118.60296, 34.03912], [-118.60331, 34.03908], [-118.60345, 34.03903], [-118.60349, 34.03929]]]} | Unknown Access 4 | 46353 | Las Tunas Beach | 29634 | 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.511 | Las Tunas Beach | 0 | Local Park 2 | 4 | |
15283 | 15283 | 15282 | {"type": "Polygon", "coordinates": [[[-118.63258, 34.35354], [-118.62383, 34.35366], [-118.62373, 34.34997], [-118.63242, 34.34997], [-118.63258, 34.35354]]]} | Unknown Access 4 | 46403 | Ron Bishop & Judge Anderson Park | 29682 | 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 | 79.884 | Ron Bishop & Judge Anderson Park | 0 | Local Park 2 | 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 | |
7025 | 7025 | 7024 | {"type": "Polygon", "coordinates": [[[-118.00435, 34.00067], [-118.00072, 34.00684], [-117.99905, 34.00616], [-117.99865, 34.00604], [-117.99811, 34.00594], [-117.99769, 34.00592], [-117.9972, 34.00594], [-117.99674, 34.00602], [-117.99656, 34.00606], [-117.99617, 34.00619], [-117.99577, 34.00638], [-117.99538, 34.00662], [-117.995, 34.00693], [-117.99481, 34.00713], [-117.99462, 34.00739], [-117.99442, 34.00773], [-117.99436, 34.00788], [-117.99402, 34.00902], [-117.99395, 34.00922], [-117.99391, 34.0093], [-117.99494, 34.00555], [-117.99575, 34.0047], [-117.99784, 34.0031], [-117.99943, 34.00315], [-118.00071, 34.00186], [-118.00161, 34.00193], [-118.0024, 34.00178], [-118.00309, 34.0011], [-118.00371, 34.00108], [-118.00435, 34.00067]]]} | Unknown Access 4 | 6507 | Hacienda Hills Open Space | 29675 | 2332 | Puente Hills Habitat Preservation Authority 849 | Special District 4 | Conservation District 31 | http://www.habitatauthority.org | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 62.094 | Hacienda Hills OS | 0 | Local Recreation Area 3 | 4 | |
15277 | 15277 | 15276 | {"type": "Polygon", "coordinates": [[[-118.01134, 34.00416], [-118.00978, 34.00681], [-118.00888, 34.00585], [-118.0079, 34.00193], [-118.00768, 34.00148], [-118.00739, 34.00133], [-118.00716, 34.00114], [-118.00703, 34.00099], [-118.00639, 34.00009], [-118.00618, 33.99987], [-118.00592, 33.9997], [-118.00515, 33.99931], [-118.00612, 33.99766], [-118.01134, 34.00416]]]} | Unknown Access 4 | 46393 | Hacienda Hills Open Space | 29675 | 6105 | Rose Hills Memorial Park and Mortuaries 1148 | Private 7 | Commercial 20 | http://www.rosehills.com/en-us/index.page | Private 14 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 40.216 | Hacienda Hills 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 | |
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 | |
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 | |
15234 | 15234 | 15233 | {"type": "Polygon", "coordinates": [[[-118.65002, 34.08174], [-118.64987, 34.08185], [-118.6439, 34.08195], [-118.64441, 34.0814], [-118.64487, 34.08123], [-118.64515, 34.08131], [-118.64532, 34.08135], [-118.64552, 34.08136], [-118.64571, 34.08135], [-118.64588, 34.08131], [-118.64667, 34.08106], [-118.64687, 34.08101], [-118.64823, 34.08085], [-118.64848, 34.08078], [-118.64869, 34.08068], [-118.64998, 34.08047], [-118.65001, 34.08047], [-118.65002, 34.08174]]]} | Unknown Access 4 | 46281 | Cold Creek Canyon Preserve | 29572 | 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 | 13.405 | Cold Creek Canyon Preserve | 0 | Local Conservation Area 4 | 2 | |
15297 | 15297 | 15296 | {"type": "Polygon", "coordinates": [[[-118.64114, 34.04646], [-118.64114, 34.04927], [-118.63883, 34.04927], [-118.6389, 34.04916], [-118.63895, 34.04894], [-118.63908, 34.04862], [-118.63914, 34.04837], [-118.63942, 34.04697], [-118.63947, 34.04677], [-118.63956, 34.04655], [-118.63956, 34.04642], [-118.63952, 34.04633], [-118.64114, 34.04646]]]} | Unknown Access 4 | 46435 | Tom & Giselle Hennesy Nature Preserve | 29704 | 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 | 13.881 | Tom & Giselle Hennesy Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
15951 | 15951 | 15950 | {"type": "MultiPolygon", "coordinates": [[[[-118.33807, 34.27306], [-118.33791, 34.27303], [-118.3371, 34.27278], [-118.33698, 34.27304], [-118.33535, 34.27254], [-118.33388, 34.27329], [-118.33264, 34.27327], [-118.33262, 34.27345], [-118.33394, 34.27349], [-118.33466, 34.27312], [-118.33435, 34.27471], [-118.33322, 34.27471], [-118.33273, 34.27646], [-118.33291, 34.27701], [-118.33276, 34.27755], [-118.33276, 34.27784], [-118.33277, 34.27785], [-118.33365, 34.27756], [-118.33494, 34.27756], [-118.33497, 34.27884], [-118.32953, 34.27884], [-118.32948, 34.27702], [-118.32203, 34.27702], [-118.32201, 34.27524], [-118.32227, 34.27509], [-118.322, 34.27457], [-118.3217, 34.27405], [-118.32007, 34.27399], [-118.32007, 34.27424], [-118.32047, 34.27455], [-118.31964, 34.27455], [-118.32, 34.27319], [-118.31998, 34.27318], [-118.3197, 34.27329], [-118.31952, 34.27322], [-118.31952, 34.27299], [-118.31761, 34.27368], [-118.31755, 34.27363], [-118.31747, 34.27359], [-118.31739, 34.27358], [-118.3173, 34.27358], [-118.31584, 34.27392], [-118.31553, 34.27404], [-118.31528, 34.27416], [-118.3152, 34.27417], [-118.3151, 34.27417], [-118.31508, 34.27422], [-118.31448, 34.27468], [-118.31398, 34.27475], [-118.31563, 34.27261], [-118.31564, 34.27263], [-118.31567, 34.27264], [-118.31568, 34.27309], [-118.31569, 34.2731], [-118.3189, 34.27071], [-118.31927, 34.27065], [-118.31971, 34.27053], [-118.31999, 34.27041], [-118.32037, 34.27019], [-118.3207, 34.26992], [-118.32133, 34.26926], [-118.32152, 34.26911], [-118.32171, 34.26899], [-118.32202, 34.26884], [-118.32229, 34.26875], [-118.32329, 34.26851], [-118.32366, 34.2684], [-118.32402, 34.26826], [-118.32452, 34.26801], [-118.32457, 34.26809], [-118.3246, 34.26819], [-118.32458, 34.26833], [-118.32452, 34.26841], [-118.3244, 34.26851], [-118.32392, 34.26874], [-118.32364, 34.26882], [-118.32334, 34.26885], [-118.32234, 34.26875], [-118.32228, 34.26877], [-118.322, 34.26906], [-118.32201, 34.26911], [-118.32244, 34.2694], [-118.32253, 34.2695], [-118.32256, 34.26963], [-118.32251, 34.27004], [-118.32255, 34.27025], [-118.32262, 34.27038], [-118.32294, 34.27092], [-118.32298, 34.27111], [-118.32305, 34.27117], [-118.32353, 34.27127], [-118.32389, 34.27133], [-118.32425, 34.27135], [-118.32462, 34.27135], [-118.32498, 34.27132], [-118.32534, 34.27126], [-118.32579, 34.27115], [-118.32625, 34.271], [-118.32646, 34.27096], [-118.32678, 34.27094], [-118.32747, 34.271], [-118.32755, 34.27103], [-118.32761, 34.27108], [-118.32779, 34.27137], [-118.32783, 34.27146], [-118.32786, 34.2716], [-118.32783, 34.27204], [-118.32784, 34.2721], [-118.32789, 34.27215], [-118.32795, 34.27218], [-118.32815, 34.27218], [-118.32832, 34.27215], [-118.33019, 34.27168], [-118.33063, 34.27154], [-118.33216, 34.27088], [-118.33291, 34.27042], [-118.33312, 34.27032], [-118.33334, 34.27024], [-118.33359, 34.27018], [-118.33403, 34.27012], [-118.33423, 34.27011], [-118.33443, 34.27013], [-118.33463, 34.27017], [-118.33482, 34.27023], [-118.33499, 34.27032], [-118.33523, 34.27046], [-118.3354, 34.27054], [-118.3368, 34.27101], [-118.33693, 34.27099], [-118.33707, 34.27091], [-118.33695, 34.27063], [-118.33714, 34.27057], [-118.33807, 34.27253], [-118.33785, 34.2726], [-118.33807, 34.27306]]], [[[-118.32554, 34.2667], [-118.32551, 34.26716], [-118.32418, 34.26786], [-118.3237, 34.26808], [-118.32319, 34.26825], [-118.32215, 34.2685], [-118.32187, 34.2686], [-118.32162, 34.26871], [-118.32127, 34.26893], [-118.32095, 34.26918], [-118.32093, 34.26922], [-118.32042, 34.26976], [-118.3201, 34.27001], [-118.31986, 34.27015], [-118.31961, 34.27027], [-118.31941, 34.27033], [-118.32008, 34.26983], [-118.32008, 34.26968], [-118.31883, 34.2706], [-118.31789, 34.2706], [-118.31789, 34.26925], [-118.31957, 34.26857], [-118.31979, 34.26865], [-118.32, 34.26826], [-118.32008, 34.26828], [-118.32009, 34.26821], [-118.32058, 34.26835], [-118.32057, 34.26842], [-118.32157, 34.26872], [-118.32201, 34.26839], [-118.32238, 34.26835], [-118.3232, 34.26792], [-118.3232, 34.26705], [-118.32526, 34.26723], [-118.32534, 34.26674], [-118.32537, 34.2667], [-118.32554, 34.2667]]]]} | Unknown Access 4 | 46259 | Big Tujunga Wash Open Space Preserve | 29544 | 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.948 | Big Tujunga Wash OSP | 0 | Local Conservation Area 4 | 2 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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]);