units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
991 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 4 sorted by YR_EST
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
576 | 576 | 575 | {"type": "Polygon", "coordinates": [[[-122.14526, 37.74311], [-122.14524, 37.74315], [-122.14492, 37.74341], [-122.14434, 37.74398], [-122.14423, 37.74406], [-122.1437, 37.7433], [-122.14342, 37.74306], [-122.14482, 37.7425], [-122.14526, 37.74311]]]} | Open Access 1 | 3448 | Poaks Headquarters | 23819 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.419 | Poaks Headquarters | None 57 | |||
587 | 587 | 586 | {"type": "Polygon", "coordinates": [[[-119.01482, 34.20968], [-119.01465, 34.21039], [-119.01452, 34.21114], [-119.01418, 34.21111], [-119.014, 34.21118], [-119.01319, 34.21098], [-119.01318, 34.21095], [-119.01357, 34.20947], [-119.01362, 34.20945], [-119.01422, 34.20959], [-119.01433, 34.20959], [-119.01441, 34.20956], [-119.01445, 34.20961], [-119.01482, 34.20968]]]} | Open Access 1 | 1987 | Woodside Park - PVRPD | 27744 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 5.147 | Woodside Park - PVRPD | None 58 | |||
1549 | 1549 | 1548 | {"type": "Polygon", "coordinates": [[[-122.2434, 38.10352], [-122.24337, 38.10447], [-122.24248, 38.10446], [-122.24233, 38.1044], [-122.24153, 38.10439], [-122.24156, 38.10395], [-122.24157, 38.10349], [-122.24254, 38.10351], [-122.2434, 38.10352]]]} | Open Access 1 | 11545 | Children's Wonderland | 17196 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=Childrens_Wonderland | Solano 26 | 4.081 | Children's Wonderland | None 122 | ||
2001 | 2001 | 2000 | {"type": "Polygon", "coordinates": [[[-119.476, 35.13679], [-119.47598, 35.13817], [-119.4743, 35.13818], [-119.4743, 35.1368], [-119.476, 35.13679]]]} | Open Access 1 | 15314 | Taft Heights Park (A Street Park) | 26164 | 2178 | West Side Recreation and Park District 467 | Special District 4 | Recreation/Parks District 4 | http://www.wsrpd.com/ | Special District 4 | 2178 | West Side Recreation and Park District 460 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 5.82 | Taft Heights Park (A Street Park) | None 159 | |||
2356 | 2356 | 2355 | {"type": "Polygon", "coordinates": [[[-121.7508, 38.02106], [-121.7506, 38.02106], [-121.75061, 38.02096], [-121.75065, 38.02095], [-121.75065, 38.01964], [-121.75066, 38.01963], [-121.75067, 38.01953], [-121.75076, 38.01953], [-121.75075, 38.02095], [-121.7508, 38.02096], [-121.7508, 38.02106]]]} | Open Access 1 | 17112 | Antioch Bridge Fishing Pier | 15522 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 0.397 | Antioch Bridge Fishing Pier | None 198 | |||
2628 | 2628 | 2627 | {"type": "Polygon", "coordinates": [[[-118.84231, 34.19564], [-118.84227, 34.19647], [-118.84184, 34.19646], [-118.84183, 34.19631], [-118.84174, 34.19621], [-118.84159, 34.1962], [-118.8415, 34.1963], [-118.84159, 34.19645], [-118.84038, 34.19642], [-118.84035, 34.1963], [-118.84001, 34.19634], [-118.83995, 34.196], [-118.84002, 34.19568], [-118.84038, 34.1958], [-118.84116, 34.19567], [-118.84155, 34.19567], [-118.84231, 34.19564]]]} | Open Access 1 | 18025 | Morrow Circle | 22506 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 4.053 | Morrow Circle | None 215 | |||
2699 | 2699 | 2698 | {"type": "Polygon", "coordinates": [[[-118.84721, 34.20202], [-118.8472, 34.20254], [-118.84648, 34.20252], [-118.846, 34.20241], [-118.84562, 34.20243], [-118.84515, 34.20253], [-118.84479, 34.20234], [-118.84429, 34.20217], [-118.84721, 34.20202]]]} | Open Access 1 | 18273 | Old Meadows FC | 23089 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 2.511 | Old Meadows FC | None 221 | |||
3351 | 3351 | 3350 | {"type": "Polygon", "coordinates": [[[-121.63593, 39.77761], [-121.63218, 39.77763], [-121.63219, 39.77495], [-121.63309, 39.77382], [-121.63173, 39.7738], [-121.63278, 39.77294], [-121.63294, 39.77294], [-121.63295, 39.7728], [-121.63365, 39.77224], [-121.63365, 39.77252], [-121.63359, 39.77253], [-121.63359, 39.77266], [-121.63317, 39.77267], [-121.63316, 39.77272], [-121.63305, 39.77273], [-121.63306, 39.77308], [-121.63589, 39.77309], [-121.63593, 39.77761]]]} | Open Access 1 | 24231 | Bill Park Expansion | 16108 | 2250 | Paradise Recreation and Park District 580 | Special District 4 | Recreation/Parks District 4 | http://www.paradiseprpd.com/ | Special District 4 | 2250 | Paradise Recreation and Park District 572 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 38.925 | Bill Park Expansion | None 273 | |||
3363 | 3363 | 3362 | {"type": "Polygon", "coordinates": [[[-120.1891, 39.3279], [-120.18813, 39.32838], [-120.18792, 39.32815], [-120.1889, 39.32764], [-120.1891, 39.3279]]]} | Open Access 1 | 24338 | Veterans Hall | 27021 | 2263 | Truckee-Donner Recreation and Park District 576 | Special District 4 | Recreation/Parks District 4 | http://www.tdrpd.com/ | Special District 4 | 2263 | Truckee-Donner Recreation and Park District 568 | Special District 4 | Recreation/Parks District 4 | Nevada 30 | 0.806 | Veterans Hall | None 274 | |||
3366 | 3366 | 3365 | {"type": "Polygon", "coordinates": [[[-123.02007, 38.4736], [-123.01905, 38.47432], [-123.01973, 38.47494], [-123.019, 38.4755], [-123.01754, 38.47486], [-123.01736, 38.47459], [-123.01653, 38.47281], [-123.0177, 38.47143], [-123.01778, 38.47153], [-123.02007, 38.4736]]]} | Open Access 1 | 24315 | Monte Rio Riverfront Meadow | 22391 | 2241 | Monte Rio Recreation and Park District 573 | Special District 4 | Recreation/Parks District 4 | http://www.mrrpd.org/ | Special District 4 | 2241 | Monte Rio Recreation and Park District 565 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 18.497 | Monte Rio Riverfront Meadow | None 275 | |||
3380 | 3380 | 3379 | {"type": "Polygon", "coordinates": [[[-122.95918, 38.42482], [-122.95872, 38.42509], [-122.95812, 38.42505], [-122.95782, 38.42498], [-122.95732, 38.42481], [-122.95714, 38.42469], [-122.95699, 38.42452], [-122.95772, 38.4242], [-122.95796, 38.42427], [-122.9584, 38.42451], [-122.95894, 38.42475], [-122.95918, 38.42482]]]} | Open Access 1 | 34933 | Camp Meeker | 16776 | 2294 | Camp Meeker Recreation and Parks District 632 | Special District 4 | Recreation/Parks District 4 | http://www.campmeeker.org/ | Special District 4 | 2294 | Camp Meeker Recreation and Parks District 621 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 2.494 | Camp Meeker | None 278 | |||
3817 | 3817 | 3816 | {"type": "Polygon", "coordinates": [[[-121.80256, 36.69071], [-121.80064, 36.68954], [-121.8013, 36.68878], [-121.8017, 36.68905], [-121.80185, 36.68917], [-121.80204, 36.68937], [-121.80221, 36.68959], [-121.80238, 36.6899], [-121.80249, 36.69019], [-121.80254, 36.69043], [-121.80256, 36.69071]]]} | Open Access 1 | 35194 | Monterey Peninsula Regional Park District 4 | 22427 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.919 | Monterey Peninsula RP District 4 | None 320 | |||
3987 | 3987 | 3986 | {"type": "Polygon", "coordinates": [[[-122.5132, 37.88901], [-122.51299, 37.88939], [-122.51302, 37.88987], [-122.51291, 37.88971], [-122.51269, 37.88951], [-122.51256, 37.88942], [-122.512, 37.88912], [-122.51221, 37.88897], [-122.51227, 37.88891], [-122.51227, 37.88889], [-122.51201, 37.88879], [-122.51114, 37.88826], [-122.51091, 37.88816], [-122.51077, 37.88816], [-122.51062, 37.88833], [-122.51058, 37.88831], [-122.51101, 37.88781], [-122.51272, 37.88864], [-122.51295, 37.88848], [-122.5132, 37.88901]]]} | Open Access 1 | 38041 | Strawberry Cove Park/Belloc Lagoon | 25913 | 2162 | Strawberry Recreation District 662 | Special District 4 | Recreation/Parks District 4 | http://strawberry.marin.org/ | Special District 4 | 2162 | Strawberry Recreation District 650 | Special District 4 | Recreation/Parks District 4 | Marin 23 | 3.478 | Strawberry Cove Park/Belloc Lagoon | None 346 | |||
4182 | 4182 | 4181 | {"type": "Polygon", "coordinates": [[[-122.33713, 37.91103], [-122.3302, 37.90951], [-122.33019, 37.90937], [-122.32739, 37.90874], [-122.32609, 37.90838], [-122.32557, 37.9082], [-122.32557, 37.90811], [-122.32475, 37.9078], [-122.32454, 37.90774], [-122.32432, 37.90764], [-122.32317, 37.90701], [-122.32242, 37.90652], [-122.32205, 37.90627], [-122.32145, 37.90584], [-122.32094, 37.9054], [-122.32039, 37.90483], [-122.32022, 37.90468], [-122.31956, 37.90396], [-122.3163, 37.8999], [-122.31655, 37.89982], [-122.31658, 37.89984], [-122.31926, 37.90317], [-122.32457, 37.90051], [-122.32268, 37.89818], [-122.32347, 37.89776], [-122.32425, 37.89827], [-122.32452, 37.89851], [-122.32468, 37.89872], [-122.32478, 37.89891], [-122.32485, 37.89914], [-122.32487, 37.89938], [-122.32522, 37.89938], [-122.32522, 37.9011], [-122.32128, 37.90308], [-122.31988, 37.9038], [-122.3203, 37.90434], [-122.32088, 37.90498], [-122.32125, 37.90533], [-122.32159, 37.90561], [-122.32212, 37.90606], [-122.32235, 37.90632], [-122.3228, 37.9066], [-122.32313, 37.90684], [-122.3235, 37.90705], [-122.32458, 37.9076], [-122.32579, 37.90809], [-122.32594, 37.90814], [-122.3261, 37.90816], [-122.32745, 37.90855], [-122.3325, 37.90968], [-122.33251, 37.90967], [-122.33251, 37.90946], [-122.33711, 37.91047], [-122.33713, 37.91103]]]} | Open Access 1 | 3447 | Point Isabel | 23851 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 37.437 | Point Isabel | None 363 | |||
4304 | 4304 | 4303 | {"type": "Polygon", "coordinates": [[[-118.43677, 35.11513], [-118.43674, 35.11696], [-118.4324, 35.11697], [-118.43243, 35.11515], [-118.43677, 35.11513]]]} | Open Access 1 | 45342 | Morris Park (Proposed) | 22495 | 2164 | Tehachapi Valley Recreation and Parks District 743 | Special District 4 | Recreation/Parks District 4 | http://www.tvrpd.org/ | Special District 4 | 2164 | Tehachapi Valley Recreation and Parks District 723 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 19.824 | Morris Park (Proposed) | None 379 | |||
4374 | 4374 | 4373 | {"type": "Polygon", "coordinates": [[[-121.44728, 38.68325], [-121.44665, 38.68325], [-121.44664, 38.68384], [-121.44643, 38.68383], [-121.44643, 38.68325], [-121.444, 38.68323], [-121.44594, 38.6815], [-121.44594, 38.68149], [-121.44573, 38.68135], [-121.44599, 38.68134], [-121.44618, 38.68069], [-121.44629, 38.68061], [-121.44728, 38.68062], [-121.44728, 38.68325]]]} | Open Access 1 | 48538 | Central Park & Horse Arena | 33257 | 2187 | Solano Tri-City and County Cooperative Planning Group 74 | Special District 4 | Open Space District 6 | Special District 4 | 2190 | Rio Linda Elverta Recreation and Park District 539 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 12.526 | Central Park & Horse Arena | None 388 | ||||
5344 | 5344 | 5343 | {"type": "Polygon", "coordinates": [[[-119.0427, 34.22709], [-119.04183, 34.2271], [-119.04183, 34.22684], [-119.04176, 34.22677], [-119.04181, 34.22671], [-119.04183, 34.22664], [-119.04181, 34.22643], [-119.04185, 34.22641], [-119.04264, 34.2264], [-119.04267, 34.22641], [-119.04269, 34.22646], [-119.0427, 34.22709]]]} | Open Access 1 | 17313 | Laurelwood Park - PVRPD | 21108 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 1.519 | Laurelwood Park - PVRPD | None 435 | |||
5595 | 5595 | 5594 | {"type": "Polygon", "coordinates": [[[-122.67989, 38.01119], [-122.67917, 38.01172], [-122.67866, 38.01125], [-122.67834, 38.0111], [-122.67789, 38.01155], [-122.67781, 38.01151], [-122.67759, 38.0116], [-122.6775, 38.01158], [-122.67804, 38.01093], [-122.67802, 38.01091], [-122.67746, 38.01158], [-122.67721, 38.01154], [-122.67715, 38.01146], [-122.67712, 38.01129], [-122.67698, 38.01116], [-122.67682, 38.01108], [-122.67658, 38.01112], [-122.67633, 38.01098], [-122.67708, 38.01016], [-122.67707, 38.01013], [-122.67689, 38.01032], [-122.67671, 38.01022], [-122.6766, 38.01031], [-122.67646, 38.01025], [-122.67635, 38.01038], [-122.67667, 38.01056], [-122.6763, 38.01097], [-122.67603, 38.01083], [-122.67581, 38.01075], [-122.6755, 38.01072], [-122.67509, 38.01072], [-122.67479, 38.01068], [-122.67475, 38.01057], [-122.67477, 38.0104], [-122.67475, 38.01007], [-122.67474, 38.00882], [-122.67655, 38.00789], [-122.67989, 38.01119]]]} | Open Access 1 | 35115 | San Geronimo Ridge Acq | 24901 | 2070 | Marin County Open Space District 44 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | Marin 23 | 25.019 | San Geronimo Ridge Acq | None 450 | |||
5831 | 5831 | 5830 | {"type": "Polygon", "coordinates": [[[-118.82888, 34.17163], [-118.82877, 34.17168], [-118.82845, 34.17117], [-118.82836, 34.1712], [-118.82832, 34.17114], [-118.82839, 34.17108], [-118.82805, 34.17055], [-118.82796, 34.17057], [-118.82791, 34.1705], [-118.828, 34.17046], [-118.82762, 34.16987], [-118.82753, 34.16991], [-118.82743, 34.1698], [-118.82731, 34.1698], [-118.82721, 34.16991], [-118.82716, 34.17], [-118.82701, 34.17006], [-118.82681, 34.17009], [-118.82654, 34.16999], [-118.82545, 34.16942], [-118.8285, 34.16806], [-118.82846, 34.16898], [-118.82843, 34.16933], [-118.82829, 34.1695], [-118.82809, 34.16959], [-118.8279, 34.16955], [-118.82778, 34.16961], [-118.82776, 34.16969], [-118.82779, 34.16976], [-118.82773, 34.16983], [-118.8281, 34.17041], [-118.82819, 34.17039], [-118.82824, 34.17045], [-118.82816, 34.1705], [-118.8285, 34.17104], [-118.82859, 34.17102], [-118.82866, 34.17109], [-118.82856, 34.17112], [-118.82855, 34.17113], [-118.82888, 34.17163]]]} | Open Access 1 | 219 | Russell Park - CRPD | 24741 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 8.455 | Russell Park - CRPD | None 467 | |||
5856 | 5856 | 5855 | {"type": "Polygon", "coordinates": [[[-122.24593, 38.05452], [-122.24554, 38.05454], [-122.24552, 38.05423], [-122.24559, 38.05422], [-122.24557, 38.05413], [-122.24515, 38.05393], [-122.24465, 38.05396], [-122.24446, 38.05402], [-122.24428, 38.05419], [-122.24387, 38.05422], [-122.24323, 38.05398], [-122.24247, 38.05407], [-122.24266, 38.05471], [-122.24243, 38.05478], [-122.24254, 38.05538], [-122.24273, 38.05569], [-122.24261, 38.05587], [-122.24169, 38.05597], [-122.24148, 38.05639], [-122.23999, 38.05634], [-122.23998, 38.05584], [-122.24021, 38.05586], [-122.24054, 38.05585], [-122.24087, 38.05578], [-122.24117, 38.05566], [-122.24143, 38.0555], [-122.24155, 38.0554], [-122.24226, 38.05455], [-122.24195, 38.0544], [-122.24182, 38.05437], [-122.24148, 38.05361], [-122.24141, 38.05342], [-122.24136, 38.05321], [-122.24134, 38.05301], [-122.24135, 38.0528], [-122.24141, 38.05251], [-122.24376, 38.05319], [-122.24396, 38.05373], [-122.24385, 38.05392], [-122.24393, 38.05396], [-122.24423, 38.05395], [-122.24431, 38.05384], [-122.24459, 38.05375], [-122.24532, 38.05371], [-122.24583, 38.05396], [-122.24584, 38.05419], [-122.24593, 38.05421], [-122.24593, 38.05452]]]} | Open Access 1 | 242 | Rodeo Grounds | 24549 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 14.364 | Rodeo Grounds | None 469 |
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]);