units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
428 rows where MNG_AG_TYP = 6 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, MNG_AG_ID, YR_EST, GAP_STS
DES_TP >30
MNG_AGENCY 7
- Mountains Recreation and Conservation Authority 351
- Conejo Open Space Conservation Agency 50
- Riverside County Habitat Conservation Agency 14
- Western Riverside County Regional Conservation Authority 7
- Solano Tri-City and County Cooperative Planning Group 2
- Rancho Simi Open Space Conservation Agency 2
- San Dieguito River Park Joint Powers Authority 2
ACCESS_TYP 4
- Open Access 248
- Unknown Access 151
- No Public Access 22
- Restricted Access 7
MNG_AG_TYP 1
- Open Space District · 428 ✖
MNG_AG_LEV 1 ✖
- Special District 428
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
806 | 806 | 805 | {"type": "Polygon", "coordinates": [[[-118.36891, 33.73931], [-118.36872, 33.73989], [-118.36801, 33.74037], [-118.3676, 33.74059], [-118.36705, 33.7408], [-118.36659, 33.74091], [-118.36593, 33.741], [-118.36518, 33.74102], [-118.36184, 33.74064], [-118.36135, 33.74054], [-118.36085, 33.74039], [-118.36043, 33.74023], [-118.35991, 33.74], [-118.36013, 33.7397], [-118.36194, 33.73906], [-118.36225, 33.73793], [-118.36307, 33.73841], [-118.36421, 33.7389], [-118.36458, 33.73893], [-118.36486, 33.73874], [-118.36576, 33.73874], [-118.36599, 33.73867], [-118.36603, 33.73842], [-118.36669, 33.73848], [-118.36759, 33.73837], [-118.36825, 33.73811], [-118.3684, 33.7379], [-118.36858, 33.73667], [-118.36844, 33.73652], [-118.36862, 33.73606], [-118.36885, 33.7361], [-118.36869, 33.73753], [-118.36863, 33.73839], [-118.36868, 33.73907], [-118.36891, 33.73931]]]} | Restricted Access 2 | 5870 | Abalone Cove Shoreline Archery Range | 29497 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 45.317 | Abalone Cove Shoreline Archery Range | None 73 | |||
6965 | 6965 | 6964 | {"type": "Polygon", "coordinates": [[[-118.38377, 33.74401], [-118.38366, 33.74409], [-118.3835, 33.74426], [-118.3834, 33.74443], [-118.38334, 33.7446], [-118.3833, 33.74463], [-118.38324, 33.74463], [-118.38251, 33.7444], [-118.37928, 33.74319], [-118.37858, 33.74294], [-118.37828, 33.74288], [-118.37797, 33.74285], [-118.37712, 33.74285], [-118.37695, 33.74283], [-118.37658, 33.74276], [-118.37633, 33.74268], [-118.3761, 33.74258], [-118.37428, 33.74166], [-118.37409, 33.74153], [-118.37449, 33.74144], [-118.37474, 33.74131], [-118.37495, 33.74111], [-118.37536, 33.74104], [-118.37533, 33.7409], [-118.37528, 33.74087], [-118.37526, 33.74091], [-118.3752, 33.74094], [-118.3751, 33.74093], [-118.37492, 33.74081], [-118.37475, 33.74072], [-118.37464, 33.74071], [-118.37456, 33.74076], [-118.37453, 33.74082], [-118.37453, 33.74102], [-118.37447, 33.74111], [-118.3742, 33.74101], [-118.37411, 33.74094], [-118.37392, 33.74063], [-118.3739, 33.74052], [-118.37392, 33.74039], [-118.3739, 33.74035], [-118.37378, 33.74035], [-118.37343, 33.74055], [-118.37317, 33.74027], [-118.37291, 33.74006], [-118.37262, 33.73987], [-118.37235, 33.73974], [-118.37207, 33.73963], [-118.37182, 33.73956], [-118.37155, 33.7395], [-118.37156, 33.73948], [-118.37151, 33.73946], [-118.37121, 33.7394], [-118.37073, 33.73936], [-118.37024, 33.73937], [-118.36993, 33.73941], [-118.36963, 33.73948], [-118.36924, 33.73961], [-118.36902, 33.73971], [-118.36872, 33.73989], [-118.3689, 33.73931], [-118.36868, 33.73908], [-118.36863, 33.73839], [-118.36869, 33.73753], [-118.36885, 33.7361], [-118.36885, 33.73633], [-118.36893, 33.73611], [-118.36965, 33.73615], [-118.36948, 33.73631], [-118.36949, 33.73632], [-118.36991, 33.73612], [-118.36997, 33.73637], [-118.36973, 33.73687], [-118.36989, 33.73695], [-118.36967, 33.73698], [-118.36968, 33.73791], [-118.37035, 33.73841], [-118.37076, 33.73858], [-118.3716, 33.7386], [-118.37177, 33.73868], [-118.37251, 33.73854], [-118.37288, 33.73836], [-118.37312, 33.73783], [-118.37366, 33.73737], [-118.37336, 33.73691], [-118.37356, 33.7366], [-118.37423, 33.73684], [-118.37407, 33.73705], [-118.37407, 33.73707], [-118.37461, 33.73683], [-118.37524, 33.73706], [-118.37536, 33.73783], [-118.3751, 33.7381], [-118.37496, 33.73871], [-118.37518, 33.73935], [-118.37541, 33.73961], [-118.3758, 33.73995], [-118.37656, 33.74047], [-118.37683, 33.7406], [-118.37719, 33.74067], [-118.37847, 33.74133], [-118.38012, 33.74196], [-118.38062, 33.7421], [-118.3814, 33.74223], [-118.38195, 33.74227], [-118.38281, 33.74211], [-118.38301, 33.7429], [-118.38305, 33.74333], [-118.38377, 33.74401]]]} | Open Access 1 | 5869 | Abalone Cove Shoreline Park | 29496 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 79.019 | Abalone Cove Shoreline Park | 0 | Local Park 2 | 4 | |
915 | 915 | 914 | {"type": "Polygon", "coordinates": [[[-118.40367, 33.76579], [-118.40172, 33.76579], [-118.40068, 33.76532], [-118.39944, 33.76548], [-118.39872, 33.76598], [-118.39851, 33.76599], [-118.39825, 33.76503], [-118.39697, 33.76527], [-118.39672, 33.76521], [-118.39662, 33.76442], [-118.39672, 33.7636], [-118.39634, 33.76316], [-118.39614, 33.76316], [-118.39577, 33.763], [-118.39552, 33.76295], [-118.39505, 33.76295], [-118.39475, 33.76286], [-118.39404, 33.76306], [-118.39345, 33.76309], [-118.39242, 33.76276], [-118.39324, 33.76159], [-118.39353, 33.76173], [-118.39386, 33.76157], [-118.394, 33.76132], [-118.39421, 33.76139], [-118.39443, 33.76143], [-118.39466, 33.76145], [-118.39504, 33.76145], [-118.3948, 33.76184], [-118.39634, 33.76183], [-118.3969, 33.7623], [-118.40024, 33.76452], [-118.40197, 33.76451], [-118.40218, 33.76489], [-118.40367, 33.76508], [-118.40367, 33.76579]]]} | Open Access 1 | 5862 | Agua Armaga Canyon Open Space | 29504 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 40.343 | Agua Armaga Canyon OS | 0 | Local Recreation Area 3 | 4 | |
13843 | 13843 | 13842 | {"type": "Polygon", "coordinates": [[[-118.40367, 33.76579], [-118.40367, 33.76744], [-118.40306, 33.76731], [-118.40216, 33.76783], [-118.40172, 33.76823], [-118.40097, 33.76815], [-118.40019, 33.76838], [-118.39966, 33.7686], [-118.39857, 33.76917], [-118.39808, 33.7696], [-118.39719, 33.77018], [-118.39663, 33.77052], [-118.3966, 33.77], [-118.39693, 33.76968], [-118.39706, 33.76933], [-118.39739, 33.76909], [-118.39756, 33.76889], [-118.39794, 33.76884], [-118.39804, 33.76873], [-118.39799, 33.76839], [-118.39848, 33.76821], [-118.39895, 33.7679], [-118.40049, 33.76721], [-118.40114, 33.767], [-118.40186, 33.7669], [-118.40209, 33.76681], [-118.40236, 33.76661], [-118.40236, 33.76579], [-118.40367, 33.76579]]]} | Open Access 1 | 46339 | Agua Armaga Canyon Open Space | 29504 | 3052 | Palos Verdes Peninsula Land Conservancy 846 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.pvplc.org/preserves.shtml | Non Governmental Organization 10 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 20.73 | Agua Armaga Canyon OS | 0 | Local Recreation Area 3 | 4 | |
14384 | 14384 | 14383 | {"type": "Polygon", "coordinates": [[[-118.96126, 34.18591], [-118.96086, 34.18776], [-118.96044, 34.1877], [-118.96044, 34.18733], [-118.96018, 34.1869], [-118.95949, 34.18737], [-118.95917, 34.18749], [-118.95899, 34.18751], [-118.95881, 34.18751], [-118.95863, 34.18749], [-118.9584, 34.18742], [-118.95807, 34.18736], [-118.95816, 34.18723], [-118.9582, 34.18686], [-118.95811, 34.18649], [-118.95798, 34.18627], [-118.95764, 34.18647], [-118.95748, 34.18629], [-118.95768, 34.18611], [-118.95782, 34.18623], [-118.9585, 34.18623], [-118.95851, 34.18593], [-118.96126, 34.18591]]]} | Restricted Access 2 | 47116 | Alta Vista Open Space | 30792 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/open_space_areas_in_TO.htm#Alta Vista | Ventura 8 | 10.982 | Alta Vista OS | 0 | Local Recreation Area 3 | 4 |
16119 | 16119 | 16118 | {"type": "MultiPolygon", "coordinates": [[[[-118.91157, 34.19061], [-118.91076, 34.19098], [-118.91079, 34.19125], [-118.911, 34.19126], [-118.90934, 34.19128], [-118.90916, 34.18971], [-118.90747, 34.18972], [-118.90516, 34.18937], [-118.90334, 34.18882], [-118.90226, 34.18875], [-118.90207, 34.18833], [-118.90224, 34.18766], [-118.90207, 34.1868], [-118.90146, 34.1862], [-118.90071, 34.18638], [-118.90034, 34.18671], [-118.89968, 34.18636], [-118.89939, 34.18597], [-118.8996, 34.18536], [-118.89983, 34.18592], [-118.90024, 34.18605], [-118.90052, 34.18607], [-118.90077, 34.18597], [-118.90168, 34.18602], [-118.90188, 34.1861], [-118.90246, 34.18627], [-118.90261, 34.1866], [-118.9027, 34.18712], [-118.90335, 34.18712], [-118.90335, 34.18611], [-118.90369, 34.18701], [-118.9037, 34.18779], [-118.904, 34.18822], [-118.90469, 34.18838], [-118.90498, 34.18818], [-118.90534, 34.18789], [-118.90668, 34.18786], [-118.90717, 34.18746], [-118.90691, 34.18584], [-118.90689, 34.18532], [-118.9073, 34.18556], [-118.90727, 34.18568], [-118.9075, 34.18631], [-118.90799, 34.18703], [-118.9081, 34.18785], [-118.90807, 34.18793], [-118.90808, 34.18799], [-118.90797, 34.18804], [-118.9079, 34.18827], [-118.90834, 34.18839], [-118.90859, 34.18831], [-118.90902, 34.18861], [-118.90954, 34.18851], [-118.90973, 34.18863], [-118.90982, 34.18875], [-118.90985, 34.18899], [-118.91008, 34.18913], [-118.91032, 34.18918], [-118.91061, 34.18937], [-118.9112, 34.18927], [-118.91131, 34.19008], [-118.9114, 34.19032], [-118.91157, 34.19061]]], [[[-118.91331, 34.19124], [-118.91268, 34.19124], [-118.91244, 34.19109], [-118.91221, 34.1909], [-118.91203, 34.1907], [-118.91188, 34.19049], [-118.91174, 34.1902], [-118.91164, 34.18986], [-118.9116, 34.1894], [-118.9115, 34.18847], [-118.9115, 34.18844], [-118.91153, 34.18841], [-118.91159, 34.18839], [-118.91201, 34.18843], [-118.91254, 34.18845], [-118.91253, 34.18868], [-118.91258, 34.18896], [-118.91248, 34.18913], [-118.91206, 34.18905], [-118.91205, 34.18906], [-118.91206, 34.18938], [-118.91213, 34.18948], [-118.91211, 34.18952], [-118.91212, 34.18957], [-118.91217, 34.18964], [-118.91226, 34.18966], [-118.91226, 34.19009], [-118.91221, 34.19009], [-118.9122, 34.1901], [-118.91229, 34.1904], [-118.91253, 34.19035], [-118.91262, 34.19028], [-118.91273, 34.19029], [-118.91279, 34.19069], [-118.91287, 34.19067], [-118.91331, 34.19124]]]]} | Restricted Access 2 | 15697 | Arroyo Conejo - South Arroyo Conejo Open Space | 15611 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | Ventura 8 | 51.646 | Arroyo Conejo - South Arroyo Conejo OS | 0 | Local Recreation Area 3 | 4 | |
4117 | 4117 | 4116 | {"type": "Polygon", "coordinates": [[[-118.921, 34.20591], [-118.92099, 34.2097], [-118.92022, 34.20901], [-118.91855, 34.20853], [-118.91575, 34.2074], [-118.91433, 34.20701], [-118.91473, 34.20578], [-118.91189, 34.20579], [-118.9117, 34.20575], [-118.91279, 34.20491], [-118.91208, 34.20449], [-118.91277, 34.2032], [-118.9125, 34.20197], [-118.91026, 34.20222], [-118.91025, 34.20301], [-118.90929, 34.20311], [-118.90827, 34.20385], [-118.90696, 34.2037], [-118.90725, 34.20331], [-118.90673, 34.20267], [-118.90598, 34.20258], [-118.90596, 34.20197], [-118.90453, 34.20257], [-118.90433, 34.20209], [-118.90377, 34.2021], [-118.90312, 34.20204], [-118.90268, 34.20197], [-118.90262, 34.20193], [-118.90248, 34.20157], [-118.90165, 34.20139], [-118.90109, 34.20142], [-118.90064, 34.20099], [-118.9011, 34.20077], [-118.90071, 34.20017], [-118.90045, 34.19943], [-118.90145, 34.19998], [-118.90194, 34.20006], [-118.90259, 34.20052], [-118.90294, 34.20059], [-118.90276, 34.20086], [-118.90277, 34.20088], [-118.90468, 34.20126], [-118.90661, 34.20099], [-118.90665, 34.19895], [-118.90804, 34.19813], [-118.9085, 34.19838], [-118.90889, 34.19713], [-118.9089, 34.19649], [-118.90846, 34.19588], [-118.90768, 34.1956], [-118.9071, 34.19509], [-118.90751, 34.19409], [-118.90785, 34.1934], [-118.90894, 34.19318], [-118.9091, 34.19293], [-118.9093, 34.19275], [-118.90933, 34.19127], [-118.911, 34.19126], [-118.91101, 34.1914], [-118.91095, 34.19154], [-118.91103, 34.19163], [-118.91106, 34.19169], [-118.91111, 34.19186], [-118.91111, 34.192], [-118.91106, 34.19213], [-118.91116, 34.1923], [-118.91116, 34.19248], [-118.91129, 34.19264], [-118.91135, 34.19285], [-118.91127, 34.19297], [-118.91104, 34.19313], [-118.91103, 34.19338], [-118.9108, 34.19329], [-118.91064, 34.1936], [-118.91064, 34.19367], [-118.91055, 34.19375], [-118.90995, 34.19372], [-118.90974, 34.19392], [-118.90962, 34.19409], [-118.90927, 34.19439], [-118.90938, 34.19465], [-118.90922, 34.19486], [-118.90942, 34.19502], [-118.90926, 34.19514], [-118.90954, 34.19538], [-118.90995, 34.19536], [-118.91013, 34.19551], [-118.91029, 34.19567], [-118.91041, 34.19587], [-118.91035, 34.19614], [-118.91072, 34.19618], [-118.91065, 34.19663], [-118.91071, 34.19694], [-118.91087, 34.19722], [-118.91113, 34.19744], [-118.91129, 34.19763], [-118.91135, 34.19776], [-118.91142, 34.1981], [-118.91148, 34.19823], [-118.91165, 34.19849], [-118.91179, 34.19862], [-118.91205, 34.19879], [-118.9123, 34.1989], [-118.91286, 34.19901], [-118.91325, 34.19911], [-118.91352, 34.19922], [-118.91366, 34.19974], [-118.91397, 34.1999], [-118.91393, 34.20004], [-118.91396, 34.20005], [-118.91437, 34.20007], [-118.91468, 34.20014], [-118.91526, 34.20037], [-118.91563, 34.20035], [-118.91584, 34.20027], [-118.91613, 34.2], [-118.91631, 34.19948], [-118.91671, 34.20002], [-118.91669, 34.20093], [-118.91789, 34.20173], [-118.91847, 34.20202], [-118.91823, 34.20298], [-118.91848, 34.20348], [-118.91938, 34.20376], [-118.91977, 34.20424], [-118.91963, 34.2053], [-118.91977, 34.20562], [-118.92032, 34.20592], [-118.92069, 34.20595], [-118.921, 34.20591]]]} | Restricted Access 2 | 47117 | Arroyo Conejo Nature Preserve | 30793 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/open_space_areas_in_TO.htm#Arroyo Conejo | Ventura 8 | 250.878 | Arroyo Conejo Nature Preserve | 0 | Local Conservation Area 4 | 2 |
15282 | 15282 | 15281 | {"type": "MultiPolygon", "coordinates": [[[[-118.01566, 33.97164], [-118.01565, 33.97527], [-118.01129, 33.97522], [-118.01115, 33.98076], [-118.01084, 33.98063], [-118.01028, 33.98102], [-118.00999, 33.982], [-118.01005, 33.9824], [-117.9948, 33.9824], [-117.99477, 33.9823], [-117.99471, 33.9822], [-117.99452, 33.98203], [-117.99442, 33.98198], [-117.99428, 33.98195], [-117.99397, 33.98193], [-117.99359, 33.98169], [-117.99375, 33.97568], [-117.99376, 33.97516], [-117.9848, 33.97512], [-117.98554, 33.97458], [-117.98606, 33.97426], [-117.98662, 33.97397], [-117.98857, 33.97305], [-117.98896, 33.97284], [-117.98942, 33.97254], [-117.98976, 33.97228], [-117.99001, 33.97207], [-117.99024, 33.97185], [-117.99173, 33.97028], [-117.9921, 33.96997], [-117.99243, 33.96974], [-117.99382, 33.9689], [-117.99382, 33.96927], [-117.99384, 33.96928], [-117.9948, 33.96871], [-117.99517, 33.96823], [-117.99565, 33.96816], [-117.99626, 33.96747], [-117.99656, 33.96738], [-117.99668, 33.96732], [-117.99694, 33.96746], [-117.99761, 33.96689], [-117.99784, 33.9669], [-117.9991, 33.9668], [-118.00017, 33.9661], [-118.00034, 33.9661], [-118.00104, 33.96561], [-118.00152, 33.96516], [-118.00193, 33.96458], [-118.00592, 33.96477], [-118.00774, 33.96578], [-118.00796, 33.96556], [-118.00827, 33.96532], [-118.00839, 33.96528], [-118.00875, 33.96504], [-118.00875, 33.96502], [-118.00951, 33.96456], [-118.00958, 33.96441], [-118.0098, 33.96413], [-118.0099, 33.96386], [-118.00989, 33.96384], [-118.01017, 33.96353], [-118.01029, 33.9636], [-118.01004, 33.96394], [-118.01053, 33.9642], [-118.00966, 33.9653], [-118.0101, 33.96556], [-118.00944, 33.96637], [-118.00857, 33.96682], [-118.00824, 33.96752], [-118.00951, 33.96824], [-118.00918, 33.96867], [-118.00952, 33.96888], [-118.00921, 33.96926], [-118.00846, 33.96884], [-118.00843, 33.96896], [-118.00792, 33.9694], [-118.00795, 33.9695], [-118.00887, 33.97002], [-118.00827, 33.97078], [-118.0088, 33.97086], [-118.00905, 33.97078], [-118.01025, 33.96928], [-118.01347, 33.97108], [-118.01348, 33.97164], [-118.01566, 33.97164]]], [[[-117.99476, 33.9824], [-117.99357, 33.98241], [-117.99359, 33.98173], [-117.99379, 33.98188], [-117.99396, 33.98196], [-117.99427, 33.98198], [-117.9945, 33.98206], [-117.99468, 33.98222], [-117.99473, 33.98231], [-117.99476, 33.9824]]]]} | Open Access 1 | 46392 | Arroyo Pescadero | 29674 | 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 | 812.555 | Arroyo Pescadero | 0 | None 1345 | ||
7235 | 7235 | 7234 | {"type": "MultiPolygon", "coordinates": [[[[-117.9711, 33.97414], [-117.97033, 33.97501], [-117.96902, 33.97501], [-117.96879, 33.97516], [-117.96856, 33.97495], [-117.96849, 33.97498], [-117.96757, 33.9742], [-117.96722, 33.9738], [-117.96704, 33.97344], [-117.96865, 33.97343], [-117.9711, 33.97414]]], [[[-118.00131, 33.96455], [-118.00116, 33.96476], [-118.00086, 33.96505], [-118.00056, 33.96529], [-118.00022, 33.9656], [-117.99995, 33.96573], [-117.99909, 33.96585], [-117.99817, 33.96629], [-117.99774, 33.96624], [-117.99667, 33.96659], [-117.99639, 33.96663], [-117.99593, 33.96712], [-117.99495, 33.96767], [-117.9948, 33.96769], [-117.99422, 33.96798], [-117.99409, 33.96831], [-117.99383, 33.96841], [-117.99382, 33.96849], [-117.99213, 33.96952], [-117.99173, 33.9698], [-117.99137, 33.97011], [-117.98983, 33.97173], [-117.9895, 33.97202], [-117.98906, 33.97235], [-117.98858, 33.97265], [-117.98818, 33.97286], [-117.98643, 33.97368], [-117.98598, 33.9739], [-117.9854, 33.97424], [-117.98516, 33.9744], [-117.98477, 33.97468], [-117.98422, 33.97511], [-117.97765, 33.97509], [-117.97666, 33.97483], [-117.97664, 33.97254], [-117.97665, 33.96784], [-117.98953, 33.96796], [-117.98955, 33.96635], [-117.98955, 33.96502], [-117.98981, 33.96474], [-117.98999, 33.96459], [-117.99016, 33.96448], [-117.99378, 33.96454], [-118.00131, 33.96455]]]]} | Open Access 1 | 6520 | Arroyo San Miguel Open Space | 29672 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 320.047 | Arroyo San Miguel OS | 0 | Local Recreation Area 3 | 4 | |
16252 | 16252 | 16251 | {"type": "MultiPolygon", "coordinates": [[[[-117.96366, 33.97258], [-117.96126, 33.97259], [-117.96126, 33.97247], [-117.9615, 33.97245], [-117.96176, 33.97236], [-117.96197, 33.97222], [-117.96214, 33.97202], [-117.96218, 33.97203], [-117.96226, 33.97185], [-117.96228, 33.97166], [-117.96225, 33.97165], [-117.96223, 33.97147], [-117.96217, 33.97133], [-117.96204, 33.97114], [-117.9622, 33.97105], [-117.96227, 33.97088], [-117.96243, 33.97101], [-117.96266, 33.97101], [-117.9629, 33.97107], [-117.96328, 33.97149], [-117.96366, 33.97258]]], [[[-117.96794, 33.97257], [-117.96656, 33.97258], [-117.96551, 33.97127], [-117.96533, 33.97112], [-117.9648, 33.97082], [-117.96593, 33.97054], [-117.96624, 33.97079], [-117.96645, 33.97069], [-117.96751, 33.97084], [-117.96766, 33.97089], [-117.96776, 33.97088], [-117.96791, 33.97121], [-117.96773, 33.97135], [-117.96722, 33.97149], [-117.96695, 33.97152], [-117.96694, 33.97153], [-117.96794, 33.97257]]], [[[-117.97666, 33.97483], [-117.97401, 33.97407], [-117.96878, 33.97258], [-117.97664, 33.97254], [-117.97666, 33.97483]]]]} | Open Access 1 | 46389 | Arroyo San Miguel Open Space | 29672 | 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 | 36.363 | Arroyo San Miguel OS | 0 | Local Recreation Area 3 | 4 | |
10461 | 10461 | 10460 | {"type": "MultiPolygon", "coordinates": [[[[-118.88521, 34.10011], [-118.87642, 34.1], [-118.87644, 34.09276], [-118.8808, 34.09278], [-118.88081, 34.09087], [-118.88097, 34.09116], [-118.88279, 34.09374], [-118.88283, 34.09385], [-118.88285, 34.094], [-118.88283, 34.09416], [-118.88273, 34.09447], [-118.8827, 34.09465], [-118.8827, 34.09492], [-118.88274, 34.0951], [-118.88283, 34.09536], [-118.88298, 34.09559], [-118.88311, 34.09572], [-118.88344, 34.09601], [-118.88354, 34.09615], [-118.88359, 34.09632], [-118.88365, 34.09675], [-118.88369, 34.09689], [-118.88376, 34.09702], [-118.88402, 34.09733], [-118.88413, 34.09743], [-118.88426, 34.09752], [-118.88448, 34.0976], [-118.88506, 34.0977], [-118.8852, 34.09775], [-118.88521, 34.10011]]], [[[-118.88959, 34.09647], [-118.88521, 34.09646], [-118.8852, 34.09757], [-118.88453, 34.09744], [-118.8844, 34.09739], [-118.88423, 34.09728], [-118.88397, 34.09699], [-118.88388, 34.09685], [-118.88383, 34.09668], [-118.88378, 34.09625], [-118.88371, 34.09606], [-118.88358, 34.0959], [-118.88326, 34.09561], [-118.88314, 34.09549], [-118.88304, 34.09534], [-118.88297, 34.09519], [-118.8829, 34.09494], [-118.88289, 34.09476], [-118.88292, 34.09451], [-118.88304, 34.09415], [-118.88305, 34.09403], [-118.88304, 34.09385], [-118.88299, 34.09372], [-118.88293, 34.0936], [-118.88114, 34.09107], [-118.88102, 34.09085], [-118.88095, 34.09061], [-118.88082, 34.08991], [-118.88082, 34.08942], [-118.88092, 34.08939], [-118.88115, 34.08941], [-118.88137, 34.08938], [-118.88158, 34.08929], [-118.88175, 34.08915], [-118.88517, 34.08915], [-118.88518, 34.08988], [-118.88503, 34.08994], [-118.88491, 34.09005], [-118.88484, 34.09019], [-118.88482, 34.09035], [-118.88484, 34.09046], [-118.88518, 34.09138], [-118.88519, 34.09279], [-118.88594, 34.0928], [-118.88685, 34.09338], [-118.88693, 34.0935], [-118.88696, 34.09364], [-118.88694, 34.09379], [-118.88683, 34.09402], [-118.88684, 34.0942], [-118.8869, 34.09438], [-118.88702, 34.09452], [-118.88718, 34.09461], [-118.8873, 34.09464], [-118.88743, 34.09464], [-118.8876, 34.09459], [-118.88771, 34.09452], [-118.88779, 34.09443], [-118.88786, 34.09433], [-118.88851, 34.09281], [-118.88958, 34.09281], [-118.88959, 34.09647]]], [[[-118.88518, 34.09043], [-118.88515, 34.09032], [-118.88518, 34.09023], [-118.88518, 34.09023], [-118.88518, 34.09043]]], [[[-118.88816, 34.09281], [-118.88753, 34.09427], [-118.88748, 34.09432], [-118.88742, 34.09435], [-118.88731, 34.09436], [-118.88724, 34.09433], [-118.88717, 34.09425], [-118.88714, 34.09415], [-118.88714, 34.09411], [-118.88727, 34.09383], [-118.88729, 34.0937], [-118.88727, 34.09351], [-118.88723, 34.09338], [-118.88716, 34.09327], [-118.88707, 34.09317], [-118.88648, 34.0928], [-118.88816, 34.09281]]]]} | Open Access 1 | 18515 | Arroyo Sequit Open Space | 33242 | 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 | 233.168 | Arroyo Sequit OS | 1984 | Local Recreation Area 3 | 4 | |
5471 | 5471 | 5470 | {"type": "Polygon", "coordinates": [[[-118.81077, 34.11086], [-118.80637, 34.11085], [-118.80651, 34.10737], [-118.81077, 34.10736], [-118.81077, 34.11086]]]} | Open Access 1 | 48527 | Ballard Mountain | 33241 | 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 | 38.205 | Ballard Mtn. | 2017 | None 442 | ||
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 | |
16018 | 16018 | 16017 | {"type": "MultiPolygon", "coordinates": [[[[-118.6668, 34.20731], [-118.6668, 34.20933], [-118.66277, 34.20935], [-118.66277, 34.21292], [-118.65817, 34.21293], [-118.65813, 34.21284], [-118.65899, 34.21229], [-118.65948, 34.21191], [-118.65946, 34.21178], [-118.65958, 34.2115], [-118.6598, 34.21116], [-118.65988, 34.21075], [-118.66004, 34.21049], [-118.66041, 34.20997], [-118.66039, 34.20968], [-118.66113, 34.20967], [-118.66123, 34.2095], [-118.66136, 34.20941], [-118.66145, 34.20937], [-118.6615, 34.20943], [-118.66172, 34.20944], [-118.66181, 34.20939], [-118.66192, 34.20926], [-118.66205, 34.20926], [-118.6622, 34.20904], [-118.66236, 34.20906], [-118.66242, 34.20897], [-118.66248, 34.20874], [-118.66261, 34.20877], [-118.66294, 34.20863], [-118.66277, 34.20833], [-118.66395, 34.20783], [-118.66414, 34.20773], [-118.66436, 34.20755], [-118.66464, 34.20717], [-118.66467, 34.20714], [-118.66474, 34.20714], [-118.6651, 34.20726], [-118.66537, 34.20733], [-118.66578, 34.20738], [-118.66633, 34.20738], [-118.6668, 34.20731]]], [[[-118.66376, 34.20651], [-118.66368, 34.20658], [-118.66361, 34.2068], [-118.6635, 34.20695], [-118.66336, 34.20702], [-118.66279, 34.20693], [-118.66253, 34.20714], [-118.66244, 34.20727], [-118.6624, 34.20744], [-118.66246, 34.20763], [-118.66239, 34.20772], [-118.66171, 34.20792], [-118.66129, 34.20798], [-118.66111, 34.20806], [-118.66095, 34.20825], [-118.66094, 34.20578], [-118.66321, 34.20579], [-118.6635, 34.20622], [-118.66376, 34.20651]]]]} | Open Access 1 | 3684 | Bell Canyon Open Space | 15969 | 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 | 57.419 | Bell Canyon OS | 0 | Local Recreation Area 3 | 4 | |
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 | |
16255 | 16255 | 16254 | {"type": "Polygon", "coordinates": [[[-118.43531, 34.11052], [-118.4348, 34.11052], [-118.43482, 34.11034], [-118.43522, 34.11034], [-118.43531, 34.11052]]]} | Open Access 1 | 46496 | Benedict Canyon Open Space | 16009 | 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 | 0.203 | Benedict Canyon OS | 0 | Local Recreation Area 3 | 4 | |
7227 | 7227 | 7226 | {"type": "MultiPolygon", "coordinates": [[[[-118.44706, 34.11605], [-118.44644, 34.11605], [-118.44654, 34.11542], [-118.44655, 34.11514], [-118.44658, 34.1151], [-118.44665, 34.1151], [-118.44668, 34.11513], [-118.44706, 34.11605]]], [[[-118.44618, 34.11604], [-118.44484, 34.11604], [-118.44484, 34.1151], [-118.44451, 34.1151], [-118.4445, 34.11352], [-118.44396, 34.11337], [-118.44376, 34.11384], [-118.44371, 34.11405], [-118.44371, 34.11421], [-118.44373, 34.11433], [-118.44387, 34.11474], [-118.44384, 34.1148], [-118.44378, 34.11479], [-118.44346, 34.11499], [-118.44346, 34.11536], [-118.44338, 34.11548], [-118.44279, 34.11594], [-118.44274, 34.11612], [-118.44265, 34.11627], [-118.44222, 34.11633], [-118.44215, 34.11642], [-118.4422, 34.11662], [-118.44246, 34.11684], [-118.44251, 34.11711], [-118.4426, 34.11728], [-118.44245, 34.11747], [-118.44228, 34.11752], [-118.44193, 34.11748], [-118.4418, 34.11756], [-118.44158, 34.11756], [-118.44113, 34.11732], [-118.44103, 34.11704], [-118.44049, 34.11692], [-118.44021, 34.11673], [-118.44021, 34.11602], [-118.4379, 34.11601], [-118.4379, 34.1145], [-118.43905, 34.11444], [-118.44021, 34.1146], [-118.44022, 34.10877], [-118.44407, 34.10878], [-118.44428, 34.10927], [-118.44309, 34.1102], [-118.44397, 34.11237], [-118.44555, 34.11239], [-118.44635, 34.11437], [-118.44631, 34.11477], [-118.44631, 34.11523], [-118.44628, 34.1155], [-118.44618, 34.11604]]]]} | Open Access 1 | 6394 | Beverly Glen Park | 29532 | 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 | 95.504 | Beverly Glen Park | 0 | Local Park 2 | 4 | |
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 | |
10267 | 10267 | 10266 | {"type": "MultiPolygon", "coordinates": [[[[-118.27963, 34.43891], [-118.27942, 34.44], [-118.27919, 34.43986], [-118.27895, 34.43975], [-118.27854, 34.4396], [-118.27563, 34.4389], [-118.27527, 34.43884], [-118.27503, 34.43882], [-118.27478, 34.43883], [-118.27453, 34.43886], [-118.27415, 34.43895], [-118.2739, 34.43904], [-118.27307, 34.43944], [-118.27278, 34.43957], [-118.27249, 34.43966], [-118.27218, 34.43973], [-118.27214, 34.43775], [-118.27694, 34.43776], [-118.27882, 34.43867], [-118.2793, 34.43883], [-118.27963, 34.43891]]], [[[-118.27986, 34.44135], [-118.27222, 34.44131], [-118.2722, 34.44029], [-118.2726, 34.44021], [-118.27309, 34.44005], [-118.2734, 34.43992], [-118.27412, 34.43956], [-118.27445, 34.43944], [-118.2748, 34.43938], [-118.27503, 34.43937], [-118.27527, 34.43939], [-118.27822, 34.44009], [-118.27858, 34.4402], [-118.27891, 34.44037], [-118.27921, 34.44059], [-118.27947, 34.44086], [-118.27986, 34.44135]]]]} | Open Access 1 | 48531 | Bird's Nest | 33245 | 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 | 51.384 | Bird's Nest | 2018 | None 894 | ||
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 |
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]);