units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
207 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, PARK_URL, COUNTY, GAP_STS
MNG_AGENCY >30
- Los Angeles, City of 36
- Torrance, City of 20
- San Diego, City of 19
- Napa, City of 12
- Escondido, City of 10
- Santa Rosa, City of 9
- Rocklin, City of 8
- Los Angeles - Department of Water and Power, City of 7
- Vallejo, City of 7
- Saint Helena, City of 5
- Petaluma, City of 4
- Vacaville, City of 4
- San Marcos, City of 4
- Long Beach, City of 4
- Rolling Hills, City of 3
- La Verne, City of 3
- Chico, City of 3
- Roseville, City of 3
- Poway, City of 2
- Rancho Palos Verdes, City of 2
- Palos Verdes Estates, City of 2
- Redding, City of 2
- Arcata, City of 2
- Sebastopol, City of 2
- Watsonville, City of 1
- Santee, City of 1
- Glendora, City of 1
- Oceanside, City of 1
- Chula Vista, City of 1
- Rosemead, City of 1
- …
DES_TP >30
- Local Other or Unknown 60
- Local Recreation Area 40
- Local Park 38
- Local Conservation Area 6
- Local Resource Management Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 1
- City Agency · 207 ✖
ACCESS_TYP 1
- No Public Access · 207 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16235 | 16235 | 16234 | {"type": "Polygon", "coordinates": [[[-121.90527, 37.49358], [-121.9052, 37.49364], [-121.90471, 37.49366], [-121.90456, 37.49364], [-121.90442, 37.49372], [-121.90408, 37.49378], [-121.90368, 37.49411], [-121.90363, 37.49437], [-121.90355, 37.49439], [-121.90348, 37.49455], [-121.90325, 37.49465], [-121.90315, 37.49491], [-121.90248, 37.49516], [-121.9024, 37.49534], [-121.90229, 37.49542], [-121.90177, 37.49562], [-121.90156, 37.49585], [-121.90097, 37.49594], [-121.90084, 37.49614], [-121.90056, 37.49617], [-121.89998, 37.49613], [-121.8998, 37.49602], [-121.89974, 37.49574], [-121.89986, 37.4957], [-121.89973, 37.49537], [-121.89955, 37.49532], [-121.89943, 37.49536], [-121.89882, 37.49529], [-121.89845, 37.49496], [-121.89838, 37.49473], [-121.89801, 37.49457], [-121.89793, 37.49432], [-121.8977, 37.49424], [-121.89727, 37.49438], [-121.89699, 37.49434], [-121.89673, 37.49487], [-121.89596, 37.49633], [-121.89529, 37.49776], [-121.89423, 37.49959], [-121.87661, 37.50034], [-121.87655, 37.50024], [-121.87577, 37.49798], [-121.87328, 37.49109], [-121.8745, 37.48905], [-121.87416, 37.48824], [-121.88426, 37.48716], [-121.88426, 37.48713], [-121.88511, 37.48551], [-121.88591, 37.48351], [-121.88572, 37.48314], [-121.88587, 37.48215], [-121.88616, 37.48178], [-121.88617, 37.48153], [-121.88602, 37.48132], [-121.88578, 37.48131], [-121.88506, 37.48093], [-121.88517, 37.48071], [-121.88332, 37.47962], [-121.88417, 37.47872], [-121.88427, 37.47857], [-121.88435, 37.4784], [-121.88432, 37.4782], [-121.89052, 37.47614], [-121.89123, 37.47752], [-121.88921, 37.47817], [-121.88976, 37.47925], [-121.89093, 37.47887], [-121.89129, 37.4789], [-121.8913, 37.48002], [-121.89194, 37.47978], [-121.89223, 37.47964], [-121.89264, 37.47948], [-121.89322, 37.47935], [-121.89409, 37.4794], [-121.89446, 37.47931], [-121.89499, 37.47944], [-121.89526, 37.47959], [-121.89528, 37.48093], [-121.89506, 37.48116], [-121.89528, 37.48185], [-121.89638, 37.48301], [-121.89647, 37.48309], [-121.89662, 37.48318], [-121.89683, 37.48327], [-121.89701, 37.48331], [-121.89717, 37.48333], [-121.89718, 37.48355], [-121.89721, 37.48373], [-121.89729, 37.48393], [-121.89741, 37.48415], [-121.89758, 37.48434], [-121.89775, 37.48449], [-121.89793, 37.48461], [-121.89818, 37.48474], [-121.89803, 37.4849], [-121.89793, 37.48504], [-121.89786, 37.48522], [-121.89782, 37.4854], [-121.89782, 37.48558], [-121.89785, 37.48576], [-121.89791, 37.48594], [-121.898, 37.48609], [-121.89811, 37.48622], [-121.89824, 37.48633], [-121.89841, 37.48643], [-121.89859, 37.48651], [-121.8988, 37.48657], [-121.899, 37.48661], [-121.89922, 37.48663], [-121.89944, 37.48662], [-121.89949, 37.48682], [-121.8996, 37.48709], [-121.89974, 37.48732], [-121.89991, 37.48754], [-121.90012, 37.48773], [-121.90031, 37.48789], [-121.90053, 37.48802], [-121.9008, 37.48815], [-121.90118, 37.48828], [-121.90167, 37.48838], [-121.90203, 37.4884], [-121.90318, 37.48839], [-121.90331, 37.48903], [-121.90383, 37.4901], [-121.90369, 37.49084], [-121.90527, 37.49358]]]} | No Public Access 3 | 45940 | Hill Face Open Space City of Fremont | 29020 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 1038.333 | Hill Face OS City of Fremont | 1976 | None 1395 | ||
16227 | 16227 | 16226 | {"type": "Polygon", "coordinates": [[[-117.91283, 34.03821], [-117.91283, 34.03899], [-117.91275, 34.03962], [-117.9127, 34.0399], [-117.91261, 34.04022], [-117.9125, 34.04056], [-117.91237, 34.04089], [-117.91209, 34.04146], [-117.91176, 34.04199], [-117.91145, 34.04239], [-117.91062, 34.04338], [-117.9068, 34.0425], [-117.9068, 34.04242], [-117.90687, 34.04244], [-117.9069, 34.04236], [-117.90686, 34.04212], [-117.90703, 34.04191], [-117.907, 34.04164], [-117.90695, 34.04141], [-117.90686, 34.04117], [-117.90723, 34.04103], [-117.9074, 34.04095], [-117.9077, 34.04076], [-117.90797, 34.04194], [-117.9081, 34.04194], [-117.90836, 34.04217], [-117.90888, 34.0422], [-117.9092, 34.04178], [-117.9092, 34.04176], [-117.90879, 34.04158], [-117.90868, 34.04151], [-117.90863, 34.04145], [-117.90852, 34.04124], [-117.90817, 34.04033], [-117.90908, 34.03917], [-117.90866, 34.0401], [-117.90909, 34.04119], [-117.91045, 34.04181], [-117.91066, 34.04186], [-117.91145, 34.0417], [-117.912, 34.04119], [-117.91214, 34.04079], [-117.91193, 34.04047], [-117.91203, 34.04013], [-117.91245, 34.03993], [-117.91257, 34.03967], [-117.91242, 34.03907], [-117.91225, 34.0388], [-117.91189, 34.03836], [-117.91192, 34.03815], [-117.91215, 34.03816], [-117.91278, 34.03816], [-117.91283, 34.03821]]]} | No Public Access 3 | 45356 | City Open Space | 17340 | 1374 | West Covina, City of 318 | City 2 | City Agency 2 | http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals | City 2 | 1374 | West Covina, City of 315 | City 2 | City Agency 2 | http://www.nlc.org/Documents/Utility%20Navigation/About%20NLC/Awards/2008%20West%20Covina%20Nomination.pdf | Los Angeles 6 | 22.107 | City OS | 0 | Local Recreation Area 3 | 4 |
16219 | 16219 | 16218 | {"type": "Polygon", "coordinates": [[[-117.17233, 33.2342], [-117.17202, 33.23604], [-117.17189, 33.23648], [-117.17178, 33.23675], [-117.17165, 33.23702], [-117.17032, 33.23703], [-117.1702, 33.23718], [-117.17023, 33.23751], [-117.17011, 33.23751], [-117.16988, 33.23783], [-117.16972, 33.23784], [-117.16977, 33.2384], [-117.16849, 33.23842], [-117.16846, 33.24102], [-117.16803, 33.24124], [-117.16763, 33.24094], [-117.16776, 33.24042], [-117.16769, 33.2402], [-117.16743, 33.23991], [-117.16592, 33.23931], [-117.16579, 33.23935], [-117.16431, 33.23922], [-117.16405, 33.23994], [-117.16386, 33.23992], [-117.16381, 33.23961], [-117.16384, 33.23934], [-117.15908, 33.23938], [-117.15804, 33.23852], [-117.15919, 33.23818], [-117.15945, 33.23775], [-117.15995, 33.23749], [-117.16145, 33.23719], [-117.16196, 33.23581], [-117.1627, 33.23526], [-117.16318, 33.23561], [-117.16327, 33.23494], [-117.16638, 33.23486], [-117.16638, 33.23119], [-117.16608, 33.23118], [-117.16622, 33.2307], [-117.16638, 33.23055], [-117.16638, 33.23112], [-117.16644, 33.23112], [-117.16649, 33.23108], [-117.16651, 33.23101], [-117.16644, 33.23081], [-117.16645, 33.23065], [-117.16653, 33.23046], [-117.16659, 33.23041], [-117.16665, 33.23038], [-117.16671, 33.23037], [-117.16745, 33.2305], [-117.16762, 33.2305], [-117.16779, 33.23047], [-117.1683, 33.23026], [-117.16876, 33.22996], [-117.16893, 33.22982], [-117.16899, 33.22975], [-117.1691, 33.22972], [-117.16919, 33.22975], [-117.1693, 33.22992], [-117.16944, 33.23004], [-117.16958, 33.23012], [-117.16978, 33.23017], [-117.16979, 33.23023], [-117.16989, 33.23025], [-117.16996, 33.23029], [-117.17, 33.23033], [-117.17008, 33.23044], [-117.17016, 33.23051], [-117.17022, 33.23053], [-117.17059, 33.23058], [-117.1706, 33.23248], [-117.17094, 33.2325], [-117.17188, 33.23359], [-117.17209, 33.23384], [-117.17201, 33.23419], [-117.17233, 33.2342]]]} | No Public Access 3 | 44881 | City of Oceanside Open Space | 17323 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 175.69 | City of Oceanside OS | 0 | Local Recreation Area 3 | 4 | |
16217 | 16217 | 16216 | {"type": "Polygon", "coordinates": [[[-117.14604, 33.16753], [-117.14568, 33.16832], [-117.14568, 33.16839], [-117.14137, 33.16834], [-117.1414, 33.16739], [-117.14061, 33.16658], [-117.14096, 33.16596], [-117.14048, 33.16411], [-117.14004, 33.1621], [-117.14023, 33.16217], [-117.14033, 33.16218], [-117.14079, 33.16211], [-117.1411, 33.1621], [-117.14137, 33.16215], [-117.14156, 33.16223], [-117.14169, 33.16234], [-117.14177, 33.16245], [-117.14184, 33.16259], [-117.14188, 33.16273], [-117.14187, 33.16285], [-117.14183, 33.16297], [-117.14178, 33.16306], [-117.14167, 33.16317], [-117.14168, 33.16329], [-117.14171, 33.1633], [-117.14189, 33.1633], [-117.1421, 33.16337], [-117.14218, 33.16342], [-117.1423, 33.16353], [-117.14243, 33.16362], [-117.14253, 33.16364], [-117.14279, 33.16359], [-117.14292, 33.1636], [-117.14302, 33.16367], [-117.14316, 33.16387], [-117.14335, 33.16399], [-117.14343, 33.16402], [-117.14354, 33.16401], [-117.14409, 33.16385], [-117.14429, 33.16385], [-117.14558, 33.16436], [-117.14574, 33.16445], [-117.14582, 33.16446], [-117.14584, 33.16451], [-117.14584, 33.16519], [-117.14582, 33.16537], [-117.14581, 33.166], [-117.14596, 33.16649], [-117.14598, 33.16664], [-117.14597, 33.16709], [-117.14604, 33.16753]]]} | No Public Access 3 | 44872 | City of Escondido Open Space | 17311 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 63.739 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
16198 | 16198 | 16197 | {"type": "MultiPolygon", "coordinates": [[[[-121.34941, 38.79537], [-121.34798, 38.79538], [-121.34717, 38.79574], [-121.34689, 38.7957], [-121.3466, 38.79572], [-121.34636, 38.79581], [-121.34598, 38.79589], [-121.34575, 38.79591], [-121.34553, 38.79633], [-121.34539, 38.79642], [-121.34546, 38.79651], [-121.34533, 38.79656], [-121.34503, 38.79653], [-121.34482, 38.79647], [-121.34463, 38.79639], [-121.3443, 38.79618], [-121.34403, 38.79595], [-121.34386, 38.79578], [-121.34362, 38.79541], [-121.34649, 38.79539], [-121.34649, 38.79424], [-121.34613, 38.79383], [-121.34831, 38.79267], [-121.34883, 38.79244], [-121.3494, 38.79224], [-121.34941, 38.79537]]], [[[-121.35801, 38.79652], [-121.35705, 38.79746], [-121.35665, 38.79764], [-121.35666, 38.79765], [-121.35697, 38.79762], [-121.35696, 38.79774], [-121.35703, 38.79776], [-121.35705, 38.7978], [-121.35693, 38.79835], [-121.35683, 38.79867], [-121.35669, 38.79897], [-121.35642, 38.79941], [-121.35463, 38.7994], [-121.35463, 38.79941], [-121.3554, 38.80031], [-121.35405, 38.80103], [-121.35391, 38.8008], [-121.35328, 38.79965], [-121.3533, 38.7996], [-121.35353, 38.79945], [-121.35364, 38.79932], [-121.35372, 38.79919], [-121.35377, 38.79905], [-121.35364, 38.79904], [-121.35357, 38.7992], [-121.35348, 38.79933], [-121.35336, 38.79943], [-121.35313, 38.79954], [-121.35287, 38.7996], [-121.35269, 38.7996], [-121.35251, 38.79957], [-121.35235, 38.79951], [-121.35213, 38.79937], [-121.35199, 38.79919], [-121.35172, 38.79852], [-121.35169, 38.79835], [-121.35168, 38.79824], [-121.35161, 38.79817], [-121.3515, 38.79816], [-121.35015, 38.79832], [-121.3494, 38.79846], [-121.34939, 38.7984], [-121.3487, 38.79854], [-121.34812, 38.79871], [-121.34791, 38.79878], [-121.34731, 38.79909], [-121.34697, 38.79912], [-121.34689, 38.79916], [-121.34667, 38.79889], [-121.34614, 38.79806], [-121.34599, 38.79788], [-121.34656, 38.79754], [-121.34683, 38.79753], [-121.34706, 38.79734], [-121.34744, 38.79725], [-121.34749, 38.79719], [-121.3479, 38.79713], [-121.34798, 38.79701], [-121.34794, 38.79683], [-121.348, 38.79653], [-121.34805, 38.79653], [-121.34824, 38.79633], [-121.34851, 38.79618], [-121.34862, 38.796], [-121.34879, 38.79586], [-121.34941, 38.79566], [-121.34942, 38.79647], [-121.35801, 38.79652]]], [[[-121.3539, 38.80109], [-121.35254, 38.80165], [-121.35206, 38.80044], [-121.35202, 38.80031], [-121.35203, 38.80017], [-121.35208, 38.80001], [-121.35231, 38.79968], [-121.35239, 38.79965], [-121.35266, 38.7997], [-121.35285, 38.7997], [-121.35306, 38.79968], [-121.35311, 38.7997], [-121.35375, 38.80085], [-121.3539, 38.80109]]]]} | No Public Access 3 | 29577 | Veterans Memorial Park Open Space | 27036 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 95.757 | Veterans Memorial Park OS | 0 | Local Recreation Area 3 | 4 | |
16141 | 16141 | 16140 | {"type": "MultiPolygon", "coordinates": [[[[-122.03212, 38.31331], [-122.03196, 38.3141], [-122.0313, 38.31544], [-122.03096, 38.31544], [-122.03056, 38.31614], [-122.0301, 38.31688], [-122.03005, 38.31707], [-122.03027, 38.31735], [-122.02952, 38.31821], [-122.02738, 38.32038], [-122.02634, 38.32147], [-122.02566, 38.32227], [-122.02487, 38.32309], [-122.0247, 38.32296], [-122.02481, 38.32271], [-122.02483, 38.32231], [-122.02483, 38.32091], [-122.02485, 38.32029], [-122.0247, 38.32019], [-122.02475, 38.31971], [-122.0241, 38.31956], [-122.0236, 38.31937], [-122.02353, 38.3194], [-122.02348, 38.31936], [-122.02274, 38.31931], [-122.02228, 38.31923], [-122.02192, 38.31888], [-122.0215, 38.31869], [-122.02116, 38.31849], [-122.02102, 38.31823], [-122.02092, 38.31819], [-122.02096, 38.31815], [-122.02096, 38.31813], [-122.02055, 38.31799], [-122.01993, 38.31769], [-122.01946, 38.3173], [-122.01902, 38.31716], [-122.01847, 38.31693], [-122.018, 38.31679], [-122.01748, 38.3165], [-122.01657, 38.31619], [-122.0151, 38.3158], [-122.01478, 38.31549], [-122.01664, 38.31423], [-122.01662, 38.31401], [-122.01662, 38.31386], [-122.01666, 38.31363], [-122.0167, 38.3135], [-122.01679, 38.3133], [-122.01718, 38.31269], [-122.01719, 38.31264], [-122.01713, 38.31259], [-122.01662, 38.31255], [-122.01647, 38.31252], [-122.01631, 38.31243], [-122.01624, 38.31236], [-122.01617, 38.31227], [-122.01613, 38.31219], [-122.01612, 38.31209], [-122.01615, 38.31194], [-122.01619, 38.31185], [-122.01642, 38.31155], [-122.01651, 38.31136], [-122.01649, 38.31128], [-122.01645, 38.31124], [-122.0164, 38.31121], [-122.01614, 38.31119], [-122.01585, 38.3112], [-122.01556, 38.31124], [-122.01526, 38.31132], [-122.01513, 38.3114], [-122.01506, 38.31147], [-122.01501, 38.31158], [-122.015, 38.31175], [-122.01495, 38.31183], [-122.01488, 38.31189], [-122.01477, 38.31193], [-122.01466, 38.31195], [-122.01453, 38.31193], [-122.01442, 38.31187], [-122.01427, 38.31127], [-122.01425, 38.31107], [-122.01427, 38.31084], [-122.01435, 38.31059], [-122.01478, 38.30969], [-122.01478, 38.30965], [-122.01477, 38.3096], [-122.01473, 38.30955], [-122.0145, 38.30941], [-122.01443, 38.30938], [-122.01382, 38.30946], [-122.01352, 38.30948], [-122.01333, 38.30946], [-122.01311, 38.3094], [-122.01293, 38.30928], [-122.01278, 38.30911], [-122.01274, 38.30903], [-122.0127, 38.30886], [-122.01269, 38.30872], [-122.01858, 38.30883], [-122.01866, 38.30895], [-122.01898, 38.30911], [-122.02115, 38.30989], [-122.02458, 38.31092], [-122.0254, 38.31237], [-122.02696, 38.31291], [-122.02885, 38.31231], [-122.02898, 38.31232], [-122.03212, 38.31331]], [[-122.02474, 38.31963], [-122.02475, 38.31964], [-122.02476, 38.31963], [-122.02475, 38.31962], [-122.02474, 38.31963]]], [[[-122.03081, 38.3203], [-122.03054, 38.32057], [-122.03033, 38.32076], [-122.02936, 38.32075], [-122.02948, 38.32125], [-122.02987, 38.32264], [-122.02992, 38.32293], [-122.03005, 38.3234], [-122.03005, 38.32493], [-122.02932, 38.325], [-122.02804, 38.32553], [-122.02611, 38.32602], [-122.02533, 38.32521], [-122.02522, 38.325], [-122.02514, 38.32475], [-122.02511, 38.32448], [-122.02514, 38.32422], [-122.02521, 38.32396], [-122.02543, 38.32374], [-122.0258, 38.32326], [-122.02614, 38.32278], [-122.0283, 38.32044], [-122.02862, 38.32014], [-122.03003, 38.31861], [-122.03081, 38.3203]]]]} | No Public Access 3 | 17793 | Lagoon Valley Open Space | 30790 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 346.712 | Lagoon Valley OS | 0 | Local Recreation Area 3 | 4 | |
16087 | 16087 | 16086 | {"type": "MultiPolygon", "coordinates": [[[[-116.90152, 33.10587], [-116.89724, 33.10587], [-116.89719, 33.10206], [-116.89513, 33.10205], [-116.89508, 33.10392], [-116.89076, 33.10399], [-116.89074, 33.10215], [-116.89295, 33.10209], [-116.89298, 33.09483], [-116.89275, 33.08392], [-116.90146, 33.08384], [-116.90148, 33.08369], [-116.90146, 33.08771], [-116.89987, 33.08735], [-116.8997, 33.08734], [-116.89919, 33.08738], [-116.89898, 33.08738], [-116.89802, 33.08726], [-116.89789, 33.08727], [-116.89777, 33.0873], [-116.89716, 33.08761], [-116.89689, 33.08767], [-116.89679, 33.08771], [-116.8967, 33.08775], [-116.89665, 33.08781], [-116.89661, 33.08793], [-116.89663, 33.08808], [-116.89657, 33.08829], [-116.89633, 33.08876], [-116.89605, 33.08912], [-116.89595, 33.08934], [-116.89596, 33.08943], [-116.89612, 33.08973], [-116.89632, 33.08999], [-116.89646, 33.09033], [-116.89664, 33.09052], [-116.8967, 33.09062], [-116.89672, 33.09068], [-116.89672, 33.09073], [-116.89656, 33.09103], [-116.89643, 33.09145], [-116.89626, 33.09176], [-116.896, 33.09212], [-116.89594, 33.09225], [-116.89588, 33.09244], [-116.89584, 33.09273], [-116.89577, 33.09306], [-116.89575, 33.09322], [-116.89565, 33.0938], [-116.89555, 33.09451], [-116.8955, 33.09464], [-116.89534, 33.09481], [-116.8955, 33.09482], [-116.8956, 33.09471], [-116.89567, 33.0946], [-116.89578, 33.09376], [-116.89588, 33.09326], [-116.89589, 33.09313], [-116.89607, 33.09227], [-116.89614, 33.09212], [-116.89637, 33.09182], [-116.89654, 33.09153], [-116.89666, 33.09113], [-116.89684, 33.09077], [-116.89685, 33.09067], [-116.89684, 33.09059], [-116.89674, 33.09046], [-116.89664, 33.09036], [-116.89658, 33.09028], [-116.89643, 33.08994], [-116.89626, 33.08971], [-116.89609, 33.0894], [-116.89609, 33.08935], [-116.89617, 33.08916], [-116.89644, 33.08879], [-116.89669, 33.08833], [-116.89675, 33.08817], [-116.89675, 33.0879], [-116.89678, 33.08784], [-116.89693, 33.08777], [-116.89718, 33.08773], [-116.89783, 33.0874], [-116.89791, 33.08737], [-116.89801, 33.08737], [-116.89902, 33.08748], [-116.89923, 33.08748], [-116.89969, 33.08745], [-116.89986, 33.08746], [-116.90146, 33.08783], [-116.90149, 33.09135], [-116.90152, 33.10587]]], [[[-116.91016, 33.11349], [-116.90585, 33.11346], [-116.90585, 33.12475], [-116.89299, 33.12481], [-116.89298, 33.12095], [-116.90158, 33.12097], [-116.90154, 33.11025], [-116.91014, 33.11012], [-116.91016, 33.11349]]]]} | No Public Access 3 | 47726 | San Pasqual Trails Open Space | 31514 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | https://www.sandiego.gov/park-and-recreation/parks/osp/sanpasqual | San Diego 4 | 738.003 | San Pasqual Trails OS | 0 | Local Recreation Area 3 | 4 |
15992 | 15992 | 15991 | {"type": "Polygon", "coordinates": [[[-121.9799, 38.37625], [-121.97978, 38.37626], [-121.97969, 38.37632], [-121.97967, 38.37636], [-121.97967, 38.37641], [-121.97972, 38.3765], [-121.97906, 38.37666], [-121.97898, 38.37672], [-121.97889, 38.3767], [-121.97882, 38.3767], [-121.97877, 38.37672], [-121.97872, 38.37667], [-121.97795, 38.37669], [-121.97733, 38.37393], [-121.97713, 38.37363], [-121.97701, 38.37346], [-121.977, 38.37339], [-121.97718, 38.37325], [-121.97737, 38.37299], [-121.97738, 38.37294], [-121.9774, 38.3729], [-121.97744, 38.37276], [-121.97745, 38.37234], [-121.9775, 38.3723], [-121.97831, 38.37233], [-121.97891, 38.37241], [-121.97913, 38.37242], [-121.97914, 38.37278], [-121.97928, 38.37297], [-121.97928, 38.37308], [-121.9793, 38.37312], [-121.97931, 38.37328], [-121.97934, 38.37343], [-121.97935, 38.37375], [-121.97943, 38.3738], [-121.97942, 38.37399], [-121.97936, 38.37423], [-121.97943, 38.37455], [-121.97952, 38.37459], [-121.9795, 38.37467], [-121.97953, 38.37474], [-121.97948, 38.37477], [-121.97954, 38.37506], [-121.97976, 38.37535], [-121.97972, 38.3754], [-121.97972, 38.37545], [-121.97975, 38.37551], [-121.97981, 38.37556], [-121.9798, 38.37594], [-121.9799, 38.37625]]]} | No Public Access 3 | 1305 | Sunrise Woodcrest Open Space | 26039 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 20.516 | Sunrise Woodcrest OS | 0 | Local Recreation Area 3 | 4 | |
15478 | 15478 | 15477 | {"type": "Polygon", "coordinates": [[[-121.79324, 36.88092], [-121.79324, 36.88092], [-121.78808, 36.88474], [-121.78767, 36.88399], [-121.79284, 36.88016], [-121.79324, 36.88092]]]} | No Public Access 3 | 36631 | Unnamed site - Watsonville, City of | 28700 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 13.356 | 0 | Local Other or Unknown 14 | 4 | ||
15451 | 15451 | 15450 | {"type": "Polygon", "coordinates": [[[-117.10104, 32.96786], [-117.0991, 32.9694], [-117.09768, 32.96813], [-117.0991, 32.96695], [-117.0996, 32.96659], [-117.10104, 32.96786]]]} | No Public Access 3 | 46721 | Penasquitos Village Neighborhood Park | 30267 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 12.044 | Penasquitos Village Neighborhood Park | 0 | Local Park 2 | 4 | |
15449 | 15449 | 15448 | {"type": "Polygon", "coordinates": [[[-122.30439, 38.26326], [-122.30382, 38.2634], [-122.30362, 38.26287], [-122.30419, 38.26274], [-122.30439, 38.26326]]]} | No Public Access 3 | 36595 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.78 | 0 | Local Other or Unknown 14 | 4 | ||
15412 | 15412 | 15411 | {"type": "Polygon", "coordinates": [[[-118.406, 33.79151], [-118.40587, 33.79177], [-118.40576, 33.79194], [-118.40567, 33.79201], [-118.40524, 33.7921], [-118.40517, 33.7922], [-118.40513, 33.7924], [-118.40438, 33.79231], [-118.40443, 33.79216], [-118.4045, 33.79203], [-118.40506, 33.79115], [-118.40519, 33.791], [-118.406, 33.79151]]]} | No Public Access 3 | 46640 | Bluff Cove North | 29976 | 1244 | Palos Verdes Estates, City of 293 | City 2 | City Agency 2 | http://www.pvestates.org/ | City 2 | 1244 | Palos Verdes Estates, City of 289 | City 2 | City Agency 2 | Los Angeles 6 | 3.008 | Bluff Cove North | None 1362 | |||
15410 | 15410 | 15409 | {"type": "Polygon", "coordinates": [[[-118.407, 33.79048], [-118.40696, 33.79057], [-118.40695, 33.79068], [-118.40687, 33.79076], [-118.40686, 33.79084], [-118.40677, 33.79095], [-118.40645, 33.79106], [-118.40624, 33.79121], [-118.40586, 33.79072], [-118.40633, 33.79064], [-118.40657, 33.79056], [-118.40695, 33.79039], [-118.407, 33.79048]]]} | No Public Access 3 | 46637 | Bluff Cove South | 29977 | 1244 | Palos Verdes Estates, City of 293 | City 2 | City Agency 2 | http://www.pvestates.org/ | City 2 | 1244 | Palos Verdes Estates, City of 289 | City 2 | City Agency 2 | Los Angeles 6 | 1.097 | Bluff Cove South | None 1361 | |||
15407 | 15407 | 15406 | {"type": "MultiPolygon", "coordinates": [[[[-118.19258, 33.84372], [-118.18742, 33.84551], [-118.1873, 33.84546], [-118.18731, 33.84541], [-118.18836, 33.84504], [-118.18837, 33.84497], [-118.18857, 33.84497], [-118.18981, 33.84454], [-118.18982, 33.84458], [-118.19067, 33.84429], [-118.19068, 33.84423], [-118.19254, 33.8436], [-118.19258, 33.84372]]], [[[-118.19442, 33.8431], [-118.19291, 33.84361], [-118.19283, 33.84363], [-118.19279, 33.84352], [-118.194, 33.8431], [-118.19442, 33.8431]]]]} | No Public Access 3 | 46631 | Sleepy Hollow Greenbelt | 29956 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 2.297 | Sleepy Hollow Greenbelt | 0 | Local Recreation Area 3 | 4 | |
15401 | 15401 | 15400 | {"type": "MultiPolygon", "coordinates": [[[[-118.1485, 33.77888], [-118.14796, 33.77888], [-118.14599, 33.77761], [-118.14599, 33.77723], [-118.14605, 33.77723], [-118.14796, 33.77847], [-118.14797, 33.77854], [-118.1485, 33.77888]]], [[[-118.15014, 33.78025], [-118.14868, 33.77931], [-118.14828, 33.77905], [-118.1488, 33.77905], [-118.15013, 33.7799], [-118.15014, 33.78025]]]]} | No Public Access 3 | 46622 | Pacific Electric Greenbelt | 29943 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 3.703 | Pacific Electric Greenbelt | 0 | Local Recreation Area 3 | 4 | |
15363 | 15363 | 15362 | {"type": "Polygon", "coordinates": [[[-118.04461, 34.0463], [-118.04438, 34.04649], [-118.04391, 34.0461], [-118.04414, 34.0459], [-118.04461, 34.0463]]]} | No Public Access 3 | 46548 | Civic Center Community Park | 29845 | 1402 | South El Monte, City of 606 | City 2 | City Agency 2 | http://www.ci.south-el-monte.ca.us/CITYDEPARTMENTSSERVICES/CommunityServices/ParksandRecreationDivision.aspx | City 2 | 1402 | South El Monte, City of 595 | City 2 | City Agency 2 | Los Angeles 6 | 0.465 | Civic Ctr. Community Park | 0 | Local Park 2 | 4 | |
15347 | 15347 | 15346 | {"type": "Polygon", "coordinates": [[[-118.07279, 33.89481], [-118.07274, 33.89485], [-118.06735, 33.89488], [-118.06735, 33.89329], [-118.06725, 33.89318], [-118.06717, 33.89306], [-118.06712, 33.89292], [-118.0671, 33.89279], [-118.06712, 33.89265], [-118.06717, 33.8925], [-118.06725, 33.89238], [-118.06737, 33.89226], [-118.06737, 33.89147], [-118.06577, 33.89148], [-118.06576, 33.8915], [-118.06423, 33.89151], [-118.06423, 33.89137], [-118.07276, 33.89132], [-118.07279, 33.89481]]]} | No Public Access 3 | 46532 | Holifield Park | 29823 | 1225 | Norwalk, City of 239 | City 2 | City Agency 2 | http://www.ci.norwalk.ca.us/city-hall/departments/recreation-park-services | City 2 | 1225 | Norwalk, City of 235 | City 2 | City Agency 2 | Los Angeles 6 | 50.044 | Holifield Park | 0 | Local Park 2 | 4 | |
15325 | 15325 | 15324 | {"type": "Polygon", "coordinates": [[[-117.85818, 34.19361], [-117.85655, 34.19631], [-117.85599, 34.19646], [-117.85577, 34.1973], [-117.85578, 34.19593], [-117.85608, 34.19586], [-117.85744, 34.1936], [-117.85818, 34.19361]]]} | No Public Access 3 | 48970 | Unnamed Site - Pasadena Department of Water and Power | 33667 | 1720 | Pasadena Department of Water and Power 1153 | City 2 | City Agency 2 | https://ww5.cityofpasadena.net/water-and-power/ | City 2 | 1720 | Pasadena Department of Water and Power 1099 | City 2 | City Agency 2 | Los Angeles 6 | 5.621 | 0 | Local Other or Unknown 14 | 4 | ||
15223 | 15223 | 15222 | {"type": "Polygon", "coordinates": [[[-118.07934, 34.56476], [-118.07807, 34.56476], [-118.07807, 34.56394], [-118.07933, 34.56393], [-118.07934, 34.56476]]]} | No Public Access 3 | 46145 | Palmdale Park | 29479 | 1242 | Palmdale, City of 205 | City 2 | City Agency 2 | http://www.cityofpalmdale.org/Residents/Recreation-and-Culture | City 2 | 1242 | Palmdale, City of 201 | City 2 | City Agency 2 | Los Angeles 6 | 2.617 | Palmdale Park | 0 | Local Park 2 | 4 | |
14695 | 14695 | 14694 | {"type": "MultiPolygon", "coordinates": [[[[-121.84325, 39.73187], [-121.84302, 39.73192], [-121.84284, 39.7319], [-121.8422, 39.73193], [-121.84217, 39.73192], [-121.84212, 39.73178], [-121.84229, 39.73181], [-121.84258, 39.7318], [-121.84284, 39.73176], [-121.84292, 39.73172], [-121.8431, 39.73171], [-121.84317, 39.73169], [-121.84325, 39.73187]]], [[[-121.8483, 39.72901], [-121.84825, 39.72906], [-121.84809, 39.72914], [-121.84775, 39.72926], [-121.84745, 39.72934], [-121.84724, 39.72943], [-121.84701, 39.72956], [-121.84693, 39.72964], [-121.84664, 39.73034], [-121.84626, 39.73047], [-121.84533, 39.73053], [-121.8451, 39.73057], [-121.84483, 39.73066], [-121.84461, 39.73079], [-121.84442, 39.73095], [-121.84438, 39.73092], [-121.84423, 39.73115], [-121.84412, 39.73137], [-121.84389, 39.73163], [-121.84382, 39.73172], [-121.84344, 39.73192], [-121.84338, 39.73185], [-121.84331, 39.73187], [-121.84322, 39.73166], [-121.84325, 39.73162], [-121.84348, 39.73146], [-121.84363, 39.73136], [-121.84379, 39.73128], [-121.84391, 39.73119], [-121.84403, 39.73107], [-121.84412, 39.7309], [-121.84423, 39.73057], [-121.84431, 39.73045], [-121.84438, 39.73039], [-121.84469, 39.73023], [-121.84494, 39.73022], [-121.84504, 39.73015], [-121.84512, 39.73011], [-121.8453, 39.73009], [-121.84578, 39.73006], [-121.84608, 39.73008], [-121.84626, 39.73003], [-121.8464, 39.72995], [-121.84652, 39.72982], [-121.84662, 39.72962], [-121.84663, 39.72953], [-121.84673, 39.72936], [-121.8468, 39.72928], [-121.84694, 39.72919], [-121.8472, 39.72907], [-121.84743, 39.72901], [-121.84782, 39.72895], [-121.84786, 39.72891], [-121.84794, 39.72886], [-121.84801, 39.72875], [-121.8483, 39.72901]]], [[[-121.85008, 39.72685], [-121.84992, 39.72697], [-121.84966, 39.72711], [-121.84932, 39.7274], [-121.84909, 39.72756], [-121.84895, 39.72763], [-121.84884, 39.72766], [-121.84868, 39.72775], [-121.8486, 39.72781], [-121.84849, 39.72795], [-121.84844, 39.72805], [-121.84837, 39.72832], [-121.84848, 39.72843], [-121.84856, 39.72859], [-121.8486, 39.72873], [-121.84857, 39.72885], [-121.84847, 39.72892], [-121.848, 39.72838], [-121.84804, 39.72817], [-121.84803, 39.72807], [-121.84809, 39.72795], [-121.84797, 39.72791], [-121.84809, 39.72764], [-121.84834, 39.72746], [-121.84855, 39.72742], [-121.84872, 39.72736], [-121.84919, 39.72713], [-121.84954, 39.72687], [-121.84986, 39.72666], [-121.85008, 39.72685]]], [[[-121.8512, 39.72593], [-121.85116, 39.72596], [-121.85119, 39.72599], [-121.8503, 39.72669], [-121.85018, 39.72659], [-121.8504, 39.72642], [-121.85079, 39.72605], [-121.85108, 39.72583], [-121.8512, 39.72593]]], [[[-121.86328, 39.72721], [-121.86263, 39.72725], [-121.8612, 39.72719], [-121.86002, 39.72711], [-121.85943, 39.72703], [-121.85906, 39.72692], [-121.85858, 39.72666], [-121.85839, 39.7266], [-121.85768, 39.7262], [-121.85723, 39.72585], [-121.85702, 39.7254], [-121.85697, 39.72523], [-121.85686, 39.72523], [-121.8561, 39.72558], [-121.85451, 39.72559], [-121.85403, 39.72573], [-121.85311, 39.72573], [-121.85237, 39.72569], [-121.85169, 39.72575], [-121.85138, 39.72585], [-121.85126, 39.7257], [-121.85142, 39.72564], [-121.85167, 39.72557], [-121.85199, 39.72557], [-121.85202, 39.72548], [-121.85209, 39.72541], [-121.85218, 39.72536], [-121.8523, 39.72534], [-121.85254, 39.72537], [-121.85272, 39.72543], [-121.85293, 39.72553], [-121.85326, 39.72561], [-121.85353, 39.72565], [-121.85371, 39.72566], [-121.85381, 39.72565], [-121.85429, 39.7255], [-121.85471, 39.72544], [-121.85547, 39.7254], [-121.85597, 39.72543], [-121.85597, 39.72537], [-121.85619, 39.72535], [-121.85641, 39.72522], [-121.8565, 39.72518], [-121.85661, 39.72506], [-121.85683, 39.72489], [-121.8569, 39.72487], [-121.85698, 39.72487], [-121.85711, 39.72494], [-121.85721, 39.72502], [-121.85724, 39.72507], [-121.85724, 39.7251], [-121.85727, 39.72514], [-121.85723, 39.72537], [-121.85725, 39.72547], [-121.85729, 39.7256], [-121.85738, 39.72571], [-121.85741, 39.72581], [-121.85746, 39.72584], [-121.85761, 39.72598], [-121.85777, 39.72606], [-121.85814, 39.72618], [-121.8583, 39.72625], [-121.85865, 39.7266], [-121.85876, 39.72669], [-121.85887, 39.72676], [-121.85899, 39.72679], [-121.85929, 39.72684], [-121.85967, 39.72699], [-121.85978, 39.72701], [-121.8607, 39.72698], [-121.86125, 39.72705], [-121.86152, 39.72709], [-121.8623, 39.72711], [-121.86296, 39.72709], [-121.86325, 39.72706], [-121.86328, 39.72721]]], [[[-121.88182, 39.72846], [-121.88181, 39.72884], [-121.88173, 39.72876], [-121.881, 39.72855], [-121.88033, 39.7281], [-121.87939, 39.72783], [-121.87927, 39.72773], [-121.87885, 39.72768], [-121.87833, 39.72773], [-121.87807, 39.72762], [-121.87754, 39.72657], [-121.87719, 39.72646], [-121.87653, 39.72635], [-121.87582, 39.72599], [-121.87462, 39.72552], [-121.87396, 39.72505], [-121.87318, 39.72512], [-121.87248, 39.72505], [-121.87209, 39.72507], [-121.87158, 39.72511], [-121.87086, 39.72494], [-121.87042, 39.72497], [-121.86931, 39.72491], [-121.8688, 39.72496], [-121.86836, 39.72481], [-121.86786, 39.72441], [-121.86763, 39.72442], [-121.86694, 39.72482], [-121.86674, 39.72503], [-121.86566, 39.72545], [-121.86534, 39.7259], [-121.86486, 39.72674], [-121.8647, 39.72681], [-121.86355, 39.72717], [-121.86353, 39.72705], [-121.86366, 39.72704], [-121.86424, 39.72678], [-121.86473, 39.72666], [-121.86483, 39.72657], [-121.86512, 39.72589], [-121.8653, 39.72573], [-121.86558, 39.7253], [-121.86592, 39.72526], [-121.86679, 39.72487], [-121.86725, 39.72445], [-121.86755, 39.72432], [-121.86794, 39.7243], [-121.86842, 39.72471], [-121.86888, 39.72485], [-121.86933, 39.72479], [-121.87007, 39.72482], [-121.87043, 39.72486], [-121.87059, 39.72485], [-121.87108, 39.72475], [-121.8717, 39.72495], [-121.8727, 39.72489], [-121.87293, 39.72492], [-121.87324, 39.72501], [-121.87334, 39.725], [-121.87345, 39.72494], [-121.87383, 39.72484], [-121.87393, 39.72482], [-121.87402, 39.72483], [-121.87417, 39.72495], [-121.87425, 39.72497], [-121.87444, 39.72511], [-121.87462, 39.72521], [-121.87531, 39.72551], [-121.87658, 39.72618], [-121.87676, 39.72623], [-121.877, 39.72624], [-121.87734, 39.72622], [-121.87745, 39.72624], [-121.87752, 39.72628], [-121.87763, 39.7264], [-121.8777, 39.7265], [-121.87776, 39.72665], [-121.8778, 39.72684], [-121.87786, 39.72691], [-121.87798, 39.72694], [-121.87843, 39.72696], [-121.87864, 39.72699], [-121.87871, 39.72704], [-121.87876, 39.72718], [-121.87878, 39.72721], [-121.87892, 39.72736], [-121.87907, 39.72746], [-121.87933, 39.72753], [-121.87953, 39.72761], [-121.87962, 39.72768], [-121.87983, 39.72777], [-121.88016, 39.72782], [-121.8804, 39.72781], [-121.88053, 39.72783], [-121.88074, 39.72795], [-121.88104, 39.72818], [-121.88134, 39.72839], [-121.88165, 39.72846], [-121.88182, 39.72846]]]]} | No Public Access 3 | 45025 | Big Chico Creek Greenway | 28979 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 23.271 | Big Chico Creek Greenway | 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]);