units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 464
- Los Angeles, City of 412
- Sacramento, City of 220
- San Jose, City of 219
- San Francisco, City and County of 195
- Ventura, City of 144
- Roseville, City of 130
- Long Beach, City of 127
- Oakland, City of 117
- Modesto, City of 85
- Irvine, City of 81
- Napa, City of 81
- Stockton, City of 80
- Tracy, City of 72
- Torrance, City of 67
- Davis, City of 64
- Santa Cruz, City of 63
- Poway, City of 63
- Brentwood, City of 63
- Clovis, City of 62
- Manteca, City of 61
- Bakersfield, City of 60
- San Ramon, City of 59
- Fresno, City of 58
- Santa Rosa, City of 58
- San Luis Obispo, City of 57
- Chula Vista, City of 57
- Huntington Beach, City of 56
- Rocklin, City of 56
- Riverside, City of 54
- …
DES_TP >30
- Local Park 6,413
- Local Recreation Area 1,335
- Local Other or Unknown 648
- Local Conservation Area 127
- Local Historic or Cultural Area 34
- National Monument or Landmark 5
- Local Resource Management Area 4
- National Forest 1
- National Recreation Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 8,686
- Restricted Access 348
- No Public Access 187
- Unknown Access 25
MNG_AG_TYP 1
- City Agency · 9,246 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1689 | 1689 | 1688 | {"type": "Polygon", "coordinates": [[[-117.7763, 33.66668], [-117.77569, 33.66727], [-117.77493, 33.66675], [-117.77476, 33.6666], [-117.77473, 33.66662], [-117.77464, 33.66655], [-117.7746, 33.66658], [-117.77459, 33.66657], [-117.77521, 33.66592], [-117.7763, 33.66668]]]} | Open Access 1 | 12732 | Valley Oak Park | 26791 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.81 | Valley Oak Park | 0 | Local Park 2 | 4 | |
1691 | 1691 | 1690 | {"type": "Polygon", "coordinates": [[[-118.80576, 34.14426], [-118.8047, 34.14528], [-118.80453, 34.14521], [-118.80449, 34.14517], [-118.80449, 34.14512], [-118.80453, 34.14505], [-118.80458, 34.14491], [-118.8046, 34.14475], [-118.80459, 34.14458], [-118.80453, 34.14442], [-118.80447, 34.14433], [-118.80433, 34.14417], [-118.80363, 34.14356], [-118.80351, 34.14348], [-118.80339, 34.14343], [-118.8035, 34.1432], [-118.80331, 34.14264], [-118.80264, 34.14255], [-118.80005, 34.14275], [-118.79893, 34.14304], [-118.79865, 34.14331], [-118.7987, 34.14355], [-118.7982, 34.14363], [-118.79819, 34.14374], [-118.79827, 34.14399], [-118.79828, 34.1443], [-118.79819, 34.14431], [-118.7982, 34.14496], [-118.79803, 34.14496], [-118.79803, 34.14247], [-118.7992, 34.14145], [-118.80462, 34.14143], [-118.8045, 34.14253], [-118.8046, 34.14314], [-118.80376, 34.14324], [-118.80375, 34.14354], [-118.80397, 34.14383], [-118.80444, 34.14425], [-118.80498, 34.14465], [-118.80511, 34.14463], [-118.80562, 34.14413], [-118.80567, 34.14419], [-118.80576, 34.14426]]]} | Open Access 1 | 12745 | Westlake Village City Parkland | 27404 | 1377 | Westlake Village, City of 321 | City 2 | City Agency 2 | http://www.wlv.org/index.aspx?nid=194 | City 2 | 1377 | Westlake Village, City of 318 | City 2 | City Agency 2 | Los Angeles 6 | 24.679 | Westlake Village City Parkland | 2018 | Local Park 2 | 4 | |
1693 | 1693 | 1692 | {"type": "Polygon", "coordinates": [[[-122.49248, 37.63035], [-122.49247, 37.63053], [-122.49221, 37.63053], [-122.49218, 37.63034], [-122.49248, 37.63035]]]} | Open Access 1 | 14655 | Palmetto Mini Park | 23354 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 0.124 | Palmetto MP | 0 | Local Park 2 | 4 | |
1694 | 1694 | 1693 | {"type": "Polygon", "coordinates": [[[-117.78468, 33.69615], [-117.78458, 33.69625], [-117.78392, 33.6958], [-117.78367, 33.69605], [-117.78377, 33.69614], [-117.78375, 33.69616], [-117.78362, 33.6961], [-117.78338, 33.69634], [-117.78339, 33.69637], [-117.78313, 33.69662], [-117.78299, 33.6966], [-117.78294, 33.69647], [-117.7828, 33.6963], [-117.783, 33.69609], [-117.78292, 33.69602], [-117.78319, 33.69576], [-117.7832, 33.69571], [-117.78345, 33.69547], [-117.78334, 33.69537], [-117.78217, 33.69454], [-117.78198, 33.69449], [-117.78203, 33.69437], [-117.78209, 33.6943], [-117.78234, 33.69449], [-117.78233, 33.69452], [-117.78397, 33.69566], [-117.78408, 33.6956], [-117.7841, 33.69562], [-117.78403, 33.69572], [-117.78457, 33.6961], [-117.78463, 33.69609], [-117.78468, 33.69615]]]} | Open Access 1 | 12756 | Willows Park | 27594 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.596 | Willows Park | 0 | Local Park 2 | 4 | |
1696 | 1696 | 1695 | {"type": "Polygon", "coordinates": [[[-117.19226, 34.07018], [-117.19224, 34.07362], [-117.19126, 34.07361], [-117.19128, 34.07017], [-117.19226, 34.07018]]]} | Open Access 1 | 14716 | Texonia Park | 26274 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 8.528 | Texonia Park | 0 | Local Park 2 | 4 | |
1697 | 1697 | 1696 | {"type": "Polygon", "coordinates": [[[-122.04168, 37.53797], [-122.04001, 37.53932], [-122.03814, 37.53786], [-122.0383, 37.53775], [-122.03857, 37.53796], [-122.0392, 37.5381], [-122.03926, 37.53805], [-122.03939, 37.53805], [-122.03948, 37.538], [-122.03952, 37.53789], [-122.03956, 37.53785], [-122.04084, 37.53698], [-122.04089, 37.53697], [-122.04093, 37.53698], [-122.04107, 37.53716], [-122.0413, 37.53755], [-122.04141, 37.5377], [-122.04154, 37.53784], [-122.04168, 37.53797]]]} | Open Access 1 | 12774 | Mayhews Landing Park | 21977 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 8.356 | Mayhews Landing Park | 1973 | Local Park 2 | 4 | |
1698 | 1698 | 1697 | {"type": "Polygon", "coordinates": [[[-123.01441, 38.79804], [-123.01401, 38.79805], [-123.01398, 38.79765], [-123.01439, 38.79761], [-123.01441, 38.79804]]]} | Open Access 1 | 6968 | Tarman Park | 26190 | 1059 | Cloverdale, City of 410 | City 2 | City Agency 2 | http://www.cloverdale.net/index.aspx?nid=152 | City 2 | 1059 | Cloverdale, City of 404 | City 2 | City Agency 2 | Sonoma 16 | 0.409 | Tarman Park | 0 | Local Park 2 | 4 | |
1700 | 1700 | 1699 | {"type": "Polygon", "coordinates": [[[-121.99256, 37.57229], [-121.99231, 37.57249], [-121.99224, 37.57281], [-121.99201, 37.5728], [-121.99171, 37.57283], [-121.99148, 37.5729], [-121.99125, 37.57302], [-121.991, 37.57276], [-121.99062, 37.57267], [-121.99116, 37.57122], [-121.99222, 37.57203], [-121.99212, 37.57212], [-121.99219, 37.57219], [-121.99231, 37.5721], [-121.99256, 37.57229]]]} | Open Access 1 | 12826 | Rancho Arroyo Park | 24127 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 4.47 | Rancho Arroyo Park | 0 | Local Park 2 | 4 | |
1701 | 1701 | 1700 | {"type": "Polygon", "coordinates": [[[-120.76629, 37.64793], [-120.76479, 37.64805], [-120.76487, 37.64844], [-120.76469, 37.64846], [-120.76456, 37.6479], [-120.76485, 37.64783], [-120.76507, 37.64773], [-120.76531, 37.64747], [-120.76603, 37.64714], [-120.76619, 37.64741], [-120.76629, 37.64793]]]} | Open Access 1 | 48919 | Goldmine Park | 33641 | 1372 | Waterford, City of 57 | City 2 | City Agency 2 | http://www.cityofwaterford.org/departments/parks-and-recreation/ | City 2 | 1372 | Waterford, City of 55 | City 2 | City Agency 2 | Stanislaus 2 | 2.185 | Goldmine Park | 0 | Local Park 2 | 4 | |
1703 | 1703 | 1702 | {"type": "MultiPolygon", "coordinates": [[[[-118.0454, 33.98641], [-118.0454, 33.98717], [-118.04443, 33.98717], [-118.04443, 33.9864], [-118.0454, 33.98641]]], [[[-118.04592, 33.9864], [-118.04592, 33.98717], [-118.04548, 33.98716], [-118.04548, 33.9864], [-118.04592, 33.9864]]], [[[-118.04752, 33.98641], [-118.04752, 33.98724], [-118.04609, 33.98725], [-118.0461, 33.98641], [-118.04752, 33.98641]]]]} | Open Access 1 | 6540 | Founders Memorial Park | 19019 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 5.781 | Founders Memorial Park | 0 | Local Park 2 | 4 | |
1704 | 1704 | 1703 | {"type": "MultiPolygon", "coordinates": [[[[-118.05718, 33.99178], [-118.05479, 33.99178], [-118.05477, 33.99], [-118.05543, 33.99001], [-118.05718, 33.99178]]], [[[-118.05829, 33.99261], [-118.05747, 33.99178], [-118.05572, 33.99], [-118.05744, 33.98999], [-118.05804, 33.99178], [-118.05829, 33.99261]]]]} | Open Access 1 | 6541 | Palm Park | 23346 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 12.607 | Palm Park | 0 | Local Park 2 | 4 | |
1706 | 1706 | 1705 | {"type": "Polygon", "coordinates": [[[-122.43198, 37.78028], [-122.43163, 37.78033], [-122.43159, 37.78009], [-122.43193, 37.78005], [-122.43198, 37.78028]]]} | Open Access 1 | 6538 | Fillmore & Turk St. Mini Park | 18898 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.203 | Fillmore & Turk St. MP | 0 | Local Park 2 | 4 | |
1707 | 1707 | 1706 | {"type": "Polygon", "coordinates": [[[-122.42707, 37.78105], [-122.42623, 37.78115], [-122.42616, 37.78084], [-122.42539, 37.78093], [-122.42538, 37.78094], [-122.42545, 37.78125], [-122.42402, 37.78144], [-122.42387, 37.78069], [-122.42692, 37.7803], [-122.42707, 37.78105]]]} | Open Access 1 | 6549 | Margaret S Hayward Playground | 21802 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 5.03 | Margaret S Hayward Playground | 0 | Local Recreation Area 3 | 4 | |
1709 | 1709 | 1708 | {"type": "Polygon", "coordinates": [[[-117.75671, 34.13628], [-117.7567, 34.1363], [-117.75036, 34.13633], [-117.75034, 34.13665], [-117.75035, 34.13666], [-117.75656, 34.13663], [-117.75559, 34.13883], [-117.75547, 34.13901], [-117.75533, 34.13918], [-117.75515, 34.13932], [-117.75367, 34.14035], [-117.75356, 34.14041], [-117.75326, 34.14053], [-117.75215, 34.14084], [-117.75214, 34.14092], [-117.75193, 34.14107], [-117.75169, 34.1413], [-117.75165, 34.14129], [-117.75133, 34.14113], [-117.75127, 34.14107], [-117.75121, 34.14102], [-117.7511, 34.141], [-117.7511, 34.14067], [-117.75024, 34.14008], [-117.75024, 34.13986], [-117.74992, 34.13986], [-117.74843, 34.13883], [-117.74818, 34.13785], [-117.7485, 34.13662], [-117.75064, 34.13454], [-117.75064, 34.13451], [-117.75208, 34.13314], [-117.75433, 34.13264], [-117.75616, 34.13503], [-117.75671, 34.13628]]]} | No Public Access 3 | 12846 | Live Oak Reservoir | 21375 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 112.516 | Live Oak Reservoir | 0 | Local Recreation Area 3 | 4 | |
1710 | 1710 | 1709 | {"type": "Polygon", "coordinates": [[[-117.81403, 33.78168], [-117.81385, 33.78162], [-117.81382, 33.78165], [-117.81354, 33.78152], [-117.81321, 33.78128], [-117.81304, 33.78111], [-117.81288, 33.78085], [-117.81279, 33.78062], [-117.81401, 33.78061], [-117.81403, 33.78168]]]} | Open Access 1 | 12933 | La Veta Park | 20814 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | Orange 3 | 2.295 | La Veta Park | 0 | Local Park 2 | 4 | |
1712 | 1712 | 1711 | {"type": "Polygon", "coordinates": [[[-116.44281, 34.1207], [-116.44281, 34.12071], [-116.44174, 34.12069], [-116.44269, 34.12043], [-116.44281, 34.1207]]]} | Open Access 1 | 14810 | Remembrance Park | 24287 | 1356 | Yucca Valley, Town of 272 | City 2 | City Agency 2 | http://www.yucca-valley.org/ | City 2 | 1356 | Yucca Valley, Town of 267 | City 2 | City Agency 2 | San Bernardino 22 | 0.373 | Remembrance Park | 0 | Local Park 2 | 4 | |
1713 | 1713 | 1712 | {"type": "MultiPolygon", "coordinates": [[[[-121.97999, 37.5644], [-121.98024, 37.56435], [-121.9804, 37.56434], [-121.98046, 37.56437], [-121.98049, 37.56446], [-121.98046, 37.56449], [-121.98039, 37.56453], [-121.9797, 37.56477], [-121.97952, 37.56481], [-121.97943, 37.56451], [-121.97999, 37.5644]]], [[[-121.98121, 37.5663], [-121.98119, 37.56634], [-121.98115, 37.56638], [-121.98079, 37.56649], [-121.98073, 37.56649], [-121.98067, 37.56646], [-121.98059, 37.56633], [-121.98044, 37.56604], [-121.98016, 37.56567], [-121.98005, 37.56548], [-121.97984, 37.56491], [-121.97984, 37.56487], [-121.97986, 37.56484], [-121.98051, 37.5646], [-121.98057, 37.5646], [-121.98063, 37.56462], [-121.98078, 37.5648], [-121.98102, 37.56501], [-121.98114, 37.56519], [-121.98121, 37.56537], [-121.98121, 37.56555], [-121.98115, 37.56583], [-121.98113, 37.56599], [-121.98115, 37.56614], [-121.98121, 37.5663]]]]} | Open Access 1 | 12857 | Shin Historic Park | 30828 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 4.615 | Shin Historic Park | 1984 | Local Historic or Cultural Area 19 | 4 | |
1714 | 1714 | 1713 | {"type": "Polygon", "coordinates": [[[-122.38468, 40.57295], [-122.3842, 40.57397], [-122.3827, 40.57341], [-122.38331, 40.57245], [-122.38468, 40.57295]]]} | Open Access 1 | 14849 | Softball Park | 25591 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 3.987 | Softball Park | 0 | Local Park 2 | 4 | |
1715 | 1715 | 1714 | {"type": "Polygon", "coordinates": [[[-117.01936, 32.8301], [-117.01924, 32.83103], [-117.01924, 32.83116], [-117.01713, 32.83102], [-117.01761, 32.83048], [-117.01773, 32.83003], [-117.01936, 32.8301]]]} | Open Access 1 | 12872 | Big Rock Park | 16087 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/index.aspx?page=65 | San Diego 4 | 4.829 | Big Rock Park | 0 | Local Park 2 | 4 |
1716 | 1716 | 1715 | {"type": "Polygon", "coordinates": [[[-122.01159, 37.54533], [-122.01151, 37.54542], [-122.01126, 37.54529], [-122.01121, 37.54529], [-122.01094, 37.54515], [-122.01092, 37.54508], [-122.01075, 37.54499], [-122.01066, 37.545], [-122.01051, 37.54492], [-122.01035, 37.54512], [-122.01046, 37.54522], [-122.01042, 37.54527], [-122.01034, 37.54524], [-122.0101, 37.5453], [-122.01001, 37.54541], [-122.00973, 37.54527], [-122.00993, 37.54502], [-122.00997, 37.54503], [-122.01024, 37.5447], [-122.01, 37.54457], [-122.01005, 37.54451], [-122.01048, 37.54474], [-122.0105, 37.54479], [-122.01071, 37.54489], [-122.01076, 37.54489], [-122.01103, 37.54503], [-122.01105, 37.54508], [-122.01125, 37.54518], [-122.01129, 37.54517], [-122.01159, 37.54533]]]} | Open Access 1 | 12873 | Plaza Park | 23782 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 1.095 | Plaza Park | 1973 | 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]);