units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
268 rows where DES_TP = 65 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Woodbridge Village Association 30
- Home Owners Association - Unknown Name 25
- Rancho Santa Margarita Landscape and Recreation Corporation 17
- Mountains Restoration Trust 16
- Amerige Heights Community Association 7
- Los Angeles Neighborhood Land Trust 6
- San Dieguito River Valley Land Conservancy 5
- Paseo Westpark Maintenance Association 4
- Deerfield Community Association 4
- Nellie Gail Ranch Owners Association 4
- Westpark Maintenance District 4
- Sierra Bonita Community Association 4
- Town Center Association 4
- Private Landowner 3
- Odd Fellows Sierra Recreation Association 3
- Northpark Square Maintenance Association 3
- Turtle Rock Broadmoor Community Association 3
- Oak Creek Village Maintenance Association 2
- Quail Hill Community Association 2
- Truckee Donner Land Trust 2
- Trinidad Coastal Land Trust 2
- Broadmoor Campus View Community Association 2
- Trust for Public Land 2
- Woodbridge Owners Association 2
- Northpark Maintenance Association 2
- Windwood Homeowners Association 2
- Johnson Ranch Community Association 2
- Woodbury Community Association 2
- John Muir Land Trust 1
- Petco Park Owner 1
- …
MNG_AG_TYP 10
ACCESS_TYP 3
- Restricted Access 192
- Open Access 38
- No Public Access 18
DES_TP 1
- Private Recreation or Education · 248 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7240 | 7240 | 7239 | {"type": "MultiPolygon", "coordinates": [[[[-118.63834, 34.05331], [-118.63828, 34.05338], [-118.63796, 34.05287], [-118.63805, 34.05287], [-118.63822, 34.05318], [-118.63834, 34.05331]]], [[[-118.6403, 34.06405], [-118.63999, 34.06447], [-118.63883, 34.06406], [-118.63887, 34.06394], [-118.63886, 34.06386], [-118.63882, 34.06371], [-118.63874, 34.06362], [-118.63846, 34.06342], [-118.63832, 34.06326], [-118.63943, 34.06277], [-118.63948, 34.06284], [-118.63955, 34.06289], [-118.63962, 34.06291], [-118.63971, 34.06301], [-118.63979, 34.06313], [-118.63977, 34.06316], [-118.64005, 34.06353], [-118.64004, 34.06366], [-118.64009, 34.06377], [-118.6403, 34.06405]]]]} | No Public Access 3 | 6434 | Las Flores Canyon Open Space | 29666 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 4.661 | Las Flores Canyon OS | 0 | Private Recreation or Education 65 | 4 | |
7265 | 7265 | 7264 | {"type": "Polygon", "coordinates": [[[-118.6346, 34.10682], [-118.63459, 34.10718], [-118.6335, 34.10718], [-118.63333, 34.10682], [-118.63356, 34.10682], [-118.63372, 34.1069], [-118.63389, 34.10682], [-118.6346, 34.10682]]]} | Open Access 1 | 6453 | Red Rock Canyon Park | 24227 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 1.049 | Red Rock Canyon Park | 0 | Private Recreation or Education 65 | 4 | |
7266 | 7266 | 7265 | {"type": "Polygon", "coordinates": [[[-118.61947, 34.11809], [-118.61505, 34.11808], [-118.61507, 34.11444], [-118.61946, 34.11443], [-118.61947, 34.11809]]]} | No Public Access 3 | 6454 | Henry Ridge Open Space | 29664 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 40.702 | Henry Ridge OS | 0 | Private Recreation or Education 65 | 4 | |
12491 | 12491 | 12490 | {"type": "Polygon", "coordinates": [[[-118.59323, 34.10829], [-118.59283, 34.10826], [-118.59281, 34.10794], [-118.59295, 34.10796], [-118.59321, 34.10791], [-118.59323, 34.10829]]]} | No Public Access 3 | 12687 | Topanga Open Space | 29663 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.339 | Topanga OS | 0 | Private Recreation or Education 65 | 4 | |
15805 | 15805 | 15804 | {"type": "Polygon", "coordinates": [[[-118.77383, 34.04565], [-118.77371, 34.04579], [-118.77369, 34.04597], [-118.77341, 34.04599], [-118.77339, 34.04567], [-118.77383, 34.04565]]]} | No Public Access 3 | 12523 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.266 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
15852 | 15852 | 15851 | {"type": "Polygon", "coordinates": [[[-118.65341, 34.04402], [-118.65239, 34.04383], [-118.65222, 34.04364], [-118.65222, 34.04358], [-118.65237, 34.0435], [-118.65252, 34.04337], [-118.65338, 34.04326], [-118.65341, 34.04402]]]} | Open Access 1 | 12524 | Mountains Restoration Trust Parkland | 22563 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 1.603 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16520 | 16520 | 16519 | {"type": "Polygon", "coordinates": [[[-118.64775, 34.04924], [-118.64555, 34.04925], [-118.64555, 34.04925], [-118.64573, 34.0491], [-118.64588, 34.04894], [-118.64619, 34.04853], [-118.64631, 34.04842], [-118.64645, 34.04834], [-118.64775, 34.04924]]]} | No Public Access 3 | 12521 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 2.56 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16528 | 16528 | 16527 | {"type": "Polygon", "coordinates": [[[-118.60253, 34.07222], [-118.60241, 34.07227], [-118.60218, 34.07226], [-118.60217, 34.07263], [-118.60212, 34.07256], [-118.60205, 34.07251], [-118.60191, 34.07248], [-118.60189, 34.07202], [-118.60197, 34.072], [-118.60221, 34.07203], [-118.60233, 34.07199], [-118.6024, 34.07194], [-118.60253, 34.07222]]]} | No Public Access 3 | 12514 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.564 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16562 | 16562 | 16561 | {"type": "Polygon", "coordinates": [[[-118.68988, 34.0683], [-118.68988, 34.06861], [-118.6898, 34.06857], [-118.68979, 34.06857], [-118.6898, 34.06859], [-118.68956, 34.0685], [-118.68902, 34.06837], [-118.689, 34.06726], [-118.68797, 34.06719], [-118.68796, 34.06733], [-118.68653, 34.06724], [-118.68653, 34.06684], [-118.68987, 34.06705], [-118.68988, 34.0683]]]} | No Public Access 3 | 12516 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 5.347 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16954 | 16954 | 16953 | {"type": "Polygon", "coordinates": [[[-118.77802, 34.04594], [-118.77704, 34.04594], [-118.77695, 34.0458], [-118.77801, 34.0458], [-118.77802, 34.04594]]]} | No Public Access 3 | 12522 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.35 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16957 | 16957 | 16956 | {"type": "Polygon", "coordinates": [[[-118.77416, 34.04757], [-118.77403, 34.04762], [-118.77363, 34.04741], [-118.7737, 34.04729], [-118.77414, 34.04746], [-118.77416, 34.04757]]]} | No Public Access 3 | 12504 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.213 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16958 | 16958 | 16957 | {"type": "Polygon", "coordinates": [[[-118.62162, 34.10069], [-118.62138, 34.1008], [-118.62131, 34.10072], [-118.62156, 34.10061], [-118.62162, 34.10069]]]} | No Public Access 3 | 12507 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.069 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16965 | 16965 | 16964 | {"type": "Polygon", "coordinates": [[[-118.60409, 34.06453], [-118.60408, 34.06544], [-118.60193, 34.06544], [-118.60193, 34.06453], [-118.60409, 34.06453]]]} | No Public Access 3 | 12509 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 4.966 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16969 | 16969 | 16968 | {"type": "Polygon", "coordinates": [[[-118.6238, 34.10536], [-118.62339, 34.10535], [-118.62338, 34.10426], [-118.62367, 34.10438], [-118.6238, 34.10442], [-118.6238, 34.10536]]]} | Restricted Access 2 | 12501 | Mountains Restoration Trust Parkland | 29662 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 1.053 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16970 | 16970 | 16969 | {"type": "Polygon", "coordinates": [[[-118.62222, 34.10346], [-118.62187, 34.10346], [-118.62175, 34.10335], [-118.62193, 34.10321], [-118.62222, 34.10346]]]} | No Public Access 3 | 12502 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.156 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16972 | 16972 | 16971 | {"type": "MultiPolygon", "coordinates": [[[[-118.67434, 34.03964], [-118.67429, 34.03977], [-118.67426, 34.03994], [-118.67425, 34.04043], [-118.67418, 34.04053], [-118.67404, 34.04067], [-118.67399, 34.04073], [-118.67394, 34.04093], [-118.67391, 34.04099], [-118.67372, 34.04118], [-118.67363, 34.04133], [-118.67354, 34.0416], [-118.67352, 34.04184], [-118.67346, 34.04201], [-118.6734, 34.04213], [-118.67323, 34.04235], [-118.6733, 34.04205], [-118.6733, 34.04199], [-118.67328, 34.04194], [-118.67375, 34.04068], [-118.67374, 34.04061], [-118.67368, 34.04054], [-118.67358, 34.0405], [-118.67252, 34.04064], [-118.67253, 34.04059], [-118.6735, 34.04045], [-118.67361, 34.04045], [-118.67371, 34.04048], [-118.67376, 34.04053], [-118.6738, 34.0406], [-118.67381, 34.04064], [-118.67382, 34.04065], [-118.67387, 34.04052], [-118.67402, 34.03978], [-118.67399, 34.03952], [-118.67425, 34.03936], [-118.67428, 34.03938], [-118.67432, 34.03946], [-118.67434, 34.03964]]], [[[-118.67508, 34.03923], [-118.6749, 34.04047], [-118.67444, 34.0432], [-118.67375, 34.04319], [-118.67367, 34.04274], [-118.67333, 34.04244], [-118.67355, 34.04212], [-118.67363, 34.04194], [-118.6742, 34.04205], [-118.67421, 34.04204], [-118.67431, 34.04138], [-118.67404, 34.04102], [-118.67408, 34.04094], [-118.67409, 34.04083], [-118.67413, 34.04074], [-118.67432, 34.04056], [-118.67438, 34.04045], [-118.67439, 34.03997], [-118.67448, 34.03958], [-118.67447, 34.03948], [-118.67442, 34.03937], [-118.67421, 34.03914], [-118.67418, 34.03908], [-118.67417, 34.03901], [-118.67421, 34.03884], [-118.6742, 34.03876], [-118.67416, 34.03867], [-118.67442, 34.03858], [-118.67464, 34.039], [-118.67508, 34.03923]]]]} | No Public Access 3 | 12520 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 9.545 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16200 | 16200 | 16199 | {"type": "Polygon", "coordinates": [[[-122.0897, 37.9062], [-122.08967, 37.90933], [-122.08958, 37.90936], [-122.08957, 37.91025], [-122.08787, 37.91065], [-122.08733, 37.91063], [-122.08703, 37.90902], [-122.08705, 37.90838], [-122.08752, 37.90706], [-122.0882, 37.90623], [-122.0897, 37.9062]]]} | Open Access 1 | 29704 | Acalanes Ridge Open Space | 15246 | 3045 | John Muir Land Trust 108 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.jmlt.org/ | Non Governmental Organization 10 | 3045 | John Muir Land Trust 105 | Non Profit 6 | Non Profit - Land Trust 10 | Contra Costa 12 | 24.054 | Acalanes Ridge OS | 0 | Private Recreation or Education 65 | 4 | |
7599 | 7599 | 7598 | {"type": "Polygon", "coordinates": [[[-117.35825, 33.16477], [-117.35811, 33.16484], [-117.35793, 33.16488], [-117.35776, 33.16502], [-117.35773, 33.16507], [-117.35761, 33.1652], [-117.35715, 33.1652], [-117.35715, 33.16625], [-117.35629, 33.16543], [-117.35617, 33.16533], [-117.35607, 33.16521], [-117.35598, 33.1652], [-117.35586, 33.16509], [-117.35548, 33.16483], [-117.35555, 33.16478], [-117.3555, 33.16464], [-117.35547, 33.16431], [-117.35558, 33.16437], [-117.35557, 33.16441], [-117.35563, 33.16466], [-117.35569, 33.16472], [-117.35576, 33.16486], [-117.35757, 33.16474], [-117.3576, 33.16476], [-117.35792, 33.16464], [-117.35803, 33.16453], [-117.35825, 33.16477]]]} | Open Access 1 | 7307 | Buena Vista Lagoon and Nature Center | 16487 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://bvaudubon.org/nature-center/ | San Diego 4 | 3.999 | Buena Vista Lagoon and Nature Ctr. | 0 | Private Recreation or Education 65 | 4 |
5982 | 5982 | 5981 | {"type": "MultiPolygon", "coordinates": [[[[-120.15031, 38.07513], [-120.15021, 38.0767], [-120.15017, 38.0788], [-120.1503, 38.07975], [-120.15007, 38.08129], [-120.14928, 38.08265], [-120.14892, 38.08205], [-120.14846, 38.08111], [-120.14743, 38.08057], [-120.14611, 38.08037], [-120.14582, 38.08042], [-120.14567, 38.08036], [-120.14566, 38.08026], [-120.14575, 38.0801], [-120.14657, 38.07944], [-120.14735, 38.07842], [-120.14738, 38.0774], [-120.14754, 38.0764], [-120.14785, 38.07644], [-120.14808, 38.07548], [-120.14814, 38.075], [-120.14814, 38.07479], [-120.14821, 38.07416], [-120.14982, 38.07453], [-120.15031, 38.07513]]], [[[-120.15315, 38.08292], [-120.15299, 38.08306], [-120.15302, 38.08341], [-120.15262, 38.08363], [-120.15246, 38.0834], [-120.15153, 38.08386], [-120.1512, 38.08408], [-120.15116, 38.08418], [-120.15116, 38.08431], [-120.15123, 38.08441], [-120.15098, 38.08462], [-120.15073, 38.08492], [-120.15035, 38.08507], [-120.15003, 38.08485], [-120.15022, 38.08462], [-120.14991, 38.08444], [-120.14965, 38.08382], [-120.14963, 38.0837], [-120.14974, 38.08333], [-120.14974, 38.08285], [-120.14939, 38.08282], [-120.14945, 38.08274], [-120.15032, 38.08131], [-120.15055, 38.0798], [-120.15088, 38.08009], [-120.15087, 38.08057], [-120.15094, 38.08099], [-120.15096, 38.08105], [-120.15148, 38.08155], [-120.15173, 38.08183], [-120.15218, 38.08213], [-120.15241, 38.08263], [-120.15255, 38.08268], [-120.15281, 38.08281], [-120.15315, 38.08292]]]]} | Open Access 1 | 575 | Odd Fellows High Sierra Park | 23069 | 3050 | Odd Fellows Sierra Recreation Association 821 | Non Profit 6 | Non Profit - Other 22 | http://ofsraparkmgt.wix.com/home | Non Governmental Organization 10 | 3050 | Odd Fellows Sierra Recreation Association 799 | Non Profit 6 | Non Profit - Other 20 | Tuolumne 21 | 69.024 | Odd Fellows High Sierra Park | 0 | Private Recreation or Education 65 | 4 | |
12389 | 12389 | 12388 | {"type": "Polygon", "coordinates": [[[-120.68035, 38.19748], [-120.68032, 38.19764], [-120.68019, 38.19787], [-120.68018, 38.19785], [-120.67998, 38.1978], [-120.68001, 38.19774], [-120.67974, 38.19755], [-120.67987, 38.19743], [-120.6797, 38.19732], [-120.67974, 38.19727], [-120.67949, 38.1971], [-120.67965, 38.19699], [-120.67991, 38.19725], [-120.68002, 38.19734], [-120.68035, 38.19748]]]} | Open Access 1 | 26534 | Neilsen Park | 22689 | 3050 | Odd Fellows Sierra Recreation Association 821 | Non Profit 6 | Non Profit - Other 22 | http://ofsraparkmgt.wix.com/home | Non Governmental Organization 10 | 3050 | Odd Fellows Sierra Recreation Association 799 | Non Profit 6 | Non Profit - Other 20 | Calaveras 53 | 0.651 | Neilsen Park | 0 | Private Recreation or Education 65 | 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]);