units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by MNG_AG_TYP
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Consumnes Community Services District 94
- The Nature Conservancy 51
- Yuba County Water Agency 50
- National Audubon Society 32
- Woodbridge Village Association 31
- Mountains Restoration Trust 30
- Fresno Metropolitan Flood Control District 29
- Las Virgenes Municipal Water District 28
- Rivers and Lands Conservancy 28
- Peninsula Open Space Trust 27
- Home Owners Association - Unknown Name 27
- Center for Natural Lands Management 25
- Sonoma Land Trust 25
- El Dorado Hills Community Service District 25
- The Wildlands Conservancy 24
- Truckee Donner Land Trust 24
- Los Angeles County Flood Control District 23
- Olivehurst Public Utility District 23
- Natomas Basin Conservancy 22
- Santa Barbara Flood Control and Water Conserv. District 21
- Big Sur Land Trust 21
- The Environmental Trust 21
- American River Conservancy 20
- San Diego Unified Port District 19
- Save the Redwoods League 18
- Land Trust of Napa County 18
- Sempervirens Fund 18
- Rancho Santa Margarita Landscape and Recreation Corporation 18
- East Bay Municipal Utility District 17
- Save Mount Diablo 17
- …
DES_TP >30
- Private Conservation 629
- Local Park 303
- Private Recreation or Education 268
- Local Recreation Area 143
- Local Other or Unknown 123
- Local Historic or Cultural Area 55
- Private Other or Unknown 51
- Local Conservation Area 19
- Private Agricultural 12
- Local Resource Management Area 8
- National Monument or Landmark 6
- Private Historic or Cultural 4
- National Wildlife Refuge 2
- State Conservation Area 1
- State Park 1
- None 1
- State Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- State Other or Unknown 1
- None 1
- State Historic or Cultural Area 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 27
- Non Profit - Land Trust 601
- Water District 238
- Home Owners Association 203
- Community Services District 198
- Non Profit - Conservation 148
- Flood District 108
- Cemetery District 62
- Irrigation District 50
- Non Profit - Other 45
- School District 38
- Port/Harbor District 33
- County Agency - Other 15
- Commercial 15
- Special District - Other 15
- Sanitation District 9
- Joint Powers Authority 9
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- Airport District 1
- Utility 1
- Home Owners Associatin 1
- Fire District 1
ACCESS_TYP 4
- Open Access 810
- Restricted Access 459
- No Public Access 418
- Unknown Access 134
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7096 | 7096 | 7095 | {"type": "MultiPolygon", "coordinates": [[[[-118.45649, 33.96106], [-118.4539, 33.96225], [-118.45386, 33.96218], [-118.45387, 33.96216], [-118.45341, 33.96151], [-118.45334, 33.96153], [-118.45045, 33.95737], [-118.45047, 33.95734], [-118.44895, 33.95484], [-118.449, 33.9548], [-118.44838, 33.95368], [-118.44808, 33.9538], [-118.44804, 33.95374], [-118.448, 33.95375], [-118.44754, 33.95303], [-118.44749, 33.95304], [-118.44736, 33.95271], [-118.44722, 33.95244], [-118.44704, 33.95251], [-118.44289, 33.9455], [-118.44281, 33.94549], [-118.44162, 33.94339], [-118.43925, 33.93909], [-118.43838, 33.93743], [-118.43516, 33.931], [-118.4348, 33.93032], [-118.43426, 33.92916], [-118.43381, 33.92809], [-118.42773, 33.91632], [-118.42962, 33.91633], [-118.42973, 33.91659], [-118.42999, 33.91685], [-118.43044, 33.91711], [-118.4313, 33.91921], [-118.43228, 33.92105], [-118.43304, 33.9221], [-118.43452, 33.92501], [-118.43532, 33.92696], [-118.43556, 33.92749], [-118.43596, 33.92826], [-118.43648, 33.92933], [-118.43669, 33.92984], [-118.43695, 33.93038], [-118.4377, 33.93169], [-118.43814, 33.93271], [-118.43825, 33.93303], [-118.43856, 33.9337], [-118.43878, 33.93406], [-118.43935, 33.93521], [-118.43954, 33.93568], [-118.43975, 33.9361], [-118.4402, 33.93693], [-118.44039, 33.93724], [-118.44084, 33.93823], [-118.44155, 33.9395], [-118.44195, 33.94017], [-118.44217, 33.94043], [-118.44232, 33.94051], [-118.44263, 33.94044], [-118.44296, 33.94034], [-118.44308, 33.94069], [-118.4432, 33.9409], [-118.44334, 33.94121], [-118.44367, 33.9417], [-118.44376, 33.94192], [-118.44381, 33.94211], [-118.44396, 33.94242], [-118.44416, 33.94266], [-118.44456, 33.94334], [-118.44541, 33.94489], [-118.44554, 33.94511], [-118.4458, 33.94546], [-118.44669, 33.947], [-118.44707, 33.94754], [-118.44738, 33.94819], [-118.44801, 33.94931], [-118.44839, 33.94989], [-118.44869, 33.95022], [-118.44873, 33.95065], [-118.44883, 33.95089], [-118.44923, 33.9516], [-118.44935, 33.95184], [-118.45076, 33.95404], [-118.451, 33.95433], [-118.45164, 33.95539], [-118.45195, 33.95585], [-118.4524, 33.95642], [-118.4523, 33.95654], [-118.45272, 33.9573], [-118.4533, 33.95802], [-118.45372, 33.95875], [-118.4544, 33.95934], [-118.4548, 33.95974], [-118.45514, 33.95998], [-118.45547, 33.9603], [-118.45582, 33.96055], [-118.45613, 33.96073], [-118.45649, 33.96106]]], [[[-118.45189, 33.95952], [-118.45155, 33.95965], [-118.45148, 33.95971], [-118.45127, 33.95915], [-118.45156, 33.95904], [-118.45189, 33.95952]]]]} | Open Access 1 | 6136 | Dockweiler State Beach | 30635 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 378 | Los Angeles County Department of Beaches and Harbors, County of 827 | County 3 | County Agency - Other 8 | http://www.parks.ca.gov/?page_id=617 | Los Angeles 6 | 279.238 | Dockweiler SB | 1948 | None 580 | |
7296 | 7296 | 7295 | {"type": "MultiPolygon", "coordinates": [[[[-118.09001, 33.80323], [-118.08973, 33.80323], [-118.08972, 33.80318], [-118.08943, 33.79703], [-118.0896, 33.79703], [-118.08976, 33.79762], [-118.09001, 33.80323]]], [[[-118.09035, 33.80941], [-118.09002, 33.8094], [-118.08982, 33.80517], [-118.09014, 33.80517], [-118.09035, 33.80941]]], [[[-118.09387, 33.78866], [-118.09152, 33.79346], [-118.09152, 33.79349], [-118.09142, 33.79369], [-118.09128, 33.7941], [-118.09112, 33.79469], [-118.09104, 33.7952], [-118.09101, 33.79591], [-118.0914, 33.80399], [-118.09119, 33.80398], [-118.09108, 33.80402], [-118.09108, 33.80406], [-118.09077, 33.80406], [-118.09035, 33.79591], [-118.09068, 33.7959], [-118.09069, 33.79548], [-118.09072, 33.79515], [-118.09082, 33.79456], [-118.0909, 33.79422], [-118.091, 33.79389], [-118.09124, 33.79331], [-118.09351, 33.78865], [-118.09387, 33.78866]]], [[[-118.09172, 33.81023], [-118.09119, 33.81024], [-118.09091, 33.80678], [-118.09078, 33.80436], [-118.09109, 33.80437], [-118.0911, 33.8044], [-118.09119, 33.80445], [-118.09143, 33.80444], [-118.09172, 33.81023]]]]} | Open Access 1 | 6580 | San Gabriel River Trail | 29917 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | Los Angeles 6 | 36.911 | San Gabriel River Trail | 0 | Local Recreation Area 3 | 4 | |
7784 | 7784 | 7783 | {"type": "Polygon", "coordinates": [[[-122.09793, 38.0339], [-122.09769, 38.03914], [-122.09158, 38.04066], [-122.09096, 38.03986], [-122.08905, 38.03774], [-122.08812, 38.03657], [-122.08732, 38.03561], [-122.08642, 38.03459], [-122.08564, 38.03378], [-122.08448, 38.0328], [-122.08348, 38.03204], [-122.08255, 38.03143], [-122.09011, 38.02928], [-122.09118, 38.03176], [-122.09429, 38.0309], [-122.09428, 38.03188], [-122.09338, 38.03401], [-122.09417, 38.03471], [-122.09447, 38.03495], [-122.09577, 38.03467], [-122.09706, 38.03377], [-122.09793, 38.0339]]]} | Restricted Access 2 | 8772 | Point Edith Wetlands | 23847 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 211.368 | Point Edith Wetlands | 2001 | Local Conservation Area 4 | 2 | |
9091 | 9091 | 9090 | {"type": "Polygon", "coordinates": [[[-122.21997, 38.05377], [-122.21956, 38.05348], [-122.21836, 38.05306], [-122.21781, 38.05289], [-122.21792, 38.05262], [-122.2194, 38.05234], [-122.21949, 38.05202], [-122.21938, 38.05173], [-122.21992, 38.05179], [-122.21998, 38.05209], [-122.22007, 38.05311], [-122.22003, 38.05357], [-122.21997, 38.05377]]]} | Open Access 1 | 15057 | Crockett | 17826 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 5.153 | Crockett | None 753 | |||
11149 | 11149 | 11148 | {"type": "Polygon", "coordinates": [[[-118.74257, 34.03285], [-118.74156, 34.03296], [-118.73843, 34.03315], [-118.73603, 34.03334], [-118.73257, 34.03315], [-118.73256, 34.03316], [-118.73223, 34.0332], [-118.7308, 34.03308], [-118.72999, 34.033], [-118.73003, 34.03274], [-118.72998, 34.03271], [-118.72974, 34.03268], [-118.72822, 34.03245], [-118.72662, 34.03222], [-118.72427, 34.03197], [-118.72278, 34.03177], [-118.7223, 34.03172], [-118.7215, 34.03167], [-118.72061, 34.03152], [-118.71938, 34.03135], [-118.71848, 34.0314], [-118.71785, 34.03146], [-118.71648, 34.03156], [-118.71599, 34.03156], [-118.71554, 34.03158], [-118.71503, 34.03154], [-118.71434, 34.03147], [-118.71321, 34.03118], [-118.71225, 34.03096], [-118.71116, 34.03074], [-118.7102, 34.03048], [-118.7093, 34.03026], [-118.70891, 34.03019], [-118.70841, 34.03002], [-118.70794, 34.02989], [-118.70726, 34.02975], [-118.70682, 34.02968], [-118.70661, 34.02967], [-118.70651, 34.02923], [-118.70685, 34.02927], [-118.70751, 34.02941], [-118.70787, 34.02954], [-118.70806, 34.02966], [-118.70854, 34.02981], [-118.70941, 34.03004], [-118.70977, 34.03009], [-118.71028, 34.03011], [-118.71096, 34.03028], [-118.7112, 34.03038], [-118.7117, 34.0305], [-118.71225, 34.03059], [-118.7125, 34.03066], [-118.71291, 34.03088], [-118.71325, 34.03102], [-118.71349, 34.03114], [-118.71434, 34.03135], [-118.71464, 34.03139], [-118.71488, 34.03138], [-118.71514, 34.03142], [-118.71541, 34.03136], [-118.71581, 34.03141], [-118.7162, 34.03143], [-118.71653, 34.03138], [-118.71692, 34.03138], [-118.71766, 34.03127], [-118.71866, 34.03109], [-118.71905, 34.03098], [-118.71935, 34.03093], [-118.71968, 34.03097], [-118.71994, 34.03107], [-118.7203, 34.03111], [-118.7224, 34.03144], [-118.72307, 34.03166], [-118.72372, 34.03175], [-118.72519, 34.03187], [-118.72521, 34.03182], [-118.72546, 34.03187], [-118.7275, 34.03214], [-118.72806, 34.03228], [-118.72847, 34.03231], [-118.72882, 34.03239], [-118.73039, 34.0325], [-118.73173, 34.03267], [-118.73322, 34.03281], [-118.73401, 34.03287], [-118.73542, 34.03301], [-118.7359, 34.03304], [-118.73608, 34.03301], [-118.73625, 34.033], [-118.73651, 34.03307], [-118.737, 34.03305], [-118.73735, 34.03309], [-118.73764, 34.0331], [-118.73798, 34.03308], [-118.73897, 34.03295], [-118.73966, 34.03291], [-118.74017, 34.03286], [-118.74111, 34.03282], [-118.74171, 34.03275], [-118.74224, 34.03264], [-118.74252, 34.03255], [-118.74257, 34.03285]]]} | Open Access 1 | 47988 | Puerco Beach | 32408 | 378 | Los Angeles County Department of Beaches and Harbors, County of 966 | County 3 | County Agency - Other 9 | http://dpw.lacounty.gov/dbh/ | County 3 | 378 | Los Angeles County Department of Beaches and Harbors, County of 827 | County 3 | County Agency - Other 8 | Los Angeles 6 | 24.244 | Puerco Beach | 0 | Local Park 2 | 4 | |
11443 | 11443 | 11442 | {"type": "MultiPolygon", "coordinates": [[[[-121.94454, 37.59589], [-121.9445, 37.5966], [-121.93814, 37.59689], [-121.93805, 37.59691], [-121.93803, 37.59707], [-121.93759, 37.59703], [-121.93756, 37.59685], [-121.93765, 37.59503], [-121.9375, 37.59448], [-121.93727, 37.59404], [-121.93713, 37.59343], [-121.93704, 37.59338], [-121.93704, 37.59322], [-121.93638, 37.59218], [-121.93598, 37.59189], [-121.93532, 37.59164], [-121.93475, 37.59162], [-121.93417, 37.59175], [-121.9335, 37.59209], [-121.93247, 37.59285], [-121.93129, 37.59484], [-121.92813, 37.5967], [-121.92649, 37.59793], [-121.92556, 37.59832], [-121.92507, 37.59842], [-121.92386, 37.59841], [-121.92295, 37.59823], [-121.92171, 37.59775], [-121.92047, 37.59709], [-121.91785, 37.59507], [-121.91651, 37.59391], [-121.91529, 37.59344], [-121.91377, 37.59308], [-121.9117, 37.593], [-121.91096, 37.59321], [-121.90743, 37.59454], [-121.90541, 37.59502], [-121.9041, 37.59509], [-121.90379, 37.59498], [-121.9025, 37.59479], [-121.90243, 37.5947], [-121.89927, 37.59391], [-121.89615, 37.59332], [-121.89377, 37.59299], [-121.89169, 37.59278], [-121.88985, 37.5927], [-121.88751, 37.59265], [-121.88603, 37.59248], [-121.88454, 37.59259], [-121.88357, 37.5945], [-121.88357, 37.59451], [-121.8838, 37.59455], [-121.88415, 37.59487], [-121.88431, 37.5952], [-121.88422, 37.59584], [-121.8838, 37.59632], [-121.88324, 37.59679], [-121.88106, 37.5982], [-121.87861, 37.5989], [-121.87608, 37.59934], [-121.87581, 37.59943], [-121.87526, 37.59963], [-121.87493, 37.59997], [-121.87465, 37.60046], [-121.87458, 37.60089], [-121.87403, 37.60137], [-121.87424, 37.60596], [-121.87601, 37.60632], [-121.87797, 37.60915], [-121.87819, 37.61072], [-121.87926, 37.61261], [-121.8793, 37.61288], [-121.88058, 37.61696], [-121.88223, 37.62116], [-121.88225, 37.62415], [-121.88319, 37.62619], [-121.88229, 37.62637], [-121.8819, 37.62639], [-121.88065, 37.62668], [-121.87351, 37.60837], [-121.87332, 37.60844], [-121.84693, 37.60243], [-121.84797, 37.60206], [-121.84833, 37.60157], [-121.84883, 37.60066], [-121.84904, 37.60049], [-121.84936, 37.60021], [-121.85073, 37.59936], [-121.8516, 37.5987], [-121.8527, 37.59814], [-121.85374, 37.59783], [-121.85501, 37.59773], [-121.85521, 37.59424], [-121.84563, 37.59215], [-121.84468, 37.58728], [-121.8384, 37.58725], [-121.83811, 37.58273], [-121.83739, 37.58308], [-121.83619, 37.58377], [-121.83348, 37.58497], [-121.82973, 37.58706], [-121.82743, 37.58894], [-121.82469, 37.5913], [-121.82157, 37.59432], [-121.81939, 37.59664], [-121.81939, 37.60076], [-121.80555, 37.60081], [-121.80554, 37.59818], [-121.7862, 37.59816], [-121.78118, 37.60198], [-121.7783, 37.60025], [-121.77841, 37.59127], [-121.77808, 37.59126], [-121.77702, 37.59019], [-121.77666, 37.58996], [-121.76516, 37.59044], [-121.76521, 37.5822], [-121.75297, 37.58206], [-121.75305, 37.57885], [-121.75304, 37.57884], [-121.73468, 37.57873], [-121.72581, 37.5787], [-121.72591, 37.57156], [-121.71649, 37.57154], [-121.71651, 37.5642], [-121.73482, 37.5642], [-121.74385, 37.56409], [-121.75314, 37.56408], [-121.7713, 37.56422], [-121.78771, 37.56431], [-121.78805, 37.55397], [-121.79753, 37.55397], [-121.79756, 37.55702], [-121.80108, 37.55707], [-121.80111, 37.56421], [-121.80659, 37.56424], [-121.83004, 37.5643], [-121.83002, 37.56079], [-121.83412, 37.56075], [-121.83379, 37.54986], [-121.84302, 37.54992], [-121.84321, 37.53688], [-121.84359, 37.53692], [-121.84373, 37.53692], [-121.84384, 37.53694], [-121.84415, 37.53703], [-121.84434, 37.53704], [-121.84444, 37.53701], [-121.84463, 37.53699], [-121.84522, 37.53709], [-121.84552, 37.53705], [-121.84582, 37.53694], [-121.84617, 37.53694], [-121.84646, 37.53688], [-121.84684, 37.53674], [-121.84716, 37.53648], [-121.84735, 37.53629], [-121.84772, 37.53609], [-121.84796, 37.53606], [-121.84833, 37.53615], [-121.84871, 37.53615], [-121.8493, 37.53591], [-121.84978, 37.53595], [-121.85, 37.53589], [-121.85023, 37.5359], [-121.85049, 37.53588], [-121.85089, 37.53583], [-121.85142, 37.53574], [-121.85196, 37.53559], [-121.85226, 37.53555], [-121.85263, 37.53557], [-121.8528, 37.53564], [-121.85303, 37.53568], [-121.85303, 37.53566], [-121.85287, 37.53547], [-121.85267, 37.53514], [-121.85237, 37.5348], [-121.85191, 37.53405], [-121.85171, 37.53351], [-121.85168, 37.5327], [-121.85203, 37.53169], [-121.85209, 37.5316], [-121.85212, 37.53149], [-121.85263, 37.5307], [-121.85277, 37.53054], [-121.85276, 37.53032], [-121.85271, 37.53019], [-121.85304, 37.53025], [-121.85308, 37.53044], [-121.85356, 37.53043], [-121.85474, 37.53091], [-121.85545, 37.53365], [-121.85593, 37.53399], [-121.85602, 37.53431], [-121.85607, 37.53469], [-121.85699, 37.53534], [-121.85796, 37.5364], [-121.85795, 37.53698], [-121.85706, 37.53799], [-121.85711, 37.53827], [-121.85743, 37.53873], [-121.85775, 37.5391], [-121.85784, 37.53962], [-121.85776, 37.53985], [-121.85748, 37.54004], [-121.8583, 37.54118], [-121.86353, 37.54128], [-121.86876, 37.54132], [-121.86872, 37.54202], [-121.86881, 37.54203], [-121.86853, 37.54853], [-121.87777, 37.5487], [-121.87772, 37.55591], [-121.88367, 37.56239], [-121.88792, 37.56245], [-121.88737, 37.5628], [-121.88555, 37.56433], [-121.88473, 37.56514], [-121.88422, 37.56581], [-121.88383, 37.56677], [-121.88363, 37.56767], [-121.88289, 37.56655], [-121.87588, 37.56873], [-121.87359, 37.56389], [-121.87433, 37.56394], [-121.87434, 37.56392], [-121.87182, 37.55949], [-121.87054, 37.55965], [-121.86967, 37.55838], [-121.86646, 37.55893], [-121.86683, 37.55955], [-121.86737, 37.56007], [-121.86796, 37.56061], [-121.86822, 37.56105], [-121.86838, 37.56164], [-121.86852, 37.56205], [-121.86902, 37.56287], [-121.86932, 37.56316], [-121.86983, 37.56407], [-121.86994, 37.56438], [-121.87011, 37.56499], [-121.87052, 37.56575], [-121.87163, 37.56752], [-121.87212, 37.56842], [-121.87268, 37.56936], [-121.87334, 37.57057], [-121.87385, 37.5716], [-121.8742, 37.57256], [-121.87457, 37.57364], [-121.87464, 37.57422], [-121.87466, 37.57468], [-121.87446, 37.57505], [-121.87432, 37.57549], [-121.87432, 37.57589], [-121.87451, 37.57632], [-121.87488, 37.57667], [-121.87523, 37.57686], [-121.87572, 37.57725], [-121.87623, 37.57774], [-121.87727, 37.57843], [-121.87827, 37.57765], [-121.87945, 37.57681], [-121.88062, 37.57626], [-121.88185, 37.57589], [-121.88547, 37.57537], [-121.88675, 37.57441], [-121.88784, 37.57368], [-121.89152, 37.57192], [-121.89421, 37.57061], [-121.89475, 37.57098], [-121.89846, 37.57472], [-121.89959, 37.5745], [-121.90226, 37.58205], [-121.90273, 37.58256], [-121.90382, 37.58353], [-121.90441, 37.58374], [-121.905, 37.5839], [-121.9055, 37.58398], [-121.90573, 37.58405], [-121.90595, 37.58408], [-121.90624, 37.58416], [-121.9064, 37.58417], [-121.90762, 37.58414], [-121.90808, 37.58424], [-121.90897, 37.58425], [-121.90915, 37.58423], [-121.91012, 37.58425], [-121.91119, 37.58414], [-121.9119, 37.58423], [-121.91202, 37.58427], [-121.91219, 37.58429], [-121.91256, 37.5843], [-121.91316, 37.58444], [-121.91329, 37.58454], [-121.91386, 37.58472], [-121.91427, 37.58614], [-121.91474, 37.58654], [-121.9225, 37.59049], [-121.9275, 37.58729], [-121.92784, 37.58575], [-121.92993, 37.58591], [-121.93276, 37.59108], [-121.93278, 37.59108], [-121.93276, 37.59073], [-121.93717, 37.59057], [-121.93766, 37.59076], [-121.93777, 37.59095], [-121.93838, 37.59124], [-121.93886, 37.59122], [-121.93897, 37.59126], [-121.93899, 37.59152], [-121.93939, 37.59171], [-121.93954, 37.5932], [-121.9395, 37.59431], [-121.94454, 37.59589]], [[-121.86961, 37.55723], [-121.86962, 37.55722], [-121.86724, 37.55421], [-121.86443, 37.55485], [-121.86549, 37.55604], [-121.86566, 37.55668], [-121.86615, 37.55767], [-121.86961, 37.55723]]], [[[-121.85097, 37.4845], [-121.85077, 37.48814], [-121.84666, 37.48816], [-121.84646, 37.49134], [-121.84263, 37.49125], [-121.84281, 37.49994], [-121.84289, 37.50646], [-121.83018, 37.50608], [-121.82899, 37.5048], [-121.82867, 37.50442], [-121.82791, 37.50396], [-121.82703, 37.50361], [-121.82642, 37.50342], [-121.82603, 37.50385], [-121.82564, 37.50399], [-121.82543, 37.50361], [-121.82524, 37.50319], [-121.82486, 37.50313], [-121.8222, 37.50333], [-121.82052, 37.5033], [-121.81987, 37.50434], [-121.81957, 37.50444], [-121.81978, 37.50496], [-121.81948, 37.50513], [-121.81907, 37.50437], [-121.81697, 37.5036], [-121.81576, 37.50409], [-121.81492, 37.50464], [-121.81415, 37.5054], [-121.81386, 37.50563], [-121.80686, 37.50544], [-121.79132, 37.50475], [-121.7734, 37.50472], [-121.75468, 37.50453], [-121.75463, 37.49994], [-121.75464, 37.49101], [-121.7732, 37.49074], [-121.77317, 37.48541], [-121.77316, 37.4854], [-121.77318, 37.48406], [-121.79079, 37.48417], [-121.79589, 37.48398], [-121.80073, 37.48399], [-121.82337, 37.48423], [-121.83148, 37.48424], [-121.83287, 37.48434], [-121.84627, 37.48444], [-121.85057, 37.48444], [-121.85097, 37.4845]]], [[[-121.86477, 37.49128], [-121.86466, 37.49523], [-121.8601, 37.49519], [-121.86005, 37.49904], [-121.85565, 37.49892], [-121.85582, 37.49136], [-121.85594, 37.48769], [-121.8603, 37.48777], [-121.86015, 37.49152], [-121.86477, 37.49128]]]]} | Restricted Access 2 | 23002 | San Francisco Watershed Lands | 24889 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | Alameda 17 | 19552.964 | San Francisco Watershed Lands | None 1015 | |||
11466 | 11466 | 11465 | {"type": "Polygon", "coordinates": [[[-122.28132, 37.9134], [-122.28121, 37.91335], [-122.28073, 37.91357], [-122.28038, 37.91363], [-122.28006, 37.91364], [-122.28059, 37.91414], [-122.28032, 37.91429], [-122.28033, 37.91433], [-122.28017, 37.91443], [-122.28013, 37.91447], [-122.28011, 37.91455], [-122.27999, 37.91464], [-122.27974, 37.91375], [-122.27977, 37.91354], [-122.27953, 37.91348], [-122.27932, 37.91337], [-122.27914, 37.9133], [-122.27894, 37.91332], [-122.27856, 37.91344], [-122.27849, 37.9134], [-122.27855, 37.91313], [-122.27855, 37.91292], [-122.28025, 37.91174], [-122.28106, 37.91239], [-122.2812, 37.91267], [-122.28074, 37.91276], [-122.28074, 37.91278], [-122.28092, 37.91335], [-122.28129, 37.91318], [-122.28132, 37.9134]]]} | Open Access 1 | 48178 | Kensington Park | 32713 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 8.459 | Kensington Park | 0 | Local Park 2 | 4 | |
12092 | 12092 | 12091 | {"type": "Polygon", "coordinates": [[[-122.02017, 37.86622], [-122.02016, 37.86639], [-122.01993, 37.86641], [-122.01969, 37.86648], [-122.01952, 37.86657], [-122.01934, 37.86672], [-122.0192, 37.86692], [-122.01905, 37.86733], [-122.01897, 37.86749], [-122.01882, 37.86767], [-122.01862, 37.86783], [-122.01852, 37.86783], [-122.01826, 37.8676], [-122.01798, 37.86742], [-122.01815, 37.86697], [-122.01795, 37.86683], [-122.0179, 37.86666], [-122.01792, 37.86629], [-122.01939, 37.86633], [-122.01944, 37.86632], [-122.0195, 37.86629], [-122.01953, 37.86625], [-122.01954, 37.8662], [-122.02017, 37.86622]]]} | Open Access 1 | 24911 | Livorna Park | 21386 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.387 | Livorna Park | 0 | Local Park 2 | 4 | |
12094 | 12094 | 12093 | {"type": "Polygon", "coordinates": [[[-121.95664, 38.0308], [-121.95557, 38.03164], [-121.95456, 38.03083], [-121.95562, 38.03], [-121.95664, 38.0308]]]} | Open Access 1 | 24917 | Lynbrook Park | 21606 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.143 | Lynbrook Park | 0 | Local Park 2 | 4 | |
12095 | 12095 | 12094 | {"type": "Polygon", "coordinates": [[[-122.2701, 38.03192], [-122.26926, 38.03205], [-122.2692, 38.03185], [-122.26868, 38.03192], [-122.26872, 38.03213], [-122.26707, 38.03237], [-122.26663, 38.03052], [-122.26966, 38.03007], [-122.2701, 38.03192]]]} | Open Access 1 | 24918 | Lefty Gomez Ballfield Complex | 21138 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 13.708 | Lefty Gomez Ballfield Complex | 0 | Local Recreation Area 3 | 4 | |
13163 | 13163 | 13162 | {"type": "Polygon", "coordinates": [[[-122.00274, 37.90517], [-122.00231, 37.90516], [-122.00213, 37.90513], [-122.00195, 37.90508], [-122.0017, 37.90499], [-121.99863, 37.90492], [-121.9986, 37.90475], [-121.99682, 37.90477], [-121.99628, 37.90372], [-121.994, 37.90374], [-121.99403, 37.90335], [-121.99401, 37.90309], [-121.99395, 37.90283], [-121.99387, 37.90259], [-121.99375, 37.90235], [-121.9936, 37.90213], [-121.99346, 37.90195], [-121.99811, 37.90237], [-121.99812, 37.90236], [-121.99811, 37.90229], [-122.00015, 37.90249], [-122.0002, 37.90249], [-122.0002, 37.90255], [-122.00096, 37.90262], [-122.00103, 37.90334], [-122.00094, 37.90336], [-122.00101, 37.90354], [-122.00107, 37.90407], [-122.00116, 37.90431], [-122.00123, 37.90442], [-122.00141, 37.90462], [-122.00151, 37.90471], [-122.00176, 37.90486], [-122.0019, 37.90492], [-122.00219, 37.905], [-122.00235, 37.90503], [-122.00268, 37.90503], [-122.00274, 37.90517]]]} | No Public Access 3 | 35113 | Mount Diablo Gateway | 28139 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 38.137 | Mount Diablo Gateway | None 1142 | |||
15389 | 15389 | 15388 | {"type": "Polygon", "coordinates": [[[-118.09413, 33.83158], [-118.09346, 33.83146], [-118.093, 33.82842], [-118.09369, 33.82863], [-118.09413, 33.83158]]]} | Open Access 1 | 46608 | San Gabriel River Trail | 29917 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | Los Angeles 6 | 5.002 | San Gabriel River Trail | 0 | Local Recreation Area 3 | 4 | |
15875 | 15875 | 15874 | {"type": "Polygon", "coordinates": [[[-122.32946, 38.00168], [-122.32842, 38.00225], [-122.32756, 38.00145], [-122.32721, 38.00108], [-122.32859, 38.00069], [-122.32946, 38.00168]]]} | Open Access 1 | 15091 | Montara Bay Community Center | 22384 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.396 | Montara Bay Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
16427 | 16427 | 16426 | {"type": "MultiPolygon", "coordinates": [[[[-118.55583, 34.03798], [-118.55572, 34.03834], [-118.55517, 34.03833], [-118.55476, 34.03835], [-118.55393, 34.03844], [-118.55365, 34.03853], [-118.55269, 34.0388], [-118.55086, 34.03926], [-118.55047, 34.03934], [-118.55001, 34.03938], [-118.54954, 34.03937], [-118.54848, 34.03928], [-118.54787, 34.03929], [-118.54788, 34.03919], [-118.54536, 34.03872], [-118.54392, 34.03887], [-118.54391, 34.03921], [-118.54177, 34.0386], [-118.54124, 34.03842], [-118.54064, 34.03816], [-118.53918, 34.03738], [-118.53794, 34.03677], [-118.53795, 34.03674], [-118.53598, 34.03579], [-118.53542, 34.03543], [-118.53468, 34.03487], [-118.5344, 34.0347], [-118.5341, 34.03456], [-118.52867, 34.03231], [-118.52815, 34.03215], [-118.52686, 34.03188], [-118.52656, 34.03176], [-118.52654, 34.03177], [-118.52486, 34.03107], [-118.52441, 34.03083], [-118.5219, 34.02944], [-118.52067, 34.02865], [-118.52039, 34.02851], [-118.51971, 34.02825], [-118.51943, 34.02808], [-118.51941, 34.028], [-118.51917, 34.02783], [-118.51907, 34.02783], [-118.51818, 34.02729], [-118.51707, 34.02675], [-118.51792, 34.02557], [-118.51861, 34.02602], [-118.51897, 34.02622], [-118.51932, 34.02639], [-118.51971, 34.02665], [-118.52001, 34.02686], [-118.52008, 34.02703], [-118.52009, 34.02722], [-118.52027, 34.02748], [-118.52039, 34.0275], [-118.52057, 34.02756], [-118.52113, 34.02756], [-118.52161, 34.02782], [-118.52185, 34.02803], [-118.52209, 34.02818], [-118.52234, 34.0284], [-118.52258, 34.02854], [-118.52283, 34.02862], [-118.52392, 34.02934], [-118.52482, 34.02988], [-118.52574, 34.0304], [-118.52621, 34.03076], [-118.52699, 34.03109], [-118.52718, 34.03109], [-118.52751, 34.03113], [-118.5281, 34.03131], [-118.52834, 34.03145], [-118.52868, 34.03169], [-118.52961, 34.03226], [-118.53042, 34.03258], [-118.53069, 34.03241], [-118.5309, 34.03248], [-118.5313, 34.03266], [-118.53192, 34.03299], [-118.53255, 34.03326], [-118.53291, 34.03344], [-118.53402, 34.03391], [-118.53482, 34.03431], [-118.53539, 34.03453], [-118.53588, 34.03479], [-118.53651, 34.035], [-118.53687, 34.03506], [-118.53715, 34.03518], [-118.53784, 34.03539], [-118.53811, 34.03551], [-118.53834, 34.0357], [-118.53857, 34.03584], [-118.53882, 34.03596], [-118.53909, 34.03605], [-118.53939, 34.03618], [-118.53973, 34.0363], [-118.54037, 34.03661], [-118.5409, 34.03697], [-118.54185, 34.03732], [-118.54249, 34.03762], [-118.54277, 34.03781], [-118.54308, 34.03797], [-118.54365, 34.03813], [-118.54399, 34.03819], [-118.5442, 34.03826], [-118.54444, 34.0383], [-118.54486, 34.03848], [-118.54487, 34.03852], [-118.5452, 34.03846], [-118.54588, 34.03865], [-118.54639, 34.03877], [-118.54736, 34.03894], [-118.54794, 34.03903], [-118.54881, 34.03909], [-118.54997, 34.0391], [-118.55042, 34.03906], [-118.55141, 34.03889], [-118.55269, 34.03862], [-118.55302, 34.03848], [-118.55385, 34.03797], [-118.55415, 34.03788], [-118.55472, 34.0378], [-118.55512, 34.03779], [-118.55568, 34.03785], [-118.55568, 34.03788], [-118.55583, 34.03798]]], [[[-118.56722, 34.04165], [-118.5663, 34.0415], [-118.56567, 34.04136], [-118.56518, 34.04127], [-118.56419, 34.04122], [-118.56383, 34.04116], [-118.56349, 34.04108], [-118.56299, 34.0409], [-118.56244, 34.0406], [-118.56207, 34.04043], [-118.56005, 34.03982], [-118.55953, 34.03964], [-118.55896, 34.03942], [-118.55764, 34.03883], [-118.55706, 34.03859], [-118.5564, 34.0384], [-118.55601, 34.03836], [-118.55601, 34.03826], [-118.55621, 34.03794], [-118.55636, 34.03797], [-118.55682, 34.0382], [-118.5576, 34.03848], [-118.55785, 34.03861], [-118.55814, 34.03869], [-118.55846, 34.03884], [-118.5589, 34.03899], [-118.55955, 34.03916], [-118.5601, 34.03938], [-118.5605, 34.03959], [-118.56097, 34.03979], [-118.56121, 34.03986], [-118.56173, 34.04004], [-118.56201, 34.04011], [-118.56227, 34.04024], [-118.56256, 34.04031], [-118.56281, 34.04041], [-118.56333, 34.04056], [-118.56392, 34.04065], [-118.5643, 34.0407], [-118.56541, 34.04096], [-118.56562, 34.04093], [-118.5668, 34.04117], [-118.56682, 34.04132], [-118.56714, 34.04138], [-118.56714, 34.04156], [-118.56722, 34.04165]]]]} | Open Access 1 | 5469 | Will Rogers State Beach | 30714 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 378 | Los Angeles County Department of Beaches and Harbors, County of 827 | County 3 | County Agency - Other 8 | http://www.parks.ca.gov/?page_id=625 | Los Angeles 6 | 90.632 | Will Rogers SB | 1931 | None 1400 | |
16457 | 16457 | 16456 | {"type": "MultiPolygon", "coordinates": [[[[-118.80898, 34.00167], [-118.80844, 34.00168], [-118.80836, 34.00194], [-118.80839, 34.00212], [-118.80832, 34.00218], [-118.8085, 34.00262], [-118.80779, 34.00333], [-118.80764, 34.00318], [-118.80753, 34.00313], [-118.80741, 34.00309], [-118.80721, 34.00309], [-118.80709, 34.00312], [-118.80699, 34.00317], [-118.8068, 34.00334], [-118.80494, 34.00517], [-118.80356, 34.0046], [-118.80388, 34.00424], [-118.8039, 34.00424], [-118.80434, 34.00367], [-118.80467, 34.00312], [-118.80476, 34.00286], [-118.80492, 34.00255], [-118.80497, 34.00249], [-118.80498, 34.00229], [-118.80497, 34.00221], [-118.8049, 34.0021], [-118.80488, 34.00191], [-118.80483, 34.00167], [-118.80481, 34.00149], [-118.80483, 34.00124], [-118.80486, 34.0011], [-118.80492, 34.00097], [-118.805, 34.0009], [-118.80511, 34.00052], [-118.80516, 34.00041], [-118.80533, 34.00029], [-118.80561, 34.00019], [-118.8058, 34.00015], [-118.80622, 34.00019], [-118.80646, 34.0001], [-118.8066, 34.00006], [-118.80683, 34.00012], [-118.80712, 34.00026], [-118.80747, 34.00048], [-118.80755, 34.00051], [-118.80783, 34.00078], [-118.80801, 34.00088], [-118.80854, 34.00135], [-118.80874, 34.00148], [-118.80898, 34.00167]]], [[[-118.81723, 34.01059], [-118.81678, 34.01091], [-118.81662, 34.01076], [-118.81653, 34.01093], [-118.8164, 34.01069], [-118.81631, 34.01073], [-118.81614, 34.01041], [-118.81637, 34.01031], [-118.81671, 34.01008], [-118.81723, 34.01059]]]]} | Open Access 1 | 8716 | Point Dume State Beach | 30686 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 378 | Los Angeles County Department of Beaches and Harbors, County of 827 | County 3 | County Agency - Other 8 | http://www.parks.ca.gov/?page_id=623 | Los Angeles 6 | 34.961 | Point Dume SB | 1958 | None 1405 | |
108 | 108 | 107 | {"type": "Polygon", "coordinates": [[[-119.80165, 34.44381], [-119.80106, 34.44387], [-119.79957, 34.44402], [-119.79959, 34.44377], [-119.80161, 34.44357], [-119.80165, 34.44381]]]} | Unknown Access 4 | 295 | San Antonio Creek | 24829 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 1.291 | San Antonio Creek | 0 | Local Other or Unknown 14 | 4 | |
172 | 172 | 171 | {"type": "Polygon", "coordinates": [[[-119.7122, 34.45864], [-119.71219, 34.45865], [-119.71206, 34.45871], [-119.71176, 34.45871], [-119.71175, 34.45848], [-119.71185, 34.45854], [-119.7122, 34.45864]]]} | Open Access 1 | 462 | Santa Barbara Botanic Gardens | 25037 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 0.145 | Santa Barbara Botanic Gardens | 0 | Local Park 2 | 4 | |
241 | 241 | 240 | {"type": "Polygon", "coordinates": [[[-120.19548, 34.61923], [-120.19532, 34.62017], [-120.19414, 34.61966], [-120.19453, 34.61897], [-120.19477, 34.61907], [-120.19504, 34.61915], [-120.19548, 34.61923]]]} | Open Access 1 | 785 | Buellton Park | 16483 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 2.399 | Buellton Park | 0 | Local Park 2 | 4 | |
928 | 928 | 927 | {"type": "MultiPolygon", "coordinates": [[[[-118.59921, 34.0992], [-118.59903, 34.09939], [-118.59861, 34.09959], [-118.59848, 34.0997], [-118.59839, 34.10003], [-118.59832, 34.10038], [-118.59776, 34.10077], [-118.59771, 34.10077], [-118.5977, 34.10064], [-118.59805, 34.10038], [-118.59816, 34.10024], [-118.59822, 34.10008], [-118.59827, 34.09982], [-118.59832, 34.09971], [-118.59838, 34.09965], [-118.59873, 34.09941], [-118.59894, 34.09917], [-118.59904, 34.09909], [-118.59921, 34.0992]]], [[[-118.60098, 34.097], [-118.60043, 34.09746], [-118.60002, 34.09794], [-118.59991, 34.09786], [-118.60007, 34.09761], [-118.60025, 34.09742], [-118.60077, 34.0971], [-118.60089, 34.09699], [-118.60096, 34.09691], [-118.60098, 34.097]]], [[[-118.60123, 34.09661], [-118.60104, 34.09701], [-118.60099, 34.09686], [-118.60102, 34.09679], [-118.60106, 34.0966], [-118.60103, 34.09619], [-118.60109, 34.09619], [-118.6011, 34.09645], [-118.60123, 34.09661]]]]} | Open Access 1 | 6426 | Topanga Creek | 26407 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 1.477 | Topanga Creek | 0 | Local Other or Unknown 14 | 4 | |
986 | 986 | 985 | {"type": "MultiPolygon", "coordinates": [[[[-118.07211, 33.98316], [-118.0721, 33.98317], [-118.07151, 33.98276], [-118.07152, 33.98275], [-118.07211, 33.98316]]], [[[-118.07278, 33.98341], [-118.07277, 33.98343], [-118.07221, 33.98304], [-118.07222, 33.98303], [-118.07278, 33.98341]]], [[[-118.07399, 33.98445], [-118.07398, 33.98447], [-118.07355, 33.98418], [-118.07356, 33.98416], [-118.07399, 33.98445]]]]} | Open Access 1 | 6696 | San Gabriel River & Bike Trail | 24897 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 0.082 | San Gabriel River & Bike Trail | 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]);