units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 144 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 10
- Local Park 30
- Local Recreation Area 5
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 43
MNG_AGENCY 1
- Petaluma, City of · 43 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13173 | 13173 | 13172 | {"type": "MultiPolygon", "coordinates": [[[[-122.58307, 38.22933], [-122.58238, 38.23007], [-122.57621, 38.22666], [-122.57633, 38.22647], [-122.57659, 38.22629], [-122.57685, 38.22617], [-122.5772, 38.22588], [-122.57777, 38.22573], [-122.57799, 38.2256], [-122.57872, 38.22483], [-122.57915, 38.22443], [-122.58083, 38.22535], [-122.58089, 38.22576], [-122.5804, 38.22629], [-122.58131, 38.22682], [-122.58105, 38.22709], [-122.58105, 38.22711], [-122.5828, 38.22811], [-122.58307, 38.22933]]], [[[-122.59172, 38.21766], [-122.59033, 38.21764], [-122.58878, 38.21814], [-122.58712, 38.21833], [-122.58596, 38.21827], [-122.58479, 38.21783], [-122.58391, 38.21714], [-122.58327, 38.21602], [-122.58331, 38.21486], [-122.58381, 38.21407], [-122.58571, 38.2127], [-122.58639, 38.21185], [-122.58784, 38.2134], [-122.59172, 38.21766]]]]} | No Public Access 3 | 35157 | Petaluma Marsh Acquisition, Enhancement and Access | 28158 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 112.939 | Petaluma Marsh Acquisition, Enhancement and Access | 0 | Local Recreation Area 3 | 4 | |
3218 | 3218 | 3217 | {"type": "MultiPolygon", "coordinates": [[[[-122.63176, 38.26966], [-122.63117, 38.27031], [-122.62234, 38.26535], [-122.62274, 38.2649], [-122.62292, 38.26507], [-122.62306, 38.26515], [-122.62318, 38.26519], [-122.62345, 38.26523], [-122.62384, 38.2652], [-122.62397, 38.26522], [-122.62406, 38.26525], [-122.62443, 38.26546], [-122.62452, 38.26553], [-122.62464, 38.26555], [-122.62465, 38.26564], [-122.62535, 38.26603], [-122.62566, 38.26601], [-122.62567, 38.2661], [-122.62572, 38.2662], [-122.62579, 38.26629], [-122.62588, 38.26637], [-122.62608, 38.26647], [-122.62644, 38.26655], [-122.62667, 38.26665], [-122.62681, 38.26676], [-122.627, 38.26699], [-122.62715, 38.26713], [-122.62741, 38.26731], [-122.62761, 38.26742], [-122.62787, 38.26751], [-122.62811, 38.26753], [-122.62825, 38.26752], [-122.62839, 38.26747], [-122.62849, 38.26742], [-122.62859, 38.26735], [-122.62829, 38.26768], [-122.6283, 38.26769], [-122.62985, 38.26856], [-122.62991, 38.26861], [-122.62999, 38.26864], [-122.63129, 38.26937], [-122.63135, 38.26942], [-122.63147, 38.26945], [-122.63151, 38.26952], [-122.63176, 38.26966]]], [[[-122.63916, 38.27377], [-122.63855, 38.27445], [-122.63365, 38.2717], [-122.63425, 38.27103], [-122.63916, 38.27377]]], [[[-122.64797, 38.27641], [-122.64737, 38.27708], [-122.64371, 38.27505], [-122.64235, 38.27656], [-122.63864, 38.27449], [-122.63924, 38.27382], [-122.6413, 38.27497], [-122.64192, 38.27478], [-122.64294, 38.27478], [-122.64359, 38.27407], [-122.64429, 38.27441], [-122.64477, 38.27461], [-122.64497, 38.2747], [-122.6455, 38.27504], [-122.64664, 38.27567], [-122.64674, 38.27576], [-122.64685, 38.27579], [-122.64797, 38.27641]]]]} | Open Access 1 | 28207 | Petaluma Urban Separator | 23625 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 55.708 | Petaluma Urban Separator | None 265 | |||
5586 | 5586 | 5585 | {"type": "Polygon", "coordinates": [[[-122.5889, 38.23692], [-122.58862, 38.23722], [-122.58856, 38.23723], [-122.58789, 38.23684], [-122.58781, 38.23683], [-122.58773, 38.23685], [-122.58813, 38.2364], [-122.58837, 38.23654], [-122.58839, 38.23659], [-122.58843, 38.23663], [-122.58889, 38.23687], [-122.5889, 38.23692]]]} | Open Access 1 | 48806 | Southgate Park | 33528 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 1.079 | Southgate Park | 0 | Local Park 2 | 4 | |
1216 | 1216 | 1215 | {"type": "Polygon", "coordinates": [[[-122.58991, 38.30992], [-122.57891, 38.32201], [-122.57277, 38.31852], [-122.58368, 38.30636], [-122.58991, 38.30992]]]} | No Public Access 3 | 7007 | Lafferty Ranch | 20837 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 272.49 | Lafferty Ranch | 0 | Local Other or Unknown 14 | 4 | |
1473 | 1473 | 1472 | {"type": "Polygon", "coordinates": [[[-122.59778, 38.23707], [-122.59771, 38.23722], [-122.59758, 38.23746], [-122.59738, 38.23787], [-122.59702, 38.23833], [-122.59676, 38.23857], [-122.59633, 38.23834], [-122.59654, 38.23789], [-122.59716, 38.23673], [-122.59778, 38.23707]]]} | Open Access 1 | 10021 | Case Del Oro Park | 16941 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 2.947 | Case Del Oro Park | 0 | Local Park 2 | 4 | |
7890 | 7890 | 7889 | {"type": "Polygon", "coordinates": [[[-122.60189, 38.24842], [-122.60042, 38.25008], [-122.59944, 38.24939], [-122.59941, 38.24942], [-122.59918, 38.24928], [-122.59886, 38.24905], [-122.59856, 38.24873], [-122.59857, 38.24867], [-122.59885, 38.24853], [-122.59953, 38.24827], [-122.59986, 38.24814], [-122.60036, 38.24785], [-122.60066, 38.24811], [-122.6009, 38.24786], [-122.60189, 38.24842]]]} | Open Access 1 | 9969 | Arroyo Park | 15616 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 9.34 | Arroyo Park | 0 | Local Park 2 | 4 | |
1469 | 1469 | 1468 | {"type": "Polygon", "coordinates": [[[-122.60249, 38.23759], [-122.6023, 38.23782], [-122.60201, 38.23804], [-122.60184, 38.23794], [-122.60183, 38.2379], [-122.6019, 38.23778], [-122.6022, 38.23745], [-122.60226, 38.23746], [-122.60249, 38.23759]]]} | Open Access 1 | 10045 | Anna's Meadows | 15501 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 0.457 | Anna's Meadows | None 121 | |||
1459 | 1459 | 1458 | {"type": "Polygon", "coordinates": [[[-122.60411, 38.24256], [-122.60085, 38.24618], [-122.5962, 38.24357], [-122.59614, 38.24353], [-122.59611, 38.24345], [-122.59612, 38.2434], [-122.59614, 38.24335], [-122.59829, 38.24098], [-122.59893, 38.24133], [-122.59953, 38.24067], [-122.59953, 38.24066], [-122.5989, 38.2403], [-122.59979, 38.23932], [-122.60141, 38.24023], [-122.60169, 38.24044], [-122.60193, 38.24069], [-122.60218, 38.24107], [-122.60195, 38.24135], [-122.60411, 38.24256]]]} | Open Access 1 | 9831 | Crinella Park | 17820 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 66.215 | Crinella Park | 0 | Local Park 2 | 4 | |
7888 | 7888 | 7887 | {"type": "Polygon", "coordinates": [[[-122.60701, 38.25607], [-122.60694, 38.25617], [-122.60509, 38.25511], [-122.60382, 38.25436], [-122.60364, 38.25435], [-122.60308, 38.25411], [-122.60224, 38.25394], [-122.6015, 38.25388], [-122.59933, 38.25266], [-122.59815, 38.2521], [-122.5976, 38.25189], [-122.59728, 38.25161], [-122.5979, 38.25094], [-122.59977, 38.25207], [-122.6004, 38.25233], [-122.60232, 38.25335], [-122.60273, 38.25336], [-122.6031, 38.25331], [-122.60329, 38.25354], [-122.60364, 38.25375], [-122.60397, 38.25382], [-122.60395, 38.25404], [-122.60415, 38.25442], [-122.60701, 38.25607]]]} | Open Access 1 | 9957 | Wiseman Airport Park | 27661 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 14.073 | Wiseman Airport Park | 0 | Local Park 2 | 4 | |
1225 | 1225 | 1224 | {"type": "Polygon", "coordinates": [[[-122.60828, 38.227], [-122.60689, 38.2283], [-122.60534, 38.22861], [-122.60511, 38.22845], [-122.60348, 38.22942], [-122.60099, 38.2291], [-122.59955, 38.22805], [-122.59813, 38.22962], [-122.59712, 38.22934], [-122.59572, 38.22889], [-122.58667, 38.22545], [-122.58472, 38.22752], [-122.58065, 38.22602], [-122.58089, 38.22576], [-122.58083, 38.22535], [-122.57915, 38.22443], [-122.57979, 38.22381], [-122.58026, 38.22347], [-122.58051, 38.22326], [-122.58068, 38.22298], [-122.58181, 38.2234], [-122.58545, 38.21911], [-122.58592, 38.21923], [-122.58644, 38.21924], [-122.58741, 38.2193], [-122.58767, 38.21927], [-122.58832, 38.21912], [-122.58881, 38.21891], [-122.58985, 38.21833], [-122.59071, 38.218], [-122.5915, 38.21787], [-122.59165, 38.21787], [-122.59273, 38.21894], [-122.59312, 38.21949], [-122.59357, 38.22006], [-122.59404, 38.22053], [-122.59456, 38.22086], [-122.59507, 38.22105], [-122.59564, 38.22119], [-122.5964, 38.22125], [-122.59841, 38.22082], [-122.59919, 38.22081], [-122.60016, 38.22118], [-122.60112, 38.22129], [-122.60174, 38.22118], [-122.60284, 38.22117], [-122.60389, 38.22166], [-122.60493, 38.22272], [-122.60556, 38.22413], [-122.60673, 38.22506], [-122.60825, 38.22572], [-122.6084, 38.22616], [-122.60841, 38.22662], [-122.60828, 38.227]]]} | Open Access 1 | 7020 | Shollenberger Park | 8553 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/parks-pages/shollenberger.html | Sonoma 16 | 455.472 | Shollenberger Park | 0 | Local Park 2 | 4 |
7892 | 7892 | 7891 | {"type": "Polygon", "coordinates": [[[-122.60948, 38.2456], [-122.6092, 38.24587], [-122.60889, 38.24599], [-122.60878, 38.24592], [-122.60856, 38.24599], [-122.60844, 38.24612], [-122.60844, 38.24628], [-122.60854, 38.24633], [-122.60853, 38.24655], [-122.6086, 38.24661], [-122.6086, 38.24671], [-122.60869, 38.24675], [-122.60846, 38.24702], [-122.60698, 38.24617], [-122.60753, 38.24552], [-122.60733, 38.24538], [-122.60735, 38.24527], [-122.60725, 38.24519], [-122.6071, 38.2452], [-122.607, 38.24523], [-122.60684, 38.24511], [-122.60679, 38.24501], [-122.60661, 38.24488], [-122.60672, 38.24475], [-122.60676, 38.24464], [-122.60651, 38.24433], [-122.60662, 38.24421], [-122.60682, 38.24404], [-122.60693, 38.24417], [-122.6071, 38.24428], [-122.60718, 38.24428], [-122.60733, 38.24435], [-122.60748, 38.2444], [-122.60783, 38.24459], [-122.60791, 38.24472], [-122.60808, 38.2448], [-122.60822, 38.24491], [-122.60901, 38.24536], [-122.60948, 38.2456]]]} | Open Access 1 | 9992 | La Tercera Park | 20810 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 8.742 | La Tercera Park | 0 | Local Park 2 | 4 | |
7485 | 7485 | 7484 | {"type": "Polygon", "coordinates": [[[-122.61069, 38.22836], [-122.6083, 38.23106], [-122.60738, 38.23091], [-122.6072, 38.2311], [-122.60692, 38.23105], [-122.60708, 38.23086], [-122.60645, 38.2302], [-122.60684, 38.22947], [-122.60659, 38.22931], [-122.60854, 38.22718], [-122.61069, 38.22836]]]} | Open Access 1 | 7033 | Rocky Memorial Dog | 24541 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 21.616 | Rocky Memorial Dog | None 622 | |||
9576 | 9576 | 9575 | {"type": "Polygon", "coordinates": [[[-122.61166, 38.265], [-122.61098, 38.26576], [-122.60488, 38.26235], [-122.6057, 38.26144], [-122.60662, 38.26161], [-122.60843, 38.26232], [-122.60952, 38.26339], [-122.61136, 38.26423], [-122.61166, 38.265]]]} | Open Access 1 | 47844 | Petaluma Community Sports Fields | 31786 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/parks-pages/petaluma-comm-sport-fields.html | Sonoma 16 | 24.892 | Petaluma Community Sports Fields | 2015 | Local Recreation Area 3 | 4 |
1461 | 1461 | 1460 | {"type": "Polygon", "coordinates": [[[-122.61278, 38.23578], [-122.61245, 38.23612], [-122.6117, 38.23568], [-122.61154, 38.23563], [-122.61117, 38.23564], [-122.61068, 38.23584], [-122.6104, 38.23602], [-122.61028, 38.23596], [-122.61032, 38.23587], [-122.61023, 38.23582], [-122.61004, 38.23605], [-122.60976, 38.23592], [-122.60964, 38.23594], [-122.60959, 38.23598], [-122.60918, 38.23576], [-122.60926, 38.2357], [-122.60938, 38.23568], [-122.60941, 38.23558], [-122.60947, 38.23551], [-122.60951, 38.23535], [-122.60958, 38.23532], [-122.60958, 38.23524], [-122.60955, 38.23516], [-122.60957, 38.23511], [-122.60966, 38.2351], [-122.60968, 38.23494], [-122.60955, 38.23492], [-122.6095, 38.23484], [-122.60964, 38.23476], [-122.61007, 38.23474], [-122.61085, 38.23474], [-122.61185, 38.23525], [-122.61278, 38.23578]]]} | Open Access 1 | 9843 | Miwok Park | 22330 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 6.479 | Miwok Park | 0 | Local Park 2 | 4 | |
3737 | 3737 | 3736 | {"type": "Polygon", "coordinates": [[[-122.61292, 38.22825], [-122.61179, 38.22899], [-122.61147, 38.22909], [-122.61106, 38.22932], [-122.61101, 38.22968], [-122.61177, 38.23], [-122.61184, 38.23035], [-122.61151, 38.23186], [-122.60961, 38.23153], [-122.60965, 38.23137], [-122.6092, 38.2308], [-122.6087, 38.23061], [-122.61068, 38.22837], [-122.60854, 38.22718], [-122.60936, 38.22628], [-122.60989, 38.22655], [-122.6104, 38.22678], [-122.61292, 38.22825]]]} | No Public Access 3 | 14099 | Alman | 15392 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 26.587 | Alman | 1995 | None 313 | ||
7880 | 7880 | 7879 | {"type": "Polygon", "coordinates": [[[-122.61979, 38.26413], [-122.6189, 38.26519], [-122.61508, 38.26305], [-122.61608, 38.26197], [-122.61979, 38.26413]]]} | Open Access 1 | 9854 | Prince Park | 24008 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 14.563 | Prince Park | 0 | Local Park 2 | 4 | |
5587 | 5587 | 5586 | {"type": "Polygon", "coordinates": [[[-122.62098, 38.22346], [-122.62096, 38.22431], [-122.62061, 38.22421], [-122.62066, 38.22397], [-122.62047, 38.22393], [-122.62007, 38.22387], [-122.61965, 38.22384], [-122.61933, 38.22378], [-122.61924, 38.22346], [-122.61889, 38.22338], [-122.61885, 38.22347], [-122.61883, 38.22363], [-122.61874, 38.22359], [-122.61874, 38.2235], [-122.61879, 38.22337], [-122.61861, 38.22326], [-122.62098, 38.22346]]]} | Open Access 1 | 48807 | Riverview Park | 33529 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 2.473 | Riverview Park | 0 | Local Park 2 | 4 | |
7818 | 7818 | 7817 | {"type": "Polygon", "coordinates": [[[-122.62227, 38.24735], [-122.62075, 38.24903], [-122.6198, 38.24853], [-122.61879, 38.24776], [-122.61909, 38.24734], [-122.61923, 38.24732], [-122.61941, 38.24745], [-122.61948, 38.24742], [-122.61993, 38.24764], [-122.62064, 38.24695], [-122.62085, 38.24703], [-122.62099, 38.24687], [-122.62165, 38.2472], [-122.62181, 38.24718], [-122.62187, 38.2471], [-122.62227, 38.24735]]]} | Open Access 1 | 9945 | McDowell Park | 22027 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 9.052 | McDowell Park | 0 | Local Park 2 | 4 | |
12467 | 12467 | 12466 | {"type": "Polygon", "coordinates": [[[-122.62482, 38.22923], [-122.62481, 38.22929], [-122.62342, 38.22908], [-122.62223, 38.22891], [-122.62175, 38.22881], [-122.62087, 38.22851], [-122.62089, 38.22842], [-122.62177, 38.22873], [-122.62218, 38.22881], [-122.62233, 38.22877], [-122.62255, 38.22851], [-122.62255, 38.22848], [-122.62263, 38.22846], [-122.62285, 38.22854], [-122.6229, 38.2286], [-122.62284, 38.2288], [-122.6229, 38.22889], [-122.62296, 38.22894], [-122.62302, 38.22895], [-122.62363, 38.22902], [-122.62482, 38.22923]]]} | Open Access 1 | 28212 | Mcnear Landing | 22060 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 1.213 | Mcnear Landing | None 1085 | |||
1472 | 1472 | 1471 | {"type": "Polygon", "coordinates": [[[-122.62727, 38.24423], [-122.62614, 38.24562], [-122.62614, 38.24564], [-122.62491, 38.24476], [-122.62415, 38.24407], [-122.6233, 38.24296], [-122.62246, 38.24147], [-122.62271, 38.24132], [-122.62324, 38.24158], [-122.62375, 38.24187], [-122.62435, 38.24203], [-122.62705, 38.24364], [-122.62685, 38.24396], [-122.62727, 38.24423]]]} | Open Access 1 | 10010 | Kenilworth Athletic Fields | 20596 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 20.13 | Kenilworth Athletic Fields | 0 | Local Recreation Area 3 | 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]);