units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,190 rows where DES_TP = 14 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, MNG_AG_LEV, PARK_URL, YR_EST
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 152
- Ventura, City of 106
- Butte, County of 52
- Yuba County Water Agency 48
- Roseville, City of 46
- Santa Barbara, County of 39
- Lake, County of 36
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Orange, County of 21
- Napa, City of 21
- Monterey, County of 18
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Los Angeles County Flood Control District 13
- Santa Cruz, City of 12
- Santa Barbara Flood Control and Water Conserv. District 12
- Oroville, City of 12
- Los Angeles, County of 11
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Guadalupe, City of 10
- Santa Maria, City of 9
- Escondido, City of 9
- …
MNG_AG_TYP 15
- City Agency 663
- County Agency 214
- Open Space District 155
- Water District 78
- Flood District 32
- Recreation/Parks District 28
- County Agency - Other 6
- Irrigation District 4
- Sanitation District 3
- Community Services District 2
- County Agency - Parks 1
- Special District - Other 1
- Metropolitan Planning Organization 1
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 859
- Unknown Access 204
- No Public Access 96
- Restricted Access 31
DES_TP 1
- Local Other or Unknown · 1,190 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6143 | 6143 | 6142 | {"type": "MultiPolygon", "coordinates": [[[[-117.2322, 33.14229], [-117.23213, 33.1423], [-117.23079, 33.14226], [-117.23016, 33.14279], [-117.23009, 33.14283], [-117.2299, 33.1429], [-117.22971, 33.14288], [-117.22965, 33.14293], [-117.22956, 33.1429], [-117.22942, 33.14281], [-117.22936, 33.14273], [-117.22838, 33.14284], [-117.22763, 33.14285], [-117.22742, 33.14382], [-117.22664, 33.14584], [-117.22578, 33.14584], [-117.22575, 33.14586], [-117.22578, 33.14672], [-117.22545, 33.14622], [-117.22543, 33.14499], [-117.22545, 33.14498], [-117.22571, 33.14438], [-117.22564, 33.14354], [-117.22553, 33.14314], [-117.22408, 33.14364], [-117.22366, 33.14366], [-117.22358, 33.14375], [-117.22341, 33.14374], [-117.22319, 33.14375], [-117.22294, 33.14384], [-117.22269, 33.14399], [-117.22261, 33.14408], [-117.22254, 33.14418], [-117.22244, 33.14426], [-117.22254, 33.1444], [-117.22213, 33.14452], [-117.22193, 33.14451], [-117.22167, 33.14427], [-117.22102, 33.14438], [-117.22071, 33.14439], [-117.22026, 33.14457], [-117.21977, 33.14473], [-117.21939, 33.14498], [-117.21909, 33.14516], [-117.21864, 33.14481], [-117.21879, 33.14463], [-117.21953, 33.14425], [-117.21971, 33.14417], [-117.21927, 33.1437], [-117.2198, 33.14346], [-117.22013, 33.14311], [-117.22065, 33.14288], [-117.2207, 33.1429], [-117.22156, 33.1426], [-117.22174, 33.14268], [-117.22244, 33.14249], [-117.2225, 33.14252], [-117.22325, 33.1423], [-117.22326, 33.14226], [-117.22301, 33.14137], [-117.22304, 33.14137], [-117.22341, 33.14217], [-117.22355, 33.14222], [-117.22536, 33.14182], [-117.22552, 33.14168], [-117.22571, 33.14182], [-117.22573, 33.14223], [-117.23002, 33.14216], [-117.22998, 33.14032], [-117.23034, 33.14013], [-117.23039, 33.14013], [-117.23078, 33.14048], [-117.23149, 33.14103], [-117.2317, 33.14126], [-117.23193, 33.14159], [-117.23208, 33.14189], [-117.2322, 33.14229]]], [[[-117.24385, 33.13544], [-117.24359, 33.13527], [-117.24107, 33.13527], [-117.24034, 33.13552], [-117.23979, 33.13609], [-117.23808, 33.138], [-117.23711, 33.13816], [-117.23713, 33.13888], [-117.23625, 33.1395], [-117.23444, 33.14101], [-117.23228, 33.14173], [-117.23214, 33.14146], [-117.23193, 33.14116], [-117.2317, 33.14091], [-117.23142, 33.14066], [-117.23315, 33.14025], [-117.2341, 33.13943], [-117.23428, 33.13863], [-117.23426, 33.13694], [-117.23613, 33.13594], [-117.23662, 33.13558], [-117.2372, 33.13568], [-117.23806, 33.13524], [-117.23805, 33.13501], [-117.23859, 33.135], [-117.24377, 33.13497], [-117.24385, 33.13544]]], [[[-117.2461, 33.13659], [-117.24526, 33.13547], [-117.24439, 33.13552], [-117.24438, 33.13503], [-117.24439, 33.13496], [-117.246, 33.13495], [-117.2461, 33.13659]]]]} | Open Access 1 | 1138 | Agua Hedionda Creek | 15293 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 113.24 | Agua Hedionda Creek | 0 | Local Other or Unknown 14 | 4 |
10361 | 10361 | 10360 | {"type": "Polygon", "coordinates": [[[-120.11686, 34.66391], [-120.11686, 34.66443], [-120.11666, 34.66443], [-120.11667, 34.6639], [-120.11686, 34.66391]]]} | Open Access 1 | 18384 | Alamo Pintado Creek | 15318 | 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 | 0.262 | Alamo Pintado Creek | 0 | Local Other or Unknown 14 | 4 | |
10640 | 10640 | 10639 | {"type": "Polygon", "coordinates": [[[-120.11817, 34.66507], [-120.11816, 34.66546], [-120.11783, 34.66545], [-120.11784, 34.66507], [-120.11817, 34.66507]]]} | Unknown Access 4 | 18982 | Alamo Pintado Creek | 15319 | 2147 | Santa Ynez River Water Conservation District 953 | Special District 4 | Water District 13 | Special District 4 | 2147 | Santa Ynez River Water Conservation District 925 | Special District 4 | Water District 13 | Santa Barbara 7 | 0.321 | Alamo Pintado Creek | 0 | Local Other or Unknown 14 | 4 | ||
4360 | 4360 | 4359 | {"type": "Polygon", "coordinates": [[[-118.22281, 34.0523], [-118.22263, 34.05242], [-118.22258, 34.05226], [-118.22258, 34.05226], [-118.22281, 34.0523]]]} | Open Access 1 | 45741 | Aliso Triangle | 28745 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.043 | Aliso Triangle | 0 | Local Other or Unknown 14 | 4 | |
6548 | 6548 | 6547 | {"type": "Polygon", "coordinates": [[[-122.27836, 38.16698], [-122.27244, 38.16694], [-122.27213, 38.16617], [-122.26881, 38.16606], [-122.26808, 38.16422], [-122.27137, 38.16431], [-122.27832, 38.16431], [-122.27836, 38.16698]]]} | No Public Access 3 | 3636 | American Canyon Property | 15448 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 55.469 | American Canyon Property | 0 | Local Other or Unknown 14 | 4 | |
11272 | 11272 | 11271 | {"type": "Polygon", "coordinates": [[[-122.28368, 38.18088], [-122.28209, 38.18427], [-122.278, 38.18424], [-122.27658, 38.18424], [-122.27681, 38.18329], [-122.2768, 38.18328], [-122.27228, 38.18322], [-122.27177, 38.1811], [-122.27824, 38.18104], [-122.28368, 38.18088]]]} | Restricted Access 2 | 21765 | American Canyon Property | 15449 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 72.744 | American Canyon Property | 0 | Local Other or Unknown 14 | 4 | |
15001 | 15001 | 15000 | {"type": "Polygon", "coordinates": [[[-118.45909, 33.99185], [-118.45903, 33.99195], [-118.45894, 33.99191], [-118.45901, 33.99181], [-118.45909, 33.99185]]]} | Open Access 1 | 45786 | Amoroso Triangle | 28805 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.027 | Amoroso Triangle | 0 | Local Other or Unknown 14 | 4 | |
13998 | 13998 | 13997 | {"type": "Polygon", "coordinates": [[[-117.76209, 33.85038], [-117.76198, 33.85034], [-117.76192, 33.85035], [-117.76201, 33.85075], [-117.76133, 33.85022], [-117.76105, 33.85004], [-117.76077, 33.8499], [-117.76053, 33.84979], [-117.76024, 33.84969], [-117.75984, 33.84959], [-117.75914, 33.84946], [-117.759, 33.84933], [-117.75885, 33.84913], [-117.75933, 33.84883], [-117.7595, 33.84902], [-117.76021, 33.84861], [-117.76209, 33.85038]]]} | Open Access 1 | 36682 | Anaheim holding 1 | 15466 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 5.203 | Anaheim holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13914 | 13914 | 13913 | {"type": "Polygon", "coordinates": [[[-117.7455, 33.84239], [-117.74526, 33.84244], [-117.74511, 33.8425], [-117.74493, 33.84267], [-117.74482, 33.8429], [-117.74482, 33.84306], [-117.74493, 33.84329], [-117.74499, 33.84337], [-117.7443, 33.84341], [-117.74474, 33.84199], [-117.74489, 33.84174], [-117.74538, 33.84107], [-117.74549, 33.84113], [-117.7455, 33.84239]]]} | Open Access 1 | 36519 | Anaheim holding 2 | 15467 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 3.08 | Anaheim holding 2 | 0 | Local Other or Unknown 14 | 4 | |
3560 | 3560 | 3559 | {"type": "Polygon", "coordinates": [[[-117.97816, 33.85487], [-117.97665, 33.85405], [-117.97656, 33.85345], [-117.97814, 33.85344], [-117.97816, 33.85487]]]} | Open Access 1 | 36526 | Anaheim holding 3 | 15468 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 3.956 | Anaheim holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13937 | 13937 | 13936 | {"type": "Polygon", "coordinates": [[[-117.78356, 33.84518], [-117.78356, 33.84564], [-117.78066, 33.84564], [-117.78019, 33.84566], [-117.78021, 33.84548], [-117.78026, 33.84543], [-117.78065, 33.84536], [-117.78158, 33.84505], [-117.78172, 33.84502], [-117.78206, 33.84499], [-117.7823, 33.845], [-117.78247, 33.84499], [-117.78356, 33.84518]]]} | Open Access 1 | 36544 | Anaheim holding 4 | 15469 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 4.264 | Anaheim holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13679 | 13679 | 13678 | {"type": "Polygon", "coordinates": [[[-121.808, 38.01005], [-121.80799, 38.01113], [-121.80628, 38.0111], [-121.80617, 38.01105], [-121.80616, 38.01002], [-121.808, 38.01005]]]} | Open Access 1 | 36335 | Antioch holding 1 | 15524 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 4.788 | Antioch holding 1 | 0 | Local Other or Unknown 14 | 4 | |
11138 | 11138 | 11137 | {"type": "Polygon", "coordinates": [[[-121.29786, 38.49822], [-121.29733, 38.49802], [-121.2969, 38.49796], [-121.29661, 38.49799], [-121.29634, 38.49832], [-121.29629, 38.49874], [-121.29647, 38.49922], [-121.29644, 38.49953], [-121.29651, 38.49982], [-121.29676, 38.49992], [-121.29701, 38.49988], [-121.29784, 38.49901], [-121.29783, 38.50332], [-121.29735, 38.50321], [-121.29714, 38.50313], [-121.29689, 38.50305], [-121.29688, 38.50306], [-121.29691, 38.50315], [-121.29703, 38.50326], [-121.29748, 38.50354], [-121.29428, 38.50352], [-121.29385, 38.50329], [-121.29323, 38.50315], [-121.29275, 38.50326], [-121.29239, 38.50351], [-121.28867, 38.50348], [-121.28869, 38.50214], [-121.2923, 38.50215], [-121.29546, 38.49847], [-121.29544, 38.49627], [-121.29762, 38.49629], [-121.29774, 38.49637], [-121.29785, 38.49753], [-121.29786, 38.49822]], [[-121.29624, 38.50255], [-121.29625, 38.50254], [-121.29618, 38.50232], [-121.29606, 38.50211], [-121.29588, 38.50192], [-121.29566, 38.50176], [-121.29541, 38.50164], [-121.29512, 38.50157], [-121.29483, 38.50154], [-121.29453, 38.50156], [-121.29425, 38.50162], [-121.29398, 38.50173], [-121.29374, 38.50176], [-121.29351, 38.50182], [-121.2933, 38.50192], [-121.29313, 38.50205], [-121.293, 38.50219], [-121.29301, 38.5022], [-121.29326, 38.50215], [-121.29354, 38.50213], [-121.29382, 38.50215], [-121.29409, 38.50221], [-121.29464, 38.50225], [-121.29519, 38.50231], [-121.29572, 38.50242], [-121.29624, 38.50255]]]} | Restricted Access 2 | 21429 | Arroyo Seco (florin Mitigation Bank) | 15628 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 66.229 | Arroyo Seco (florin Mitigation Bank) | 0 | Local Other or Unknown 14 | 4 | |
9811 | 9811 | 9810 | {"type": "MultiPolygon", "coordinates": [[[[-119.78388, 34.43252], [-119.78345, 34.43278], [-119.78231, 34.43354], [-119.78143, 34.43378], [-119.78052, 34.4337], [-119.78052, 34.43358], [-119.78135, 34.43364], [-119.78158, 34.43361], [-119.78213, 34.43346], [-119.78241, 34.43332], [-119.78376, 34.43242], [-119.78381, 34.43241], [-119.78385, 34.43243], [-119.78388, 34.43248], [-119.78388, 34.43252]]], [[[-119.79498, 34.42774], [-119.79162, 34.42959], [-119.7874, 34.43078], [-119.78626, 34.43109], [-119.78625, 34.43108], [-119.78589, 34.43127], [-119.78408, 34.43239], [-119.78411, 34.4321], [-119.78448, 34.43201], [-119.78536, 34.43149], [-119.78544, 34.43143], [-119.7857, 34.43115], [-119.7862, 34.43068], [-119.78689, 34.43049], [-119.78694, 34.43059], [-119.79145, 34.42935], [-119.79203, 34.42903], [-119.79202, 34.42901], [-119.79462, 34.42757], [-119.79483, 34.42761], [-119.79498, 34.42774]]]]} | Unknown Access 4 | 16760 | Atascadero Creek | 15661 | 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 | 9.641 | Atascadero Creek | 0 | Local Other or Unknown 14 | 4 | |
13792 | 13792 | 13791 | {"type": "Polygon", "coordinates": [[[-120.60175, 37.3593], [-120.60132, 37.35982], [-120.60126, 37.35998], [-120.60081, 37.36], [-120.60081, 37.35938], [-120.59996, 37.35936], [-120.60049, 37.35872], [-120.60085, 37.3589], [-120.60101, 37.35891], [-120.60175, 37.3593]]]} | Open Access 1 | 36357 | Atwater holding 2 | 15679 | 1014 | Atwater, City of 470 | City 2 | City Agency 2 | http://www.atwater.org/index.cfm?page=940884 | City 2 | 1014 | Atwater, City of 463 | City 2 | City Agency 2 | Merced 37 | 2.533 | Atwater holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13847 | 13847 | 13846 | {"type": "Polygon", "coordinates": [[[-121.05862, 38.90419], [-121.05816, 38.90434], [-121.05815, 38.90405], [-121.05815, 38.90405], [-121.05862, 38.90419]]]} | Open Access 1 | 36436 | Auburn holding 10 | 15684 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 0.161 | Auburn holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13848 | 13848 | 13847 | {"type": "Polygon", "coordinates": [[[-121.08066, 38.87675], [-121.08053, 38.87701], [-121.08034, 38.87728], [-121.08037, 38.87647], [-121.08047, 38.87655], [-121.08059, 38.87661], [-121.08066, 38.87675]]]} | Open Access 1 | 36437 | Auburn holding 11 | 15685 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 0.336 | Auburn holding 11 | 0 | Local Other or Unknown 14 | 4 | |
6980 | 6980 | 6979 | {"type": "Polygon", "coordinates": [[[-121.07455, 38.91293], [-121.07438, 38.9135], [-121.07415, 38.91404], [-121.07387, 38.91393], [-121.07445, 38.91293], [-121.07455, 38.91293]]]} | Open Access 1 | 36393 | Auburn holding 12 | 15686 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 0.588 | Auburn holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13822 | 13822 | 13821 | {"type": "Polygon", "coordinates": [[[-121.07768, 38.92039], [-121.07754, 38.9204], [-121.07755, 38.92127], [-121.0773, 38.92127], [-121.07737, 38.92103], [-121.07736, 38.92101], [-121.07719, 38.92103], [-121.07719, 38.92109], [-121.07713, 38.92111], [-121.07714, 38.92128], [-121.07702, 38.92128], [-121.07712, 38.92095], [-121.07715, 38.92092], [-121.07729, 38.92087], [-121.07735, 38.92082], [-121.07736, 38.92077], [-121.07735, 38.92072], [-121.0773, 38.92066], [-121.07722, 38.92063], [-121.07711, 38.92064], [-121.07708, 38.92058], [-121.07713, 38.92045], [-121.07718, 38.92045], [-121.07722, 38.92033], [-121.07727, 38.92033], [-121.07731, 38.92021], [-121.07709, 38.92016], [-121.07684, 38.92039], [-121.07669, 38.92064], [-121.07656, 38.92109], [-121.07649, 38.92135], [-121.07674, 38.9214], [-121.07666, 38.92146], [-121.07611, 38.92137], [-121.07608, 38.92142], [-121.07598, 38.92134], [-121.07616, 38.92133], [-121.07623, 38.92106], [-121.07624, 38.92093], [-121.07627, 38.92081], [-121.07643, 38.92045], [-121.07624, 38.92037], [-121.07635, 38.9203], [-121.07639, 38.92021], [-121.07638, 38.92016], [-121.07634, 38.92012], [-121.07623, 38.92006], [-121.07768, 38.92011], [-121.07768, 38.92039]]]} | Open Access 1 | 36408 | Auburn holding 15 | 15687 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 2.423 | Auburn holding 15 | 0 | Local Other or Unknown 14 | 4 | |
13823 | 13823 | 13822 | {"type": "Polygon", "coordinates": [[[-121.08677, 38.89466], [-121.08652, 38.89464], [-121.08619, 38.89452], [-121.08587, 38.89452], [-121.0854, 38.89474], [-121.0851, 38.89477], [-121.08481, 38.89497], [-121.0847, 38.89492], [-121.0847, 38.89455], [-121.0849, 38.89462], [-121.08509, 38.89464], [-121.08529, 38.89461], [-121.08582, 38.89446], [-121.08602, 38.89446], [-121.08627, 38.89453], [-121.08642, 38.89454], [-121.08661, 38.89453], [-121.08677, 38.89448], [-121.08677, 38.89466]]]} | Open Access 1 | 36409 | Auburn holding 2 | 15688 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 0.645 | Auburn holding 2 | 0 | Local Other or Unknown 14 | 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]);