units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
84 rows where MNG_AGENCY = 253 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15683 | 15683 | 15682 | {"type": "Polygon", "coordinates": [[[-122.14345, 37.66316], [-122.13933, 37.66252], [-122.13712, 37.66264], [-122.13435, 37.66282], [-122.13439, 37.66455], [-122.1343, 37.66465], [-122.13378, 37.66475], [-122.12773, 37.66512], [-122.12783, 37.6672], [-122.12333, 37.66749], [-122.1227, 37.66755], [-122.12201, 37.66675], [-122.1221, 37.6666], [-122.129, 37.66341], [-122.12923, 37.66336], [-122.12948, 37.66336], [-122.13113, 37.6636], [-122.1313, 37.66355], [-122.13151, 37.66338], [-122.13249, 37.66174], [-122.13262, 37.66163], [-122.13565, 37.66029], [-122.139, 37.65856], [-122.14345, 37.66316]]]} | Restricted Access 2 | 14871 | Skywest Golf Course | 33043 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 116.758 | Skywest GC | 0 | Local Recreation Area 3 | 4 | |
8997 | 8997 | 8996 | {"type": "MultiPolygon", "coordinates": [[[[-122.04337, 37.62404], [-122.0433, 37.62429], [-122.04202, 37.62518], [-122.04029, 37.62378], [-122.04286, 37.62379], [-122.0431, 37.62411], [-122.04331, 37.62396], [-122.04337, 37.62404]]], [[[-122.05058, 37.62653], [-122.04861, 37.62811], [-122.04838, 37.62793], [-122.0453, 37.62798], [-122.04225, 37.62538], [-122.04346, 37.62451], [-122.04355, 37.62461], [-122.04366, 37.6246], [-122.04449, 37.62538], [-122.04567, 37.62544], [-122.0457, 37.62672], [-122.04602, 37.62698], [-122.04659, 37.62714], [-122.04745, 37.62728], [-122.04796, 37.62732], [-122.04819, 37.62714], [-122.04814, 37.62684], [-122.04827, 37.62667], [-122.04822, 37.62471], [-122.04919, 37.62473], [-122.05058, 37.62653]]]]} | Restricted Access 2 | 14851 | Mission Hills Golf Course | 33042 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 37.311 | Mission Hills GC | 0 | Local Recreation Area 3 | 4 | |
9355 | 9355 | 9354 | {"type": "Polygon", "coordinates": [[[-122.02752, 37.6138], [-122.02891, 37.61502], [-122.02891, 37.61505], [-122.02889, 37.61508], [-122.02832, 37.61549], [-122.02815, 37.61565], [-122.02808, 37.61564], [-122.02768, 37.6154], [-122.0275, 37.61532], [-122.02734, 37.61528], [-122.02669, 37.61518], [-122.0265, 37.6151], [-122.02633, 37.61497], [-122.02598, 37.61449], [-122.02752, 37.6138]]]} | Restricted Access 2 | 15628 | El Rancho Verde School Park | 31953 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 6.904 | El Rancho Verde School Park | 0 | Local Park 2 | 4 | |
2052 | 2052 | 2051 | {"type": "Polygon", "coordinates": [[[-122.05604, 37.67111], [-122.05571, 37.6729], [-122.05568, 37.67326], [-122.05563, 37.67337], [-122.05549, 37.67348], [-122.05533, 37.67354], [-122.05428, 37.67355], [-122.05406, 37.67328], [-122.0545, 37.67093], [-122.05604, 37.67111]]]} | Restricted Access 2 | 15627 | East Avenue School Park | 31952 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 9.509 | East Avenue School Park | 0 | Local Park 2 | 4 | |
9354 | 9354 | 9353 | {"type": "Polygon", "coordinates": [[[-122.11964, 37.68374], [-122.11922, 37.684], [-122.11911, 37.68404], [-122.1168, 37.6842], [-122.11595, 37.68321], [-122.11628, 37.683], [-122.11617, 37.68289], [-122.11753, 37.6819], [-122.11964, 37.68374]]]} | Restricted Access 2 | 15626 | Colonial Acres School Park | 31951 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 11.662 | Colonial Acres School Park | 0 | Local Park 2 | 4 | |
9350 | 9350 | 9349 | {"type": "Polygon", "coordinates": [[[-122.10242, 37.62927], [-122.10248, 37.6293], [-122.10346, 37.63089], [-122.10346, 37.63092], [-122.10342, 37.63095], [-122.10209, 37.63146], [-122.10118, 37.63149], [-122.10113, 37.62978], [-122.10242, 37.62927]]]} | Restricted Access 2 | 15620 | Brenkwitz School Park | 31949 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 8.677 | Brenkwitz School Park | 0 | Local Park 2 | 4 | |
16674 | 16674 | 16673 | {"type": "Polygon", "coordinates": [[[-122.09024, 37.7077], [-122.09056, 37.70869], [-122.09056, 37.70876], [-122.09053, 37.70884], [-122.09047, 37.7089], [-122.09041, 37.70893], [-122.08948, 37.7092], [-122.08932, 37.70928], [-122.08916, 37.70941], [-122.08905, 37.70954], [-122.08872, 37.71015], [-122.08861, 37.71021], [-122.08829, 37.71021], [-122.08815, 37.70889], [-122.088, 37.70839], [-122.08802, 37.70711], [-122.08886, 37.70713], [-122.08902, 37.70785], [-122.09024, 37.7077]]]} | Open Access 1 | 15165 | Castro Valley Park and Community Center | 31506 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 11.132 | Castro Valley Park and Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
1518 | 1518 | 1517 | {"type": "Polygon", "coordinates": [[[-122.08221, 37.69769], [-122.08102, 37.69769], [-122.08099, 37.69634], [-122.08217, 37.69632], [-122.08221, 37.69769]]]} | Open Access 1 | 47719 | Adobe Park | 31505 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/facilities/facility/details/Adobe-Park-116 | Alameda 17 | 3.894 | Adobe Park | 0 | Local Park 2 | 4 |
7823 | 7823 | 7822 | {"type": "Polygon", "coordinates": [[[-122.10017, 37.70619], [-122.09895, 37.70702], [-122.09936, 37.70782], [-122.09996, 37.70839], [-122.09962, 37.70842], [-122.0991, 37.70793], [-122.09862, 37.70791], [-122.09776, 37.70819], [-122.09758, 37.70803], [-122.09663, 37.70834], [-122.09654, 37.70826], [-122.09747, 37.70794], [-122.09748, 37.7079], [-122.09732, 37.70767], [-122.09679, 37.70718], [-122.09576, 37.70752], [-122.09571, 37.70748], [-122.09674, 37.70713], [-122.09579, 37.70625], [-122.09476, 37.70659], [-122.09461, 37.70645], [-122.09579, 37.70606], [-122.09484, 37.70517], [-122.09579, 37.70486], [-122.09591, 37.70496], [-122.09601, 37.70489], [-122.09606, 37.70451], [-122.09619, 37.7045], [-122.0963, 37.70448], [-122.09641, 37.70443], [-122.09652, 37.70436], [-122.09684, 37.70466], [-122.09724, 37.70491], [-122.09757, 37.70522], [-122.09777, 37.7051], [-122.09866, 37.70591], [-122.09903, 37.70567], [-122.09925, 37.70555], [-122.09963, 37.70589], [-122.09971, 37.70584], [-122.10017, 37.70619]]]} | Open Access 1 | 47707 | Valley View Park | 31456 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/605/Valley-View-Park---Former-EBMUD-Property | Alameda 17 | 24.129 | Valley View Park | 0 | Local Park 2 | 4 |
7838 | 7838 | 7837 | {"type": "Polygon", "coordinates": [[[-122.11632, 37.69538], [-122.11631, 37.69594], [-122.11596, 37.69624], [-122.11544, 37.69587], [-122.11561, 37.69571], [-122.1157, 37.69577], [-122.11618, 37.69535], [-122.11623, 37.69538], [-122.11632, 37.69538]]]} | Open Access 1 | 47706 | Jack Holland Sr. Park | 31455 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/Facilities/Facility/Details/Jack-Holland-Sr-Park-129 | Alameda 17 | 1.0 | Jack Holland Sr. Park | 0 | Local Park 2 | 4 |
7837 | 7837 | 7836 | {"type": "Polygon", "coordinates": [[[-122.03138, 37.67539], [-122.03177, 37.67601], [-122.03184, 37.67616], [-122.03207, 37.67648], [-122.03214, 37.67663], [-122.03216, 37.67677], [-122.0321, 37.67712], [-122.0312, 37.67848], [-122.03059, 37.67809], [-122.03035, 37.67797], [-122.03, 37.67773], [-122.02986, 37.67762], [-122.02967, 37.67737], [-122.02951, 37.67703], [-122.02949, 37.67667], [-122.02955, 37.6764], [-122.02964, 37.67619], [-122.02975, 37.676], [-122.03016, 37.67566], [-122.03045, 37.67553], [-122.03072, 37.67544], [-122.03097, 37.6754], [-122.03138, 37.67539]]]} | Open Access 1 | 47705 | Five Canyons Park | 31454 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/Facilities/Facility/Details/Five-Canyons-Park-127 | Alameda 17 | 13.452 | Five Canyons Park | 0 | Local Park 2 | 4 |
11574 | 11574 | 11573 | {"type": "Polygon", "coordinates": [[[-122.13867, 37.66915], [-122.13747, 37.66972], [-122.13761, 37.66993], [-122.13728, 37.66988], [-122.137, 37.66991], [-122.13688, 37.66873], [-122.13674, 37.66695], [-122.13846, 37.66685], [-122.13867, 37.66915]]]} | Open Access 1 | 23668 | Del Rey Park | 31452 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/Facilities/Facility/Details/Del-Rey-Park-42 | Alameda 17 | 11.244 | Del Rey Park | 0 | Local Park 2 | 4 |
8987 | 8987 | 8986 | {"type": "Polygon", "coordinates": [[[-122.09567, 37.62037], [-122.09565, 37.62062], [-122.09561, 37.62089], [-122.09467, 37.62085], [-122.09433, 37.62076], [-122.09392, 37.62056], [-122.09321, 37.62], [-122.09278, 37.61977], [-122.09277, 37.61937], [-122.09283, 37.61933], [-122.09308, 37.61934], [-122.09332, 37.61941], [-122.09398, 37.6198], [-122.09428, 37.62011], [-122.0945, 37.62021], [-122.09478, 37.62027], [-122.09558, 37.62033], [-122.09567, 37.62037]]]} | Open Access 1 | 14865 | Christian Penke Park | 31451 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 4.375 | Christian Penke Park | 0 | Local Park 2 | 4 | |
7836 | 7836 | 7835 | {"type": "Polygon", "coordinates": [[[-122.07255, 37.69448], [-122.07245, 37.69479], [-122.07246, 37.69486], [-122.07249, 37.69495], [-122.07248, 37.69502], [-122.07212, 37.6949], [-122.07228, 37.69459], [-122.07203, 37.6945], [-122.07231, 37.69398], [-122.0723, 37.69395], [-122.07227, 37.69395], [-122.07224, 37.69382], [-122.07182, 37.69362], [-122.07168, 37.69362], [-122.07161, 37.69348], [-122.0716, 37.69294], [-122.07155, 37.69271], [-122.0719, 37.6927], [-122.0719, 37.69293], [-122.07177, 37.69294], [-122.07182, 37.69357], [-122.07188, 37.69362], [-122.07198, 37.69362], [-122.07226, 37.69375], [-122.07231, 37.69386], [-122.0724, 37.69394], [-122.07245, 37.69423], [-122.07255, 37.69448]]]} | Open Access 1 | 47704 | Castro Valley Creek Park | 31450 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.308 | Castro Valley Creek Park | 0 | Local Park 2 | 4 | |
7835 | 7835 | 7834 | {"type": "Polygon", "coordinates": [[[-122.05746, 37.62338], [-122.05725, 37.62354], [-122.05718, 37.62354], [-122.05709, 37.62357], [-122.05704, 37.62365], [-122.0566, 37.62401], [-122.05605, 37.62357], [-122.0562, 37.62344], [-122.0556, 37.62297], [-122.05627, 37.62243], [-122.05718, 37.62315], [-122.05716, 37.62319], [-122.05736, 37.62334], [-122.05739, 37.62332], [-122.05746, 37.62338]]]} | Open Access 1 | 47703 | Silver Star Veterans Park | 31448 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.309 | Silver Star Veterans Park | 0 | Local Park 2 | 4 | |
7808 | 7808 | 7807 | {"type": "Polygon", "coordinates": [[[-122.0655, 37.67733], [-122.06488, 37.67742], [-122.06498, 37.67783], [-122.06458, 37.67789], [-122.06446, 37.67744], [-122.06407, 37.6775], [-122.06404, 37.67737], [-122.06336, 37.67748], [-122.06331, 37.67739], [-122.0627, 37.67759], [-122.06249, 37.67715], [-122.06307, 37.67685], [-122.06254, 37.67654], [-122.06226, 37.67652], [-122.06223, 37.67661], [-122.06162, 37.67652], [-122.06173, 37.67596], [-122.06198, 37.67596], [-122.06258, 37.67576], [-122.06269, 37.67574], [-122.06267, 37.67587], [-122.06301, 37.67588], [-122.06307, 37.6756], [-122.0631, 37.6756], [-122.06306, 37.67588], [-122.0634, 37.67589], [-122.06339, 37.67602], [-122.06462, 37.6759], [-122.06448, 37.67664], [-122.06455, 37.67667], [-122.06479, 37.67682], [-122.06493, 37.67683], [-122.06502, 37.67689], [-122.06518, 37.6769], [-122.06539, 37.67687], [-122.0655, 37.67733]]]} | Open Access 1 | 47701 | Sulphur Creek Nature Center | 31437 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 10.148 | Sulphur Creek Nature Ctr. | 0 | Local Park 2 | 4 | |
1435 | 1435 | 1434 | {"type": "Polygon", "coordinates": [[[-122.13981, 37.67822], [-122.13977, 37.67831], [-122.13782, 37.6791], [-122.13753, 37.67864], [-122.13699, 37.67886], [-122.13613, 37.67751], [-122.13869, 37.67647], [-122.13981, 37.67822]]]} | Open Access 1 | 47700 | Mervin Morris Park | 31436 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 13.34 | Mervin Morris Park | 0 | Local Park 2 | 4 | |
1434 | 1434 | 1433 | {"type": "Polygon", "coordinates": [[[-122.0272, 37.65621], [-122.02609, 37.65763], [-122.02388, 37.65638], [-122.02421, 37.65615], [-122.02448, 37.65581], [-122.02462, 37.65538], [-122.02478, 37.655], [-122.02503, 37.65468], [-122.02527, 37.65453], [-122.0272, 37.65621]]]} | Open Access 1 | 47699 | J.A. Lewis Park | 31435 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 12.57 | J.A. Lewis Park | 0 | Local Park 2 | 4 | |
6459 | 6459 | 6458 | {"type": "Polygon", "coordinates": [[[-122.07934, 37.6359], [-122.07868, 37.63596], [-122.07811, 37.63594], [-122.07765, 37.63578], [-122.07731, 37.63541], [-122.07665, 37.63442], [-122.07597, 37.63349], [-122.07584, 37.63306], [-122.07927, 37.63317], [-122.07934, 37.6359]]]} | Open Access 1 | 1996 | Weekes Park | 27330 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 17.561 | Weekes Park | 0 | Local Park 2 | 4 | |
1914 | 1914 | 1913 | {"type": "Polygon", "coordinates": [[[-122.05238, 37.63238], [-122.05203, 37.63263], [-122.05126, 37.63194], [-122.05159, 37.63169], [-122.05238, 37.63238]]]} | Open Access 1 | 14805 | Valle Vista Park | 26774 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.045 | Valle Vista 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]);