units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP >30
- City Agency 10,467
- County Agency 1,211
- Recreation/Parks District 1,155
- State Agency 1,134
- Non Profit - Land Trust 601
- Federal Agency 517
- Open Space District 428
- Water District 238
- County Agency - Parks 234
- Home Owners Association 203
- Community Services District 198
- Non Profit - Conservation 147
- Flood District 107
- Cemetery District 62
- Irrigation District 50
- Non Profit - Other 45
- School District 38
- County Agency - Other 35
- Port/Harbor District 30
- Commercial 15
- Special District - Other 15
- Sanitation District 9
- Joint Powers Authority 9
- Other 5
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
DES_TP >30
- Local Park 9,321
- Local Recreation Area 1,975
- Local Other or Unknown 1,189
- Private Conservation 629
- Local Conservation Area 480
- State Conservation Area 379
- Private Recreation or Education 267
- State Park 206
- State Resource Management Area 159
- State Recreation Area 145
- Local Historic or Cultural Area 115
- National Forest 99
- National Public Lands 75
- National Wildlife Refuge 75
- State Other or Unknown 70
- State Historic or Cultural Area 62
- Recreation Management Area 61
- Private Other or Unknown 51
- National Recreation Area 40
- National Monument or Landmark 39
- National Park 26
- Resource Management Area 26
- Local Resource Management Area 24
- Federal Other or Unknown 24
- Conservation Area 14
- Private Agricultural 12
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 14,431
- Restricted Access 1,199
- No Public Access 967
- Unknown Access 384
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15965 | 15965 | 15964 | {"type": "MultiPolygon", "coordinates": [[[[-117.06586, 32.80515], [-117.0658, 32.80532], [-117.06343, 32.80519], [-117.06325, 32.80547], [-117.06301, 32.80761], [-117.06336, 32.8082], [-117.06378, 32.80842], [-117.06404, 32.80838], [-117.06411, 32.80847], [-117.06393, 32.80853], [-117.06402, 32.8088], [-117.06447, 32.80976], [-117.06452, 32.80996], [-117.06437, 32.81087], [-117.06436, 32.81175], [-117.06431, 32.81197], [-117.06418, 32.8122], [-117.06408, 32.81213], [-117.06366, 32.81262], [-117.06351, 32.81309], [-117.06307, 32.81359], [-117.06266, 32.8139], [-117.06209, 32.81451], [-117.0618, 32.81439], [-117.06151, 32.81416], [-117.06085, 32.81369], [-117.06063, 32.81316], [-117.06025, 32.81191], [-117.06025, 32.81157], [-117.06002, 32.81126], [-117.05985, 32.81078], [-117.05986, 32.81033], [-117.05937, 32.81002], [-117.05873, 32.80993], [-117.05828, 32.81042], [-117.05848, 32.81087], [-117.05885, 32.81116], [-117.05923, 32.8122], [-117.05923, 32.81292], [-117.05865, 32.81321], [-117.05802, 32.81297], [-117.05714, 32.81297], [-117.05713, 32.81344], [-117.05537, 32.81343], [-117.05383, 32.81191], [-117.05519, 32.81109], [-117.05563, 32.81081], [-117.05563, 32.81072], [-117.05614, 32.8107], [-117.0562, 32.81078], [-117.05632, 32.81082], [-117.05656, 32.81096], [-117.05643, 32.8112], [-117.05723, 32.81156], [-117.05722, 32.80997], [-117.05739, 32.80997], [-117.05777, 32.80957], [-117.0577, 32.80943], [-117.05788, 32.80927], [-117.05802, 32.80899], [-117.05833, 32.80894], [-117.05874, 32.809], [-117.05909, 32.80913], [-117.05933, 32.80928], [-117.06093, 32.8098], [-117.06091, 32.80984], [-117.06093, 32.80991], [-117.06083, 32.81019], [-117.06135, 32.8109], [-117.06145, 32.81095], [-117.0617, 32.81149], [-117.06173, 32.81186], [-117.06196, 32.8122], [-117.06225, 32.81232], [-117.06231, 32.81226], [-117.06237, 32.81208], [-117.06233, 32.81192], [-117.06269, 32.81185], [-117.06284, 32.8116], [-117.06284, 32.81142], [-117.06277, 32.81094], [-117.06252, 32.8104], [-117.06236, 32.80984], [-117.0623, 32.80971], [-117.06234, 32.80927], [-117.062, 32.80922], [-117.06153, 32.8091], [-117.0613, 32.80908], [-117.06115, 32.80889], [-117.06118, 32.8086], [-117.06128, 32.80818], [-117.06143, 32.80817], [-117.06175, 32.80782], [-117.06162, 32.80749], [-117.06149, 32.8073], [-117.06136, 32.80726], [-117.06074, 32.80746], [-117.06058, 32.80726], [-117.06048, 32.80726], [-117.06044, 32.80775], [-117.06039, 32.80785], [-117.06038, 32.80802], [-117.06005, 32.80807], [-117.05985, 32.80804], [-117.05978, 32.80766], [-117.05971, 32.80757], [-117.05958, 32.8075], [-117.05944, 32.80736], [-117.05942, 32.80727], [-117.05914, 32.80713], [-117.05899, 32.80736], [-117.05905, 32.80743], [-117.05898, 32.8075], [-117.05898, 32.80758], [-117.05868, 32.80791], [-117.05845, 32.8079], [-117.05835, 32.80788], [-117.05834, 32.80779], [-117.05765, 32.80718], [-117.05753, 32.80727], [-117.0575, 32.80735], [-117.05752, 32.80763], [-117.05749, 32.80772], [-117.0575, 32.80778], [-117.05754, 32.80781], [-117.05752, 32.80794], [-117.05724, 32.80807], [-117.05728, 32.80732], [-117.05731, 32.80556], [-117.05734, 32.80518], [-117.05733, 32.80509], [-117.05736, 32.80415], [-117.05736, 32.80368], [-117.05771, 32.8038], [-117.05821, 32.80384], [-117.05862, 32.80401], [-117.05907, 32.80404], [-117.0596, 32.8039], [-117.06013, 32.80366], [-117.06022, 32.80366], [-117.06059, 32.80351], [-117.06072, 32.80337], [-117.06074, 32.80315], [-117.06054, 32.80293], [-117.06041, 32.80283], [-117.06023, 32.80279], [-117.05984, 32.80285], [-117.05965, 32.80297], [-117.05955, 32.80307], [-117.05938, 32.80319], [-117.05896, 32.80332], [-117.05883, 32.80331], [-117.05831, 32.80294], [-117.05814, 32.80286], [-117.05735, 32.80255], [-117.05733, 32.80233], [-117.05567, 32.80119], [-117.05553, 32.80109], [-117.05493, 32.80069], [-117.05453, 32.80046], [-117.05702, 32.80058], [-117.05749, 32.80057], [-117.05785, 32.80053], [-117.0583, 32.80046], [-117.05889, 32.80028], [-117.05924, 32.80015], [-117.06126, 32.79919], [-117.06172, 32.79894], [-117.06218, 32.79857], [-117.06392, 32.79693], [-117.0634, 32.79818], [-117.06288, 32.79959], [-117.06302, 32.79971], [-117.06268, 32.79998], [-117.06253, 32.80013], [-117.0624, 32.80038], [-117.06199, 32.80029], [-117.0612, 32.80098], [-117.06098, 32.80158], [-117.06126, 32.8021], [-117.06425, 32.80209], [-117.06383, 32.80252], [-117.06362, 32.80251], [-117.06349, 32.80244], [-117.06341, 32.80228], [-117.06304, 32.80243], [-117.06285, 32.80263], [-117.06258, 32.80321], [-117.06246, 32.80329], [-117.06228, 32.80372], [-117.06226, 32.80415], [-117.06253, 32.80443], [-117.06272, 32.80453], [-117.06333, 32.80443], [-117.06356, 32.80448], [-117.06374, 32.80461], [-117.06403, 32.80502], [-117.06427, 32.80512], [-117.06499, 32.8051], [-117.06515, 32.80513], [-117.06556, 32.80513], [-117.06586, 32.80515]]], [[[-117.07622, 32.8044], [-117.07569, 32.80481], [-117.07306, 32.8043], [-117.07303, 32.80447], [-117.07222, 32.80432], [-117.07198, 32.80434], [-117.07175, 32.80433], [-117.07085, 32.80441], [-117.07065, 32.80455], [-117.06991, 32.8047], [-117.06944, 32.80489], [-117.06889, 32.80523], [-117.06912, 32.80587], [-117.06796, 32.80632], [-117.0676, 32.80584], [-117.06731, 32.80619], [-117.06729, 32.80619], [-117.06693, 32.80615], [-117.06626, 32.80642], [-117.06627, 32.80687], [-117.06648, 32.80713], [-117.06621, 32.80732], [-117.06598, 32.8071], [-117.0659, 32.80698], [-117.06583, 32.80683], [-117.06579, 32.80667], [-117.0658, 32.80647], [-117.06586, 32.80624], [-117.0662, 32.80557], [-117.06626, 32.80543], [-117.06629, 32.80508], [-117.06673, 32.80493], [-117.06715, 32.80471], [-117.06768, 32.80457], [-117.06789, 32.80454], [-117.06801, 32.80443], [-117.06805, 32.80415], [-117.06812, 32.80383], [-117.06802, 32.80369], [-117.0678, 32.80368], [-117.06748, 32.80373], [-117.06739, 32.80365], [-117.06713, 32.80352], [-117.06667, 32.80342], [-117.06663, 32.80333], [-117.06675, 32.80319], [-117.06685, 32.80325], [-117.06683, 32.80317], [-117.06684, 32.80309], [-117.06687, 32.80307], [-117.06691, 32.80309], [-117.06699, 32.80298], [-117.06699, 32.80293], [-117.06702, 32.80294], [-117.0671, 32.80278], [-117.06721, 32.80266], [-117.06742, 32.80248], [-117.06731, 32.80208], [-117.06791, 32.80208], [-117.06868, 32.80211], [-117.06882, 32.80212], [-117.07038, 32.80269], [-117.07178, 32.80272], [-117.07291, 32.80324], [-117.07308, 32.80328], [-117.07329, 32.8033], [-117.07358, 32.80325], [-117.07366, 32.8035], [-117.0739, 32.80341], [-117.07425, 32.8032], [-117.07444, 32.80323], [-117.07447, 32.80356], [-117.07459, 32.80384], [-117.07481, 32.80407], [-117.07509, 32.80411], [-117.0756, 32.8043], [-117.07575, 32.80442], [-117.07603, 32.8043], [-117.07614, 32.80437], [-117.07622, 32.8044]]]]} | Open Access 1 | 103 | Rancho Mission Canyon Park and Open Space | 10506 | 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 | 236.791 | Rancho Mission Canyon Park and OS | 0 | Local Recreation Area 3 | 4 | |
45 | 45 | 44 | {"type": "Polygon", "coordinates": [[[-121.58017, 38.00647], [-121.57962, 38.00489], [-121.5792, 38.00424], [-121.57866, 38.00373], [-121.578, 38.00325], [-121.5773, 38.00297], [-121.5765, 38.00275], [-121.57532, 38.00267], [-121.57437, 38.00274], [-121.57366, 38.00284], [-121.57299, 38.00288], [-121.57271, 38.00292], [-121.57084, 38.00265], [-121.56985, 38.00228], [-121.56934, 38.002], [-121.56923, 38.00168], [-121.56976, 38.00083], [-121.57043, 38.0001], [-121.57105, 37.99959], [-121.57179, 37.99931], [-121.57271, 37.99929], [-121.57361, 37.99936], [-121.57459, 37.99948], [-121.57536, 37.99977], [-121.57739, 37.99957], [-121.57899, 37.99906], [-121.57922, 37.99895], [-121.57943, 37.99902], [-121.57968, 38.00053], [-121.57966, 38.0016], [-121.57979, 38.0027], [-121.5798, 38.00342], [-121.57997, 38.00413], [-121.58015, 38.00529], [-121.58017, 38.00647]]]} | Open Access 1 | 104 | Rhode Island Wildlife Area | 30492 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Rhode-Island-WA | Contra Costa 12 | 85.271 | Rhode Island Wildlife Area | 2002 | State Conservation Area 8 | 2 |
15966 | 15966 | 15965 | {"type": "MultiPolygon", "coordinates": [[[[-121.86007, 36.60626], [-121.86019, 36.60641], [-121.86027, 36.60654], [-121.86032, 36.6067], [-121.86035, 36.60687], [-121.86033, 36.60703], [-121.86029, 36.60718], [-121.86022, 36.60732], [-121.86011, 36.60747], [-121.86, 36.60758], [-121.85984, 36.60769], [-121.85775, 36.60886], [-121.85761, 36.60892], [-121.85741, 36.60896], [-121.85638, 36.60792], [-121.85936, 36.60601], [-121.85978, 36.60644], [-121.86007, 36.60626]]], [[[-121.85802, 36.60942], [-121.85791, 36.6095], [-121.85784, 36.6094], [-121.85755, 36.6091], [-121.85783, 36.60901], [-121.85794, 36.60922], [-121.85802, 36.60942]]]]} | Open Access 1 | 105 | Roberts Lake Open Space | 24492 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 14.46 | Roberts Lake OS | 0 | Local Recreation Area 3 | 4 | |
48 | 48 | 47 | {"type": "Polygon", "coordinates": [[[-121.13139, 37.46901], [-121.13089, 37.46894], [-121.13099, 37.46845], [-121.13139, 37.46901], [-121.13139, 37.46901]]]} | Open Access 1 | 106 | Del Puerto Park | 18048 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.306 | Del Puerto Park | 0 | Local Park 2 | 4 | |
49 | 49 | 48 | {"type": "Polygon", "coordinates": [[[-117.04877, 32.81115], [-117.04766, 32.81153], [-117.04656, 32.81065], [-117.04633, 32.81056], [-117.04656, 32.80996], [-117.04591, 32.8096], [-117.04518, 32.80917], [-117.0453, 32.80896], [-117.04544, 32.80897], [-117.04612, 32.8091], [-117.04679, 32.80933], [-117.04712, 32.80941], [-117.04749, 32.80943], [-117.04824, 32.80934], [-117.04829, 32.8096], [-117.0481, 32.80978], [-117.04786, 32.81015], [-117.04788, 32.81022], [-117.04852, 32.81057], [-117.04845, 32.81084], [-117.04877, 32.81115]]]} | Open Access 1 | 107 | Tuxedo Neighborhood Park | 30163 | 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 | 10.11 | Tuxedo Neighborhood Park | 0 | Local Park 2 | 4 | |
15960 | 15960 | 15959 | {"type": "Polygon", "coordinates": [[[-117.10471, 32.79491], [-117.10467, 32.7985], [-117.10274, 32.80185], [-117.10402, 32.80351], [-117.10409, 32.80363], [-117.10436, 32.804], [-117.10441, 32.80428], [-117.10442, 32.80441], [-117.10441, 32.80537], [-117.10314, 32.80531], [-117.10313, 32.80532], [-117.10315, 32.80708], [-117.10314, 32.80795], [-117.10315, 32.808], [-117.10316, 32.80919], [-117.10414, 32.8092], [-117.10422, 32.81113], [-117.10193, 32.8111], [-117.10205, 32.81505], [-117.10269, 32.81506], [-117.10279, 32.81714], [-117.10052, 32.8176], [-117.1004, 32.8161], [-117.09964, 32.81602], [-117.09967, 32.81585], [-117.09967, 32.81551], [-117.10033, 32.81554], [-117.10034, 32.81552], [-117.10008, 32.81241], [-117.09986, 32.81214], [-117.09951, 32.81205], [-117.09947, 32.81235], [-117.09933, 32.81238], [-117.09929, 32.81243], [-117.09927, 32.81248], [-117.0989, 32.8124], [-117.09902, 32.81279], [-117.0989, 32.81363], [-117.09867, 32.81405], [-117.09901, 32.81439], [-117.09904, 32.81455], [-117.09888, 32.81475], [-117.09861, 32.81483], [-117.0984, 32.81502], [-117.09811, 32.81519], [-117.09807, 32.81529], [-117.09819, 32.81547], [-117.09823, 32.81565], [-117.09819, 32.81581], [-117.098, 32.81609], [-117.09776, 32.81596], [-117.09756, 32.81618], [-117.09781, 32.81637], [-117.09765, 32.81648], [-117.09733, 32.81678], [-117.09727, 32.81716], [-117.09718, 32.81733], [-117.09708, 32.81747], [-117.0974, 32.81759], [-117.09738, 32.81764], [-117.09698, 32.81762], [-117.09693, 32.81824], [-117.09609, 32.81861], [-117.09582, 32.81836], [-117.09557, 32.81819], [-117.09553, 32.81823], [-117.0953, 32.81809], [-117.095, 32.81794], [-117.09719, 32.81421], [-117.09716, 32.81236], [-117.0968, 32.81233], [-117.09688, 32.81169], [-117.09695, 32.81154], [-117.09719, 32.81122], [-117.09711, 32.81086], [-117.09719, 32.8108], [-117.09723, 32.81065], [-117.09712, 32.81042], [-117.09693, 32.81029], [-117.09697, 32.81024], [-117.09708, 32.81021], [-117.09711, 32.81009], [-117.09723, 32.80997], [-117.09745, 32.81012], [-117.09765, 32.81009], [-117.09774, 32.80998], [-117.09785, 32.80988], [-117.09801, 32.80982], [-117.09802, 32.80965], [-117.09811, 32.80951], [-117.09831, 32.80938], [-117.09839, 32.80921], [-117.09837, 32.80903], [-117.09845, 32.80891], [-117.09856, 32.80883], [-117.09867, 32.80864], [-117.09894, 32.80844], [-117.09917, 32.80814], [-117.09926, 32.80797], [-117.09932, 32.80778], [-117.0994, 32.80739], [-117.09922, 32.80716], [-117.09883, 32.80704], [-117.09847, 32.80719], [-117.09835, 32.80747], [-117.0985, 32.80773], [-117.09838, 32.80784], [-117.09817, 32.80801], [-117.09802, 32.80809], [-117.09786, 32.80819], [-117.0977, 32.80833], [-117.09763, 32.8085], [-117.09744, 32.80865], [-117.09744, 32.80881], [-117.09748, 32.80896], [-117.09744, 32.80907], [-117.09734, 32.80918], [-117.09691, 32.80957], [-117.09686, 32.80971], [-117.09708, 32.80987], [-117.09697, 32.80999], [-117.09688, 32.81002], [-117.09683, 32.81005], [-117.0968, 32.81015], [-117.09652, 32.81044], [-117.09627, 32.81027], [-117.09615, 32.81041], [-117.09596, 32.81053], [-117.09583, 32.81071], [-117.09576, 32.8109], [-117.09558, 32.81097], [-117.09513, 32.81101], [-117.09538, 32.81172], [-117.09559, 32.81187], [-117.0951, 32.812], [-117.09479, 32.81191], [-117.09405, 32.81192], [-117.09354, 32.81197], [-117.09358, 32.81096], [-117.09529, 32.80942], [-117.09592, 32.80857], [-117.09796, 32.8068], [-117.10056, 32.80525], [-117.10023, 32.80248], [-117.09938, 32.80248], [-117.09919, 32.80155], [-117.09926, 32.79946], [-117.10095, 32.79737], [-117.10471, 32.79491]]]} | Open Access 1 | 110 | Tierrasanta Open Space | 10608 | 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 | 260.674 | Tierrasanta OS | 0 | Local Recreation Area 3 | 4 | |
3734 | 3734 | 3733 | {"type": "MultiPolygon", "coordinates": [[[[-122.31785, 37.90207], [-122.31749, 37.90263], [-122.3175, 37.90285], [-122.31661, 37.90177], [-122.31604, 37.90104], [-122.31593, 37.90086], [-122.31581, 37.90061], [-122.31574, 37.90032], [-122.31575, 37.90024], [-122.31577, 37.90016], [-122.31585, 37.90005], [-122.31596, 37.89998], [-122.31612, 37.89993], [-122.31785, 37.90207]]], [[[-122.31976, 37.90599], [-122.31923, 37.906], [-122.3171, 37.90343], [-122.31757, 37.90318], [-122.31802, 37.90409], [-122.31829, 37.90458], [-122.31976, 37.90599]]]]} | Restricted Access 2 | 113 | McLaughlin Eastshore State Park | 29198 | 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 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/eastshore | Contra Costa 12 | 7.835 | McLaughlin Eastshore SP | None 312 | ||
5811 | 5811 | 5810 | {"type": "Polygon", "coordinates": [[[-121.86002, 36.60779], [-121.85928, 36.6088], [-121.85829, 36.60932], [-121.85798, 36.6093], [-121.85783, 36.60901], [-121.86002, 36.60779]]]} | Open Access 1 | 114 | Roberts Lake Open Space | 24493 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 2.374 | Roberts Lake OS | 0 | Local Recreation Area 3 | 4 | |
5780 | 5780 | 5779 | {"type": "Polygon", "coordinates": [[[-121.15626, 37.46621], [-121.15624, 37.46686], [-121.1555, 37.46686], [-121.15551, 37.4662], [-121.15626, 37.46621]]]} | Open Access 1 | 115 | Early Gold Park | 18356 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.191 | Early Gold Park | 0 | Local Park 2 | 4 | |
50 | 50 | 49 | {"type": "MultiPolygon", "coordinates": [[[[-117.21301, 33.87552], [-117.21265, 33.8756], [-117.21258, 33.87543], [-117.21246, 33.87526], [-117.2123, 33.87511], [-117.21214, 33.87501], [-117.21187, 33.87491], [-117.21099, 33.87478], [-117.2109, 33.87468], [-117.21098, 33.87391], [-117.21278, 33.87393], [-117.21279, 33.8744], [-117.21285, 33.87488], [-117.21287, 33.87501], [-117.21289, 33.87505], [-117.21301, 33.87552]]], [[[-117.21735, 33.87448], [-117.21724, 33.87454], [-117.21542, 33.87452], [-117.21528, 33.87448], [-117.21519, 33.87448], [-117.21508, 33.87454], [-117.21502, 33.87462], [-117.21502, 33.87471], [-117.21505, 33.87477], [-117.21504, 33.87503], [-117.21332, 33.87502], [-117.21325, 33.87454], [-117.21324, 33.87428], [-117.21325, 33.87393], [-117.21469, 33.87393], [-117.2147, 33.87379], [-117.21734, 33.8738], [-117.21735, 33.87448]]]]} | Open Access 1 | 116 | El Potrero Park | 18530 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 14.762 | El Potrero Park | 0 | Local Park 2 | 4 | |
15967 | 15967 | 15966 | {"type": "MultiPolygon", "coordinates": [[[[-117.08618, 32.78287], [-117.08622, 32.78293], [-117.08624, 32.78303], [-117.08622, 32.78311], [-117.08617, 32.7832], [-117.08531, 32.78378], [-117.08524, 32.78389], [-117.0852, 32.78402], [-117.08519, 32.78416], [-117.08523, 32.78429], [-117.08533, 32.78443], [-117.08553, 32.78456], [-117.0856, 32.78469], [-117.08463, 32.78553], [-117.08436, 32.78592], [-117.0838, 32.78592], [-117.08272, 32.78658], [-117.08187, 32.78792], [-117.08286, 32.78773], [-117.08044, 32.79012], [-117.08043, 32.79016], [-117.08034, 32.79009], [-117.08058, 32.78985], [-117.0793, 32.78892], [-117.07776, 32.79006], [-117.07763, 32.79017], [-117.07667, 32.79085], [-117.07584, 32.79149], [-117.07542, 32.79293], [-117.07593, 32.79393], [-117.07626, 32.79416], [-117.07659, 32.79381], [-117.0766, 32.79377], [-117.07671, 32.79385], [-117.07667, 32.79385], [-117.07664, 32.79387], [-117.07561, 32.79498], [-117.07591, 32.79563], [-117.07546, 32.79607], [-117.07495, 32.7957], [-117.0747, 32.79596], [-117.07404, 32.79548], [-117.07362, 32.79414], [-117.07449, 32.79342], [-117.07448, 32.79295], [-117.07389, 32.79245], [-117.07286, 32.79331], [-117.0684, 32.79401], [-117.06839, 32.79409], [-117.06843, 32.79426], [-117.06836, 32.7943], [-117.06808, 32.79402], [-117.06769, 32.79358], [-117.0676, 32.79345], [-117.0676, 32.79336], [-117.06773, 32.79353], [-117.06781, 32.79355], [-117.06852, 32.79334], [-117.06922, 32.79322], [-117.07092, 32.79298], [-117.07154, 32.79284], [-117.07175, 32.79276], [-117.07203, 32.79268], [-117.07252, 32.79249], [-117.07267, 32.79241], [-117.07272, 32.79241], [-117.07334, 32.79207], [-117.07408, 32.79157], [-117.0754, 32.79057], [-117.07323, 32.78843], [-117.07149, 32.78856], [-117.07143, 32.7885], [-117.07022, 32.78771], [-117.06892, 32.78716], [-117.0687, 32.78701], [-117.06765, 32.78579], [-117.06757, 32.78526], [-117.06807, 32.78473], [-117.06822, 32.78539], [-117.06985, 32.78614], [-117.07023, 32.78641], [-117.07028, 32.78636], [-117.07052, 32.78646], [-117.0705, 32.78653], [-117.07139, 32.78694], [-117.07187, 32.78715], [-117.07191, 32.78709], [-117.07266, 32.78742], [-117.07402, 32.78704], [-117.07404, 32.78702], [-117.07405, 32.78729], [-117.07495, 32.78863], [-117.07732, 32.78821], [-117.07818, 32.78758], [-117.07746, 32.78678], [-117.07421, 32.78551], [-117.07432, 32.78501], [-117.07451, 32.78473], [-117.07458, 32.78465], [-117.07655, 32.78524], [-117.07826, 32.78523], [-117.07841, 32.78539], [-117.07853, 32.78555], [-117.07906, 32.78608], [-117.07925, 32.78623], [-117.0797, 32.78654], [-117.08013, 32.78577], [-117.08138, 32.78469], [-117.0837, 32.78401], [-117.08345, 32.78297], [-117.08294, 32.78299], [-117.08288, 32.78279], [-117.08293, 32.78263], [-117.08618, 32.78287]]], [[[-117.08637, 32.78311], [-117.08635, 32.78329], [-117.08601, 32.78377], [-117.08606, 32.7838], [-117.08569, 32.78433], [-117.08555, 32.78436], [-117.0855, 32.78433], [-117.08544, 32.78428], [-117.08538, 32.78415], [-117.08537, 32.78403], [-117.08542, 32.7839], [-117.08551, 32.78382], [-117.0856, 32.78377], [-117.08621, 32.78333], [-117.08632, 32.78321], [-117.08637, 32.78311]]]]} | Open Access 1 | 117 | Navajo Canyon Open Space Park | 22675 | 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 | 155.786 | Navajo Canyon OS Park | 0 | Local Recreation Area 3 | 4 | |
36 | 36 | 35 | {"type": "Polygon", "coordinates": [[[-117.05461, 32.80729], [-117.05411, 32.80771], [-117.05225, 32.80659], [-117.05423, 32.80617], [-117.05443, 32.80698], [-117.05448, 32.8071], [-117.05461, 32.80729]]]} | Open Access 1 | 118 | Dailard Neighborhood Park | 17891 | 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 | 4.634 | Dailard Neighborhood Park | 0 | Local Park 2 | 4 | |
37 | 37 | 36 | {"type": "Polygon", "coordinates": [[[-122.32795, 37.91786], [-122.32631, 37.91992], [-122.32264, 37.91975], [-122.32261, 37.91967], [-122.32261, 37.91841], [-122.32258, 37.9183], [-122.32754, 37.91757], [-122.32795, 37.91786]]]} | Open Access 1 | 119 | Booker T. Anderson Jr. Park | 16269 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 21.023 | Booker T. Anderson Jr. Park | 0 | Local Park 2 | 4 | |
38 | 38 | 37 | {"type": "Polygon", "coordinates": [[[-121.12982, 37.47991], [-121.12928, 37.48015], [-121.12914, 37.47996], [-121.12969, 37.4797], [-121.12982, 37.47991]]]} | Open Access 1 | 121 | El Pescadero Park | 18527 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.352 | El Pescadero Park | 0 | Local Park 2 | 4 | |
39 | 39 | 38 | {"type": "Polygon", "coordinates": [[[-122.41541, 37.74416], [-122.41424, 37.74386], [-122.4139, 37.74373], [-122.41307, 37.74338], [-122.41292, 37.74333], [-122.41277, 37.74333], [-122.41262, 37.74335], [-122.41236, 37.74347], [-122.41201, 37.74361], [-122.41188, 37.74363], [-122.41171, 37.74361], [-122.41023, 37.74309], [-122.41017, 37.74304], [-122.41012, 37.74297], [-122.4101, 37.74289], [-122.4101, 37.74281], [-122.41018, 37.74269], [-122.41031, 37.74257], [-122.41045, 37.74251], [-122.4106, 37.74249], [-122.41164, 37.74243], [-122.41251, 37.7423], [-122.41265, 37.7423], [-122.41416, 37.74251], [-122.41432, 37.74252], [-122.41446, 37.7425], [-122.41461, 37.74246], [-122.41479, 37.74238], [-122.41501, 37.74225], [-122.41512, 37.74222], [-122.4159, 37.74217], [-122.41629, 37.74208], [-122.41647, 37.74206], [-122.41669, 37.74209], [-122.41682, 37.74216], [-122.41689, 37.74222], [-122.41696, 37.74233], [-122.41699, 37.74242], [-122.41698, 37.74251], [-122.41693, 37.74261], [-122.4167, 37.74279], [-122.41662, 37.74291], [-122.41657, 37.74307], [-122.41659, 37.74328], [-122.41655, 37.74337], [-122.41647, 37.74345], [-122.4161, 37.74363], [-122.41597, 37.74372], [-122.41586, 37.74383], [-122.4158, 37.74393], [-122.41575, 37.74406], [-122.41568, 37.74413], [-122.41556, 37.74418], [-122.41541, 37.74416]], [[-122.41555, 37.74286], [-122.41477, 37.74286], [-122.41477, 37.74327], [-122.41556, 37.74326], [-122.41555, 37.74286]]]} | Open Access 1 | 122 | Bernal Heights Park | 16026 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 19.35 | Bernal Heights Park | 0 | Local Park 2 | 4 | |
5814 | 5814 | 5813 | {"type": "Polygon", "coordinates": [[[-119.89151, 34.43413], [-119.89122, 34.43427], [-119.8914, 34.43453], [-119.89147, 34.43483], [-119.89136, 34.43502], [-119.89074, 34.43377], [-119.8905, 34.43295], [-119.89037, 34.43294], [-119.89009, 34.43279], [-119.89018, 34.43279], [-119.89036, 34.43289], [-119.89048, 34.43289], [-119.8905, 34.43294], [-119.89083, 34.43292], [-119.891, 34.43284], [-119.89098, 34.43312], [-119.891, 34.43328], [-119.89106, 34.43344], [-119.89113, 34.43357], [-119.89151, 34.43413]]]} | Open Access 1 | 123 | Brandon Park | 16330 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.073 | Brandon Park | 0 | Local Park 2 | 4 | |
15548 | 15548 | 15547 | {"type": "MultiPolygon", "coordinates": [[[[-121.45789, 38.26582], [-121.45767, 38.26729], [-121.45774, 38.2673], [-121.45751, 38.26975], [-121.45732, 38.26973], [-121.45657, 38.26972], [-121.45655, 38.26957], [-121.45464, 38.27005], [-121.4543, 38.27018], [-121.45301, 38.26681], [-121.45491, 38.26671], [-121.4556, 38.26691], [-121.45678, 38.26697], [-121.45789, 38.26582]]], [[[-121.39224, 38.26209], [-121.39208, 38.27592], [-121.38748, 38.27593], [-121.3876, 38.28325], [-121.37871, 38.28322], [-121.37877, 38.27595], [-121.37624, 38.27596], [-121.37622, 38.27665], [-121.37362, 38.27663], [-121.37364, 38.27447], [-121.37322, 38.27423], [-121.37277, 38.27395], [-121.37227, 38.27359], [-121.37202, 38.27336], [-121.37184, 38.27315], [-121.37152, 38.27271], [-121.37138, 38.27249], [-121.37132, 38.27233], [-121.3713, 38.27225], [-121.37129, 38.27196], [-121.37118, 38.27188], [-121.37072, 38.2715], [-121.37003, 38.27122], [-121.36776, 38.27164], [-121.36546, 38.27173], [-121.3639, 38.27148], [-121.363, 38.27114], [-121.36152, 38.27125], [-121.35993, 38.27092], [-121.35983, 38.26368], [-121.35984, 38.26194], [-121.36997, 38.26204], [-121.36994, 38.26662], [-121.37924, 38.26667], [-121.37929, 38.26206], [-121.39224, 38.26209]]], [[[-121.37865, 38.29094], [-121.37858, 38.29856], [-121.36937, 38.29852], [-121.36879, 38.29851], [-121.36912, 38.29823], [-121.36956, 38.29807], [-121.37005, 38.29797], [-121.37038, 38.29798], [-121.37067, 38.29794], [-121.37086, 38.29787], [-121.37113, 38.29771], [-121.37121, 38.29757], [-121.37127, 38.29718], [-121.37136, 38.29707], [-121.37179, 38.2968], [-121.37218, 38.29665], [-121.37238, 38.29651], [-121.3725, 38.29627], [-121.37254, 38.29608], [-121.37255, 38.29576], [-121.37268, 38.29546], [-121.37292, 38.29516], [-121.37312, 38.29483], [-121.37332, 38.29444], [-121.37347, 38.2939], [-121.37394, 38.29319], [-121.3741, 38.29298], [-121.37411, 38.29118], [-121.37422, 38.29107], [-121.37501, 38.29094], [-121.37568, 38.2909], [-121.37834, 38.29089], [-121.37865, 38.29094]]], [[[-121.38512, 38.31501], [-121.38431, 38.31541], [-121.38404, 38.31529], [-121.38224, 38.31617], [-121.38094, 38.31689], [-121.3799, 38.31769], [-121.3773, 38.32209], [-121.36688, 38.32234], [-121.36679, 38.33285], [-121.35757, 38.3328], [-121.35753, 38.33645], [-121.35294, 38.33642], [-121.35293, 38.3367], [-121.33795, 38.33676], [-121.33642, 38.33261], [-121.33636, 38.33264], [-121.3362, 38.33267], [-121.33593, 38.33266], [-121.33745, 38.33677], [-121.33518, 38.33678], [-121.33665, 38.34043], [-121.33646, 38.34184], [-121.3362, 38.34175], [-121.33567, 38.34166], [-121.33534, 38.34153], [-121.33516, 38.34143], [-121.335, 38.3413], [-121.33485, 38.34113], [-121.33476, 38.34098], [-121.32949, 38.32963], [-121.32784, 38.32601], [-121.32748, 38.32505], [-121.32777, 38.32497], [-121.32793, 38.32489], [-121.32808, 38.32479], [-121.32819, 38.32465], [-121.32825, 38.32453], [-121.32828, 38.32438], [-121.32827, 38.32425], [-121.32821, 38.32404], [-121.32824, 38.32401], [-121.32836, 38.32395], [-121.32843, 38.32387], [-121.32845, 38.32377], [-121.32842, 38.32369], [-121.32835, 38.32358], [-121.32823, 38.32347], [-121.32808, 38.32337], [-121.32712, 38.32297], [-121.32693, 38.32287], [-121.32677, 38.32277], [-121.32657, 38.3226], [-121.32644, 38.32245], [-121.32631, 38.32224], [-121.32628, 38.32211], [-121.3376, 38.32217], [-121.33754, 38.31278], [-121.34387, 38.31278], [-121.34384, 38.30808], [-121.34543, 38.30807], [-121.34544, 38.30772], [-121.34581, 38.30768], [-121.346, 38.30771], [-121.34615, 38.30772], [-121.34628, 38.30769], [-121.34649, 38.3076], [-121.34671, 38.30746], [-121.34694, 38.30737], [-121.34722, 38.30735], [-121.34757, 38.30738], [-121.34772, 38.30735], [-121.3478, 38.30731], [-121.34795, 38.30716], [-121.34841, 38.30662], [-121.34857, 38.30647], [-121.34881, 38.30632], [-121.34903, 38.30615], [-121.34947, 38.3057], [-121.35, 38.30531], [-121.35018, 38.30521], [-121.35032, 38.30517], [-121.35059, 38.30523], [-121.35078, 38.30529], [-121.3509, 38.30529], [-121.35102, 38.30525], [-121.35114, 38.30519], [-121.3513, 38.30507], [-121.35136, 38.30495], [-121.35137, 38.30463], [-121.35143, 38.30444], [-121.35159, 38.30428], [-121.35183, 38.30417], [-121.35211, 38.30411], [-121.35249, 38.30411], [-121.35282, 38.30413], [-121.35307, 38.3041], [-121.35353, 38.30399], [-121.35381, 38.30392], [-121.35406, 38.30381], [-121.35435, 38.30364], [-121.35468, 38.30349], [-121.35501, 38.30338], [-121.35527, 38.30333], [-121.35557, 38.30331], [-121.35652, 38.30335], [-121.35685, 38.30332], [-121.35716, 38.30324], [-121.3574, 38.30314], [-121.35876, 38.3022], [-121.35902, 38.3021], [-121.35936, 38.30203], [-121.35953, 38.30197], [-121.35969, 38.30187], [-121.35975, 38.30173], [-121.35973, 38.30161], [-121.35964, 38.3015], [-121.35949, 38.30137], [-121.35946, 38.30128], [-121.35947, 38.30117], [-121.35957, 38.30109], [-121.35994, 38.30104], [-121.36058, 38.30087], [-121.36085, 38.30082], [-121.36102, 38.30081], [-121.36126, 38.30084], [-121.36147, 38.30084], [-121.36161, 38.30081], [-121.36206, 38.3005], [-121.36233, 38.30011], [-121.36253, 38.29992], [-121.36272, 38.2998], [-121.36316, 38.29966], [-121.36397, 38.29965], [-121.36428, 38.2996], [-121.36459, 38.2996], [-121.36476, 38.29969], [-121.36485, 38.29982], [-121.36488, 38.30006], [-121.36488, 38.30021], [-121.36502, 38.30047], [-121.36515, 38.30053], [-121.36536, 38.30054], [-121.36596, 38.30039], [-121.36648, 38.30029], [-121.36657, 38.30025], [-121.36653, 38.30031], [-121.36523, 38.3013], [-121.3652, 38.30557], [-121.36531, 38.31376], [-121.37112, 38.31378], [-121.37568, 38.30826], [-121.38512, 38.31501]]], [[[-121.33304, 38.34475], [-121.33237, 38.34524], [-121.33106, 38.34628], [-121.32177, 38.35345], [-121.32052, 38.35213], [-121.3206, 38.34373], [-121.33156, 38.34376], [-121.33304, 38.34475]]], [[[-121.32501, 38.35685], [-121.32198, 38.35367], [-121.3313, 38.34648], [-121.33261, 38.34544], [-121.33322, 38.34499], [-121.336, 38.34501], [-121.33603, 38.34468], [-121.33641, 38.34546], [-121.33682, 38.3462], [-121.33919, 38.3504], [-121.34277, 38.35679], [-121.34305, 38.3575], [-121.34449, 38.36005], [-121.34476, 38.36046], [-121.34505, 38.36085], [-121.34559, 38.36148], [-121.34595, 38.36184], [-121.34633, 38.36218], [-121.34704, 38.36273], [-121.34705, 38.36272], [-121.34665, 38.36164], [-121.34681, 38.3618], [-121.34766, 38.36405], [-121.34755, 38.36409], [-121.3479, 38.36507], [-121.34296, 38.36327], [-121.34284, 38.36304], [-121.34272, 38.3627], [-121.34266, 38.36246], [-121.34242, 38.36216], [-121.34186, 38.36158], [-121.34178, 38.36135], [-121.34176, 38.36107], [-121.34171, 38.36066], [-121.34167, 38.3605], [-121.34129, 38.36076], [-121.33881, 38.36217], [-121.33816, 38.36257], [-121.33741, 38.363], [-121.3368, 38.36336], [-121.33647, 38.36353], [-121.3361, 38.36368], [-121.33596, 38.36371], [-121.33515, 38.36101], [-121.32958, 38.35914], [-121.32829, 38.3586], [-121.32591, 38.3578], [-121.32501, 38.35685]]]]} | Open Access 1 | 124 | Cosumnes River Ecological Reserve | 32137 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cosumnes-River-ER | Sacramento 41 | 4574.064 | Cosumnes River ER | 2003 | State Conservation Area 8 | 2 |
54 | 54 | 53 | {"type": "Polygon", "coordinates": [[[-119.73175, 36.7591], [-119.73175, 36.75936], [-119.73077, 36.75936], [-119.72949, 36.75856], [-119.72945, 36.75845], [-119.72945, 36.75759], [-119.73145, 36.7576], [-119.73104, 36.75782], [-119.73095, 36.75784], [-119.73086, 36.75791], [-119.73087, 36.75827], [-119.73094, 36.75851], [-119.73101, 36.75863], [-119.73118, 36.75885], [-119.73131, 36.75898], [-119.73139, 36.75904], [-119.73157, 36.75909], [-119.73175, 36.7591]]]} | Open Access 1 | 125 | Carozza Park | 16891 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 6.025 | Carozza Park | 0 | Local Park 2 | 4 | |
40 | 40 | 39 | {"type": "Polygon", "coordinates": [[[-120.6535, 35.26278], [-120.65337, 35.26287], [-120.65316, 35.26262], [-120.6533, 35.26255], [-120.6535, 35.26278]]]} | Open Access 1 | 127 | Rockview Right-of-Way | 24536 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.123 | Rockview Right-of-Way | None 7 | |||
55 | 55 | 54 | {"type": "Polygon", "coordinates": [[[-121.12622, 37.47895], [-121.12464, 37.47968], [-121.12384, 37.47861], [-121.12544, 37.47788], [-121.12622, 37.47895]]]} | Open Access 1 | 128 | Felipe Garza Park | 18867 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 5.539 | Felipe Garza Park | 0 | Local Park 2 | 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]);