units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
146 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG_AG_TYP = 7 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 146 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
377 | 377 | 376 | {"type": "MultiPolygon", "coordinates": [[[[-122.63741, 38.12007], [-122.63652, 38.12048], [-122.63581, 38.12056], [-122.63427, 38.12059], [-122.63219, 38.12082], [-122.63072, 38.12113], [-122.63011, 38.12046], [-122.63011, 38.12018], [-122.63741, 38.12007]]], [[[-122.65936, 38.11021], [-122.65936, 38.11113], [-122.65811, 38.11088], [-122.65765, 38.11101], [-122.65744, 38.11116], [-122.65704, 38.11178], [-122.65712, 38.11228], [-122.65707, 38.11254], [-122.65714, 38.11312], [-122.65688, 38.11345], [-122.65636, 38.11364], [-122.65601, 38.11358], [-122.65542, 38.11317], [-122.65416, 38.11323], [-122.65372, 38.11339], [-122.65371, 38.11369], [-122.65377, 38.11389], [-122.65395, 38.11408], [-122.65437, 38.11443], [-122.65407, 38.11581], [-122.65247, 38.11544], [-122.65221, 38.11541], [-122.65197, 38.11541], [-122.65156, 38.11549], [-122.65117, 38.11566], [-122.65054, 38.11598], [-122.64716, 38.11789], [-122.64712, 38.11622], [-122.65079, 38.11475], [-122.6518, 38.11272], [-122.65291, 38.11126], [-122.65452, 38.11062], [-122.65452, 38.10997], [-122.65048, 38.10962], [-122.647, 38.11051], [-122.64693, 38.10718], [-122.65128, 38.10727], [-122.65565, 38.10662], [-122.65936, 38.11021]]]]} | Open Access 1 | 1118 | Stafford Lake County Park | 25774 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 151.667 | Stafford Lake County Park | 2000 | Local Park 2 | 4 | |
509 | 509 | 508 | {"type": "Polygon", "coordinates": [[[-123.01254, 38.82071], [-123.01186, 38.82152], [-123.01112, 38.82235], [-123.01076, 38.82218], [-123.0119, 38.82141], [-123.01148, 38.82068], [-123.01202, 38.81948], [-123.01254, 38.82071]]]} | Open Access 1 | 1700 | Cloverdale River Park | 17444 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 3.11 | Cloverdale River Park | 0 | Local Park 2 | 4 | |
1102 | 1102 | 1101 | {"type": "Polygon", "coordinates": [[[-117.9216, 34.03221], [-117.92061, 34.0323], [-117.92052, 34.03227], [-117.92007, 34.03231], [-117.91957, 34.03233], [-117.91955, 34.03229], [-117.91964, 34.0311], [-117.91978, 34.03062], [-117.91984, 34.03031], [-117.9202, 34.03031], [-117.92158, 34.03021], [-117.92152, 34.03167], [-117.9216, 34.03221]]]} | Open Access 1 | 7055 | Rimgrove Park | 32498 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 9.626 | Rimgrove Park | 0 | Local Park 2 | 4 | |
1142 | 1142 | 1141 | {"type": "MultiPolygon", "coordinates": [[[[-118.15899, 34.20112], [-118.15798, 34.20099], [-118.15803, 34.20185], [-118.15593, 34.20201], [-118.15628, 34.20126], [-118.15588, 34.20113], [-118.15642, 34.19994], [-118.15896, 34.20076], [-118.15899, 34.20112]]], [[[-118.1575, 34.20252], [-118.15539, 34.20268], [-118.15534, 34.20222], [-118.15742, 34.20206], [-118.15745, 34.2021], [-118.1575, 34.20252]]], [[[-118.15918, 34.20422], [-118.1569, 34.20411], [-118.15721, 34.20392], [-118.15738, 34.20379], [-118.15741, 34.20376], [-118.15741, 34.20374], [-118.15755, 34.20359], [-118.15768, 34.20337], [-118.15774, 34.20316], [-118.15776, 34.20299], [-118.15766, 34.20208], [-118.15768, 34.20204], [-118.15909, 34.20194], [-118.15918, 34.20422]]]]} | Open Access 1 | 6712 | Loma Alta Park | 32482 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 20.497 | Loma Alta Park | 0 | Local Park 2 | 4 | |
1298 | 1298 | 1297 | {"type": "MultiPolygon", "coordinates": [[[[-118.63104, 34.48996], [-118.62998, 34.48997], [-118.63, 34.49077], [-118.6298, 34.49064], [-118.62911, 34.4906], [-118.62852, 34.49022], [-118.62868, 34.49003], [-118.62891, 34.48982], [-118.62916, 34.48964], [-118.62959, 34.48941], [-118.62992, 34.48929], [-118.62996, 34.48928], [-118.62997, 34.48932], [-118.63014, 34.48925], [-118.63046, 34.48916], [-118.63071, 34.4891], [-118.63102, 34.48905], [-118.63104, 34.48996]]], [[[-118.63006, 34.48904], [-118.63005, 34.48905], [-118.62996, 34.48909], [-118.62996, 34.48904], [-118.63006, 34.48904]]]]} | Open Access 1 | 7290 | Del Valle Park | 32472 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 5.473 | Del Valle Park | 0 | Local Park 2 | 4 | |
1318 | 1318 | 1317 | {"type": "Polygon", "coordinates": [[[-118.19118, 34.02197], [-118.19118, 34.02211], [-118.19106, 34.02258], [-118.19107, 34.02339], [-118.19103, 34.0234], [-118.19104, 34.02342], [-118.19107, 34.02342], [-118.19107, 34.02376], [-118.19106, 34.02379], [-118.19101, 34.02381], [-118.1894, 34.02381], [-118.18936, 34.0238], [-118.18935, 34.02377], [-118.18934, 34.02201], [-118.19019, 34.02199], [-118.19018, 34.02203], [-118.19012, 34.02208], [-118.19011, 34.02214], [-118.19014, 34.0222], [-118.19022, 34.02222], [-118.19028, 34.02221], [-118.19032, 34.02217], [-118.19033, 34.02199], [-118.19118, 34.02197]]]} | Open Access 1 | 10714 | Ruben F. Salazar Park | 32499 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 7.928 | Ruben F. Salazar Park | 0 | Local Park 2 | 4 | |
1463 | 1463 | 1462 | {"type": "Polygon", "coordinates": [[[-122.5538, 38.41058], [-122.55368, 38.41107], [-122.5537, 38.41226], [-122.55207, 38.41085], [-122.55355, 38.40986], [-122.5538, 38.41058]]]} | Open Access 1 | 9872 | Alder Park | 15346 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 4.856 | Alder Park | 1968 | Local Park 2 | 4 | |
2419 | 2419 | 2418 | {"type": "Polygon", "coordinates": [[[-118.19323, 33.89597], [-118.19317, 33.89601], [-118.19241, 33.89603], [-118.19236, 33.896], [-118.19235, 33.89575], [-118.19232, 33.8957], [-118.19227, 33.89498], [-118.19219, 33.89361], [-118.19265, 33.8936], [-118.19265, 33.89352], [-118.19306, 33.89352], [-118.19315, 33.89475], [-118.19323, 33.89597]]]} | Open Access 1 | 6260 | East Rancho Dominguez Park | 32484 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 5.518 | East Rancho Dominguez Park | 0 | Local Park 2 | 4 | |
2482 | 2482 | 2481 | {"type": "MultiPolygon", "coordinates": [[[[-122.71352, 37.90015], [-122.71308, 37.9004], [-122.71226, 37.89978], [-122.71205, 37.89957], [-122.71194, 37.89942], [-122.7113, 37.8982], [-122.71119, 37.89809], [-122.71104, 37.89801], [-122.71091, 37.89799], [-122.71077, 37.89799], [-122.7106, 37.89803], [-122.71049, 37.89808], [-122.71041, 37.89816], [-122.71024, 37.8984], [-122.71022, 37.89851], [-122.71026, 37.89864], [-122.70994, 37.89875], [-122.71006, 37.89899], [-122.71012, 37.89919], [-122.71009, 37.8992], [-122.71, 37.89905], [-122.70983, 37.89892], [-122.70962, 37.89883], [-122.70944, 37.8988], [-122.70946, 37.89864], [-122.70969, 37.89854], [-122.70981, 37.89846], [-122.70995, 37.89832], [-122.71007, 37.89814], [-122.71013, 37.89793], [-122.71013, 37.89779], [-122.71011, 37.89765], [-122.71005, 37.89751], [-122.70991, 37.89733], [-122.70955, 37.89753], [-122.70938, 37.89742], [-122.70905, 37.89729], [-122.70883, 37.89717], [-122.70862, 37.89699], [-122.70807, 37.89619], [-122.70791, 37.89605], [-122.70774, 37.89593], [-122.70819, 37.89543], [-122.70925, 37.89589], [-122.71022, 37.89622], [-122.71056, 37.89674], [-122.71082, 37.89717], [-122.71098, 37.89748], [-122.71124, 37.89769], [-122.71126, 37.89779], [-122.71136, 37.89796], [-122.71136, 37.89802], [-122.71147, 37.89821], [-122.71194, 37.89883], [-122.71208, 37.89908], [-122.71235, 37.89934], [-122.71258, 37.89954], [-122.71285, 37.89969], [-122.71345, 37.90008], [-122.71352, 37.90015]]], [[[-122.71035, 37.90018], [-122.71029, 37.90026], [-122.71004, 37.90051], [-122.70995, 37.90066], [-122.70992, 37.90061], [-122.70991, 37.90044], [-122.70986, 37.9003], [-122.7098, 37.90028], [-122.71004, 37.8995], [-122.71008, 37.89957], [-122.71007, 37.89976], [-122.70999, 37.90011], [-122.71003, 37.90026], [-122.71035, 37.90018]]]]} | Open Access 1 | 17481 | Agate Beach | 15284 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 13.699 | Agate Beach | 0 | Local Park 2 | 4 | |
2626 | 2626 | 2625 | {"type": "Polygon", "coordinates": [[[-122.51197, 38.34219], [-122.51196, 38.34225], [-122.51196, 38.34231], [-122.51135, 38.34242], [-122.51119, 38.34185], [-122.51136, 38.34182], [-122.51197, 38.34219]]]} | Open Access 1 | 18036 | Moran Goodman Park | 22470 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 0.652 | Moran Goodman Park | 1990 | Local Park 2 | 4 | |
2766 | 2766 | 2765 | {"type": "Polygon", "coordinates": [[[-122.45896, 37.89379], [-122.45848, 37.89539], [-122.45674, 37.89491], [-122.45576, 37.89472], [-122.45574, 37.89382], [-122.45569, 37.89313], [-122.45551, 37.89226], [-122.45534, 37.89188], [-122.45543, 37.89186], [-122.45553, 37.89187], [-122.45574, 37.89198], [-122.45599, 37.89229], [-122.45627, 37.89245], [-122.45648, 37.89245], [-122.45694, 37.8923], [-122.45718, 37.8921], [-122.45723, 37.89207], [-122.45733, 37.89206], [-122.45743, 37.89209], [-122.45749, 37.89213], [-122.45753, 37.89219], [-122.45765, 37.8926], [-122.45817, 37.89292], [-122.45862, 37.89361], [-122.45896, 37.89379]]]} | Open Access 1 | 18478 | Paradise Beach | 23398 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 18.591 | Paradise Beach | 2000 | Local Park 2 | 4 | |
2833 | 2833 | 2832 | {"type": "Polygon", "coordinates": [[[-122.49452, 38.30454], [-122.49377, 38.3048], [-122.49335, 38.30407], [-122.49301, 38.3042], [-122.49262, 38.30344], [-122.49253, 38.30334], [-122.49242, 38.30326], [-122.49212, 38.30312], [-122.49197, 38.3031], [-122.49146, 38.30305], [-122.49093, 38.30295], [-122.49061, 38.30299], [-122.49053, 38.30297], [-122.4902, 38.30247], [-122.49055, 38.30267], [-122.49065, 38.30255], [-122.49072, 38.30255], [-122.49081, 38.3025], [-122.4909, 38.30271], [-122.49136, 38.30275], [-122.49157, 38.3027], [-122.49165, 38.30276], [-122.49171, 38.30277], [-122.49178, 38.30275], [-122.49209, 38.30285], [-122.49216, 38.30262], [-122.49206, 38.30244], [-122.49196, 38.30232], [-122.4919, 38.30221], [-122.49236, 38.30204], [-122.49326, 38.30174], [-122.49452, 38.30454]]]} | Open Access 1 | 22048 | Ernie Smith Community Park | 18699 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 10.405 | Ernie Smith Community Park | 0 | Local Park 2 | 4 | |
3106 | 3106 | 3105 | {"type": "Polygon", "coordinates": [[[-118.06276, 33.9794], [-118.06276, 33.97946], [-118.06244, 33.97978], [-118.0624, 33.97979], [-118.06229, 33.9799], [-118.06229, 33.97994], [-118.06156, 33.98068], [-118.06148, 33.98069], [-118.05955, 33.97935], [-118.06083, 33.97806], [-118.06276, 33.9794]]]} | Open Access 1 | 12858 | Sorensen Park | 32486 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 10.894 | Sorensen Park | 0 | Local Park 2 | 4 | |
3915 | 3915 | 3914 | {"type": "Polygon", "coordinates": [[[-123.05717, 38.323], [-123.05659, 38.32356], [-123.05543, 38.32636], [-123.05548, 38.31987], [-123.05563, 38.32022], [-123.05684, 38.32104], [-123.05715, 38.32178], [-123.05717, 38.323]]]} | Open Access 1 | 2027 | Westside Park | 27424 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 14.966 | Westside Park | 0 | Local Park 2 | 4 | |
3988 | 3988 | 3987 | {"type": "Polygon", "coordinates": [[[-122.68946, 38.01406], [-122.68941, 38.01415], [-122.68914, 38.01432], [-122.68905, 38.01435], [-122.68897, 38.01436], [-122.6889, 38.01434], [-122.68874, 38.01421], [-122.68929, 38.01378], [-122.6893, 38.01384], [-122.68938, 38.01388], [-122.68944, 38.01394], [-122.68946, 38.01399], [-122.68946, 38.01406]]]} | Open Access 1 | 38044 | Forest Knolls Park | 18995 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.526 | Forest Knolls Park | 0 | Local Park 2 | 4 | |
4255 | 4255 | 4254 | {"type": "Polygon", "coordinates": [[[-117.90325, 33.97998], [-117.90158, 33.98014], [-117.90166, 33.97993], [-117.90157, 33.97938], [-117.90144, 33.97842], [-117.90299, 33.97827], [-117.90325, 33.97998]]]} | Open Access 1 | 14365 | Carolyn Rosas Park | 32479 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 6.897 | Carolyn Rosas Park | 0 | Local Park 2 | 4 | |
4302 | 4302 | 4301 | {"type": "Polygon", "coordinates": [[[-118.1262, 34.18898], [-118.12621, 34.18904], [-118.12603, 34.18933], [-118.12602, 34.18935], [-118.12595, 34.18934], [-118.12593, 34.18924], [-118.12595, 34.18897], [-118.12609, 34.18896], [-118.1262, 34.18898]]]} | Open Access 1 | 48153 | Ganesha Park | 32689 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.181 | Ganesha Park | 0 | Local Park 2 | 4 | |
5466 | 5466 | 5465 | {"type": "Polygon", "coordinates": [[[-122.49033, 38.31713], [-122.48955, 38.31716], [-122.4894, 38.31763], [-122.48924, 38.3178], [-122.48702, 38.3187], [-122.48673, 38.31831], [-122.48645, 38.31798], [-122.48724, 38.31765], [-122.48849, 38.317], [-122.48879, 38.31681], [-122.48949, 38.31649], [-122.48954, 38.31627], [-122.48958, 38.31644], [-122.48957, 38.31649], [-122.48962, 38.31662], [-122.48984, 38.31689], [-122.49033, 38.31713]]]} | Open Access 1 | 17295 | Larson Park | 21037 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 7.602 | Larson Park | 1987 | Local Park 2 | 4 | |
5506 | 5506 | 5505 | {"type": "Polygon", "coordinates": [[[-122.53671, 38.00113], [-122.53636, 38.00112], [-122.53598, 38.00094], [-122.53585, 38.00113], [-122.53575, 38.00113], [-122.53448, 38.00304], [-122.53437, 38.00314], [-122.53264, 38.00397], [-122.52966, 38.00525], [-122.52941, 38.00533], [-122.52915, 38.00539], [-122.52888, 38.00542], [-122.52862, 38.00541], [-122.52829, 38.00536], [-122.52663, 38.00495], [-122.52911, 38.00327], [-122.52684, 38.00151], [-122.52722, 38.00121], [-122.52735, 38.0013], [-122.52948, 37.99958], [-122.52899, 37.9992], [-122.52906, 37.99915], [-122.52905, 37.99913], [-122.52833, 37.99856], [-122.52884, 37.99814], [-122.52788, 37.99739], [-122.52834, 37.99703], [-122.52839, 37.99701], [-122.52845, 37.99701], [-122.5285, 37.99704], [-122.52855, 37.99702], [-122.52882, 37.99679], [-122.52881, 37.9967], [-122.52883, 37.99666], [-122.52916, 37.9964], [-122.52958, 37.99605], [-122.52996, 37.99569], [-122.5305, 37.99536], [-122.53086, 37.99535], [-122.53126, 37.99554], [-122.53206, 37.99559], [-122.53224, 37.99562], [-122.53249, 37.99571], [-122.53264, 37.99579], [-122.53284, 37.99594], [-122.53309, 37.99622], [-122.53338, 37.99649], [-122.53575, 37.99984], [-122.53671, 38.00113]]]} | Open Access 1 | 12859 | Civic Center Lagoon Park | 17350 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 136.98 | Civic Ctr. Lagoon Park | 0 | Local Park 2 | 4 | |
5566 | 5566 | 5565 | {"type": "Polygon", "coordinates": [[[-122.21003, 37.47408], [-122.20952, 37.47417], [-122.20935, 37.47434], [-122.20898, 37.4741], [-122.20983, 37.47394], [-122.21003, 37.47408]]]} | Open Access 1 | 46891 | Friendship Park | 30388 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 0.407 | Friendship 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]);