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,330
- County Agency 973
- Recreation/Parks District 956
- State Agency 651
- Non Profit - Land Trust 459
- Open Space District 211
- Federal Agency 194
- County Agency - Parks 189
- Community Services District 181
- Water District 164
- Home Owners Association 145
- Non Profit - Conservation 103
- Flood District 90
- Cemetery District 60
- Non Profit - Other 33
- Port/Harbor District 31
- County Agency - Other 28
- Irrigation District 16
- School District 13
- Special District - Other 11
- Commercial 10
- Sanitation District 9
- Joint Powers Authority 5
- Other 5
- Non Profit - Cemetery District 5
- Conservation District 5
- Mitigation Bank 4
- Transportation Agency 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- Los Angeles, City of 418
- San Diego, City of 399
- California Department of Fish and Wildlife 306
- San Jose, City of 230
- San Francisco, City and County of 210
- Sacramento, City of 198
- California Department of Parks and Recreation 165
- Mountains Recreation and Conservation Authority 163
- Los Angeles, County of 153
- Ventura, City of 147
- Long Beach, City of 137
- Roseville, City of 119
- San Diego, County of 115
- East Bay Regional Park District 113
- Oakland, City of 108
- Irvine, City of 96
- Fresno, City of 92
- Consumnes Community Services District 89
- Modesto, City of 78
- Hayward Area Recreation and Park District 77
- Santa Barbara, County of 76
- Huntington Beach, City of 74
- Stockton, City of 74
- Orange, County of 72
- Torrance, City of 71
- Tracy, City of 69
- Santa Rosa, City of 68
- Santa Cruz, City of 66
- Chula Vista, City of 66
- Poway, City of 62
- …
ACCESS_TYP 4
- Open Access 12,031
- Restricted Access 938
- No Public Access 679
- Unknown Access 245
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1746 | 1746 | 1745 | {"type": "Polygon", "coordinates": [[[-117.22851, 33.7902], [-117.22628, 33.7902], [-117.22628, 33.78801], [-117.22746, 33.788], [-117.22746, 33.78955], [-117.22846, 33.78956], [-117.22851, 33.7902]]]} | Open Access 1 | Banta Beatty Park | 15802 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 8.224 | Banta Beatty Park | ||
1747 | 1747 | 1746 | {"type": "MultiPolygon", "coordinates": [[[[-117.16654, 32.73769], [-117.16637, 32.73802], [-117.16607, 32.73803], [-117.16607, 32.73863], [-117.16568, 32.73863], [-117.16567, 32.73844], [-117.16534, 32.73844], [-117.16534, 32.7383], [-117.1654, 32.73828], [-117.16539, 32.73764], [-117.16566, 32.73764], [-117.16567, 32.73753], [-117.16593, 32.73753], [-117.16595, 32.73769], [-117.16625, 32.73769], [-117.16624, 32.73773], [-117.16625, 32.73774], [-117.16636, 32.73774], [-117.16638, 32.73769], [-117.16654, 32.73769]]], [[[-117.16627, 32.73925], [-117.16594, 32.73926], [-117.16593, 32.7388], [-117.16627, 32.7388], [-117.16627, 32.73925]]]]} | Open Access 1 | Banker's Hill Canyon Open Space | 15796 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 2.368 | Banker's Hill Canyon OS | ||
1748 | 1748 | 1747 | {"type": "Polygon", "coordinates": [[[-117.72456, 34.11639], [-117.72451, 34.11639], [-117.72448, 34.11643], [-117.72444, 34.11644], [-117.72362, 34.11612], [-117.7234, 34.11606], [-117.72316, 34.11602], [-117.72044, 34.11598], [-117.72041, 34.11595], [-117.7204, 34.11592], [-117.72039, 34.11434], [-117.7245, 34.11437], [-117.72447, 34.11458], [-117.72447, 34.11603], [-117.7245, 34.11619], [-117.72456, 34.1162], [-117.72456, 34.11639]]]} | Open Access 1 | Cahuilla Park | 16663 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 17.742 | Cahuilla Park | ||
1749 | 1749 | 1748 | {"type": "Polygon", "coordinates": [[[-116.20372, 33.73346], [-116.20136, 33.73345], [-116.20135, 33.73248], [-116.20244, 33.73249], [-116.20262, 33.73252], [-116.2029, 33.73262], [-116.20312, 33.73267], [-116.20332, 33.73268], [-116.20372, 33.73268], [-116.20372, 33.73346]]]} | Open Access 1 | Cahuilla Park | 16664 | 1145 | Indio, City of 216 | City 2 | City Agency 2 | http://www.indio.org/index.aspx?page=90 | City 2 | 5.359 | Cahuilla Park | ||
1750 | 1750 | 1749 | {"type": "Polygon", "coordinates": [[[-121.87741, 37.32001], [-121.87733, 37.32006], [-121.8769, 37.31949], [-121.8769, 37.31949], [-121.87741, 37.32001]]]} | Open Access 1 | Caldwallder Park | 16674 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.082 | Caldwallder Park | ||
1751 | 1751 | 1750 | {"type": "Polygon", "coordinates": [[[-118.95258, 34.15965], [-118.95191, 34.15988], [-118.95174, 34.15957], [-118.9516, 34.15941], [-118.95136, 34.15924], [-118.95118, 34.15915], [-118.95127, 34.15911], [-118.95136, 34.15904], [-118.95142, 34.15891], [-118.95142, 34.15885], [-118.95126, 34.15851], [-118.95089, 34.15713], [-118.94971, 34.15665], [-118.94978, 34.15661], [-118.95097, 34.15694], [-118.95211, 34.15752], [-118.95204, 34.15763], [-118.95258, 34.15965]]]} | Open Access 1 | Banyan Park | 15803 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 6.949 | Banyan Park | ||
1752 | 1752 | 1751 | {"type": "Polygon", "coordinates": [[[-117.65338, 33.57827], [-117.65327, 33.57829], [-117.65319, 33.57832], [-117.65311, 33.57841], [-117.65252, 33.57938], [-117.6515, 33.57897], [-117.65142, 33.57895], [-117.65131, 33.57897], [-117.65136, 33.57891], [-117.65146, 33.57884], [-117.65149, 33.57885], [-117.65167, 33.57868], [-117.65227, 33.57803], [-117.65338, 33.57827]]]} | Open Access 1 | Barbadanes Park | 15804 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 3.37 | Barbadanes Park | ||
1753 | 1753 | 1752 | {"type": "Polygon", "coordinates": [[[-121.81971, 38.01823], [-121.81971, 38.01999], [-121.818, 38.01898], [-121.81795, 38.0188], [-121.81877, 38.0185], [-121.81917, 38.01849], [-121.81916, 38.0184], [-121.81862, 38.01842], [-121.81811, 38.01859], [-121.81783, 38.01857], [-121.81744, 38.01825], [-121.8171, 38.0182], [-121.81671, 38.01823], [-121.81617, 38.01813], [-121.81609, 38.01802], [-121.81597, 38.01801], [-121.81592, 38.01785], [-121.81971, 38.01823]]]} | Open Access 1 | Barbara Price Marina Park | 15805 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 6.691 | Barbara Price Marina Park | ||
1754 | 1754 | 1753 | {"type": "Polygon", "coordinates": [[[-118.09105, 33.8752], [-118.09097, 33.87507], [-118.0907, 33.87482], [-118.09062, 33.87469], [-118.09095, 33.87469], [-118.09106, 33.87497], [-118.09105, 33.8752]]]} | Open Access 1 | Barber Park | 15806 | 1010 | Artesia, City of 549 | City 2 | City Agency 2 | http://www.cityofartesia.us/index.aspx?nid=127 | City 2 | 0.253 | Barber Park | ||
1755 | 1755 | 1754 | {"type": "MultiPolygon", "coordinates": [[[[-121.81736, 37.31364], [-121.8153, 37.31502], [-121.81397, 37.31591], [-121.81404, 37.31557], [-121.81408, 37.31554], [-121.81431, 37.31549], [-121.81447, 37.31539], [-121.81459, 37.31525], [-121.81465, 37.31511], [-121.81476, 37.31501], [-121.81492, 37.31494], [-121.81519, 37.31489], [-121.81535, 37.31481], [-121.81609, 37.31431], [-121.81679, 37.31386], [-121.81692, 37.31374], [-121.81701, 37.31356], [-121.81708, 37.31349], [-121.81717, 37.31348], [-121.81725, 37.31354], [-121.81727, 37.31354], [-121.81736, 37.31364]]], [[[-121.8212, 37.31105], [-121.8176, 37.31346], [-121.8174, 37.31329], [-121.81739, 37.31326], [-121.81741, 37.31321], [-121.81755, 37.31312], [-121.81769, 37.31306], [-121.81803, 37.31296], [-121.8182, 37.31289], [-121.81946, 37.31205], [-121.81964, 37.31188], [-121.81983, 37.3116], [-121.82001, 37.31145], [-121.8202, 37.31136], [-121.82077, 37.31116], [-121.82105, 37.311], [-121.82113, 37.311], [-121.8212, 37.31105]]]]} | Open Access 1 | Barberry Pathway | 15808 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 3.881 | Barberry Pathway | ||
1756 | 1756 | 1755 | {"type": "Polygon", "coordinates": [[[-122.87222, 38.64282], [-122.87178, 38.64314], [-122.87062, 38.64408], [-122.87, 38.64377], [-122.86856, 38.64383], [-122.86689, 38.64229], [-122.86594, 38.64229], [-122.86592, 38.6421], [-122.86587, 38.64188], [-122.86589, 38.64183], [-122.86593, 38.64181], [-122.86644, 38.6417], [-122.86694, 38.64153], [-122.86732, 38.64133], [-122.86766, 38.64109], [-122.86884, 38.64215], [-122.86908, 38.64199], [-122.8692, 38.64207], [-122.86931, 38.64209], [-122.86942, 38.64206], [-122.86958, 38.64195], [-122.86977, 38.64211], [-122.87056, 38.64211], [-122.87065, 38.64219], [-122.87141, 38.64269], [-122.87155, 38.64277], [-122.87171, 38.64282], [-122.87188, 38.64284], [-122.87206, 38.64284], [-122.87222, 38.64282]]]} | Open Access 1 | Barbieri Brothers Park | 15809 | 1131 | Healdsburg, City of 369 | City 2 | City Agency 2 | http://www.ci.healdsburg.ca.us/index.aspx?page=94 | City 2 | 19.749 | Barbieri Brothers Park | ||
1757 | 1757 | 1756 | {"type": "Polygon", "coordinates": [[[-121.58711, 39.81342], [-121.58621, 39.81385], [-121.58619, 39.81385], [-121.58633, 39.81373], [-121.58677, 39.81349], [-121.58711, 39.81342]]]} | Open Access 1 | Butte holding 21 | 16565 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.131 | Butte holding 21 | ||
1758 | 1758 | 1757 | {"type": "MultiPolygon", "coordinates": [[[[-121.44227, 37.72363], [-121.44223, 37.7237], [-121.44136, 37.72401], [-121.44088, 37.72409], [-121.4408, 37.72405], [-121.44072, 37.7238], [-121.44073, 37.72376], [-121.44075, 37.72375], [-121.44091, 37.72373], [-121.44135, 37.72373], [-121.44149, 37.72378], [-121.44161, 37.72377], [-121.44167, 37.72374], [-121.4417, 37.72369], [-121.44171, 37.72362], [-121.44167, 37.72356], [-121.44179, 37.7235], [-121.44179, 37.72335], [-121.44221, 37.72335], [-121.44223, 37.7235], [-121.44227, 37.72363]]], [[[-121.44384, 37.72334], [-121.44325, 37.72335], [-121.44255, 37.72359], [-121.44246, 37.72355], [-121.44243, 37.72347], [-121.44242, 37.72313], [-121.44247, 37.72308], [-121.44285, 37.72302], [-121.4435, 37.72287], [-121.44384, 37.72283], [-121.44384, 37.72334]]]]} | Open Access 1 | Barbozo Park | 15810 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 2.773 | Barbozo Park | ||
1759 | 1759 | 1758 | {"type": "Polygon", "coordinates": [[[-117.65837, 33.63225], [-117.65835, 33.63227], [-117.65821, 33.63231], [-117.65796, 33.63233], [-117.65783, 33.63242], [-117.65752, 33.63232], [-117.65736, 33.63233], [-117.65733, 33.63239], [-117.65718, 33.63239], [-117.65721, 33.63178], [-117.65731, 33.63152], [-117.6573, 33.63142], [-117.65727, 33.63131], [-117.65719, 33.63111], [-117.65714, 33.63103], [-117.65827, 33.63102], [-117.65825, 33.63123], [-117.65826, 33.63171], [-117.65832, 33.63204], [-117.65838, 33.6322], [-117.65837, 33.63225]]]} | Open Access 1 | Barcelona Park | 15811 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 3.58 | Barcelona Park | ||
1760 | 1760 | 1759 | {"type": "Polygon", "coordinates": [[[-118.9423, 34.36055], [-118.9423, 34.36195], [-118.94129, 34.36223], [-118.94128, 34.36118], [-118.93907, 34.36194], [-118.93823, 34.36211], [-118.93755, 34.3607], [-118.93811, 34.3605], [-118.9423, 34.36055]]]} | Open Access 1 | Bardsdale Cemetery | 15812 | 2005 | Bardsdale Cemetery District 508 | Special District 4 | Cemetery District 11 | http://bardsdalecemetery.com/ | Special District 4 | 14.328 | Bardsdale Cemetery | ||
1761 | 1761 | 1760 | {"type": "Polygon", "coordinates": [[[-116.54353, 33.81885], [-116.54196, 33.81885], [-116.54196, 33.81846], [-116.54228, 33.8185], [-116.54264, 33.81853], [-116.54293, 33.81858], [-116.54323, 33.81868], [-116.54341, 33.81877], [-116.54353, 33.81885]]]} | Open Access 1 | Baristo Park | 15814 | 1241 | Palm Springs, City of 546 | City 2 | City Agency 2 | http://www.ci.palm-springs.ca.us/index.aspx?page=80 | City 2 | 1.082 | Baristo Park | ||
1762 | 1762 | 1761 | {"type": "Polygon", "coordinates": [[[-122.4602, 37.68387], [-122.45987, 37.68387], [-122.45987, 37.68365], [-122.4602, 37.68363], [-122.4602, 37.68387]]]} | Open Access 1 | Bark Park | 15815 | 1456 | Colma, City of 934 | City 2 | City Agency 2 | http://www.colma.ca.gov/ | City 2 | 0.187 | Bark Park | ||
1763 | 1763 | 1762 | {"type": "MultiPolygon", "coordinates": [[[[-119.34483, 35.58715], [-119.34481, 35.58877], [-119.34272, 35.58876], [-119.34274, 35.58715], [-119.34483, 35.58715]]], [[[-119.34698, 35.58716], [-119.34695, 35.58877], [-119.34494, 35.58876], [-119.34496, 35.58715], [-119.34698, 35.58716]]]]} | Open Access 1 | Barker Park | 15817 | 2175 | Wasco Recreation and Park District 458 | Special District 4 | Recreation/Parks District 4 | http://www.wascoparks.com/ | Special District 4 | 16.436 | Barker Park | ||
1764 | 1764 | 1763 | {"type": "Polygon", "coordinates": [[[-121.34974, 37.99512], [-121.34936, 37.99513], [-121.34921, 37.99498], [-121.34906, 37.99488], [-121.34854, 37.99465], [-121.34831, 37.99453], [-121.34808, 37.99433], [-121.34972, 37.99431], [-121.34974, 37.99512]]]} | Open Access 1 | Barkleyville Dog Park | 15818 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1.985 | Barkleyville Dog Park | ||
1765 | 1765 | 1764 | {"type": "Polygon", "coordinates": [[[-118.48789, 34.00292], [-118.48772, 34.00305], [-118.48765, 34.00305], [-118.48759, 34.00303], [-118.48743, 34.00263], [-118.48732, 34.00241], [-118.48573, 34.00074], [-118.48564, 34.00056], [-118.48456, 33.99943], [-118.48443, 33.99935], [-118.48412, 33.99903], [-118.48337, 33.99821], [-118.48336, 33.99817], [-118.48347, 33.99814], [-118.48499, 33.99976], [-118.48551, 34.00018], [-118.48683, 34.00156], [-118.48696, 34.00176], [-118.48754, 34.00237], [-118.48748, 34.00241], [-118.4875, 34.00246], [-118.48748, 34.00251], [-118.48789, 34.00292]]]} | Open Access 1 | Barnard Way Linear Park | 15820 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 2.747 | Barnard Way Linear 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]);