superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by PARK_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: LAYER
MNG_AG_TYP >30
- City Agency 10,210
- County Agency 1,102
- Recreation/Parks District 1,091
- State Agency 872
- Non Profit - Land Trust 511
- Federal Agency 289
- 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
- …
MNG_AGENCY >30
- Los Angeles, City of 465
- San Diego, City of 433
- California Department of Fish and Wildlife 394
- California Department of Parks and Recreation 276
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 218
- Mountains Recreation and Conservation Authority 181
- Los Angeles, County of 171
- Ventura, City of 151
- Long Beach, City of 148
- East Bay Regional Park District 132
- Roseville, City of 124
- Oakland, City of 122
- San Diego, County of 120
- Irvine, City of 98
- Fresno, City of 94
- Consumnes Community Services District 92
- Santa Barbara, County of 89
- Hayward Area Recreation and Park District 84
- Modesto, City of 84
- Orange, County of 82
- Stockton, City of 81
- Santa Rosa, City of 79
- Huntington Beach, City of 76
- Tracy, City of 73
- Torrance, City of 72
- Santa Cruz, City of 69
- Chula Vista, City of 69
- Brentwood, City of 68
- …
MNG_AG_LEV 8 ✖
- City 10,210
- Special District 2,000
- County 1,352
- State 872
- Non Profit 682
- Federal 289
- Private 226
- Joint 7
ACCESS_TYP 4
- Open Access 13,512
- Restricted Access 1,118
- No Public Access 754
- Unknown Access 254
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11941 | 11941 | 11940 | {"type": "Polygon", "coordinates": [[[-118.2853, 33.94082], [-118.2853, 33.94114], [-118.28516, 33.94114], [-118.28516, 33.94082], [-118.2853, 33.94082]]]} | Open Access 1 | 105th Street Pocket Park | http://www.laparks.org/environmental/105th.htm | 28734 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.111 | 105th Street PP | |
1388 | 1388 | 1387 | {"type": "Polygon", "coordinates": [[[-118.24932, 33.93589], [-118.24931, 33.93673], [-118.24783, 33.93674], [-118.24784, 33.93589], [-118.24932, 33.93589]]]} | Open Access 1 | 109th Street Recreation Center | 15168 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.183 | 109th Street Rec. Ctr. | ||
1387 | 1387 | 1386 | {"type": "Polygon", "coordinates": [[[-122.46853, 37.78203], [-122.4677, 37.78207], [-122.46767, 37.78166], [-122.4685, 37.78162], [-122.46853, 37.78203]], [[-122.4682, 37.78188], [-122.46824, 37.78187], [-122.46824, 37.78181], [-122.46819, 37.7818], [-122.46818, 37.78172], [-122.46796, 37.78173], [-122.46798, 37.78197], [-122.46819, 37.78197], [-122.4682, 37.78188]]]} | Open Access 1 | 10th Ave & Clement Mini Park | 15169 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.689 | 10th Ave & Clement MP | ||
9897 | 9897 | 9896 | {"type": "Polygon", "coordinates": [[[-118.2713, 33.93401], [-118.2713, 33.93437], [-118.2712, 33.93437], [-118.2712, 33.93401], [-118.2713, 33.93401]]]} | Open Access 1 | 111th Place Neighborhood Park | http://www.laparks.org/environmental/pdf/111thPark.pdf | 27920 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.09 | 111th Place Neighborhood Park | |
12017 | 12017 | 12016 | {"type": "MultiPolygon", "coordinates": [[[[-118.24124, 33.92765], [-118.24116, 33.9276], [-118.24085, 33.92733], [-118.24124, 33.92733], [-118.24124, 33.92765]]], [[[-118.24433, 33.92779], [-118.24433, 33.92814], [-118.24389, 33.92811], [-118.2427, 33.92796], [-118.24172, 33.92781], [-118.24433, 33.92779]]], [[[-118.24465, 33.92779], [-118.24465, 33.92817], [-118.24449, 33.92815], [-118.24449, 33.92779], [-118.24465, 33.92779]]], [[[-118.24611, 33.92784], [-118.24611, 33.9282], [-118.24572, 33.9282], [-118.2457, 33.92817], [-118.24482, 33.92817], [-118.24482, 33.92779], [-118.24607, 33.92779], [-118.24611, 33.92784]]]]} | Unknown Access 4 | 117th and Compton | 28898 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 2.883 | 117th and Compton | ||
11198 | 11198 | 11197 | {"type": "Polygon", "coordinates": [[[-118.34102, 33.92741], [-118.34102, 33.92741], [-118.34058, 33.92712], [-118.34101, 33.92713], [-118.34102, 33.92741]]]} | Open Access 1 | 118th Street Mini Park | 29761 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 0.154 | 118th Street MP | ||
11955 | 11955 | 11954 | {"type": "Polygon", "coordinates": [[[-118.32926, 33.98393], [-118.32926, 33.98408], [-118.32896, 33.98418], [-118.32863, 33.98434], [-118.32863, 33.98418], [-118.3287, 33.98418], [-118.32926, 33.98393]]]} | Open Access 1 | 11th Avenue Park | http://www.lanlt.org/parks-and-gardens.php#11th | 28781 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.207 | 11th Avenue Park | |
13671 | 13671 | 13670 | {"type": "Polygon", "coordinates": [[[-118.0693, 33.71722], [-118.06917, 33.71732], [-118.06861, 33.71687], [-118.06878, 33.71676], [-118.0693, 33.71722]]]} | Open Access 1 | 11th Street Beach Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/11th-street-beach-park.cfm | 31159 | 1142 | Huntington Park, City of 83 | City 2 | City Agency 2 | http://www.hpca.gov/index.aspx?nid=14 | City 2 | 0.322 | 11th Street Beach Park | |
13576 | 13576 | 13575 | {"type": "Polygon", "coordinates": [[[-120.4815, 37.29325], [-120.48128, 37.29362], [-120.48113, 37.29357], [-120.48134, 37.29319], [-120.4815, 37.29325]]]} | Open Access 1 | 11th Street Neighborhood Park | https://www.cityofmerced.org/depts/parks_n_community_services/parks_n_facilities/parks/mini.asp | 31016 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 0.172 | 11th Street Neighborhood Park | |
1385 | 1385 | 1384 | {"type": "Polygon", "coordinates": [[[-117.64341, 34.11057], [-117.64175, 34.11057], [-117.6417, 34.11053], [-117.6417, 34.11008], [-117.64338, 34.11007], [-117.64341, 34.11011], [-117.64341, 34.11057]]]} | Open Access 1 | 13th Street Reservoir Park | 15171 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 2.128 | 13th Street Reservoir Park | ||
14819 | 14819 | 14818 | {"type": "MultiPolygon", "coordinates": [[[[-122.47227, 37.75682], [-122.47215, 37.75701], [-122.47202, 37.75727], [-122.47195, 37.75729], [-122.47141, 37.75706], [-122.47129, 37.75699], [-122.4712, 37.7569], [-122.47111, 37.75678], [-122.47106, 37.75666], [-122.47105, 37.75655], [-122.47106, 37.75638], [-122.47147, 37.75639], [-122.47146, 37.75656], [-122.47151, 37.75669], [-122.47162, 37.75678], [-122.47178, 37.75685], [-122.47194, 37.75665], [-122.47227, 37.75682]]], [[[-122.47149, 37.75605], [-122.47147, 37.75632], [-122.47108, 37.75631], [-122.47109, 37.75604], [-122.47149, 37.75605]]], [[[-122.47257, 37.75623], [-122.47259, 37.75633], [-122.47257, 37.75647], [-122.47251, 37.75655], [-122.47232, 37.75676], [-122.47199, 37.75659], [-122.47219, 37.75636], [-122.4722, 37.75634], [-122.47197, 37.75608], [-122.47171, 37.7559], [-122.47192, 37.75563], [-122.47207, 37.75572], [-122.47224, 37.75585], [-122.47238, 37.756], [-122.47257, 37.75623]]]]} | Open Access 1 | 14th & 15th Avenue Open Space | 15172 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.667 | 14th & 15th Avenue OS | ||
1386 | 1386 | 1385 | {"type": "MultiPolygon", "coordinates": [[[[-118.19093, 33.78373], [-118.19093, 33.78389], [-118.19012, 33.78389], [-118.19012, 33.78373], [-118.19093, 33.78373]]], [[[-118.19225, 33.78389], [-118.1912, 33.78389], [-118.1912, 33.78373], [-118.19225, 33.78373], [-118.19225, 33.78389]]], [[[-118.19492, 33.78372], [-118.19492, 33.78389], [-118.19388, 33.78389], [-118.19388, 33.78372], [-118.19492, 33.78372]]], [[[-118.19623, 33.78372], [-118.19623, 33.78389], [-118.19519, 33.78389], [-118.19519, 33.78372], [-118.19623, 33.78372]]]]} | Open Access 1 | 14th Street Park and Playground | 15173 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.66 | 14th Street Park and Playground | ||
1389 | 1389 | 1388 | {"type": "Polygon", "coordinates": [[[-122.47276, 37.75963], [-122.47242, 37.75965], [-122.47242, 37.75992], [-122.47229, 37.75993], [-122.47226, 37.75966], [-122.47186, 37.75967], [-122.47184, 37.75949], [-122.47225, 37.75947], [-122.47223, 37.75917], [-122.47237, 37.75919], [-122.47241, 37.75955], [-122.47275, 37.75954], [-122.47276, 37.75963]]]} | Open Access 1 | 15th Avenue Steps | 15174 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.525 | 15th Avenue Steps | ||
1074 | 1074 | 1073 | {"type": "Polygon", "coordinates": [[[-120.61198, 35.11407], [-120.61192, 35.1148], [-120.60972, 35.11469], [-120.60972, 35.11439], [-120.60966, 35.11409], [-120.61027, 35.11394], [-120.61038, 35.11396], [-120.6107, 35.11398], [-120.6107, 35.11401], [-120.61198, 35.11407]]]} | Open Access 1 | 16th Street Park | 15175 | 1452 | Grover Beach, City of 643 | City 2 | City Agency 2 | http://www.grover.org/index.aspx?nid=141 | City 2 | 4.081 | 16th Street Park | ||
1075 | 1075 | 1074 | {"type": "Polygon", "coordinates": [[[-119.7988, 36.28916], [-119.79442, 36.28915], [-119.7944, 36.289], [-119.79335, 36.289], [-119.79335, 36.28889], [-119.79441, 36.28841], [-119.79847, 36.28677], [-119.7987, 36.28683], [-119.79873, 36.28803], [-119.79881, 36.28828], [-119.7988, 36.28916]]]} | Open Access 1 | 19th Avenue Park | 15176 | 1174 | Lemoore, City of 375 | City 2 | City Agency 2 | http://www.lemoore.com/parks/default.html | City 2 | 18.282 | 19th Avenue Park | ||
15511 | 15511 | 15510 | {"type": "Polygon", "coordinates": [[[-118.24477, 34.05427], [-118.24461, 34.05444], [-118.24458, 34.05443], [-118.24454, 34.05448], [-118.24455, 34.05451], [-118.24403, 34.05507], [-118.2432, 34.05453], [-118.24394, 34.05373], [-118.24477, 34.05427]]]} | Open Access 1 | 1st and Broadway Civic Center Park | 29093 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 2.682 | 1st and Broadway Civic Ctr. Park | ||
1076 | 1076 | 1075 | {"type": "Polygon", "coordinates": [[[-124.174, 40.78401], [-124.174, 40.78456], [-124.17298, 40.78455], [-124.17296, 40.78439], [-124.17198, 40.78439], [-124.17198, 40.78413], [-124.17248, 40.78413], [-124.1725, 40.78384], [-124.17296, 40.78384], [-124.17298, 40.78375], [-124.17379, 40.78376], [-124.1738, 40.784], [-124.174, 40.78401]]]} | Open Access 1 | 20-30 Park and Playground | 15177 | 1419 | Eureka, City of 698 | City 2 | City Agency 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | City 2 | 2.707 | 20-30 Park and Playground | ||
596 | 596 | 595 | {"type": "MultiPolygon", "coordinates": [[[[-121.81612, 39.73135], [-121.81386, 39.73158], [-121.81324, 39.73086], [-121.81256, 39.72996], [-121.81236, 39.72969], [-121.81297, 39.7294], [-121.81278, 39.72916], [-121.81233, 39.72845], [-121.81238, 39.72842], [-121.81242, 39.72694], [-121.81242, 39.72644], [-121.81291, 39.72644], [-121.81431, 39.72746], [-121.81522, 39.72735], [-121.81532, 39.72743], [-121.81549, 39.72741], [-121.81549, 39.72792], [-121.81551, 39.72811], [-121.81561, 39.72812], [-121.81612, 39.73135]]], [[[-121.81639, 39.73299], [-121.81549, 39.73308], [-121.81469, 39.73241], [-121.81424, 39.73197], [-121.8139, 39.73162], [-121.81613, 39.7314], [-121.81639, 39.73299]]]]} | Open Access 1 | 20th Street Park | 15178 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 37.862 | 20th Street Park | ||
597 | 597 | 596 | {"type": "Polygon", "coordinates": [[[-121.64347, 37.11265], [-121.64347, 37.11268], [-121.64305, 37.11279], [-121.64285, 37.11264], [-121.64329, 37.11251], [-121.64335, 37.1126], [-121.64341, 37.11259], [-121.64345, 37.11264], [-121.64347, 37.11265]]]} | Open Access 1 | 21 Mile Park | 15179 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 0.221 | 21 Mile Park | ||
1352 | 1352 | 1351 | {"type": "MultiPolygon", "coordinates": [[[[-121.41423, 38.53216], [-121.41422, 38.53219], [-121.41307, 38.5322], [-121.41293, 38.53216], [-121.41289, 38.53211], [-121.41292, 38.53205], [-121.41299, 38.53202], [-121.41418, 38.53201], [-121.41422, 38.53203], [-121.41423, 38.53216]]], [[[-121.41671, 38.53219], [-121.41444, 38.53219], [-121.41441, 38.53218], [-121.41439, 38.53203], [-121.41442, 38.53202], [-121.41666, 38.53202], [-121.4167, 38.53204], [-121.41671, 38.53219]]], [[[-121.41912, 38.53205], [-121.41898, 38.53229], [-121.4189, 38.53231], [-121.41792, 38.53231], [-121.4169, 38.5322], [-121.41688, 38.53218], [-121.41688, 38.53204], [-121.41691, 38.53202], [-121.41909, 38.53202], [-121.41912, 38.53205]]], [[[-121.42107, 38.53205], [-121.42106, 38.53229], [-121.42104, 38.53231], [-121.41918, 38.5323], [-121.41933, 38.53204], [-121.41937, 38.53202], [-121.42105, 38.53202], [-121.42107, 38.53205]]], [[[-121.42604, 38.53216], [-121.42604, 38.53227], [-121.42601, 38.53228], [-121.42297, 38.53227], [-121.42248, 38.53232], [-121.42127, 38.53231], [-121.42124, 38.53229], [-121.42125, 38.53205], [-121.42128, 38.53203], [-121.42312, 38.53203], [-121.42419, 38.53215], [-121.42604, 38.53216]]], [[[-121.42712, 38.53223], [-121.42711, 38.53225], [-121.42691, 38.53224], [-121.42677, 38.53228], [-121.42624, 38.53228], [-121.42622, 38.53227], [-121.42623, 38.53217], [-121.42624, 38.53215], [-121.42663, 38.53217], [-121.42712, 38.53223]]], [[[-121.4294, 38.53226], [-121.42938, 38.53227], [-121.42797, 38.53227], [-121.42796, 38.53226], [-121.42797, 38.53225], [-121.42818, 38.53225], [-121.4284, 38.53221], [-121.42899, 38.53215], [-121.42939, 38.53214], [-121.4294, 38.53226]]], [[[-121.43268, 38.53227], [-121.43264, 38.5323], [-121.43224, 38.5323], [-121.43202, 38.53227], [-121.42961, 38.53227], [-121.42959, 38.53226], [-121.42959, 38.53215], [-121.42962, 38.53214], [-121.43037, 38.53214], [-121.43129, 38.53203], [-121.43265, 38.53202], [-121.43268, 38.53204], [-121.43268, 38.53227]]], [[[-121.43518, 38.53217], [-121.43516, 38.5322], [-121.43456, 38.53227], [-121.43288, 38.5323], [-121.43286, 38.53229], [-121.43286, 38.53204], [-121.43289, 38.53201], [-121.43512, 38.53199], [-121.43515, 38.53201], [-121.43518, 38.53217]]], [[[-121.43864, 38.53198], [-121.43853, 38.53212], [-121.43848, 38.53213], [-121.43566, 38.53216], [-121.4354, 38.53218], [-121.43537, 38.53217], [-121.43533, 38.53201], [-121.43535, 38.53198], [-121.43863, 38.53196], [-121.43864, 38.53198]]], [[[-121.44204, 38.53208], [-121.44201, 38.53209], [-121.43875, 38.53213], [-121.43874, 38.53211], [-121.43884, 38.53197], [-121.43888, 38.53195], [-121.44129, 38.53192], [-121.44158, 38.53195], [-121.44202, 38.53194], [-121.44204, 38.53196], [-121.44204, 38.53208]]], [[[-121.44319, 38.53205], [-121.44317, 38.53206], [-121.44224, 38.53209], [-121.44222, 38.53208], [-121.44222, 38.53196], [-121.44224, 38.53194], [-121.44318, 38.53193], [-121.44319, 38.53196], [-121.44319, 38.53205]]], [[[-121.44435, 38.53195], [-121.44434, 38.53204], [-121.44432, 38.53206], [-121.44339, 38.53206], [-121.44337, 38.53204], [-121.44338, 38.53195], [-121.4434, 38.53194], [-121.44435, 38.53195]]], [[[-121.44543, 38.53192], [-121.44542, 38.53194], [-121.4452, 38.53199], [-121.4449, 38.53204], [-121.44455, 38.53206], [-121.44453, 38.53203], [-121.44453, 38.53195], [-121.44456, 38.53193], [-121.44543, 38.53192]]]]} | Open Access 1 | 21st Avenue Parkway | 15182 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 13.335 | 21st Avenue Parkway |
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]);