units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,440 rows where DES_TP = 3 and MNG_AG_TYP = 2 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 211
- Los Angeles, City of 116
- San Francisco, City and County of 80
- San Luis Obispo, City of 26
- Long Beach, City of 25
- Glendale, City of 24
- Davis, City of 23
- Santa Clarita, City of 18
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Fullerton, City of 15
- Santa Cruz, City of 14
- San Bernardino, City of 14
- San Marcos, City of 14
- Tiburon, Town of 13
- Carlsbad, City of 12
- Poway, City of 12
- Mission Viejo, City of 11
- Fresno, City of 10
- Oceanside, City of 10
- Riverside, City of 9
- Irvine, City of 9
- Roseville, City of 9
- Santa Barbara, City of 8
- South San Francisco, City of 8
- Escondido, City of 8
- Chico, City of 8
- …
ACCESS_TYP 4
- Open Access 1,226
- Restricted Access 168
- No Public Access 40
- Unknown Access 6
MNG_AG_TYP 1
- City Agency · 1,440 ✖
DES_TP 1
- Local Recreation Area · 1,440 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | 3 | 2 | {"type": "Polygon", "coordinates": [[[-120.81796, 37.78801], [-120.81602, 37.78793], [-120.81565, 37.78787], [-120.81358, 37.7878], [-120.81268, 37.78774], [-120.8117, 37.78776], [-120.8111, 37.78789], [-120.81064, 37.78764], [-120.80991, 37.78733], [-120.80928, 37.78757], [-120.80895, 37.78704], [-120.80743, 37.78568], [-120.80702, 37.78537], [-120.80701, 37.78515], [-120.80703, 37.78338], [-120.80993, 37.78254], [-120.81293, 37.78022], [-120.81292, 37.77802], [-120.81434, 37.77723], [-120.81693, 37.77715], [-120.81697, 37.78113], [-120.81726, 37.78253], [-120.81756, 37.78477], [-120.81686, 37.78479], [-120.81635, 37.78482], [-120.8157, 37.78465], [-120.81513, 37.78463], [-120.81405, 37.78454], [-120.81371, 37.7843], [-120.81343, 37.78428], [-120.81288, 37.78427], [-120.81092, 37.78458], [-120.81058, 37.78429], [-120.81017, 37.78433], [-120.80902, 37.785], [-120.80861, 37.78529], [-120.80875, 37.78561], [-120.80897, 37.78583], [-120.80941, 37.78606], [-120.80994, 37.78614], [-120.81072, 37.78613], [-120.81093, 37.78596], [-120.8114, 37.78609], [-120.81224, 37.78639], [-120.81288, 37.78655], [-120.8129, 37.78674], [-120.81368, 37.78684], [-120.8148, 37.78683], [-120.81525, 37.78688], [-120.81579, 37.78697], [-120.81674, 37.78697], [-120.81725, 37.78683], [-120.81777, 37.7866], [-120.81796, 37.78801]], [[-120.81641, 37.7829], [-120.81637, 37.78261], [-120.81576, 37.78291], [-120.81539, 37.78302], [-120.81522, 37.78337], [-120.81521, 37.78348], [-120.8154, 37.78386], [-120.81556, 37.78389], [-120.81566, 37.78395], [-120.81602, 37.78396], [-120.81609, 37.784], [-120.81655, 37.78409], [-120.81655, 37.78401], [-120.81644, 37.78328], [-120.81641, 37.7829]]]} | Restricted Access 2 | 9 | Oakdale Golf & Country Club | 32983 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 137.317 | Oakdale Golf & Country Club | 0 | Local Recreation Area 3 | 4 | |
5772 | 5772 | 5771 | {"type": "MultiPolygon", "coordinates": [[[[-117.09595, 32.73243], [-117.09595, 32.73295], [-117.09545, 32.73295], [-117.09545, 32.73292], [-117.09595, 32.73243]]], [[[-117.09843, 32.73523], [-117.09843, 32.73653], [-117.09794, 32.73653], [-117.09794, 32.73626], [-117.09742, 32.73627], [-117.09716, 32.73619], [-117.0962, 32.73618], [-117.0962, 32.73598], [-117.0967, 32.73597], [-117.09673, 32.7318], [-117.09719, 32.7318], [-117.09717, 32.73381], [-117.0979, 32.73382], [-117.09789, 32.73522], [-117.09843, 32.73523]]], [[[-117.09844, 32.73154], [-117.09844, 32.73179], [-117.09803, 32.7318], [-117.09802, 32.73173], [-117.09745, 32.73172], [-117.09745, 32.73153], [-117.09844, 32.73154]]], [[[-117.09875, 32.73833], [-117.09835, 32.73833], [-117.09836, 32.73695], [-117.09875, 32.73695], [-117.09875, 32.73833]]], [[[-117.09913, 32.73237], [-117.09913, 32.73258], [-117.09869, 32.73258], [-117.09869, 32.73237], [-117.09913, 32.73237]]], [[[-117.09913, 32.73195], [-117.09913, 32.73209], [-117.09869, 32.73209], [-117.09869, 32.73195], [-117.09913, 32.73195]]], [[[-117.09935, 32.73841], [-117.09934, 32.73864], [-117.09894, 32.73864], [-117.09894, 32.73841], [-117.09935, 32.73841]]]]} | Open Access 1 | 20 | Swan's Canyon | 26095 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 14.734 | Swan's Canyon | 0 | Local Recreation Area 3 | 4 | |
5787 | 5787 | 5786 | {"type": "Polygon", "coordinates": [[[-117.16383, 32.73565], [-117.16352, 32.73566], [-117.16351, 32.7358], [-117.16293, 32.7358], [-117.16292, 32.73594], [-117.16203, 32.73595], [-117.16202, 32.73649], [-117.16202, 32.73727], [-117.1617, 32.73727], [-117.1617, 32.73766], [-117.16137, 32.73766], [-117.16136, 32.73741], [-117.16137, 32.73596], [-117.16184, 32.73595], [-117.16185, 32.73568], [-117.16227, 32.73567], [-117.16226, 32.73477], [-117.16292, 32.73477], [-117.16293, 32.73452], [-117.16319, 32.73452], [-117.1632, 32.73438], [-117.16382, 32.73438], [-117.16383, 32.73565]]]} | Open Access 1 | 21 | Maple Canyon Open Space | 21772 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 7.943 | Maple Canyon OS | 0 | Local Recreation Area 3 | 4 | |
5777 | 5777 | 5776 | {"type": "Polygon", "coordinates": [[[-120.83709, 37.74748], [-120.83712, 37.74754], [-120.83714, 37.74873], [-120.83713, 37.7489], [-120.83708, 37.74903], [-120.83695, 37.74922], [-120.8368, 37.74935], [-120.83658, 37.74948], [-120.83621, 37.74958], [-120.83463, 37.74956], [-120.83439, 37.74952], [-120.83428, 37.74948], [-120.83403, 37.74934], [-120.83394, 37.74926], [-120.83384, 37.74915], [-120.83373, 37.74897], [-120.83371, 37.74879], [-120.8337, 37.7475], [-120.83378, 37.74745], [-120.83702, 37.74745], [-120.83709, 37.74748]]]} | Open Access 1 | 29 | T L Davis Youth Sports Park | 26155 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 16.658 | T L Davis Youth Sports Park | 0 | Local Recreation Area 3 | 4 | |
10 | 10 | 9 | {"type": "MultiPolygon", "coordinates": [[[[-117.09436, 32.74201], [-117.09395, 32.74201], [-117.09393, 32.74146], [-117.09346, 32.74146], [-117.09345, 32.74102], [-117.09291, 32.74017], [-117.09284, 32.74016], [-117.09282, 32.73919], [-117.09236, 32.73919], [-117.09235, 32.7385], [-117.0928, 32.73849], [-117.09279, 32.73755], [-117.09339, 32.73754], [-117.09339, 32.73696], [-117.09359, 32.73697], [-117.0936, 32.73699], [-117.0938, 32.73699], [-117.09383, 32.7391], [-117.09321, 32.73912], [-117.09324, 32.74037], [-117.09385, 32.74037], [-117.09387, 32.74118], [-117.09435, 32.74118], [-117.09436, 32.74201]]], [[[-117.09277, 32.74057], [-117.0927, 32.74058], [-117.09269, 32.74084], [-117.09238, 32.74085], [-117.09238, 32.74039], [-117.09276, 32.74038], [-117.09277, 32.74057]]], [[[-117.09497, 32.74242], [-117.09456, 32.74242], [-117.09456, 32.74223], [-117.09497, 32.74222], [-117.09497, 32.74242]]], [[[-117.09603, 32.7429], [-117.09564, 32.74291], [-117.09564, 32.7427], [-117.09603, 32.7427], [-117.09603, 32.7429]]]]} | Open Access 1 | 31 | 47th Street Canyon | 15202 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 9.994 | 47th Street Canyon | 0 | Local Recreation Area 3 | 4 | |
5179 | 5179 | 5178 | {"type": "Polygon", "coordinates": [[[-117.15713, 32.7541], [-117.15639, 32.7541], [-117.15639, 32.75376], [-117.15712, 32.75376], [-117.15713, 32.7541]]]} | Open Access 1 | 40 | Mission Valley Hillsides Open Space | 22316 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.644 | Mission Valley Hillsides OS | 0 | Local Recreation Area 3 | 4 | |
5798 | 5798 | 5797 | {"type": "Polygon", "coordinates": [[[-121.9319, 36.60721], [-121.93203, 36.60742], [-121.93214, 36.60765], [-121.93222, 36.60787], [-121.93227, 36.60812], [-121.93229, 36.60833], [-121.93229, 36.60854], [-121.93226, 36.6088], [-121.93222, 36.60897], [-121.93212, 36.60925], [-121.932, 36.60951], [-121.93184, 36.60975], [-121.93143, 36.60999], [-121.93122, 36.61014], [-121.93097, 36.61035], [-121.93067, 36.61064], [-121.93031, 36.6111], [-121.92995, 36.61168], [-121.92927, 36.6127], [-121.92828, 36.61221], [-121.92858, 36.61186], [-121.92888, 36.61143], [-121.92909, 36.61108], [-121.92944, 36.61037], [-121.92975, 36.6099], [-121.92999, 36.60961], [-121.93025, 36.60934], [-121.93067, 36.60913], [-121.93078, 36.60898], [-121.93085, 36.60884], [-121.9309, 36.60867], [-121.93093, 36.6085], [-121.93092, 36.60832], [-121.93089, 36.60815], [-121.9307, 36.60773], [-121.93034, 36.60709], [-121.93161, 36.60675], [-121.9319, 36.60721]]]} | Open Access 1 | 54 | Rip Van Winkle Open Space | 24394 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 19.761 | Rip Van Winkle OS | 0 | Local Recreation Area 3 | 4 | |
15958 | 15958 | 15957 | {"type": "MultiPolygon", "coordinates": [[[[-117.16852, 32.75178], [-117.16819, 32.75178], [-117.16819, 32.75095], [-117.16851, 32.75094], [-117.16852, 32.75178]]], [[[-117.17277, 32.75259], [-117.17219, 32.7526], [-117.17221, 32.75382], [-117.17234, 32.75383], [-117.17233, 32.75447], [-117.17188, 32.75448], [-117.17188, 32.75493], [-117.17128, 32.75494], [-117.17129, 32.75521], [-117.17188, 32.75521], [-117.17188, 32.75535], [-117.1704, 32.75535], [-117.1704, 32.75679], [-117.16881, 32.75676], [-117.16879, 32.75595], [-117.16827, 32.75595], [-117.16825, 32.7539], [-117.16825, 32.75383], [-117.16882, 32.75382], [-117.1688, 32.75369], [-117.1688, 32.75301], [-117.16946, 32.75301], [-117.16949, 32.75482], [-117.17153, 32.7548], [-117.17154, 32.75383], [-117.17152, 32.75273], [-117.17153, 32.75233], [-117.17127, 32.75232], [-117.17061, 32.75232], [-117.17062, 32.75197], [-117.17065, 32.75193], [-117.1707, 32.75191], [-117.17127, 32.75191], [-117.17128, 32.75218], [-117.17185, 32.75218], [-117.17186, 32.75225], [-117.17244, 32.75225], [-117.17245, 32.75219], [-117.17277, 32.75219], [-117.17277, 32.75259]]], [[[-117.1731, 32.75421], [-117.17278, 32.75421], [-117.17277, 32.75382], [-117.17309, 32.75381], [-117.1731, 32.75421]]]]} | Open Access 1 | 63 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 22.556 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
2839 | 2839 | 2838 | {"type": "Polygon", "coordinates": [[[-117.15582, 32.75554], [-117.15554, 32.75574], [-117.15531, 32.75552], [-117.15538, 32.75542], [-117.15582, 32.75543], [-117.15582, 32.75554]]]} | Open Access 1 | 68 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.27 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
5805 | 5805 | 5804 | {"type": "Polygon", "coordinates": [[[-117.15503, 32.75526], [-117.15494, 32.7552], [-117.15494, 32.75483], [-117.15502, 32.75483], [-117.15503, 32.75526]]]} | Open Access 1 | 73 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.082 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
15959 | 15959 | 15958 | {"type": "Polygon", "coordinates": [[[-117.15844, 32.75574], [-117.15803, 32.75574], [-117.15769, 32.75634], [-117.15747, 32.75625], [-117.15712, 32.75602], [-117.15701, 32.75585], [-117.15677, 32.7558], [-117.15656, 32.75572], [-117.15644, 32.75554], [-117.15643, 32.75545], [-117.15766, 32.75548], [-117.15765, 32.7543], [-117.15782, 32.75454], [-117.158, 32.75474], [-117.15844, 32.75574]]]} | Open Access 1 | 74 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.512 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
34 | 34 | 33 | {"type": "MultiPolygon", "coordinates": [[[[-117.17794, 32.74783], [-117.17775, 32.74806], [-117.17722, 32.74774], [-117.1774, 32.74752], [-117.17794, 32.74783]]], [[[-117.17828, 32.74722], [-117.17791, 32.74765], [-117.1775, 32.74741], [-117.17767, 32.74719], [-117.17788, 32.74732], [-117.17807, 32.74709], [-117.17828, 32.74722]]], [[[-117.18416, 32.74689], [-117.18397, 32.7471], [-117.18305, 32.74655], [-117.18229, 32.74742], [-117.18242, 32.74751], [-117.18213, 32.74784], [-117.1823, 32.74795], [-117.18122, 32.74795], [-117.18235, 32.74663], [-117.18211, 32.74647], [-117.18239, 32.74614], [-117.18259, 32.74591], [-117.18283, 32.74606], [-117.18329, 32.74552], [-117.18411, 32.74602], [-117.1836, 32.74661], [-117.18398, 32.74685], [-117.18403, 32.74681], [-117.18416, 32.74689]]]]} | Open Access 1 | 83 | Mission Hills Park and Open Space | 22301 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 7.109 | Mission Hills Park and OS | 0 | Local Recreation Area 3 | 4 | |
5809 | 5809 | 5808 | {"type": "Polygon", "coordinates": [[[-117.18992, 32.75185], [-117.18955, 32.7523], [-117.18866, 32.75176], [-117.18881, 32.75169], [-117.18925, 32.75194], [-117.18954, 32.75161], [-117.18992, 32.75185]]]} | Open Access 1 | 90 | Presidio Open Space | 23994 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.879 | Presidio OS | 0 | Local Recreation Area 3 | 4 | |
5818 | 5818 | 5817 | {"type": "Polygon", "coordinates": [[[-117.08127, 32.81201], [-117.08111, 32.81199], [-117.08082, 32.81197], [-117.0803, 32.81201], [-117.08005, 32.81207], [-117.07981, 32.81215], [-117.07902, 32.81256], [-117.07878, 32.81271], [-117.0779, 32.81364], [-117.07744, 32.81414], [-117.07736, 32.81426], [-117.07726, 32.81451], [-117.07722, 32.81469], [-117.07681, 32.81432], [-117.08089, 32.8107], [-117.08127, 32.81201]]]} | Open Access 1 | 102 | Tierrasanta Open Space | 10608 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 5.337 | Tierrasanta OS | 0 | Local Recreation Area 3 | 4 | |
15965 | 15965 | 15964 | {"type": "MultiPolygon", "coordinates": [[[[-117.06586, 32.80515], [-117.0658, 32.80532], [-117.06343, 32.80519], [-117.06325, 32.80547], [-117.06301, 32.80761], [-117.06336, 32.8082], [-117.06378, 32.80842], [-117.06404, 32.80838], [-117.06411, 32.80847], [-117.06393, 32.80853], [-117.06402, 32.8088], [-117.06447, 32.80976], [-117.06452, 32.80996], [-117.06437, 32.81087], [-117.06436, 32.81175], [-117.06431, 32.81197], [-117.06418, 32.8122], [-117.06408, 32.81213], [-117.06366, 32.81262], [-117.06351, 32.81309], [-117.06307, 32.81359], [-117.06266, 32.8139], [-117.06209, 32.81451], [-117.0618, 32.81439], [-117.06151, 32.81416], [-117.06085, 32.81369], [-117.06063, 32.81316], [-117.06025, 32.81191], [-117.06025, 32.81157], [-117.06002, 32.81126], [-117.05985, 32.81078], [-117.05986, 32.81033], [-117.05937, 32.81002], [-117.05873, 32.80993], [-117.05828, 32.81042], [-117.05848, 32.81087], [-117.05885, 32.81116], [-117.05923, 32.8122], [-117.05923, 32.81292], [-117.05865, 32.81321], [-117.05802, 32.81297], [-117.05714, 32.81297], [-117.05713, 32.81344], [-117.05537, 32.81343], [-117.05383, 32.81191], [-117.05519, 32.81109], [-117.05563, 32.81081], [-117.05563, 32.81072], [-117.05614, 32.8107], [-117.0562, 32.81078], [-117.05632, 32.81082], [-117.05656, 32.81096], [-117.05643, 32.8112], [-117.05723, 32.81156], [-117.05722, 32.80997], [-117.05739, 32.80997], [-117.05777, 32.80957], [-117.0577, 32.80943], [-117.05788, 32.80927], [-117.05802, 32.80899], [-117.05833, 32.80894], [-117.05874, 32.809], [-117.05909, 32.80913], [-117.05933, 32.80928], [-117.06093, 32.8098], [-117.06091, 32.80984], [-117.06093, 32.80991], [-117.06083, 32.81019], [-117.06135, 32.8109], [-117.06145, 32.81095], [-117.0617, 32.81149], [-117.06173, 32.81186], [-117.06196, 32.8122], [-117.06225, 32.81232], [-117.06231, 32.81226], [-117.06237, 32.81208], [-117.06233, 32.81192], [-117.06269, 32.81185], [-117.06284, 32.8116], [-117.06284, 32.81142], [-117.06277, 32.81094], [-117.06252, 32.8104], [-117.06236, 32.80984], [-117.0623, 32.80971], [-117.06234, 32.80927], [-117.062, 32.80922], [-117.06153, 32.8091], [-117.0613, 32.80908], [-117.06115, 32.80889], [-117.06118, 32.8086], [-117.06128, 32.80818], [-117.06143, 32.80817], [-117.06175, 32.80782], [-117.06162, 32.80749], [-117.06149, 32.8073], [-117.06136, 32.80726], [-117.06074, 32.80746], [-117.06058, 32.80726], [-117.06048, 32.80726], [-117.06044, 32.80775], [-117.06039, 32.80785], [-117.06038, 32.80802], [-117.06005, 32.80807], [-117.05985, 32.80804], [-117.05978, 32.80766], [-117.05971, 32.80757], [-117.05958, 32.8075], [-117.05944, 32.80736], [-117.05942, 32.80727], [-117.05914, 32.80713], [-117.05899, 32.80736], [-117.05905, 32.80743], [-117.05898, 32.8075], [-117.05898, 32.80758], [-117.05868, 32.80791], [-117.05845, 32.8079], [-117.05835, 32.80788], [-117.05834, 32.80779], [-117.05765, 32.80718], [-117.05753, 32.80727], [-117.0575, 32.80735], [-117.05752, 32.80763], [-117.05749, 32.80772], [-117.0575, 32.80778], [-117.05754, 32.80781], [-117.05752, 32.80794], [-117.05724, 32.80807], [-117.05728, 32.80732], [-117.05731, 32.80556], [-117.05734, 32.80518], [-117.05733, 32.80509], [-117.05736, 32.80415], [-117.05736, 32.80368], [-117.05771, 32.8038], [-117.05821, 32.80384], [-117.05862, 32.80401], [-117.05907, 32.80404], [-117.0596, 32.8039], [-117.06013, 32.80366], [-117.06022, 32.80366], [-117.06059, 32.80351], [-117.06072, 32.80337], [-117.06074, 32.80315], [-117.06054, 32.80293], [-117.06041, 32.80283], [-117.06023, 32.80279], [-117.05984, 32.80285], [-117.05965, 32.80297], [-117.05955, 32.80307], [-117.05938, 32.80319], [-117.05896, 32.80332], [-117.05883, 32.80331], [-117.05831, 32.80294], [-117.05814, 32.80286], [-117.05735, 32.80255], [-117.05733, 32.80233], [-117.05567, 32.80119], [-117.05553, 32.80109], [-117.05493, 32.80069], [-117.05453, 32.80046], [-117.05702, 32.80058], [-117.05749, 32.80057], [-117.05785, 32.80053], [-117.0583, 32.80046], [-117.05889, 32.80028], [-117.05924, 32.80015], [-117.06126, 32.79919], [-117.06172, 32.79894], [-117.06218, 32.79857], [-117.06392, 32.79693], [-117.0634, 32.79818], [-117.06288, 32.79959], [-117.06302, 32.79971], [-117.06268, 32.79998], [-117.06253, 32.80013], [-117.0624, 32.80038], [-117.06199, 32.80029], [-117.0612, 32.80098], [-117.06098, 32.80158], [-117.06126, 32.8021], [-117.06425, 32.80209], [-117.06383, 32.80252], [-117.06362, 32.80251], [-117.06349, 32.80244], [-117.06341, 32.80228], [-117.06304, 32.80243], [-117.06285, 32.80263], [-117.06258, 32.80321], [-117.06246, 32.80329], [-117.06228, 32.80372], [-117.06226, 32.80415], [-117.06253, 32.80443], [-117.06272, 32.80453], [-117.06333, 32.80443], [-117.06356, 32.80448], [-117.06374, 32.80461], [-117.06403, 32.80502], [-117.06427, 32.80512], [-117.06499, 32.8051], [-117.06515, 32.80513], [-117.06556, 32.80513], [-117.06586, 32.80515]]], [[[-117.07622, 32.8044], [-117.07569, 32.80481], [-117.07306, 32.8043], [-117.07303, 32.80447], [-117.07222, 32.80432], [-117.07198, 32.80434], [-117.07175, 32.80433], [-117.07085, 32.80441], [-117.07065, 32.80455], [-117.06991, 32.8047], [-117.06944, 32.80489], [-117.06889, 32.80523], [-117.06912, 32.80587], [-117.06796, 32.80632], [-117.0676, 32.80584], [-117.06731, 32.80619], [-117.06729, 32.80619], [-117.06693, 32.80615], [-117.06626, 32.80642], [-117.06627, 32.80687], [-117.06648, 32.80713], [-117.06621, 32.80732], [-117.06598, 32.8071], [-117.0659, 32.80698], [-117.06583, 32.80683], [-117.06579, 32.80667], [-117.0658, 32.80647], [-117.06586, 32.80624], [-117.0662, 32.80557], [-117.06626, 32.80543], [-117.06629, 32.80508], [-117.06673, 32.80493], [-117.06715, 32.80471], [-117.06768, 32.80457], [-117.06789, 32.80454], [-117.06801, 32.80443], [-117.06805, 32.80415], [-117.06812, 32.80383], [-117.06802, 32.80369], [-117.0678, 32.80368], [-117.06748, 32.80373], [-117.06739, 32.80365], [-117.06713, 32.80352], [-117.06667, 32.80342], [-117.06663, 32.80333], [-117.06675, 32.80319], [-117.06685, 32.80325], [-117.06683, 32.80317], [-117.06684, 32.80309], [-117.06687, 32.80307], [-117.06691, 32.80309], [-117.06699, 32.80298], [-117.06699, 32.80293], [-117.06702, 32.80294], [-117.0671, 32.80278], [-117.06721, 32.80266], [-117.06742, 32.80248], [-117.06731, 32.80208], [-117.06791, 32.80208], [-117.06868, 32.80211], [-117.06882, 32.80212], [-117.07038, 32.80269], [-117.07178, 32.80272], [-117.07291, 32.80324], [-117.07308, 32.80328], [-117.07329, 32.8033], [-117.07358, 32.80325], [-117.07366, 32.8035], [-117.0739, 32.80341], [-117.07425, 32.8032], [-117.07444, 32.80323], [-117.07447, 32.80356], [-117.07459, 32.80384], [-117.07481, 32.80407], [-117.07509, 32.80411], [-117.0756, 32.8043], [-117.07575, 32.80442], [-117.07603, 32.8043], [-117.07614, 32.80437], [-117.07622, 32.8044]]]]} | Open Access 1 | 103 | Rancho Mission Canyon Park and Open Space | 10506 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 236.791 | Rancho Mission Canyon Park and OS | 0 | Local Recreation Area 3 | 4 | |
15966 | 15966 | 15965 | {"type": "MultiPolygon", "coordinates": [[[[-121.86007, 36.60626], [-121.86019, 36.60641], [-121.86027, 36.60654], [-121.86032, 36.6067], [-121.86035, 36.60687], [-121.86033, 36.60703], [-121.86029, 36.60718], [-121.86022, 36.60732], [-121.86011, 36.60747], [-121.86, 36.60758], [-121.85984, 36.60769], [-121.85775, 36.60886], [-121.85761, 36.60892], [-121.85741, 36.60896], [-121.85638, 36.60792], [-121.85936, 36.60601], [-121.85978, 36.60644], [-121.86007, 36.60626]]], [[[-121.85802, 36.60942], [-121.85791, 36.6095], [-121.85784, 36.6094], [-121.85755, 36.6091], [-121.85783, 36.60901], [-121.85794, 36.60922], [-121.85802, 36.60942]]]]} | Open Access 1 | 105 | Roberts Lake Open Space | 24492 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 14.46 | Roberts Lake OS | 0 | Local Recreation Area 3 | 4 | |
15960 | 15960 | 15959 | {"type": "Polygon", "coordinates": [[[-117.10471, 32.79491], [-117.10467, 32.7985], [-117.10274, 32.80185], [-117.10402, 32.80351], [-117.10409, 32.80363], [-117.10436, 32.804], [-117.10441, 32.80428], [-117.10442, 32.80441], [-117.10441, 32.80537], [-117.10314, 32.80531], [-117.10313, 32.80532], [-117.10315, 32.80708], [-117.10314, 32.80795], [-117.10315, 32.808], [-117.10316, 32.80919], [-117.10414, 32.8092], [-117.10422, 32.81113], [-117.10193, 32.8111], [-117.10205, 32.81505], [-117.10269, 32.81506], [-117.10279, 32.81714], [-117.10052, 32.8176], [-117.1004, 32.8161], [-117.09964, 32.81602], [-117.09967, 32.81585], [-117.09967, 32.81551], [-117.10033, 32.81554], [-117.10034, 32.81552], [-117.10008, 32.81241], [-117.09986, 32.81214], [-117.09951, 32.81205], [-117.09947, 32.81235], [-117.09933, 32.81238], [-117.09929, 32.81243], [-117.09927, 32.81248], [-117.0989, 32.8124], [-117.09902, 32.81279], [-117.0989, 32.81363], [-117.09867, 32.81405], [-117.09901, 32.81439], [-117.09904, 32.81455], [-117.09888, 32.81475], [-117.09861, 32.81483], [-117.0984, 32.81502], [-117.09811, 32.81519], [-117.09807, 32.81529], [-117.09819, 32.81547], [-117.09823, 32.81565], [-117.09819, 32.81581], [-117.098, 32.81609], [-117.09776, 32.81596], [-117.09756, 32.81618], [-117.09781, 32.81637], [-117.09765, 32.81648], [-117.09733, 32.81678], [-117.09727, 32.81716], [-117.09718, 32.81733], [-117.09708, 32.81747], [-117.0974, 32.81759], [-117.09738, 32.81764], [-117.09698, 32.81762], [-117.09693, 32.81824], [-117.09609, 32.81861], [-117.09582, 32.81836], [-117.09557, 32.81819], [-117.09553, 32.81823], [-117.0953, 32.81809], [-117.095, 32.81794], [-117.09719, 32.81421], [-117.09716, 32.81236], [-117.0968, 32.81233], [-117.09688, 32.81169], [-117.09695, 32.81154], [-117.09719, 32.81122], [-117.09711, 32.81086], [-117.09719, 32.8108], [-117.09723, 32.81065], [-117.09712, 32.81042], [-117.09693, 32.81029], [-117.09697, 32.81024], [-117.09708, 32.81021], [-117.09711, 32.81009], [-117.09723, 32.80997], [-117.09745, 32.81012], [-117.09765, 32.81009], [-117.09774, 32.80998], [-117.09785, 32.80988], [-117.09801, 32.80982], [-117.09802, 32.80965], [-117.09811, 32.80951], [-117.09831, 32.80938], [-117.09839, 32.80921], [-117.09837, 32.80903], [-117.09845, 32.80891], [-117.09856, 32.80883], [-117.09867, 32.80864], [-117.09894, 32.80844], [-117.09917, 32.80814], [-117.09926, 32.80797], [-117.09932, 32.80778], [-117.0994, 32.80739], [-117.09922, 32.80716], [-117.09883, 32.80704], [-117.09847, 32.80719], [-117.09835, 32.80747], [-117.0985, 32.80773], [-117.09838, 32.80784], [-117.09817, 32.80801], [-117.09802, 32.80809], [-117.09786, 32.80819], [-117.0977, 32.80833], [-117.09763, 32.8085], [-117.09744, 32.80865], [-117.09744, 32.80881], [-117.09748, 32.80896], [-117.09744, 32.80907], [-117.09734, 32.80918], [-117.09691, 32.80957], [-117.09686, 32.80971], [-117.09708, 32.80987], [-117.09697, 32.80999], [-117.09688, 32.81002], [-117.09683, 32.81005], [-117.0968, 32.81015], [-117.09652, 32.81044], [-117.09627, 32.81027], [-117.09615, 32.81041], [-117.09596, 32.81053], [-117.09583, 32.81071], [-117.09576, 32.8109], [-117.09558, 32.81097], [-117.09513, 32.81101], [-117.09538, 32.81172], [-117.09559, 32.81187], [-117.0951, 32.812], [-117.09479, 32.81191], [-117.09405, 32.81192], [-117.09354, 32.81197], [-117.09358, 32.81096], [-117.09529, 32.80942], [-117.09592, 32.80857], [-117.09796, 32.8068], [-117.10056, 32.80525], [-117.10023, 32.80248], [-117.09938, 32.80248], [-117.09919, 32.80155], [-117.09926, 32.79946], [-117.10095, 32.79737], [-117.10471, 32.79491]]]} | Open Access 1 | 110 | Tierrasanta Open Space | 10608 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 260.674 | Tierrasanta OS | 0 | Local Recreation Area 3 | 4 | |
15967 | 15967 | 15966 | {"type": "MultiPolygon", "coordinates": [[[[-117.08618, 32.78287], [-117.08622, 32.78293], [-117.08624, 32.78303], [-117.08622, 32.78311], [-117.08617, 32.7832], [-117.08531, 32.78378], [-117.08524, 32.78389], [-117.0852, 32.78402], [-117.08519, 32.78416], [-117.08523, 32.78429], [-117.08533, 32.78443], [-117.08553, 32.78456], [-117.0856, 32.78469], [-117.08463, 32.78553], [-117.08436, 32.78592], [-117.0838, 32.78592], [-117.08272, 32.78658], [-117.08187, 32.78792], [-117.08286, 32.78773], [-117.08044, 32.79012], [-117.08043, 32.79016], [-117.08034, 32.79009], [-117.08058, 32.78985], [-117.0793, 32.78892], [-117.07776, 32.79006], [-117.07763, 32.79017], [-117.07667, 32.79085], [-117.07584, 32.79149], [-117.07542, 32.79293], [-117.07593, 32.79393], [-117.07626, 32.79416], [-117.07659, 32.79381], [-117.0766, 32.79377], [-117.07671, 32.79385], [-117.07667, 32.79385], [-117.07664, 32.79387], [-117.07561, 32.79498], [-117.07591, 32.79563], [-117.07546, 32.79607], [-117.07495, 32.7957], [-117.0747, 32.79596], [-117.07404, 32.79548], [-117.07362, 32.79414], [-117.07449, 32.79342], [-117.07448, 32.79295], [-117.07389, 32.79245], [-117.07286, 32.79331], [-117.0684, 32.79401], [-117.06839, 32.79409], [-117.06843, 32.79426], [-117.06836, 32.7943], [-117.06808, 32.79402], [-117.06769, 32.79358], [-117.0676, 32.79345], [-117.0676, 32.79336], [-117.06773, 32.79353], [-117.06781, 32.79355], [-117.06852, 32.79334], [-117.06922, 32.79322], [-117.07092, 32.79298], [-117.07154, 32.79284], [-117.07175, 32.79276], [-117.07203, 32.79268], [-117.07252, 32.79249], [-117.07267, 32.79241], [-117.07272, 32.79241], [-117.07334, 32.79207], [-117.07408, 32.79157], [-117.0754, 32.79057], [-117.07323, 32.78843], [-117.07149, 32.78856], [-117.07143, 32.7885], [-117.07022, 32.78771], [-117.06892, 32.78716], [-117.0687, 32.78701], [-117.06765, 32.78579], [-117.06757, 32.78526], [-117.06807, 32.78473], [-117.06822, 32.78539], [-117.06985, 32.78614], [-117.07023, 32.78641], [-117.07028, 32.78636], [-117.07052, 32.78646], [-117.0705, 32.78653], [-117.07139, 32.78694], [-117.07187, 32.78715], [-117.07191, 32.78709], [-117.07266, 32.78742], [-117.07402, 32.78704], [-117.07404, 32.78702], [-117.07405, 32.78729], [-117.07495, 32.78863], [-117.07732, 32.78821], [-117.07818, 32.78758], [-117.07746, 32.78678], [-117.07421, 32.78551], [-117.07432, 32.78501], [-117.07451, 32.78473], [-117.07458, 32.78465], [-117.07655, 32.78524], [-117.07826, 32.78523], [-117.07841, 32.78539], [-117.07853, 32.78555], [-117.07906, 32.78608], [-117.07925, 32.78623], [-117.0797, 32.78654], [-117.08013, 32.78577], [-117.08138, 32.78469], [-117.0837, 32.78401], [-117.08345, 32.78297], [-117.08294, 32.78299], [-117.08288, 32.78279], [-117.08293, 32.78263], [-117.08618, 32.78287]]], [[[-117.08637, 32.78311], [-117.08635, 32.78329], [-117.08601, 32.78377], [-117.08606, 32.7838], [-117.08569, 32.78433], [-117.08555, 32.78436], [-117.0855, 32.78433], [-117.08544, 32.78428], [-117.08538, 32.78415], [-117.08537, 32.78403], [-117.08542, 32.7839], [-117.08551, 32.78382], [-117.0856, 32.78377], [-117.08621, 32.78333], [-117.08632, 32.78321], [-117.08637, 32.78311]]]]} | Open Access 1 | 117 | Navajo Canyon Open Space Park | 22675 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 155.786 | Navajo Canyon OS Park | 0 | Local Recreation Area 3 | 4 | |
15962 | 15962 | 15961 | {"type": "Polygon", "coordinates": [[[-117.09619, 32.81934], [-117.09519, 32.82044], [-117.09538, 32.82111], [-117.09482, 32.82197], [-117.09476, 32.82194], [-117.09447, 32.8225], [-117.0949, 32.82303], [-117.09493, 32.82341], [-117.09402, 32.82355], [-117.09414, 32.82433], [-117.09405, 32.82458], [-117.09401, 32.82483], [-117.09407, 32.82516], [-117.09407, 32.82543], [-117.09361, 32.82557], [-117.09341, 32.82605], [-117.09341, 32.82626], [-117.09338, 32.82636], [-117.09325, 32.82656], [-117.09309, 32.82671], [-117.09247, 32.82693], [-117.09215, 32.82725], [-117.09126, 32.82766], [-117.09093, 32.82762], [-117.09033, 32.8279], [-117.08988, 32.82832], [-117.08974, 32.82856], [-117.08942, 32.8287], [-117.08934, 32.82876], [-117.08943, 32.82891], [-117.08873, 32.82909], [-117.08835, 32.82916], [-117.08781, 32.8292], [-117.08784, 32.829], [-117.08825, 32.8287], [-117.08851, 32.82803], [-117.08811, 32.82808], [-117.08804, 32.82813], [-117.08796, 32.82811], [-117.08789, 32.82813], [-117.08784, 32.82807], [-117.08758, 32.82799], [-117.0874, 32.82811], [-117.08781, 32.82822], [-117.08783, 32.8283], [-117.08753, 32.8282], [-117.0874, 32.82828], [-117.08625, 32.82781], [-117.08573, 32.82761], [-117.08509, 32.82753], [-117.08251, 32.82603], [-117.08217, 32.82586], [-117.08225, 32.82571], [-117.0823, 32.82559], [-117.08244, 32.82513], [-117.08335, 32.82549], [-117.08353, 32.82557], [-117.08387, 32.82577], [-117.08468, 32.82635], [-117.08488, 32.82647], [-117.08511, 32.82658], [-117.08557, 32.82672], [-117.08581, 32.82676], [-117.08606, 32.82677], [-117.0863, 32.82677], [-117.08626, 32.82647], [-117.08639, 32.82645], [-117.08646, 32.82675], [-117.08674, 32.82675], [-117.08691, 32.82661], [-117.08733, 32.82644], [-117.08742, 32.82636], [-117.0876, 32.82652], [-117.08827, 32.82659], [-117.08905, 32.8265], [-117.08913, 32.82636], [-117.08917, 32.82637], [-117.08926, 32.82631], [-117.08936, 32.82637], [-117.09056, 32.82588], [-117.09065, 32.82573], [-117.09031, 32.82559], [-117.09039, 32.82552], [-117.09066, 32.82555], [-117.09075, 32.8255], [-117.09033, 32.82481], [-117.09028, 32.82463], [-117.09027, 32.82447], [-117.09034, 32.82427], [-117.09044, 32.82411], [-117.09051, 32.82404], [-117.09046, 32.82396], [-117.09053, 32.82389], [-117.09097, 32.82381], [-117.0914, 32.82375], [-117.09147, 32.8238], [-117.09156, 32.82379], [-117.09163, 32.82374], [-117.09165, 32.82371], [-117.09166, 32.82367], [-117.09182, 32.82364], [-117.09189, 32.82342], [-117.09144, 32.82312], [-117.09153, 32.8231], [-117.09157, 32.82305], [-117.09158, 32.82297], [-117.09154, 32.82291], [-117.0917, 32.8227], [-117.09183, 32.82239], [-117.0918, 32.82231], [-117.09187, 32.82225], [-117.09222, 32.82231], [-117.09223, 32.82197], [-117.09189, 32.82181], [-117.0919, 32.82144], [-117.09187, 32.82139], [-117.09189, 32.82135], [-117.09189, 32.82131], [-117.09187, 32.82125], [-117.09195, 32.82122], [-117.09211, 32.82104], [-117.09215, 32.82112], [-117.09244, 32.82129], [-117.09295, 32.82129], [-117.09327, 32.82105], [-117.09328, 32.82075], [-117.09305, 32.82054], [-117.09352, 32.82024], [-117.0937, 32.82003], [-117.09371, 32.8197], [-117.09419, 32.81936], [-117.09427, 32.81923], [-117.0943, 32.81899], [-117.0942, 32.81885], [-117.09401, 32.81871], [-117.09419, 32.81842], [-117.09427, 32.81799], [-117.09455, 32.81807], [-117.09482, 32.81817], [-117.09532, 32.81843], [-117.09537, 32.81847], [-117.09556, 32.81861], [-117.09578, 32.81881], [-117.096, 32.81906], [-117.09619, 32.81934]]]} | Open Access 1 | 130 | Tierrasanta Open Space | 10608 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 93.585 | Tierrasanta OS | 0 | Local Recreation Area 3 | 4 | |
46 | 46 | 45 | {"type": "Polygon", "coordinates": [[[-117.08226, 32.82508], [-117.08219, 32.82527], [-117.08213, 32.82555], [-117.08203, 32.82574], [-117.08095, 32.8251], [-117.08087, 32.82511], [-117.08059, 32.82491], [-117.08031, 32.82482], [-117.07942, 32.82465], [-117.0796, 32.8244], [-117.08002, 32.82402], [-117.08018, 32.82416], [-117.08058, 32.82439], [-117.08226, 32.82508]]]} | Open Access 1 | 131 | Tierrasanta Open Space | 10608 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 4.081 | Tierrasanta OS | 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]);