units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AG_TYP = 8 sorted by map
This data as json, copyable, CSV (advanced)
DES_TP 8
- Local Park 5
- Local Other or Unknown 3
- Local Recreation Area 2
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AGENCY 2
MNG_AG_TYP 1
- County Agency - Other · 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12094 | 12094 | 12093 | {"type": "Polygon", "coordinates": [[[-121.95664, 38.0308], [-121.95557, 38.03164], [-121.95456, 38.03083], [-121.95562, 38.03], [-121.95664, 38.0308]]]} | Open Access 1 | 24917 | Lynbrook Park | 21606 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.143 | Lynbrook Park | 0 | Local Park 2 | 4 | |
13163 | 13163 | 13162 | {"type": "Polygon", "coordinates": [[[-122.00274, 37.90517], [-122.00231, 37.90516], [-122.00213, 37.90513], [-122.00195, 37.90508], [-122.0017, 37.90499], [-121.99863, 37.90492], [-121.9986, 37.90475], [-121.99682, 37.90477], [-121.99628, 37.90372], [-121.994, 37.90374], [-121.99403, 37.90335], [-121.99401, 37.90309], [-121.99395, 37.90283], [-121.99387, 37.90259], [-121.99375, 37.90235], [-121.9936, 37.90213], [-121.99346, 37.90195], [-121.99811, 37.90237], [-121.99812, 37.90236], [-121.99811, 37.90229], [-122.00015, 37.90249], [-122.0002, 37.90249], [-122.0002, 37.90255], [-122.00096, 37.90262], [-122.00103, 37.90334], [-122.00094, 37.90336], [-122.00101, 37.90354], [-122.00107, 37.90407], [-122.00116, 37.90431], [-122.00123, 37.90442], [-122.00141, 37.90462], [-122.00151, 37.90471], [-122.00176, 37.90486], [-122.0019, 37.90492], [-122.00219, 37.905], [-122.00235, 37.90503], [-122.00268, 37.90503], [-122.00274, 37.90517]]]} | No Public Access 3 | 35113 | Mount Diablo Gateway | 28139 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 38.137 | Mount Diablo Gateway | None 1142 | |||
12092 | 12092 | 12091 | {"type": "Polygon", "coordinates": [[[-122.02017, 37.86622], [-122.02016, 37.86639], [-122.01993, 37.86641], [-122.01969, 37.86648], [-122.01952, 37.86657], [-122.01934, 37.86672], [-122.0192, 37.86692], [-122.01905, 37.86733], [-122.01897, 37.86749], [-122.01882, 37.86767], [-122.01862, 37.86783], [-122.01852, 37.86783], [-122.01826, 37.8676], [-122.01798, 37.86742], [-122.01815, 37.86697], [-122.01795, 37.86683], [-122.0179, 37.86666], [-122.01792, 37.86629], [-122.01939, 37.86633], [-122.01944, 37.86632], [-122.0195, 37.86629], [-122.01953, 37.86625], [-122.01954, 37.8662], [-122.02017, 37.86622]]]} | Open Access 1 | 24911 | Livorna Park | 21386 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.387 | Livorna Park | 0 | Local Park 2 | 4 | |
7784 | 7784 | 7783 | {"type": "Polygon", "coordinates": [[[-122.09793, 38.0339], [-122.09769, 38.03914], [-122.09158, 38.04066], [-122.09096, 38.03986], [-122.08905, 38.03774], [-122.08812, 38.03657], [-122.08732, 38.03561], [-122.08642, 38.03459], [-122.08564, 38.03378], [-122.08448, 38.0328], [-122.08348, 38.03204], [-122.08255, 38.03143], [-122.09011, 38.02928], [-122.09118, 38.03176], [-122.09429, 38.0309], [-122.09428, 38.03188], [-122.09338, 38.03401], [-122.09417, 38.03471], [-122.09447, 38.03495], [-122.09577, 38.03467], [-122.09706, 38.03377], [-122.09793, 38.0339]]]} | Restricted Access 2 | 8772 | Point Edith Wetlands | 23847 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 211.368 | Point Edith Wetlands | 2001 | Local Conservation Area 4 | 2 | |
5923 | 5923 | 5922 | {"type": "Polygon", "coordinates": [[[-122.1385, 37.48163], [-122.13828, 37.48212], [-122.13754, 37.48296], [-122.13725, 37.48334], [-122.13641, 37.48427], [-122.13358, 37.48639], [-122.13244, 37.48637], [-122.12668, 37.4898], [-122.12636, 37.48978], [-122.12589, 37.4898], [-122.1259, 37.48918], [-122.12601, 37.48639], [-122.12719, 37.48574], [-122.12827, 37.48519], [-122.13007, 37.48435], [-122.1312, 37.48388], [-122.13088, 37.48337], [-122.13108, 37.4829], [-122.13274, 37.48232], [-122.13331, 37.48262], [-122.1338, 37.48271], [-122.13422, 37.48259], [-122.13498, 37.48243], [-122.13544, 37.48231], [-122.13605, 37.48227], [-122.13669, 37.48211], [-122.13741, 37.48183], [-122.1385, 37.48163]]]} | Restricted Access 2 | 455 | San Mateo Properties | 24954 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 94.811 | San Mateo Properties | 1930 | Local Other or Unknown 14 | 4 | |
9091 | 9091 | 9090 | {"type": "Polygon", "coordinates": [[[-122.21997, 38.05377], [-122.21956, 38.05348], [-122.21836, 38.05306], [-122.21781, 38.05289], [-122.21792, 38.05262], [-122.2194, 38.05234], [-122.21949, 38.05202], [-122.21938, 38.05173], [-122.21992, 38.05179], [-122.21998, 38.05209], [-122.22007, 38.05311], [-122.22003, 38.05357], [-122.21997, 38.05377]]]} | Open Access 1 | 15057 | Crockett | 17826 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 5.153 | Crockett | None 753 | |||
12095 | 12095 | 12094 | {"type": "Polygon", "coordinates": [[[-122.2701, 38.03192], [-122.26926, 38.03205], [-122.2692, 38.03185], [-122.26868, 38.03192], [-122.26872, 38.03213], [-122.26707, 38.03237], [-122.26663, 38.03052], [-122.26966, 38.03007], [-122.2701, 38.03192]]]} | Open Access 1 | 24918 | Lefty Gomez Ballfield Complex | 21138 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 13.708 | Lefty Gomez Ballfield Complex | 0 | Local Recreation Area 3 | 4 | |
3257 | 3257 | 3256 | {"type": "Polygon", "coordinates": [[[-122.27841, 37.90357], [-122.27835, 37.9037], [-122.2783, 37.90383], [-122.27824, 37.90357], [-122.27841, 37.90357]]]} | Open Access 1 | 48179 | Kensington Pocket Park | 32715 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 0.053 | Kensington PP | 0 | Local Park 2 | 4 | |
11466 | 11466 | 11465 | {"type": "Polygon", "coordinates": [[[-122.28132, 37.9134], [-122.28121, 37.91335], [-122.28073, 37.91357], [-122.28038, 37.91363], [-122.28006, 37.91364], [-122.28059, 37.91414], [-122.28032, 37.91429], [-122.28033, 37.91433], [-122.28017, 37.91443], [-122.28013, 37.91447], [-122.28011, 37.91455], [-122.27999, 37.91464], [-122.27974, 37.91375], [-122.27977, 37.91354], [-122.27953, 37.91348], [-122.27932, 37.91337], [-122.27914, 37.9133], [-122.27894, 37.91332], [-122.27856, 37.91344], [-122.27849, 37.9134], [-122.27855, 37.91313], [-122.27855, 37.91292], [-122.28025, 37.91174], [-122.28106, 37.91239], [-122.2812, 37.91267], [-122.28074, 37.91276], [-122.28074, 37.91278], [-122.28092, 37.91335], [-122.28129, 37.91318], [-122.28132, 37.9134]]]} | Open Access 1 | 48178 | Kensington Park | 32713 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 8.459 | Kensington Park | 0 | Local Park 2 | 4 | |
15875 | 15875 | 15874 | {"type": "Polygon", "coordinates": [[[-122.32946, 38.00168], [-122.32842, 38.00225], [-122.32756, 38.00145], [-122.32721, 38.00108], [-122.32859, 38.00069], [-122.32946, 38.00168]]]} | Open Access 1 | 15091 | Montara Bay Community Center | 22384 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.396 | Montara Bay Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
1963 | 1963 | 1962 | {"type": "Polygon", "coordinates": [[[-122.3308, 37.99984], [-122.32883, 38.00027], [-122.32826, 37.99972], [-122.32874, 37.99941], [-122.32795, 37.99863], [-122.32906, 37.99841], [-122.32936, 37.9984], [-122.33043, 37.9986], [-122.33057, 37.99918], [-122.33065, 37.99944], [-122.33072, 37.9996], [-122.3308, 37.99984]]]} | Open Access 1 | 15093 | Montalvin Park | 22382 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 8.497 | Montalvin Park | 0 | Local Park 2 | 4 | |
5313 | 5313 | 5312 | {"type": "Polygon", "coordinates": [[[-122.40596, 37.71374], [-122.40581, 37.71398], [-122.40589, 37.71402], [-122.40573, 37.71427], [-122.4055, 37.71418], [-122.40565, 37.71394], [-122.40558, 37.7139], [-122.40573, 37.71365], [-122.40596, 37.71374]]]} | Open Access 1 | 6024 | Reis Tract Lots - Arleta I | 24283 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Francisco 13 | 0.348 | Reis Tract Lots - Arleta I | 0 | Local Other or Unknown 14 | 4 | |
5925 | 5925 | 5924 | {"type": "Polygon", "coordinates": [[[-122.44138, 37.61408], [-122.44117, 37.61412], [-122.44069, 37.61392], [-122.44002, 37.61339], [-122.43948, 37.61261], [-122.43864, 37.61177], [-122.43763, 37.61092], [-122.43671, 37.61028], [-122.43634, 37.60975], [-122.43625, 37.60948], [-122.43585, 37.6092], [-122.43502, 37.60891], [-122.43444, 37.60826], [-122.43427, 37.60785], [-122.43386, 37.60742], [-122.43315, 37.60696], [-122.433, 37.60668], [-122.43269, 37.60643], [-122.43245, 37.60595], [-122.43182, 37.60556], [-122.43113, 37.60494], [-122.43007, 37.60428], [-122.429, 37.60304], [-122.42866, 37.60291], [-122.42866, 37.60265], [-122.42805, 37.60208], [-122.42785, 37.60169], [-122.42702, 37.60087], [-122.42702, 37.60064], [-122.42725, 37.60053], [-122.4273, 37.60029], [-122.42656, 37.59972], [-122.4263, 37.59931], [-122.4259, 37.59895], [-122.42521, 37.59867], [-122.42492, 37.59842], [-122.42474, 37.59792], [-122.42394, 37.59723], [-122.42377, 37.59698], [-122.42371, 37.59661], [-122.42328, 37.59636], [-122.42239, 37.59643], [-122.42224, 37.59631], [-122.42218, 37.59526], [-122.42167, 37.59434], [-122.41931, 37.59171], [-122.41899, 37.59171], [-122.41879, 37.5918], [-122.41859, 37.59207], [-122.41859, 37.59288], [-122.41844, 37.59299], [-122.41819, 37.59299], [-122.41781, 37.5926], [-122.41764, 37.59228], [-122.41761, 37.59203], [-122.41793, 37.5915], [-122.41796, 37.59125], [-122.41784, 37.59111], [-122.41727, 37.59093], [-122.41727, 37.59073], [-122.41752, 37.59036], [-122.41764, 37.58917], [-122.41689, 37.58837], [-122.41661, 37.58784], [-122.41638, 37.58773], [-122.41637, 37.58752], [-122.41597, 37.58718], [-122.41505, 37.58692], [-122.41502, 37.58608], [-122.41416, 37.58534], [-122.41381, 37.58532], [-122.41347, 37.58553], [-122.4131, 37.58562], [-122.41298, 37.58553], [-122.41307, 37.5851], [-122.41295, 37.58495], [-122.41269, 37.58493], [-122.41238, 37.58502], [-122.4122, 37.58496], [-122.41154, 37.58502], [-122.4114, 37.58493], [-122.41143, 37.58452], [-122.41238, 37.58431], [-122.41261, 37.58418], [-122.41261, 37.58397], [-122.412, 37.58335], [-122.4114, 37.58305], [-122.41117, 37.58267], [-122.41082, 37.58262], [-122.41054, 37.58271], [-122.41016, 37.58271], [-122.40996, 37.58234], [-122.41008, 37.58209], [-122.41054, 37.58179], [-122.41057, 37.58127], [-122.41045, 37.58074], [-122.41085, 37.58049], [-122.41224, 37.58006], [-122.41246, 37.5801], [-122.41284, 37.58042], [-122.41341, 37.58063], [-122.4141, 37.58076], [-122.41482, 37.58061], [-122.41689, 37.58061], [-122.41741, 37.58068], [-122.41738, 37.58088], [-122.41707, 37.58104], [-122.41675, 37.58109], [-122.41517, 37.582], [-122.41506, 37.58221], [-122.41548, 37.58267], [-122.41563, 37.58301], [-122.41615, 37.58329], [-122.41661, 37.58365], [-122.41713, 37.58381], [-122.41902, 37.58388], [-122.41899, 37.58404], [-122.41856, 37.58443], [-122.4183, 37.58503], [-122.41836, 37.58534], [-122.41845, 37.58557], [-122.41905, 37.58617], [-122.41946, 37.58672], [-122.41974, 37.5869], [-122.42037, 37.587], [-122.42063, 37.58713], [-122.42075, 37.58745], [-122.42101, 37.5877], [-122.42196, 37.58796], [-122.42262, 37.58802], [-122.42382, 37.58789], [-122.42432, 37.58761], [-122.4246, 37.58764], [-122.42414, 37.58853], [-122.42417, 37.58871], [-122.42472, 37.58892], [-122.42742, 37.58853], [-122.42794, 37.58862], [-122.42788, 37.58876], [-122.42742, 37.58894], [-122.42711, 37.58917], [-122.42636, 37.58949], [-122.42575, 37.59011], [-122.42552, 37.59057], [-122.42564, 37.59086], [-122.42587, 37.59112], [-122.42584, 37.5913], [-122.42558, 37.59148], [-122.42549, 37.59171], [-122.42552, 37.59247], [-122.42567, 37.59279], [-122.42587, 37.59297], [-122.42595, 37.59322], [-122.42633, 37.59354], [-122.42742, 37.59402], [-122.42805, 37.59439], [-122.42857, 37.5945], [-122.43027, 37.59432], [-122.43061, 37.5945], [-122.43044, 37.59494], [-122.43047, 37.59526], [-122.43099, 37.59567], [-122.43102, 37.59599], [-122.43093, 37.59613], [-122.43038, 37.59631], [-122.42926, 37.59638], [-122.42906, 37.59652], [-122.42895, 37.59691], [-122.42906, 37.59716], [-122.4305, 37.59796], [-122.43119, 37.59812], [-122.43277, 37.59881], [-122.4343, 37.59993], [-122.43427, 37.60014], [-122.43378, 37.60073], [-122.43378, 37.60119], [-122.43401, 37.60158], [-122.43424, 37.60169], [-122.43556, 37.60183], [-122.43594, 37.60201], [-122.43628, 37.6024], [-122.43634, 37.60286], [-122.43651, 37.60304], [-122.43692, 37.60298], [-122.43738, 37.60302], [-122.43801, 37.6033], [-122.43893, 37.60321], [-122.43953, 37.60353], [-122.43979, 37.60387], [-122.43994, 37.60426], [-122.44066, 37.6052], [-122.44109, 37.60561], [-122.44117, 37.60579], [-122.44115, 37.60632], [-122.44103, 37.60662], [-122.44022, 37.60728], [-122.44002, 37.60735], [-122.43942, 37.60694], [-122.43801, 37.60659], [-122.43754, 37.60625], [-122.43712, 37.60623], [-122.43654, 37.60654], [-122.43643, 37.60696], [-122.4366, 37.60737], [-122.4372, 37.60797], [-122.43781, 37.60831], [-122.43795, 37.60865], [-122.43821, 37.609], [-122.43844, 37.60994], [-122.44025, 37.61158], [-122.44083, 37.61243], [-122.44137, 37.61362], [-122.44138, 37.61408]]]} | Restricted Access 2 | 408 | San Francisco Watershed Lands | 24889 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 478.92 | San Francisco Watershed Lands | None 474 | |||
5318 | 5318 | 5317 | {"type": "Polygon", "coordinates": [[[-122.45243, 37.75546], [-122.45204, 37.75657], [-122.45019, 37.75667], [-122.44973, 37.75638], [-122.44965, 37.75628], [-122.4496, 37.75614], [-122.4496, 37.75594], [-122.4499, 37.75586], [-122.45005, 37.75579], [-122.45019, 37.75571], [-122.45027, 37.75565], [-122.45079, 37.75511], [-122.45094, 37.755], [-122.45106, 37.75493], [-122.45121, 37.75487], [-122.45136, 37.75483], [-122.45148, 37.75484], [-122.45155, 37.75481], [-122.45158, 37.75476], [-122.45164, 37.75442], [-122.45206, 37.75443], [-122.45208, 37.75517], [-122.45243, 37.75546]]]} | Restricted Access 2 | 5591 | Summit Reservoir Water Facilities | 25969 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Francisco 13 | 9.063 | Summit Reservoir Water Facilities | None 430 | |||
1149 | 1149 | 1148 | {"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]} | Restricted Access 2 | 6734 | Hillcrest And Ocean View Lots | 19962 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 0.08 | Hillcrest And Ocean View Lots | 0 | Local Other or Unknown 14 | 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]);