units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
99 rows where DES_TP = 2 and MNG_AGENCY = 56 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AG_TYP 1
- City Agency 99
MNG_AGENCY 1
- Oakland, City of · 99 ✖
DES_TP 1
- Local Park · 99 ✖
ACCESS_TYP 1
- Open Access 99
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9932 | 9932 | 9931 | {"type": "Polygon", "coordinates": [[[-122.20157, 37.81532], [-122.20142, 37.81555], [-122.2014, 37.81576], [-122.20146, 37.8158], [-122.20146, 37.81584], [-122.20097, 37.8158], [-122.20056, 37.81601], [-122.20054, 37.81613], [-122.20019, 37.81597], [-122.19965, 37.8158], [-122.19955, 37.81598], [-122.19942, 37.81587], [-122.19921, 37.81575], [-122.19877, 37.81564], [-122.19877, 37.81557], [-122.1987, 37.81546], [-122.19863, 37.8154], [-122.19703, 37.81651], [-122.19701, 37.81655], [-122.19704, 37.81659], [-122.19676, 37.81653], [-122.19667, 37.81649], [-122.19724, 37.81594], [-122.19699, 37.81577], [-122.19615, 37.81537], [-122.19595, 37.81551], [-122.1959, 37.81548], [-122.19575, 37.81537], [-122.19547, 37.81505], [-122.19536, 37.81498], [-122.19526, 37.81494], [-122.19439, 37.81472], [-122.19421, 37.81495], [-122.19414, 37.8151], [-122.19397, 37.81504], [-122.19377, 37.815], [-122.19359, 37.81499], [-122.1933, 37.81499], [-122.19336, 37.81472], [-122.19312, 37.81468], [-122.19285, 37.81469], [-122.19258, 37.81466], [-122.19247, 37.8149], [-122.19182, 37.81483], [-122.1918, 37.81498], [-122.19231, 37.81504], [-122.19168, 37.81531], [-122.19109, 37.81532], [-122.19078, 37.81542], [-122.19056, 37.81561], [-122.19054, 37.81622], [-122.19, 37.81646], [-122.18994, 37.81683], [-122.18964, 37.81712], [-122.1895, 37.81732], [-122.18933, 37.81745], [-122.189, 37.81788], [-122.18886, 37.81809], [-122.18858, 37.81855], [-122.18853, 37.81871], [-122.18854, 37.81883], [-122.18857, 37.81893], [-122.18885, 37.81928], [-122.18889, 37.81942], [-122.18871, 37.8198], [-122.18861, 37.81985], [-122.18856, 37.81986], [-122.18761, 37.81989], [-122.18747, 37.82002], [-122.18749, 37.8204], [-122.18742, 37.82057], [-122.18705, 37.82107], [-122.18682, 37.82133], [-122.18687, 37.82208], [-122.18558, 37.82072], [-122.1854, 37.8207], [-122.18543, 37.82053], [-122.18442, 37.82041], [-122.18438, 37.82057], [-122.18359, 37.82048], [-122.1812, 37.81931], [-122.18035, 37.81815], [-122.1784, 37.81671], [-122.17548, 37.81459], [-122.17433, 37.81083], [-122.17322, 37.81037], [-122.17377, 37.80952], [-122.17445, 37.8098], [-122.17561, 37.80792], [-122.17558, 37.80775], [-122.1756, 37.80762], [-122.17565, 37.80748], [-122.17579, 37.80731], [-122.17599, 37.80718], [-122.17624, 37.80711], [-122.1765, 37.8071], [-122.1767, 37.80713], [-122.17777, 37.80667], [-122.17851, 37.80577], [-122.1785, 37.80568], [-122.17851, 37.80554], [-122.17856, 37.8054], [-122.17865, 37.80528], [-122.17883, 37.80513], [-122.17898, 37.80506], [-122.17913, 37.80502], [-122.17917, 37.80497], [-122.178, 37.8037], [-122.1784, 37.80395], [-122.17912, 37.80431], [-122.17949, 37.80507], [-122.1796, 37.80546], [-122.17974, 37.80607], [-122.17954, 37.80716], [-122.18001, 37.80727], [-122.18037, 37.8078], [-122.18048, 37.80862], [-122.18084, 37.80901], [-122.18212, 37.80963], [-122.18494, 37.80969], [-122.18573, 37.80942], [-122.18697, 37.8093], [-122.18763, 37.80938], [-122.18781, 37.80945], [-122.18775, 37.80957], [-122.18775, 37.80958], [-122.1883, 37.80978], [-122.18855, 37.80984], [-122.18874, 37.80988], [-122.18897, 37.80989], [-122.1892, 37.80988], [-122.19067, 37.80971], [-122.19101, 37.80972], [-122.1913, 37.80979], [-122.19153, 37.80987], [-122.19242, 37.81032], [-122.19284, 37.81049], [-122.19327, 37.81061], [-122.1945, 37.81086], [-122.19414, 37.81112], [-122.19377, 37.81171], [-122.19425, 37.8119], [-122.19396, 37.81239], [-122.19457, 37.81263], [-122.1939, 37.81371], [-122.1939, 37.81373], [-122.19462, 37.81392], [-122.195, 37.81392], [-122.19516, 37.81398], [-122.19545, 37.814], [-122.19569, 37.81406], [-122.19589, 37.81394], [-122.19595, 37.81396], [-122.19629, 37.81394], [-122.19665, 37.81407], [-122.19701, 37.81431], [-122.1973, 37.81459], [-122.19757, 37.81475], [-122.19785, 37.81479], [-122.19772, 37.81488], [-122.19782, 37.81496], [-122.19828, 37.81491], [-122.19837, 37.81497], [-122.1986, 37.81499], [-122.19877, 37.81504], [-122.19887, 37.81514], [-122.19901, 37.81517], [-122.19903, 37.8152], [-122.20076, 37.81408], [-122.20117, 37.81462], [-122.20156, 37.81526], [-122.20157, 37.81532]], [[-122.18548, 37.81936], [-122.18548, 37.81934], [-122.18537, 37.81927], [-122.1853, 37.81917], [-122.18527, 37.81909], [-122.18525, 37.81892], [-122.18522, 37.81884], [-122.18518, 37.81875], [-122.1851, 37.81868], [-122.18501, 37.81863], [-122.1849, 37.8186], [-122.18467, 37.81859], [-122.18446, 37.81861], [-122.18429, 37.81865], [-122.18418, 37.81871], [-122.1841, 37.81879], [-122.18405, 37.8189], [-122.18405, 37.81898], [-122.18407, 37.81907], [-122.18411, 37.81915], [-122.18429, 37.8194], [-122.1843, 37.81945], [-122.1843, 37.8195], [-122.18424, 37.81956], [-122.18416, 37.8196], [-122.18408, 37.8196], [-122.18395, 37.81957], [-122.18382, 37.81951], [-122.18312, 37.81911], [-122.18302, 37.819], [-122.18276, 37.8186], [-122.18265, 37.81849], [-122.18253, 37.81842], [-122.18225, 37.81827], [-122.18203, 37.81818], [-122.18183, 37.81813], [-122.18141, 37.81804], [-122.18122, 37.81797], [-122.18109, 37.8179], [-122.18092, 37.81777], [-122.18077, 37.81763], [-122.18065, 37.81748], [-122.18059, 37.81761], [-122.18067, 37.81771], [-122.18085, 37.81788], [-122.18101, 37.818], [-122.18116, 37.81808], [-122.18136, 37.81815], [-122.18177, 37.81823], [-122.18199, 37.8183], [-122.18227, 37.81842], [-122.18254, 37.81857], [-122.18267, 37.81869], [-122.18289, 37.81906], [-122.18301, 37.81918], [-122.1831, 37.81925], [-122.18375, 37.81961], [-122.1839, 37.81967], [-122.18407, 37.81971], [-122.1842, 37.81971], [-122.18433, 37.81966], [-122.18442, 37.81956], [-122.18445, 37.81948], [-122.18443, 37.81938], [-122.18423, 37.81907], [-122.18419, 37.81893], [-122.18422, 37.81885], [-122.18427, 37.81879], [-122.18434, 37.81875], [-122.18445, 37.81873], [-122.18461, 37.81871], [-122.1848, 37.81871], [-122.18492, 37.81872], [-122.18499, 37.81875], [-122.18504, 37.8188], [-122.18508, 37.81888], [-122.18513, 37.81914], [-122.18521, 37.81929], [-122.18535, 37.81942], [-122.18548, 37.81936]]]} | Open Access 1 | 17088 | Joaquin Miller Park | 7825 | 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 | http://www2.oaklandnet.com/Government/o/opr/s/Parks/JoaquinMiller/ | Alameda 17 | 438.978 | Joaquin Miller Park | 1917 | 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 | |
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 | |
8534 | 8534 | 8533 | {"type": "Polygon", "coordinates": [[[-122.17361, 37.75533], [-122.17331, 37.75544], [-122.17312, 37.7551], [-122.1734, 37.755], [-122.17361, 37.75533]]]} | Open Access 1 | 13413 | 85th Avenue Mini Park | 15217 | 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.291 | 85th Avenue MP | 0 | Local Park 2 | 4 | |
7466 | 7466 | 7465 | {"type": "Polygon", "coordinates": [[[-122.17152, 37.75333], [-122.17114, 37.7535], [-122.17092, 37.75318], [-122.1713, 37.75301], [-122.17152, 37.75333]]]} | Open Access 1 | 15669 | 88th Avenue Mini Park | 15218 | 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.384 | 88th Avenue MP | 0 | Local Park 2 | 4 | |
9188 | 9188 | 9187 | {"type": "Polygon", "coordinates": [[[-122.26214, 37.81105], [-122.26189, 37.81169], [-122.26104, 37.81169], [-122.2609, 37.81082], [-122.26151, 37.81091], [-122.26214, 37.81105]]]} | Open Access 1 | 15254 | Adams Park | 15262 | 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 | 1.952 | Adams Park | 0 | Local Park 2 | 4 | |
8531 | 8531 | 8530 | {"type": "Polygon", "coordinates": [[[-122.20445, 37.78919], [-122.20338, 37.78987], [-122.203, 37.78953], [-122.20327, 37.78933], [-122.20319, 37.78923], [-122.2033, 37.78914], [-122.20373, 37.78848], [-122.20445, 37.78919]]]} | Open Access 1 | 13401 | Allendale Park | 15380 | 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 | 2.22 | Allendale Park | 0 | Local Park 2 | 4 | |
2458 | 2458 | 2457 | {"type": "Polygon", "coordinates": [[[-122.17762, 37.76178], [-122.17531, 37.76327], [-122.17401, 37.76158], [-122.17408, 37.76156], [-122.17414, 37.76151], [-122.17415, 37.76144], [-122.17413, 37.76138], [-122.17405, 37.76132], [-122.17392, 37.76131], [-122.17367, 37.76098], [-122.17577, 37.75997], [-122.17762, 37.76178]]]} | Open Access 1 | 17382 | Arroyo Viejo Park | 15635 | 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 | 16.302 | Arroyo Viejo Park | 0 | Local Park 2 | 4 | |
12102 | 12102 | 12101 | {"type": "Polygon", "coordinates": [[[-122.25489, 37.79992], [-122.25459, 37.80007], [-122.25445, 37.80018], [-122.25432, 37.80033], [-122.25428, 37.80035], [-122.25424, 37.80034], [-122.25395, 37.80025], [-122.25392, 37.80021], [-122.25392, 37.80017], [-122.25439, 37.79946], [-122.25489, 37.7999], [-122.25489, 37.79992]]]} | Open Access 1 | 24941 | Athol Plaza Park | 15669 | 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 | 1.009 | Athol Plaza Park | 0 | Local Park 2 | 4 | |
9308 | 9308 | 9307 | {"type": "Polygon", "coordinates": [[[-122.19271, 37.80049], [-122.19222, 37.80069], [-122.19223, 37.80074], [-122.19163, 37.80082], [-122.19163, 37.8007], [-122.19166, 37.80061], [-122.19171, 37.80053], [-122.19181, 37.80044], [-122.19203, 37.80032], [-122.19249, 37.80017], [-122.19271, 37.80049]]]} | Open Access 1 | 15515 | Avenue Terrance Park | 15726 | 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.925 | Avenue Terrance Park | 0 | Local Park 2 | 4 | |
9311 | 9311 | 9310 | {"type": "Polygon", "coordinates": [[[-122.22879, 37.80296], [-122.22874, 37.80319], [-122.22866, 37.8032], [-122.2286, 37.8034], [-122.22866, 37.80346], [-122.22861, 37.80361], [-122.22813, 37.80352], [-122.22803, 37.80397], [-122.22751, 37.80389], [-122.22783, 37.80276], [-122.22879, 37.80296]]]} | Open Access 1 | 15518 | Beaumont Park | 15940 | 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 | 2.163 | Beaumont Park | 0 | Local Park 2 | 4 | |
5428 | 5428 | 5427 | {"type": "Polygon", "coordinates": [[[-122.2734, 37.81151], [-122.27319, 37.81157], [-122.27305, 37.81166], [-122.27319, 37.81109], [-122.27321, 37.81107], [-122.27324, 37.81107], [-122.27326, 37.81109], [-122.2734, 37.81151]]]} | Open Access 1 | 24942 | Begin Plaza Park | 15954 | 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.248 | Begin Plaza Park | 0 | Local Park 2 | 4 | |
5425 | 5425 | 5424 | {"type": "Polygon", "coordinates": [[[-122.23869, 37.79974], [-122.23813, 37.80013], [-122.23755, 37.79959], [-122.23809, 37.79919], [-122.23869, 37.79974]]]} | Open Access 1 | 13302 | Bella Vista Park | 15981 | 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 | 1.284 | Bella Vista Park | 0 | Local Park 2 | 4 | |
9243 | 9243 | 9242 | {"type": "Polygon", "coordinates": [[[-122.17895, 37.73253], [-122.17879, 37.73285], [-122.17879, 37.73286], [-122.17869, 37.73296], [-122.17862, 37.73298], [-122.17826, 37.73236], [-122.17857, 37.73236], [-122.17895, 37.73253]]]} | Open Access 1 | 15521 | Carney Park | 16886 | 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.559 | Carney Park | 0 | Local Park 2 | 4 | |
1782 | 1782 | 1781 | {"type": "Polygon", "coordinates": [[[-122.2254, 37.79572], [-122.22488, 37.79726], [-122.2254, 37.79739], [-122.22534, 37.79752], [-122.22512, 37.79788], [-122.22476, 37.79824], [-122.22455, 37.79614], [-122.22445, 37.7959], [-122.22414, 37.79575], [-122.22369, 37.79573], [-122.22272, 37.79592], [-122.22233, 37.79614], [-122.22223, 37.79636], [-122.22215, 37.79767], [-122.2213, 37.79752], [-122.22212, 37.79528], [-122.22285, 37.79546], [-122.22296, 37.79513], [-122.2254, 37.79572]]]} | Open Access 1 | 13342 | Central Reservoir Park | 17073 | 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 | 9.124 | Central Reservoir Park | 0 | Local Park 2 | 4 | |
3517 | 3517 | 3516 | {"type": "Polygon", "coordinates": [[[-122.21848, 37.77884], [-122.21773, 37.77981], [-122.21745, 37.77956], [-122.21813, 37.77872], [-122.21827, 37.77848], [-122.21752, 37.77811], [-122.2176, 37.778], [-122.21846, 37.77842], [-122.21848, 37.77884]]]} | Open Access 1 | 13356 | Cesar Chavez Park | 17097 | 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 | 1.518 | Cesar Chavez Park | 0 | Local Park 2 | 4 | |
9313 | 9313 | 9312 | {"type": "Polygon", "coordinates": [[[-122.24204, 37.85062], [-122.23984, 37.85093], [-122.23982, 37.85109], [-122.2391, 37.85125], [-122.23883, 37.8512], [-122.23693, 37.85067], [-122.23681, 37.85044], [-122.23681, 37.85023], [-122.23658, 37.84995], [-122.23623, 37.84978], [-122.23624, 37.84932], [-122.23667, 37.84953], [-122.23731, 37.84991], [-122.23785, 37.85015], [-122.23846, 37.85028], [-122.23905, 37.85035], [-122.24001, 37.85032], [-122.2408, 37.85019], [-122.24128, 37.85007], [-122.24168, 37.84993], [-122.24196, 37.84972], [-122.24204, 37.85062]]]} | Open Access 1 | 15527 | Chabot Park | 17109 | 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 | 10.307 | Chabot Park | 1961 | Local Park 2 | 4 | |
8494 | 8494 | 8493 | {"type": "Polygon", "coordinates": [[[-122.26277, 37.79503], [-122.26265, 37.79521], [-122.26225, 37.79504], [-122.26118, 37.79682], [-122.25982, 37.79631], [-122.25937, 37.79601], [-122.25689, 37.79375], [-122.25807, 37.79295], [-122.25956, 37.79323], [-122.26015, 37.79275], [-122.26028, 37.79248], [-122.26063, 37.79208], [-122.2611, 37.792], [-122.26168, 37.79229], [-122.26185, 37.79209], [-122.26272, 37.79287], [-122.26204, 37.79397], [-122.26183, 37.79427], [-122.26277, 37.79503]]]} | Open Access 1 | 13280 | Channel Park | 17121 | 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 | 37.379 | Channel Park | 0 | Local Park 2 | 4 | |
1779 | 1779 | 1778 | {"type": "Polygon", "coordinates": [[[-122.27241, 37.80487], [-122.27205, 37.80548], [-122.27156, 37.80529], [-122.27141, 37.80474], [-122.27152, 37.80454], [-122.27241, 37.80487]]]} | Open Access 1 | 13266 | City Hall Plaza | 17298 | 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 | 1.331 | City Hall Plaza | 0 | Local Park 2 | 4 | |
8522 | 8522 | 8521 | {"type": "Polygon", "coordinates": [[[-122.25792, 37.84756], [-122.2579, 37.8476], [-122.25786, 37.84762], [-122.25741, 37.84767], [-122.25737, 37.84765], [-122.25735, 37.84762], [-122.25734, 37.84745], [-122.25736, 37.84742], [-122.2574, 37.8474], [-122.25781, 37.84735], [-122.25789, 37.84739], [-122.25792, 37.84756]]]} | Open Access 1 | 13441 | Colby Park | 17479 | 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.357 | Colby 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]);