units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where MNG_AGENCY = 31 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15703 | 15703 | 15702 | {"type": "Polygon", "coordinates": [[[-121.8681, 37.62662], [-121.86809, 37.62949], [-121.86746, 37.62949], [-121.86738, 37.62958], [-121.86719, 37.62974], [-121.86701, 37.62999], [-121.86704, 37.63011], [-121.86705, 37.63038], [-121.86702, 37.63046], [-121.86704, 37.63053], [-121.86733, 37.63117], [-121.86725, 37.63132], [-121.86735, 37.63136], [-121.86744, 37.63156], [-121.86696, 37.63156], [-121.86695, 37.63157], [-121.86761, 37.63321], [-121.86754, 37.63324], [-121.86752, 37.63323], [-121.86725, 37.63257], [-121.86693, 37.63267], [-121.86653, 37.63313], [-121.86542, 37.63362], [-121.86487, 37.63389], [-121.86502, 37.63417], [-121.86474, 37.63427], [-121.86444, 37.63433], [-121.86278, 37.63494], [-121.86129, 37.63491], [-121.86113, 37.63488], [-121.86098, 37.63481], [-121.86096, 37.63476], [-121.86101, 37.63462], [-121.86103, 37.6345], [-121.86102, 37.63427], [-121.86164, 37.63401], [-121.86159, 37.63348], [-121.86117, 37.63345], [-121.86142, 37.63313], [-121.86168, 37.63309], [-121.86172, 37.6331], [-121.86217, 37.63287], [-121.86227, 37.63264], [-121.86263, 37.63207], [-121.86196, 37.63105], [-121.86149, 37.6305], [-121.86094, 37.6296], [-121.8606, 37.62883], [-121.86034, 37.62882], [-121.8604, 37.62867], [-121.86042, 37.62853], [-121.86031, 37.62774], [-121.86034, 37.62758], [-121.86041, 37.6274], [-121.86028, 37.62735], [-121.8602, 37.6275], [-121.86012, 37.62748], [-121.85898, 37.62797], [-121.8579, 37.6265], [-121.85797, 37.62603], [-121.85819, 37.62589], [-121.85848, 37.62587], [-121.85881, 37.62594], [-121.85907, 37.62586], [-121.85927, 37.62573], [-121.86018, 37.62572], [-121.86054, 37.6257], [-121.86062, 37.62557], [-121.86053, 37.62523], [-121.86079, 37.62515], [-121.86085, 37.62494], [-121.86101, 37.62492], [-121.86109, 37.62488], [-121.86128, 37.62499], [-121.8615, 37.62527], [-121.86166, 37.62542], [-121.86172, 37.62559], [-121.86173, 37.62574], [-121.86216, 37.62596], [-121.86288, 37.6265], [-121.8632, 37.6266], [-121.86336, 37.62669], [-121.86347, 37.62673], [-121.86363, 37.62674], [-121.8637, 37.62672], [-121.86374, 37.62667], [-121.8637, 37.62657], [-121.86319, 37.62626], [-121.86305, 37.626], [-121.863, 37.62595], [-121.86294, 37.62586], [-121.86297, 37.62583], [-121.86306, 37.62567], [-121.86313, 37.62561], [-121.8633, 37.62559], [-121.86351, 37.62565], [-121.86358, 37.62564], [-121.86364, 37.62561], [-121.86368, 37.62557], [-121.86369, 37.6255], [-121.86372, 37.62542], [-121.86377, 37.62535], [-121.86395, 37.62528], [-121.86401, 37.62528], [-121.86409, 37.62533], [-121.86419, 37.62535], [-121.86429, 37.62545], [-121.86443, 37.62544], [-121.86454, 37.62545], [-121.86472, 37.62555], [-121.8648, 37.62584], [-121.86506, 37.62594], [-121.86516, 37.62602], [-121.86544, 37.62616], [-121.86554, 37.62628], [-121.86574, 37.62626], [-121.86579, 37.62627], [-121.86595, 37.62662], [-121.86594, 37.62664], [-121.86606, 37.6268], [-121.86624, 37.62694], [-121.86628, 37.627], [-121.86632, 37.62717], [-121.86635, 37.62719], [-121.86642, 37.6272], [-121.86662, 37.62711], [-121.8668, 37.62705], [-121.86686, 37.62702], [-121.86685, 37.62699], [-121.86696, 37.62693], [-121.86718, 37.62701], [-121.86712, 37.62739], [-121.86706, 37.62751], [-121.86716, 37.62766], [-121.86728, 37.62769], [-121.86727, 37.62785], [-121.86722, 37.62798], [-121.867, 37.62835], [-121.86685, 37.6285], [-121.86686, 37.62852], [-121.86691, 37.62854], [-121.86719, 37.6283], [-121.86731, 37.62823], [-121.86747, 37.62785], [-121.86763, 37.62771], [-121.86774, 37.62743], [-121.86791, 37.62731], [-121.868, 37.62701], [-121.86804, 37.62665], [-121.8681, 37.62662]], [[-121.86232, 37.63345], [-121.86167, 37.63343], [-121.8617, 37.63379], [-121.86179, 37.63397], [-121.8621, 37.63405], [-121.86235, 37.63398], [-121.86249, 37.6339], [-121.86248, 37.63351], [-121.86232, 37.63345]], [[-121.86638, 37.62876], [-121.86627, 37.62874], [-121.86603, 37.62888], [-121.86602, 37.62867], [-121.86589, 37.62847], [-121.86563, 37.62841], [-121.86526, 37.62842], [-121.86519, 37.62857], [-121.86521, 37.62865], [-121.86511, 37.62889], [-121.86535, 37.62917], [-121.86549, 37.6291], [-121.86562, 37.6291], [-121.86579, 37.62903], [-121.86584, 37.62932], [-121.866, 37.62918], [-121.86652, 37.62896], [-121.86638, 37.62876]]]} | Restricted Access 2 | 23675 | Callippe Preserve Golf Course | 33079 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 130.046 | Callippe Preserve GC | 0 | Local Recreation Area 3 | 4 | |
14265 | 14265 | 14264 | {"type": "Polygon", "coordinates": [[[-121.8986, 37.65004], [-121.89857, 37.65009], [-121.89765, 37.65055], [-121.89754, 37.65064], [-121.89742, 37.65077], [-121.89738, 37.65079], [-121.89687, 37.65061], [-121.89668, 37.65051], [-121.89655, 37.65036], [-121.89636, 37.65005], [-121.89639, 37.65], [-121.89668, 37.64988], [-121.89691, 37.64974], [-121.89707, 37.64962], [-121.89744, 37.64927], [-121.8976, 37.64917], [-121.89774, 37.64909], [-121.8978, 37.64911], [-121.89821, 37.64954], [-121.8986, 37.65004]]]} | Open Access 1 | 44185 | Fawn Hills Park | 18854 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 4.875 | Fawn Hills Park | 0 | Local Park 2 | 4 | |
13916 | 13916 | 13915 | {"type": "Polygon", "coordinates": [[[-121.85023, 37.68137], [-121.84817, 37.68139], [-121.84815, 37.67994], [-121.84777, 37.67993], [-121.84787, 37.67968], [-121.8483, 37.67911], [-121.84925, 37.67858], [-121.84933, 37.67753], [-121.84827, 37.67712], [-121.84772, 37.67721], [-121.8468, 37.67765], [-121.84666, 37.67735], [-121.84669, 37.67707], [-121.8464, 37.67694], [-121.84614, 37.67698], [-121.84562, 37.67737], [-121.84513, 37.67742], [-121.84497, 37.67734], [-121.84477, 37.67645], [-121.8468, 37.67577], [-121.85001, 37.67585], [-121.85023, 37.68137]]]} | Open Access 1 | 36529 | Pleasanton holding 4 | 23807 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 32.765 | Pleasanton holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13781 | 13781 | 13780 | {"type": "Polygon", "coordinates": [[[-121.86242, 37.67993], [-121.86223, 37.67999], [-121.86182, 37.68021], [-121.86175, 37.68021], [-121.86156, 37.68003], [-121.8614, 37.67992], [-121.8612, 37.67984], [-121.86096, 37.67978], [-121.86097, 37.67923], [-121.86135, 37.67899], [-121.86162, 37.67876], [-121.86169, 37.67876], [-121.86172, 37.67878], [-121.86149, 37.67898], [-121.8621, 37.67943], [-121.86221, 37.67955], [-121.86234, 37.67986], [-121.86242, 37.67993]]]} | Open Access 1 | 36328 | Pleasanton holding 1 | 23804 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 2.66 | Pleasanton holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13757 | 13757 | 13756 | {"type": "Polygon", "coordinates": [[[-121.84934, 37.67753], [-121.84925, 37.67858], [-121.8483, 37.67911], [-121.84787, 37.67968], [-121.84777, 37.67993], [-121.84555, 37.67995], [-121.84497, 37.67734], [-121.84513, 37.67742], [-121.84562, 37.67737], [-121.84614, 37.67698], [-121.8464, 37.67694], [-121.84669, 37.67707], [-121.84666, 37.67735], [-121.84681, 37.67764], [-121.84772, 37.67721], [-121.84827, 37.67712], [-121.84934, 37.67753]]]} | Open Access 1 | 36272 | Pleasanton holding 3 | 23806 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 22.762 | Pleasanton holding 3 | 0 | Local Other or Unknown 14 | 4 | |
12099 | 12099 | 12098 | {"type": "Polygon", "coordinates": [[[-121.91451, 37.66298], [-121.9139, 37.66231], [-121.91367, 37.66208], [-121.91168, 37.66028], [-121.91138, 37.65999], [-121.91113, 37.65971], [-121.9109, 37.65941], [-121.91052, 37.65879], [-121.91106, 37.65944], [-121.91312, 37.66055], [-121.91371, 37.66114], [-121.91422, 37.66235], [-121.91451, 37.66282], [-121.91451, 37.66298]]]} | Open Access 1 | 24929 | Adobe Park | 15272 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 5.76 | Adobe Park | 0 | Local Park 2 | 4 | |
11575 | 11575 | 11574 | {"type": "Polygon", "coordinates": [[[-121.93836, 37.69196], [-121.93762, 37.69268], [-121.93722, 37.6928], [-121.93685, 37.69281], [-121.93661, 37.69292], [-121.93487, 37.69179], [-121.93427, 37.69086], [-121.93388, 37.69013], [-121.93406, 37.69], [-121.93436, 37.69028], [-121.93449, 37.69038], [-121.93466, 37.69047], [-121.93499, 37.69058], [-121.93548, 37.69065], [-121.93578, 37.69074], [-121.93707, 37.69133], [-121.93731, 37.69142], [-121.93763, 37.6915], [-121.93784, 37.69159], [-121.93809, 37.69173], [-121.93836, 37.69196]]]} | Open Access 1 | 23670 | Laurel Creek Park and Staging Area | 21092 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 13.056 | Laurel Creek Park and Staging Area | None 1032 | |||
11569 | 11569 | 11568 | {"type": "Polygon", "coordinates": [[[-121.85913, 37.66996], [-121.85864, 37.67006], [-121.85845, 37.66932], [-121.85888, 37.66925], [-121.85913, 37.66996]]]} | Open Access 1 | 23664 | BMX Facility | 16201 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 0.847 | BMX Facility | None 1030 | |||
9452 | 9452 | 9451 | {"type": "Polygon", "coordinates": [[[-121.87721, 37.67438], [-121.87705, 37.6744], [-121.87693, 37.67448], [-121.87685, 37.67458], [-121.87492, 37.67454], [-121.87477, 37.67435], [-121.87417, 37.67454], [-121.87339, 37.67466], [-121.87279, 37.67287], [-121.87277, 37.67231], [-121.87485, 37.67227], [-121.87479, 37.67327], [-121.87616, 37.67387], [-121.87718, 37.67366], [-121.87721, 37.67438]]]} | Open Access 1 | 15809 | Amador Valley Community Park | 15435 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 14.984 | Amador Valley Community Park | 0 | Local Park 2 | 4 | |
9289 | 9289 | 9288 | {"type": "Polygon", "coordinates": [[[-121.85656, 37.66294], [-121.85641, 37.66331], [-121.85608, 37.66315], [-121.85569, 37.66322], [-121.85554, 37.66342], [-121.8556, 37.66364], [-121.85545, 37.66393], [-121.85512, 37.66409], [-121.85492, 37.66412], [-121.8546, 37.66419], [-121.85432, 37.66405], [-121.85418, 37.66405], [-121.85397, 37.66408], [-121.85398, 37.6634], [-121.85656, 37.66294]]]} | Open Access 1 | 15475 | Tawny Park | 26198 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 3.542 | Tawny Park | 0 | Local Park 2 | 4 | |
9286 | 9286 | 9285 | {"type": "Polygon", "coordinates": [[[-121.86652, 37.65941], [-121.86612, 37.66004], [-121.86508, 37.65957], [-121.86553, 37.65894], [-121.86652, 37.65941]]]} | Open Access 1 | 15469 | McKinley Park | 22047 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 2.047 | McKinley Park | 0 | Local Park 2 | 4 | |
9282 | 9282 | 9281 | {"type": "Polygon", "coordinates": [[[-121.87494, 37.65914], [-121.87422, 37.6598], [-121.87396, 37.65962], [-121.87468, 37.65896], [-121.87494, 37.65914]]]} | Open Access 1 | 15463 | Delucchi Park | 18079 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 0.731 | Delucchi Park | 0 | Local Park 2 | 4 | |
9277 | 9277 | 9276 | {"type": "Polygon", "coordinates": [[[-121.8838, 37.66917], [-121.88337, 37.66981], [-121.88292, 37.66957], [-121.88313, 37.66928], [-121.88296, 37.66872], [-121.88345, 37.66858], [-121.8838, 37.66917]]]} | Open Access 1 | 15452 | Harvest Park | 19723 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 1.567 | Harvest Park | 0 | Local Park 2 | 4 | |
9276 | 9276 | 9275 | {"type": "Polygon", "coordinates": [[[-121.88627, 37.67414], [-121.88627, 37.67462], [-121.88625, 37.67466], [-121.88621, 37.67468], [-121.88577, 37.67469], [-121.88559, 37.67473], [-121.88544, 37.67479], [-121.88525, 37.67491], [-121.88509, 37.67508], [-121.88499, 37.67527], [-121.88495, 37.67548], [-121.88451, 37.67547], [-121.88458, 37.67544], [-121.88462, 37.6754], [-121.88463, 37.67516], [-121.8847, 37.67509], [-121.88472, 37.67501], [-121.88468, 37.67491], [-121.88458, 37.67485], [-121.88458, 37.67469], [-121.8843, 37.67468], [-121.88431, 37.67456], [-121.88448, 37.67442], [-121.88448, 37.67414], [-121.88627, 37.67414]]]} | Open Access 1 | 15449 | Walnut Grove Park | 27231 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 3.453 | Walnut Grove Park | 0 | Local Park 2 | 4 | |
9274 | 9274 | 9273 | {"type": "Polygon", "coordinates": [[[-121.89538, 37.67097], [-121.89482, 37.67152], [-121.89403, 37.67123], [-121.89309, 37.67062], [-121.89239, 37.66998], [-121.8933, 37.66949], [-121.89367, 37.66993], [-121.89538, 37.67097]]]} | Open Access 1 | 15443 | Hansen Park | 19650 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 5.898 | Hansen Park | 0 | Local Park 2 | 4 | |
9273 | 9273 | 9272 | {"type": "Polygon", "coordinates": [[[-121.90762, 37.66974], [-121.90641, 37.67016], [-121.90629, 37.66994], [-121.90608, 37.66966], [-121.90591, 37.66939], [-121.90574, 37.66904], [-121.90569, 37.66872], [-121.90696, 37.66847], [-121.90762, 37.66974]]]} | Open Access 1 | 15440 | Del Prado Park | 18047 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 4.872 | Del Prado Park | 0 | Local Park 2 | 4 | |
9271 | 9271 | 9270 | {"type": "Polygon", "coordinates": [[[-121.91123, 37.66511], [-121.90939, 37.66585], [-121.90889, 37.66483], [-121.90929, 37.66467], [-121.90961, 37.66481], [-121.91004, 37.6649], [-121.91048, 37.66487], [-121.91099, 37.66471], [-121.91123, 37.66511]]]} | Open Access 1 | 15437 | Meadowlark Park | 22090 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 3.577 | Meadowlark Park | 0 | Local Park 2 | 4 | |
9268 | 9268 | 9267 | {"type": "Polygon", "coordinates": [[[-121.92999, 37.6877], [-121.92972, 37.68758], [-121.92907, 37.68769], [-121.92859, 37.68768], [-121.92791, 37.68645], [-121.92834, 37.68629], [-121.92864, 37.68598], [-121.92872, 37.68555], [-121.92939, 37.68495], [-121.92942, 37.685], [-121.92968, 37.68637], [-121.92999, 37.6877]]]} | Open Access 1 | 15429 | Moller Park | 22361 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 7.634 | Moller Park | 0 | Local Park 2 | 4 | |
9265 | 9265 | 9264 | {"type": "Polygon", "coordinates": [[[-121.87743, 37.66136], [-121.87705, 37.66208], [-121.87682, 37.66199], [-121.87683, 37.66197], [-121.87682, 37.66193], [-121.87705, 37.66136], [-121.87711, 37.66126], [-121.87743, 37.66136]]]} | Open Access 1 | 15455 | Veterans Plaza | 27060 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 0.595 | Veterans Plaza | 0 | Local Park 2 | 4 | |
9260 | 9260 | 9259 | {"type": "Polygon", "coordinates": [[[-121.9149, 37.68359], [-121.91517, 37.6843], [-121.91517, 37.68433], [-121.91515, 37.68437], [-121.91335, 37.68473], [-121.91322, 37.6848], [-121.91317, 37.68487], [-121.91318, 37.68496], [-121.91443, 37.68894], [-121.91445, 37.68905], [-121.91443, 37.68916], [-121.91438, 37.68926], [-121.91429, 37.68934], [-121.91419, 37.6894], [-121.91403, 37.68946], [-121.91317, 37.68963], [-121.91246, 37.68738], [-121.91255, 37.68714], [-121.91216, 37.68589], [-121.91208, 37.68571], [-121.91199, 37.68554], [-121.91187, 37.68538], [-121.91174, 37.68523], [-121.91158, 37.68509], [-121.91138, 37.68496], [-121.91111, 37.68488], [-121.91119, 37.68448], [-121.91126, 37.68429], [-121.91136, 37.6841], [-121.91149, 37.68392], [-121.91156, 37.68384], [-121.91163, 37.68385], [-121.91196, 37.68404], [-121.91209, 37.68415], [-121.91216, 37.68418], [-121.91224, 37.68419], [-121.91238, 37.68414], [-121.91251, 37.684], [-121.91271, 37.68387], [-121.91293, 37.68377], [-121.91319, 37.6837], [-121.91331, 37.68399], [-121.9149, 37.68359]]]} | Open Access 1 | 15423 | Val Vista Park | 26757 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 23.865 | Val Vista 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]);