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 SUID_NMA
This data as json, copyable, CSV (advanced)
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 38
- 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 657
- County Agency 212
- Open Space District 155
- Water District 69
- Flood District 31
- Recreation/Parks District 28
- County Agency - Other 6
- Sanitation District 3
- Irrigation District 2
- Community Services District 2
- County Agency - Parks 1
- Special District - Other 1
- Metropolitan Planning Organization 1
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 842
- Unknown Access 203
- No Public Access 95
- Restricted Access 30
DES_TP 1
- Local Other or Unknown · 1,170 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13914 | 13914 | 13913 | {"type": "Polygon", "coordinates": [[[-117.7455, 33.84239], [-117.74526, 33.84244], [-117.74511, 33.8425], [-117.74493, 33.84267], [-117.74482, 33.8429], [-117.74482, 33.84306], [-117.74493, 33.84329], [-117.74499, 33.84337], [-117.7443, 33.84341], [-117.74474, 33.84199], [-117.74489, 33.84174], [-117.74538, 33.84107], [-117.74549, 33.84113], [-117.7455, 33.84239]]]} | Open Access 1 | 36519 | Anaheim holding 2 | 15467 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 3.08 | Anaheim holding 2 | 0 | Local Other or Unknown 14 | 4 | |
3560 | 3560 | 3559 | {"type": "Polygon", "coordinates": [[[-117.97816, 33.85487], [-117.97665, 33.85405], [-117.97656, 33.85345], [-117.97814, 33.85344], [-117.97816, 33.85487]]]} | Open Access 1 | 36526 | Anaheim holding 3 | 15468 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 3.956 | Anaheim holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13937 | 13937 | 13936 | {"type": "Polygon", "coordinates": [[[-117.78356, 33.84518], [-117.78356, 33.84564], [-117.78066, 33.84564], [-117.78019, 33.84566], [-117.78021, 33.84548], [-117.78026, 33.84543], [-117.78065, 33.84536], [-117.78158, 33.84505], [-117.78172, 33.84502], [-117.78206, 33.84499], [-117.7823, 33.845], [-117.78247, 33.84499], [-117.78356, 33.84518]]]} | Open Access 1 | 36544 | Anaheim holding 4 | 15469 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 4.264 | Anaheim holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13679 | 13679 | 13678 | {"type": "Polygon", "coordinates": [[[-121.808, 38.01005], [-121.80799, 38.01113], [-121.80628, 38.0111], [-121.80617, 38.01105], [-121.80616, 38.01002], [-121.808, 38.01005]]]} | Open Access 1 | 36335 | Antioch holding 1 | 15524 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 4.788 | Antioch holding 1 | 0 | Local Other or Unknown 14 | 4 | |
11138 | 11138 | 11137 | {"type": "Polygon", "coordinates": [[[-121.29786, 38.49822], [-121.29733, 38.49802], [-121.2969, 38.49796], [-121.29661, 38.49799], [-121.29634, 38.49832], [-121.29629, 38.49874], [-121.29647, 38.49922], [-121.29644, 38.49953], [-121.29651, 38.49982], [-121.29676, 38.49992], [-121.29701, 38.49988], [-121.29784, 38.49901], [-121.29783, 38.50332], [-121.29735, 38.50321], [-121.29714, 38.50313], [-121.29689, 38.50305], [-121.29688, 38.50306], [-121.29691, 38.50315], [-121.29703, 38.50326], [-121.29748, 38.50354], [-121.29428, 38.50352], [-121.29385, 38.50329], [-121.29323, 38.50315], [-121.29275, 38.50326], [-121.29239, 38.50351], [-121.28867, 38.50348], [-121.28869, 38.50214], [-121.2923, 38.50215], [-121.29546, 38.49847], [-121.29544, 38.49627], [-121.29762, 38.49629], [-121.29774, 38.49637], [-121.29785, 38.49753], [-121.29786, 38.49822]], [[-121.29624, 38.50255], [-121.29625, 38.50254], [-121.29618, 38.50232], [-121.29606, 38.50211], [-121.29588, 38.50192], [-121.29566, 38.50176], [-121.29541, 38.50164], [-121.29512, 38.50157], [-121.29483, 38.50154], [-121.29453, 38.50156], [-121.29425, 38.50162], [-121.29398, 38.50173], [-121.29374, 38.50176], [-121.29351, 38.50182], [-121.2933, 38.50192], [-121.29313, 38.50205], [-121.293, 38.50219], [-121.29301, 38.5022], [-121.29326, 38.50215], [-121.29354, 38.50213], [-121.29382, 38.50215], [-121.29409, 38.50221], [-121.29464, 38.50225], [-121.29519, 38.50231], [-121.29572, 38.50242], [-121.29624, 38.50255]]]} | Restricted Access 2 | 21429 | Arroyo Seco (florin Mitigation Bank) | 15628 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 66.229 | Arroyo Seco (florin Mitigation Bank) | 0 | Local Other or Unknown 14 | 4 | |
9811 | 9811 | 9810 | {"type": "MultiPolygon", "coordinates": [[[[-119.78388, 34.43252], [-119.78345, 34.43278], [-119.78231, 34.43354], [-119.78143, 34.43378], [-119.78052, 34.4337], [-119.78052, 34.43358], [-119.78135, 34.43364], [-119.78158, 34.43361], [-119.78213, 34.43346], [-119.78241, 34.43332], [-119.78376, 34.43242], [-119.78381, 34.43241], [-119.78385, 34.43243], [-119.78388, 34.43248], [-119.78388, 34.43252]]], [[[-119.79498, 34.42774], [-119.79162, 34.42959], [-119.7874, 34.43078], [-119.78626, 34.43109], [-119.78625, 34.43108], [-119.78589, 34.43127], [-119.78408, 34.43239], [-119.78411, 34.4321], [-119.78448, 34.43201], [-119.78536, 34.43149], [-119.78544, 34.43143], [-119.7857, 34.43115], [-119.7862, 34.43068], [-119.78689, 34.43049], [-119.78694, 34.43059], [-119.79145, 34.42935], [-119.79203, 34.42903], [-119.79202, 34.42901], [-119.79462, 34.42757], [-119.79483, 34.42761], [-119.79498, 34.42774]]]]} | Unknown Access 4 | 16760 | Atascadero Creek | 15661 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 9.641 | Atascadero Creek | 0 | Local Other or Unknown 14 | 4 | |
13792 | 13792 | 13791 | {"type": "Polygon", "coordinates": [[[-120.60175, 37.3593], [-120.60132, 37.35982], [-120.60126, 37.35998], [-120.60081, 37.36], [-120.60081, 37.35938], [-120.59996, 37.35936], [-120.60049, 37.35872], [-120.60085, 37.3589], [-120.60101, 37.35891], [-120.60175, 37.3593]]]} | Open Access 1 | 36357 | Atwater holding 2 | 15679 | 1014 | Atwater, City of 470 | City 2 | City Agency 2 | http://www.atwater.org/index.cfm?page=940884 | City 2 | 1014 | Atwater, City of 463 | City 2 | City Agency 2 | Merced 37 | 2.533 | Atwater holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13847 | 13847 | 13846 | {"type": "Polygon", "coordinates": [[[-121.05862, 38.90419], [-121.05816, 38.90434], [-121.05815, 38.90405], [-121.05815, 38.90405], [-121.05862, 38.90419]]]} | Open Access 1 | 36436 | Auburn holding 10 | 15684 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 0.161 | Auburn holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13848 | 13848 | 13847 | {"type": "Polygon", "coordinates": [[[-121.08066, 38.87675], [-121.08053, 38.87701], [-121.08034, 38.87728], [-121.08037, 38.87647], [-121.08047, 38.87655], [-121.08059, 38.87661], [-121.08066, 38.87675]]]} | Open Access 1 | 36437 | Auburn holding 11 | 15685 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 0.336 | Auburn holding 11 | 0 | Local Other or Unknown 14 | 4 | |
6980 | 6980 | 6979 | {"type": "Polygon", "coordinates": [[[-121.07455, 38.91293], [-121.07438, 38.9135], [-121.07415, 38.91404], [-121.07387, 38.91393], [-121.07445, 38.91293], [-121.07455, 38.91293]]]} | Open Access 1 | 36393 | Auburn holding 12 | 15686 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 0.588 | Auburn holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13822 | 13822 | 13821 | {"type": "Polygon", "coordinates": [[[-121.07768, 38.92039], [-121.07754, 38.9204], [-121.07755, 38.92127], [-121.0773, 38.92127], [-121.07737, 38.92103], [-121.07736, 38.92101], [-121.07719, 38.92103], [-121.07719, 38.92109], [-121.07713, 38.92111], [-121.07714, 38.92128], [-121.07702, 38.92128], [-121.07712, 38.92095], [-121.07715, 38.92092], [-121.07729, 38.92087], [-121.07735, 38.92082], [-121.07736, 38.92077], [-121.07735, 38.92072], [-121.0773, 38.92066], [-121.07722, 38.92063], [-121.07711, 38.92064], [-121.07708, 38.92058], [-121.07713, 38.92045], [-121.07718, 38.92045], [-121.07722, 38.92033], [-121.07727, 38.92033], [-121.07731, 38.92021], [-121.07709, 38.92016], [-121.07684, 38.92039], [-121.07669, 38.92064], [-121.07656, 38.92109], [-121.07649, 38.92135], [-121.07674, 38.9214], [-121.07666, 38.92146], [-121.07611, 38.92137], [-121.07608, 38.92142], [-121.07598, 38.92134], [-121.07616, 38.92133], [-121.07623, 38.92106], [-121.07624, 38.92093], [-121.07627, 38.92081], [-121.07643, 38.92045], [-121.07624, 38.92037], [-121.07635, 38.9203], [-121.07639, 38.92021], [-121.07638, 38.92016], [-121.07634, 38.92012], [-121.07623, 38.92006], [-121.07768, 38.92011], [-121.07768, 38.92039]]]} | Open Access 1 | 36408 | Auburn holding 15 | 15687 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 2.423 | Auburn holding 15 | 0 | Local Other or Unknown 14 | 4 | |
13823 | 13823 | 13822 | {"type": "Polygon", "coordinates": [[[-121.08677, 38.89466], [-121.08652, 38.89464], [-121.08619, 38.89452], [-121.08587, 38.89452], [-121.0854, 38.89474], [-121.0851, 38.89477], [-121.08481, 38.89497], [-121.0847, 38.89492], [-121.0847, 38.89455], [-121.0849, 38.89462], [-121.08509, 38.89464], [-121.08529, 38.89461], [-121.08582, 38.89446], [-121.08602, 38.89446], [-121.08627, 38.89453], [-121.08642, 38.89454], [-121.08661, 38.89453], [-121.08677, 38.89448], [-121.08677, 38.89466]]]} | Open Access 1 | 36409 | Auburn holding 2 | 15688 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 0.645 | Auburn holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13821 | 13821 | 13820 | {"type": "Polygon", "coordinates": [[[-121.07622, 38.92006], [-121.07609, 38.92012], [-121.07601, 38.92022], [-121.07595, 38.92022], [-121.07592, 38.92017], [-121.07559, 38.92029], [-121.07548, 38.9206], [-121.07546, 38.921], [-121.07543, 38.92102], [-121.0752, 38.92085], [-121.07501, 38.92076], [-121.0748, 38.92069], [-121.07445, 38.92065], [-121.07443, 38.92062], [-121.07603, 38.92005], [-121.07622, 38.92006]]]} | Open Access 1 | 36407 | Auburn holding 3 | 15689 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 1.045 | Auburn holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13816 | 13816 | 13815 | {"type": "Polygon", "coordinates": [[[-121.07732, 38.92248], [-121.07544, 38.92192], [-121.07547, 38.92184], [-121.07521, 38.92155], [-121.0753, 38.9215], [-121.07565, 38.9219], [-121.07607, 38.92204], [-121.07616, 38.92189], [-121.07599, 38.92182], [-121.07585, 38.92174], [-121.07553, 38.92138], [-121.07557, 38.92136], [-121.07588, 38.9217], [-121.07602, 38.92179], [-121.07619, 38.92184], [-121.07644, 38.92185], [-121.07663, 38.92181], [-121.07679, 38.92172], [-121.0769, 38.92161], [-121.07689, 38.92174], [-121.07681, 38.92176], [-121.07683, 38.92182], [-121.07675, 38.92184], [-121.07667, 38.92184], [-121.07657, 38.92187], [-121.07657, 38.92192], [-121.07644, 38.92194], [-121.07636, 38.92194], [-121.07636, 38.9219], [-121.07628, 38.9219], [-121.07628, 38.92208], [-121.0767, 38.92208], [-121.07688, 38.92201], [-121.07687, 38.92228], [-121.07732, 38.92248]]]} | Open Access 1 | 36396 | Auburn holding 4 | 15690 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 0.852 | Auburn holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13815 | 13815 | 13814 | {"type": "Polygon", "coordinates": [[[-121.06796, 38.91452], [-121.06786, 38.91488], [-121.06781, 38.91546], [-121.06771, 38.91566], [-121.06759, 38.91586], [-121.06684, 38.91547], [-121.06705, 38.91525], [-121.0673, 38.91486], [-121.06742, 38.91459], [-121.06751, 38.91431], [-121.06766, 38.91425], [-121.06796, 38.91452]]]} | Open Access 1 | 36395 | Auburn holding 5 | 15691 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 2.176 | Auburn holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13817 | 13817 | 13816 | {"type": "Polygon", "coordinates": [[[-121.0847, 38.89492], [-121.08439, 38.89476], [-121.08419, 38.89442], [-121.08415, 38.89417], [-121.08429, 38.89401], [-121.08458, 38.89399], [-121.0847, 38.89432], [-121.0847, 38.89492]]]} | Open Access 1 | 36397 | Auburn holding 6 | 15692 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 0.854 | Auburn holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13814 | 13814 | 13813 | {"type": "Polygon", "coordinates": [[[-121.07756, 38.92258], [-121.07732, 38.92248], [-121.07742, 38.92234], [-121.07742, 38.92232], [-121.077, 38.9222], [-121.07694, 38.92231], [-121.07687, 38.92227], [-121.07688, 38.92201], [-121.07707, 38.92191], [-121.0772, 38.92173], [-121.0771, 38.92156], [-121.07694, 38.92161], [-121.07699, 38.92173], [-121.07689, 38.92174], [-121.0769, 38.92159], [-121.07696, 38.92151], [-121.07702, 38.92128], [-121.07714, 38.92128], [-121.07707, 38.92131], [-121.07709, 38.92143], [-121.07726, 38.92142], [-121.0773, 38.92128], [-121.07755, 38.92127], [-121.07756, 38.92258]]]} | Open Access 1 | 36394 | Auburn holding 8 | 15693 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 1.363 | Auburn holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13845 | 13845 | 13844 | {"type": "Polygon", "coordinates": [[[-121.0945, 38.95298], [-121.0945, 38.95481], [-121.09334, 38.9548], [-121.09334, 38.95298], [-121.0945, 38.95298]]]} | Open Access 1 | 36434 | Auburn holding 9 | 15694 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 1015 | Auburn, City of 824 | City 2 | City Agency 2 | Placer 35 | 5.036 | Auburn holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13647 | 13647 | 13646 | {"type": "Polygon", "coordinates": [[[-122.15828, 38.05398], [-122.15776, 38.05473], [-122.1558, 38.05383], [-122.1562, 38.05302], [-122.15828, 38.05398]]]} | Open Access 1 | 36331 | Benicia holding 1 | 16011 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 4.824 | Benicia holding 1 | 0 | Local Other or Unknown 14 | 4 | |
5870 | 5870 | 5869 | {"type": "Polygon", "coordinates": [[[-121.86762, 37.40876], [-121.8673, 37.40914], [-121.86705, 37.40917], [-121.86399, 37.40917], [-121.86362, 37.40915], [-121.86337, 37.40916], [-121.863, 37.40924], [-121.86265, 37.4094], [-121.86231, 37.40952], [-121.86218, 37.40956], [-121.86184, 37.4096], [-121.86169, 37.40964], [-121.86155, 37.40971], [-121.86142, 37.4098], [-121.86128, 37.40993], [-121.86122, 37.40996], [-121.86119, 37.41], [-121.86101, 37.41017], [-121.86085, 37.41039], [-121.86069, 37.4107], [-121.86053, 37.41085], [-121.86026, 37.41105], [-121.86008, 37.41115], [-121.85954, 37.41138], [-121.85917, 37.41151], [-121.85895, 37.41163], [-121.85883, 37.41174], [-121.85854, 37.41212], [-121.85837, 37.41242], [-121.85817, 37.41268], [-121.85801, 37.41296], [-121.85746, 37.41395], [-121.85741, 37.4141], [-121.85738, 37.41423], [-121.85732, 37.41436], [-121.85723, 37.41449], [-121.85708, 37.41462], [-121.85698, 37.41475], [-121.85678, 37.41508], [-121.85672, 37.41513], [-121.85655, 37.41521], [-121.85633, 37.4156], [-121.85611, 37.41527], [-121.85724, 37.4133], [-121.85729, 37.41313], [-121.8575, 37.41286], [-121.8579, 37.41214], [-121.85814, 37.41177], [-121.85844, 37.41144], [-121.85879, 37.41114], [-121.85895, 37.41104], [-121.85941, 37.41081], [-121.85915, 37.41044], [-121.85829, 37.40994], [-121.85823, 37.40999], [-121.85769, 37.40992], [-121.85757, 37.41], [-121.85719, 37.40977], [-121.85797, 37.40946], [-121.85839, 37.40936], [-121.8588, 37.40923], [-121.86014, 37.40863], [-121.86019, 37.40864], [-121.86022, 37.40866], [-121.8607, 37.40934], [-121.86073, 37.40944], [-121.86081, 37.40948], [-121.86088, 37.40948], [-121.86091, 37.40951], [-121.86099, 37.40945], [-121.86144, 37.40924], [-121.86179, 37.40915], [-121.86219, 37.4091], [-121.8623, 37.40906], [-121.86258, 37.40891], [-121.86276, 37.40884], [-121.86297, 37.40878], [-121.86331, 37.40874], [-121.86363, 37.40875], [-121.8642, 37.40879], [-121.86683, 37.40879], [-121.86725, 37.40881], [-121.86762, 37.40876]]]} | Open Access 1 | 246 | Berryessa Creek | 16036 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 25.184 | Berryessa Creek | 1979 | 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]);