superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 9,409
- County Agency 983
- Recreation/Parks District 969
- State Agency 652
- Non Profit - Land Trust 460
- Open Space District 211
- Federal Agency 198
- County Agency - Parks 189
- Community Services District 183
- Water District 166
- Home Owners Association 146
- Non Profit - Conservation 107
- Flood District 91
- Cemetery District 60
- Non Profit - Other 33
- Port/Harbor District 32
- County Agency - Other 28
- Irrigation District 16
- School District 13
- Special District - Other 12
- Commercial 10
- Sanitation District 9
- Joint Powers Authority 5
- Other 5
- 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
- Los Angeles, City of 422
- San Diego, City of 400
- California Department of Fish and Wildlife 307
- San Jose, City of 233
- San Francisco, City and County of 212
- Sacramento, City of 201
- California Department of Parks and Recreation 165
- Mountains Recreation and Conservation Authority 163
- Los Angeles, County of 155
- Ventura, City of 147
- Long Beach, City of 138
- Roseville, City of 119
- San Diego, County of 116
- East Bay Regional Park District 113
- Oakland, City of 110
- Irvine, City of 96
- Fresno, City of 92
- Consumnes Community Services District 91
- Hayward Area Recreation and Park District 78
- Modesto, City of 78
- Santa Barbara, County of 77
- Huntington Beach, City of 75
- Stockton, City of 75
- Orange, County of 72
- Torrance, City of 71
- Tracy, City of 70
- Santa Rosa, City of 68
- Santa Cruz, City of 66
- Chula Vista, City of 66
- Newport Beach, City of 63
- …
ACCESS_TYP 4
- Open Access 12,144
- Restricted Access 941
- No Public Access 682
- Unknown Access 247
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1625 | 1625 | 1624 | {"type": "Polygon", "coordinates": [[[-118.68263, 34.26869], [-118.68196, 34.26869], [-118.68192, 34.26875], [-118.68186, 34.26874], [-118.6818, 34.26875], [-118.68175, 34.26869], [-118.6811, 34.26869], [-118.6811, 34.26857], [-118.68112, 34.26847], [-118.68111, 34.2684], [-118.68105, 34.2683], [-118.68095, 34.26824], [-118.68106, 34.26798], [-118.68214, 34.26828], [-118.68263, 34.26838], [-118.68263, 34.26869]]]} | Open Access 1 | Arroyostow Park | 15638 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2.019 | Arroyostow Park | ||
1626 | 1626 | 1625 | {"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 | Artesia Park | 15639 | 1010 | Artesia, City of 549 | City 2 | City Agency 2 | http://www.cityofartesia.us/index.aspx?nid=127 | City 2 | 14.785 | Artesia Park | ||
1627 | 1627 | 1626 | {"type": "MultiPolygon", "coordinates": [[[[-122.50346, 40.63652], [-122.50346, 40.63912], [-122.50327, 40.63918], [-122.50131, 40.63907], [-122.49859, 40.63901], [-122.49789, 40.63902], [-122.49787, 40.63908], [-122.49371, 40.63742], [-122.49382, 40.63681], [-122.50346, 40.63652]]], [[[-122.52689, 40.65487], [-122.52646, 40.6586], [-122.52177, 40.65854], [-122.52219, 40.65493], [-122.52468, 40.65491], [-122.52521, 40.65444], [-122.5266, 40.65469], [-122.52689, 40.65487]]]]} | Open Access 1 | Ash Creek WA | 15647 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 87.711 | Ash Creek WA | ||
1628 | 1628 | 1627 | {"type": "Polygon", "coordinates": [[[-117.35743, 33.16745], [-117.35654, 33.16659], [-117.35654, 33.16659], [-117.35663, 33.16654], [-117.35665, 33.16649], [-117.35674, 33.16649], [-117.35696, 33.16667], [-117.35697, 33.1667], [-117.35728, 33.16704], [-117.35725, 33.16707], [-117.35727, 33.1671], [-117.35726, 33.16716], [-117.35728, 33.16723], [-117.3574, 33.16736], [-117.35743, 33.16745]]]} | Unknown Access 4 | Buena Vista Lagoon Ecological Reserve | 16489 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | http://www.gonctd.com/ | Special District 4 | 0.498 | Buena Vista Lagoon ER | 1968 | |
1629 | 1629 | 1628 | {"type": "Polygon", "coordinates": [[[-117.35825, 33.16477], [-117.35811, 33.16484], [-117.35793, 33.16488], [-117.35776, 33.16502], [-117.35761, 33.1652], [-117.35715, 33.16521], [-117.35715, 33.16625], [-117.35617, 33.16533], [-117.35608, 33.16521], [-117.35598, 33.1652], [-117.35586, 33.16509], [-117.35548, 33.16483], [-117.35555, 33.16477], [-117.3555, 33.16464], [-117.35547, 33.16431], [-117.35558, 33.16437], [-117.35557, 33.16441], [-117.35563, 33.16466], [-117.35569, 33.16472], [-117.35576, 33.16486], [-117.35757, 33.16474], [-117.35761, 33.16476], [-117.35792, 33.16464], [-117.35803, 33.16453], [-117.35825, 33.16477]]]} | Open Access 1 | Buena Vista Lagoon and Nature Center | http://bvaudubon.org/nature-center/ | 16487 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 4.021 | Buena Vista Lagoon and Nature Ctr. | |
1630 | 1630 | 1629 | {"type": "Polygon", "coordinates": [[[-122.03974, 37.52433], [-122.03781, 37.52499], [-122.03779, 37.52499], [-122.03778, 37.52488], [-122.03775, 37.52484], [-122.0377, 37.52481], [-122.03761, 37.52478], [-122.03747, 37.52481], [-122.03718, 37.52491], [-122.03694, 37.52445], [-122.03816, 37.52403], [-122.03938, 37.52364], [-122.03974, 37.52433]]]} | Open Access 1 | Ash Street Park | 15649 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 4.542 | Ash Street Park | 1973 | |
1631 | 1631 | 1630 | {"type": "Polygon", "coordinates": [[[-121.06468, 38.91873], [-121.06431, 38.91933], [-121.06366, 38.91966], [-121.06329, 38.91982], [-121.063, 38.91991], [-121.063, 38.91944], [-121.0622, 38.91748], [-121.06238, 38.91737], [-121.06257, 38.91741], [-121.06446, 38.91859], [-121.06447, 38.91872], [-121.06468, 38.91873]]]} | Open Access 1 | Ashford Park | http://www.auburnrec.com/parks_ashford.php | 15650 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 7.06 | Ashford Park | |
1632 | 1632 | 1631 | {"type": "MultiPolygon", "coordinates": [[[[-118.13301, 34.022], [-118.13299, 34.02209], [-118.13123, 34.02349], [-118.13067, 34.02337], [-118.13013, 34.02322], [-118.13226, 34.02153], [-118.13271, 34.02178], [-118.13298, 34.02195], [-118.13301, 34.022]]], [[[-118.13384, 34.02141], [-118.13333, 34.02182], [-118.13293, 34.02154], [-118.13254, 34.0213], [-118.13304, 34.0209], [-118.13384, 34.02141]]], [[[-118.13394, 34.02121], [-118.13392, 34.02123], [-118.13389, 34.02123], [-118.13321, 34.0208], [-118.13364, 34.02046], [-118.13382, 34.02081], [-118.13394, 34.02121]]]]} | Open Access 1 | Ashiya Park | 15651 | 1211 | Montebello, City of 248 | City 2 | City Agency 2 | http://www.cityofmontebello.com/depts/parks/default.asp | City 2 | 7.892 | Ashiya Park | ||
1633 | 1633 | 1632 | {"type": "Polygon", "coordinates": [[[-118.46534, 34.00959], [-118.46482, 34.00989], [-118.46458, 34.00965], [-118.46523, 34.00949], [-118.46534, 34.00959]]]} | Open Access 1 | Ashland Park | 15653 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 0.364 | Ashland Park | ||
1634 | 1634 | 1633 | {"type": "Polygon", "coordinates": [[[-122.10782, 37.69342], [-122.10723, 37.69384], [-122.107, 37.69365], [-122.10684, 37.69376], [-122.1067, 37.69364], [-122.10697, 37.69343], [-122.10661, 37.69311], [-122.10689, 37.6929], [-122.10694, 37.69288], [-122.10694, 37.69286], [-122.10699, 37.69283], [-122.10782, 37.69342]]]} | Open Access 1 | Ashland Park | 15654 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 1.491 | Ashland Park | ||
1635 | 1635 | 1634 | {"type": "Polygon", "coordinates": [[[-122.33929, 38.30424], [-122.33903, 38.30485], [-122.33905, 38.30487], [-122.33895, 38.30512], [-122.33886, 38.30508], [-122.33878, 38.30473], [-122.33867, 38.30465], [-122.3383, 38.30466], [-122.33834, 38.30486], [-122.33812, 38.30491], [-122.33806, 38.30453], [-122.33802, 38.30444], [-122.33792, 38.3043], [-122.33775, 38.3042], [-122.33756, 38.30416], [-122.3374, 38.30416], [-122.33716, 38.30428], [-122.33702, 38.30439], [-122.33695, 38.3044], [-122.33679, 38.30438], [-122.33644, 38.3044], [-122.33631, 38.30389], [-122.33659, 38.30418], [-122.33703, 38.30405], [-122.33784, 38.30373], [-122.33808, 38.30371], [-122.33808, 38.30369], [-122.33785, 38.30344], [-122.33792, 38.30341], [-122.33849, 38.30402], [-122.33929, 38.30424]]]} | Open Access 1 | Buhman Park | 16499 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 3.644 | Buhman Park | 1973 | |
1636 | 1636 | 1635 | {"type": "Polygon", "coordinates": [[[-121.36647, 38.57697], [-121.36491, 38.57743], [-121.36468, 38.57747], [-121.36465, 38.57737], [-121.36464, 38.57714], [-121.36415, 38.57728], [-121.36363, 38.57713], [-121.36368, 38.57704], [-121.36372, 38.57694], [-121.36373, 38.57674], [-121.3637, 38.57661], [-121.36346, 38.576], [-121.36344, 38.57586], [-121.36347, 38.57573], [-121.36562, 38.5751], [-121.36647, 38.57697]]]} | Open Access 1 | Ashton Park | 15656 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 11.245 | Ashton Park | ||
1637 | 1637 | 1636 | {"type": "Polygon", "coordinates": [[[-118.36875, 33.95782], [-118.36872, 33.95811], [-118.36872, 33.95829], [-118.36868, 33.95861], [-118.36851, 33.95933], [-118.36833, 33.9606], [-118.36829, 33.95783], [-118.36875, 33.95782]]]} | Open Access 1 | Ashwood Park | 15657 | 1147 | Inglewood, City of 272 | City 2 | City Agency 2 | http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp | City 2 | 1.68 | Ashwood Park | ||
1638 | 1638 | 1637 | {"type": "Polygon", "coordinates": [[[-117.78781, 33.67973], [-117.78686, 33.68064], [-117.78636, 33.68028], [-117.7873, 33.67937], [-117.78781, 33.67973]]]} | Restricted Access 2 | Ashwood Park | 15658 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 2.01 | Ashwood Park | ||
1639 | 1639 | 1638 | {"type": "Polygon", "coordinates": [[[-121.93548, 36.61625], [-121.9351, 36.61657], [-121.93498, 36.6167], [-121.9349, 36.61682], [-121.93433, 36.6178], [-121.93421, 36.61812], [-121.93407, 36.61853], [-121.934, 36.61893], [-121.93384, 36.61889], [-121.93398, 36.61786], [-121.93416, 36.61788], [-121.9348, 36.61678], [-121.93494, 36.6166], [-121.93509, 36.61645], [-121.93532, 36.61626], [-121.93548, 36.61625]]]} | Open Access 1 | Asilomar Conference Grounds | 15659 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1.06 | Asilomar Conference Grounds | ||
1640 | 1640 | 1639 | {"type": "MultiPolygon", "coordinates": [[[[-119.78388, 34.43248], [-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.79498, 34.42774], [-119.79162, 34.42959], [-119.7874, 34.43078], [-119.78626, 34.43109], [-119.78624, 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.78695, 34.43058], [-119.79145, 34.42935], [-119.79202, 34.42903], [-119.79202, 34.42901], [-119.79462, 34.42757], [-119.79483, 34.42761], [-119.79498, 34.42774]]]]} | Unknown Access 4 | Atascadero Creek | 15661 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 9.641 | Atascadero Creek | ||
1641 | 1641 | 1640 | {"type": "Polygon", "coordinates": [[[-120.6696, 35.4669], [-120.66937, 35.46727], [-120.66919, 35.46762], [-120.66913, 35.46762], [-120.66897, 35.46805], [-120.66891, 35.46832], [-120.66888, 35.46856], [-120.66803, 35.46825], [-120.66739, 35.4682], [-120.66714, 35.46815], [-120.66828, 35.4673], [-120.6684, 35.46719], [-120.6685, 35.46705], [-120.66856, 35.46693], [-120.6686, 35.4668], [-120.66861, 35.46667], [-120.66881, 35.46665], [-120.66906, 35.46668], [-120.66925, 35.46674], [-120.6696, 35.4669]]]} | Open Access 1 | Atascadero Lake Park | 15663 | 1012 | Atascadero, City of 542 | City 2 | City Agency 2 | http://www.atascadero.org/index.php?option=com_content&view=article&id=670&Itemid=584 | City 2 | 5.166 | Atascadero Lake Park | ||
1642 | 1642 | 1641 | {"type": "Polygon", "coordinates": [[[-118.28068, 33.91874], [-118.2806, 33.91876], [-118.2806, 33.91994], [-118.27843, 33.91994], [-118.27849, 33.9166], [-118.27855, 33.91656], [-118.2806, 33.91655], [-118.28067, 33.91661], [-118.28068, 33.91874]]]} | Open Access 1 | Athens Park | 15666 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 18.721 | Athens Park | ||
1643 | 1643 | 1642 | {"type": "Polygon", "coordinates": [[[-121.33522, 37.99548], [-121.33521, 37.9955], [-121.33481, 37.99563], [-121.33433, 37.99586], [-121.3339, 37.99615], [-121.33368, 37.99633], [-121.33248, 37.99445], [-121.33309, 37.99375], [-121.33327, 37.99359], [-121.33345, 37.99347], [-121.33348, 37.99346], [-121.33481, 37.99472], [-121.33496, 37.9949], [-121.33508, 37.9951], [-121.33514, 37.99523], [-121.33522, 37.99548]]]} | Open Access 1 | Atherton Park | 15667 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 9.8 | Atherton Park | ||
1644 | 1644 | 1643 | {"type": "Polygon", "coordinates": [[[-118.75367, 34.28776], [-118.75325, 34.28777], [-118.75323, 34.28789], [-118.752, 34.28789], [-118.752, 34.28642], [-118.75365, 34.28642], [-118.75365, 34.28723], [-118.75367, 34.28776]]]} | Open Access 1 | Atherwood Park | 15668 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 6.024 | Atherwood Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);