units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
491 rows where MNG_AGENCY = 24 sorted by DES_TP
This data as json, copyable, CSV (advanced)
DES_TP >30
- Local Park 294
- Local Recreation Area 116
- Local Other or Unknown 26
- Local Conservation Area 4
- National Forest 1
- Local Historic or Cultural Area 1
- None 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 412
- No Public Access 36
- Restricted Access 20
- Unknown Access 3
AGNCY_LEV 3 ✖
- City 465
- Special District 5
- State 1
MNG_AG_TYP 1
- City Agency 471
MNG_AGENCY 1
- Los Angeles, City of · 471 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
737 | 737 | 736 | {"type": "Polygon", "coordinates": [[[-118.50977, 34.20099], [-118.50767, 34.20099], [-118.50767, 34.19973], [-118.50918, 34.19972], [-118.5092, 34.19979], [-118.50938, 34.19979], [-118.50938, 34.19974], [-118.50977, 34.19974], [-118.50977, 34.20099]]]} | Open Access 1 | 4829 | Louise Park | 21550 | 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 | 6.663 | Louise Park | 0 | Local Park 2 | 4 | |
752 | 752 | 751 | {"type": "Polygon", "coordinates": [[[-118.28031, 34.05822], [-118.27848, 34.06102], [-118.27504, 34.05949], [-118.27684, 34.05666], [-118.28031, 34.05822]]]} | Open Access 1 | 4928 | MacArthur Park | 21623 | 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 | 31.717 | MacArthur Park | 0 | Local Park 2 | 4 | |
791 | 791 | 790 | {"type": "Polygon", "coordinates": [[[-118.30835, 34.01371], [-118.30834, 34.014], [-118.30815, 34.014], [-118.30813, 34.0142], [-118.30731, 34.0142], [-118.30731, 34.01294], [-118.30773, 34.01293], [-118.30779, 34.01291], [-118.30789, 34.01283], [-118.3079, 34.01358], [-118.30812, 34.01359], [-118.30813, 34.01373], [-118.30835, 34.01371]]]} | Open Access 1 | 5154 | Martin Luther King Jr Park | 21907 | 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.407 | Martin Luther King Jr Park | 0 | Local Park 2 | 4 | |
792 | 792 | 791 | {"type": "Polygon", "coordinates": [[[-118.57969, 34.26206], [-118.57967, 34.2621], [-118.57963, 34.26211], [-118.57724, 34.26212], [-118.57721, 34.2621], [-118.5772, 34.26208], [-118.5772, 34.25943], [-118.57721, 34.25941], [-118.57725, 34.25939], [-118.57962, 34.25939], [-118.57967, 34.25942], [-118.57969, 34.26206]]]} | Open Access 1 | 5161 | Mason Park | 21943 | 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 | 17.038 | Mason Park | 0 | Local Park 2 | 4 | |
856 | 856 | 855 | {"type": "Polygon", "coordinates": [[[-118.28914, 33.97559], [-118.28914, 33.97628], [-118.2872, 33.97629], [-118.2872, 33.9756], [-118.28914, 33.97559]]]} | Open Access 1 | 5525 | Mount Carmel Park | 22522 | 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.405 | Mount Carmel Park | 0 | Local Park 2 | 4 | |
888 | 888 | 887 | {"type": "MultiPolygon", "coordinates": [[[[-118.44145, 33.9444], [-118.44145, 33.94447], [-118.44138, 33.94465], [-118.44136, 33.94467], [-118.4413, 33.94467], [-118.44127, 33.94464], [-118.4412, 33.94453], [-118.44114, 33.94437], [-118.44113, 33.94429], [-118.44116, 33.94426], [-118.44122, 33.94426], [-118.44141, 33.94434], [-118.44145, 33.9444]]], [[[-118.44163, 33.94405], [-118.44154, 33.94426], [-118.4415, 33.94429], [-118.44146, 33.9443], [-118.44122, 33.9442], [-118.4412, 33.94418], [-118.4412, 33.94415], [-118.44122, 33.94412], [-118.44155, 33.94399], [-118.4416, 33.944], [-118.44163, 33.94405]]], [[[-118.4419, 33.94457], [-118.44153, 33.94471], [-118.44148, 33.94472], [-118.44145, 33.94469], [-118.44145, 33.94465], [-118.44152, 33.94446], [-118.44156, 33.94443], [-118.44163, 33.94443], [-118.44188, 33.9445], [-118.4419, 33.94452], [-118.4419, 33.94457]]], [[[-118.44196, 33.94442], [-118.44193, 33.94445], [-118.44189, 33.94445], [-118.44166, 33.94438], [-118.44161, 33.94434], [-118.4416, 33.94425], [-118.44168, 33.94407], [-118.44171, 33.94405], [-118.44174, 33.94405], [-118.44178, 33.94406], [-118.44196, 33.94438], [-118.44196, 33.94442]]]]} | Open Access 1 | 6312 | Vista Del Mar Park | 27170 | 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.852 | Vista Del Mar Park | 0 | Local Park 2 | 4 | |
890 | 890 | 889 | {"type": "Polygon", "coordinates": [[[-118.44628, 33.96116], [-118.44598, 33.9614], [-118.44575, 33.9612], [-118.44605, 33.96097], [-118.44628, 33.96116]]]} | Open Access 1 | 6317 | Titmouse Park | 26375 | 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.286 | Titmouse Park | 0 | Local Park 2 | 4 | |
900 | 900 | 899 | {"type": "Polygon", "coordinates": [[[-118.5393, 34.04023], [-118.5392, 34.04026], [-118.53912, 34.04018], [-118.53906, 34.04014], [-118.53896, 34.04012], [-118.53789, 34.04018], [-118.53702, 34.04019], [-118.53585, 34.04014], [-118.53571, 34.04012], [-118.53547, 34.04004], [-118.53525, 34.03993], [-118.53514, 34.03985], [-118.53513, 34.03978], [-118.53515, 34.03976], [-118.53508, 34.03965], [-118.53502, 34.0396], [-118.53492, 34.03957], [-118.53483, 34.0396], [-118.53481, 34.03959], [-118.53495, 34.03938], [-118.53524, 34.0395], [-118.53576, 34.03995], [-118.53608, 34.03994], [-118.53637, 34.04007], [-118.53655, 34.04011], [-118.53679, 34.04004], [-118.53703, 34.04009], [-118.53712, 34.04016], [-118.53771, 34.04016], [-118.53778, 34.04008], [-118.53788, 34.04008], [-118.53794, 34.04014], [-118.53893, 34.04004], [-118.53911, 34.04009], [-118.5393, 34.04023]]]} | Open Access 1 | 6342 | Palisades-Asilomar Park | 28614 | 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.433 | Palisades-Asilomar Park | 0 | Local Park 2 | 4 | |
920 | 920 | 919 | {"type": "MultiPolygon", "coordinates": [[[[-118.2933, 33.74611], [-118.2933, 33.74675], [-118.29307, 33.74676], [-118.29293, 33.74681], [-118.2928, 33.7468], [-118.29271, 33.74686], [-118.2927, 33.74694], [-118.29256, 33.74666], [-118.29279, 33.74665], [-118.2928, 33.74611], [-118.2933, 33.74611]]], [[[-118.29437, 33.7462], [-118.29434, 33.74633], [-118.29429, 33.74644], [-118.29347, 33.74646], [-118.29348, 33.74611], [-118.29437, 33.74611], [-118.29437, 33.7462]]], [[[-118.29658, 33.74641], [-118.295, 33.7464], [-118.29449, 33.7464], [-118.29457, 33.7462], [-118.29459, 33.74618], [-118.29598, 33.74618], [-118.29656, 33.74619], [-118.29658, 33.7462], [-118.29658, 33.74641]]], [[[-118.29717, 33.74641], [-118.29681, 33.74641], [-118.29682, 33.7462], [-118.29717, 33.74619], [-118.29717, 33.74641]]], [[[-118.29879, 33.74622], [-118.29878, 33.74641], [-118.29722, 33.74641], [-118.29723, 33.74619], [-118.29878, 33.7462], [-118.29879, 33.74622]]]]} | Open Access 1 | 5882 | Bandini Canyon Park | 15794 | 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.959 | Bandini Canyon Park | 0 | Local Park 2 | 4 | |
924 | 924 | 923 | {"type": "MultiPolygon", "coordinates": [[[[-118.29797, 33.72561], [-118.29725, 33.72561], [-118.29724, 33.72563], [-118.29692, 33.72564], [-118.29692, 33.72527], [-118.29797, 33.72527], [-118.29797, 33.72561]]], [[[-118.29824, 33.7247], [-118.29784, 33.7247], [-118.29784, 33.7251], [-118.29692, 33.7251], [-118.29692, 33.72485], [-118.29731, 33.72485], [-118.29731, 33.72476], [-118.29758, 33.72475], [-118.29758, 33.72436], [-118.29823, 33.72436], [-118.29824, 33.7247]]]]} | Open Access 1 | 5892 | Alma Park | 15387 | 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.257 | Alma Park | 0 | Local Park 2 | 4 | |
925 | 925 | 924 | {"type": "Polygon", "coordinates": [[[-118.31177, 33.73167], [-118.31176, 33.73332], [-118.31098, 33.73332], [-118.31072, 33.73336], [-118.31042, 33.73346], [-118.30969, 33.73379], [-118.30966, 33.73379], [-118.3096, 33.73376], [-118.30925, 33.7332], [-118.30917, 33.7331], [-118.30891, 33.73287], [-118.30979, 33.73216], [-118.3098, 33.73166], [-118.31177, 33.73167]]]} | Open Access 1 | 5893 | Averill Park | 15727 | 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.743 | Averill Park | 0 | Local Park 2 | 4 | |
926 | 926 | 925 | {"type": "Polygon", "coordinates": [[[-118.38249, 34.16339], [-118.38231, 34.1629], [-118.38103, 34.1601], [-118.38166, 34.16015], [-118.38179, 34.1602], [-118.38199, 34.16041], [-118.38213, 34.16054], [-118.38249, 34.16077], [-118.38256, 34.16084], [-118.38263, 34.16094], [-118.38279, 34.16126], [-118.38279, 34.16205], [-118.38278, 34.1622], [-118.38249, 34.16339]]]} | Open Access 1 | 5896 | Valley Village Park | 28628 | 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/parks/facility/valleyVillagePk.htm | Los Angeles 6 | 6.493 | Valley Village Park | 0 | Local Park 2 | 4 |
1027 | 1027 | 1026 | {"type": "Polygon", "coordinates": [[[-118.46676, 33.98488], [-118.4666, 33.98497], [-118.46642, 33.98477], [-118.46658, 33.98467], [-118.46676, 33.98488]]]} | Open Access 1 | 6327 | Canal Park | 16796 | 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.131 | Canal Park | 0 | Local Park 2 | 4 | |
1035 | 1035 | 1034 | {"type": "Polygon", "coordinates": [[[-118.33822, 34.21675], [-118.3366, 34.21733], [-118.33701, 34.21615], [-118.33703, 34.21547], [-118.33731, 34.21544], [-118.33759, 34.21539], [-118.33784, 34.21529], [-118.33822, 34.21675]]]} | Open Access 1 | 6843 | Villa Cabrini Park | 27098 | 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 | 4.683 | Villa Cabrini Park | 0 | Local Park 2 | 4 | |
1036 | 1036 | 1035 | {"type": "Polygon", "coordinates": [[[-118.51713, 34.07188], [-118.51413, 34.07305], [-118.51366, 34.07294], [-118.51362, 34.07289], [-118.5136, 34.07284], [-118.51362, 34.07277], [-118.51362, 34.0727], [-118.51369, 34.07257], [-118.51369, 34.07245], [-118.51365, 34.07237], [-118.51351, 34.07226], [-118.51335, 34.07224], [-118.51307, 34.0723], [-118.51245, 34.07228], [-118.51236, 34.07224], [-118.51228, 34.07218], [-118.51223, 34.07209], [-118.5122, 34.07199], [-118.51208, 34.07188], [-118.51195, 34.07183], [-118.51153, 34.07184], [-118.51141, 34.0718], [-118.51131, 34.07172], [-118.51127, 34.07164], [-118.51126, 34.07141], [-118.51128, 34.07134], [-118.51137, 34.0712], [-118.51137, 34.07112], [-118.51134, 34.07106], [-118.51127, 34.07099], [-118.51069, 34.07068], [-118.51055, 34.07059], [-118.51044, 34.07044], [-118.51037, 34.07025], [-118.51032, 34.07016], [-118.51017, 34.06999], [-118.51091, 34.06955], [-118.51171, 34.06934], [-118.51263, 34.06862], [-118.51341, 34.0685], [-118.51427, 34.06912], [-118.51469, 34.06939], [-118.51498, 34.0695], [-118.51546, 34.06989], [-118.51567, 34.07004], [-118.51603, 34.07034], [-118.51638, 34.07068], [-118.51672, 34.07111], [-118.517, 34.07159], [-118.51713, 34.07188]]]} | Open Access 1 | 6348 | Rustic Canyon Park | 24750 | 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 | 44.671 | Rustic Canyon Park | 0 | Local Park 2 | 4 | |
1037 | 1037 | 1036 | {"type": "Polygon", "coordinates": [[[-118.51161, 34.07364], [-118.50784, 34.07279], [-118.50828, 34.07163], [-118.50773, 34.07138], [-118.50772, 34.07119], [-118.5074, 34.07108], [-118.5074, 34.06996], [-118.5084, 34.06963], [-118.50883, 34.0699], [-118.50951, 34.07038], [-118.51017, 34.07118], [-118.51059, 34.07146], [-118.51105, 34.07274], [-118.51108, 34.07319], [-118.51161, 34.07364]]]} | Open Access 1 | 6349 | Sullivan Canyon Park | 25949 | 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 | 21.85 | Sullivan Canyon Park | 0 | Local Park 2 | 4 | |
1055 | 1055 | 1054 | {"type": "MultiPolygon", "coordinates": [[[[-118.19889, 34.08643], [-118.19879, 34.08644], [-118.19864, 34.08648], [-118.19841, 34.08661], [-118.19733, 34.08687], [-118.19727, 34.0869], [-118.19694, 34.08714], [-118.19681, 34.0872], [-118.19665, 34.08724], [-118.19651, 34.08724], [-118.19633, 34.0872], [-118.19562, 34.08694], [-118.19573, 34.08605], [-118.19623, 34.08609], [-118.19606, 34.08563], [-118.19662, 34.08566], [-118.19679, 34.08529], [-118.19695, 34.08537], [-118.19864, 34.08512], [-118.19872, 34.08551], [-118.19855, 34.08556], [-118.19874, 34.08601], [-118.19888, 34.08598], [-118.19889, 34.08643]]], [[[-118.19558, 34.08623], [-118.19549, 34.08695], [-118.19295, 34.08753], [-118.19293, 34.08601], [-118.19484, 34.08539], [-118.19485, 34.0858], [-118.19493, 34.08579], [-118.19493, 34.08637], [-118.19558, 34.08623]]]]} | Open Access 1 | 6932 | Rose Hill Park | 24610 | 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 | 20.545 | Rose Hill Park | 0 | Local Park 2 | 4 | |
1060 | 1060 | 1059 | {"type": "Polygon", "coordinates": [[[-118.58835, 34.1574], [-118.58606, 34.1574], [-118.58649, 34.15597], [-118.58652, 34.15583], [-118.58671, 34.15424], [-118.58674, 34.15421], [-118.58675, 34.15418], [-118.58671, 34.15411], [-118.58664, 34.15409], [-118.58656, 34.15414], [-118.58655, 34.15418], [-118.58658, 34.15424], [-118.58638, 34.15586], [-118.58592, 34.1574], [-118.58588, 34.15747], [-118.58579, 34.15753], [-118.58572, 34.15755], [-118.58551, 34.15757], [-118.58506, 34.1552], [-118.58531, 34.15463], [-118.58518, 34.15359], [-118.58603, 34.1525], [-118.58688, 34.15235], [-118.58834, 34.15325], [-118.58835, 34.1574]]]} | Open Access 1 | 6414 | Serrania Avenue Park | 25316 | 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 | 35.478 | Serrania Avenue Park | 0 | Local Park 2 | 4 | |
1187 | 1187 | 1186 | {"type": "Polygon", "coordinates": [[[-118.24283, 34.04028], [-118.24264, 34.0405], [-118.24224, 34.04026], [-118.24244, 34.04004], [-118.24283, 34.04028]]]} | Open Access 1 | 7805 | Sixth and Gladys St. Park | 25524 | 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.34 | Sixth and Gladys St. Park | 0 | Local Park 2 | 4 | |
1191 | 1191 | 1190 | {"type": "Polygon", "coordinates": [[[-118.38189, 34.1221], [-118.38155, 34.1221], [-118.38136, 34.12216], [-118.38125, 34.12221], [-118.38104, 34.12239], [-118.38096, 34.12251], [-118.38092, 34.12263], [-118.38091, 34.12271], [-118.38088, 34.12276], [-118.38081, 34.12279], [-118.38072, 34.1228], [-118.38066, 34.12279], [-118.38004, 34.12239], [-118.37985, 34.12232], [-118.37965, 34.12228], [-118.3789, 34.12231], [-118.37872, 34.12225], [-118.37867, 34.12219], [-118.37854, 34.12209], [-118.37836, 34.122], [-118.3781, 34.12193], [-118.37787, 34.12192], [-118.37787, 34.11964], [-118.37905, 34.11965], [-118.37906, 34.11958], [-118.38053, 34.11959], [-118.38046, 34.11995], [-118.38129, 34.12021], [-118.38144, 34.12149], [-118.38176, 34.12172], [-118.38189, 34.1221]]]} | Open Access 1 | 6905 | Laurel Canyon Park | 21087 | 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 | 23.473 | Laurel Canyon 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]);