superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2,007 rows where LAYER = 4
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 181
- East Bay Regional Park District 132
- Consumnes Community Services District 92
- Hayward Area Recreation and Park District 84
- Valley-Wide Recreation and Park District 67
- Rancho Simi Recreation and Park District 53
- Yuba County Water Agency 50
- Conejo Recreation and Park District 44
- Midpeninsula Regional Open Space District 43
- Southgate Recreation and Park District 40
- Marin County Open Space District 39
- Sunrise Recreation and Park District 39
- Conejo Open Space Conservation Agency 38
- Cordova Recreation and Park District 36
- Greater Vallejo Recreation and Park District 33
- Pleasant Valley Recreation and Park District 31
- Fresno Metropolitan Flood Control District 29
- North of the River Recreation and Park District 27
- Monterey Peninsula Regional Park District 24
- El Dorado Hills Community Service District 24
- Santa Clara Valley Open Space Authority 23
- Olivehurst Public Utility District 23
- Sonoma County Agricultural Preservation and Open Space District 21
- Natomas Basin Conservancy 20
- San Diego Unified Port District 19
- Jurupa Area Recreation and Park District 18
- Los Angeles County Flood Control District 16
- Santa Barbara Flood Control and Water Conserv. District 15
- Desert Recreation District 15
- Los Angeles Unified School District 15
- …
MNG_AG_TYP 17
- Recreation/Parks District 1,089
- Open Space District 240
- Community Services District 193
- Water District 187
- Flood District 93
- Cemetery District 61
- School District 37
- Port/Harbor District 32
- Irrigation District 24
- Special District - Other 15
- Sanitation District 9
- Joint Powers Authority 8
- Conservation District 5
- Transportation Agency 5
- Metropolitan Planning Organization 2
- Airport District 1
- Fire District 1
ACCESS_TYP 4
- Open Access 1,565
- No Public Access 195
- Restricted Access 138
- Unknown Access 104
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
54 | 54 | 53 | {"type": "Polygon", "coordinates": [[[-118.32587, 33.74382], [-118.32587, 33.74461], [-118.32566, 33.74466], [-118.3256, 33.74453], [-118.3255, 33.74455], [-118.32553, 33.74468], [-118.32546, 33.7447], [-118.32526, 33.74439], [-118.3258, 33.74434], [-118.32581, 33.74381], [-118.32587, 33.74382]]]} | Open Access 1 | Frog Pond Park | 31771 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 0.44 | Frog Pond Park | ||
56 | 56 | 55 | {"type": "Polygon", "coordinates": [[[-118.32092, 33.74221], [-118.32011, 33.74356], [-118.32016, 33.74372], [-118.32001, 33.74377], [-118.31988, 33.744], [-118.31997, 33.74414], [-118.32047, 33.74413], [-118.32055, 33.74404], [-118.32057, 33.74405], [-118.32058, 33.74434], [-118.32056, 33.7444], [-118.32044, 33.74452], [-118.32027, 33.74456], [-118.32011, 33.74436], [-118.31968, 33.74442], [-118.3195, 33.74476], [-118.31966, 33.74514], [-118.31998, 33.74517], [-118.32002, 33.74548], [-118.31996, 33.74555], [-118.31991, 33.74557], [-118.31983, 33.74557], [-118.31939, 33.74542], [-118.31919, 33.74477], [-118.3197, 33.74396], [-118.32074, 33.74221], [-118.32092, 33.74221]]]} | Open Access 1 | Harter Park | 31774 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2.954 | Harter Park | ||
57 | 57 | 56 | {"type": "Polygon", "coordinates": [[[-118.32587, 33.74145], [-118.32586, 33.74173], [-118.32563, 33.74185], [-118.32541, 33.7416], [-118.32474, 33.74161], [-118.32422, 33.74153], [-118.32393, 33.74164], [-118.32391, 33.74158], [-118.32401, 33.74154], [-118.32401, 33.74153], [-118.32329, 33.74095], [-118.32212, 33.74084], [-118.3217, 33.74095], [-118.32093, 33.74221], [-118.32075, 33.74221], [-118.32176, 33.74053], [-118.32318, 33.74066], [-118.32402, 33.74133], [-118.32477, 33.74147], [-118.32587, 33.74145]]]} | Open Access 1 | Colinita Trail | 31775 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 3.142 | Colinita Trail | ||
61 | 61 | 60 | {"type": "MultiPolygon", "coordinates": [[[[-118.32508, 33.74836], [-118.32477, 33.74839], [-118.32442, 33.74858], [-118.3242, 33.74879], [-118.32384, 33.74839], [-118.32179, 33.74742], [-118.32161, 33.74723], [-118.32105, 33.74759], [-118.32094, 33.74748], [-118.32149, 33.74711], [-118.32094, 33.7465], [-118.32031, 33.74623], [-118.3199, 33.74579], [-118.31989, 33.7457], [-118.32, 33.74568], [-118.3201, 33.74562], [-118.32024, 33.74572], [-118.32031, 33.74572], [-118.32038, 33.74575], [-118.32054, 33.74589], [-118.32066, 33.74602], [-118.32075, 33.74605], [-118.32085, 33.74605], [-118.32097, 33.74599], [-118.32102, 33.7459], [-118.32101, 33.74581], [-118.32091, 33.74564], [-118.32093, 33.74564], [-118.32142, 33.74604], [-118.32229, 33.7465], [-118.32269, 33.74631], [-118.32274, 33.74637], [-118.32236, 33.74654], [-118.32235, 33.74656], [-118.32345, 33.74762], [-118.32367, 33.74772], [-118.32395, 33.74742], [-118.32419, 33.74758], [-118.32394, 33.74788], [-118.32439, 33.74816], [-118.32474, 33.74814], [-118.32486, 33.74801], [-118.32498, 33.74812], [-118.32504, 33.74824], [-118.32508, 33.74836]]], [[[-118.32085, 33.74589], [-118.32081, 33.74592], [-118.32078, 33.74592], [-118.32066, 33.74579], [-118.32054, 33.74569], [-118.32074, 33.74566], [-118.32085, 33.74585], [-118.32085, 33.74589]]]]} | Open Access 1 | Sienna Loop Trail | 31777 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 9.939 | Sienna Loop Trail | ||
73 | 73 | 72 | {"type": "MultiPolygon", "coordinates": [[[[-118.31957, 33.74707], [-118.31942, 33.74709], [-118.31936, 33.7467], [-118.3191, 33.74575], [-118.31911, 33.7457], [-118.31924, 33.74568], [-118.31926, 33.7457], [-118.31947, 33.74646], [-118.31954, 33.74679], [-118.31957, 33.74707]]], [[[-118.31996, 33.74921], [-118.31982, 33.74928], [-118.31971, 33.74913], [-118.31966, 33.74901], [-118.31962, 33.74886], [-118.31962, 33.74877], [-118.31968, 33.74836], [-118.31968, 33.74813], [-118.31963, 33.74788], [-118.31952, 33.74756], [-118.31942, 33.74714], [-118.31959, 33.74712], [-118.31963, 33.74737], [-118.31978, 33.74782], [-118.31983, 33.74803], [-118.31984, 33.74831], [-118.3198, 33.74887], [-118.31988, 33.74908], [-118.31996, 33.74921]]], [[[-118.32135, 33.75015], [-118.3213, 33.75029], [-118.32109, 33.75022], [-118.32063, 33.75], [-118.32023, 33.74971], [-118.32002, 33.74952], [-118.31987, 33.74934], [-118.32002, 33.74926], [-118.32025, 33.74952], [-118.32053, 33.74976], [-118.32098, 33.75001], [-118.32135, 33.75015]]], [[[-118.32351, 33.7498], [-118.32345, 33.74985], [-118.32325, 33.74997], [-118.32303, 33.75005], [-118.32211, 33.7503], [-118.32178, 33.75034], [-118.32159, 33.75034], [-118.32137, 33.7503], [-118.32143, 33.75017], [-118.32165, 33.7502], [-118.32191, 33.75019], [-118.32351, 33.7498]]], [[[-118.32508, 33.74962], [-118.32433, 33.74974], [-118.32383, 33.74986], [-118.32381, 33.7498], [-118.32406, 33.74967], [-118.32419, 33.74964], [-118.32504, 33.74949], [-118.32508, 33.74962]]]]} | Open Access 1 | Miraleste Median | 31778 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 3.263 | Miraleste Median | ||
74 | 74 | 73 | {"type": "Polygon", "coordinates": [[[-118.32587, 33.74953], [-118.32572, 33.74942], [-118.32569, 33.74937], [-118.32556, 33.74827], [-118.32549, 33.74805], [-118.32543, 33.74795], [-118.32579, 33.74783], [-118.32587, 33.74783], [-118.32587, 33.74785], [-118.32587, 33.74953]]]} | Open Access 1 | Miltenberger Park | 31779 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 1.103 | Miltenberger Park | ||
75 | 75 | 74 | {"type": "Polygon", "coordinates": [[[-118.319, 33.74614], [-118.31877, 33.74618], [-118.31864, 33.74623], [-118.31846, 33.74607], [-118.31846, 33.74603], [-118.31855, 33.74586], [-118.3188, 33.74581], [-118.31892, 33.74587], [-118.319, 33.74614]]]} | Open Access 1 | Miraleste Park | 31780 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 0.395 | Miraleste Park | ||
76 | 76 | 75 | {"type": "Polygon", "coordinates": [[[-118.32588, 33.7512], [-118.32569, 33.75113], [-118.32582, 33.75079], [-118.32552, 33.75069], [-118.32515, 33.75073], [-118.32511, 33.75097], [-118.32475, 33.75096], [-118.32454, 33.75099], [-118.32427, 33.75107], [-118.32405, 33.75118], [-118.32387, 33.751], [-118.32318, 33.75133], [-118.32271, 33.75141], [-118.32253, 33.75149], [-118.32265, 33.75175], [-118.32264, 33.75176], [-118.32258, 33.75178], [-118.32243, 33.75155], [-118.32134, 33.75207], [-118.32135, 33.75226], [-118.32116, 33.75229], [-118.32107, 33.75233], [-118.32097, 33.75239], [-118.32079, 33.75224], [-118.32044, 33.75241], [-118.31947, 33.75237], [-118.31862, 33.75274], [-118.31877, 33.753], [-118.31873, 33.75321], [-118.31842, 33.75321], [-118.31842, 33.75196], [-118.3186, 33.7517], [-118.31861, 33.7518], [-118.3187, 33.7517], [-118.31875, 33.75173], [-118.31877, 33.75211], [-118.31926, 33.75203], [-118.32016, 33.75204], [-118.32047, 33.75195], [-118.32125, 33.7514], [-118.32161, 33.75107], [-118.32246, 33.75079], [-118.32384, 33.75045], [-118.32372, 33.75006], [-118.32393, 33.75001], [-118.32412, 33.75038], [-118.32457, 33.75026], [-118.32529, 33.75014], [-118.32553, 33.74992], [-118.32587, 33.75017], [-118.32588, 33.7512]]]} | Open Access 1 | Canada Park | 31781 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 13.194 | Canada Park | ||
77 | 77 | 76 | {"type": "Polygon", "coordinates": [[[-118.31871, 33.75148], [-118.3186, 33.75159], [-118.3186, 33.7517], [-118.31842, 33.75196], [-118.31843, 33.74806], [-118.31846, 33.74607], [-118.31864, 33.74623], [-118.31866, 33.74651], [-118.31866, 33.7466], [-118.31862, 33.74662], [-118.31859, 33.75137], [-118.31871, 33.75148]]]} | Open Access 1 | Lorraine Trail | 31782 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2.558 | Lorraine Trail | ||
80 | 80 | 79 | {"type": "Polygon", "coordinates": [[[-121.77853, 37.07588], [-121.76509, 37.07542], [-121.76501, 37.07143], [-121.76791, 37.06968], [-121.76826, 37.07015], [-121.76836, 37.07057], [-121.76857, 37.07105], [-121.76854, 37.07122], [-121.76836, 37.07142], [-121.76851, 37.07179], [-121.76829, 37.07195], [-121.76806, 37.07225], [-121.76777, 37.07252], [-121.76769, 37.0727], [-121.76771, 37.07293], [-121.76757, 37.0733], [-121.76764, 37.07378], [-121.76775, 37.07403], [-121.76803, 37.07423], [-121.76821, 37.07467], [-121.76813, 37.0749], [-121.76814, 37.07491], [-121.77093, 37.07339], [-121.77067, 37.07249], [-121.77067, 37.07238], [-121.77157, 37.07239], [-121.77158, 37.07188], [-121.77848, 37.07211], [-121.77853, 37.07588]]]} | No Public Access 3 | Croy Redwoods | 31791 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 115.547 | Croy Redwoods | 2018 | |
84 | 84 | 83 | {"type": "Polygon", "coordinates": [[[-122.69582, 38.54625], [-122.69567, 38.54622], [-122.6949, 38.54581], [-122.69432, 38.54576], [-122.69338, 38.54514], [-122.69307, 38.54474], [-122.69284, 38.54396], [-122.69244, 38.5437], [-122.69183, 38.54277], [-122.69113, 38.54204], [-122.69108, 38.54018], [-122.69581, 38.54015], [-122.69582, 38.54625]]]} | No Public Access 3 | Wendle Property | 31796 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 50.237 | Wendle Property | 2018 | |
109 | 109 | 108 | {"type": "Polygon", "coordinates": [[[-121.9074, 36.56068], [-121.90715, 36.56057], [-121.90645, 36.56038], [-121.9058, 36.56048], [-121.90561, 36.56076], [-121.90567, 36.56101], [-121.9061, 36.56184], [-121.90658, 36.56217], [-121.9069, 36.56188], [-121.90692, 36.5619], [-121.90692, 36.56195], [-121.90682, 36.56207], [-121.90677, 36.56217], [-121.90674, 36.56228], [-121.90673, 36.56241], [-121.90259, 36.56001], [-121.90101, 36.56162], [-121.90195, 36.55734], [-121.90282, 36.55745], [-121.90344, 36.55788], [-121.90366, 36.55858], [-121.90421, 36.55869], [-121.90476, 36.55775], [-121.90484, 36.55822], [-121.90585, 36.55863], [-121.90669, 36.55928], [-121.9074, 36.56068]]]} | Open Access 1 | Hatton Canyon Open Space | 19738 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 34.94 | Hatton Canyon OS | ||
113 | 113 | 112 | {"type": "Polygon", "coordinates": [[[-121.5396, 38.7289], [-121.53955, 38.73052], [-121.53953, 38.73375], [-121.53067, 38.73375], [-121.53068, 38.72896], [-121.5396, 38.7289]]]} | No Public Access 3 | Bianchi West | 16062 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 102.176 | Bianchi West | ||
117 | 117 | 116 | {"type": "Polygon", "coordinates": [[[-121.72392, 37.72515], [-121.72391, 37.72701], [-121.71937, 37.72699], [-121.71955, 37.72651], [-121.71934, 37.72518], [-121.71901, 37.72496], [-121.71905, 37.72481], [-121.71958, 37.72492], [-121.72009, 37.72486], [-121.72039, 37.72492], [-121.72092, 37.72511], [-121.72158, 37.72515], [-121.72198, 37.72506], [-121.72233, 37.72491], [-121.72253, 37.72495], [-121.72267, 37.72508], [-121.72367, 37.72516], [-121.72392, 37.72515]]]} | No Public Access 3 | Garaventa Wetlands Preserve | https://www.larpd.org/garaventa-wetlands | 31818 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 21.408 | Garaventa Wetlands Preserve | |
118 | 118 | 117 | {"type": "Polygon", "coordinates": [[[-121.71671, 37.72148], [-121.71669, 37.72289], [-121.71655, 37.72282], [-121.71638, 37.72284], [-121.7163, 37.72283], [-121.71614, 37.72271], [-121.71604, 37.72268], [-121.71589, 37.72271], [-121.7157, 37.7228], [-121.71557, 37.72281], [-121.71548, 37.72278], [-121.71522, 37.72262], [-121.71518, 37.72256], [-121.71517, 37.72242], [-121.71509, 37.72236], [-121.71509, 37.72164], [-121.71547, 37.72166], [-121.71605, 37.72163], [-121.71635, 37.72158], [-121.71671, 37.72148]]]} | Open Access 1 | Altamont Creek Park | 31819 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 4.385 | Altamont Creek Park | ||
129 | 129 | 128 | {"type": "Polygon", "coordinates": [[[-118.68396, 34.04189], [-118.68229, 34.04179], [-118.68173, 34.04176], [-118.68178, 34.0414], [-118.68203, 34.04139], [-118.6821, 34.0415], [-118.68391, 34.0416], [-118.68396, 34.04189]]]} | Open Access 1 | Hendler Open Space | 19817 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 1.661 | Hendler OS | ||
142 | 142 | 141 | {"type": "Polygon", "coordinates": [[[-118.86847, 34.16213], [-118.86844, 34.16602], [-118.86617, 34.16601], [-118.86506, 34.16543], [-118.86467, 34.16666], [-118.86465, 34.16679], [-118.86444, 34.16674], [-118.8643, 34.16664], [-118.86415, 34.16656], [-118.86399, 34.16651], [-118.86322, 34.16645], [-118.86311, 34.1664], [-118.86303, 34.1663], [-118.86238, 34.16652], [-118.86152, 34.16653], [-118.86127, 34.16711], [-118.86113, 34.1681], [-118.86098, 34.16814], [-118.86105, 34.1684], [-118.85971, 34.16867], [-118.85993, 34.16927], [-118.86095, 34.16976], [-118.86073, 34.17007], [-118.86031, 34.16996], [-118.85986, 34.17013], [-118.85911, 34.17141], [-118.85928, 34.17173], [-118.85655, 34.17177], [-118.85651, 34.16546], [-118.85073, 34.16559], [-118.85068, 34.16209], [-118.86847, 34.16213]]]} | Open Access 1 | Conejo Ridge Open Space | http://www.conejo-openspace.org/open_space_areas_in_TO.htm#Conejo Ridge | 30797 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 227.891 | Conejo Ridge OS | |
154 | 154 | 153 | {"type": "MultiPolygon", "coordinates": [[[[-121.71486, 37.74156], [-121.7147, 37.75227], [-121.7146, 37.76668], [-121.69633, 37.76647], [-121.69658, 37.75215], [-121.69668, 37.73782], [-121.69679, 37.7305], [-121.69681, 37.72438], [-121.6975, 37.72388], [-121.69709, 37.72329], [-121.70059, 37.72331], [-121.70078, 37.72338], [-121.71057, 37.72331], [-121.71061, 37.72632], [-121.70985, 37.72633], [-121.70985, 37.72675], [-121.70601, 37.72678], [-121.70601, 37.7282], [-121.71452, 37.7369], [-121.71384, 37.73784], [-121.70576, 37.73784], [-121.70581, 37.74507], [-121.71036, 37.74507], [-121.70831, 37.74963], [-121.70584, 37.74899], [-121.70471, 37.74935], [-121.70307, 37.75083], [-121.70256, 37.75161], [-121.70184, 37.75238], [-121.70016, 37.75396], [-121.69983, 37.75501], [-121.69922, 37.75567], [-121.6986, 37.75645], [-121.69788, 37.75754], [-121.69727, 37.75852], [-121.69755, 37.75852], [-121.69902, 37.75662], [-121.69957, 37.75587], [-121.70019, 37.75511], [-121.70046, 37.75423], [-121.70222, 37.75251], [-121.70362, 37.75092], [-121.70493, 37.74973], [-121.70578, 37.74938], [-121.70849, 37.74992], [-121.71056, 37.74523], [-121.71073, 37.74422], [-121.7119, 37.74311], [-121.71243, 37.74178], [-121.71256, 37.74156], [-121.71486, 37.74156]]], [[[-121.71486, 37.73725], [-121.71485, 37.73785], [-121.71406, 37.73784], [-121.71463, 37.73702], [-121.71486, 37.73725]]]]} | Open Access 1 | Brushy Peak Regional Preserve | http://www.larpd.org/open_space/brushy_peak.html | 5287 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 1584.798 | Brushy Peak RPr | 2005 |
160 | 160 | 159 | {"type": "Polygon", "coordinates": [[[-118.06854, 33.96506], [-118.06786, 33.96522], [-118.06772, 33.96583], [-118.06705, 33.96582], [-118.06704, 33.96591], [-118.06669, 33.96591], [-118.06666, 33.9658], [-118.06616, 33.96578], [-118.06653, 33.96476], [-118.06654, 33.96478], [-118.06731, 33.9648], [-118.06733, 33.96478], [-118.06851, 33.96481], [-118.06854, 33.96506]]]} | Restricted Access 2 | Aeolian Elementary School Park | 31844 | 2376 | Los Nietos School District 893 | Special District 4 | School District 21 | http://www.losnietos.k12.ca.us/ | Special District 4 | 4.512 | Aeolian Elementary School Park | ||
164 | 164 | 163 | {"type": "Polygon", "coordinates": [[[-121.74145, 37.61399], [-121.74132, 37.61413], [-121.74116, 37.61418], [-121.74067, 37.61426], [-121.74045, 37.61437], [-121.74047, 37.61426], [-121.74145, 37.61399]]]} | Open Access 1 | Lake Del Valle SRA | http://www.parks.ca.gov/?page_id=537 | 1594 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 0.204 | Lake Del Valle SRA | 2000 |
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]);