units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where GAP_STS = 4 and MNG_AG_TYP = 9 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, PARK_URL, COUNTY
MNG_AGENCY 9
- Los Angeles County Flood Control District 19
- Santa Barbara Flood Control and Water Conserv. District 18
- Fresno Metropolitan Flood Control District 14
- Natomas Basin Conservancy 4
- Sacramento Area Flood Control Agency 2
- Sacramento and San Joaquin Drainage District 1
- Alameda County Flood Control and Water Conservation District 1
- San Bernardino County Flood Control District 1
- Marin Public Works Dept/Flood Control 1
ACCESS_TYP 4
DES_TP 3
MNG_AG_TYP 1
- Flood District · 61 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4548 | 4548 | 4547 | {"type": "Polygon", "coordinates": [[[-121.79158, 37.67939], [-121.79158, 37.67946], [-121.79149, 37.67979], [-121.79049, 37.6798], [-121.78952, 37.6799], [-121.78852, 37.67912], [-121.78813, 37.67868], [-121.78776, 37.6781], [-121.78856, 37.67806], [-121.78921, 37.67793], [-121.78982, 37.67789], [-121.79032, 37.67778], [-121.79055, 37.67842], [-121.79149, 37.67827], [-121.79153, 37.67865], [-121.79159, 37.67899], [-121.79158, 37.67939]]]} | Open Access 1 | 22291 | Unnamed site - Alameda County Flood Control and Water Conservation District | 28716 | 2000 | Alameda County Flood Control and Water Conservation District 771 | Special District 4 | Flood District 8 | http://acfloodcontrol.org/ | Special District 4 | 2000 | Alameda County Flood Control and Water Conservation District 752 | Special District 4 | Flood District 9 | Alameda 17 | 13.147 | 0 | Local Other or Unknown 14 | 4 | ||
4312 | 4312 | 4311 | {"type": "Polygon", "coordinates": [[[-119.82186, 36.82104], [-119.82186, 36.82267], [-119.82071, 36.82268], [-119.82071, 36.82239], [-119.81997, 36.82167], [-119.81992, 36.8217], [-119.81966, 36.8217], [-119.81966, 36.82097], [-119.82, 36.82096], [-119.82001, 36.82105], [-119.82186, 36.82104]]]} | Open Access 1 | 47276 | Basin I Park | 30984 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 6.944 | Basin I Park | 0 | Local Park 2 | 4 |
4779 | 4779 | 4778 | {"type": "Polygon", "coordinates": [[[-119.7721, 36.81927], [-119.7721, 36.82034], [-119.77065, 36.82074], [-119.76932, 36.82178], [-119.76873, 36.82129], [-119.76874, 36.82111], [-119.76941, 36.82058], [-119.76952, 36.82039], [-119.76935, 36.82023], [-119.76862, 36.8208], [-119.76973, 36.81993], [-119.7721, 36.81927]]]} | No Public Access 3 | 47094 | Unnamed site - Fresno Metropolitan Flood Control District | 30753 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | Fresno 9 | 9.081 | 0 | Local Other or Unknown 14 | 4 | ||
6347 | 6347 | 6346 | {"type": "Polygon", "coordinates": [[[-119.72501, 36.73865], [-119.725, 36.73946], [-119.72284, 36.73945], [-119.72277, 36.73948], [-119.72274, 36.73954], [-119.7218, 36.73953], [-119.72181, 36.73948], [-119.72187, 36.7394], [-119.72187, 36.73933], [-119.72181, 36.73926], [-119.7217, 36.73923], [-119.7216, 36.73926], [-119.72154, 36.73933], [-119.72154, 36.7394], [-119.7216, 36.73948], [-119.72161, 36.73953], [-119.72058, 36.73953], [-119.72058, 36.73894], [-119.72284, 36.73894], [-119.72285, 36.73828], [-119.72318, 36.73827], [-119.72319, 36.7383], [-119.72327, 36.73837], [-119.72369, 36.73841], [-119.72396, 36.73853], [-119.72424, 36.73868], [-119.72501, 36.73865]]]} | Open Access 1 | 1762 | Trolley Creek Park | 26550 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | Fresno 9 | 8.104 | Trolley Creek Park | 0 | Local Park 2 | 4 | |
6389 | 6389 | 6388 | {"type": "Polygon", "coordinates": [[[-119.83073, 36.81646], [-119.83073, 36.81823], [-119.82858, 36.81824], [-119.82858, 36.81647], [-119.83073, 36.81646]]]} | Open Access 1 | 1815 | Oso De Oro Lake Park | 23234 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | Fresno 9 | 9.316 | Oso De Oro Lake Park | 0 | Local Park 2 | 4 | |
14752 | 14752 | 14751 | {"type": "Polygon", "coordinates": [[[-119.74966, 36.79444], [-119.74965, 36.79625], [-119.74636, 36.79624], [-119.74689, 36.79573], [-119.74739, 36.79533], [-119.74753, 36.7952], [-119.74772, 36.79496], [-119.74789, 36.79465], [-119.74842, 36.79461], [-119.74966, 36.79444]]]} | Open Access 1 | 47260 | Basin C Park | 30970 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 10.001 | Basin C Park | 0 | Local Park 2 | 4 |
14815 | 14815 | 14814 | {"type": "Polygon", "coordinates": [[[-119.86782, 36.82561], [-119.86717, 36.82627], [-119.86482, 36.82629], [-119.86482, 36.82551], [-119.86487, 36.82546], [-119.86489, 36.82541], [-119.86489, 36.82512], [-119.86665, 36.82512], [-119.86682, 36.82496], [-119.86782, 36.82561]]]} | Open Access 1 | 47257 | Basin AC Park | 30968 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 7.509 | Basin AC Park | 0 | Local Park 2 | 4 |
14829 | 14829 | 14828 | {"type": "Polygon", "coordinates": [[[-119.8129, 36.79759], [-119.8129, 36.79813], [-119.80966, 36.79816], [-119.80965, 36.79807], [-119.80975, 36.79761], [-119.8129, 36.79759]]]} | Open Access 1 | 47264 | Basin DD1 Park | 30973 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 4.322 | Basin DD1 Park | 0 | Local Park 2 | 4 |
14831 | 14831 | 14830 | {"type": "Polygon", "coordinates": [[[-119.90629, 36.8413], [-119.90545, 36.84133], [-119.90541, 36.84069], [-119.90626, 36.8407], [-119.90629, 36.8413]]]} | Open Access 1 | 47266 | Basin EG Park | 30974 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 1.297 | Basin EG Park | 0 | Local Park 2 | 4 |
14834 | 14834 | 14833 | {"type": "Polygon", "coordinates": [[[-119.79715, 36.81648], [-119.79715, 36.81665], [-119.79656, 36.81674], [-119.79642, 36.81675], [-119.79629, 36.81674], [-119.79602, 36.81668], [-119.7959, 36.81662], [-119.79577, 36.81654], [-119.79559, 36.81636], [-119.79551, 36.81624], [-119.79546, 36.81614], [-119.79543, 36.81597], [-119.79715, 36.81648]]]} | Open Access 1 | 47267 | Basin F Park | 30976 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 1.692 | Basin F Park | 0 | Local Park 2 | 4 |
14839 | 14839 | 14838 | {"type": "Polygon", "coordinates": [[[-119.8233, 36.72501], [-119.82328, 36.72602], [-119.82268, 36.72602], [-119.8227, 36.72501], [-119.8233, 36.72501]]]} | Open Access 1 | 47269 | Basin FF Park | 30978 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 1.472 | Basin FF Park | 0 | Local Park 2 | 4 |
14849 | 14849 | 14848 | {"type": "Polygon", "coordinates": [[[-119.79667, 36.82651], [-119.79493, 36.82652], [-119.79495, 36.82485], [-119.79576, 36.82483], [-119.79586, 36.8248], [-119.79593, 36.82475], [-119.79668, 36.82475], [-119.79667, 36.82651]]]} | Open Access 1 | 47273 | Basin H Park | 30981 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 7.305 | Basin H Park | 0 | Local Park 2 | 4 |
14878 | 14878 | 14877 | {"type": "Polygon", "coordinates": [[[-119.81224, 36.70994], [-119.81179, 36.70994], [-119.81185, 36.71007], [-119.81187, 36.71015], [-119.81186, 36.71035], [-119.81112, 36.71036], [-119.81112, 36.70874], [-119.81224, 36.70873], [-119.81224, 36.70994]]]} | Open Access 1 | 47281 | Basin TT2 Park | 30990 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 4.062 | Basin TT2 Park | 0 | Local Park 2 | 4 |
14881 | 14881 | 14880 | {"type": "Polygon", "coordinates": [[[-119.77005, 36.81043], [-119.77004, 36.8121], [-119.76831, 36.81211], [-119.7683, 36.81219], [-119.76777, 36.81219], [-119.76777, 36.81043], [-119.77005, 36.81043]]]} | Open Access 1 | 47278 | Basin M Park | 30986 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 9.444 | Basin M Park | 0 | Local Park 2 | 4 |
15033 | 15033 | 15032 | {"type": "Polygon", "coordinates": [[[-119.83778, 36.76281], [-119.83769, 36.76281], [-119.83768, 36.76288], [-119.83567, 36.76288], [-119.83567, 36.76165], [-119.83777, 36.76164], [-119.83778, 36.76281]]]} | Open Access 1 | 47287 | Basin XX Park | 30993 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Fresno 9 | 6.359 | Basin XX Park | 0 | Local Park 2 | 4 |
10118 | 10118 | 10117 | {"type": "MultiPolygon", "coordinates": [[[[-122.53534, 38.07672], [-122.53156, 38.07807], [-122.53133, 38.07813], [-122.53036, 38.0783], [-122.52863, 38.07883], [-122.52842, 38.07833], [-122.52729, 38.07791], [-122.52563, 38.07464], [-122.52596, 38.07439], [-122.52574, 38.07374], [-122.5243, 38.07215], [-122.52311, 38.07182], [-122.52237, 38.07141], [-122.5218, 38.07101], [-122.52315, 38.06994], [-122.52495, 38.06973], [-122.52495, 38.06971], [-122.52738, 38.06943], [-122.52761, 38.07048], [-122.52826, 38.07145], [-122.52875, 38.07227], [-122.52886, 38.07233], [-122.52895, 38.07248], [-122.52897, 38.07274], [-122.52924, 38.0732], [-122.52982, 38.07335], [-122.53044, 38.07297], [-122.53091, 38.07302], [-122.53132, 38.07324], [-122.53149, 38.07354], [-122.53148, 38.07382], [-122.53175, 38.0742], [-122.53227, 38.07428], [-122.53262, 38.07445], [-122.53285, 38.07487], [-122.53314, 38.07482], [-122.53391, 38.07456], [-122.53469, 38.07593], [-122.53489, 38.07618], [-122.53514, 38.07644], [-122.53534, 38.07672]]], [[[-122.53462, 38.08549], [-122.53457, 38.08664], [-122.51994, 38.09789], [-122.51972, 38.09772], [-122.51576, 38.10081], [-122.51169, 38.09693], [-122.51111, 38.09776], [-122.50743, 38.09739], [-122.50179, 38.09877], [-122.5016, 38.09898], [-122.50144, 38.09994], [-122.49266, 38.09971], [-122.49517, 38.09326], [-122.49571, 38.09316], [-122.49813, 38.09207], [-122.50068, 38.09055], [-122.50189, 38.08967], [-122.50306, 38.08829], [-122.50434, 38.08636], [-122.50476, 38.08672], [-122.50462, 38.0869], [-122.50547, 38.08821], [-122.5071, 38.09337], [-122.50961, 38.09217], [-122.51401, 38.08952], [-122.51417, 38.09043], [-122.51543, 38.09181], [-122.51569, 38.09196], [-122.5162, 38.09211], [-122.51883, 38.09149], [-122.51989, 38.09089], [-122.5217, 38.08911], [-122.52284, 38.08835], [-122.52335, 38.08812], [-122.52446, 38.08801], [-122.52504, 38.08804], [-122.5258, 38.08817], [-122.52699, 38.08823], [-122.52785, 38.08799], [-122.52841, 38.08753], [-122.52891, 38.08677], [-122.52898, 38.08609], [-122.52863, 38.08491], [-122.52814, 38.08411], [-122.52711, 38.08293], [-122.52684, 38.08204], [-122.5271, 38.08141], [-122.52804, 38.08099], [-122.52999, 38.0817], [-122.53168, 38.08273], [-122.53318, 38.08368], [-122.53412, 38.08444], [-122.53462, 38.08549]]], [[[-122.55951, 38.09996], [-122.55862, 38.10039], [-122.55845, 38.10046], [-122.55726, 38.0999], [-122.5569, 38.09995], [-122.55686, 38.09998], [-122.5528, 38.09898], [-122.55176, 38.09958], [-122.5507, 38.09887], [-122.54961, 38.10549], [-122.54399, 38.10359], [-122.54188, 38.10374], [-122.53904, 38.10259], [-122.53854, 38.10213], [-122.5352, 38.10117], [-122.5351, 38.10123], [-122.53421, 38.10043], [-122.53427, 38.10035], [-122.53466, 38.10075], [-122.53542, 38.10118], [-122.53848, 38.10186], [-122.5397, 38.10179], [-122.54035, 38.10017], [-122.5423, 38.10081], [-122.54299, 38.10036], [-122.54308, 38.10049], [-122.54317, 38.10043], [-122.54344, 38.09978], [-122.54308, 38.09854], [-122.54219, 38.09765], [-122.54108, 38.09662], [-122.54019, 38.09627], [-122.53982, 38.09454], [-122.53834, 38.09349], [-122.53683, 38.09307], [-122.53388, 38.0938], [-122.53231, 38.09484], [-122.53214, 38.09646], [-122.53264, 38.0976], [-122.53368, 38.09778], [-122.53315, 38.09841], [-122.52794, 38.09337], [-122.52831, 38.09329], [-122.52831, 38.09327], [-122.5281, 38.09305], [-122.52858, 38.09268], [-122.5286, 38.09268], [-122.53, 38.09158], [-122.53, 38.09157], [-122.53247, 38.08961], [-122.53254, 38.08966], [-122.53422, 38.08837], [-122.53534, 38.08745], [-122.53546, 38.08781], [-122.53566, 38.08815], [-122.53593, 38.08846], [-122.5361, 38.08859], [-122.53646, 38.08883], [-122.53667, 38.08893], [-122.53722, 38.08914], [-122.53754, 38.0893], [-122.53784, 38.08947], [-122.53812, 38.08967], [-122.54201, 38.09264], [-122.54214, 38.09272], [-122.54228, 38.09278], [-122.54243, 38.09282], [-122.5426, 38.09285], [-122.54276, 38.09285], [-122.54292, 38.09282], [-122.54308, 38.09278], [-122.54365, 38.09254], [-122.54418, 38.09237], [-122.54472, 38.09223], [-122.54588, 38.09203], [-122.54644, 38.09197], [-122.54672, 38.09198], [-122.547, 38.092], [-122.54728, 38.09205], [-122.54755, 38.09212], [-122.5479, 38.09223], [-122.54757, 38.09267], [-122.54778, 38.09278], [-122.54813, 38.09233], [-122.54838, 38.09246], [-122.54862, 38.09261], [-122.54883, 38.09277], [-122.54903, 38.09295], [-122.5492, 38.09314], [-122.54935, 38.09335], [-122.54948, 38.09356], [-122.55018, 38.09494], [-122.55026, 38.09517], [-122.55031, 38.09539], [-122.55036, 38.09576], [-122.55042, 38.09588], [-122.5505, 38.096], [-122.55061, 38.09611], [-122.55074, 38.09619], [-122.55088, 38.09626], [-122.55104, 38.09631], [-122.55121, 38.09633], [-122.55146, 38.09632], [-122.55563, 38.09543], [-122.55597, 38.09584], [-122.55612, 38.09581], [-122.55679, 38.09661], [-122.55677, 38.09667], [-122.55898, 38.09929], [-122.55951, 38.09996]], [[-122.54938, 38.09799], [-122.54938, 38.09798], [-122.54655, 38.09688], [-122.54664, 38.09628], [-122.54662, 38.09627], [-122.54651, 38.09694], [-122.54938, 38.09799]]]]} | Open Access 1 | 17572 | Marin County Flood Control | 6348 | 2072 | Marin Public Works Dept/Flood Control 945 | Special District 4 | Flood District 8 | http://www.marincounty.org/depts/pw/divisions/flood-control | Special District 4 | 2072 | Marin Public Works Dept/Flood Control 917 | Special District 4 | Flood District 9 | Marin 23 | 1294.68 | Marin County Flood Control | 0 | Local Other or Unknown 14 | 4 | |
3477 | 3477 | 3476 | {"type": "Polygon", "coordinates": [[[-121.48575, 38.69996], [-121.48446, 38.69997], [-121.48434, 38.68531], [-121.48562, 38.68532], [-121.48575, 38.69996]]]} | No Public Access 3 | 25814 | UEDA Parkway | 26644 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sacramento 41 | 45.052 | UEDA Parkway | 0 | Local Recreation Area 3 | 4 | |
12719 | 12719 | 12718 | {"type": "Polygon", "coordinates": [[[-121.57188, 38.7717], [-121.56259, 38.77184], [-121.56254, 38.76466], [-121.56254, 38.76083], [-121.56867, 38.76072], [-121.5687, 38.76451], [-121.57185, 38.76444], [-121.57188, 38.7717]]]} | No Public Access 3 | 29735 | Lucich Ranch | 21580 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 215.926 | Lucich Ranch | 0 | Local Other or Unknown 14 | 4 | |
12720 | 12720 | 12719 | {"type": "Polygon", "coordinates": [[[-121.58519, 38.73806], [-121.5843, 38.74056], [-121.58366, 38.74229], [-121.58355, 38.74272], [-121.58352, 38.74306], [-121.58331, 38.74329], [-121.5831, 38.74338], [-121.58271, 38.74346], [-121.57806, 38.7435], [-121.57789, 38.74347], [-121.57717, 38.7431], [-121.57692, 38.74306], [-121.5769, 38.73805], [-121.58519, 38.73806]]]} | No Public Access 3 | 29736 | Ruby Ranch | 24724 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 93.99 | Ruby Ranch | 0 | Local Other or Unknown 14 | 4 | |
13175 | 13175 | 13174 | {"type": "Polygon", "coordinates": [[[-121.57686, 38.77162], [-121.57188, 38.7717], [-121.57185, 38.76445], [-121.5687, 38.76451], [-121.56867, 38.76072], [-121.57182, 38.76066], [-121.57184, 38.76246], [-121.57684, 38.76237], [-121.57686, 38.77162]]]} | No Public Access 3 | 35159 | Lucich Ranch | 21580 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 138.582 | Lucich Ranch | 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]);