units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 8,006
- Recreation/Parks District 994
- State Agency 985
- County Agency 972
- Non Profit - Land Trust 500
- Federal Agency 417
- Open Space District 391
- County Agency - Parks 207
- Water District 204
- Home Owners Association 182
- Community Services District 176
- Non Profit - Conservation 132
- Flood District 95
- Non Profit - Other 41
- Irrigation District 38
- School District 35
- Cemetery District 33
- County Agency - Other 27
- Port/Harbor District 26
- Special District - Other 15
- Commercial 14
- Joint Powers Authority 7
- Sanitation District 6
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 412
- Los Angeles, City of 377
- California Department of Fish and Wildlife 375
- California Department of Parks and Recreation 332
- Mountains Recreation and Conservation Authority 319
- San Jose, City of 191
- Sacramento, City of 190
- San Francisco, City and County of 161
- East Bay Regional Park District 157
- Los Angeles, County of 137
- Ventura, City of 131
- Long Beach, City of 122
- Roseville, City of 120
- San Diego, County of 101
- United States Bureau of Land Management 95
- Santa Barbara, County of 94
- Oakland, City of 93
- Consumnes Community Services District 93
- United States Forest Service 87
- Napa, City of 79
- Orange, County of 77
- California State Lands Commission 76
- United States Fish and Wildlife Service 75
- United States National Park Service 72
- Irvine, City of 70
- Hayward Area Recreation and Park District 68
- Valley-Wide Recreation and Park District 64
- Tracy, City of 62
- Poway, City of 61
- Davis, City of 61
- …
DES_TP >30
- Local Park 6,928
- Local Recreation Area 1,702
- Local Other or Unknown 1,140
- Private Conservation 523
- Local Conservation Area 418
- State Conservation Area 339
- Private Recreation or Education 236
- State Park 182
- State Resource Management Area 128
- State Recreation Area 124
- National Forest 74
- Local Historic or Cultural Area 70
- National Wildlife Refuge 68
- State Other or Unknown 66
- State Historic or Cultural Area 58
- National Public Lands 53
- Recreation Management Area 51
- Private Other or Unknown 51
- National Monument or Landmark 36
- National Recreation Area 34
- National Park 22
- Local Resource Management Area 20
- Resource Management Area 18
- Federal Other or Unknown 18
- Conservation Area 12
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 5
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 11,304
- Restricted Access 1,049
- No Public Access 824
- Unknown Access 359
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3533 | 3533 | 3532 | {"type": "Polygon", "coordinates": [[[-117.2507, 33.68241], [-117.25037, 33.68251], [-117.2504, 33.68248], [-117.2504, 33.68243], [-117.25019, 33.68189], [-117.25016, 33.68186], [-117.25011, 33.68184], [-117.2503, 33.68184], [-117.25047, 33.68182], [-117.2507, 33.68241]]]} | Open Access 1 | 28098 | Lions Parkq | 21326 | 1458 | Canyon Lake, City of 656 | City 2 | City Agency 2 | http://www.cityofcanyonlake.com/ | City 2 | 1458 | Canyon Lake, City of 644 | City 2 | City Agency 2 | Riverside 10 | 0.491 | Lions Parkq | None 294 | |||
3534 | 3534 | 3533 | {"type": "Polygon", "coordinates": [[[-120.60822, 35.11477], [-120.60789, 35.11477], [-120.60766, 35.11474], [-120.60738, 35.11468], [-120.60693, 35.11464], [-120.6007, 35.11463], [-120.60066, 35.1146], [-120.60065, 35.11457], [-120.60063, 35.1127], [-120.60796, 35.11271], [-120.60821, 35.11292], [-120.60822, 35.11477]]]} | Open Access 1 | 28101 | Soto Sports Complex | 33130 | 1454 | Arroyo Grande, City of 611 | City 2 | City Agency 2 | http://www.arroyogrande.org/ | City 2 | 1454 | Arroyo Grande, City of 600 | City 2 | City Agency 2 | San Luis Obispo 1 | 36.63 | Soto Sports Complex | 0 | Local Recreation Area 3 | 4 | |
3535 | 3535 | 3534 | {"type": "Polygon", "coordinates": [[[-122.44112, 38.28032], [-122.44096, 38.28136], [-122.43854, 38.28113], [-122.43869, 38.28008], [-122.44112, 38.28032]]]} | Open Access 1 | 28218 | Sonoma Garden Park | 25611 | 1338 | Sonoma, City of 373 | City 2 | City Agency 2 | http://www.sonomacity.org/ | City 2 | 1338 | Sonoma, City of 368 | City 2 | City Agency 2 | Sonoma 16 | 6.173 | Sonoma Garden Park | 0 | Local Park 2 | 4 | |
3536 | 3536 | 3535 | {"type": "Polygon", "coordinates": [[[-122.41521, 37.74427], [-122.41503, 37.74455], [-122.41497, 37.74456], [-122.41494, 37.74427], [-122.41521, 37.74427]]]} | Open Access 1 | 36361 | San Francisco, City and County of 2 | 24892 | 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 | 0.114 | San Francisco, City and County of 2 | None 295 | |||
3537 | 3537 | 3536 | {"type": "Polygon", "coordinates": [[[-121.44091, 37.7344], [-121.44095, 37.73455], [-121.44096, 37.73472], [-121.44085, 37.73529], [-121.44084, 37.73547], [-121.44084, 37.73572], [-121.44051, 37.73575], [-121.44056, 37.73608], [-121.44064, 37.7364], [-121.44069, 37.73664], [-121.44071, 37.73705], [-121.44062, 37.73748], [-121.44047, 37.73784], [-121.44019, 37.73776], [-121.44033, 37.73739], [-121.44036, 37.7372], [-121.44039, 37.73693], [-121.44038, 37.73674], [-121.44035, 37.73659], [-121.44036, 37.73657], [-121.44023, 37.73603], [-121.4402, 37.73581], [-121.44021, 37.73574], [-121.43998, 37.73566], [-121.43988, 37.7356], [-121.43976, 37.7355], [-121.43968, 37.73539], [-121.43963, 37.73527], [-121.43962, 37.73509], [-121.43966, 37.73494], [-121.43974, 37.7348], [-121.43985, 37.7347], [-121.43995, 37.73463], [-121.44015, 37.73455], [-121.44055, 37.73449], [-121.44091, 37.7344]]]} | Open Access 1 | 28133 | Alden Park | 15345 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 4.924 | Alden Park | 0 | Local Park 2 | 4 | |
3538 | 3538 | 3537 | {"type": "MultiPolygon", "coordinates": [[[[-115.82568, 35.02937], [-115.82568, 35.04387], [-115.80655, 35.04385], [-115.80654, 35.02936], [-115.82568, 35.02937]]], [[[-115.82562, 35.11652], [-115.8256, 35.13105], [-115.80662, 35.13104], [-115.80661, 35.11652], [-115.82562, 35.11652]]]]} | Open Access 1 | 28126 | Kelso Peak & Old Dad Mountains Wildlife Area | 30459 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 1383.587 | Kelso Peak & Old Dad Mtns. Wildlife Area | 1989 | State Conservation Area 8 | 2 | |
3539 | 3539 | 3538 | {"type": "Polygon", "coordinates": [[[-121.3399, 38.77607], [-121.33948, 38.77588], [-121.33948, 38.77588], [-121.33969, 38.77582], [-121.3399, 38.77607]]]} | Open Access 1 | 36403 | Roseville holding 13 | 24631 | 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 | 0.081 | Roseville holding 13 | 0 | Local Other or Unknown 14 | 4 | |
3540 | 3540 | 3539 | {"type": "Polygon", "coordinates": [[[-118.16453, 33.91645], [-118.16403, 33.91647], [-118.164, 33.91524], [-118.16449, 33.91524], [-118.16453, 33.91645]]]} | Open Access 1 | 20600 | Hollydale Community Park | 20048 | 1339 | South Gate, City of 657 | City 2 | City Agency 2 | http://www.cityofsouthgate.org/ | City 2 | 1339 | South Gate, City of 645 | City 2 | City Agency 2 | Los Angeles 6 | 1.539 | Hollydale Community Park | 0 | Local Park 2 | 4 | |
3541 | 3541 | 3540 | {"type": "Polygon", "coordinates": [[[-118.15686, 33.91279], [-118.15558, 33.9145], [-118.15396, 33.91378], [-118.15439, 33.91307], [-118.15686, 33.91279]]]} | Open Access 1 | 20601 | All American Park | 15376 | 1245 | Paramount, City of 285 | City 2 | City Agency 2 | http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 | City 2 | 1245 | Paramount, City of 281 | City 2 | City Agency 2 | Los Angeles 6 | 6.776 | All American Park | 0 | Local Park 2 | 4 | |
3542 | 3542 | 3541 | {"type": "Polygon", "coordinates": [[[-118.15132, 33.89221], [-118.1513, 33.89222], [-118.1513, 33.8927], [-118.15125, 33.89275], [-118.1494, 33.89275], [-118.14939, 33.89231], [-118.14861, 33.89231], [-118.1486, 33.89214], [-118.14829, 33.89214], [-118.14828, 33.89195], [-118.14739, 33.89195], [-118.14739, 33.89147], [-118.1507, 33.89147], [-118.15081, 33.8914], [-118.15132, 33.8914], [-118.15132, 33.89221]]]} | Open Access 1 | 20603 | Progress Park | 24013 | 1245 | Paramount, City of 285 | City 2 | City Agency 2 | http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 | City 2 | 1245 | Paramount, City of 281 | City 2 | City Agency 2 | http://www.paramountcity.com/Home/Components/FacilityDirectory/FacilityDirectory/38/97 | Los Angeles 6 | 9.632 | Progress Park | 0 | Local Park 2 | 4 |
3543 | 3543 | 3542 | {"type": "Polygon", "coordinates": [[[-117.8109, 34.10652], [-117.8094, 34.10658], [-117.80939, 34.10618], [-117.80939, 34.10618], [-117.8109, 34.10652]]]} | Open Access 1 | 20605 | Rhoads Park | 24312 | 1298 | San Dimas, City of 237 | City 2 | City Agency 2 | http://www.cityofsandimas.com/ps.parksrecreation.cfm?ID=2157 | City 2 | 1298 | San Dimas, City of 233 | City 2 | City Agency 2 | Los Angeles 6 | 0.766 | Rhoads Park | 0 | Local Park 2 | 4 | |
3544 | 3544 | 3543 | {"type": "Polygon", "coordinates": [[[-117.85486, 34.14059], [-117.85485, 34.14152], [-117.85341, 34.14152], [-117.85365, 34.14135], [-117.85486, 34.14059]]]} | Open Access 1 | 20606 | Ole Hammer Park | 23114 | 1120 | Glendora, City of 76 | City 2 | City Agency 2 | http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services | City 2 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 1.741 | Ole Hammer Park | 0 | Local Park 2 | 4 | |
3545 | 3545 | 3544 | {"type": "Polygon", "coordinates": [[[-118.04485, 34.04282], [-118.04349, 34.04401], [-118.04261, 34.04329], [-118.04286, 34.04329], [-118.04283, 34.04288], [-118.04383, 34.04199], [-118.0448, 34.04278], [-118.04482, 34.04281], [-118.04485, 34.04282]]]} | Restricted Access 2 | 20607 | New Temple Park | 31632 | 2383 | Valle Lindo Unified School District 658 | Special District 4 | School District 14 | http://www.vallelindo.k12.ca.us/ | Special District 4 | 1402 | South El Monte, City of 595 | City 2 | City Agency 2 | Los Angeles 6 | 5.682 | New Temple Park | 0 | Local Park 2 | 4 | |
3546 | 3546 | 3545 | {"type": "Polygon", "coordinates": [[[-121.94776, 38.35645], [-121.94605, 38.35706], [-121.94576, 38.3565], [-121.94534, 38.35665], [-121.94491, 38.35597], [-121.94666, 38.35525], [-121.94676, 38.35524], [-121.94734, 38.35568], [-121.94757, 38.3557], [-121.94774, 38.35584], [-121.94776, 38.35645]]]} | Restricted Access 2 | 28309 | Cooper School Park | 31609 | 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 | 7.337 | Cooper School Park | 0 | Local Park 2 | 4 | |
3547 | 3547 | 3546 | {"type": "Polygon", "coordinates": [[[-121.32679, 38.76689], [-121.3266, 38.76689], [-121.3266, 38.76659], [-121.32679, 38.76659], [-121.32679, 38.76689]]]} | Open Access 1 | 36445 | Roseville holding 1 | 24627 | 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 | 0.139 | Roseville holding 1 | 0 | Local Other or Unknown 14 | 4 | |
3548 | 3548 | 3547 | {"type": "Polygon", "coordinates": [[[-121.95786, 37.09826], [-121.95785, 37.09831], [-121.95772, 37.09853], [-121.95771, 37.09862], [-121.95776, 37.0987], [-121.95792, 37.09886], [-121.95799, 37.09899], [-121.95798, 37.09918], [-121.95799, 37.09931], [-121.9581, 37.09962], [-121.95813, 37.09973], [-121.95812, 37.10001], [-121.95813, 37.10012], [-121.95819, 37.10025], [-121.95843, 37.10056], [-121.95847, 37.10076], [-121.95845, 37.10085], [-121.95837, 37.10096], [-121.958, 37.10123], [-121.95783, 37.10138], [-121.95773, 37.10155], [-121.95769, 37.10172], [-121.95629, 37.10164], [-121.95655, 37.10147], [-121.95691, 37.10155], [-121.95723, 37.10095], [-121.95744, 37.10068], [-121.95767, 37.10059], [-121.95757, 37.10014], [-121.95779, 37.09972], [-121.95773, 37.0996], [-121.9574, 37.09934], [-121.95733, 37.09916], [-121.95733, 37.09893], [-121.95737, 37.09881], [-121.95667, 37.09858], [-121.95655, 37.09837], [-121.95617, 37.09827], [-121.95643, 37.09799], [-121.95564, 37.09731], [-121.95743, 37.09748], [-121.95708, 37.09765], [-121.95701, 37.09775], [-121.95701, 37.09786], [-121.95747, 37.09804], [-121.95786, 37.09826]]]} | Open Access 1 | 28270 | Scotts Valley Water District | 25214 | 2274 | Scotts Valley Water District 599 | Special District 4 | Water District 13 | http://www.svwd.org/ | Special District 4 | 2274 | Scotts Valley Water District 589 | Special District 4 | Water District 13 | Santa Cruz 5 | 9.048 | Scotts Valley Water District | 0 | Local Other or Unknown 14 | 4 | |
3549 | 3549 | 3548 | {"type": "MultiPolygon", "coordinates": [[[[-122.0948, 37.05167], [-122.09523, 37.0518], [-122.09531, 37.05186], [-122.09535, 37.05191], [-122.09535, 37.05198], [-122.09527, 37.05217], [-122.09521, 37.05222], [-122.09513, 37.05225], [-122.09477, 37.05223], [-122.09445, 37.05228], [-122.0948, 37.05167]]], [[[-122.10538, 37.05336], [-122.09591, 37.05335], [-122.09591, 37.05309], [-122.09516, 37.05242], [-122.09526, 37.0524], [-122.09535, 37.05235], [-122.09542, 37.0523], [-122.09546, 37.05223], [-122.09555, 37.05206], [-122.09556, 37.05192], [-122.0955, 37.05179], [-122.09541, 37.0517], [-122.09555, 37.05169], [-122.09556, 37.05168], [-122.09536, 37.05163], [-122.09486, 37.05141], [-122.09483, 37.05116], [-122.09522, 37.0506], [-122.0954, 37.05042], [-122.09543, 37.05025], [-122.09453, 37.04961], [-122.09315, 37.05085], [-122.0934, 37.05104], [-122.09379, 37.05115], [-122.09377, 37.0512], [-122.09291, 37.05096], [-122.09282, 37.05091], [-122.09277, 37.05084], [-122.09232, 37.04997], [-122.09226, 37.0499], [-122.09218, 37.04985], [-122.09099, 37.04935], [-122.0907, 37.04918], [-122.09043, 37.04908], [-122.08996, 37.049], [-122.08972, 37.04899], [-122.08938, 37.049], [-122.08921, 37.04897], [-122.08894, 37.04882], [-122.08869, 37.04874], [-122.08869, 37.04856], [-122.08848, 37.04857], [-122.0881, 37.04862], [-122.0879, 37.0486], [-122.08772, 37.04862], [-122.08744, 37.04871], [-122.08727, 37.04878], [-122.08678, 37.04907], [-122.08627, 37.04922], [-122.08606, 37.04933], [-122.08594, 37.04943], [-122.08584, 37.04943], [-122.08595, 37.04937], [-122.08613, 37.04923], [-122.08644, 37.04908], [-122.08657, 37.04903], [-122.08668, 37.04902], [-122.08679, 37.04897], [-122.08687, 37.0489], [-122.0872, 37.04868], [-122.08738, 37.04861], [-122.08768, 37.04852], [-122.0879, 37.04849], [-122.0881, 37.0485], [-122.08846, 37.04846], [-122.08862, 37.04851], [-122.0887, 37.04848], [-122.08869, 37.04837], [-122.08745, 37.04797], [-122.08684, 37.04745], [-122.08624, 37.04744], [-122.08628, 37.0455], [-122.0912, 37.04553], [-122.09117, 37.04663], [-122.09118, 37.04664], [-122.09293, 37.04667], [-122.1006, 37.04584], [-122.10523, 37.04586], [-122.10538, 37.05336]]]]} | Open Access 1 | 28274 | San Lorenzo Valley Water District | 11349 | 2277 | San Lorenzo Valley Water District 598 | Special District 4 | Water District 13 | http://www.slvwd.com/ | Special District 4 | 2277 | San Lorenzo Valley Water District 588 | Special District 4 | Water District 13 | Santa Cruz 5 | 251.674 | San Lorenzo Valley Water District | 0 | Local Other or Unknown 14 | 4 | |
3550 | 3550 | 3549 | {"type": "Polygon", "coordinates": [[[-122.79598, 38.68638], [-122.79593, 38.68645], [-122.79587, 38.68663], [-122.79584, 38.68702], [-122.79582, 38.68712], [-122.79577, 38.68724], [-122.79549, 38.68779], [-122.79545, 38.68786], [-122.79501, 38.68816], [-122.79483, 38.68832], [-122.79478, 38.68849], [-122.79478, 38.68903], [-122.79483, 38.68923], [-122.79486, 38.68944], [-122.79482, 38.68962], [-122.79478, 38.68969], [-122.79471, 38.68978], [-122.79457, 38.68984], [-122.79425, 38.68987], [-122.79372, 38.68983], [-122.79362, 38.68984], [-122.79311, 38.68994], [-122.79276, 38.69005], [-122.79265, 38.69012], [-122.79244, 38.6902], [-122.79194, 38.69034], [-122.79182, 38.69038], [-122.79175, 38.69043], [-122.79171, 38.6905], [-122.79168, 38.69063], [-122.79137, 38.69088], [-122.79073, 38.69135], [-122.79069, 38.69141], [-122.79067, 38.69148], [-122.7907, 38.6916], [-122.79102, 38.69195], [-122.79109, 38.69208], [-122.79115, 38.69228], [-122.79115, 38.69241], [-122.79113, 38.69252], [-122.79101, 38.69282], [-122.79094, 38.6929], [-122.79085, 38.69297], [-122.79052, 38.69312], [-122.79023, 38.69322], [-122.79012, 38.69328], [-122.78934, 38.69224], [-122.78925, 38.6893], [-122.78809, 38.68905], [-122.7847, 38.68871], [-122.78467, 38.68598], [-122.79598, 38.68638]]]} | No Public Access 3 | 28288 | Bear Canyon | 15921 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 98.229 | Bear Canyon | 0 | Local Recreation Area 3 | 4 | |
3551 | 3551 | 3550 | {"type": "Polygon", "coordinates": [[[-117.98918, 34.51959], [-117.98917, 34.52033], [-117.98818, 34.52034], [-117.98817, 34.51959], [-117.98918, 34.51959]]]} | No Public Access 3 | 12453 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.865 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
3552 | 3552 | 3551 | {"type": "Polygon", "coordinates": [[[-117.05544, 32.59946], [-117.05505, 32.59946], [-117.05504, 32.59979], [-117.05461, 32.59966], [-117.05462, 32.59923], [-117.05469, 32.59919], [-117.05504, 32.59919], [-117.05505, 32.59938], [-117.05544, 32.59939], [-117.05544, 32.59946]]]} | Open Access 1 | 7710 | Connoley Park | 17592 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/connoley-park | San Diego 4 | 0.668 | Connoley 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]);