superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by MNG_AG_TYP
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 9,552
- County Agency 1,102
- Recreation/Parks District 1,091
- State Agency 872
- Non Profit - Land Trust 511
- Open Space District 241
- County Agency - Parks 218
- Home Owners Association 200
- Community Services District 193
- Water District 187
- Non Profit - Conservation 119
- Flood District 94
- Cemetery District 61
- Non Profit - Other 44
- School District 38
- County Agency - Other 32
- Port/Harbor District 32
- Irrigation District 24
- Special District - Other 15
- Commercial 14
- Sanitation District 9
- Joint Powers Authority 8
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- Airport District 1
- …
MNG_AGENCY >30
- Los Angeles, City of 426
- San Diego, City of 401
- California Department of Fish and Wildlife 394
- California Department of Parks and Recreation 276
- San Jose, City of 239
- San Francisco, City and County of 220
- Sacramento, City of 208
- Mountains Recreation and Conservation Authority 181
- Los Angeles, County of 171
- Ventura, City of 149
- Long Beach, City of 138
- East Bay Regional Park District 132
- Roseville, City of 121
- San Diego, County of 120
- Oakland, City of 111
- Irvine, City of 96
- Fresno, City of 92
- Consumnes Community Services District 92
- Santa Barbara, County of 89
- Hayward Area Recreation and Park District 84
- Orange, County of 82
- Stockton, City of 79
- Modesto, City of 78
- Huntington Beach, City of 76
- Torrance, City of 72
- Tracy, City of 70
- Santa Rosa, City of 69
- Santa Cruz, City of 68
- Valley-Wide Recreation and Park District 67
- Chula Vista, City of 66
- …
ACCESS_TYP 4
- Open Access 12,723
- Restricted Access 998
- No Public Access 722
- Unknown Access 248
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1410 | 1410 | 1409 | {"type": "Polygon", "coordinates": [[[-121.33483, 38.79171], [-121.33446, 38.79171], [-121.3334, 38.79087], [-121.3337, 38.79064], [-121.33377, 38.79063], [-121.33391, 38.79064], [-121.33401, 38.79059], [-121.33406, 38.79053], [-121.33406, 38.79046], [-121.33402, 38.79041], [-121.33395, 38.79036], [-121.33403, 38.7903], [-121.33414, 38.79038], [-121.3343, 38.79046], [-121.3344, 38.79055], [-121.33482, 38.79077], [-121.33483, 38.79171]]]} | Open Access 1 | Adam V. Baquera Park | 15257 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 2.667 | Adam V. Baquera Park | ||
1412 | 1412 | 1411 | {"type": "Polygon", "coordinates": [[[-117.67481, 34.08139], [-117.67252, 34.0814], [-117.67251, 34.07958], [-117.67298, 34.07957], [-117.67297, 34.07795], [-117.67307, 34.07795], [-117.67309, 34.07797], [-117.6748, 34.07797], [-117.67481, 34.08139]]]} | Open Access 1 | Anthony Munoz Park | 15516 | 1232 | Ontario, City of 123 | City 2 | City Agency 2 | http://www.ci.ontario.ca.us/index.aspx?page=456 | City 2 | 18.011 | Anthony Munoz Park | ||
1413 | 1413 | 1412 | {"type": "MultiPolygon", "coordinates": [[[[-117.2322, 33.14229], [-117.23213, 33.1423], [-117.23079, 33.14226], [-117.23016, 33.14279], [-117.23009, 33.14283], [-117.2299, 33.14289], [-117.22971, 33.14288], [-117.22965, 33.14293], [-117.22956, 33.1429], [-117.22942, 33.14281], [-117.22936, 33.14274], [-117.22838, 33.14284], [-117.22764, 33.14285], [-117.22742, 33.14382], [-117.22664, 33.14584], [-117.22579, 33.14584], [-117.22576, 33.14586], [-117.22578, 33.14672], [-117.22545, 33.14622], [-117.22543, 33.14499], [-117.22545, 33.14498], [-117.22571, 33.14438], [-117.22564, 33.14354], [-117.22552, 33.14314], [-117.22409, 33.14364], [-117.22366, 33.14366], [-117.22358, 33.14375], [-117.22341, 33.14374], [-117.2232, 33.14375], [-117.22294, 33.14384], [-117.22269, 33.14399], [-117.22261, 33.14408], [-117.22254, 33.14418], [-117.22245, 33.14425], [-117.22254, 33.1444], [-117.22213, 33.14452], [-117.22193, 33.14451], [-117.22167, 33.14427], [-117.22102, 33.14438], [-117.22071, 33.14439], [-117.22026, 33.14457], [-117.21977, 33.14473], [-117.21939, 33.14498], [-117.21909, 33.14516], [-117.21864, 33.14481], [-117.21879, 33.14463], [-117.21953, 33.14425], [-117.2197, 33.14417], [-117.21927, 33.1437], [-117.2198, 33.14346], [-117.22013, 33.14311], [-117.22065, 33.14288], [-117.2207, 33.1429], [-117.22156, 33.1426], [-117.22174, 33.14268], [-117.22244, 33.14249], [-117.2225, 33.14252], [-117.22325, 33.1423], [-117.22326, 33.14226], [-117.22301, 33.14137], [-117.22304, 33.14137], [-117.22341, 33.14217], [-117.22355, 33.14222], [-117.22536, 33.14182], [-117.22552, 33.14168], [-117.22571, 33.14182], [-117.22574, 33.14223], [-117.23001, 33.14216], [-117.22998, 33.14032], [-117.23034, 33.14013], [-117.23039, 33.14013], [-117.23078, 33.14049], [-117.23149, 33.14103], [-117.2317, 33.14126], [-117.23193, 33.14159], [-117.23208, 33.14189], [-117.2322, 33.14229]]], [[[-117.24385, 33.13544], [-117.24359, 33.13527], [-117.24107, 33.13527], [-117.24034, 33.13552], [-117.23979, 33.13609], [-117.23808, 33.138], [-117.23711, 33.13816], [-117.23713, 33.13888], [-117.23625, 33.1395], [-117.23444, 33.14101], [-117.23228, 33.14173], [-117.23214, 33.14146], [-117.23193, 33.14116], [-117.2317, 33.14091], [-117.23142, 33.14066], [-117.23315, 33.14025], [-117.23409, 33.13944], [-117.23428, 33.13863], [-117.23426, 33.13694], [-117.23612, 33.13594], [-117.23662, 33.13558], [-117.2372, 33.13568], [-117.23806, 33.13524], [-117.23805, 33.13501], [-117.23859, 33.13499], [-117.24377, 33.13497], [-117.24385, 33.13544]]], [[[-117.2461, 33.13659], [-117.24526, 33.13547], [-117.24439, 33.13552], [-117.24438, 33.13503], [-117.24439, 33.13496], [-117.246, 33.13495], [-117.2461, 33.13659]]]]} | Open Access 1 | Agua Hedionda Creek | http://www.cityofvista.com/services/parks-and-facilities | 15293 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 113.311 | Agua Hedionda Creek | |
1414 | 1414 | 1413 | {"type": "Polygon", "coordinates": [[[-122.38674, 37.76527], [-122.38641, 37.76569], [-122.38597, 37.76658], [-122.38587, 37.76659], [-122.38593, 37.76636], [-122.38592, 37.76628], [-122.38629, 37.76569], [-122.38652, 37.76541], [-122.38654, 37.7653], [-122.38647, 37.76528], [-122.38646, 37.76523], [-122.38674, 37.76527]]]} | Open Access 1 | Agua Vista Park | 15295 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.47 | Agua Vista Park | ||
1415 | 1415 | 1414 | {"type": "Polygon", "coordinates": [[[-117.69167, 34.01455], [-117.69121, 34.01455], [-117.6912, 34.0139], [-117.69167, 34.01389], [-117.69167, 34.01455]]]} | Open Access 1 | Aguiar Square | http://www.cityofchino.org/government-services/community-services/parks/aguiar-square | 15296 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.78 | Aguiar Square | |
1419 | 1419 | 1418 | {"type": "Polygon", "coordinates": [[[-118.53705, 34.04425], [-118.53705, 34.04425], [-118.53673, 34.04434], [-118.53687, 34.04401], [-118.53705, 34.04425]]]} | Open Access 1 | Aiglon Plaza | 15299 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.12 | Aiglon Plaza | ||
1420 | 1420 | 1419 | {"type": "Polygon", "coordinates": [[[-121.5174, 38.63835], [-121.51735, 38.63837], [-121.5163, 38.63837], [-121.51622, 38.63835], [-121.51612, 38.63836], [-121.51601, 38.63829], [-121.51469, 38.63829], [-121.51467, 38.63694], [-121.51469, 38.6369], [-121.51479, 38.63683], [-121.5158, 38.63681], [-121.51646, 38.63672], [-121.51648, 38.63675], [-121.51663, 38.63716], [-121.51669, 38.63723], [-121.51674, 38.63725], [-121.51682, 38.63726], [-121.51726, 38.63713], [-121.51731, 38.63714], [-121.51734, 38.63716], [-121.51743, 38.63744], [-121.51747, 38.63769], [-121.51747, 38.63788], [-121.51742, 38.6383], [-121.5174, 38.63835]]]} | Open Access 1 | Airfield Park Site | 15300 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 9.219 | Airfield Park Site | ||
1422 | 1422 | 1421 | {"type": "MultiPolygon", "coordinates": [[[[-121.48293, 38.51018], [-121.48097, 38.51019], [-121.48096, 38.50922], [-121.4829, 38.50921], [-121.48293, 38.51018]]], [[[-121.48294, 38.51071], [-121.48292, 38.51075], [-121.48286, 38.51077], [-121.48266, 38.5107], [-121.48202, 38.51037], [-121.48198, 38.51032], [-121.482, 38.51028], [-121.48205, 38.51027], [-121.48293, 38.51026], [-121.48294, 38.51071]]], [[[-121.48603, 38.50975], [-121.48435, 38.50907], [-121.48421, 38.50905], [-121.48314, 38.50905], [-121.48311, 38.50825], [-121.48452, 38.50824], [-121.48455, 38.50891], [-121.48602, 38.50891], [-121.48603, 38.50975]]]]} | Open Access 1 | Airport Little League Park | 15302 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 9.952 | Airport Little League Park | ||
1423 | 1423 | 1422 | {"type": "Polygon", "coordinates": [[[-120.86852, 37.05834], [-120.8685, 37.05835], [-120.86824, 37.05832], [-120.86805, 37.05827], [-120.8679, 37.05819], [-120.86778, 37.05804], [-120.86758, 37.05772], [-120.86761, 37.05771], [-120.86852, 37.05834]]]} | Open Access 1 | Airport Park | 15303 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.388 | Airport Park | ||
1424 | 1424 | 1423 | {"type": "Polygon", "coordinates": [[[-118.44788, 34.01608], [-118.44784, 34.01622], [-118.44658, 34.01731], [-118.44614, 34.01671], [-118.4444, 34.01766], [-118.44401, 34.01714], [-118.44734, 34.01539], [-118.44788, 34.01608]]]} | Open Access 1 | Airport Park | 15304 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 8.348 | Airport Park | ||
1425 | 1425 | 1424 | {"type": "Polygon", "coordinates": [[[-121.33169, 38.03669], [-121.33167, 38.03673], [-121.33162, 38.03675], [-121.33058, 38.03674], [-121.33054, 38.03672], [-121.33052, 38.03669], [-121.33052, 38.03595], [-121.33045, 38.03589], [-121.33039, 38.03588], [-121.33033, 38.03589], [-121.33033, 38.03552], [-121.33043, 38.0355], [-121.33044, 38.03391], [-121.33101, 38.03362], [-121.33159, 38.03362], [-121.33163, 38.03364], [-121.33169, 38.03669]]]} | Open Access 1 | Aj Bart Detoni Park | 15306 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 8.937 | Aj Bart Detoni Park | ||
1426 | 1426 | 1425 | {"type": "Polygon", "coordinates": [[[-121.78691, 37.69219], [-121.78691, 37.69315], [-121.78629, 37.69315], [-121.78629, 37.6917], [-121.7865, 37.6917], [-121.78689, 37.69197], [-121.78685, 37.69202], [-121.78685, 37.69207], [-121.78686, 37.69212], [-121.78691, 37.69219]]]} | Open Access 1 | Al Caffodio Park | 15307 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 2.005 | Al Caffodio Park | ||
1427 | 1427 | 1426 | {"type": "Polygon", "coordinates": [[[-121.46925, 38.47035], [-121.46923, 38.47237], [-121.46889, 38.47237], [-121.46888, 38.47244], [-121.46842, 38.47244], [-121.46843, 38.4715], [-121.46663, 38.47146], [-121.46663, 38.47066], [-121.46925, 38.47035]]]} | Open Access 1 | Anthony Park | 15517 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 7.883 | Anthony Park | ||
1430 | 1430 | 1429 | {"type": "Polygon", "coordinates": [[[-118.08178, 33.8369], [-118.07971, 33.8369], [-118.07968, 33.83406], [-118.08175, 33.83407], [-118.08178, 33.8369]]]} | Open Access 1 | Bloomfield Park | 16168 | 1168 | Lakewood, City of 255 | City 2 | City Agency 2 | http://www.lakewoodcity.org/ | City 2 | 14.9 | Bloomfield Park | ||
1433 | 1433 | 1432 | {"type": "Polygon", "coordinates": [[[-121.90435, 37.45781], [-121.90357, 37.45808], [-121.90341, 37.45809], [-121.9031, 37.45827], [-121.90308, 37.45825], [-121.90336, 37.45806], [-121.90247, 37.45707], [-121.90199, 37.45642], [-121.9025, 37.45622], [-121.90329, 37.45598], [-121.90435, 37.45781]]]} | Open Access 1 | Albert Augustine Park | 15337 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 6.109 | Albert Augustine Park | 1973 | |
1434 | 1434 | 1433 | {"type": "Polygon", "coordinates": [[[-122.53016, 37.96819], [-122.53012, 37.96849], [-122.52962, 37.96845], [-122.52958, 37.96857], [-122.5296, 37.96858], [-122.5301, 37.96863], [-122.5299, 37.96998], [-122.52887, 37.96988], [-122.52883, 37.9701], [-122.52651, 37.96875], [-122.52664, 37.96792], [-122.5278, 37.96801], [-122.52783, 37.96793], [-122.53016, 37.96819]]]} | Open Access 1 | Albert Park | 15338 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 13.119 | Albert Park | ||
1435 | 1435 | 1434 | {"type": "Polygon", "coordinates": [[[-121.47373, 38.56654], [-121.47334, 38.56743], [-121.47227, 38.56714], [-121.47265, 38.56625], [-121.47373, 38.56654]]]} | Open Access 1 | Albert Winn Park | 15339 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.556 | Albert Winn Park | ||
1436 | 1436 | 1435 | {"type": "Polygon", "coordinates": [[[-121.36832, 38.78194], [-121.36963, 38.78194], [-121.36975, 38.78195], [-121.36987, 38.78199], [-121.37, 38.78209], [-121.37005, 38.78218], [-121.37006, 38.78232], [-121.37003, 38.78241], [-121.36996, 38.7825], [-121.36982, 38.78258], [-121.3697, 38.78261], [-121.3683, 38.78261], [-121.36826, 38.78259], [-121.36824, 38.78254], [-121.36824, 38.78201], [-121.36826, 38.78197], [-121.36832, 38.78194]]]} | Open Access 1 | Alberto and Carmen Heredia Park | 15340 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 2.743 | Alberto and Carmen Heredia Park | ||
1437 | 1437 | 1436 | {"type": "MultiPolygon", "coordinates": [[[[-121.79422, 37.23369], [-121.79422, 37.23411], [-121.79394, 37.2341], [-121.79396, 37.23297], [-121.7941, 37.23298], [-121.79415, 37.23301], [-121.79415, 37.2334], [-121.79412, 37.23355], [-121.79415, 37.23363], [-121.79422, 37.23369]]], [[[-121.79425, 37.23083], [-121.79424, 37.23137], [-121.79415, 37.23143], [-121.79411, 37.23151], [-121.79411, 37.23157], [-121.79414, 37.2317], [-121.79414, 37.23196], [-121.79409, 37.23208], [-121.7941, 37.23215], [-121.79413, 37.23219], [-121.79422, 37.23227], [-121.79422, 37.23281], [-121.79396, 37.23281], [-121.79398, 37.23083], [-121.79425, 37.23083]]], [[[-121.79425, 37.23012], [-121.79425, 37.23066], [-121.79397, 37.23067], [-121.79398, 37.23012], [-121.79425, 37.23012]]]]} | Open Access 1 | Albertson Parkway | 15341 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2.047 | Albertson Parkway | 1998 | |
1438 | 1438 | 1437 | {"type": "Polygon", "coordinates": [[[-120.58918, 37.34515], [-120.58917, 37.34574], [-120.58912, 37.34686], [-120.58835, 37.34684], [-120.58786, 37.34686], [-120.5876, 37.34684], [-120.58758, 37.34649], [-120.5876, 37.34644], [-120.58761, 37.34609], [-120.58819, 37.34609], [-120.58822, 37.34561], [-120.58823, 37.34513], [-120.58918, 37.34515]]]} | Open Access 1 | Albiani Park | 15342 | 1014 | Atwater, City of 463 | City 2 | City Agency 2 | http://www.atwater.org/index.cfm?page=940884 | City 2 | 5.063 | Albiani 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]);