units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 8,456
- State Agency 1,051
- Recreation/Parks District 1,038
- County Agency 1,013
- Non Profit - Land Trust 543
- Federal Agency 445
- Open Space District 394
- Water District 222
- County Agency - Parks 214
- Community Services District 190
- Home Owners Association 187
- Non Profit - Conservation 140
- Flood District 98
- Non Profit - Other 43
- Irrigation District 39
- School District 37
- Cemetery District 34
- County Agency - Other 28
- Port/Harbor District 28
- Special District - Other 15
- Commercial 14
- Sanitation District 7
- Joint Powers Authority 7
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 449
- California Department of Fish and Wildlife 405
- Los Angeles, City of 387
- California Department of Parks and Recreation 354
- Mountains Recreation and Conservation Authority 320
- Sacramento, City of 208
- San Jose, City of 193
- San Francisco, City and County of 164
- East Bay Regional Park District 162
- Los Angeles, County of 139
- Ventura, City of 132
- Roseville, City of 127
- Long Beach, City of 123
- Oakland, City of 102
- San Diego, County of 102
- United States Bureau of Land Management 98
- United States Forest Service 98
- Santa Barbara, County of 96
- Consumnes Community Services District 94
- California State Lands Commission 81
- Napa, City of 80
- Orange, County of 79
- United States Fish and Wildlife Service 77
- United States National Park Service 73
- Irvine, City of 73
- Modesto, City of 71
- Hayward Area Recreation and Park District 68
- Tracy, City of 65
- Valley-Wide Recreation and Park District 64
- Davis, City of 64
- …
DES_TP >30
- Local Park 7,361
- Local Recreation Area 1,778
- Local Other or Unknown 1,155
- Private Conservation 569
- Local Conservation Area 428
- State Conservation Area 354
- Private Recreation or Education 247
- State Park 193
- State Resource Management Area 147
- State Recreation Area 132
- National Forest 85
- Local Historic or Cultural Area 74
- National Wildlife Refuge 70
- State Other or Unknown 67
- State Historic or Cultural Area 61
- National Public Lands 55
- Recreation Management Area 52
- Private Other or Unknown 51
- National Monument or Landmark 37
- National Recreation Area 34
- National Park 22
- Resource Management Area 22
- Federal Other or Unknown 22
- Local Resource Management Area 21
- Conservation Area 12
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 5
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
LAYER 14 ✖
- City 8,333
- Special District 2,151
- County 1,221
- Non Governmental Organization 714
- Other State 409
- California Department of Fish and Wildlife 362
- California Department of Parks and Recreation 327
- Private 248
- Other Federal 129
- US Bureau of Land Management 119
- US Forest Service 102
- National Park Service 78
- US Fish and Wildlife Service 74
- US Military/Defense 9
ACCESS_TYP 4
- Open Access 11,932
- Restricted Access 1,095
- No Public Access 881
- Unknown Access 368
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2793 | 2793 | 2792 | {"type": "Polygon", "coordinates": [[[-121.76676, 36.92508], [-121.76492, 36.92663], [-121.7632, 36.92467], [-121.76454, 36.92389], [-121.76432, 36.92363], [-121.76487, 36.92332], [-121.76462, 36.92303], [-121.76486, 36.92289], [-121.76531, 36.92344], [-121.76676, 36.92508]]]} | Open Access 1 | 18569 | Pioneer Cemetery | 23711 | 2107 | Pajaro Valley Public Cemetery District 554 | Special District 4 | Cemetery District 11 | Special District 4 | 2107 | Pajaro Valley Public Cemetery District 547 | Special District 4 | Cemetery District 11 | Santa Cruz 5 | 15.079 | Pioneer Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
2794 | 2794 | 2793 | {"type": "MultiPolygon", "coordinates": [[[[-120.97132, 37.66022], [-120.97118, 37.66023], [-120.97109, 37.66025], [-120.97108, 37.65921], [-120.97126, 37.65948], [-120.97137, 37.65961], [-120.97162, 37.65984], [-120.97177, 37.65994], [-120.97209, 37.66011], [-120.97244, 37.66023], [-120.97292, 37.66036], [-120.97295, 37.6604], [-120.97281, 37.66074], [-120.9727, 37.66088], [-120.97261, 37.66095], [-120.9725, 37.66102], [-120.97231, 37.66108], [-120.97218, 37.6611], [-120.97184, 37.6611], [-120.97182, 37.66109], [-120.9718, 37.66106], [-120.97179, 37.66059], [-120.97175, 37.66045], [-120.97167, 37.66036], [-120.97157, 37.66029], [-120.97145, 37.66024], [-120.97132, 37.66022]]], [[[-120.97548, 37.65992], [-120.97549, 37.66111], [-120.97547, 37.66114], [-120.97544, 37.66115], [-120.97541, 37.66114], [-120.97529, 37.661], [-120.97515, 37.66089], [-120.975, 37.66078], [-120.97467, 37.66059], [-120.9743, 37.66046], [-120.97238, 37.65995], [-120.97223, 37.65989], [-120.97195, 37.65974], [-120.97171, 37.65955], [-120.9716, 37.65944], [-120.97143, 37.65921], [-120.97131, 37.65896], [-120.97127, 37.65883], [-120.97123, 37.65856], [-120.97439, 37.65856], [-120.9744, 37.65991], [-120.97548, 37.65992]]]]} | Open Access 1 | 18570 | Downey Community Park | 18254 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 16.389 | Downey Community Park | 0 | Local Park 2 | 4 | |
2795 | 2795 | 2794 | {"type": "Polygon", "coordinates": [[[-121.84621, 38.45144], [-121.84632, 38.45163], [-121.84634, 38.4519], [-121.84631, 38.45227], [-121.84622, 38.45247], [-121.84596, 38.45276], [-121.84502, 38.45261], [-121.84451, 38.45267], [-121.84414, 38.4528], [-121.84395, 38.45265], [-121.84375, 38.45206], [-121.84371, 38.45182], [-121.8439, 38.4516], [-121.84483, 38.45168], [-121.84562, 38.45164], [-121.84621, 38.45144]]]} | Open Access 1 | 18574 | Patwin Park | 23524 | 1087 | Dixon, City of 426 | City 2 | City Agency 2 | http://www.ci.dixon.ca.us/ | City 2 | 1087 | Dixon, City of 420 | City 2 | City Agency 2 | Solano 26 | 6.284 | Patwin Park | 0 | Local Park 2 | 4 | |
2796 | 2796 | 2795 | {"type": "Polygon", "coordinates": [[[-120.44383, 34.64848], [-120.44381, 34.64997], [-120.44255, 34.64995], [-120.44256, 34.64847], [-120.44383, 34.64848]]]} | Open Access 1 | 18575 | Pioneer Park | 23724 | 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 | 4.712 | Pioneer Park | 0 | Local Park 2 | 4 | |
2797 | 2797 | 2796 | {"type": "Polygon", "coordinates": [[[-121.55314, 39.00936], [-121.55263, 39.01017], [-121.55221, 39.01115], [-121.5521, 39.01187], [-121.55057, 39.01169], [-121.55045, 39.01165], [-121.55045, 39.01154], [-121.55051, 39.01116], [-121.55068, 39.01048], [-121.55082, 39.01006], [-121.55095, 39.00982], [-121.55162, 39.0088], [-121.55167, 39.00876], [-121.55171, 39.00877], [-121.55314, 39.00936]]]} | Open Access 1 | 21685 | Rio Del Oro Park Site | 24378 | 2101 | Olivehurst Public Utility District 555 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | Yuba 25 | 11.671 | Rio Del Oro Park Site | 0 | Local Park 2 | 4 | |
2798 | 2798 | 2797 | {"type": "Polygon", "coordinates": [[[-118.07956, 33.86085], [-118.07681, 33.86088], [-118.07678, 33.85867], [-118.07681, 33.85862], [-118.0788, 33.8586], [-118.07871, 33.8587], [-118.07874, 33.85878], [-118.07884, 33.85886], [-118.07911, 33.85896], [-118.07955, 33.85959], [-118.07956, 33.86085]]]} | Open Access 1 | 18581 | Artesia Park | 15639 | 1010 | Artesia, City of 556 | City 2 | City Agency 2 | http://www.cityofartesia.us/index.aspx?nid=127 | City 2 | 1010 | Artesia, City of 549 | City 2 | City Agency 2 | Los Angeles 6 | 14.786 | Artesia Park | 0 | Local Park 2 | 4 | |
2799 | 2799 | 2798 | {"type": "MultiPolygon", "coordinates": [[[[-117.05969, 32.76384], [-117.05963, 32.76392], [-117.05829, 32.76395], [-117.05834, 32.7639], [-117.05835, 32.76382], [-117.05963, 32.76378], [-117.05966, 32.76379], [-117.05969, 32.76384]]], [[[-117.06115, 32.76232], [-117.06114, 32.76248], [-117.06111, 32.76257], [-117.06106, 32.76264], [-117.06009, 32.76351], [-117.06004, 32.76235], [-117.06115, 32.76232]]]]} | Restricted Access 2 | 18582 | Clay Neighborhood Park | 31592 | 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 | 2.413 | Clay Neighborhood Park | 0 | Local Park 2 | 4 | |
2800 | 2800 | 2799 | {"type": "Polygon", "coordinates": [[[-118.62165, 34.10163], [-118.62148, 34.10166], [-118.62143, 34.10159], [-118.62157, 34.10153], [-118.62165, 34.10163]]]} | No Public Access 3 | 12515 | 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.042 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
2801 | 2801 | 2800 | {"type": "Polygon", "coordinates": [[[-118.32488, 34.26118], [-118.32485, 34.26121], [-118.32482, 34.26122], [-118.32268, 34.26137], [-118.32225, 34.26137], [-118.32224, 34.26139], [-118.32064, 34.26139], [-118.32037, 34.26157], [-118.32005, 34.26185], [-118.31993, 34.26192], [-118.3198, 34.26196], [-118.31972, 34.26196], [-118.31964, 34.26193], [-118.3196, 34.26184], [-118.31962, 34.26176], [-118.31982, 34.26152], [-118.32, 34.2612], [-118.32007, 34.26115], [-118.32019, 34.26111], [-118.3202, 34.25982], [-118.32072, 34.25982], [-118.32073, 34.25985], [-118.32201, 34.25986], [-118.3222, 34.25989], [-118.32223, 34.25993], [-118.32225, 34.25989], [-118.3224, 34.25993], [-118.32269, 34.26004], [-118.32485, 34.26112], [-118.32487, 34.26114], [-118.32488, 34.26118]]]} | Open Access 1 | 14571 | Sunland Park | 26001 | 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 | 14.336 | Sunland Park | 0 | Local Park 2 | 4 | |
2802 | 2802 | 2801 | {"type": "Polygon", "coordinates": [[[-121.60581, 37.02401], [-121.60433, 37.02404], [-121.60401, 37.0238], [-121.60443, 37.02348], [-121.60456, 37.02333], [-121.60468, 37.02314], [-121.60521, 37.02315], [-121.60571, 37.02308], [-121.60575, 37.0231], [-121.60577, 37.02314], [-121.60578, 37.02363], [-121.60573, 37.02371], [-121.60573, 37.02376], [-121.60575, 37.02382], [-121.60581, 37.02387], [-121.60581, 37.02401]]]} | Open Access 1 | 14572 | Del Rey Park | 18052 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | Santa Clara 19 | 3.122 | Del Rey Park | 0 | Local Park 2 | 4 | |
2803 | 2803 | 2802 | {"type": "Polygon", "coordinates": [[[-118.37097, 34.13187], [-118.37053, 34.13214], [-118.36993, 34.13183], [-118.37013, 34.13145], [-118.37097, 34.13187]]]} | No Public Access 3 | 12817 | Los Angeles City Water Resource Parkland | 21477 | 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 | 0.89 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
2804 | 2804 | 2803 | {"type": "Polygon", "coordinates": [[[-117.53379, 33.9259], [-117.53312, 33.92591], [-117.53313, 33.92683], [-117.53242, 33.92684], [-117.53239, 33.92687], [-117.53234, 33.92681], [-117.53223, 33.92658], [-117.53218, 33.92639], [-117.53209, 33.92639], [-117.53184, 33.92645], [-117.53182, 33.9264], [-117.532, 33.92637], [-117.53213, 33.92633], [-117.53221, 33.92621], [-117.53224, 33.92612], [-117.53228, 33.92603], [-117.53241, 33.92588], [-117.53241, 33.92578], [-117.53243, 33.92572], [-117.53255, 33.92559], [-117.53271, 33.92553], [-117.53277, 33.92553], [-117.53304, 33.92564], [-117.53305, 33.9258], [-117.53379, 33.92579], [-117.53379, 33.9259]]]} | Open Access 1 | 47394 | The Basin | 31118 | 1395 | Norco, City of 114 | City 2 | City Agency 2 | http://www.norco.ca.us/depts/parks/default.asp | City 2 | 1395 | Norco, City of 111 | City 2 | City Agency 2 | http://www.norco.ca.us/depts/parks/facilities/parks/basin.asp | Riverside 10 | 2.811 | The Basin | None 232 | ||
2805 | 2805 | 2804 | {"type": "Polygon", "coordinates": [[[-121.65616, 36.72516], [-121.65615, 36.7258], [-121.65563, 36.7258], [-121.65567, 36.72576], [-121.65568, 36.72571], [-121.65567, 36.72566], [-121.65564, 36.72561], [-121.6556, 36.72559], [-121.65553, 36.72558], [-121.65543, 36.7256], [-121.65542, 36.72514], [-121.65612, 36.72513], [-121.65616, 36.72516]]]} | Open Access 1 | 938 | Soto Square Park | 25632 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 1.073 | Soto Square Park | 0 | Local Park 2 | 4 | |
2806 | 2806 | 2805 | {"type": "Polygon", "coordinates": [[[-117.8549, 33.90262], [-117.85489, 33.90263], [-117.85489, 33.90365], [-117.85488, 33.90368], [-117.85485, 33.9037], [-117.8548, 33.90371], [-117.85408, 33.90372], [-117.85407, 33.90354], [-117.85392, 33.90352], [-117.85392, 33.90293], [-117.85281, 33.90294], [-117.8528, 33.90275], [-117.85194, 33.90278], [-117.85194, 33.90283], [-117.85131, 33.90283], [-117.85131, 33.90249], [-117.85107, 33.90249], [-117.85107, 33.9022], [-117.85067, 33.90219], [-117.85067, 33.90204], [-117.85489, 33.902], [-117.8549, 33.90262]]]} | Open Access 1 | 940 | George J. Koch Park | 19268 | 1255 | Placentia, City of 241 | City 2 | City Agency 2 | http://www.placentia.org/ | City 2 | 1255 | Placentia, City of 237 | City 2 | City Agency 2 | Orange 3 | 10.057 | George J. Koch Park | 0 | Local Park 2 | 4 | |
2807 | 2807 | 2806 | {"type": "Polygon", "coordinates": [[[-119.01383, 34.23215], [-119.01366, 34.23232], [-119.01347, 34.23245], [-119.01309, 34.23283], [-119.01304, 34.23285], [-119.01299, 34.23284], [-119.0099, 34.23064], [-119.00988, 34.23061], [-119.00988, 34.23057], [-119.01061, 34.22986], [-119.01383, 34.23215]]]} | Open Access 1 | 18618 | Pitts Ranch Park | 23748 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 10.421 | Pitts Ranch Park | 0 | Local Park 2 | 4 | |
2808 | 2808 | 2807 | {"type": "MultiPolygon", "coordinates": [[[[-117.07778, 33.0469], [-117.0777, 33.04805], [-117.07744, 33.04827], [-117.07733, 33.04853], [-117.07686, 33.04884], [-117.07613, 33.04995], [-117.07575, 33.05041], [-117.07551, 33.0502], [-117.07465, 33.04958], [-117.07443, 33.04938], [-117.07427, 33.0492], [-117.07411, 33.04898], [-117.07399, 33.04877], [-117.07384, 33.04837], [-117.0738, 33.04801], [-117.07377, 33.04761], [-117.0738, 33.04658], [-117.07388, 33.04658], [-117.07394, 33.04656], [-117.074, 33.04652], [-117.07403, 33.04647], [-117.07419, 33.04588], [-117.0744, 33.04536], [-117.0744, 33.04531], [-117.07438, 33.04525], [-117.07435, 33.04521], [-117.07429, 33.04517], [-117.07454, 33.04485], [-117.07512, 33.04473], [-117.07581, 33.04506], [-117.07646, 33.04577], [-117.07681, 33.04619], [-117.07765, 33.04667], [-117.07778, 33.0469]]], [[[-117.07436, 33.04534], [-117.07414, 33.04587], [-117.07398, 33.04646], [-117.07396, 33.0465], [-117.07391, 33.04652], [-117.0738, 33.04654], [-117.07384, 33.04615], [-117.07391, 33.04587], [-117.07407, 33.0455], [-117.07425, 33.04521], [-117.07434, 33.04526], [-117.07436, 33.04534]]]]} | Open Access 1 | 18642 | Rancho Bernardo Community Park | 24129 | 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 | 38.443 | Rancho Bernardo Community Park | 0 | Local Park 2 | 4 | |
2809 | 2809 | 2808 | {"type": "Polygon", "coordinates": [[[-121.01348, 37.6259], [-121.01188, 37.6259], [-121.01185, 37.62423], [-121.01345, 37.62422], [-121.01348, 37.6259]]]} | Open Access 1 | 18652 | James Marshall Park | 20349 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 6.525 | James Marshall Park | 0 | Local Park 2 | 4 | |
2810 | 2810 | 2809 | {"type": "Polygon", "coordinates": [[[-119.69855, 34.4095], [-119.69842, 34.40964], [-119.69608, 34.40791], [-119.69508, 34.40884], [-119.69458, 34.40847], [-119.69487, 34.4083], [-119.69505, 34.40813], [-119.69526, 34.40776], [-119.69509, 34.40772], [-119.69496, 34.40802], [-119.69475, 34.40822], [-119.69446, 34.40838], [-119.69407, 34.4081], [-119.69422, 34.40794], [-119.69435, 34.40773], [-119.69444, 34.4075], [-119.69448, 34.40738], [-119.69474, 34.40743], [-119.69492, 34.40763], [-119.6955, 34.40754], [-119.6957, 34.40752], [-119.69614, 34.40772], [-119.69676, 34.40788], [-119.69747, 34.40846], [-119.69826, 34.40917], [-119.6982, 34.40924], [-119.69855, 34.4095]]]} | Open Access 1 | 18644 | Plaza del Mar Park | 23779 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 6.277 | Plaza del Mar Park | 0 | Local Park 2 | 4 | |
2811 | 2811 | 2810 | {"type": "Polygon", "coordinates": [[[-119.14865, 35.67453], [-119.1475, 35.67452], [-119.1475, 35.67402], [-119.14865, 35.67402], [-119.14865, 35.67453]]]} | Open Access 1 | 14786 | United States Bureau of Reclamation | 13858 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Kern 36 | 1.453 | United States Bureau of Reclamation | 0 | Federal Other or Unknown 87 | 4 | |
2812 | 2812 | 2811 | {"type": "MultiPolygon", "coordinates": [[[[-119.22941, 35.67311], [-119.22913, 35.67312], [-119.22913, 35.67358], [-119.22923, 35.67359], [-119.22923, 35.67373], [-119.22912, 35.67374], [-119.22912, 35.67385], [-119.22897, 35.67375], [-119.22887, 35.67372], [-119.22875, 35.6737], [-119.22825, 35.67369], [-119.22816, 35.67366], [-119.22806, 35.67345], [-119.2279, 35.67321], [-119.22781, 35.67312], [-119.22763, 35.67299], [-119.22755, 35.67296], [-119.22737, 35.67286], [-119.22682, 35.67274], [-119.22666, 35.67268], [-119.22653, 35.67252], [-119.22634, 35.67196], [-119.22801, 35.67193], [-119.22821, 35.67195], [-119.2294, 35.67193], [-119.22941, 35.67311]]], [[[-119.22712, 35.67297], [-119.2266, 35.673], [-119.22648, 35.67275], [-119.22661, 35.67283], [-119.22677, 35.67289], [-119.22712, 35.67297]]]]} | Open Access 1 | 12861 | McFarland Park | 22031 | 2075 | McFarland Recreation and Park District 557 | Special District 4 | Recreation/Parks District 4 | http://www.mcfarlandrpd.com/ | Special District 4 | 2075 | McFarland Recreation and Park District 550 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 9.421 | McFarland Park | 0 | Local Park 2 | 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]);