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 LAYER
This data as json, copyable, CSV (advanced)
MNG_AGENCY 213
- Mountains Recreation and Conservation Authority 152
- Ventura, City of 104
- 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
- California City, City of 25
- Los Angeles, City of 21
- 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 14
- 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
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Guadalupe, City of 10
- Santa Barbara, City of 9
- Santa Maria, City of 9
- San Lorenzo Valley Water District 9
- La Selva Beach Recreation District 8
- Watsonville, City of 7
- Scotts Valley, City of 7
- Torrance, City of 7
- San Luis Obispo, City of 6
- Sacramento, County of 6
- San Francisco - Public Utilities Commission, City and County of 5
- Salinas, City of 5
- Anaheim, City of 5
- Escondido, City of 5
- Ventura, County of 5
- Los Angeles - Department of Water and Power, City of 5
- Stockton, City of 5
- Santa Cruz, County of 4
- San Diego, County of 4
- San Marcos, City of 4
- Marina, City of 4
- Morgan Hill, City of 4
- Lincoln, City of 4
- Calistoga, City of 4
- Pleasanton, City of 3
- Marin County Open Space District 3
- Solvang, City of 3
- Tulare, County of 3
- Riverside, County of 3
- Moorpark, City of 3
- Woodlake, City of 3
- Reedley, City of 3
- Clovis, City of 3
- Gridley, City of 3
- Ripon, City of 3
- Scotts Valley Water District 3
- Natomas Basin Conservancy 3
- Rio Dell, City of 3
- Santa Clara Valley Water District 3
- Patterson, City of 2
- Monterey, City of 2
- Vista, City of 2
- Hayward Area Recreation and Park District 2
- Riverside County Regional Park and Open Space District 2
- Fountain Valley, City of 2
- Rancho Palos Verdes, City of 2
- Orange, City of 2
- Hanford, City of 2
- Sonoma, City of 2
- Imperial Irrigation District 2
- Pittsburg, City of 2
- Sonoma County Agricultural Preservation and Open Space District 2
- American Canyon, City of 2
- Merced, County of 2
- Modesto, City of 2
- Winters, City of 2
- Truckee Tahoe Airport District 2
- North County Recreation and Park District 2
- Stanton, City of 2
- Orange County Water District 2
- Westfield Recreation and Park District 2
- Ramona Municipal Water District 2
- Western Riverside County Regional Conservation Authority 2
- Fortuna, City of 2
- Oakdale, City of 1
- Seal Beach, City of 1
- Claremont, City of 1
- Conejo Recreation and Park District 1
- Fresno, City of 1
- Santa Ana, City of 1
- San Francisco, City and County of 1
- San Jose, City of 1
- Santee, City of 1
- Victorville, City of 1
- Monterey Peninsula Regional Park District 1
- Newport Beach, City of 1
- South San Francisco, City of 1
- Carpinteria, City of 1
- Oceanside, City of 1
- Coachella, City of 1
- Oxnard, City of 1
- Redlands, City of 1
- Napa County Regional Park and Open Space District 1
- Paso Robles, City of 1
- Chula Vista, City of 1
- Dana Point, City of 1
- Vacaville, City of 1
- Visalia, City of 1
- Fontana, City of 1
- Davis, City of 1
- Goleta, City of 1
- Laguna Beach, City of 1
- San Leandro, City of 1
- Loma Linda, City of 1
- Sonoma County Regional Parks Dept., County of 1
- Dos Palos, City of 1
- Fairfield, City of 1
- Placer, County of 1
- San Jacinto, City of 1
- Cerritos, City of 1
- Mill Valley, City of 1
- San Joaquin, City of 1
- Sanger, City of 1
- Lake Forest, City of 1
- Marin Municipal Water District 1
- Livermore, City of 1
- Tustin, City of 1
- Paramount, City of 1
- Whittier, City of 1
- Long Beach, City of 1
- Pasadena, City of 1
- South Pasadena, City of 1
- Tehachapi, City of 1
- Monrovia, City of 1
- Diamond Bar, City of 1
- Benicia, City of 1
- Imperial, County of 1
- Antioch, City of 1
- San Rafael, City of 1
- San Clemente, City of 1
- San Bernardino, County of 1
- Lemoore, City of 1
- Fremont, City of 1
- North of the River Recreation and Park District 1
- Burlingame, City of 1
- Concord, City of 1
- Redwood City, City of 1
- Redding, City of 1
- Metropolitan Water District of Southern California 1
- Sunnyvale, City of 1
- Parlier, City of 1
- Dixon, City of 1
- Corte Madera, Town of 1
- Foster City, City of 1
- Lomita, City of 1
- Atwater, City of 1
- Santa Clara Valley Open Space Authority 1
- Soledad, City of 1
- Red Bluff, City of 1
- Napa, County of 1
- Newman, City of 1
- Vallejo, City of 1
- Sacramento, City of 1
- Yolo, County of 1
- Woodland, City of 1
- Humboldt, County of 1
- Olivehurst Public Utility District 1
- Folsom, City of 1
- Riverside County Habitat Conservation Agency 1
- Tehama, County of 1
- Sacramento Regional County Sanitation District 1
- Soquel Creek Water District 1
- Calexico, City of 1
- Galt, City of 1
- Sacramento and San Joaquin Drainage District 1
- Brisbane, City of 1
- Coloma-Lotus 1
- Blue Lake, City of 1
- Trinidad, City of 1
- Fresno Metropolitan Flood Control District 1
- Williams, City of 1
- Ridgecrest, City of 1
- Borrego Water District 1
- Orange County Department of Education, County of 1
- Alameda County Flood Control and Water Conservation District 1
- Soledad-Mission Recreation District 1
- Helix Water District 1
- California Reclamation District 2140 1
- Point Arena, City of 1
- Georgetown Divide Recreation District 1
- Coalinga, City of 1
- Coachella Valley Association of Governments 1
- Watershed Conservation Authority 1
- Olivenhain Municipal Water District 1
- Coastside County Water District 1
- Marina County Water District 1
- Aptos Sanitation District 1
- Marin Public Works Dept/Flood Control 1
- Novato Sanitary District 1
- Santa Ynez River Water Conservation District 1
- Modesto Irrigation District 1
- Turlock Irrigation District 1
- Trinity, County of 1
- Marin, County of 1
- Solano, County of 1
- North County Transit District 1
- Pasadena Department of Water and Power 1
MNG_AG_TYP 15
- City Agency 643
- 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
ACCESS_TYP 4
- Open Access 854
- Unknown Access 201
- No Public Access 85
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2953 | 2953 | 2952 | {"type": "Polygon", "coordinates": [[[-117.88143, 33.70905], [-117.8815, 33.70906], [-117.88153, 33.70911], [-117.88152, 33.70962], [-117.88149, 33.70965], [-117.87994, 33.70965], [-117.88027, 33.70954], [-117.88143, 33.70905]]]} | Open Access 1 | 20418 | Segerstrom Triangle | 25286 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 1.234 | Segerstrom Triangle | 0 | Local Other or Unknown 14 | 4 | |
3050 | 3050 | 3049 | {"type": "MultiPolygon", "coordinates": [[[[-121.24452, 38.72086], [-121.24452, 38.72174], [-121.24392, 38.72198], [-121.24348, 38.72211], [-121.243, 38.72216], [-121.24087, 38.72215], [-121.24088, 38.72187], [-121.24142, 38.72131], [-121.24229, 38.72048], [-121.2424, 38.72035], [-121.24247, 38.72024], [-121.24255, 38.72001], [-121.24256, 38.71981], [-121.24243, 38.71901], [-121.24317, 38.71934], [-121.24452, 38.72086]]], [[[-121.24324, 38.72673], [-121.24287, 38.72694], [-121.24263, 38.72659], [-121.24242, 38.72641], [-121.24196, 38.72561], [-121.24212, 38.7254], [-121.24228, 38.7254], [-121.24235, 38.72544], [-121.24262, 38.72546], [-121.24261, 38.72582], [-121.24268, 38.72605], [-121.24282, 38.72626], [-121.24324, 38.72673]]], [[[-121.24705, 38.72776], [-121.24669, 38.72806], [-121.24614, 38.7276], [-121.24538, 38.7271], [-121.24461, 38.72713], [-121.24464, 38.72905], [-121.24408, 38.72926], [-121.24395, 38.72917], [-121.24386, 38.72913], [-121.24372, 38.7291], [-121.24358, 38.7291], [-121.24358, 38.72874], [-121.24324, 38.72824], [-121.24342, 38.72813], [-121.24353, 38.72797], [-121.24366, 38.72722], [-121.24366, 38.72705], [-121.24361, 38.7269], [-121.24353, 38.7268], [-121.2429, 38.72609], [-121.24281, 38.72588], [-121.2428, 38.7257], [-121.24283, 38.72526], [-121.24329, 38.72527], [-121.24334, 38.72506], [-121.2433, 38.72484], [-121.24337, 38.72448], [-121.24365, 38.72414], [-121.24385, 38.72389], [-121.24388, 38.72355], [-121.24381, 38.72292], [-121.24399, 38.72224], [-121.24462, 38.72224], [-121.24462, 38.72236], [-121.24444, 38.72249], [-121.24437, 38.72277], [-121.24432, 38.72287], [-121.2443, 38.72308], [-121.24453, 38.72352], [-121.24447, 38.72389], [-121.24432, 38.7242], [-121.24392, 38.72447], [-121.2439, 38.72451], [-121.24388, 38.72482], [-121.24387, 38.72589], [-121.24392, 38.72603], [-121.24398, 38.72612], [-121.2441, 38.72622], [-121.24423, 38.72622], [-121.24505, 38.72665], [-121.2456, 38.72668], [-121.2461, 38.72696], [-121.24705, 38.72776]]], [[[-121.24936, 38.72958], [-121.24879, 38.72974], [-121.24869, 38.72944], [-121.2471, 38.72837], [-121.24684, 38.72817], [-121.24721, 38.72788], [-121.24746, 38.72807], [-121.24913, 38.72919], [-121.24936, 38.72958]]]]} | Open Access 1 | 20932 | Flood Control | 18952 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 37.251 | Flood Control | 0 | Local Other or Unknown 14 | 4 | |
3416 | 3416 | 3415 | {"type": "Polygon", "coordinates": [[[-120.45474, 34.63166], [-120.45474, 34.63208], [-120.45449, 34.63208], [-120.45449, 34.6318], [-120.45474, 34.63166]]]} | Open Access 1 | 35325 | Lompoc holding 11 | 21422 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.216 | Lompoc holding 11 | 0 | Local Other or Unknown 14 | 4 | |
3435 | 3435 | 3434 | {"type": "Polygon", "coordinates": [[[-119.16407, 34.29454], [-119.16386, 34.29466], [-119.16329, 34.294], [-119.1635, 34.29388], [-119.16407, 34.29454]]]} | Open Access 1 | 35441 | Ventura holding 78 | 26960 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.529 | Ventura holding 78 | 0 | Local Other or Unknown 14 | 4 | |
3475 | 3475 | 3474 | {"type": "Polygon", "coordinates": [[[-117.81584, 35.18562], [-117.81582, 35.18618], [-117.8141, 35.18621], [-117.81412, 35.18564], [-117.81584, 35.18562]]]} | Open Access 1 | 35797 | California City holding 16 | 16696 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 2.424 | California City holding 16 | 0 | Local Other or Unknown 14 | 4 | |
3539 | 3539 | 3538 | {"type": "Polygon", "coordinates": [[[-121.3399, 38.77607], [-121.33948, 38.77588], [-121.33948, 38.77588], [-121.33969, 38.77582], [-121.3399, 38.77607]]]} | Open Access 1 | 36403 | Roseville holding 13 | 24631 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.081 | Roseville holding 13 | 0 | Local Other or Unknown 14 | 4 | |
3547 | 3547 | 3546 | {"type": "Polygon", "coordinates": [[[-121.32679, 38.76689], [-121.3266, 38.76689], [-121.3266, 38.76659], [-121.32679, 38.76659], [-121.32679, 38.76689]]]} | Open Access 1 | 36445 | Roseville holding 1 | 24627 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.139 | Roseville holding 1 | 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 | |
3580 | 3580 | 3579 | {"type": "Polygon", "coordinates": [[[-118.36897, 33.80456], [-118.36893, 33.80458], [-118.36878, 33.80431], [-118.36871, 33.80428], [-118.36847, 33.80438], [-118.36821, 33.80455], [-118.36778, 33.80419], [-118.3688, 33.8042], [-118.36897, 33.80456]]]} | Open Access 1 | 36686 | Torrance holding 28 | 26435 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.536 | Torrance holding 28 | 0 | Local Other or Unknown 14 | 4 | |
3581 | 3581 | 3580 | {"type": "Polygon", "coordinates": [[[-117.06669, 32.93389], [-117.06669, 32.93424], [-117.06636, 32.93423], [-117.06575, 32.93426], [-117.06303, 32.93451], [-117.06295, 32.93426], [-117.06337, 32.93406], [-117.06374, 32.93381], [-117.06492, 32.93381], [-117.06669, 32.93389]]]} | Open Access 1 | 36687 | Poway holding 30 | 23955 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 4.51 | Poway holding 30 | 0 | Local Other or Unknown 14 | 4 | |
3582 | 3582 | 3581 | {"type": "Polygon", "coordinates": [[[-118.32429, 33.80965], [-118.32389, 33.80965], [-118.32389, 33.80924], [-118.32429, 33.80924], [-118.32429, 33.80965]]]} | No Public Access 3 | 36688 | Empty Lot 237th and Vine | 29082 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.419 | Empty Lot 237th and Vine | 0 | Local Other or Unknown 14 | 4 | |
3584 | 3584 | 3583 | {"type": "Polygon", "coordinates": [[[-119.17467, 34.27812], [-119.17461, 34.27816], [-119.17442, 34.27794], [-119.17446, 34.27792], [-119.1745, 34.27793], [-119.17467, 34.27812]]]} | Open Access 1 | 36691 | Ventura holding 106 | 26859 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.046 | Ventura holding 106 | 0 | Local Other or Unknown 14 | 4 | |
3824 | 3824 | 3823 | {"type": "Polygon", "coordinates": [[[-121.82197, 36.58445], [-121.82053, 36.586], [-121.81948, 36.58511], [-121.81901, 36.58475], [-121.81625, 36.58287], [-121.81739, 36.58153], [-121.82197, 36.58445]]]} | Open Access 1 | 35230 | Monterey holding 1 | 22421 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 24.525 | Monterey holding 1 | 0 | Local Other or Unknown 14 | 4 | |
3829 | 3829 | 3828 | {"type": "Polygon", "coordinates": [[[-119.64094, 36.31958], [-119.63928, 36.31958], [-119.63927, 36.31834], [-119.64092, 36.31834], [-119.64094, 36.31958]]]} | Open Access 1 | 35315 | Hanford holding 2 | 19639 | 1129 | Hanford, City of 349 | City 2 | City Agency 2 | http://www.ci.hanford.ca.us/depts/rec/default.asp | City 2 | 1129 | Hanford, City of 346 | City 2 | City Agency 2 | Kings 44 | 5.018 | Hanford holding 2 | 0 | Local Other or Unknown 14 | 4 | |
3831 | 3831 | 3830 | {"type": "Polygon", "coordinates": [[[-119.21633, 34.28845], [-119.216, 34.28946], [-119.21597, 34.28964], [-119.21595, 34.2896], [-119.21596, 34.28948], [-119.21603, 34.28913], [-119.2163, 34.28845], [-119.21633, 34.28845]]]} | Open Access 1 | 35331 | Ventura holding 123 | 26878 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.146 | Ventura holding 123 | 0 | Local Other or Unknown 14 | 4 | |
3880 | 3880 | 3879 | {"type": "Polygon", "coordinates": [[[-118.98823, 37.63061], [-118.98823, 37.63113], [-118.98717, 37.63113], [-118.98717, 37.6306], [-118.98823, 37.63061]]]} | Open Access 1 | 36481 | Mammoth Lakes holding 4 | 21723 | 1355 | Mammoth Lakes, Town of 572 | City 2 | City Agency 2 | http://www.ci.mammoth-lakes.ca.us/index.aspx?NID=322 | City 2 | 1355 | Mammoth Lakes, Town of 564 | City 2 | City Agency 2 | Mono 32 | 1.35 | Mammoth Lakes holding 4 | 0 | Local Other or Unknown 14 | 4 | |
3886 | 3886 | 3885 | {"type": "Polygon", "coordinates": [[[-117.82685, 35.25106], [-117.82674, 35.25113], [-117.82627, 35.25163], [-117.82615, 35.25189], [-117.8261, 35.25307], [-117.82591, 35.25347], [-117.82372, 35.25348], [-117.82367, 35.25201], [-117.82381, 35.25191], [-117.82507, 35.25133], [-117.82579, 35.25117], [-117.82685, 35.25106]]]} | Open Access 1 | 35754 | California City holding 22 | 16703 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 12.685 | California City holding 22 | 0 | Local Other or Unknown 14 | 4 | |
3891 | 3891 | 3890 | {"type": "Polygon", "coordinates": [[[-117.09429, 33.13135], [-117.094, 33.13143], [-117.09383, 33.13102], [-117.09403, 33.13085], [-117.09407, 33.13095], [-117.09412, 33.13095], [-117.09429, 33.13135]]]} | No Public Access 3 | 642 | Reidy Canyon Creek | 24281 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 0.372 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
3896 | 3896 | 3895 | {"type": "Polygon", "coordinates": [[[-118.57142, 34.12782], [-118.57142, 34.12931], [-118.56528, 34.12931], [-118.5662, 34.12783], [-118.57142, 34.12782]]]} | Unknown Access 4 | 45829 | Steers Property | 28848 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 21.351 | Steers Property | 0 | Local Other or Unknown 14 | 4 | |
3937 | 3937 | 3936 | {"type": "Polygon", "coordinates": [[[-121.54941, 39.51629], [-121.54933, 39.51642], [-121.54896, 39.51663], [-121.5493, 39.51711], [-121.54902, 39.51728], [-121.54868, 39.51754], [-121.54854, 39.51757], [-121.54836, 39.5177], [-121.5483, 39.5178], [-121.54817, 39.51791], [-121.54785, 39.51803], [-121.54782, 39.51812], [-121.54772, 39.5182], [-121.54767, 39.51838], [-121.54759, 39.51845], [-121.54743, 39.51858], [-121.54739, 39.51863], [-121.54739, 39.51869], [-121.54719, 39.51869], [-121.5476, 39.51762], [-121.54795, 39.51685], [-121.54912, 39.5164], [-121.54871, 39.51678], [-121.54874, 39.51683], [-121.54926, 39.51634], [-121.54941, 39.51629]]]} | Open Access 1 | 36306 | Oroville holding 1 | 23210 | 1236 | Oroville, City of 503 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | Butte 42 | 3.965 | Oroville holding 1 | 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]);