units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
20 rows where AGNCY_LEV = 2 and MNG_AGENCY = 302
This data as json, copyable, CSV (advanced)
DES_TP 3
MNG_AG_TYP 1
- City Agency 20
MNG_AGENCY 1
- Orange, City of · 20 ✖
ACCESS_TYP 1
- Open Access 20
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1023 | 1023 | 1022 | {"type": "Polygon", "coordinates": [[[-117.83939, 33.83531], [-117.8393, 33.83543], [-117.83908, 33.8363], [-117.83894, 33.83647], [-117.83895, 33.83656], [-117.83901, 33.83656], [-117.83901, 33.83684], [-117.83874, 33.83684], [-117.83875, 33.83701], [-117.8387, 33.83747], [-117.8387, 33.83783], [-117.83845, 33.83783], [-117.83845, 33.83883], [-117.83871, 33.83885], [-117.83842, 33.83889], [-117.83807, 33.83898], [-117.83777, 33.83899], [-117.83753, 33.83896], [-117.83725, 33.83889], [-117.837, 33.83885], [-117.83614, 33.83882], [-117.83595, 33.83875], [-117.83586, 33.83869], [-117.83566, 33.83848], [-117.83543, 33.8383], [-117.83542, 33.83827], [-117.8358, 33.83746], [-117.83607, 33.83671], [-117.83773, 33.83668], [-117.83769, 33.83507], [-117.83865, 33.83506], [-117.83866, 33.83511], [-117.83886, 33.83513], [-117.83905, 33.83517], [-117.83924, 33.83524], [-117.83939, 33.83531]]]} | Open Access 1 | 5640 | Eisenhower Park | 18474 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=2534 | Orange 3 | 21.754 | Eisenhower Park | 0 | Local Park 2 | 4 |
1084 | 1084 | 1083 | {"type": "Polygon", "coordinates": [[[-117.85231, 33.83686], [-117.85225, 33.83819], [-117.85103, 33.83816], [-117.85011, 33.83714], [-117.85165, 33.83617], [-117.85231, 33.83686]]]} | Open Access 1 | 6460 | Olive Park | 23126 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=2526 | Orange 3 | 7.356 | Olive Park | 0 | Local Park 2 | 4 |
1395 | 1395 | 1394 | {"type": "Polygon", "coordinates": [[[-117.85303, 33.78766], [-117.85312, 33.78765], [-117.85326, 33.78767], [-117.85333, 33.78771], [-117.85338, 33.78776], [-117.85342, 33.78785], [-117.85342, 33.7879], [-117.85339, 33.78797], [-117.85334, 33.78803], [-117.85322, 33.78809], [-117.85309, 33.78811], [-117.85292, 33.78806], [-117.85283, 33.78799], [-117.85279, 33.78787], [-117.85282, 33.78779], [-117.85286, 33.78773], [-117.85292, 33.78769], [-117.85303, 33.78766]]]} | Open Access 1 | 8625 | Plaza Square Park | 23791 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=2535 | Orange 3 | 0.568 | Plaza Square Park | 0 | Local Park 2 | 4 |
1428 | 1428 | 1427 | {"type": "Polygon", "coordinates": [[[-117.85179, 33.81938], [-117.85134, 33.82073], [-117.84911, 33.82074], [-117.84909, 33.8194], [-117.85179, 33.81938]]]} | Open Access 1 | 12418 | Shaffer Park | 25352 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=15255 | Orange 3 | 8.392 | Shaffer Park | 0 | Local Park 2 | 4 |
1710 | 1710 | 1709 | {"type": "Polygon", "coordinates": [[[-117.81403, 33.78168], [-117.81385, 33.78162], [-117.81382, 33.78165], [-117.81354, 33.78152], [-117.81321, 33.78128], [-117.81304, 33.78111], [-117.81288, 33.78085], [-117.81279, 33.78062], [-117.81401, 33.78061], [-117.81403, 33.78168]]]} | Open Access 1 | 12933 | La Veta Park | 20814 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | Orange 3 | 2.295 | La Veta Park | 0 | Local Park 2 | 4 | |
2029 | 2029 | 2028 | {"type": "Polygon", "coordinates": [[[-117.82924, 33.78766], [-117.82727, 33.78768], [-117.8272, 33.78763], [-117.8272, 33.78599], [-117.82924, 33.78599], [-117.82924, 33.78766]]]} | Open Access 1 | 15491 | Yorba Park | 27777 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=2531 | Orange 3 | 8.668 | Yorba Park | 0 | Local Park 2 | 4 |
4145 | 4145 | 4144 | {"type": "Polygon", "coordinates": [[[-117.81825, 33.78334], [-117.81778, 33.78335], [-117.81777, 33.78293], [-117.81682, 33.78293], [-117.81635, 33.78287], [-117.81611, 33.7827], [-117.81608, 33.78405], [-117.81403, 33.78405], [-117.81403, 33.78178], [-117.81424, 33.78184], [-117.81457, 33.78187], [-117.81825, 33.78188], [-117.81825, 33.78334]]]} | Open Access 1 | 47500 | McPherson Athletic Facility | 31215 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?blobid=2525 | Orange 3 | 17.607 | McPherson Athletic Facility | 0 | Local Recreation Area 3 | 4 |
4232 | 4232 | 4231 | {"type": "Polygon", "coordinates": [[[-117.80563, 33.83343], [-117.80562, 33.8335], [-117.80503, 33.83395], [-117.8047, 33.83359], [-117.80439, 33.83291], [-117.80503, 33.83272], [-117.80534, 33.8331], [-117.80537, 33.83321], [-117.80563, 33.83343]]]} | Open Access 1 | 30345 | Belmont Park | 15993 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=2518 | Orange 3 | 2.104 | Belmont Park | 0 | Local Park 2 | 4 |
4783 | 4783 | 4782 | {"type": "Polygon", "coordinates": [[[-117.79446, 33.8233], [-117.7936, 33.82387], [-117.79307, 33.82417], [-117.79173, 33.82406], [-117.79024, 33.82475], [-117.78846, 33.82477], [-117.78746, 33.82377], [-117.78764, 33.82361], [-117.7879, 33.82307], [-117.78779, 33.82268], [-117.78789, 33.82253], [-117.78847, 33.82231], [-117.7888, 33.82226], [-117.79011, 33.82225], [-117.79095, 33.82214], [-117.79122, 33.82312], [-117.79446, 33.8233]]]} | Open Access 1 | 47428 | Unnamed site - City of Orange | 31145 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | Orange 3 | 26.593 | 0 | Local Other or Unknown 14 | 4 | ||
5816 | 5816 | 5815 | {"type": "MultiPolygon", "coordinates": [[[[-117.80522, 33.77805], [-117.80516, 33.77848], [-117.80507, 33.77873], [-117.80498, 33.77889], [-117.80469, 33.77923], [-117.80459, 33.77939], [-117.80449, 33.77961], [-117.80446, 33.77974], [-117.80347, 33.77974], [-117.80347, 33.77977], [-117.8031, 33.77977], [-117.80311, 33.77801], [-117.80518, 33.77802], [-117.80522, 33.77805]]], [[[-117.80651, 33.77897], [-117.80594, 33.77961], [-117.80594, 33.78083], [-117.80596, 33.78174], [-117.80591, 33.78197], [-117.80584, 33.78216], [-117.80574, 33.78233], [-117.80555, 33.78257], [-117.80556, 33.78274], [-117.80548, 33.78265], [-117.80546, 33.78266], [-117.8053, 33.7825], [-117.80516, 33.78234], [-117.80501, 33.78207], [-117.80469, 33.7801], [-117.80468, 33.77984], [-117.80472, 33.77967], [-117.80479, 33.7795], [-117.80488, 33.77935], [-117.80514, 33.77907], [-117.80526, 33.77892], [-117.80604, 33.77893], [-117.80605, 33.77896], [-117.80651, 33.77897]]]]} | Open Access 1 | 88 | El Modena Park | 18516 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=2520 | Orange 3 | 17.868 | El Modena Park | 0 | Local Park 2 | 4 |
6126 | 6126 | 6125 | {"type": "Polygon", "coordinates": [[[-117.85743, 33.78848], [-117.85701, 33.78847], [-117.85701, 33.78807], [-117.85705, 33.78801], [-117.85709, 33.78799], [-117.85742, 33.78799], [-117.85743, 33.78848]]]} | Open Access 1 | 47427 | Veterans Memorial at Depot Park | 31144 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | Orange 3 | 0.5 | Veterans Memorial at Depot Park | 0 | Local Park 2 | 4 | |
6274 | 6274 | 6273 | {"type": "Polygon", "coordinates": [[[-117.83124, 33.8021], [-117.83064, 33.80211], [-117.82911, 33.8022], [-117.82913, 33.8005], [-117.83021, 33.80049], [-117.83023, 33.79869], [-117.83089, 33.79869], [-117.83124, 33.8021]]]} | Open Access 1 | 1370 | Handy Park | 19637 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=6991 | Orange 3 | 11.999 | Handy Park | 0 | Local Park 2 | 4 |
6310 | 6310 | 6309 | {"type": "Polygon", "coordinates": [[[-117.85302, 33.77682], [-117.85302, 33.77864], [-117.85295, 33.77859], [-117.85216, 33.77859], [-117.85215, 33.77866], [-117.85193, 33.77872], [-117.85193, 33.77864], [-117.85177, 33.77863], [-117.85151, 33.77834], [-117.85107, 33.77834], [-117.85092, 33.77838], [-117.85091, 33.77824], [-117.85038, 33.77839], [-117.84974, 33.7788], [-117.84878, 33.7788], [-117.84879, 33.77693], [-117.84662, 33.77693], [-117.8466, 33.77593], [-117.84745, 33.77569], [-117.84838, 33.77556], [-117.84964, 33.77555], [-117.85057, 33.77563], [-117.85231, 33.77621], [-117.85292, 33.77631], [-117.85295, 33.77643], [-117.85297, 33.77681], [-117.85302, 33.77682]]]} | Open Access 1 | 1473 | Hart Park | 19709 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=2522 | Orange 3 | 36.267 | Hart Park | 0 | Local Park 2 | 4 |
6529 | 6529 | 6528 | {"type": "Polygon", "coordinates": [[[-117.85516, 33.79876], [-117.85375, 33.79875], [-117.85375, 33.79773], [-117.85363, 33.79772], [-117.85363, 33.7973], [-117.85378, 33.79729], [-117.85378, 33.79698], [-117.85428, 33.79698], [-117.85428, 33.79672], [-117.85443, 33.79673], [-117.85444, 33.7972], [-117.85433, 33.79721], [-117.85433, 33.79733], [-117.85477, 33.79733], [-117.85477, 33.79797], [-117.85481, 33.79801], [-117.85516, 33.79801], [-117.85516, 33.79876]]]} | Open Access 1 | 2868 | Killefer Park | 20642 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=2533 | Orange 3 | 5.202 | Killefer Park | 0 | Local Park 2 | 4 |
10798 | 10798 | 10797 | {"type": "Polygon", "coordinates": [[[-117.87165, 33.79308], [-117.87079, 33.79409], [-117.87065, 33.79429], [-117.87055, 33.7945], [-117.87044, 33.79484], [-117.86915, 33.79484], [-117.86914, 33.79486], [-117.8681, 33.79486], [-117.86776, 33.7949], [-117.86703, 33.79505], [-117.86679, 33.79507], [-117.86668, 33.795], [-117.86664, 33.79472], [-117.86663, 33.79346], [-117.86667, 33.79315], [-117.86674, 33.7931], [-117.8669, 33.79306], [-117.87165, 33.79308]]]} | Open Access 1 | 20294 | El Camino Real Park | 18481 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=15253 | Orange 3 | 19.851 | El Camino Real Park | 0 | Local Park 2 | 4 |
11976 | 11976 | 11975 | {"type": "Polygon", "coordinates": [[[-117.82251, 33.79145], [-117.82246, 33.79155], [-117.82231, 33.79174], [-117.8211, 33.79298], [-117.82087, 33.79328], [-117.82042, 33.7937], [-117.82014, 33.79351], [-117.81984, 33.79349], [-117.81974, 33.79342], [-117.8196, 33.79321], [-117.8195, 33.79314], [-117.81936, 33.79315], [-117.8192, 33.79332], [-117.8191, 33.79354], [-117.81888, 33.79357], [-117.8187, 33.7934], [-117.81849, 33.7934], [-117.8185, 33.7915], [-117.82251, 33.79145]]]} | Open Access 1 | 24606 | Grijalva Park at Santiago Creek | 19519 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=2445 | Orange 3 | 15.556 | Grijalva Park at Santiago Creek | 0 | Local Other or Unknown 14 | 4 |
11977 | 11977 | 11976 | {"type": "MultiPolygon", "coordinates": [[[[-117.76803, 33.78832], [-117.76799, 33.78837], [-117.76794, 33.7885], [-117.76785, 33.78862], [-117.76783, 33.78852], [-117.76758, 33.78837], [-117.76688, 33.7879], [-117.76732, 33.7881], [-117.76769, 33.78824], [-117.76803, 33.78832]]], [[[-117.77057, 33.79143], [-117.77055, 33.79147], [-117.7701, 33.79168], [-117.7701, 33.7917], [-117.7695, 33.79192], [-117.76888, 33.79208], [-117.76798, 33.79219], [-117.76722, 33.7922], [-117.76724, 33.79217], [-117.7674, 33.79204], [-117.76742, 33.79194], [-117.76743, 33.79131], [-117.76754, 33.79125], [-117.76937, 33.79052], [-117.7683, 33.78887], [-117.76805, 33.7887], [-117.76812, 33.78862], [-117.76819, 33.78848], [-117.76822, 33.78835], [-117.76857, 33.78839], [-117.76891, 33.78839], [-117.76891, 33.78856], [-117.76843, 33.78874], [-117.76843, 33.78876], [-117.76956, 33.79049], [-117.76959, 33.79058], [-117.76975, 33.7908], [-117.77019, 33.79157], [-117.77057, 33.79143]]]]} | Open Access 1 | 24608 | Santiago Hills Park | 25152 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=15254 | Orange 3 | 9.888 | Santiago Hills Park | 0 | Local Park 2 | 4 |
12342 | 12342 | 12341 | {"type": "Polygon", "coordinates": [[[-117.84521, 33.78557], [-117.84521, 33.78595], [-117.84452, 33.78595], [-117.84452, 33.7857], [-117.8449, 33.7857], [-117.84491, 33.78557], [-117.84521, 33.78557]]]} | Open Access 1 | 26035 | Pitcher Park | 23747 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=2527 | Orange 3 | 0.537 | Pitcher Park | 0 | Local Park 2 | 4 |
12887 | 12887 | 12886 | {"type": "Polygon", "coordinates": [[[-117.76711, 33.82831], [-117.76638, 33.82832], [-117.7663, 33.82829], [-117.76611, 33.82829], [-117.76603, 33.82832], [-117.76546, 33.82832], [-117.76488, 33.82837], [-117.7643, 33.82849], [-117.76422, 33.82848], [-117.76403, 33.82854], [-117.76397, 33.82858], [-117.76349, 33.82876], [-117.76334, 33.8288], [-117.76307, 33.82894], [-117.76295, 33.82892], [-117.76292, 33.82894], [-117.76286, 33.82886], [-117.76283, 33.82876], [-117.76283, 33.82872], [-117.76276, 33.82868], [-117.7628, 33.82863], [-117.76285, 33.82859], [-117.76375, 33.8282], [-117.76397, 33.82823], [-117.76402, 33.82792], [-117.76711, 33.82831]]]} | Open Access 1 | 30346 | Fred Barrera Park | 19072 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=5410 | Orange 3 | 3.204 | Fred Barrera Park | 0 | Local Park 2 | 4 |
12889 | 12889 | 12888 | {"type": "Polygon", "coordinates": [[[-117.7818, 33.82905], [-117.78166, 33.82921], [-117.78004, 33.82881], [-117.77954, 33.82862], [-117.77952, 33.82849], [-117.77946, 33.82848], [-117.77913, 33.82789], [-117.77888, 33.82762], [-117.77894, 33.82756], [-117.77925, 33.82778], [-117.77952, 33.82794], [-117.78015, 33.82825], [-117.7803, 33.82835], [-117.78036, 33.82838], [-117.78046, 33.82838], [-117.78051, 33.82835], [-117.7807, 33.82818], [-117.78093, 33.82801], [-117.78119, 33.82825], [-117.78129, 33.8284], [-117.7816, 33.82867], [-117.78165, 33.82869], [-117.78173, 33.82867], [-117.7818, 33.82905]]]} | Open Access 1 | 30347 | Serrano Park | 25319 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?blobid=2670 | Orange 3 | 4.346 | Serrano 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]);