units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP, LAYER
ACCESS_TYP 4
- Open Access 14,491
- Restricted Access 1,203
- No Public Access 969
- Unknown Access 385
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13563 | 13563 | 13562 | {"type": "Polygon", "coordinates": [[[-117.26661, 32.96713], [-117.26583, 32.96719], [-117.2658, 32.96677], [-117.2658, 32.96632], [-117.26595, 32.96632], [-117.26661, 32.96713]]]} | Open Access 1 | 35878 | 21st Street Tennis Courts and Pump Station | 28692 | 1082 | Del Mar, City of 93 | City 2 | City Agency 2 | http://www.delmar.ca.us/203/Beaches-Parks | City 2 | 1082 | Del Mar, City of 91 | City 2 | City Agency 2 | http://www.delmar.ca.us/301/Tennis-Courts | San Diego 4 | 1.052 | 21st Street Tennis Courts and Pump Station | None 1170 | ||
2391 | 2391 | 2390 | {"type": "Polygon", "coordinates": [[[-118.20432, 33.79536], [-118.20431, 33.79659], [-118.20427, 33.79663], [-118.20404, 33.79662], [-118.20404, 33.79554], [-118.20398, 33.79553], [-118.20397, 33.79536], [-118.20432, 33.79536]]]} | Open Access 1 | 45873 | 21st to Hill Mini Park | 28944 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://longbeach.granicus.com/MediaPlayer.php?view_id=12&clip_id=4470 | Los Angeles 6 | 0.91 | 21st to Hill MP | 0 | Local Park 2 | 4 |
7015 | 7015 | 7014 | {"type": "Polygon", "coordinates": [[[-118.28389, 33.72397], [-118.28434, 33.72394], [-118.28451, 33.72426], [-118.28467, 33.72499], [-118.28458, 33.72533], [-118.2844, 33.72593], [-118.28373, 33.7268], [-118.28244, 33.72785], [-118.28077, 33.72872], [-118.28047, 33.72883], [-118.28046, 33.72831], [-118.28107, 33.728], [-118.28046, 33.72628], [-118.28046, 33.72509], [-118.28209, 33.72464], [-118.28381, 33.72421], [-118.28389, 33.72419], [-118.28392, 33.72412], [-118.28389, 33.72397]]]} | Open Access 1 | 5957 | 22nd Street Landing | 15183 | 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 | 30.559 | 22nd Street Landing | 0 | None 574 | ||
6891 | 6891 | 6890 | {"type": "Polygon", "coordinates": [[[-122.40867, 37.7532], [-122.4085, 37.75321], [-122.40848, 37.75292], [-122.40865, 37.75291], [-122.40867, 37.7532]]]} | Open Access 1 | 5720 | 24th & York Mini Park | 15185 | 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.119 | 24th & York MP | 0 | Local Park 2 | 4 | |
11068 | 11068 | 11067 | {"type": "MultiPolygon", "coordinates": [[[[-121.48235, 38.49361], [-121.48044, 38.49362], [-121.48044, 38.4925], [-121.48046, 38.49243], [-121.4805, 38.49238], [-121.48056, 38.49235], [-121.48062, 38.49233], [-121.48066, 38.49234], [-121.48097, 38.49259], [-121.48202, 38.49327], [-121.48222, 38.49346], [-121.48235, 38.49361]]], [[[-121.48082, 38.49178], [-121.48186, 38.49179], [-121.48203, 38.49183], [-121.48215, 38.49187], [-121.48238, 38.49202], [-121.48249, 38.49213], [-121.48255, 38.49223], [-121.48261, 38.49243], [-121.48261, 38.49309], [-121.48258, 38.49318], [-121.48252, 38.49327], [-121.48247, 38.4933], [-121.48241, 38.49329], [-121.48215, 38.49307], [-121.48118, 38.49244], [-121.48098, 38.49229], [-121.4808, 38.4921], [-121.48065, 38.49188], [-121.48065, 38.49185], [-121.48068, 38.49181], [-121.48082, 38.49178]]]]} | Open Access 1 | 21267 | 24th Street Bypass Park | 15186 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 7.38 | 24th Street Bypass Park | 0 | Local Park 2 | 4 | |
9353 | 9353 | 9352 | {"type": "Polygon", "coordinates": [[[-122.27275, 37.81463], [-122.27269, 37.81501], [-122.27229, 37.81496], [-122.27236, 37.81458], [-122.27275, 37.81463]]]} | Open Access 1 | 15617 | 25th St. Mini Park | 15188 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.375 | 25th St. MP | 0 | Local Park 2 | 4 | |
14393 | 14393 | 14392 | {"type": "MultiPolygon", "coordinates": [[[[-119.25231, 35.30226], [-119.25231, 35.30309], [-119.25223, 35.3031], [-119.25222, 35.30377], [-119.25231, 35.30378], [-119.2523, 35.30706], [-119.24691, 35.30706], [-119.24689, 35.31068], [-119.24357, 35.31069], [-119.24355, 35.31431], [-119.23467, 35.3143], [-119.23463, 35.31794], [-119.23106, 35.31795], [-119.23105, 35.31986], [-119.21949, 35.32], [-119.21947, 35.32536], [-119.21637, 35.3254], [-119.21635, 35.32721], [-119.21203, 35.32721], [-119.21196, 35.33231], [-119.21237, 35.33267], [-119.19869, 35.33266], [-119.19417, 35.33263], [-119.19407, 35.33993], [-119.18531, 35.33985], [-119.18533, 35.34355], [-119.1809, 35.34352], [-119.18092, 35.34642], [-119.17282, 35.34638], [-119.17282, 35.34627], [-119.17216, 35.3462], [-119.17025, 35.34618], [-119.16994, 35.3462], [-119.16942, 35.34631], [-119.16922, 35.34633], [-119.16921, 35.34661], [-119.16335, 35.34659], [-119.16335, 35.34614], [-119.16316, 35.34614], [-119.16314, 35.34659], [-119.1549, 35.34666], [-119.15433, 35.34673], [-119.15381, 35.34673], [-119.1538, 35.34675], [-119.14748, 35.3468], [-119.14747, 35.34678], [-119.14733, 35.34678], [-119.14702, 35.34685], [-119.14677, 35.34695], [-119.14658, 35.34707], [-119.14631, 35.34729], [-119.14553, 35.3473], [-119.14553, 35.34797], [-119.145, 35.34843], [-119.14497, 35.34841], [-119.14437, 35.34892], [-119.14412, 35.34909], [-119.1438, 35.34925], [-119.14342, 35.34939], [-119.14313, 35.34947], [-119.14132, 35.34975], [-119.14085, 35.34986], [-119.14051, 35.34998], [-119.13735, 35.3512], [-119.13734, 35.35119], [-119.13699, 35.3513], [-119.1356, 35.35161], [-119.13549, 35.35161], [-119.13497, 35.3515], [-119.13484, 35.35151], [-119.133, 35.35189], [-119.13144, 35.35085], [-119.13213, 35.35018], [-119.13545, 35.34873], [-119.1366, 35.34848], [-119.13659, 35.34756], [-119.13714, 35.3473], [-119.14146, 35.34564], [-119.14337, 35.34493], [-119.14412, 35.34462], [-119.14552, 35.34446], [-119.14552, 35.3456], [-119.14554, 35.34561], [-119.14565, 35.34507], [-119.15013, 35.34469], [-119.15125, 35.34468], [-119.15439, 35.3431], [-119.16039, 35.34305], [-119.16326, 35.34385], [-119.16327, 35.34414], [-119.16498, 35.34432], [-119.16768, 35.34402], [-119.16837, 35.34364], [-119.16913, 35.34254], [-119.16938, 35.34184], [-119.1713, 35.33983], [-119.17208, 35.33982], [-119.17212, 35.33618], [-119.17652, 35.33617], [-119.17656, 35.33253], [-119.18096, 35.33252], [-119.18107, 35.32415], [-119.18682, 35.32194], [-119.18726, 35.32181], [-119.197, 35.32044], [-119.19726, 35.32038], [-119.19748, 35.32027], [-119.19882, 35.32142], [-119.20352, 35.32537], [-119.20396, 35.32537], [-119.20396, 35.32535], [-119.19775, 35.32011], [-119.21331, 35.31076], [-119.21743, 35.30838], [-119.21775, 35.30826], [-119.21817, 35.30814], [-119.21859, 35.30805], [-119.21893, 35.30799], [-119.23869, 35.30597], [-119.2387, 35.30596], [-119.23866, 35.3057], [-119.24602, 35.30491], [-119.24784, 35.30307], [-119.25231, 35.30226]]], [[[-119.26408, 35.30353], [-119.25461, 35.30346], [-119.25393, 35.30397], [-119.25258, 35.30426], [-119.25258, 35.30378], [-119.25266, 35.30377], [-119.25266, 35.30311], [-119.25258, 35.30309], [-119.25258, 35.30216], [-119.25321, 35.30159], [-119.25464, 35.30088], [-119.25577, 35.30059], [-119.25736, 35.30052], [-119.25921, 35.30106], [-119.26113, 35.30122], [-119.26408, 35.30353]]]]} | Restricted Access 2 | 44492 | 2800 Acre Water Bank | 15189 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 3053.963 | 2800 Acre Water Bank | None 1220 | |||
15709 | 15709 | 15708 | {"type": "Polygon", "coordinates": [[[-122.44016, 37.74009], [-122.43987, 37.7401], [-122.43978, 37.73989], [-122.43976, 37.7398], [-122.43976, 37.73971], [-122.43982, 37.73946], [-122.43984, 37.73932], [-122.43982, 37.73917], [-122.43978, 37.73898], [-122.44007, 37.73898], [-122.44016, 37.74009]]]} | Open Access 1 | 5549 | 298 Berkeley Way Open Space | 15190 | 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.831 | 298 Berkeley Way OS | 0 | Local Recreation Area 3 | 4 | |
11985 | 11985 | 11984 | {"type": "Polygon", "coordinates": [[[-116.99002, 33.93689], [-116.98976, 33.93712], [-116.98957, 33.93735], [-116.98957, 33.93742], [-116.98948, 33.93746], [-116.98945, 33.9375], [-116.98944, 33.93755], [-116.98924, 33.93759], [-116.98896, 33.93807], [-116.98887, 33.93804], [-116.98867, 33.93792], [-116.98846, 33.93774], [-116.98828, 33.93752], [-116.98819, 33.93733], [-116.98814, 33.93718], [-116.98811, 33.93699], [-116.98811, 33.93607], [-116.98818, 33.93601], [-116.98847, 33.93606], [-116.9894, 33.93642], [-116.98969, 33.93659], [-116.98984, 33.93671], [-116.99002, 33.93689]]]} | Open Access 1 | 24636 | 3 Rings Ranch Community Park | 15191 | 1415 | Beaumont, City of 802 | City 2 | City Agency 2 | http://www.ci.beaumont.ca.us/index.aspx?nid=33 | City 2 | 1415 | Beaumont, City of 782 | City 2 | City Agency 2 | Riverside 10 | 6.021 | 3 Rings Ranch Community Park | 0 | Local Park 2 | 4 | |
505 | 505 | 504 | {"type": "Polygon", "coordinates": [[[-117.1296, 32.71069], [-117.1296, 32.71124], [-117.12944, 32.71124], [-117.12944, 32.71069], [-117.1296, 32.71069]]]} | Open Access 1 | 2045 | 30th Street Mini Park | 15192 | 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 | 0.23 | 30th Street MP | 0 | Local Park 2 | 4 | |
1171 | 1171 | 1170 | {"type": "MultiPolygon", "coordinates": [[[[-117.12486, 32.71786], [-117.12437, 32.71786], [-117.12432, 32.71769], [-117.12428, 32.71748], [-117.12485, 32.71748], [-117.12486, 32.71786]]], [[[-117.12527, 32.7201], [-117.12493, 32.7201], [-117.12493, 32.71957], [-117.12459, 32.71956], [-117.12459, 32.71928], [-117.1244, 32.71927], [-117.1244, 32.71914], [-117.12521, 32.71913], [-117.12522, 32.71925], [-117.12525, 32.71926], [-117.12526, 32.71942], [-117.12527, 32.7201]]], [[[-117.1252, 32.71847], [-117.12449, 32.71847], [-117.12441, 32.71809], [-117.1252, 32.71808], [-117.1252, 32.71847]]], [[[-117.12521, 32.7189], [-117.12456, 32.71891], [-117.12452, 32.71853], [-117.12521, 32.71852], [-117.12521, 32.7189]]], [[[-117.12529, 32.72089], [-117.12494, 32.72089], [-117.12494, 32.72033], [-117.12528, 32.72032], [-117.12529, 32.72089]]], [[[-117.12597, 32.72046], [-117.12554, 32.72046], [-117.12554, 32.72028], [-117.12596, 32.72028], [-117.12597, 32.72046]]], [[[-117.12598, 32.72117], [-117.12554, 32.72117], [-117.12554, 32.72059], [-117.12597, 32.72059], [-117.12598, 32.72117]]], [[[-117.12644, 32.72134], [-117.12644, 32.72193], [-117.12597, 32.72192], [-117.12597, 32.72134], [-117.12644, 32.72134]]], [[[-117.12744, 32.72243], [-117.12743, 32.72304], [-117.12707, 32.72304], [-117.12707, 32.72292], [-117.12704, 32.72291], [-117.12704, 32.72269], [-117.12665, 32.72268], [-117.12666, 32.72243], [-117.12744, 32.72243]]], [[[-117.12744, 32.72221], [-117.12669, 32.72221], [-117.1267, 32.72179], [-117.12703, 32.7218], [-117.12704, 32.72207], [-117.12736, 32.72215], [-117.12743, 32.72215], [-117.12744, 32.72221]]], [[[-117.1283, 32.72411], [-117.12828, 32.72434], [-117.12792, 32.72434], [-117.12792, 32.72404], [-117.12829, 32.72404], [-117.1283, 32.72411]]], [[[-117.12829, 32.7239], [-117.12792, 32.72391], [-117.12792, 32.72377], [-117.12829, 32.72378], [-117.12829, 32.7239]]]]} | Open Access 1 | 7499 | 32nd Street Canyon | 15193 | 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 | 7.011 | 32nd Street Canyon | 0 | Local Recreation Area 3 | 4 | |
4151 | 4151 | 4150 | {"type": "Polygon", "coordinates": [[[-117.12552, 32.73807], [-117.12552, 32.73821], [-117.12512, 32.73821], [-117.12512, 32.73807], [-117.12552, 32.73807]]]} | Open Access 1 | 47523 | 32nd Street Mini Park | 31228 | 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 | 0.143 | 32nd Street MP | 0 | Local Park 2 | 4 | |
16145 | 16145 | 16144 | {"type": "Polygon", "coordinates": [[[-117.12447, 32.72612], [-117.12413, 32.72613], [-117.12412, 32.72547], [-117.12445, 32.72546], [-117.12447, 32.72612]]]} | Open Access 1 | 19921 | 34th St Canyon Open Space | 15194 | 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 | 0.576 | 34th St Canyon OS | 0 | Local Recreation Area 3 | 4 | |
15381 | 15381 | 15380 | {"type": "Polygon", "coordinates": [[[-118.20463, 33.81903], [-118.20462, 33.81984], [-118.20458, 33.82011], [-118.20441, 33.82001], [-118.20429, 33.81989], [-118.20428, 33.81985], [-118.20429, 33.81892], [-118.20458, 33.81893], [-118.20463, 33.81903]]]} | Open Access 1 | 46593 | 34th St Greenbelt | 29894 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.928 | 34th St Greenbelt | 2007 | Local Recreation Area 3 | 4 | |
6323 | 6323 | 6322 | {"type": "Polygon", "coordinates": [[[-122.22256, 37.7762], [-122.22252, 37.77649], [-122.22235, 37.77642], [-122.22253, 37.77619], [-122.22256, 37.7762]]]} | Open Access 1 | 13419 | 35th Avenue Plaza | 15195 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.074 | 35th Avenue Plaza | 0 | Local Park 2 | 4 | |
7314 | 7314 | 7313 | {"type": "Polygon", "coordinates": [[[-117.93517, 33.61789], [-117.93509, 33.61794], [-117.93498, 33.61796], [-117.93491, 33.61795], [-117.93482, 33.61791], [-117.93424, 33.61727], [-117.93418, 33.61712], [-117.93418, 33.61708], [-117.93421, 33.61704], [-117.93424, 33.61702], [-117.93439, 33.61697], [-117.93516, 33.61784], [-117.93517, 33.61789]]]} | Open Access 1 | 6628 | 38th Street Park | 15197 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.922 | 38th Street Park | 0 | Local Park 2 | 4 | |
6434 | 6434 | 6433 | {"type": "Polygon", "coordinates": [[[-117.10586, 32.68969], [-117.1057, 32.68969], [-117.10569, 32.68931], [-117.10586, 32.68931], [-117.10586, 32.68969]]]} | Open Access 1 | 1958 | 41st Street Mini-Park | 15201 | 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 | 0.161 | 41st Street Mini-Park | 0 | Local Park 2 | 4 | |
10 | 10 | 9 | {"type": "MultiPolygon", "coordinates": [[[[-117.09436, 32.74201], [-117.09395, 32.74201], [-117.09393, 32.74146], [-117.09346, 32.74146], [-117.09345, 32.74102], [-117.09291, 32.74017], [-117.09284, 32.74016], [-117.09282, 32.73919], [-117.09236, 32.73919], [-117.09235, 32.7385], [-117.0928, 32.73849], [-117.09279, 32.73755], [-117.09339, 32.73754], [-117.09339, 32.73696], [-117.09359, 32.73697], [-117.0936, 32.73699], [-117.0938, 32.73699], [-117.09383, 32.7391], [-117.09321, 32.73912], [-117.09324, 32.74037], [-117.09385, 32.74037], [-117.09387, 32.74118], [-117.09435, 32.74118], [-117.09436, 32.74201]]], [[[-117.09277, 32.74057], [-117.0927, 32.74058], [-117.09269, 32.74084], [-117.09238, 32.74085], [-117.09238, 32.74039], [-117.09276, 32.74038], [-117.09277, 32.74057]]], [[[-117.09497, 32.74242], [-117.09456, 32.74242], [-117.09456, 32.74223], [-117.09497, 32.74222], [-117.09497, 32.74242]]], [[[-117.09603, 32.7429], [-117.09564, 32.74291], [-117.09564, 32.7427], [-117.09603, 32.7427], [-117.09603, 32.7429]]]]} | Open Access 1 | 31 | 47th Street Canyon | 15202 | 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 | 9.994 | 47th Street Canyon | 0 | Local Recreation Area 3 | 4 | |
12125 | 12125 | 12124 | {"type": "Polygon", "coordinates": [[[-120.37312, 37.98464], [-120.37092, 37.98352], [-120.37013, 37.98316], [-120.36931, 37.98351], [-120.36816, 37.98404], [-120.36712, 37.98448], [-120.36706, 37.98392], [-120.36712, 37.98344], [-120.36852, 37.98162], [-120.37305, 37.98169], [-120.37304, 37.98224], [-120.37297, 37.98379], [-120.373, 37.98406], [-120.37308, 37.98438], [-120.37312, 37.98464]]]} | Open Access 1 | 25080 | 49'er Rotary Park | 15205 | 1448 | Sonora, City of 645 | City 2 | City Agency 2 | http://www.sonoraca.com/visitsonora/trailsparks.htm | City 2 | 1448 | Sonora, City of 635 | City 2 | City Agency 2 | Tuolumne 21 | 28.185 | 49'er Rotary Park | 0 | Local Park 2 | 4 | |
5715 | 5715 | 5714 | {"type": "Polygon", "coordinates": [[[-118.2636, 33.99857], [-118.26343, 33.99857], [-118.26343, 33.99811], [-118.2636, 33.99811], [-118.2636, 33.99857]]]} | Open Access 1 | 45781 | 49th Street Pocket Park | 28800 | 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 | http://www.laparks.org/environmental/49thStPark.htm | Los Angeles 6 | 0.189 | 49th Street PP | 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]);