units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
49 rows where ACCESS_TYP = 1 and AGNCY_NAME = 325
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP, DES_TP
MNG_AGENCY 2
ACCESS_TYP 1
- Open Access · 49 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
3259 | 3259 | 3258 | {"type": "MultiPolygon", "coordinates": [[[[-118.53244, 34.46826], [-118.52928, 34.46833], [-118.52923, 34.46815], [-118.52921, 34.46799], [-118.52921, 34.46783], [-118.52923, 34.46767], [-118.52931, 34.46741], [-118.52962, 34.46667], [-118.53231, 34.46662], [-118.53235, 34.46664], [-118.5324, 34.4669], [-118.53256, 34.46743], [-118.53259, 34.46761], [-118.53259, 34.46776], [-118.53257, 34.46794], [-118.53252, 34.46809], [-118.53244, 34.46826]]], [[[-118.53427, 34.46657], [-118.53418, 34.46793], [-118.53413, 34.46822], [-118.53267, 34.46826], [-118.53274, 34.46811], [-118.53278, 34.46794], [-118.53281, 34.46776], [-118.53281, 34.46761], [-118.53277, 34.4674], [-118.53261, 34.46686], [-118.53256, 34.46661], [-118.53427, 34.46657]]]]} | Open Access 1 | 48184 | Mountain View Park | 32720 | 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 | 19.342 | Mtn. View Park | 0 | Local Park 2 | 4 | |
3261 | 3261 | 3260 | {"type": "Polygon", "coordinates": [[[-118.55494, 34.44777], [-118.55391, 34.44758], [-118.55351, 34.44757], [-118.55306, 34.44759], [-118.55321, 34.44728], [-118.55333, 34.44695], [-118.55344, 34.44661], [-118.55347, 34.44659], [-118.55446, 34.4467], [-118.55494, 34.44777]]]} | Open Access 1 | 48183 | Summerhill Park | 32719 | 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 | 3.493 | Summerhill 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 |
4408 | 4408 | 4407 | {"type": "Polygon", "coordinates": [[[-118.55874, 34.40582], [-118.55864, 34.40606], [-118.55852, 34.40619], [-118.55843, 34.40633], [-118.55825, 34.40674], [-118.55808, 34.40688], [-118.55799, 34.40703], [-118.558, 34.40721], [-118.5581, 34.4074], [-118.55781, 34.40752], [-118.55768, 34.40753], [-118.55757, 34.40749], [-118.55743, 34.40736], [-118.55717, 34.40725], [-118.55703, 34.40723], [-118.5569, 34.40728], [-118.55678, 34.40735], [-118.55643, 34.40742], [-118.55628, 34.40749], [-118.55641, 34.40778], [-118.55615, 34.40793], [-118.55557, 34.40723], [-118.55637, 34.40679], [-118.55641, 34.40682], [-118.55727, 34.40635], [-118.55752, 34.40606], [-118.55766, 34.40574], [-118.55794, 34.40547], [-118.55874, 34.40582]]]} | Open Access 1 | 46217 | Valencia Summit Park | 29511 | 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/Home/Components/FacilityDirectory/FacilityDirectory/82/1386 | Los Angeles 6 | 7.366 | Valencia Summit Park | 0 | Local Park 2 | 4 |
4433 | 4433 | 4432 | {"type": "MultiPolygon", "coordinates": [[[[-118.2896, 34.44511], [-118.28959, 34.44876], [-118.2854, 34.44869], [-118.28535, 34.44505], [-118.2896, 34.44511]]], [[[-118.29626, 34.44876], [-118.29406, 34.44876], [-118.29404, 34.44571], [-118.29402, 34.44509], [-118.29623, 34.44508], [-118.29626, 34.44876]]], [[[-118.32311, 34.4672], [-118.32304, 34.46725], [-118.32117, 34.46822], [-118.32115, 34.46719], [-118.32311, 34.4672]]]]} | Open Access 1 | 46400 | Agua Dulce Canyon Parkland | 29553 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 61.59 | Agua Dulce Canyon Parkland | 0 | Local Park 2 | 4 | |
4948 | 4948 | 4947 | {"type": "MultiPolygon", "coordinates": [[[[-118.5101, 34.34486], [-118.50618, 34.34465], [-118.50656, 34.34395], [-118.50649, 34.3432], [-118.50688, 34.3418], [-118.50724, 34.34095], [-118.50722, 34.34007], [-118.50774, 34.33964], [-118.5078, 34.33937], [-118.50772, 34.33916], [-118.50812, 34.33937], [-118.50833, 34.33951], [-118.50851, 34.33967], [-118.50875, 34.33994], [-118.50888, 34.34014], [-118.50898, 34.34035], [-118.50899, 34.34038], [-118.50895, 34.34057], [-118.50897, 34.3407], [-118.50902, 34.34082], [-118.50913, 34.34096], [-118.5091, 34.34099], [-118.50918, 34.3411], [-118.50928, 34.34149], [-118.50927, 34.34161], [-118.50929, 34.34169], [-118.50935, 34.34176], [-118.51006, 34.34462], [-118.5101, 34.34486]]], [[[-118.51238, 34.34498], [-118.51044, 34.34488], [-118.51038, 34.34456], [-118.50938, 34.34054], [-118.50925, 34.34017], [-118.50925, 34.33995], [-118.50921, 34.3398], [-118.50914, 34.33965], [-118.50904, 34.33953], [-118.50884, 34.33937], [-118.50869, 34.33929], [-118.50843, 34.33921], [-118.50816, 34.33905], [-118.50779, 34.33888], [-118.50789, 34.33866], [-118.50839, 34.33881], [-118.50908, 34.3384], [-118.51238, 34.34498]]], [[[-118.52867, 34.34888], [-118.51973, 34.34889], [-118.51974, 34.34714], [-118.5151, 34.34688], [-118.51522, 34.34514], [-118.51311, 34.34502], [-118.50912, 34.33703], [-118.50917, 34.33682], [-118.50936, 34.33678], [-118.5093, 34.33699], [-118.50931, 34.33708], [-118.50942, 34.33727], [-118.50944, 34.33725], [-118.50934, 34.33708], [-118.50934, 34.33702], [-118.50973, 34.3369], [-118.50995, 34.33696], [-118.50993, 34.33727], [-118.51012, 34.3374], [-118.5107, 34.33739], [-118.51095, 34.33715], [-118.51119, 34.33713], [-118.51129, 34.33719], [-118.51115, 34.33737], [-118.51111, 34.33738], [-118.51109, 34.33741], [-118.51094, 34.33745], [-118.51094, 34.33751], [-118.51119, 34.33746], [-118.51122, 34.33738], [-118.51134, 34.33722], [-118.51154, 34.33733], [-118.51156, 34.33741], [-118.5116, 34.33745], [-118.51168, 34.33746], [-118.51175, 34.33742], [-118.51338, 34.33813], [-118.5184, 34.34041], [-118.51929, 34.34083], [-118.51949, 34.34099], [-118.51978, 34.34119], [-118.51976, 34.34538], [-118.52865, 34.34534], [-118.52867, 34.34888]]], [[[-118.50972, 34.33687], [-118.50934, 34.33698], [-118.50934, 34.33698], [-118.5094, 34.33678], [-118.50961, 34.33677], [-118.50972, 34.33687]]], [[[-118.50995, 34.33688], [-118.50995, 34.33694], [-118.50976, 34.33688], [-118.50978, 34.33688], [-118.50995, 34.33688]]], [[[-118.51169, 34.3374], [-118.51164, 34.3374], [-118.51162, 34.33736], [-118.51165, 34.33738], [-118.51169, 34.3374]]]]} | Open Access 1 | 47481 | Valley Vista Open Space | 31203 | 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 | 284.605 | Valley Vista OS | 0 | Local Recreation Area 3 | 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 | |
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 | |
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 | |
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 | |
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 | |
7583 | 7583 | 7582 | {"type": "Polygon", "coordinates": [[[-118.52918, 34.37774], [-118.52876, 34.37796], [-118.5283, 34.37737], [-118.52918, 34.37774], [-118.52918, 34.37774]]]} | Open Access 1 | 7277 | Veterans Historical Plaza | 29505 | 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=422 | Los Angeles 6 | 0.434 | Veterans Historical Plaza | 0 | Local Park 2 | 4 |
7585 | 7585 | 7584 | {"type": "Polygon", "coordinates": [[[-118.54852, 34.45524], [-118.54772, 34.45535], [-118.54673, 34.45561], [-118.5462, 34.45564], [-118.54608, 34.45561], [-118.54585, 34.45444], [-118.54639, 34.45436], [-118.54704, 34.4543], [-118.54743, 34.45429], [-118.54834, 34.45432], [-118.54837, 34.45434], [-118.54839, 34.45437], [-118.54845, 34.45489], [-118.54852, 34.45524]]]} | Open Access 1 | 7284 | Chesebrough Park | 29034 | 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/chesebroughpark | Los Angeles 6 | 7.137 | Chesebrough 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 | |
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 |
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]);