units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
54 rows where DES_TP = 2 and MNG_AGENCY = 462 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER
AGNCY_TYP 2 ✖
MNG_AG_TYP 1
- City Agency 54
MNG_AGENCY 1
- Clovis, City of · 54 ✖
DES_TP 1
- Local Park · 54 ✖
ACCESS_TYP 1
- Open Access 54
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10457 | 10457 | 10456 | {"type": "MultiPolygon", "coordinates": [[[[-119.65091, 36.79722], [-119.65091, 36.79784], [-119.65005, 36.79784], [-119.65005, 36.79766], [-119.65008, 36.79749], [-119.65008, 36.79719], [-119.65013, 36.79715], [-119.65062, 36.79715], [-119.65087, 36.79719], [-119.65091, 36.79722]]], [[[-119.65111, 36.79636], [-119.65092, 36.79659], [-119.65082, 36.79672], [-119.6507, 36.79702], [-119.6505, 36.79701], [-119.6505, 36.79654], [-119.65083, 36.79654], [-119.65102, 36.79631], [-119.65111, 36.79636]]]]} | Open Access 1 | 48583 | East West Park | 33293 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.827 | East West Park | 0 | Local Park 2 | 4 | |
10471 | 10471 | 10470 | {"type": "MultiPolygon", "coordinates": [[[[-119.65208, 36.79225], [-119.65208, 36.79231], [-119.65203, 36.79235], [-119.65131, 36.79235], [-119.65126, 36.7923], [-119.65126, 36.79225], [-119.65208, 36.79225]]], [[[-119.65294, 36.79232], [-119.65294, 36.7924], [-119.65279, 36.7924], [-119.65273, 36.79242], [-119.65228, 36.79238], [-119.65225, 36.79226], [-119.65273, 36.79226], [-119.65294, 36.79232]]], [[[-119.65109, 36.792], [-119.65109, 36.7923], [-119.65104, 36.79235], [-119.65025, 36.79234], [-119.64996, 36.79228], [-119.64946, 36.79221], [-119.64938, 36.79223], [-119.64932, 36.79227], [-119.64908, 36.79223], [-119.64845, 36.79223], [-119.64833, 36.79229], [-119.64825, 36.79228], [-119.64815, 36.79232], [-119.64797, 36.79232], [-119.64783, 36.79238], [-119.64758, 36.79265], [-119.64731, 36.7929], [-119.64718, 36.79281], [-119.64745, 36.79256], [-119.6477, 36.79229], [-119.64776, 36.7923], [-119.64784, 36.79228], [-119.64789, 36.79225], [-119.64793, 36.79219], [-119.64821, 36.79216], [-119.64843, 36.79211], [-119.64917, 36.7921], [-119.64994, 36.79199], [-119.65109, 36.792]]], [[[-119.64718, 36.793], [-119.64648, 36.79352], [-119.64647, 36.79366], [-119.64621, 36.79366], [-119.64621, 36.79344], [-119.64632, 36.79344], [-119.64705, 36.7929], [-119.64718, 36.793]]]]} | Open Access 1 | 48585 | Camden Place Park | 33295 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 2.905 | Camden Place Park | 0 | Local Park 2 | 4 | |
2466 | 2466 | 2465 | {"type": "MultiPolygon", "coordinates": [[[[-119.66748, 36.82655], [-119.66743, 36.82659], [-119.66445, 36.82655], [-119.66409, 36.82656], [-119.66413, 36.82635], [-119.66427, 36.82638], [-119.6648, 36.82638], [-119.66523, 36.82635], [-119.66698, 36.82636], [-119.66746, 36.82639], [-119.66748, 36.82655]]], [[[-119.66833, 36.8264], [-119.66833, 36.82657], [-119.6677, 36.82659], [-119.66766, 36.82655], [-119.66765, 36.8264], [-119.66833, 36.8264]]], [[[-119.67176, 36.82639], [-119.67176, 36.82661], [-119.66854, 36.82659], [-119.66856, 36.82651], [-119.67025, 36.82651], [-119.67041, 36.82647], [-119.67068, 36.82639], [-119.67176, 36.82639]]], [[[-119.67278, 36.82662], [-119.67195, 36.82662], [-119.67196, 36.8265], [-119.67277, 36.82651], [-119.67278, 36.82662]]], [[[-119.67733, 36.82651], [-119.67724, 36.82653], [-119.67708, 36.8265], [-119.67473, 36.82648], [-119.67452, 36.82651], [-119.67427, 36.82657], [-119.67407, 36.82659], [-119.67382, 36.82658], [-119.67365, 36.82654], [-119.67354, 36.82657], [-119.67311, 36.82658], [-119.6731, 36.8264], [-119.67733, 36.82644], [-119.67733, 36.82651]]], [[[-119.67925, 36.82664], [-119.67921, 36.82667], [-119.67768, 36.82665], [-119.6776, 36.82664], [-119.67751, 36.82658], [-119.67751, 36.82644], [-119.67924, 36.82646], [-119.67925, 36.82664]]], [[[-119.68064, 36.82669], [-119.67943, 36.82668], [-119.67943, 36.82645], [-119.68063, 36.82647], [-119.68064, 36.82669]]]]} | Open Access 1 | 17415 | Linear Park | 21305 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 5.959 | Linear Park | 0 | Local Park 2 | 4 | |
9386 | 9386 | 9385 | {"type": "MultiPolygon", "coordinates": [[[[-119.66768, 36.86208], [-119.66783, 36.86235], [-119.66787, 36.86248], [-119.66788, 36.86262], [-119.66783, 36.86282], [-119.66762, 36.86316], [-119.66757, 36.86318], [-119.66742, 36.86314], [-119.66726, 36.86311], [-119.66691, 36.86311], [-119.66684, 36.86309], [-119.66676, 36.86303], [-119.66667, 36.86301], [-119.66658, 36.86302], [-119.6665, 36.86309], [-119.66616, 36.86303], [-119.66617, 36.86222], [-119.66621, 36.86219], [-119.66677, 36.86219], [-119.66703, 36.86216], [-119.6673, 36.86216], [-119.66749, 36.86213], [-119.66768, 36.86208]]], [[[-119.67269, 36.86285], [-119.67267, 36.86289], [-119.67255, 36.86295], [-119.67248, 36.86302], [-119.67241, 36.86315], [-119.67241, 36.86324], [-119.67244, 36.86333], [-119.67255, 36.86348], [-119.67252, 36.86356], [-119.67215, 36.86343], [-119.67213, 36.86336], [-119.67207, 36.86331], [-119.67198, 36.86329], [-119.67192, 36.86329], [-119.67159, 36.86315], [-119.6712, 36.86324], [-119.67118, 36.8632], [-119.67113, 36.86314], [-119.67108, 36.86312], [-119.67099, 36.86311], [-119.67089, 36.86316], [-119.67084, 36.86324], [-119.67053, 36.86319], [-119.67023, 36.86324], [-119.67021, 36.8632], [-119.67017, 36.86314], [-119.67012, 36.86312], [-119.67003, 36.86311], [-119.66993, 36.86314], [-119.66988, 36.8632], [-119.66987, 36.86324], [-119.66956, 36.86318], [-119.66925, 36.86324], [-119.66923, 36.86319], [-119.66918, 36.86313], [-119.66906, 36.8631], [-119.66898, 36.86313], [-119.66891, 36.86318], [-119.66859, 36.86324], [-119.66859, 36.86343], [-119.66852, 36.86343], [-119.66855, 36.86336], [-119.66854, 36.86331], [-119.66847, 36.86324], [-119.66839, 36.86321], [-119.6683, 36.86322], [-119.66795, 36.86313], [-119.66809, 36.86288], [-119.66851, 36.86299], [-119.66895, 36.86287], [-119.66901, 36.86292], [-119.66908, 36.86295], [-119.6698, 36.86295], [-119.66989, 36.86293], [-119.66998, 36.86301], [-119.67066, 36.86301], [-119.67076, 36.86294], [-119.67084, 36.86296], [-119.67215, 36.86296], [-119.67224, 36.86293], [-119.6723, 36.86285], [-119.67269, 36.86285]]]]} | Open Access 1 | 17187 | Deauville Park | 17982 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 6.722 | Deauville Park | 0 | Local Park 2 | 4 | |
10432 | 10432 | 10431 | {"type": "MultiPolygon", "coordinates": [[[[-119.70632, 36.86297], [-119.7063, 36.86309], [-119.70618, 36.86318], [-119.70604, 36.86324], [-119.70605, 36.86297], [-119.70632, 36.86297]]], [[[-119.70745, 36.86319], [-119.70703, 36.86364], [-119.70606, 36.86364], [-119.70606, 36.86342], [-119.70611, 36.86337], [-119.70621, 36.86333], [-119.7063, 36.86328], [-119.70642, 36.86318], [-119.70672, 36.86311], [-119.70733, 36.86312], [-119.70743, 36.86313], [-119.70745, 36.86319]]]]} | Open Access 1 | 48574 | Lennar Park | 33284 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.495 | Lennar Park | 0 | Local Park 2 | 4 | |
11453 | 11453 | 11452 | {"type": "Polygon", "coordinates": [[[-119.64146, 36.86082], [-119.64061, 36.86083], [-119.64054, 36.86081], [-119.64033, 36.86071], [-119.64039, 36.86063], [-119.64038, 36.86058], [-119.64034, 36.86054], [-119.64039, 36.86048], [-119.64043, 36.86049], [-119.64051, 36.8604], [-119.64048, 36.86038], [-119.64055, 36.86031], [-119.64068, 36.86025], [-119.64076, 36.86015], [-119.64076, 36.86006], [-119.64074, 36.85999], [-119.64069, 36.85994], [-119.6406, 36.85989], [-119.64045, 36.85988], [-119.64032, 36.85992], [-119.64025, 36.86], [-119.64022, 36.8601], [-119.64016, 36.86016], [-119.64014, 36.86015], [-119.64003, 36.86026], [-119.64004, 36.86027], [-119.63998, 36.86031], [-119.63993, 36.86029], [-119.63989, 36.86028], [-119.63977, 36.86035], [-119.63963, 36.86019], [-119.63964, 36.86015], [-119.64081, 36.85949], [-119.64109, 36.85938], [-119.64137, 36.85932], [-119.64141, 36.85934], [-119.64141, 36.85936], [-119.64144, 36.85937], [-119.64146, 36.86082]]]} | Open Access 1 | 48696 | Harlan Ranch Community Park | 33431 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | https://www.visitclovis.com/clovis-parks/ | Fresno 9 | 3.576 | Harlan Ranch Community Park | 0 | Local Park 2 | 4 |
14628 | 14628 | 14627 | {"type": "Polygon", "coordinates": [[[-119.64776, 36.81683], [-119.6474, 36.81712], [-119.64603, 36.81712], [-119.64603, 36.81573], [-119.64776, 36.81573], [-119.64776, 36.81683]]]} | Open Access 1 | 48578 | Pasa Tiempo Park | 33288 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 5.779 | Pasa Tiempo Park | 0 | Local Park 2 | 4 | |
14633 | 14633 | 14632 | {"type": "Polygon", "coordinates": [[[-119.65069, 36.81251], [-119.65065, 36.81255], [-119.65012, 36.81255], [-119.65007, 36.81251], [-119.65007, 36.81151], [-119.65059, 36.81151], [-119.65069, 36.81159], [-119.65069, 36.81251]]]} | Open Access 1 | 48579 | Palmina Park | 33289 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.562 | Palmina Park | 0 | Local Park 2 | 4 | |
4185 | 4185 | 4184 | {"type": "Polygon", "coordinates": [[[-119.65164, 36.80532], [-119.65136, 36.8054], [-119.65113, 36.80545], [-119.65079, 36.80547], [-119.65055, 36.80544], [-119.64925, 36.8052], [-119.64921, 36.80516], [-119.64923, 36.80495], [-119.64927, 36.80492], [-119.65057, 36.80492], [-119.65085, 36.80494], [-119.65161, 36.80508], [-119.65164, 36.80522], [-119.65164, 36.80532]]]} | Open Access 1 | 48580 | Los Arbolitos Park | 33290 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 2.465 | Los Arbolitos Park | 0 | Local Park 2 | 4 | |
10458 | 10458 | 10457 | {"type": "Polygon", "coordinates": [[[-119.65231, 36.79585], [-119.65231, 36.79617], [-119.65185, 36.79611], [-119.65214, 36.79577], [-119.65218, 36.79576], [-119.65228, 36.7958], [-119.65231, 36.79585]]]} | Open Access 1 | 48584 | Arrowhead Park | 33294 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.289 | Arrowhead Park | 0 | Local Park 2 | 4 | |
15020 | 15020 | 15019 | {"type": "Polygon", "coordinates": [[[-119.65948, 36.80526], [-119.65948, 36.80591], [-119.65943, 36.80595], [-119.65932, 36.80594], [-119.65899, 36.80589], [-119.65869, 36.80578], [-119.65817, 36.80552], [-119.6581, 36.80542], [-119.65802, 36.80537], [-119.65792, 36.80535], [-119.65781, 36.80537], [-119.65758, 36.80531], [-119.65724, 36.80527], [-119.65717, 36.80524], [-119.65717, 36.80511], [-119.65756, 36.80478], [-119.65764, 36.80478], [-119.6577, 36.80477], [-119.65774, 36.80474], [-119.6578, 36.80467], [-119.65787, 36.80464], [-119.65816, 36.80464], [-119.65822, 36.80466], [-119.65832, 36.80475], [-119.6584, 36.80477], [-119.65852, 36.80474], [-119.65858, 36.80465], [-119.65864, 36.80465], [-119.65864, 36.80506], [-119.65899, 36.80507], [-119.65901, 36.80515], [-119.65909, 36.8052], [-119.65916, 36.80522], [-119.65943, 36.80522], [-119.65948, 36.80526]]]} | Open Access 1 | 45667 | Thorburn Park | 28484 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | Fresno 9 | 3.907 | Thorburn Park | 0 | Local Park 2 | 4 |
10473 | 10473 | 10472 | {"type": "Polygon", "coordinates": [[[-119.65955, 36.79238], [-119.65888, 36.79238], [-119.65883, 36.79234], [-119.65887, 36.79206], [-119.65882, 36.79175], [-119.65887, 36.7917], [-119.65955, 36.7917], [-119.65955, 36.79238]]]} | Open Access 1 | 48587 | Summit 4 Park | 33296 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.164 | Summit 4 Park | 0 | Local Park 2 | 4 | |
10474 | 10474 | 10473 | {"type": "Polygon", "coordinates": [[[-119.66006, 36.7975], [-119.65992, 36.79756], [-119.65992, 36.79787], [-119.65915, 36.79787], [-119.65911, 36.79783], [-119.65911, 36.79725], [-119.65915, 36.79722], [-119.65982, 36.79722], [-119.65998, 36.79726], [-119.66006, 36.79725], [-119.66006, 36.7975]]]} | Open Access 1 | 48588 | Summit 5 Park | 33297 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.365 | Summit 5 Park | 0 | Local Park 2 | 4 | |
9970 | 9970 | 9969 | {"type": "Polygon", "coordinates": [[[-119.6601, 36.81223], [-119.66009, 36.81231], [-119.66005, 36.8124], [-119.66004, 36.81247], [-119.65994, 36.81265], [-119.65988, 36.81286], [-119.65948, 36.81289], [-119.65909, 36.81287], [-119.65911, 36.81216], [-119.66006, 36.81217], [-119.6601, 36.81223]]]} | Open Access 1 | 17148 | Countrywood Park | 17711 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.561 | Countrywood Park | 0 | Local Park 2 | 4 | |
2023 | 2023 | 2022 | {"type": "Polygon", "coordinates": [[[-119.66019, 36.83627], [-119.65963, 36.83626], [-119.6595, 36.83624], [-119.65749, 36.83624], [-119.65748, 36.83579], [-119.6595, 36.83579], [-119.65995, 36.83582], [-119.66001, 36.83603], [-119.66019, 36.83627]]]} | Open Access 1 | 17012 | Cedarwood Park | 17003 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 2.832 | Cedarwood Park | 0 | Local Park 2 | 4 | |
2759 | 2759 | 2758 | {"type": "Polygon", "coordinates": [[[-119.66079, 36.81891], [-119.66078, 36.81946], [-119.66072, 36.81946], [-119.6606, 36.81949], [-119.65944, 36.81949], [-119.65944, 36.81891], [-119.66079, 36.81891]]]} | Open Access 1 | 18455 | Westcal III Park | 27383 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.881 | Westcal III Park | 0 | Local Park 2 | 4 | |
2625 | 2625 | 2624 | {"type": "Polygon", "coordinates": [[[-119.66392, 36.83292], [-119.65948, 36.83293], [-119.65947, 36.83112], [-119.66171, 36.83111], [-119.6617, 36.82964], [-119.66386, 36.82964], [-119.66386, 36.83008], [-119.66389, 36.83028], [-119.6639, 36.83041], [-119.66392, 36.83292]]]} | Open Access 1 | 18019 | Sierra Meadows Park | 25459 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 27.516 | Sierra Meadows Park | 0 | Local Park 2 | 4 | |
2634 | 2634 | 2633 | {"type": "Polygon", "coordinates": [[[-119.66697, 36.81099], [-119.66697, 36.81158], [-119.66646, 36.81159], [-119.66647, 36.81091], [-119.66697, 36.81099]]]} | Open Access 1 | 18063 | Silverton II Park | 25500 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.783 | Silverton II Park | 0 | Local Park 2 | 4 | |
2223 | 2223 | 2222 | {"type": "Polygon", "coordinates": [[[-119.66782, 36.7926], [-119.66782, 36.79282], [-119.66779, 36.79318], [-119.66729, 36.79318], [-119.66729, 36.79286], [-119.66733, 36.79255], [-119.66772, 36.79257], [-119.66782, 36.7926]]]} | Open Access 1 | 17929 | Seville II Park | 25328 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.767 | Seville II Park | 0 | Local Park 2 | 4 | |
10070 | 10070 | 10069 | {"type": "Polygon", "coordinates": [[[-119.66797, 36.81743], [-119.66784, 36.818], [-119.66759, 36.81799], [-119.66734, 36.81801], [-119.6673, 36.81799], [-119.66719, 36.81776], [-119.66704, 36.8175], [-119.66706, 36.81747], [-119.66709, 36.81747], [-119.66743, 36.81742], [-119.66771, 36.81741], [-119.66797, 36.81743]]]} | Open Access 1 | 17479 | Monte Vista 21 Park | 22396 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 1.035 | Monte Vista 21 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]);