units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17 rows where ACCESS_TYP = 2, AGNCY_ID = 1188, MNG_AGENCY = 24 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
DES_TP 4
MNG_AG_TYP 1
- City Agency · 17 ✖
MNG_AGENCY 1
- Los Angeles, City of · 17 ✖
ACCESS_TYP 1
- Restricted Access · 17 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2405 | 2405 | 2404 | {"type": "Polygon", "coordinates": [[[-118.40176, 34.26476], [-118.40163, 34.26535], [-118.40154, 34.26562], [-118.40143, 34.26588], [-118.40129, 34.26614], [-118.40113, 34.26638], [-118.40076, 34.26685], [-118.39988, 34.26605], [-118.39946, 34.26558], [-118.39897, 34.26483], [-118.39843, 34.26433], [-118.39782, 34.26399], [-118.39746, 34.26329], [-118.39631, 34.26249], [-118.3954, 34.26242], [-118.39351, 34.26158], [-118.39344, 34.2618], [-118.39335, 34.2618], [-118.39148, 34.26078], [-118.39103, 34.26066], [-118.39073, 34.26044], [-118.39031, 34.26113], [-118.38941, 34.26086], [-118.38925, 34.26121], [-118.38666, 34.26042], [-118.3866, 34.26035], [-118.38665, 34.259], [-118.38713, 34.25817], [-118.3865, 34.2579], [-118.38587, 34.25895], [-118.38448, 34.25843], [-118.38394, 34.2583], [-118.38325, 34.25843], [-118.38262, 34.25846], [-118.38042, 34.25817], [-118.37936, 34.25812], [-118.37816, 34.25822], [-118.37725, 34.25823], [-118.37614, 34.2584], [-118.37506, 34.25861], [-118.37403, 34.25861], [-118.37343, 34.25859], [-118.37384, 34.2578], [-118.37427, 34.25756], [-118.37765, 34.25587], [-118.37789, 34.25571], [-118.3781, 34.25552], [-118.37827, 34.25531], [-118.3784, 34.2551], [-118.38172, 34.25574], [-118.38181, 34.25558], [-118.38262, 34.25451], [-118.38266, 34.25435], [-118.38485, 34.25642], [-118.38492, 34.25637], [-118.39338, 34.25803], [-118.39555, 34.25899], [-118.39564, 34.25907], [-118.39587, 34.25891], [-118.39595, 34.25904], [-118.3961, 34.2592], [-118.39638, 34.25958], [-118.39669, 34.25992], [-118.40172, 34.26468], [-118.40173, 34.26475], [-118.40176, 34.26476]]]} | Restricted Access 2 | 45520 | Hansen Dam Golf Course | 28354 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://golf.lacity.org/cdp_hansen.htm | Los Angeles 6 | 201.493 | Hansen Dam GC | 0 | Local Recreation Area 3 | 4 |
2504 | 2504 | 2503 | {"type": "Polygon", "coordinates": [[[-118.4665, 34.00437], [-118.46104, 34.00726], [-118.46085, 34.00737], [-118.46087, 34.00741], [-118.45724, 34.00933], [-118.45601, 34.00775], [-118.4616, 34.00479], [-118.46148, 34.00472], [-118.46244, 34.00421], [-118.46252, 34.00428], [-118.46267, 34.00422], [-118.46531, 34.00282], [-118.4665, 34.00437]]]} | Restricted Access 2 | 6334 | Penmar Golf Course | 33009 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 52.132 | Penmar GC | 0 | Local Recreation Area 3 | 4 | |
2946 | 2946 | 2945 | {"type": "Polygon", "coordinates": [[[-118.43139, 34.07349], [-118.43133, 34.0739], [-118.43131, 34.07413], [-118.43128, 34.07416], [-118.43123, 34.07417], [-118.4312, 34.07415], [-118.43081, 34.0738], [-118.4306, 34.07366], [-118.4303, 34.07352], [-118.42983, 34.0734], [-118.42965, 34.0733], [-118.4295, 34.07319], [-118.42916, 34.07276], [-118.42892, 34.07255], [-118.42767, 34.07171], [-118.42764, 34.07166], [-118.42764, 34.0716], [-118.4278, 34.0712], [-118.42784, 34.07119], [-118.42921, 34.07171], [-118.42952, 34.07187], [-118.42979, 34.07208], [-118.43009, 34.07242], [-118.43027, 34.0726], [-118.43138, 34.07347], [-118.43139, 34.07349]]]} | Restricted Access 2 | 1906 | Holmby Park | 32999 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 8.535 | Holmby Park | 0 | Local Park 2 | 4 | |
4782 | 4782 | 4781 | {"type": "MultiPolygon", "coordinates": [[[[-118.31523, 34.27262], [-118.31155, 34.27525], [-118.31209, 34.27614], [-118.31019, 34.27715], [-118.31018, 34.27759], [-118.30864, 34.278], [-118.30827, 34.27922], [-118.30683, 34.28], [-118.30504, 34.28028], [-118.30418, 34.27659], [-118.3067, 34.27613], [-118.30776, 34.27606], [-118.30797, 34.27532], [-118.30739, 34.27455], [-118.3079, 34.27436], [-118.30845, 34.27422], [-118.30878, 34.27411], [-118.30893, 34.27404], [-118.30921, 34.27384], [-118.30958, 34.27409], [-118.31025, 34.27505], [-118.31221, 34.27344], [-118.31465, 34.27267], [-118.31408, 34.27288], [-118.31389, 34.27298], [-118.31396, 34.27307], [-118.31454, 34.27284], [-118.31523, 34.27262]], [[-118.30988, 34.27535], [-118.30988, 34.27534], [-118.30953, 34.27504], [-118.30924, 34.27461], [-118.30928, 34.27454], [-118.30927, 34.27453], [-118.30885, 34.27447], [-118.3087, 34.27429], [-118.30803, 34.27437], [-118.30782, 34.27443], [-118.30784, 34.27447], [-118.30799, 34.27441], [-118.3086, 34.27434], [-118.30861, 34.27438], [-118.30817, 34.27444], [-118.30816, 34.27446], [-118.30908, 34.27567], [-118.30988, 34.27535]]], [[[-118.31018, 34.27763], [-118.31014, 34.27952], [-118.30543, 34.28199], [-118.30505, 34.28031], [-118.30684, 34.28003], [-118.30831, 34.27923], [-118.30868, 34.27803], [-118.31018, 34.27763]]], [[[-118.31695, 34.27216], [-118.31632, 34.27264], [-118.31581, 34.27301], [-118.3158, 34.27253], [-118.31583, 34.27253], [-118.31587, 34.27248], [-118.31656, 34.27226], [-118.31695, 34.27216]]]]} | Restricted Access 2 | 47252 | Unnamed site - Los Angeles, City of | 30961 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 88.776 | 0 | Local Other or Unknown 14 | 4 | ||
5696 | 5696 | 5695 | {"type": "Polygon", "coordinates": [[[-118.29818, 34.06162], [-118.29723, 34.06162], [-118.29617, 34.06163], [-118.29617, 34.06159], [-118.29669, 34.06159], [-118.2967, 34.06149], [-118.29818, 34.06147], [-118.29818, 34.06162]]]} | Restricted Access 2 | 45735 | Robert F Kennedy Inspiration Park | 31643 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/commissionerhtm/pdf2010/oct06/10-266.pdf | Los Angeles 6 | 0.574 | Robert F Kennedy Inspiration Park | 0 | Local Park 2 | 4 |
5702 | 5702 | 5701 | {"type": "Polygon", "coordinates": [[[-118.21106, 34.03932], [-118.21067, 34.03991], [-118.21062, 34.03994], [-118.21057, 34.03993], [-118.20993, 34.03964], [-118.21034, 34.03899], [-118.21106, 34.03932]]]} | Restricted Access 2 | 45762 | Roosevelt High School Pool | 28767 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/dos/aquatic/facility/rooseveltPool.htm | Los Angeles 6 | 1.493 | Roosevelt High School Pool | 0 | Local Recreation Area 3 | 4 |
5708 | 5708 | 5707 | {"type": "Polygon", "coordinates": [[[-118.4631, 34.04049], [-118.4631, 34.04049], [-118.46238, 34.04081], [-118.46291, 34.04033], [-118.4631, 34.04049]]]} | Restricted Access 2 | 45779 | Bundy Triangle | 28785 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.22 | Bundy Triangle | 0 | Local Other or Unknown 14 | 4 | |
5710 | 5710 | 5709 | {"type": "Polygon", "coordinates": [[[-118.2722, 34.12839], [-118.27164, 34.12791], [-118.2691, 34.12331], [-118.26956, 34.12305], [-118.26994, 34.12261], [-118.27156, 34.12603], [-118.2722, 34.12839]]]} | Restricted Access 2 | 45780 | Los Feliz Golf Course | 28786 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://golf.lacity.org/cdp_los_feliz.htm | Los Angeles 6 | 11.795 | Los Feliz GC | 0 | Local Recreation Area 3 | 4 |
9130 | 9130 | 9129 | {"type": "Polygon", "coordinates": [[[-118.1982, 34.0513], [-118.19807, 34.0515], [-118.19808, 34.05158], [-118.19791, 34.05157], [-118.19774, 34.05153], [-118.19725, 34.05132], [-118.19747, 34.05098], [-118.1982, 34.0513]]]} | Restricted Access 2 | 15135 | Wabash Recreation Center | 28866 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.784 | Wabash Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
12284 | 12284 | 12283 | {"type": "Polygon", "coordinates": [[[-118.53366, 34.03505], [-118.5333, 34.0359], [-118.53307, 34.0362], [-118.53297, 34.03611], [-118.5328, 34.0361], [-118.53282, 34.036], [-118.53279, 34.03592], [-118.53275, 34.03587], [-118.53261, 34.03578], [-118.53232, 34.03565], [-118.53202, 34.03557], [-118.53186, 34.03554], [-118.53161, 34.03554], [-118.53137, 34.03557], [-118.53079, 34.03574], [-118.53049, 34.03581], [-118.53031, 34.03583], [-118.52994, 34.03584], [-118.52955, 34.0358], [-118.52938, 34.03577], [-118.52913, 34.0357], [-118.52881, 34.03558], [-118.52863, 34.03548], [-118.52845, 34.03537], [-118.52837, 34.03533], [-118.52812, 34.03498], [-118.52804, 34.03454], [-118.52803, 34.03408], [-118.52811, 34.03394], [-118.52793, 34.03354], [-118.52755, 34.03327], [-118.52702, 34.03309], [-118.52664, 34.03355], [-118.52628, 34.03352], [-118.52621, 34.03414], [-118.52671, 34.03416], [-118.52669, 34.03442], [-118.52672, 34.03507], [-118.5268, 34.03551], [-118.52684, 34.03567], [-118.52638, 34.03577], [-118.52637, 34.0358], [-118.52644, 34.03597], [-118.52653, 34.03613], [-118.52676, 34.03645], [-118.5267, 34.03653], [-118.52656, 34.0365], [-118.52642, 34.03631], [-118.52627, 34.03618], [-118.52608, 34.03607], [-118.52593, 34.036], [-118.52578, 34.03596], [-118.52557, 34.03594], [-118.52538, 34.03594], [-118.52528, 34.03596], [-118.52539, 34.03581], [-118.52527, 34.03562], [-118.52498, 34.03597], [-118.52501, 34.03602], [-118.52476, 34.03616], [-118.52463, 34.03626], [-118.52454, 34.03636], [-118.52441, 34.03656], [-118.52436, 34.03671], [-118.52434, 34.03683], [-118.52434, 34.03702], [-118.52438, 34.03721], [-118.52449, 34.03748], [-118.52596, 34.03959], [-118.52609, 34.03975], [-118.52628, 34.03994], [-118.52668, 34.04025], [-118.527, 34.04042], [-118.52706, 34.04049], [-118.52704, 34.04085], [-118.52694, 34.04149], [-118.52664, 34.04146], [-118.5264, 34.0416], [-118.52632, 34.04182], [-118.52584, 34.04176], [-118.52603, 34.04073], [-118.52589, 34.04059], [-118.52501, 34.04047], [-118.52447, 34.03997], [-118.52465, 34.03924], [-118.52323, 34.03721], [-118.52313, 34.03653], [-118.52336, 34.0359], [-118.52367, 34.03554], [-118.52419, 34.03514], [-118.52423, 34.03517], [-118.52427, 34.03515], [-118.52484, 34.03422], [-118.52484, 34.03421], [-118.52478, 34.03419], [-118.52574, 34.03263], [-118.5256, 34.03206], [-118.52621, 34.03192], [-118.52648, 34.03206], [-118.52849, 34.03324], [-118.52951, 34.03374], [-118.52992, 34.03392], [-118.53077, 34.03423], [-118.53142, 34.03444], [-118.53366, 34.03505]]]} | Restricted Access 2 | 25935 | Potrero Canyon Park | 28872 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 59.924 | Potrero Canyon Park | 0 | Local Park 2 | 4 | |
12843 | 12843 | 12842 | {"type": "Polygon", "coordinates": [[[-118.41888, 34.04508], [-118.41071, 34.04979], [-118.41066, 34.0498], [-118.41063, 34.04978], [-118.40947, 34.04839], [-118.41012, 34.04771], [-118.41049, 34.04727], [-118.41122, 34.04639], [-118.41134, 34.0462], [-118.4122, 34.04566], [-118.41232, 34.04556], [-118.4123, 34.04532], [-118.41195, 34.04482], [-118.4113, 34.04507], [-118.41049, 34.04518], [-118.41007, 34.0452], [-118.40951, 34.04518], [-118.40863, 34.04405], [-118.40826, 34.04398], [-118.40772, 34.04398], [-118.40754, 34.04391], [-118.40691, 34.04308], [-118.41032, 34.04122], [-118.41044, 34.04125], [-118.41408, 34.03927], [-118.41888, 34.04508]]]} | Restricted Access 2 | 44526 | Rancho Park Municipal Golf Course | 33107 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 148.459 | Rancho Park Municipal GC | 0 | Local Recreation Area 3 | 4 | |
14195 | 14195 | 14194 | {"type": "Polygon", "coordinates": [[[-118.54281, 34.25984], [-118.54023, 34.25984], [-118.5403, 34.2596], [-118.5404, 34.25932], [-118.54124, 34.2574], [-118.54174, 34.25744], [-118.54281, 34.25743], [-118.54281, 34.25984]]]} | Restricted Access 2 | 46859 | Northridge City Little League | 30336 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 12.794 | Northridge City Little League | None 1208 | |||
15051 | 15051 | 15050 | {"type": "Polygon", "coordinates": [[[-118.4995, 34.30582], [-118.49819, 34.30855], [-118.49804, 34.30878], [-118.49759, 34.30968], [-118.49608, 34.30917], [-118.49773, 34.30545], [-118.49787, 34.30539], [-118.49814, 34.30541], [-118.49852, 34.30548], [-118.4995, 34.30582]]]} | Restricted Access 2 | 45713 | Granada Hills Youth Recreation Center | 28880 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 18.213 | Granada Hills Youth Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
15065 | 15065 | 15064 | {"type": "Polygon", "coordinates": [[[-118.46931, 34.16258], [-118.46866, 34.16231], [-118.46826, 34.16216], [-118.46633, 34.16157], [-118.46632, 34.16106], [-118.46918, 34.16165], [-118.46924, 34.16182], [-118.46929, 34.16204], [-118.46931, 34.16258]]]} | Restricted Access 2 | 45827 | Sherman Oaks Castle Park | 28846 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/shermanoaks_castlepk/ | Los Angeles 6 | 4.982 | Sherman Oaks Castle Park | 0 | Local Park 2 | 4 |
15687 | 15687 | 15686 | {"type": "Polygon", "coordinates": [[[-118.41363, 33.95967], [-118.40927, 33.95968], [-118.40927, 33.95722], [-118.40942, 33.95725], [-118.40951, 33.95722], [-118.40956, 33.95713], [-118.40956, 33.95708], [-118.40953, 33.95704], [-118.40948, 33.957], [-118.40942, 33.95699], [-118.40928, 33.95702], [-118.4057, 33.95703], [-118.40454, 33.95711], [-118.40449, 33.95706], [-118.4045, 33.95483], [-118.40456, 33.95479], [-118.41077, 33.95416], [-118.41233, 33.95399], [-118.41264, 33.95412], [-118.41314, 33.95437], [-118.41362, 33.95468], [-118.41363, 33.95967]]]} | Restricted Access 2 | 15279 | Westchester Golf Course | 33047 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | Los Angeles 6 | 90.203 | Westchester GC | 0 | Local Recreation Area 3 | 4 |
15701 | 15701 | 15700 | {"type": "Polygon", "coordinates": [[[-118.4901, 34.19376], [-118.49007, 34.19379], [-118.48693, 34.19379], [-118.48692, 34.19036], [-118.48707, 34.19038], [-118.48713, 34.19038], [-118.4872, 34.19034], [-118.48722, 34.19027], [-118.48719, 34.19021], [-118.48713, 34.19017], [-118.48706, 34.19016], [-118.48692, 34.19019], [-118.48692, 34.18927], [-118.48706, 34.1893], [-118.48713, 34.18929], [-118.48719, 34.18925], [-118.48722, 34.18919], [-118.48719, 34.18912], [-118.48712, 34.18908], [-118.48683, 34.1891], [-118.48683, 34.18847], [-118.48697, 34.18851], [-118.48703, 34.18851], [-118.4871, 34.18846], [-118.48713, 34.18839], [-118.48709, 34.18832], [-118.48703, 34.18829], [-118.48696, 34.18829], [-118.48683, 34.18832], [-118.48683, 34.18769], [-118.48697, 34.18773], [-118.48704, 34.18772], [-118.4871, 34.18768], [-118.48713, 34.18761], [-118.4871, 34.18755], [-118.48702, 34.18751], [-118.48697, 34.18751], [-118.48683, 34.18754], [-118.48683, 34.18723], [-118.48687, 34.18724], [-118.4869, 34.18728], [-118.48696, 34.18728], [-118.48696, 34.18713], [-118.4869, 34.18712], [-118.48685, 34.18717], [-118.48675, 34.18717], [-118.48675, 34.18678], [-118.49004, 34.18677], [-118.49009, 34.1868], [-118.4901, 34.19376]]]} | Restricted Access 2 | 22010 | Van Nuys Golf Course | 33076 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | Los Angeles 6 | 56.262 | Van Nuys GC | 0 | Local Recreation Area 3 | 4 |
17042 | 17042 | 17041 | {"type": "Polygon", "coordinates": [[[-118.37326, 34.27372], [-118.36895, 34.2735], [-118.36894, 34.27339], [-118.36827, 34.27335], [-118.3682, 34.27332], [-118.3682, 34.27247], [-118.36822, 34.27225], [-118.36828, 34.2722], [-118.36834, 34.27218], [-118.36839, 34.27207], [-118.36845, 34.27199], [-118.36856, 34.2719], [-118.36875, 34.27177], [-118.36887, 34.27172], [-118.36924, 34.27164], [-118.36933, 34.27158], [-118.36934, 34.27154], [-118.36933, 34.27138], [-118.36919, 34.27127], [-118.3688, 34.27111], [-118.36873, 34.27105], [-118.36865, 34.27091], [-118.36862, 34.27081], [-118.36862, 34.27071], [-118.36868, 34.27055], [-118.36874, 34.27046], [-118.36878, 34.27038], [-118.36881, 34.2701], [-118.36881, 34.26999], [-118.36876, 34.26986], [-118.36871, 34.26981], [-118.36861, 34.26974], [-118.36851, 34.26964], [-118.36848, 34.26958], [-118.36848, 34.26953], [-118.36828, 34.26945], [-118.36821, 34.26921], [-118.36819, 34.269], [-118.3725, 34.26887], [-118.3728, 34.26881], [-118.37297, 34.26886], [-118.37307, 34.26895], [-118.37311, 34.26911], [-118.3728, 34.27074], [-118.37326, 34.27372]]]} | Restricted Access 2 | 47236 | Hansen Dam Equestrian Center | 30949 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://hansendamhorsecenter.com/ | Los Angeles 6 | 52.323 | Hansen Dam Equestrian Ctr. | 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]);