units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,190 rows where DES_TP = 14 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, YR_EST
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 152
- Ventura, City of 106
- Butte, County of 52
- Yuba County Water Agency 48
- Roseville, City of 46
- Santa Barbara, County of 39
- Lake, County of 36
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Orange, County of 21
- Napa, City of 21
- Monterey, County of 18
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Los Angeles County Flood Control District 13
- Santa Cruz, City of 12
- Santa Barbara Flood Control and Water Conserv. District 12
- Oroville, City of 12
- Los Angeles, County of 11
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Guadalupe, City of 10
- Santa Maria, City of 9
- Escondido, City of 9
- …
MNG_AG_TYP 15
- City Agency 663
- County Agency 214
- Open Space District 155
- Water District 78
- Flood District 32
- Recreation/Parks District 28
- County Agency - Other 6
- Irrigation District 4
- Sanitation District 3
- Community Services District 2
- County Agency - Parks 1
- Special District - Other 1
- Metropolitan Planning Organization 1
- Conservation District 1
- Transportation Agency 1
PARK_URL 8 ✖
- http://wsoweb.ladwp.com/Aqueduct/recuses/recreationindex.htm 2
- http://www.cityofvista.com/services/parks-and-facilities 2
- http://dpw.lacounty.gov/wrd/Projects/BTWMA/index.cfm 1
- http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#9 1
- http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=2445 1
- http://www.cvag.org 1
- http://www.lakecountyca.gov/Government/Directory/Parks/Parks/Search/Keeling_County_Park.htm 1
- http://www.riodellcity.com/planning-pdf/Rio%20Dell%20Zoning%20Map.pdf 1
ACCESS_TYP 4
- Open Access 859
- Unknown Access 204
- No Public Access 96
- Restricted Access 31
MNG_AG_LEV 3 ✖
- City 663
- Special District 306
- County 221
DES_TP 1
- Local Other or Unknown · 1,190 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1046 | 1046 | 1045 | {"type": "Polygon", "coordinates": [[[-118.34139, 34.12342], [-118.34119, 34.12342], [-118.34101, 34.12338], [-118.34082, 34.12338], [-118.34041, 34.12313], [-118.34051, 34.12301], [-118.34068, 34.12311], [-118.34077, 34.12313], [-118.34087, 34.12313], [-118.341, 34.12307], [-118.34139, 34.12342]]]} | Open Access 1 | 6900 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.464 | 0 | Local Other or Unknown 14 | 4 | ||
1066 | 1066 | 1065 | {"type": "Polygon", "coordinates": [[[-118.16257, 34.20755], [-118.16261, 34.2077], [-118.16261, 34.20779], [-118.16252, 34.20798], [-118.16232, 34.20798], [-118.16232, 34.20756], [-118.16257, 34.20755]]]} | Open Access 1 | 6963 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.283 | 0 | Local Other or Unknown 14 | 4 | ||
1208 | 1208 | 1207 | {"type": "Polygon", "coordinates": [[[-118.6372, 34.36427], [-118.62414, 34.36475], [-118.62394, 34.35736], [-118.63275, 34.35717], [-118.63292, 34.36076], [-118.63708, 34.36067], [-118.6372, 34.36427]]]} | Unknown Access 4 | 8425 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 201.929 | 0 | Local Other or Unknown 14 | 4 | ||
1209 | 1209 | 1208 | {"type": "Polygon", "coordinates": [[[-118.61077, 34.34136], [-118.60659, 34.34141], [-118.60658, 34.33946], [-118.61074, 34.33941], [-118.61077, 34.34136]]]} | Open Access 1 | 8436 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 20.46 | 0 | Local Other or Unknown 14 | 4 | ||
1210 | 1210 | 1209 | {"type": "MultiPolygon", "coordinates": [[[[-118.61079, 34.34292], [-118.6087, 34.34294], [-118.60869, 34.34216], [-118.61078, 34.34214], [-118.61079, 34.34292]]], [[[-118.61929, 34.3608], [-118.6181, 34.36074], [-118.61801, 34.35708], [-118.61919, 34.35713], [-118.61929, 34.3608]]]]} | Open Access 1 | 8447 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 15.04 | 0 | Local Other or Unknown 14 | 4 | ||
2882 | 2882 | 2881 | {"type": "Polygon", "coordinates": [[[-121.79106, 37.67722], [-121.79029, 37.67754], [-121.78871, 37.6778], [-121.78807, 37.67784], [-121.78741, 37.67737], [-121.78811, 37.67727], [-121.78838, 37.67755], [-121.78901, 37.67751], [-121.78842, 37.67665], [-121.78831, 37.67628], [-121.78917, 37.67597], [-121.78992, 37.67604], [-121.79005, 37.67635], [-121.79039, 37.67668], [-121.79075, 37.67693], [-121.79106, 37.67722]]]} | Open Access 1 | 22290 | Unknown park - Livermore, City of | 28714 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 8.284 | 0 | Local Other or Unknown 14 | 4 | ||
4130 | 4130 | 4129 | {"type": "Polygon", "coordinates": [[[-121.80347, 37.04255], [-121.80296, 37.04373], [-121.80276, 37.04499], [-121.80264, 37.04534], [-121.80233, 37.04573], [-121.80235, 37.04659], [-121.80223, 37.04686], [-121.80224, 37.04701], [-121.80228, 37.04703], [-121.80228, 37.04715], [-121.80279, 37.04754], [-121.80017, 37.04746], [-121.80028, 37.04454], [-121.80045, 37.04074], [-121.80194, 37.04076], [-121.80282, 37.04139], [-121.80342, 37.04205], [-121.80347, 37.04255]]]} | Open Access 1 | 36505 | Unnamed site - Watsonville, City of | 28675 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 40.881 | 0 | Local Other or Unknown 14 | 4 | ||
4376 | 4376 | 4375 | {"type": "Polygon", "coordinates": [[[-121.1454, 37.46398], [-121.14539, 37.46422], [-121.14474, 37.46421], [-121.14469, 37.46417], [-121.14469, 37.46347], [-121.1453, 37.46348], [-121.14529, 37.46374], [-121.14524, 37.46379], [-121.14522, 37.46387], [-121.14527, 37.46394], [-121.14534, 37.46398], [-121.1454, 37.46398]]]} | Open Access 1 | 48546 | Unknown Park - Patterson, City of | 33386 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.121 | 0 | Local Other or Unknown 14 | 4 | ||
4469 | 4469 | 4468 | {"type": "Polygon", "coordinates": [[[-117.06249, 32.75242], [-117.06211, 32.75251], [-117.06106, 32.75279], [-117.06087, 32.75234], [-117.0624, 32.75219], [-117.06249, 32.75242]]]} | Open Access 1 | 94 | Unnamed site - San Diego, City of | 28704 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.367 | 0 | Local Other or Unknown 14 | 4 | ||
4470 | 4470 | 4469 | {"type": "Polygon", "coordinates": [[[-116.37329, 33.19965], [-116.36458, 33.19964], [-116.36453, 33.19257], [-116.37324, 33.19257], [-116.37329, 33.19965]]]} | Restricted Access 2 | 1194 | Unnamed site - Borrego Water District | 28622 | 2008 | Borrego Water District 764 | Special District 4 | Water District 13 | http://www.borregowd.org/ | Special District 4 | 2008 | Borrego Water District 745 | Special District 4 | Water District 13 | San Diego 4 | 157.534 | 0 | Local Other or Unknown 14 | 4 | ||
4473 | 4473 | 4472 | {"type": "MultiPolygon", "coordinates": [[[[-121.97217, 36.95571], [-121.97161, 36.95571], [-121.97067, 36.95684], [-121.96972, 36.95745], [-121.96972, 36.9572], [-121.96985, 36.95709], [-121.97002, 36.95701], [-121.97017, 36.95688], [-121.97046, 36.95667], [-121.97057, 36.95657], [-121.97068, 36.9564], [-121.97079, 36.9563], [-121.9709, 36.95613], [-121.97105, 36.95599], [-121.9711, 36.95587], [-121.97115, 36.95582], [-121.97122, 36.95566], [-121.97128, 36.95558], [-121.9715, 36.95551], [-121.97151, 36.95549], [-121.97172, 36.95544], [-121.97193, 36.95527], [-121.97196, 36.9553], [-121.97173, 36.9555], [-121.97217, 36.9556], [-121.97217, 36.95571]]], [[[-121.97325, 36.95473], [-121.97294, 36.95463], [-121.97273, 36.95464], [-121.97267, 36.95471], [-121.97265, 36.95471], [-121.97264, 36.95469], [-121.97275, 36.95462], [-121.97288, 36.95459], [-121.97305, 36.95462], [-121.97324, 36.95471], [-121.97325, 36.95473]]]]} | Open Access 1 | 1619 | Unnamed site - Santa Cruz, County of | 28666 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.964 | 0 | Local Other or Unknown 14 | 4 | ||
4474 | 4474 | 4473 | {"type": "Polygon", "coordinates": [[[-118.79355, 34.05992], [-118.79347, 34.06171], [-118.78758, 34.06172], [-118.78748, 34.05991], [-118.79355, 34.05992]], [[-118.78798, 34.06012], [-118.78789, 34.06023], [-118.78799, 34.06049], [-118.78817, 34.06057], [-118.78837, 34.06052], [-118.78844, 34.0604], [-118.78835, 34.06025], [-118.78816, 34.06007], [-118.78798, 34.06012]]]} | Open Access 1 | 2664 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 26.845 | 0 | Local Other or Unknown 14 | 4 | ||
4477 | 4477 | 4476 | {"type": "MultiPolygon", "coordinates": [[[[-118.78326, 34.06724], [-118.78319, 34.06725], [-118.78314, 34.0671], [-118.78304, 34.06698], [-118.78289, 34.06691], [-118.78273, 34.06689], [-118.78256, 34.06692], [-118.78178, 34.06725], [-118.78103, 34.06725], [-118.781, 34.06673], [-118.78097, 34.06659], [-118.7809, 34.06646], [-118.7805, 34.06596], [-118.78035, 34.06587], [-118.78017, 34.06584], [-118.78, 34.06587], [-118.77985, 34.06595], [-118.77974, 34.06609], [-118.77971, 34.06624], [-118.77976, 34.06638], [-118.77983, 34.06647], [-118.78016, 34.06665], [-118.78026, 34.06677], [-118.78029, 34.06691], [-118.78028, 34.06725], [-118.77923, 34.06725], [-118.77921, 34.06359], [-118.78113, 34.06358], [-118.78102, 34.06375], [-118.78099, 34.0639], [-118.78101, 34.064], [-118.78106, 34.06409], [-118.78119, 34.0642], [-118.78136, 34.06425], [-118.78148, 34.06425], [-118.7816, 34.06422], [-118.78196, 34.06408], [-118.78208, 34.06408], [-118.78218, 34.06412], [-118.78222, 34.06417], [-118.78225, 34.06424], [-118.78233, 34.06476], [-118.7823, 34.06483], [-118.78215, 34.06496], [-118.78205, 34.06511], [-118.78202, 34.06522], [-118.78203, 34.06579], [-118.78202, 34.06588], [-118.78198, 34.06596], [-118.78172, 34.06625], [-118.78167, 34.06634], [-118.78164, 34.06644], [-118.78166, 34.06658], [-118.78172, 34.06667], [-118.7818, 34.06674], [-118.78189, 34.06679], [-118.78201, 34.06682], [-118.78218, 34.06681], [-118.78277, 34.06668], [-118.78292, 34.06668], [-118.78301, 34.06671], [-118.78314, 34.06679], [-118.78322, 34.06691], [-118.78326, 34.06724]]], [[[-118.78083, 34.06725], [-118.78047, 34.06725], [-118.78048, 34.06686], [-118.78044, 34.0667], [-118.78037, 34.0666], [-118.78029, 34.06652], [-118.77999, 34.06637], [-118.77995, 34.06632], [-118.77992, 34.06627], [-118.77991, 34.0662], [-118.77993, 34.06614], [-118.78003, 34.06604], [-118.7801, 34.06601], [-118.78017, 34.066], [-118.78025, 34.06601], [-118.78031, 34.06604], [-118.78036, 34.06609], [-118.78072, 34.06654], [-118.78078, 34.06664], [-118.78081, 34.06675], [-118.78083, 34.06725]]], [[[-118.78356, 34.06724], [-118.78346, 34.06724], [-118.78343, 34.06693], [-118.78337, 34.06678], [-118.78325, 34.06665], [-118.78308, 34.06656], [-118.78294, 34.06652], [-118.78274, 34.06651], [-118.78206, 34.06666], [-118.78195, 34.06663], [-118.78187, 34.06656], [-118.78184, 34.06647], [-118.78186, 34.06638], [-118.78215, 34.06605], [-118.78221, 34.0659], [-118.78222, 34.06519], [-118.78229, 34.06508], [-118.78244, 34.06495], [-118.7825, 34.06487], [-118.78253, 34.06477], [-118.78252, 34.06468], [-118.78243, 34.06416], [-118.78234, 34.06403], [-118.78225, 34.06396], [-118.78208, 34.06391], [-118.78196, 34.06391], [-118.78184, 34.06394], [-118.78144, 34.06408], [-118.78132, 34.06407], [-118.78123, 34.06401], [-118.78119, 34.06392], [-118.78119, 34.06385], [-118.78137, 34.06358], [-118.78345, 34.06357], [-118.78356, 34.06724]]], [[[-118.78299, 34.06725], [-118.78261, 34.06725], [-118.78223, 34.06725], [-118.78265, 34.06707], [-118.78275, 34.06705], [-118.78283, 34.06706], [-118.78292, 34.06711], [-118.78296, 34.06716], [-118.78299, 34.06725]]]]} | Open Access 1 | 3750 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 34.504 | 0 | Local Other or Unknown 14 | 4 | ||
4481 | 4481 | 4480 | {"type": "Polygon", "coordinates": [[[-118.36745, 34.34431], [-118.36743, 34.34613], [-118.36606, 34.34614], [-118.36599, 34.34579], [-118.36591, 34.34567], [-118.36583, 34.34561], [-118.36568, 34.34555], [-118.36509, 34.34549], [-118.36511, 34.34439], [-118.36643, 34.34432], [-118.36745, 34.34431]]]} | Open Access 1 | 4296 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 9.278 | 0 | Local Other or Unknown 14 | 4 | ||
4482 | 4482 | 4481 | {"type": "Polygon", "coordinates": [[[-118.82809, 34.1109], [-118.82374, 34.11089], [-118.82373, 34.10731], [-118.82808, 34.10728], [-118.82809, 34.1109]]]} | Unknown Access 4 | 4333 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 39.614 | 0 | Local Other or Unknown 14 | 4 | ||
4483 | 4483 | 4482 | {"type": "Polygon", "coordinates": [[[-118.83243, 34.10717], [-118.83243, 34.10853], [-118.82873, 34.10863], [-118.82809, 34.10863], [-118.82808, 34.10727], [-118.82875, 34.10727], [-118.83243, 34.10717]]]} | Unknown Access 4 | 4342 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 14.94 | 0 | Local Other or Unknown 14 | 4 | ||
4485 | 4485 | 4484 | {"type": "Polygon", "coordinates": [[[-116.23302, 33.58134], [-116.23293, 33.58128], [-116.23136, 33.57741], [-116.23092, 33.57648], [-116.22951, 33.57441], [-116.22812, 33.57509], [-116.22717, 33.57368], [-116.22436, 33.5737], [-116.22436, 33.57461], [-116.22274, 33.57463], [-116.22139, 33.57376], [-116.22098, 33.57302], [-116.22093, 33.57256], [-116.22053, 33.57243], [-116.22029, 33.57202], [-116.21854, 33.57148], [-116.21604, 33.57082], [-116.21605, 33.56939], [-116.22448, 33.56938], [-116.22417, 33.57223], [-116.22418, 33.57224], [-116.22904, 33.56937], [-116.233, 33.56936], [-116.23299, 33.57257], [-116.23302, 33.58134]]]} | Open Access 1 | 4461 | Unnamed site - Riverside County Regional Park and Open Space District | 28656 | 2123 | Riverside County Regional Park and Open Space District 262 | Special District 4 | Recreation/Parks District 4 | http://www.riversidecountyparks.org/ | Special District 4 | 2123 | Riverside County Regional Park and Open Space District 258 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 187.128 | 0 | Local Other or Unknown 14 | 4 | ||
4487 | 4487 | 4486 | {"type": "Polygon", "coordinates": [[[-117.65095, 33.91007], [-117.65019, 33.91006], [-117.64981, 33.90897], [-117.65009, 33.9089], [-117.65007, 33.90881], [-117.65045, 33.90848], [-117.65044, 33.90828], [-117.64965, 33.9076], [-117.64926, 33.90648], [-117.65093, 33.90642], [-117.65095, 33.91007]]]} | Unknown Access 4 | 4844 | Unnamed site - Orange County Water District | 28653 | 2105 | Orange County Water District 768 | Special District 4 | Water District 13 | http://www.ocwd.com/ | Special District 4 | 2105 | Orange County Water District 749 | Special District 4 | Water District 13 | Riverside 10 | 9.715 | 0 | Local Other or Unknown 14 | 4 | ||
4489 | 4489 | 4488 | {"type": "MultiPolygon", "coordinates": [[[[-118.21759, 34.10846], [-118.21735, 34.1085], [-118.21726, 34.10813], [-118.21751, 34.10809], [-118.21759, 34.10846]]], [[[-118.21918, 34.10822], [-118.21901, 34.10857], [-118.21832, 34.10834], [-118.21784, 34.10842], [-118.21775, 34.10805], [-118.21837, 34.10795], [-118.21918, 34.10822]]]]} | Unknown Access 4 | 4922 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.517 | 0 | Local Other or Unknown 14 | 4 | ||
4492 | 4492 | 4491 | {"type": "Polygon", "coordinates": [[[-118.35128, 33.78024], [-118.35122, 33.78036], [-118.35108, 33.78051], [-118.35086, 33.78065], [-118.35069, 33.7807], [-118.35057, 33.78035], [-118.35093, 33.78032], [-118.35092, 33.78], [-118.35108, 33.78], [-118.35119, 33.78003], [-118.35127, 33.78011], [-118.35128, 33.78024]]]} | Open Access 1 | 5914 | Unnamed site - Westfield Recreation and Park District | 28676 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.653 | 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]);