units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
101 rows where DES_TP = 2 and MNG_AGENCY = 294 sorted by id descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 101
MNG_AGENCY 1
- Long Beach, City of · 101 ✖
DES_TP 1
- Local Park · 101 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16815 | 16815 | 16814 | {"type": "Polygon", "coordinates": [[[-118.09007, 33.81023], [-118.0898, 33.81023], [-118.08979, 33.81025], [-118.08952, 33.81025], [-118.08951, 33.81028], [-118.08938, 33.81028], [-118.08938, 33.81031], [-118.089, 33.81031], [-118.08899, 33.81032], [-118.087, 33.81031], [-118.08681, 33.8103], [-118.08646, 33.81026], [-118.08528, 33.81025], [-118.08526, 33.80869], [-118.08528, 33.80858], [-118.08528, 33.80779], [-118.0838, 33.8078], [-118.08379, 33.8066], [-118.08225, 33.8066], [-118.0825, 33.80624], [-118.08262, 33.8061], [-118.08326, 33.80558], [-118.08379, 33.80511], [-118.08429, 33.80462], [-118.0848, 33.80407], [-118.08488, 33.80402], [-118.085, 33.80397], [-118.08519, 33.80394], [-118.08609, 33.80401], [-118.0878, 33.80432], [-118.08845, 33.8044], [-118.08879, 33.80441], [-118.08879, 33.80434], [-118.08978, 33.80435], [-118.09007, 33.81023]]]} | Open Access 1 | 6665 | El Dorado Nature Center | 18502 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 87.546 | El Dorado Nature Ctr. | 1998 | Local Park 2 | 4 | |
16323 | 16323 | 16322 | {"type": "MultiPolygon", "coordinates": [[[[-118.0908, 33.81768], [-118.09047, 33.81769], [-118.0906, 33.81868], [-118.08945, 33.81869], [-118.0885, 33.81861], [-118.0879, 33.81852], [-118.08434, 33.81774], [-118.08378, 33.81764], [-118.08341, 33.81758], [-118.08287, 33.81754], [-118.08224, 33.81751], [-118.08174, 33.81752], [-118.08176, 33.81394], [-118.08195, 33.81393], [-118.08196, 33.81266], [-118.0827, 33.81114], [-118.08279, 33.811], [-118.08295, 33.81085], [-118.08305, 33.81079], [-118.08332, 33.81069], [-118.08445, 33.81057], [-118.08673, 33.81058], [-118.08732, 33.81055], [-118.09009, 33.81055], [-118.09014, 33.8117], [-118.0905, 33.81171], [-118.09051, 33.81179], [-118.0906, 33.81391], [-118.0908, 33.81768]]], [[[-118.09232, 33.82822], [-118.09099, 33.82783], [-118.09091, 33.82687], [-118.09069, 33.82686], [-118.09069, 33.82486], [-118.08925, 33.82485], [-118.08923, 33.8273], [-118.08223, 33.82523], [-118.08214, 33.82485], [-118.0819, 33.82348], [-118.08181, 33.82263], [-118.08175, 33.82191], [-118.08173, 33.8205], [-118.08174, 33.82047], [-118.08175, 33.81779], [-118.08278, 33.81781], [-118.08335, 33.81786], [-118.08389, 33.81793], [-118.08736, 33.81869], [-118.08744, 33.81869], [-118.08787, 33.81882], [-118.08834, 33.81889], [-118.08886, 33.81894], [-118.08923, 33.81896], [-118.09064, 33.81895], [-118.09076, 33.81978], [-118.09109, 33.81978], [-118.09232, 33.82822]]]]} | Open Access 1 | 6606 | El Dorado East Regional Park | 5426 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/parks_and_open_spaces/parks/el_dorado_regional_park.asp | Los Angeles 6 | 354.173 | El Dorado East RP | 0 | Local Park 2 | 4 |
15400 | 15400 | 15399 | {"type": "Polygon", "coordinates": [[[-118.20264, 33.82045], [-118.20248, 33.82045], [-118.20153, 33.81926], [-118.20157, 33.81922], [-118.2021, 33.81932], [-118.20229, 33.81937], [-118.2023, 33.81941], [-118.20247, 33.81946], [-118.20248, 33.81943], [-118.20264, 33.81948], [-118.20264, 33.82045]]]} | Open Access 1 | 46617 | Wrigley Heights Dog Park | 29932 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.703 | Wrigley Heights Dog Park | 2014 | Local Park 2 | 4 | |
15399 | 15399 | 15398 | {"type": "Polygon", "coordinates": [[[-118.18285, 33.87975], [-118.18285, 33.88002], [-118.18185, 33.88002], [-118.18185, 33.87975], [-118.18285, 33.87975]]]} | Open Access 1 | 46616 | North Community Gardens | 29930 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.68 | North Community Gardens | 0 | Local Park 2 | 4 | |
15398 | 15398 | 15397 | {"type": "Polygon", "coordinates": [[[-118.13217, 33.7536], [-118.13193, 33.75398], [-118.13149, 33.75376], [-118.13174, 33.75337], [-118.13217, 33.7536]]]} | Open Access 1 | 46614 | Bayshore Park | 29912 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.568 | Bayshore Park | 1934 | Local Park 2 | 4 | |
15397 | 15397 | 15396 | {"type": "MultiPolygon", "coordinates": [[[[-118.16911, 33.76371], [-118.16907, 33.76395], [-118.16889, 33.76393], [-118.16893, 33.76369], [-118.16911, 33.76371]]], [[[-118.17, 33.76384], [-118.16997, 33.76404], [-118.16979, 33.76401], [-118.16982, 33.76382], [-118.17, 33.76384]]], [[[-118.17089, 33.76396], [-118.17086, 33.76416], [-118.17068, 33.76414], [-118.17072, 33.76393], [-118.17089, 33.76396]]], [[[-118.17176, 33.76423], [-118.17175, 33.7643], [-118.17157, 33.76428], [-118.17158, 33.76412], [-118.17159, 33.76412], [-118.17167, 33.76419], [-118.17176, 33.76423]]], [[[-118.17268, 33.76419], [-118.17265, 33.76435], [-118.17248, 33.76433], [-118.1725, 33.76417], [-118.17268, 33.76419]]], [[[-118.17358, 33.76431], [-118.17354, 33.76452], [-118.17346, 33.76449], [-118.17336, 33.7645], [-118.1734, 33.76428], [-118.17358, 33.76431]]], [[[-118.17447, 33.76442], [-118.17443, 33.76465], [-118.17439, 33.76464], [-118.17435, 33.76461], [-118.17425, 33.76462], [-118.17429, 33.7644], [-118.17447, 33.76442]]], [[[-118.17536, 33.76454], [-118.17533, 33.76475], [-118.17515, 33.76473], [-118.17519, 33.76452], [-118.17536, 33.76454]]], [[[-118.17626, 33.76466], [-118.17623, 33.76484], [-118.17605, 33.76482], [-118.17608, 33.76464], [-118.17626, 33.76466]]], [[[-118.17716, 33.76478], [-118.17711, 33.76501], [-118.17694, 33.76498], [-118.17698, 33.76475], [-118.17716, 33.76478]]], [[[-118.17805, 33.76489], [-118.17801, 33.76512], [-118.17783, 33.7651], [-118.17787, 33.76487], [-118.17805, 33.76489]]], [[[-118.17895, 33.76501], [-118.17891, 33.76521], [-118.17873, 33.76519], [-118.17877, 33.76499], [-118.17895, 33.76501]]], [[[-118.17984, 33.76513], [-118.1798, 33.76535], [-118.17962, 33.76533], [-118.17966, 33.7651], [-118.17984, 33.76513]]], [[[-118.18074, 33.76524], [-118.18068, 33.76554], [-118.18063, 33.76552], [-118.1805, 33.76551], [-118.18056, 33.76522], [-118.18074, 33.76524]]], [[[-118.18164, 33.76534], [-118.18157, 33.76571], [-118.18151, 33.76569], [-118.18139, 33.76569], [-118.18145, 33.76534], [-118.18164, 33.76534]]]]} | Open Access 1 | 46613 | Mini-Parks at 1st Place through 15th Place | 29924 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.511 | Mini-Parks at 1st Place through 15th Place | 1980 | Local Park 2 | 4 | |
15392 | 15392 | 15391 | {"type": "Polygon", "coordinates": [[[-118.11977, 33.76092], [-118.11936, 33.76122], [-118.11897, 33.76132], [-118.11864, 33.76148], [-118.1184, 33.76157], [-118.11836, 33.76161], [-118.11829, 33.76175], [-118.11825, 33.76178], [-118.11814, 33.7618], [-118.11783, 33.76151], [-118.11805, 33.76134], [-118.11853, 33.76125], [-118.1189, 33.76111], [-118.11927, 33.76109], [-118.11934, 33.76106], [-118.11943, 33.76114], [-118.11949, 33.76108], [-118.11965, 33.76081], [-118.11977, 33.76092]]]} | Open Access 1 | 46611 | Marina Pacifica Park | 29922 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.136 | Marina Pacifica Park | 0 | Local Park 2 | 4 | |
15390 | 15390 | 15389 | {"type": "Polygon", "coordinates": [[[-118.2227, 33.79832], [-118.22247, 33.79885], [-118.22142, 33.79884], [-118.22142, 33.79833], [-118.2227, 33.79832]]]} | Open Access 1 | 46610 | Hudson Park Community Garden | 29919 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.531 | Hudson Park Community Garden | 0 | Local Park 2 | 4 | |
15125 | 15125 | 15124 | {"type": "Polygon", "coordinates": [[[-118.18058, 33.80621], [-118.18059, 33.80984], [-118.18057, 33.81046], [-118.18041, 33.81046], [-118.17969, 33.81087], [-118.17885, 33.81087], [-118.17885, 33.81152], [-118.1774, 33.81152], [-118.1774, 33.81136], [-118.17753, 33.81135], [-118.17753, 33.81108], [-118.17786, 33.8108], [-118.17854, 33.8108], [-118.17874, 33.81064], [-118.17874, 33.81009], [-118.17754, 33.81009], [-118.17753, 33.80951], [-118.17641, 33.8095], [-118.17642, 33.80662], [-118.1766, 33.80662], [-118.17681, 33.80621], [-118.18058, 33.80621]]]} | Open Access 1 | 45937 | Willow Springs Park | 29012 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 44.552 | Willow Springs Park | 2012 | Local Park 2 | 4 | |
15123 | 15123 | 15122 | {"type": "Polygon", "coordinates": [[[-118.15198, 33.76322], [-118.15204, 33.763], [-118.15207, 33.76299], [-118.15224, 33.76336], [-118.15223, 33.76338], [-118.1522, 33.76339], [-118.15197, 33.76334], [-118.15196, 33.7633], [-118.15198, 33.76322]]]} | Open Access 1 | 45935 | Trolley Park | 29010 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.15 | Trolley Park | 0 | Local Park 2 | 4 | |
15119 | 15119 | 15118 | {"type": "Polygon", "coordinates": [[[-118.13488, 33.82336], [-118.13487, 33.82495], [-118.13413, 33.82494], [-118.13407, 33.82489], [-118.13408, 33.82335], [-118.13488, 33.82336]]]} | Open Access 1 | 45926 | Rosie the Riveter Park | 29002 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/park-and-facilities/directory/rosie-the-riveter-park/ | Los Angeles 6 | 3.243 | Rosie the Riveter Park | 0 | Local Park 2 | 4 |
15118 | 15118 | 15117 | {"type": "MultiPolygon", "coordinates": [[[[-118.17635, 33.78748], [-118.17633, 33.78757], [-118.17628, 33.78756], [-118.17628, 33.78748], [-118.17635, 33.78748]]], [[[-118.17644, 33.78717], [-118.17637, 33.78741], [-118.17628, 33.78741], [-118.17628, 33.78713], [-118.17644, 33.78717]]], [[[-118.17668, 33.78631], [-118.17646, 33.78703], [-118.17643, 33.78703], [-118.17643, 33.78631], [-118.17668, 33.78631]]]]} | Open Access 1 | 45925 | Rosa Parks Park | 29001 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/park-and-facilities/directory/rosa-parks-park/ | Los Angeles 6 | 0.348 | Rosa Parks Park | 0 | Local Park 2 | 4 |
15117 | 15117 | 15116 | {"type": "Polygon", "coordinates": [[[-118.18086, 33.77419], [-118.18085, 33.77523], [-118.18052, 33.77524], [-118.18052, 33.77509], [-118.18039, 33.77509], [-118.18051, 33.77465], [-118.18065, 33.77429], [-118.18076, 33.7742], [-118.18086, 33.77419]]]} | Open Access 1 | 45924 | Gumbiner Park | 32574 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/park-and-facilities/directory/gumbiner-park/ | Los Angeles 6 | 0.856 | Gumbiner Park | 0 | Local Park 2 | 4 |
15115 | 15115 | 15114 | {"type": "Polygon", "coordinates": [[[-118.19242, 33.76315], [-118.19221, 33.7635], [-118.19212, 33.76343], [-118.19211, 33.76333], [-118.19198, 33.76331], [-118.19182, 33.76314], [-118.19171, 33.76307], [-118.19137, 33.76305], [-118.19121, 33.76293], [-118.19116, 33.76292], [-118.19075, 33.76293], [-118.19061, 33.76292], [-118.19056, 33.76288], [-118.19027, 33.76264], [-118.19008, 33.76263], [-118.18992, 33.76273], [-118.18992, 33.76276], [-118.19036, 33.76313], [-118.19038, 33.76317], [-118.19037, 33.76321], [-118.19011, 33.76342], [-118.1901, 33.76358], [-118.19007, 33.76361], [-118.19003, 33.76363], [-118.18995, 33.76364], [-118.18965, 33.76363], [-118.18933, 33.7636], [-118.18921, 33.76356], [-118.18911, 33.76352], [-118.18887, 33.76336], [-118.18872, 33.7633], [-118.18859, 33.76327], [-118.18845, 33.76326], [-118.18832, 33.76327], [-118.18795, 33.76334], [-118.18788, 33.76333], [-118.18768, 33.76327], [-118.18742, 33.7633], [-118.187, 33.76284], [-118.18703, 33.76282], [-118.18701, 33.76277], [-118.18703, 33.76273], [-118.18725, 33.76257], [-118.18759, 33.76238], [-118.18795, 33.76223], [-118.18827, 33.76214], [-118.18862, 33.76208], [-118.18898, 33.76205], [-118.18935, 33.76205], [-118.1899, 33.76213], [-118.19042, 33.76227], [-118.19238, 33.76306], [-118.19242, 33.76315]]]} | Open Access 1 | 45921 | Rainbow Lagoon Park | 28995 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/park-and-facilities/directory/rainbow-lagoon/ | Los Angeles 6 | 11.696 | Rainbow Lagoon Park | 0 | Local Park 2 | 4 |
15114 | 15114 | 15113 | {"type": "Polygon", "coordinates": [[[-118.19095, 33.76861], [-118.19046, 33.7686], [-118.19046, 33.76819], [-118.19095, 33.76819], [-118.19095, 33.76861]]]} | Open Access 1 | 45919 | Promenade Square | 28993 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.516 | Promenade Square | 0 | Local Park 2 | 4 | |
15113 | 15113 | 15112 | {"type": "MultiPolygon", "coordinates": [[[[-118.18106, 33.78938], [-118.18106, 33.78974], [-118.18078, 33.78974], [-118.18077, 33.78939], [-118.18106, 33.78938]]], [[[-118.18486, 33.78965], [-118.18486, 33.78969], [-118.18481, 33.78973], [-118.18452, 33.78974], [-118.18452, 33.78965], [-118.18486, 33.78965]]]]} | Open Access 1 | 45918 | Poly High Gateway Park | 28992 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.326 | Poly High Gateway Park | 0 | Local Park 2 | 4 | |
15112 | 15112 | 15111 | {"type": "Polygon", "coordinates": [[[-118.18768, 33.79411], [-118.18768, 33.79425], [-118.18729, 33.79425], [-118.18728, 33.79411], [-118.18768, 33.79411]]]} | Open Access 1 | 45917 | Officer Daryle W Black Memorial Park | 28991 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/park-and-facilities/directory/daryle-black-park/ | Los Angeles 6 | 0.138 | Officer Daryle W Black Memorial Park | 0 | Local Park 2 | 4 |
15111 | 15111 | 15110 | {"type": "Polygon", "coordinates": [[[-118.18059, 33.7985], [-118.18058, 33.7996], [-118.17972, 33.79907], [-118.17956, 33.79901], [-118.17869, 33.79843], [-118.17851, 33.79836], [-118.17851, 33.79822], [-118.17966, 33.79895], [-118.18042, 33.79895], [-118.18045, 33.7985], [-118.18059, 33.7985]]]} | Open Access 1 | 45916 | NAACP Freedom Park | 28989 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.384 | NAACP Freedom Park | 0 | Local Park 2 | 4 | |
15110 | 15110 | 15109 | {"type": "Polygon", "coordinates": [[[-118.11318, 33.75143], [-118.11287, 33.75143], [-118.11283, 33.75139], [-118.11283, 33.75133], [-118.11296, 33.75122], [-118.11318, 33.75143]]]} | Open Access 1 | 45912 | Maurice 'Mossy' Kent Park | 28987 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/park-and-facilities/directory/mossy-kent-park/ | Los Angeles 6 | 0.108 | Maurice 'Mossy' Kent Park | 0 | Local Park 2 | 4 |
15109 | 15109 | 15108 | {"type": "Polygon", "coordinates": [[[-118.21483, 33.79305], [-118.21483, 33.79341], [-118.21466, 33.79341], [-118.21466, 33.79305], [-118.21483, 33.79305]]]} | Open Access 1 | 45911 | Mary Molina Community Garden | 28986 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.152 | Mary Molina Community Garden | 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]);