units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
50 rows where DES_TP = 2 and MNG_AGENCY = 52 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 30
MNG_AGENCY 1
- Newport Beach, City of · 30 ✖
DES_TP 1
- Local Park · 30 ✖
ACCESS_TYP 1
- Open Access 30
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
299 | 299 | 298 | {"type": "Polygon", "coordinates": [[[-117.89118, 33.62744], [-117.89109, 33.6275], [-117.89102, 33.62758], [-117.89077, 33.62794], [-117.89073, 33.62809], [-117.89075, 33.62825], [-117.8904, 33.62835], [-117.8906, 33.62779], [-117.89072, 33.62716], [-117.8909, 33.6271], [-117.89118, 33.62744]]]} | Open Access 1 | 803 | Galaxy View Park | 19171 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.948 | Galaxy View Park | 0 | Local Park 2 | 4 | |
1738 | 1738 | 1737 | {"type": "Polygon", "coordinates": [[[-117.84482, 33.61091], [-117.84442, 33.6108], [-117.84419, 33.6107], [-117.84396, 33.61058], [-117.8442, 33.61028], [-117.84435, 33.6102], [-117.84453, 33.61016], [-117.84464, 33.61024], [-117.84461, 33.61032], [-117.84464, 33.61041], [-117.8447, 33.61045], [-117.84478, 33.61046], [-117.84482, 33.61091]]]} | Open Access 1 | 12947 | Spyglass Hill Reservoir Park | 25757 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.949 | Spyglass Hill Reservoir Park | 0 | Local Park 2 | 4 | |
4848 | 4848 | 4847 | {"type": "Polygon", "coordinates": [[[-117.93748, 33.62363], [-117.93728, 33.62371], [-117.9371, 33.62381], [-117.93693, 33.62393], [-117.9367, 33.62416], [-117.93646, 33.62403], [-117.93612, 33.6238], [-117.93624, 33.6237], [-117.93632, 33.62366], [-117.93648, 33.6236], [-117.93665, 33.62356], [-117.93691, 33.62355], [-117.93729, 33.62357], [-117.93748, 33.62359], [-117.93748, 33.62363]]]} | Open Access 1 | 47424 | Sunset Ridge Park | 31140 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 1.077 | Sunset Ridge Park | 0 | Local Park 2 | 4 | |
9223 | 9223 | 9222 | {"type": "Polygon", "coordinates": [[[-117.93779, 33.62105], [-117.93766, 33.6216], [-117.93705, 33.62146], [-117.93662, 33.62098], [-117.93669, 33.62088], [-117.93779, 33.62105]]]} | Open Access 1 | 15344 | Channel Place Park | 17122 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 1.279 | Channel Place Park | 0 | Local Park 2 | 4 | |
8350 | 8350 | 8349 | {"type": "Polygon", "coordinates": [[[-117.84757, 33.61287], [-117.84709, 33.61286], [-117.84708, 33.61282], [-117.84703, 33.6128], [-117.8469, 33.61279], [-117.84658, 33.61231], [-117.84724, 33.61224], [-117.84742, 33.61225], [-117.84764, 33.6123], [-117.84767, 33.61232], [-117.84768, 33.61236], [-117.84757, 33.61287]]]} | Open Access 1 | 12935 | Spyglass Hill Park | 25756 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 1.299 | Spyglass Hill Park | 0 | Local Park 2 | 4 | |
1745 | 1745 | 1744 | {"type": "Polygon", "coordinates": [[[-117.92184, 33.60768], [-117.92172, 33.60823], [-117.92104, 33.60813], [-117.92107, 33.60796], [-117.9206, 33.60789], [-117.92068, 33.60751], [-117.92184, 33.60768]]]} | Open Access 1 | 15014 | Veterans Memorial Park | 27029 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 1.457 | Veterans Memorial Park | 0 | Local Park 2 | 4 | |
6349 | 6349 | 6348 | {"type": "Polygon", "coordinates": [[[-117.84516, 33.60647], [-117.84512, 33.6066], [-117.84389, 33.6063], [-117.84397, 33.60618], [-117.84398, 33.60601], [-117.84411, 33.60589], [-117.84429, 33.60579], [-117.84447, 33.60574], [-117.84455, 33.60573], [-117.84463, 33.60576], [-117.84472, 33.60583], [-117.84493, 33.60624], [-117.84502, 33.60636], [-117.84516, 33.60647]]]} | Open Access 1 | 47501 | Harbor Watch Park | 31216 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://nbgis.newportbeachca.gov/gispub/recreation/facilities/default.aspx | Orange 3 | 1.529 | Harbor Watch Park | 0 | Local Park 2 | 4 |
12788 | 12788 | 12787 | {"type": "Polygon", "coordinates": [[[-117.87411, 33.65187], [-117.87364, 33.65234], [-117.87338, 33.65216], [-117.87333, 33.65216], [-117.87331, 33.65209], [-117.87326, 33.65206], [-117.87319, 33.65205], [-117.87312, 33.65208], [-117.87308, 33.65213], [-117.87307, 33.65218], [-117.87281, 33.65212], [-117.87253, 33.65194], [-117.87254, 33.65162], [-117.87276, 33.65157], [-117.87298, 33.65154], [-117.87336, 33.65157], [-117.8736, 33.65162], [-117.87377, 33.65168], [-117.87393, 33.65176], [-117.87411, 33.65187]]]} | Open Access 1 | 30219 | Bayview Park | 15902 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 1.991 | Bayview Park | 0 | Local Park 2 | 4 | |
126 | 126 | 125 | {"type": "Polygon", "coordinates": [[[-117.92158, 33.62047], [-117.92075, 33.62131], [-117.92059, 33.62077], [-117.92003, 33.62037], [-117.92034, 33.62006], [-117.92071, 33.62032], [-117.92089, 33.62015], [-117.92158, 33.62047]]]} | Open Access 1 | 318 | Ensign View Park | 18682 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 2.134 | Ensign View Park | 0 | Local Park 2 | 4 | |
6550 | 6550 | 6549 | {"type": "Polygon", "coordinates": [[[-117.8785, 33.60028], [-117.87806, 33.60073], [-117.87786, 33.60084], [-117.87749, 33.60122], [-117.87699, 33.60086], [-117.87695, 33.60081], [-117.87698, 33.60076], [-117.87721, 33.60066], [-117.87743, 33.60053], [-117.87756, 33.60038], [-117.8778, 33.60002], [-117.87786, 33.60001], [-117.87806, 33.60003], [-117.87847, 33.59996], [-117.87837, 33.60002], [-117.87827, 33.60018], [-117.8785, 33.60028]]]} | Open Access 1 | 3277 | Begonia Park | 15955 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 2.145 | Begonia Park | 0 | Local Park 2 | 4 | |
9199 | 9199 | 9198 | {"type": "Polygon", "coordinates": [[[-117.89951, 33.62209], [-117.89873, 33.62219], [-117.89842, 33.62226], [-117.89814, 33.62236], [-117.89787, 33.6225], [-117.89762, 33.62265], [-117.89743, 33.62283], [-117.89748, 33.62305], [-117.89738, 33.62307], [-117.89734, 33.62311], [-117.89731, 33.62317], [-117.89733, 33.62325], [-117.89744, 33.62336], [-117.89711, 33.6238], [-117.89694, 33.62397], [-117.89678, 33.6239], [-117.89695, 33.62354], [-117.897, 33.62335], [-117.89703, 33.62301], [-117.89707, 33.62287], [-117.89714, 33.62275], [-117.8973, 33.62258], [-117.89795, 33.62213], [-117.89848, 33.6218], [-117.89863, 33.62174], [-117.89887, 33.62171], [-117.89904, 33.62172], [-117.89913, 33.62175], [-117.8992, 33.62181], [-117.89951, 33.62209]]]} | Open Access 1 | 15290 | Westcliff Park | 27387 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 2.984 | Westcliff Park | 0 | Local Park 2 | 4 | |
6519 | 6519 | 6518 | {"type": "MultiPolygon", "coordinates": [[[[-117.87277, 33.59691], [-117.87259, 33.59708], [-117.87225, 33.5969], [-117.87241, 33.59671], [-117.87277, 33.59691]]], [[[-117.87361, 33.59735], [-117.87343, 33.59752], [-117.87272, 33.59715], [-117.8729, 33.59698], [-117.8734, 33.59722], [-117.87361, 33.59735]]], [[[-117.87442, 33.59782], [-117.87425, 33.59799], [-117.87356, 33.59762], [-117.87372, 33.59744], [-117.87442, 33.59782]]], [[[-117.87765, 33.59996], [-117.87753, 33.60014], [-117.8752, 33.59854], [-117.87436, 33.59808], [-117.87453, 33.59788], [-117.87536, 33.59825], [-117.87553, 33.59837], [-117.87609, 33.59883], [-117.87627, 33.59901], [-117.87639, 33.59916], [-117.87674, 33.59945], [-117.8774, 33.59978], [-117.87764, 33.59992], [-117.87765, 33.59996]]]]} | Open Access 1 | 2757 | Bayside Park | 15897 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 3.525 | Bayside Park | 0 | Local Park 2 | 4 | |
6324 | 6324 | 6323 | {"type": "Polygon", "coordinates": [[[-117.84273, 33.60606], [-117.84233, 33.60601], [-117.84193, 33.60598], [-117.84011, 33.60593], [-117.83941, 33.60594], [-117.8394, 33.60578], [-117.83942, 33.60564], [-117.83954, 33.60542], [-117.83967, 33.60539], [-117.83994, 33.60557], [-117.84034, 33.60575], [-117.84049, 33.60576], [-117.84059, 33.60573], [-117.84067, 33.60568], [-117.84084, 33.60551], [-117.84114, 33.60531], [-117.8412, 33.60528], [-117.84132, 33.60527], [-117.84139, 33.60529], [-117.84152, 33.60538], [-117.8416, 33.60541], [-117.84212, 33.60542], [-117.84232, 33.6055], [-117.84238, 33.60558], [-117.84242, 33.60576], [-117.84263, 33.60582], [-117.84273, 33.60594], [-117.84273, 33.60606]]]} | Open Access 1 | 47410 | Canyon Watch Park | 31125 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 3.694 | Canyon Watch Park | 0 | Local Park 2 | 4 | |
6884 | 6884 | 6883 | {"type": "MultiPolygon", "coordinates": [[[[-117.9237, 33.6228], [-117.9237, 33.62326], [-117.92361, 33.6234], [-117.92352, 33.62348], [-117.92347, 33.62349], [-117.92332, 33.62349], [-117.92317, 33.62339], [-117.92316, 33.62333], [-117.92317, 33.62316], [-117.92309, 33.62302], [-117.92296, 33.62292], [-117.9228, 33.62287], [-117.92264, 33.62286], [-117.92247, 33.62291], [-117.92216, 33.62314], [-117.92203, 33.62321], [-117.92177, 33.62327], [-117.92158, 33.62328], [-117.92137, 33.62325], [-117.92123, 33.6232], [-117.92119, 33.62318], [-117.92117, 33.62314], [-117.92118, 33.6231], [-117.92136, 33.62291], [-117.92148, 33.62285], [-117.92198, 33.62287], [-117.92221, 33.62285], [-117.92258, 33.62276], [-117.92295, 33.62254], [-117.92316, 33.62235], [-117.92335, 33.62213], [-117.92333, 33.62226], [-117.9237, 33.6228]]], [[[-117.92517, 33.6225], [-117.92411, 33.62251], [-117.92393, 33.62196], [-117.92421, 33.62206], [-117.92446, 33.62211], [-117.92481, 33.6221], [-117.9251, 33.62204], [-117.92517, 33.6225]]]]} | Open Access 1 | 5621 | Cliff Drive Park | 17424 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 4.149 | Cliff Drive Park | 0 | Local Park 2 | 4 | |
1369 | 1369 | 1368 | {"type": "Polygon", "coordinates": [[[-117.90004, 33.60061], [-117.8997, 33.60129], [-117.89766, 33.60064], [-117.89775, 33.6005], [-117.89762, 33.60045], [-117.89793, 33.59997], [-117.89813, 33.60006], [-117.89822, 33.59994], [-117.89828, 33.59992], [-117.89928, 33.60027], [-117.89926, 33.60034], [-117.90004, 33.60061]]]} | Open Access 1 | 8249 | Peninsula Park | 23579 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 4.539 | Peninsula Park | 0 | Local Park 2 | 4 | |
7098 | 7098 | 7097 | {"type": "Polygon", "coordinates": [[[-117.90618, 33.62234], [-117.90575, 33.62311], [-117.90557, 33.62333], [-117.90548, 33.62358], [-117.90542, 33.62363], [-117.90531, 33.62377], [-117.9052, 33.62372], [-117.90522, 33.62354], [-117.90518, 33.62344], [-117.90511, 33.62332], [-117.90486, 33.62323], [-117.90428, 33.62307], [-117.90398, 33.62292], [-117.90394, 33.62284], [-117.90426, 33.62273], [-117.90442, 33.62262], [-117.90454, 33.62247], [-117.90457, 33.62236], [-117.90459, 33.62217], [-117.90464, 33.62211], [-117.90487, 33.62202], [-117.90506, 33.62201], [-117.90506, 33.62198], [-117.90537, 33.622], [-117.90558, 33.62205], [-117.90616, 33.62228], [-117.90618, 33.62234]]]} | Open Access 1 | 6150 | Bob Henry Park | 16208 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 5.104 | Bob Henry Park | 0 | Local Park 2 | 4 | |
9196 | 9196 | 9195 | {"type": "MultiPolygon", "coordinates": [[[[-117.94969, 33.62624], [-117.94958, 33.62636], [-117.94798, 33.62544], [-117.94766, 33.6253], [-117.94733, 33.6252], [-117.94731, 33.62523], [-117.94706, 33.62519], [-117.9469, 33.62513], [-117.94687, 33.62515], [-117.94658, 33.62509], [-117.94645, 33.6251], [-117.94609, 33.62504], [-117.94592, 33.62478], [-117.94549, 33.62395], [-117.94576, 33.6241], [-117.9462, 33.62432], [-117.9486, 33.62565], [-117.94891, 33.6258], [-117.94969, 33.62624]]], [[[-117.95249, 33.62804], [-117.95195, 33.62773], [-117.94969, 33.62643], [-117.9498, 33.62629], [-117.95143, 33.6272], [-117.95259, 33.62791], [-117.95259, 33.62793], [-117.95249, 33.62804]]], [[[-117.95641, 33.63022], [-117.95636, 33.63028], [-117.95425, 33.62911], [-117.95263, 33.62812], [-117.95273, 33.62801], [-117.95275, 33.628], [-117.95641, 33.63022]]]]} | Open Access 1 | 15264 | West Newport Park | 27370 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 6.289 | West Newport Park | 0 | Local Park 2 | 4 | |
4134 | 4134 | 4133 | {"type": "Polygon", "coordinates": [[[-117.92489, 33.60778], [-117.92468, 33.60878], [-117.92225, 33.60844], [-117.92237, 33.60782], [-117.92183, 33.60774], [-117.92183, 33.60768], [-117.92168, 33.60766], [-117.92169, 33.6076], [-117.92144, 33.60757], [-117.9215, 33.6073], [-117.92489, 33.60778]]]} | Open Access 1 | 47418 | Marina Park | 31135 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 7.25 | Marina Park | 0 | Local Park 2 | 4 | |
2352 | 2352 | 2351 | {"type": "Polygon", "coordinates": [[[-117.85359, 33.61808], [-117.85184, 33.6207], [-117.8518, 33.62072], [-117.85175, 33.62071], [-117.85126, 33.62047], [-117.85098, 33.62026], [-117.85073, 33.62], [-117.85148, 33.61962], [-117.85164, 33.61951], [-117.85188, 33.61926], [-117.85227, 33.61923], [-117.85249, 33.61903], [-117.8526, 33.61887], [-117.85289, 33.61831], [-117.8527, 33.61799], [-117.85232, 33.61781], [-117.85204, 33.61758], [-117.85208, 33.61732], [-117.85201, 33.61705], [-117.85166, 33.6168], [-117.8515, 33.61672], [-117.85112, 33.61646], [-117.8512, 33.61642], [-117.85359, 33.61808]]]} | Open Access 1 | 11189 | San Miguel Park | 24958 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 7.292 | San Miguel Park | 0 | Local Park 2 | 4 | |
6480 | 6480 | 6479 | {"type": "Polygon", "coordinates": [[[-117.88244, 33.60781], [-117.88204, 33.60814], [-117.88177, 33.60826], [-117.88164, 33.60833], [-117.88166, 33.60837], [-117.88145, 33.60853], [-117.88142, 33.60852], [-117.88129, 33.60865], [-117.88132, 33.60869], [-117.88122, 33.60882], [-117.88116, 33.609], [-117.88112, 33.60904], [-117.87903, 33.6076], [-117.87967, 33.60695], [-117.87971, 33.60694], [-117.88115, 33.60734], [-117.88169, 33.60757], [-117.88244, 33.60781]]]} | Open Access 1 | 2293 | Irvine Terrace Park | 20271 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 8.547 | Irvine Terrace 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]);