units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
116 rows where DES_TP = 3 and MNG_AGENCY = 24 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL
ACCESS_TYP 3
- Open Access 105
- Restricted Access 10
- No Public Access 1
MNG_AG_TYP 1
- City Agency 116
MNG_AGENCY 1
- Los Angeles, City of · 116 ✖
DES_TP 1
- Local Recreation Area · 116 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5843 | 5843 | 5842 | {"type": "Polygon", "coordinates": [[[-118.18237, 34.07792], [-118.18013, 34.07793], [-118.18013, 34.07751], [-118.18011, 34.0774], [-118.18007, 34.07733], [-118.18, 34.07725], [-118.17993, 34.07718], [-118.1795, 34.07695], [-118.17947, 34.07691], [-118.18026, 34.07568], [-118.18235, 34.07567], [-118.18237, 34.07792]]]} | Open Access 1 | 169 | El Sereno Recreation Center | 18543 | 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 | 13.93 | El Sereno Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
5871 | 5871 | 5870 | {"type": "Polygon", "coordinates": [[[-118.24545, 34.09931], [-118.24468, 34.0998], [-118.24403, 34.09922], [-118.24481, 34.09872], [-118.24487, 34.09872], [-118.24545, 34.09931]]]} | Open Access 1 | 245 | Elysian Valley Recreation Center | 18609 | 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 | 2.004 | Elysian Valley Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
5927 | 5927 | 5926 | {"type": "Polygon", "coordinates": [[[-118.2058, 34.03807], [-118.20518, 34.03902], [-118.20469, 34.03879], [-118.2044, 34.03922], [-118.20354, 34.03884], [-118.20443, 34.03747], [-118.20518, 34.0378], [-118.20518, 34.03783], [-118.20534, 34.0379], [-118.20536, 34.03788], [-118.2058, 34.03807]]]} | Open Access 1 | 411 | Evergreen Recreation Center | 18767 | 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 | 5.393 | Evergreen Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
3572 | 3572 | 3571 | {"type": "Polygon", "coordinates": [[[-118.4037, 34.2292], [-118.40363, 34.22925], [-118.40364, 34.22929], [-118.40362, 34.22931], [-118.40221, 34.23034], [-118.40077, 34.22897], [-118.40228, 34.22787], [-118.4037, 34.2292]]]} | Open Access 1 | 519 | Fernangeles Recreation Center | 18880 | 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 | 9.262 | Fernangeles Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
294 | 294 | 293 | {"type": "Polygon", "coordinates": [[[-118.36564, 34.02332], [-118.36557, 34.02447], [-118.36551, 34.02475], [-118.36542, 34.02503], [-118.36317, 34.02482], [-118.36308, 34.02548], [-118.3629, 34.02546], [-118.36318, 34.02338], [-118.36465, 34.02338], [-118.36466, 34.02331], [-118.36564, 34.02332]]]} | Open Access 1 | 788 | Baldwin Hills Recreation Center | 15776 | 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 | 10.253 | Baldwin Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
2907 | 2907 | 2906 | {"type": "Polygon", "coordinates": [[[-118.2343, 34.11538], [-118.23311, 34.11682], [-118.23255, 34.1176], [-118.23164, 34.11715], [-118.23068, 34.11666], [-118.2302, 34.11658], [-118.23129, 34.11609], [-118.2325, 34.11535], [-118.23326, 34.1146], [-118.23381, 34.11501], [-118.23351, 34.11525], [-118.23351, 34.11526], [-118.23352, 34.11527], [-118.23383, 34.11503], [-118.2343, 34.11538]]]} | Open Access 1 | 1011 | Glassell Park and Recreation Center | 19309 | 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/reccenter/facility/glassellParkRC.htm | Los Angeles 6 | 12.663 | Glassell Park and Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
16795 | 16795 | 16794 | {"type": "MultiPolygon", "coordinates": [[[[-118.35638, 34.26783], [-118.35593, 34.26829], [-118.35584, 34.26829], [-118.35537, 34.2677], [-118.35638, 34.26783]]], [[[-118.40076, 34.26685], [-118.3982, 34.26992], [-118.39688, 34.27114], [-118.39396, 34.27326], [-118.39345, 34.27322], [-118.39305, 34.27306], [-118.39242, 34.27288], [-118.39167, 34.27275], [-118.39148, 34.27273], [-118.3913, 34.27261], [-118.39115, 34.27271], [-118.39048, 34.27273], [-118.3895, 34.27285], [-118.38271, 34.27375], [-118.38204, 34.27395], [-118.38165, 34.27413], [-118.38166, 34.27415], [-118.38199, 34.27411], [-118.38149, 34.27448], [-118.37505, 34.27381], [-118.37326, 34.27372], [-118.3728, 34.27074], [-118.37311, 34.26911], [-118.37307, 34.26894], [-118.37297, 34.26886], [-118.3728, 34.26881], [-118.3725, 34.26887], [-118.36836, 34.26898], [-118.36556, 34.26923], [-118.36779, 34.27246], [-118.3682, 34.27267], [-118.3682, 34.27331], [-118.36827, 34.27335], [-118.36339, 34.27298], [-118.36215, 34.27292], [-118.36205, 34.27265], [-118.36168, 34.27244], [-118.36149, 34.27222], [-118.36028, 34.27139], [-118.35844, 34.27155], [-118.35617, 34.26871], [-118.35695, 34.26791], [-118.35827, 34.26807], [-118.35863, 34.26622], [-118.36449, 34.26628], [-118.36534, 34.26618], [-118.36553, 34.26608], [-118.36603, 34.26587], [-118.36643, 34.26563], [-118.36663, 34.26571], [-118.36732, 34.26584], [-118.36782, 34.26584], [-118.36997, 34.26526], [-118.36978, 34.2624], [-118.37166, 34.25994], [-118.37265, 34.25872], [-118.37328, 34.25818], [-118.3738, 34.25783], [-118.37343, 34.25859], [-118.37343, 34.25862], [-118.37506, 34.25861], [-118.37614, 34.2584], [-118.37725, 34.25823], [-118.37816, 34.25822], [-118.37936, 34.25812], [-118.38042, 34.25817], [-118.38262, 34.25846], [-118.38325, 34.25843], [-118.38394, 34.2583], [-118.38448, 34.25843], [-118.38587, 34.25895], [-118.3865, 34.2579], [-118.38713, 34.25817], [-118.38665, 34.259], [-118.3866, 34.26034], [-118.38666, 34.26042], [-118.38925, 34.26121], [-118.3894, 34.26086], [-118.39031, 34.26113], [-118.39073, 34.26043], [-118.39103, 34.26066], [-118.39148, 34.26078], [-118.39335, 34.2618], [-118.39344, 34.2618], [-118.3935, 34.26157], [-118.3954, 34.26242], [-118.39631, 34.26249], [-118.39746, 34.26329], [-118.39782, 34.26398], [-118.39843, 34.26433], [-118.39897, 34.26483], [-118.39946, 34.26558], [-118.39988, 34.26605], [-118.40076, 34.26685]]], [[[-118.39867, 34.27251], [-118.39763, 34.27327], [-118.39688, 34.27256], [-118.3959, 34.27251], [-118.39568, 34.27231], [-118.39725, 34.27116], [-118.39867, 34.27251]]], [[[-118.40091, 34.26912], [-118.40073, 34.26966], [-118.40042, 34.27118], [-118.40039, 34.27126], [-118.39882, 34.2724], [-118.39739, 34.27105], [-118.3978, 34.2707], [-118.39826, 34.27023], [-118.39995, 34.26822], [-118.40091, 34.26912]]], [[[-118.4014, 34.26764], [-118.40094, 34.26903], [-118.40001, 34.26815], [-118.40119, 34.26673], [-118.4014, 34.26764]]]]} | Open Access 1 | 1374 | Hansen Dam Recreation Area | 30957 | 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/reccenter/facility/hansendamRC.htm | Los Angeles 6 | 1140.78 | Hansen Dam Rec. Area | 0 | Local Recreation Area 3 | 4 |
4082 | 4082 | 4081 | {"type": "Polygon", "coordinates": [[[-118.30667, 33.98334], [-118.30667, 33.98455], [-118.30249, 33.98455], [-118.30251, 33.98333], [-118.30667, 33.98334]]]} | Open Access 1 | 1485 | Jackie Tatum/Harvard Recreation Center | 28621 | 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/reccenter/facility/jackieTatumRC.htm | Los Angeles 6 | 12.849 | Jackie Tatum/Harvard Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
6394 | 6394 | 6393 | {"type": "Polygon", "coordinates": [[[-118.18925, 34.11305], [-118.18679, 34.11383], [-118.18662, 34.11346], [-118.18815, 34.11212], [-118.18864, 34.1122], [-118.18925, 34.11305]]]} | Open Access 1 | 1811 | Highland Park Recreation Center | 19937 | 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 | 5.416 | Highland Park Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
3181 | 3181 | 3180 | {"type": "Polygon", "coordinates": [[[-118.32975, 34.09132], [-118.32975, 34.09151], [-118.32899, 34.09152], [-118.32899, 34.09084], [-118.32975, 34.09084], [-118.32975, 34.09132]]]} | Open Access 1 | 1902 | Hollywood Recreation Center | 20054 | 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 | 1.295 | Hollywood Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
3902 | 3902 | 3901 | {"type": "MultiPolygon", "coordinates": [[[[-118.28275, 34.03276], [-118.28253, 34.0331], [-118.28239, 34.03304], [-118.28261, 34.03269], [-118.28275, 34.03276]]], [[[-118.28381, 34.033], [-118.28378, 34.03302], [-118.2827, 34.03255], [-118.28329, 34.0316], [-118.28337, 34.03159], [-118.28376, 34.03176], [-118.2838, 34.03182], [-118.28381, 34.033]]], [[[-118.2838, 34.03365], [-118.28341, 34.03348], [-118.28363, 34.03314], [-118.28377, 34.0332], [-118.2838, 34.03324], [-118.2838, 34.03365]]]]} | Open Access 1 | 1924 | Hoover Recreation Center | 20083 | 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 | 2.988 | Hoover Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
15592 | 15592 | 15591 | {"type": "Polygon", "coordinates": [[[-118.3716, 34.27463], [-118.37157, 34.27826], [-118.371, 34.27826], [-118.371, 34.27743], [-118.37049, 34.27743], [-118.3705, 34.27574], [-118.37032, 34.27573], [-118.37032, 34.27523], [-118.37007, 34.27517], [-118.37007, 34.27462], [-118.3716, 34.27463]]]} | Open Access 1 | 3527 | Lakeview Terrace Recreation Center | 20985 | 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 | 9.825 | Lakeview Terrace Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
15672 | 15672 | 15671 | {"type": "Polygon", "coordinates": [[[-118.60581, 34.21744], [-118.60579, 34.21747], [-118.60575, 34.21749], [-118.60178, 34.21749], [-118.60174, 34.21744], [-118.60174, 34.21566], [-118.60179, 34.21562], [-118.60577, 34.21562], [-118.60581, 34.21566], [-118.60581, 34.21744]]]} | Open Access 1 | 3551 | Lanark Recreation Center | 28623 | 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/reccenter/facility/lanarkRC.htm | Los Angeles 6 | 19.128 | Lanark Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
15731 | 15731 | 15730 | {"type": "Polygon", "coordinates": [[[-118.30502, 34.08785], [-118.30481, 34.08785], [-118.30454, 34.08756], [-118.30454, 34.08743], [-118.30421, 34.0871], [-118.30393, 34.08695], [-118.30365, 34.0867], [-118.30352, 34.08657], [-118.30334, 34.08644], [-118.30334, 34.08634], [-118.30501, 34.08633], [-118.30502, 34.08785]]]} | Open Access 1 | 3924 | Lemon Grove Recreation Center | 21152 | 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 | 3.523 | Lemon Grove Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
6592 | 6592 | 6591 | {"type": "Polygon", "coordinates": [[[-118.28341, 34.08393], [-118.283, 34.08459], [-118.28255, 34.08441], [-118.28134, 34.08636], [-118.28032, 34.08591], [-118.28183, 34.08349], [-118.28339, 34.0839], [-118.28341, 34.08393]]]} | Open Access 1 | 3982 | Bellevue Recreation Center | 28615 | 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 | 9.129 | Bellevue Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
5062 | 5062 | 5061 | {"type": "Polygon", "coordinates": [[[-118.21546, 34.07238], [-118.21496, 34.07239], [-118.21496, 34.07274], [-118.21444, 34.07275], [-118.21443, 34.07196], [-118.21545, 34.07195], [-118.21546, 34.07238]]]} | Open Access 1 | 4187 | Lincoln Heights Recreation Center | 21250 | 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 | 1.593 | Lincoln Heights Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
6674 | 6674 | 6673 | {"type": "Polygon", "coordinates": [[[-118.64797, 34.19522], [-118.64792, 34.19556], [-118.64772, 34.19554], [-118.64752, 34.19555], [-118.64721, 34.19561], [-118.64698, 34.19569], [-118.6464, 34.19595], [-118.64635, 34.19593], [-118.64625, 34.19573], [-118.64624, 34.19563], [-118.64627, 34.19542], [-118.64631, 34.19537], [-118.6464, 34.1953], [-118.64642, 34.19522], [-118.6464, 34.19518], [-118.64636, 34.19513], [-118.64629, 34.19511], [-118.64623, 34.19511], [-118.64624, 34.19507], [-118.64797, 34.19522]]]} | Open Access 1 | 4956 | Mae Boyar Recreation Center | 21665 | 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 | 2.247 | Mae Boyar Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
6755 | 6755 | 6754 | {"type": "Polygon", "coordinates": [[[-118.43113, 34.01704], [-118.42626, 34.01947], [-118.42529, 34.01837], [-118.43024, 34.016], [-118.43078, 34.01658], [-118.43113, 34.01704]]]} | Open Access 1 | 5100 | Mar Vista Recreation Center | 21787 | 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 | 19.06 | Mar Vista Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
6937 | 6937 | 6936 | {"type": "Polygon", "coordinates": [[[-118.30014, 34.04536], [-118.29922, 34.04533], [-118.29922, 34.04401], [-118.30011, 34.04389], [-118.30014, 34.04391], [-118.30014, 34.04536]]]} | Open Access 1 | 5833 | Normandie Playground | 22801 | 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 | 3.267 | Normandie Playground | 0 | Local Recreation Area 3 | 4 | |
17009 | 17009 | 17008 | {"type": "MultiPolygon", "coordinates": [[[[-118.30098, 33.74904], [-118.30071, 33.74905], [-118.30006, 33.74885], [-118.29989, 33.74895], [-118.29989, 33.74917], [-118.29941, 33.74917], [-118.29941, 33.74883], [-118.29967, 33.74884], [-118.29968, 33.74851], [-118.30055, 33.74851], [-118.30055, 33.74884], [-118.30098, 33.74884], [-118.30098, 33.74904]]], [[[-118.30941, 33.74716], [-118.30905, 33.74992], [-118.30655, 33.74991], [-118.30653, 33.75195], [-118.29918, 33.75195], [-118.29869, 33.75043], [-118.29877, 33.75042], [-118.29876, 33.75009], [-118.299, 33.7501], [-118.299, 33.74996], [-118.2994, 33.74996], [-118.2994, 33.7493], [-118.29992, 33.74931], [-118.30002, 33.74933], [-118.30002, 33.7503], [-118.30005, 33.75031], [-118.30005, 33.75064], [-118.30097, 33.75064], [-118.30097, 33.75155], [-118.30152, 33.75155], [-118.30153, 33.75144], [-118.30208, 33.75144], [-118.30209, 33.75111], [-118.30232, 33.75111], [-118.30232, 33.75064], [-118.30245, 33.75063], [-118.30245, 33.75032], [-118.30281, 33.75031], [-118.30281, 33.75018], [-118.30265, 33.75018], [-118.30266, 33.74988], [-118.30273, 33.74988], [-118.30283, 33.74985], [-118.30296, 33.74976], [-118.30301, 33.74971], [-118.30304, 33.74963], [-118.30303, 33.74947], [-118.30306, 33.74944], [-118.30358, 33.74944], [-118.30358, 33.74897], [-118.30385, 33.74897], [-118.30385, 33.74863], [-118.30391, 33.74862], [-118.304, 33.74858], [-118.30425, 33.74837], [-118.3043, 33.74831], [-118.30473, 33.74832], [-118.30474, 33.74818], [-118.30655, 33.74818], [-118.30656, 33.74709], [-118.30658, 33.74706], [-118.30661, 33.74705], [-118.30864, 33.74706], [-118.30903, 33.74708], [-118.30937, 33.74713], [-118.30941, 33.74716]]]]} | Open Access 1 | 5885 | Peck Park and Community Center | 23556 | 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 | 66.635 | Peck Park and Community 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]);