superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where MNG_AG_TYP = 20 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY 19
- San Francisco Parks Alliance 5
- Santa Barbara Trust for Historic Preservation 2
- Tulare County Historical Society 1
- Redlands Conservancy 1
- San Diego Humane Society and SPCA 1
- Kare Youth League 1
- San Jacinto Mountain Community Center 1
- Foundation for Preservation of Mt. Helix Nature Theatre 1
- San Diego Zoo Global 1
- La Verne Heritage Foundation 1
- Silver Dollar BMX 1
- Willits Kids Club 1
- Central Valley Community Sports Foundation 1
- Murrieta Valley PONY Baseball, Inc 1
- Watts Labor Community Action Committee 1
- Boy Scouts of America 1
- YMCA of Southeast - Rio Vista 1
- Rancho Santa Fe Community Foundation 1
- National Trust for Historic Preservation 1
ACCESS_TYP 2
MNG_AG_TYP 1
- Non Profit - Other · 24 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB ▼ | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7262 | 7262 | 7261 | {"type": "MultiPolygon", "coordinates": [[[[-116.98007, 32.77041], [-116.97968, 32.77033], [-116.97914, 32.77013], [-116.97923, 32.76989], [-116.97934, 32.7699], [-116.97948, 32.76997], [-116.98007, 32.77041]]], [[[-116.98014, 32.76944], [-116.98017, 32.76955], [-116.9802, 32.76977], [-116.9802, 32.76996], [-116.98018, 32.77009], [-116.98013, 32.77025], [-116.98007, 32.77023], [-116.97955, 32.76984], [-116.97941, 32.76978], [-116.97929, 32.76976], [-116.97953, 32.76954], [-116.97972, 32.7693], [-116.98004, 32.76937], [-116.98014, 32.76944]]], [[[-116.98059, 32.7693], [-116.98028, 32.77017], [-116.98022, 32.77025], [-116.98028, 32.77002], [-116.98028, 32.76978], [-116.98025, 32.76951], [-116.98022, 32.76942], [-116.98014, 32.76935], [-116.98008, 32.76931], [-116.97977, 32.76924], [-116.97988, 32.76911], [-116.98017, 32.76898], [-116.98059, 32.7693]]], [[[-116.98087, 32.76954], [-116.98087, 32.76954], [-116.98049, 32.76998], [-116.9807, 32.7694], [-116.98087, 32.76954]]], [[[-116.98313, 32.76651], [-116.98288, 32.76661], [-116.98266, 32.76658], [-116.98257, 32.76662], [-116.98253, 32.76666], [-116.98239, 32.76693], [-116.98236, 32.76703], [-116.98238, 32.76715], [-116.98245, 32.76726], [-116.98277, 32.76752], [-116.98302, 32.76765], [-116.98294, 32.76763], [-116.98228, 32.76735], [-116.98219, 32.76715], [-116.98236, 32.76689], [-116.98254, 32.76651], [-116.98266, 32.76646], [-116.98313, 32.76651]]], [[[-116.98432, 32.76701], [-116.98411, 32.76731], [-116.98404, 32.76739], [-116.98377, 32.76752], [-116.9836, 32.76758], [-116.98348, 32.76759], [-116.98317, 32.76758], [-116.98293, 32.76749], [-116.98281, 32.76741], [-116.98257, 32.76721], [-116.9825, 32.7671], [-116.9825, 32.76698], [-116.98252, 32.76694], [-116.98265, 32.76674], [-116.98268, 32.76671], [-116.9829, 32.76674], [-116.98319, 32.76662], [-116.98334, 32.7666], [-116.98362, 32.76663], [-116.98411, 32.76677], [-116.98423, 32.76685], [-116.98432, 32.76701]]], [[[-116.98413, 32.76749], [-116.98403, 32.76755], [-116.98385, 32.76773], [-116.98381, 32.76769], [-116.98369, 32.76768], [-116.98333, 32.76772], [-116.98326, 32.7677], [-116.9835, 32.7677], [-116.98373, 32.76766], [-116.98405, 32.76752], [-116.98412, 32.76747], [-116.98413, 32.76749]]]]} | Open Access 1 | Mt. Helix Park | https://www.mthelixpark.org/ | 22579 | 3024 | Foundation for Preservation of Mt. Helix Nature Theatre 852 | Non Profit 6 | Non Profit - Other 20 | http://www.mthelixpark.org/ | Non Governmental Organization 10 | 6.584 | Mt. Helix Park | |
4234 | 4234 | 4233 | {"type": "Polygon", "coordinates": [[[-122.33796, 37.45405], [-122.33784, 37.45482], [-122.3369, 37.45579], [-122.33616, 37.45669], [-122.33589, 37.45776], [-122.33615, 37.45885], [-122.33668, 37.45965], [-122.31809, 37.47368], [-122.31806, 37.47368], [-122.3133, 37.47728], [-122.30701, 37.47208], [-122.30872, 37.47077], [-122.30803, 37.46999], [-122.30845, 37.46868], [-122.30961, 37.46678], [-122.31148, 37.46868], [-122.31435, 37.46651], [-122.3146, 37.46658], [-122.31482, 37.46659], [-122.31542, 37.46654], [-122.3156, 37.46558], [-122.33576, 37.45033], [-122.33575, 37.45149], [-122.33668, 37.45179], [-122.33796, 37.45405]]]} | Restricted Access 2 | Filoli Center | 18900 | 3047 | National Trust for Historic Preservation 1122 | Non Profit 6 | Non Profit - Other 20 | http://www.preservationnation.org/ | Non Governmental Organization 10 | 657.366 | Filoli Ctr. | 1975 | |
656 | 656 | 655 | {"type": "Polygon", "coordinates": [[[-117.12997, 34.00757], [-117.12566, 34.00736], [-117.12569, 34.01105], [-117.12136, 34.01083], [-117.12136, 34.0124], [-117.11673, 34.01318], [-117.11671, 34.01471], [-117.11253, 34.01494], [-117.11247, 34.01855], [-117.11191, 34.01851], [-117.1119, 34.01824], [-117.11177, 34.01822], [-117.1117, 34.01827], [-117.11153, 34.01825], [-117.11138, 34.01806], [-117.11128, 34.01822], [-117.11086, 34.01823], [-117.10963, 34.01775], [-117.10954, 34.01781], [-117.10954, 34.01786], [-117.10942, 34.01774], [-117.10934, 34.01772], [-117.10927, 34.01772], [-117.10918, 34.01753], [-117.10925, 34.01751], [-117.10915, 34.01654], [-117.10816, 34.01601], [-117.10719, 34.01448], [-117.10708, 34.0126], [-117.10573, 34.01116], [-117.10685, 34.01022], [-117.10757, 34.01071], [-117.1126, 34.01028], [-117.1126, 34.01066], [-117.11262, 34.01068], [-117.11494, 34.0093], [-117.1164, 34.00859], [-117.11749, 34.00742], [-117.11913, 34.0066], [-117.11913, 34.00658], [-117.11825, 34.00577], [-117.11884, 34.00524], [-117.11984, 34.00498], [-117.12059, 34.00429], [-117.12243, 34.00429], [-117.12244, 34.00434], [-117.12274, 34.00488], [-117.12362, 34.00456], [-117.12395, 34.00465], [-117.12397, 34.00461], [-117.12449, 34.00464], [-117.12498, 34.0043], [-117.12991, 34.0043], [-117.12997, 34.00757]]]} | Open Access 1 | Live Oak Canyon Open Space | 33535 | 3302 | Redlands Conservancy 660 | Non Profit 6 | Non Profit - Other 20 | http://www.redlandsconservancy.org/ | Non Governmental Organization 10 | 338.391 | Live Oak Canyon OS | ||
9189 | 9189 | 9188 | {"type": "MultiPolygon", "coordinates": [[[[-117.23374, 33.03631], [-117.23309, 33.03834], [-117.23296, 33.03831], [-117.23292, 33.03841], [-117.23201, 33.03818], [-117.23209, 33.03792], [-117.23191, 33.03787], [-117.23251, 33.03599], [-117.23374, 33.03631]]], [[[-117.23623, 33.03472], [-117.23609, 33.03514], [-117.23477, 33.03601], [-117.23459, 33.03653], [-117.23385, 33.03634], [-117.23455, 33.03424], [-117.23623, 33.03472]]]]} | Open Access 1 | San Elijo Lagoon Ecological Reserve | https://www.sanelijo.org/home | 24880 | 3058 | Rancho Santa Fe Community Foundation 1101 | Non Profit 6 | Non Profit - Other 20 | http://www.rsffoundation.org/ | Non Governmental Organization 10 | 14.076 | San Elijo Lagoon ER | 1983 |
14059 | 14059 | 14058 | {"type": "Polygon", "coordinates": [[[-117.01166, 33.09834], [-117.00724, 33.09846], [-117.00721, 33.10173], [-117.00292, 33.10171], [-117.00293, 33.1048], [-117.00284, 33.10489], [-117.00279, 33.10502], [-117.00277, 33.10523], [-117.00281, 33.1053], [-116.99808, 33.10533], [-116.99803, 33.10898], [-116.98097, 33.10899], [-116.98095, 33.10543], [-116.96332, 33.10566], [-116.96371, 33.09511], [-116.96367, 33.09348], [-116.96393, 33.09332], [-116.96428, 33.09317], [-116.96446, 33.09312], [-116.96564, 33.09286], [-116.9661, 33.09274], [-116.96856, 33.0918], [-116.96876, 33.09173], [-116.96925, 33.09162], [-116.97152, 33.09125], [-116.97191, 33.09117], [-116.97461, 33.09036], [-116.97866, 33.08928], [-116.97854, 33.08932], [-116.97857, 33.09035], [-116.98186, 33.09031], [-116.99163, 33.08849], [-116.99171, 33.08887], [-116.99197, 33.08955], [-116.99249, 33.09015], [-116.99317, 33.09071], [-116.99366, 33.09108], [-116.99411, 33.09135], [-116.99459, 33.0916], [-116.99501, 33.09177], [-116.99945, 33.09342], [-117.00223, 33.09441], [-117.00239, 33.09428], [-117.00233, 33.09448], [-117.00438, 33.09522], [-117.00503, 33.09542], [-117.00567, 33.09558], [-117.00623, 33.09569], [-117.00687, 33.09579], [-117.01086, 33.09625], [-117.01126, 33.09635], [-117.01148, 33.09642], [-117.01165, 33.0965], [-117.01166, 33.09834]]]} | Open Access 1 | San Diego Safari Park | http://sdzsafaripark.org/ | 31513 | 7020 | San Diego Zoo Global 858 | Non Profit 6 | Non Profit - Other 20 | http://www.sandiegozooglobal.org | Non Governmental Organization 10 | 1700.054 | San Diego Safari Park | |
12226 | 12226 | 12225 | {"type": "MultiPolygon", "coordinates": [[[[-119.69816, 34.42266], [-119.69776, 34.42304], [-119.69749, 34.4229], [-119.69761, 34.42271], [-119.6973, 34.42248], [-119.69723, 34.42254], [-119.69702, 34.42239], [-119.69735, 34.42208], [-119.69816, 34.42266]]], [[[-119.69831, 34.4219], [-119.69791, 34.42227], [-119.69736, 34.42187], [-119.69751, 34.42172], [-119.69769, 34.42185], [-119.69793, 34.42163], [-119.69799, 34.42166], [-119.69805, 34.42158], [-119.69825, 34.42169], [-119.69816, 34.42178], [-119.69831, 34.4219]]], [[[-119.69897, 34.42326], [-119.69864, 34.42356], [-119.69857, 34.42353], [-119.69836, 34.42374], [-119.69814, 34.42358], [-119.69809, 34.42361], [-119.69771, 34.42334], [-119.69831, 34.42277], [-119.69897, 34.42326]]], [[[-119.69884, 34.42203], [-119.69859, 34.42227], [-119.69834, 34.4221], [-119.69845, 34.42199], [-119.69859, 34.42208], [-119.69873, 34.42195], [-119.69884, 34.42203]]], [[[-119.69995, 34.42208], [-119.6997, 34.42231], [-119.69984, 34.42244], [-119.69966, 34.42265], [-119.69937, 34.42248], [-119.6993, 34.42255], [-119.69935, 34.42259], [-119.69915, 34.42282], [-119.69916, 34.42285], [-119.69897, 34.42303], [-119.69844, 34.42265], [-119.69944, 34.42171], [-119.69995, 34.42208]]]]} | Open Access 1 | El Presidio de Santa Barbara State Historic Park | http://www.parks.ca.gov/?page_id=608 | 30636 | 3372 | Santa Barbara Trust for Historic Preservation 706 | Non Profit 6 | Non Profit - Other 20 | http://www.sbthp.org/ | Non Governmental Organization 10 | 5.929 | El Presidio de Santa Barbara SHP | 1966 |
12254 | 12254 | 12253 | {"type": "Polygon", "coordinates": [[[-120.13295, 34.59237], [-120.13291, 34.59524], [-120.12773, 34.5952], [-120.12768, 34.59802], [-120.12682, 34.59784], [-120.12694, 34.59711], [-120.12699, 34.59606], [-120.1268, 34.59601], [-120.12734, 34.59501], [-120.12844, 34.59417], [-120.12826, 34.59379], [-120.1283, 34.59233], [-120.13295, 34.59237]]]} | Restricted Access 2 | Santa Ines Mission Mill | http://www.sbthp.org/ | 30693 | 3372 | Santa Barbara Trust for Historic Preservation 706 | Non Profit 6 | Non Profit - Other 20 | http://www.sbthp.org/ | Non Governmental Organization 10 | 40.04 | Santa Ines Mission Mill | |
12096 | 12096 | 12095 | {"type": "Polygon", "coordinates": [[[-117.98619, 34.17245], [-117.98605, 34.1798], [-117.9775, 34.17979], [-117.97751, 34.17245], [-117.98619, 34.17245]]]} | Open Access 1 | Canyon Park, Boy Scouts of America | 29062 | 3360 | Boy Scouts of America 1092 | Non Profit 6 | Non Profit - Other 20 | http://www.scouting.org/ | Non Governmental Organization 10 | 159.845 | Canyon Park, Boy Scouts of America | ||
12143 | 12143 | 12142 | {"type": "Polygon", "coordinates": [[[-117.35459, 33.20901], [-117.35406, 33.21043], [-117.35407, 33.21045], [-117.35412, 33.21045], [-117.3539, 33.21053], [-117.35388, 33.21048], [-117.35389, 33.21042], [-117.35409, 33.20978], [-117.35417, 33.20964], [-117.35418, 33.20959], [-117.35417, 33.20953], [-117.3541, 33.20946], [-117.35404, 33.20943], [-117.35393, 33.20943], [-117.35337, 33.20918], [-117.35314, 33.20899], [-117.35395, 33.20875], [-117.35416, 33.20875], [-117.35447, 33.20877], [-117.35454, 33.20899], [-117.35459, 33.20901]]]} | Open Access 1 | North County Humane Society and SPCA Dog Park | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/dogpark.asp | 29112 | 3361 | San Diego Humane Society and SPCA 783 | Non Profit 6 | Non Profit - Other 20 | http://www.sdhumane.org/ | Non Governmental Organization 10 | 2.32 | North County Humane Society and SPCA Dog Park | |
463 | 463 | 462 | {"type": "Polygon", "coordinates": [[[-122.39117, 37.78541], [-122.39071, 37.78573], [-122.39028, 37.78609], [-122.39017, 37.78649], [-122.38985, 37.78623], [-122.39103, 37.78533], [-122.39117, 37.78541]]]} | Open Access 1 | Rincon Hill Dog Park | https://www.rinconhilldogpark.org/about | 33503 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 0.621 | Rincon Hill Dog Park | 2007 |
789 | 789 | 788 | {"type": "Polygon", "coordinates": [[[-122.39104, 37.75772], [-122.39035, 37.75777], [-122.39033, 37.7576], [-122.39101, 37.75756], [-122.39104, 37.75772]]]} | Open Access 1 | Woods Yard | https://www.sfparksalliance.org/our-parks/parks/woods-yard | 33552 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 0.275 | Woods Yard | |
802 | 802 | 801 | {"type": "Polygon", "coordinates": [[[-122.39106, 37.77842], [-122.38914, 37.77987], [-122.38862, 37.78032], [-122.38843, 37.78055], [-122.38828, 37.78079], [-122.38819, 37.78101], [-122.38806, 37.78144], [-122.388, 37.78149], [-122.38791, 37.78151], [-122.38783, 37.7815], [-122.38776, 37.78145], [-122.38774, 37.78141], [-122.38768, 37.7806], [-122.38752, 37.77914], [-122.38746, 37.77826], [-122.38762, 37.77821], [-122.38757, 37.77825], [-122.3878, 37.78026], [-122.38849, 37.78024], [-122.38857, 37.78028], [-122.391, 37.77836], [-122.39106, 37.77842]]]} | Open Access 1 | South Beach Park | https://www.sfparksalliance.org/our-parks/parks/south-beach-park | 33553 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 2.85 | South Beach Park | |
819 | 819 | 818 | {"type": "Polygon", "coordinates": [[[-122.47779, 37.71752], [-122.47794, 37.71754], [-122.47824, 37.71766], [-122.47841, 37.71779], [-122.47855, 37.71794], [-122.47864, 37.71809], [-122.47866, 37.71822], [-122.47864, 37.7183], [-122.4786, 37.71838], [-122.47849, 37.71848], [-122.47837, 37.71855], [-122.47824, 37.71859], [-122.4781, 37.71859], [-122.47795, 37.71857], [-122.47777, 37.71849], [-122.47759, 37.71838], [-122.47748, 37.71829], [-122.47737, 37.71816], [-122.47731, 37.71806], [-122.47729, 37.71796], [-122.4773, 37.71787], [-122.47733, 37.71778], [-122.47742, 37.71767], [-122.47753, 37.71758], [-122.47764, 37.71754], [-122.47779, 37.71752]]]} | Open Access 1 | Robert Pender Park | https://www.sfparksalliance.org/our-parks/parks/robert-pender-park | 33555 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 2.547 | Robert Pender Park | |
4028 | 4028 | 4027 | {"type": "Polygon", "coordinates": [[[-122.44958, 37.76633], [-122.44898, 37.7664], [-122.44881, 37.76647], [-122.44849, 37.76654], [-122.44848, 37.76657], [-122.44806, 37.76662], [-122.44802, 37.76642], [-122.44844, 37.76637], [-122.44847, 37.7664], [-122.44872, 37.76635], [-122.44892, 37.76627], [-122.44902, 37.7662], [-122.44899, 37.76602], [-122.4495, 37.76595], [-122.44958, 37.76633]]]} | Open Access 1 | Richard Gamble Memorial Park | https://www.sfparksalliance.org/our-parks/parks/gamble-memorial-park | 33627 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 0.913 | Richard Gamble Memorial Park | |
5198 | 5198 | 5197 | {"type": "Polygon", "coordinates": [[[-119.08951, 36.35464], [-119.08945, 36.35822], [-119.08502, 36.3582], [-119.08507, 36.35461], [-119.08951, 36.35464]]]} | Open Access 1 | Hog Wallow Preserve | 20024 | 3137 | Tulare County Historical Society 625 | Non Profit 6 | Non Profit - Other 20 | http://www.tularecountyhistoricalsociety.org/ | Non Governmental Organization 10 | 39.158 | Hog Wallow Preserve | ||
14028 | 14028 | 14027 | {"type": "Polygon", "coordinates": [[[-123.35819, 39.40016], [-123.35815, 39.40029], [-123.35809, 39.40029], [-123.35808, 39.40035], [-123.35769, 39.40036], [-123.35769, 39.40074], [-123.35748, 39.40075], [-123.35748, 39.40086], [-123.35711, 39.40086], [-123.35709, 39.40016], [-123.35819, 39.40016]]]} | Open Access 1 | Willits Kids Club Discovery Park and Playground | 32597 | 3383 | Willits Kids Club 941 | Non Profit 6 | Non Profit - Other 20 | http://www.willitskidsclub.org/about | Non Governmental Organization 10 | 1.123 | Willits Kids Club Discovery Park and Playground | ||
11567 | 11567 | 11566 | {"type": "Polygon", "coordinates": [[[-118.23665, 33.94382], [-118.23662, 33.94385], [-118.23513, 33.94385], [-118.23512, 33.94321], [-118.2366, 33.94322], [-118.23664, 33.94324], [-118.23665, 33.94382]]]} | Open Access 1 | MudTown Farms | 28055 | 3351 | Watts Labor Community Action Committee 1077 | Non Profit 6 | Non Profit - Other 20 | http://www.wlcac.org/ | Non Governmental Organization 10 | 2.45 | MudTown Farms | ||
12635 | 12635 | 12634 | {"type": "Polygon", "coordinates": [[[-118.1787, 33.98749], [-118.1785, 33.98885], [-118.17811, 33.98882], [-118.17817, 33.98838], [-118.17812, 33.98837], [-118.17792, 33.98851], [-118.17774, 33.98834], [-118.17784, 33.98769], [-118.17797, 33.98768], [-118.178, 33.98742], [-118.1787, 33.98749]]]} | Open Access 1 | Maywood Activity Center | http://www.cityofmaywood.com/index.php?option=com_content&view=article&id=162&Itemid=69 | 29736 | 3366 | YMCA of Southeast - Rio Vista 1098 | Non Profit 6 | Non Profit - Other 20 | http://www.ymcala.org/southeast-rio-vista/ | Non Governmental Organization 10 | 2.401 | Maywood Activity Ctr. | |
13650 | 13650 | 13649 | {"type": "Polygon", "coordinates": [[[-119.75209, 36.7914], [-119.75208, 36.79222], [-119.74984, 36.79221], [-119.74986, 36.79016], [-119.74979, 36.79014], [-119.74979, 36.78996], [-119.74993, 36.78994], [-119.74995, 36.78796], [-119.75026, 36.78784], [-119.75059, 36.78776], [-119.75151, 36.78761], [-119.7515, 36.78918], [-119.75146, 36.7892], [-119.75145, 36.79075], [-119.75161, 36.79077], [-119.75161, 36.79139], [-119.75209, 36.7914]]]} | Open Access 1 | Granite Park Sports Complex | https://www.graniteparkfresno.com/about-us | 33452 | 3396 | Central Valley Community Sports Foundation 947 | Non Profit 6 | Non Profit - Other 20 | https://www.graniteparkfresno.com/about-us | Non Governmental Organization 10 | 18.776 | Granite Park Sports Complex | |
15613 | 15613 | 15612 | {"type": "Polygon", "coordinates": [[[-116.71662, 33.74341], [-116.71529, 33.74392], [-116.71542, 33.7442], [-116.71505, 33.74429], [-116.71457, 33.7435], [-116.71464, 33.7433], [-116.71463, 33.7428], [-116.71464, 33.74276], [-116.71524, 33.74258], [-116.71632, 33.74263], [-116.71628, 33.74276], [-116.71662, 33.74341]]]} | Open Access 1 | Idyllwild Community Center | https://www.idyllwildcommunitycenter.org/faq | 33128 | 3387 | San Jacinto Mountain Community Center 831 | Non Profit 6 | Non Profit - Other 20 | https://www.idyllwildcommunitycenter.org/faq | Non Governmental Organization 10 | 5.567 | Idyllwild Community Ctr. | 2019 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);