units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where MNG_AGENCY = 322 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, LABEL_NAME
DES_TP 3
- Local Park 32
- Local Recreation Area 18
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 51
MNG_AGENCY 1
- Santa Clarita, City of · 51 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11922 | 11922 | 11921 | {"type": "Polygon", "coordinates": [[[-118.52735, 34.42936], [-118.52648, 34.4312], [-118.52377, 34.4344], [-118.52375, 34.4344], [-118.52373, 34.43438], [-118.52366, 34.4344], [-118.52366, 34.43443], [-118.52356, 34.43446], [-118.52356, 34.43443], [-118.52349, 34.43445], [-118.52292, 34.43464], [-118.52289, 34.43469], [-118.51956, 34.43606], [-118.51934, 34.43614], [-118.51921, 34.4362], [-118.51911, 34.43628], [-118.51872, 34.4365], [-118.51866, 34.43641], [-118.51824, 34.43627], [-118.51752, 34.43616], [-118.51675, 34.43564], [-118.51612, 34.43492], [-118.51601, 34.43454], [-118.51599, 34.43359], [-118.51617, 34.43263], [-118.51638, 34.43244], [-118.51689, 34.43217], [-118.51741, 34.43224], [-118.5181, 34.43224], [-118.51831, 34.43207], [-118.51831, 34.43205], [-118.51798, 34.43182], [-118.51716, 34.43158], [-118.51793, 34.43112], [-118.51839, 34.43118], [-118.51902, 34.43111], [-118.51991, 34.43113], [-118.52057, 34.43153], [-118.521, 34.43155], [-118.52124, 34.43111], [-118.52235, 34.4297], [-118.52232, 34.42936], [-118.52204, 34.42904], [-118.52188, 34.42879], [-118.52198, 34.42861], [-118.52249, 34.42859], [-118.52301, 34.42894], [-118.52339, 34.42892], [-118.52384, 34.42887], [-118.52422, 34.42833], [-118.52466, 34.42818], [-118.52512, 34.42828], [-118.5253, 34.42868], [-118.52648, 34.42868], [-118.52735, 34.42936]]]} | Open Access 1 | 24527 | Central Park | 5954 | 2340 | Castaic Lake Water Agency 1002 | Special District 4 | Water District 13 | http://clwa.org/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=409 | Los Angeles 6 | 122.849 | Central Park | 0 | Local Park 2 | 4 |
1297 | 1297 | 1296 | {"type": "Polygon", "coordinates": [[[-118.5452, 34.39992], [-118.54518, 34.40007], [-118.54511, 34.40016], [-118.54512, 34.40031], [-118.54511, 34.40039], [-118.54481, 34.40102], [-118.54462, 34.4013], [-118.54457, 34.40143], [-118.54453, 34.40157], [-118.5444, 34.40157], [-118.54422, 34.40153], [-118.54382, 34.40139], [-118.54351, 34.40121], [-118.54338, 34.40112], [-118.5432, 34.40096], [-118.54313, 34.40089], [-118.54486, 34.39997], [-118.54492, 34.39998], [-118.54516, 34.3999], [-118.5452, 34.39992]]]} | Open Access 1 | 7271 | Almendra Park | 15395 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 4.337 | Almendra Park | 0 | Local Park 2 | 4 | |
7586 | 7586 | 7585 | {"type": "Polygon", "coordinates": [[[-118.39597, 34.43856], [-118.39415, 34.43852], [-118.39416, 34.43766], [-118.39535, 34.4373], [-118.39547, 34.43749], [-118.39559, 34.43762], [-118.39566, 34.43772], [-118.39571, 34.43786], [-118.39571, 34.43806], [-118.39573, 34.43819], [-118.39584, 34.43841], [-118.39597, 34.43856]]]} | Open Access 1 | 7286 | Begonias Lane Park | 15956 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 4.192 | Begonias Lane Park | 0 | Local Park 2 | 4 | |
1144 | 1144 | 1143 | {"type": "Polygon", "coordinates": [[[-118.50693, 34.45383], [-118.50419, 34.45385], [-118.50418, 34.45232], [-118.50691, 34.4523], [-118.50693, 34.45383]]]} | Open Access 1 | 7283 | Bouquet Canyon Park | 16302 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 10.567 | Bouquet Canyon Park | 0 | Local Park 2 | 4 | |
10860 | 10860 | 10859 | {"type": "Polygon", "coordinates": [[[-118.55086, 34.42777], [-118.55071, 34.42814], [-118.55003, 34.42806], [-118.54982, 34.42802], [-118.54982, 34.428], [-118.54977, 34.42799], [-118.54976, 34.42802], [-118.54855, 34.42796], [-118.54655, 34.42794], [-118.54585, 34.42615], [-118.54604, 34.42614], [-118.54672, 34.42619], [-118.54707, 34.42614], [-118.54709, 34.42619], [-118.54768, 34.42609], [-118.54894, 34.42607], [-118.54869, 34.42636], [-118.55086, 34.42777]]]} | Open Access 1 | 20658 | Bridgeport Park | 16380 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 16.763 | Bridgeport Park | 0 | Local Park 2 | 4 | |
7582 | 7582 | 7581 | {"type": "Polygon", "coordinates": [[[-118.44384, 34.41824], [-118.44384, 34.42005], [-118.44302, 34.42005], [-118.4434, 34.41864], [-118.4434, 34.41856], [-118.44299, 34.41855], [-118.44289, 34.41857], [-118.44114, 34.41916], [-118.44113, 34.41991], [-118.44113, 34.42005], [-118.44117, 34.42006], [-118.44116, 34.42057], [-118.44077, 34.42049], [-118.44047, 34.42047], [-118.43976, 34.42049], [-118.43946, 34.42053], [-118.43928, 34.42006], [-118.43969, 34.42005], [-118.44045, 34.41837], [-118.44071, 34.41825], [-118.44153, 34.41795], [-118.44178, 34.41784], [-118.44211, 34.41765], [-118.44281, 34.41717], [-118.44314, 34.41761], [-118.44349, 34.41772], [-118.44373, 34.41794], [-118.44374, 34.41822], [-118.44384, 34.41824]]]} | Open Access 1 | 7276 | Canyon Country Park | 16810 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 16.457 | Canyon Country Park | 0 | Local Park 2 | 4 | |
10861 | 10861 | 10860 | {"type": "Polygon", "coordinates": [[[-118.5352, 34.39926], [-118.53465, 34.39935], [-118.53487, 34.40053], [-118.53406, 34.40064], [-118.53387, 34.39968], [-118.53393, 34.39948], [-118.53438, 34.39903], [-118.53426, 34.39892], [-118.53412, 34.39903], [-118.5338, 34.39935], [-118.53374, 34.39902], [-118.5341, 34.39885], [-118.53451, 34.3986], [-118.53459, 34.39899], [-118.53464, 34.39893], [-118.53468, 34.39894], [-118.53475, 34.39884], [-118.53489, 34.39877], [-118.53505, 34.39864], [-118.53505, 34.39879], [-118.5352, 34.39926]]]} | Open Access 1 | 20659 | Circle J Ranch Park | 17263 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 4.091 | Circle J Ranch Park | 0 | Local Park 2 | 4 | |
10862 | 10862 | 10861 | {"type": "Polygon", "coordinates": [[[-118.52166, 34.37788], [-118.52155, 34.37794], [-118.5216, 34.37802], [-118.52101, 34.37832], [-118.51896, 34.37592], [-118.51945, 34.37515], [-118.52016, 34.37582], [-118.52058, 34.37646], [-118.52104, 34.37623], [-118.52134, 34.37749], [-118.52166, 34.37788]]]} | Open Access 1 | 20660 | Creekview Park | 17788 | 6102 | The Master's College 959 | Private 7 | Education 35 | http://www.masters.edu/ | Private 14 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=411 | Los Angeles 6 | 8.223 | Creekview Park | 0 | Local Park 2 | 4 |
10868 | 10868 | 10867 | {"type": "Polygon", "coordinates": [[[-118.51608, 34.38791], [-118.51584, 34.3888], [-118.51372, 34.38841], [-118.51347, 34.3893], [-118.51227, 34.38908], [-118.51276, 34.3873], [-118.51608, 34.38791]]]} | Open Access 1 | 25035 | Emmaus Park | 18631 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 10.676 | Emmaus Park | 0 | Local Park 2 | 4 | |
7580 | 7580 | 7579 | {"type": "Polygon", "coordinates": [[[-118.54181, 34.38614], [-118.5392, 34.38764], [-118.53914, 34.38762], [-118.53796, 34.38621], [-118.54059, 34.3847], [-118.54181, 34.38614]]]} | Open Access 1 | 7273 | Newhall Park | 22726 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 14.293 | Newhall Park | 0 | Local Park 2 | 4 | |
4020 | 4020 | 4019 | {"type": "Polygon", "coordinates": [[[-118.55199, 34.43912], [-118.55125, 34.43945], [-118.54943, 34.43532], [-118.54883, 34.43379], [-118.54922, 34.4338], [-118.55004, 34.43375], [-118.55053, 34.43501], [-118.55067, 34.43532], [-118.55037, 34.43541], [-118.55036, 34.43542], [-118.55199, 34.43912]]]} | Open Access 1 | 44058 | Northbridge Park | 22868 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=811 | Los Angeles 6 | 13.592 | Northbridge Park | 0 | Local Park 2 | 4 |
7568 | 7568 | 7567 | {"type": "Polygon", "coordinates": [[[-118.553, 34.43747], [-118.55301, 34.43773], [-118.55298, 34.43794], [-118.55289, 34.43823], [-118.5528, 34.43842], [-118.55263, 34.43864], [-118.55245, 34.43883], [-118.55225, 34.43898], [-118.552, 34.43912], [-118.55144, 34.43787], [-118.55267, 34.4375], [-118.553, 34.43747]]]} | Open Access 1 | 7279 | Northbridge Park | 22868 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=811 | Los Angeles 6 | 3.887 | Northbridge Park | 0 | Local Park 2 | 4 |
7587 | 7587 | 7586 | {"type": "Polygon", "coordinates": [[[-118.41379, 34.43115], [-118.41378, 34.43103], [-118.41362, 34.43103], [-118.41335, 34.43038], [-118.41411, 34.43019], [-118.41439, 34.43019], [-118.41447, 34.42991], [-118.41473, 34.42992], [-118.41505, 34.42992], [-118.41508, 34.42995], [-118.41508, 34.43102], [-118.41508, 34.43191], [-118.41454, 34.43139], [-118.41426, 34.4312], [-118.41413, 34.43116], [-118.41379, 34.43115]]]} | Open Access 1 | 7287 | Oak Spring Park | 23006 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 4.909 | Oak Spring Park | 0 | Local Park 2 | 4 | |
7579 | 7579 | 7578 | {"type": "Polygon", "coordinates": [[[-118.54936, 34.37941], [-118.54915, 34.38025], [-118.54884, 34.3801], [-118.54667, 34.38023], [-118.54631, 34.38034], [-118.54612, 34.37991], [-118.54608, 34.37971], [-118.54608, 34.37963], [-118.54614, 34.37958], [-118.54936, 34.37941]]]} | Open Access 1 | 7272 | Old Orchard Park | 23096 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 5.386 | Old Orchard Park | 0 | Local Park 2 | 4 | |
1284 | 1284 | 1283 | {"type": "Polygon", "coordinates": [[[-118.52879, 34.45008], [-118.52769, 34.45186], [-118.52742, 34.45177], [-118.52714, 34.4517], [-118.52679, 34.45165], [-118.52658, 34.45164], [-118.52658, 34.45113], [-118.52664, 34.45086], [-118.52677, 34.45061], [-118.52751, 34.44954], [-118.52879, 34.45008]]]} | Open Access 1 | 7281 | Pamplico Park | 23381 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 7.596 | Pamplico Park | 0 | Local Park 2 | 4 | |
7569 | 7569 | 7568 | {"type": "Polygon", "coordinates": [[[-118.53612, 34.44773], [-118.53506, 34.44778], [-118.53487, 34.44533], [-118.5361, 34.44527], [-118.53612, 34.44773]]]} | Open Access 1 | 7280 | Santa Clarita Park | 25059 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 7.126 | Santa Clarita Park | 0 | Local Park 2 | 4 | |
7576 | 7576 | 7575 | {"type": "Polygon", "coordinates": [[[-118.55064, 34.39482], [-118.55036, 34.39498], [-118.55004, 34.39522], [-118.54984, 34.39542], [-118.54956, 34.39575], [-118.54943, 34.39584], [-118.54939, 34.39588], [-118.54936, 34.39588], [-118.54928, 34.39603], [-118.54866, 34.39579], [-118.54863, 34.39585], [-118.54858, 34.396], [-118.54855, 34.396], [-118.54854, 34.39603], [-118.54833, 34.396], [-118.54817, 34.39593], [-118.54799, 34.39579], [-118.54791, 34.3957], [-118.54781, 34.39553], [-118.54776, 34.39534], [-118.54772, 34.39529], [-118.54765, 34.39524], [-118.54759, 34.39523], [-118.54758, 34.39519], [-118.54755, 34.39519], [-118.54747, 34.39491], [-118.54759, 34.39483], [-118.54754, 34.39476], [-118.54766, 34.3947], [-118.5478, 34.3946], [-118.54794, 34.39451], [-118.54798, 34.39455], [-118.5481, 34.3945], [-118.54813, 34.39456], [-118.54821, 34.3946], [-118.54821, 34.39468], [-118.54847, 34.39482], [-118.54843, 34.39488], [-118.54849, 34.39495], [-118.54862, 34.39502], [-118.5487, 34.39501], [-118.54871, 34.39504], [-118.54876, 34.39508], [-118.54883, 34.3951], [-118.54884, 34.39517], [-118.54909, 34.39529], [-118.55, 34.39402], [-118.55012, 34.39408], [-118.55045, 34.39451], [-118.55064, 34.39482]]]} | Open Access 1 | 7270 | Valencia Glen Park | 26760 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 7.254 | Valencia Glen Park | 0 | Local Park 2 | 4 | |
2992 | 2992 | 2991 | {"type": "Polygon", "coordinates": [[[-118.56068, 34.43413], [-118.56002, 34.43551], [-118.5576, 34.43343], [-118.55733, 34.43364], [-118.55685, 34.43445], [-118.55657, 34.43436], [-118.55621, 34.43433], [-118.55618, 34.4343], [-118.55621, 34.4341], [-118.55632, 34.43382], [-118.55636, 34.43348], [-118.55651, 34.4331], [-118.55685, 34.43256], [-118.55705, 34.43236], [-118.55746, 34.43187], [-118.55752, 34.43183], [-118.55758, 34.43182], [-118.5577, 34.43185], [-118.55793, 34.43203], [-118.55802, 34.43215], [-118.55808, 34.43222], [-118.5586, 34.43253], [-118.55938, 34.4331], [-118.56068, 34.43413]]]} | Open Access 1 | 20657 | Valencia Heritage Park | 26762 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 17.559 | Valencia Heritage Park | 0 | Local Park 2 | 4 | |
7581 | 7581 | 7580 | {"type": "Polygon", "coordinates": [[[-118.55633, 34.39477], [-118.55578, 34.39487], [-118.55576, 34.3948], [-118.55602, 34.39465], [-118.55597, 34.39448], [-118.55601, 34.39444], [-118.55602, 34.39437], [-118.55598, 34.39432], [-118.55587, 34.39423], [-118.55454, 34.39252], [-118.55448, 34.3924], [-118.55466, 34.39242], [-118.55585, 34.39202], [-118.55597, 34.3918], [-118.55612, 34.39197], [-118.55617, 34.39208], [-118.55619, 34.39223], [-118.55619, 34.39415], [-118.55615, 34.39427], [-118.55615, 34.39432], [-118.55619, 34.39437], [-118.55626, 34.3944], [-118.55625, 34.39446], [-118.55633, 34.39477]]]} | Open Access 1 | 7275 | Valencia Meadows Park | 26763 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 6.124 | Valencia Meadows Park | 0 | Local Park 2 | 4 | |
16234 | 16234 | 16233 | {"type": "Polygon", "coordinates": [[[-118.51584, 34.47057], [-118.51585, 34.47425], [-118.51582, 34.47789], [-118.51139, 34.47789], [-118.51138, 34.48164], [-118.50248, 34.48162], [-118.50251, 34.4779], [-118.49829, 34.47782], [-118.49832, 34.47411], [-118.4941, 34.47405], [-118.49413, 34.47035], [-118.4875, 34.47028], [-118.48753, 34.46757], [-118.48974, 34.46758], [-118.48975, 34.46662], [-118.49726, 34.46667], [-118.49772, 34.46108], [-118.49823, 34.4609], [-118.49852, 34.46081], [-118.49884, 34.46073], [-118.4992, 34.46067], [-118.49962, 34.46063], [-118.50004, 34.46062], [-118.50062, 34.46065], [-118.5012, 34.46075], [-118.50168, 34.46087], [-118.50214, 34.46104], [-118.50258, 34.46124], [-118.50263, 34.46671], [-118.51144, 34.46693], [-118.51142, 34.47053], [-118.51343, 34.47056], [-118.51341, 34.47099], [-118.51335, 34.47105], [-118.51331, 34.47106], [-118.51326, 34.47111], [-118.51308, 34.47121], [-118.51299, 34.47122], [-118.51293, 34.47117], [-118.5129, 34.47117], [-118.51281, 34.47123], [-118.51266, 34.47126], [-118.51264, 34.47131], [-118.5126, 34.47133], [-118.51251, 34.47132], [-118.51243, 34.47135], [-118.51225, 34.47148], [-118.5121, 34.47154], [-118.5121, 34.47165], [-118.51194, 34.47177], [-118.51186, 34.4718], [-118.51171, 34.47178], [-118.51169, 34.47183], [-118.51179, 34.47199], [-118.51183, 34.47224], [-118.51183, 34.4723], [-118.51175, 34.47245], [-118.51177, 34.47254], [-118.51182, 34.47258], [-118.51163, 34.47342], [-118.51246, 34.47335], [-118.51285, 34.47328], [-118.51358, 34.47251], [-118.51383, 34.47216], [-118.51392, 34.47207], [-118.514, 34.47194], [-118.51412, 34.47189], [-118.51414, 34.47173], [-118.51424, 34.47166], [-118.51436, 34.47167], [-118.51438, 34.47166], [-118.5144, 34.47162], [-118.51461, 34.47206], [-118.51484, 34.47206], [-118.51513, 34.4716], [-118.51512, 34.4717], [-118.51516, 34.47172], [-118.51525, 34.47167], [-118.51531, 34.47159], [-118.51543, 34.47155], [-118.51554, 34.47136], [-118.51565, 34.47122], [-118.5158, 34.47107], [-118.51578, 34.47083], [-118.51557, 34.47057], [-118.51584, 34.47057]]]} | Open Access 1 | 45603 | Haskell Canyon Open Space | 28429 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 726.54 | Haskell Canyon OS | 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]);