superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,210 rows where MNG_AG_TYP = 2 sorted by PARK_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 373
- San Diego, City of 329
- San Jose, City of 196
- San Francisco, City and County of 184
- Sacramento, City of 176
- Ventura, City of 139
- Long Beach, City of 112
- Roseville, City of 108
- Oakland, City of 89
- Irvine, City of 81
- Fresno, City of 76
- Torrance, City of 66
- Stockton, City of 66
- Modesto, City of 64
- Tracy, City of 62
- Santa Rosa, City of 59
- Chula Vista, City of 59
- Huntington Beach, City of 59
- Poway, City of 59
- Santa Barbara, City of 56
- Santa Cruz, City of 55
- Napa, City of 55
- Encinitas, City of 54
- San Luis Obispo, City of 52
- Davis, City of 51
- Clovis, City of 49
- Manteca, City of 47
- Rocklin, City of 47
- Brentwood, City of 45
- Anaheim, City of 44
- …
ACCESS_TYP 4
- Open Access 7,586
- Restricted Access 279
- No Public Access 121
- Unknown Access 26
MNG_AG_TYP 1
- City Agency · 8,012 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13676 | 13676 | 13675 | {"type": "Polygon", "coordinates": [[[-118.0585, 33.7167], [-118.05849, 33.71686], [-118.05845, 33.71692], [-118.0584, 33.71695], [-118.05831, 33.71697], [-118.05784, 33.71697], [-118.05784, 33.7167], [-118.0585, 33.7167]]]} | Open Access 1 | Davenport Beach Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/davenport-beach-park.cfm | 31164 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 0.443 | Davenport Beach Park | |
3452 | 3452 | 3451 | {"type": "Polygon", "coordinates": [[[-122.30822, 37.83781], [-122.30821, 37.83825], [-122.30811, 37.83834], [-122.30805, 37.83835], [-122.30808, 37.83859], [-122.30688, 37.8386], [-122.30689, 37.83838], [-122.30764, 37.83834], [-122.30752, 37.83805], [-122.30775, 37.83797], [-122.30776, 37.83792], [-122.30772, 37.83783], [-122.30779, 37.8378], [-122.30749, 37.83723], [-122.30818, 37.83723], [-122.30819, 37.83736], [-122.30811, 37.8375], [-122.30811, 37.83779], [-122.30822, 37.83781]]]} | Open Access 1 | Davenport Park | 17939 | 1098 | Emeryville, City of 769 | City 2 | City Agency 2 | http://www.ci.emeryville.ca.us/158/City-Parks | City 2 | 2.112 | Davenport Park | ||
3453 | 3453 | 3452 | {"type": "Polygon", "coordinates": [[[-120.45683, 37.33995], [-120.45637, 37.33993], [-120.45612, 37.33986], [-120.45579, 37.3397], [-120.45557, 37.33956], [-120.45533, 37.33946], [-120.45505, 37.33936], [-120.45469, 37.33931], [-120.45401, 37.33931], [-120.45403, 37.33859], [-120.45463, 37.33855], [-120.45505, 37.33842], [-120.45638, 37.33845], [-120.45647, 37.33853], [-120.45669, 37.33865], [-120.45678, 37.33875], [-120.45683, 37.33995]]]} | Open Access 1 | Davenport Park | 17940 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 7.283 | Davenport Park | ||
11925 | 11925 | 11924 | {"type": "Polygon", "coordinates": [[[-118.15763, 33.85724], [-118.15761, 33.85726], [-118.15761, 33.85746], [-118.15552, 33.85747], [-118.15552, 33.85685], [-118.1555, 33.85684], [-118.15551, 33.85637], [-118.15762, 33.85637], [-118.15763, 33.85724]]]} | Open Access 1 | Davenport Park | 28713 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 5.858 | Davenport Park | ||
13942 | 13942 | 13941 | {"type": "Polygon", "coordinates": [[[-118.09712, 33.9437], [-118.09706, 33.94375], [-118.09704, 33.94388], [-118.09699, 33.94392], [-118.09695, 33.94391], [-118.09685, 33.94381], [-118.09681, 33.94379], [-118.09675, 33.94378], [-118.0967, 33.9438], [-118.09668, 33.94379], [-118.09687, 33.94372], [-118.09712, 33.9437]]]} | Open Access 1 | Davenrich Parkette | 32539 | 1321 | Santa Fe Springs, City of 207 | City 2 | City Agency 2 | http://www.santafesprings.org/cityhall/community_serv/parks/default.asp | City 2 | 0.103 | Davenrich Parkette | ||
3455 | 3455 | 3454 | {"type": "Polygon", "coordinates": [[[-121.80257, 38.65901], [-121.80257, 38.65944], [-121.80253, 38.65958], [-121.80253, 38.66038], [-121.80191, 38.66038], [-121.80164, 38.66041], [-121.80121, 38.66082], [-121.80008, 38.66009], [-121.79986, 38.65997], [-121.7996, 38.65989], [-121.79972, 38.65954], [-121.79827, 38.65952], [-121.79824, 38.65929], [-121.79906, 38.659], [-121.80006, 38.65901], [-121.80092, 38.65886], [-121.80094, 38.65854], [-121.80251, 38.65857], [-121.80255, 38.65859], [-121.80257, 38.65863], [-121.80257, 38.65879], [-121.80244, 38.6588], [-121.80243, 38.659], [-121.80257, 38.65901]]]} | Open Access 1 | David Douglass Park | 17941 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 12.865 | David Douglass Park | ||
2727 | 2727 | 2726 | {"type": "Polygon", "coordinates": [[[-122.05715, 37.57857], [-122.05566, 37.58029], [-122.05467, 37.57972], [-122.0569, 37.57843], [-122.05715, 37.57857]]]} | Open Access 1 | David Jones Park | 17942 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 3.885 | David Jones Park | ||
10276 | 10276 | 10275 | {"type": "Polygon", "coordinates": [[[-118.41452, 34.26891], [-118.41343, 34.26971], [-118.41196, 34.26832], [-118.41305, 34.26752], [-118.41452, 34.26891]]]} | Open Access 1 | David M. Gonzales Recreation Center | http://www.laparks.org/dos/reccenter/facility/davidMGonzalesRC.htm | 28624 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 6.801 | David M. Gonzales Rec. Ctr. | |
12105 | 12105 | 12104 | {"type": "Polygon", "coordinates": [[[-118.4899, 34.44767], [-118.48977, 34.44785], [-118.48969, 34.44799], [-118.48943, 34.44865], [-118.48936, 34.44879], [-118.48926, 34.44893], [-118.48911, 34.44908], [-118.48801, 34.45001], [-118.48764, 34.45043], [-118.48749, 34.45034], [-118.48698, 34.44991], [-118.4868, 34.44979], [-118.48819, 34.44735], [-118.48876, 34.44752], [-118.48913, 34.44715], [-118.48988, 34.44762], [-118.4899, 34.44767]]]} | Open Access 1 | David March Park | 29048 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 12.314 | David March Park | ||
3456 | 3456 | 3455 | {"type": "Polygon", "coordinates": [[[-122.41374, 37.70263], [-122.41365, 37.70283], [-122.41296, 37.70284], [-122.413, 37.70307], [-122.41298, 37.70324], [-122.41292, 37.70342], [-122.41281, 37.70358], [-122.41189, 37.70309], [-122.41234, 37.70208], [-122.41268, 37.70218], [-122.41267, 37.70222], [-122.4128, 37.70225], [-122.41309, 37.70201], [-122.41335, 37.70208], [-122.41318, 37.70247], [-122.41374, 37.70263]]]} | Open Access 1 | David Rowe Park | 17944 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 3.516 | David Rowe Park | 1977 | |
11704 | 11704 | 11703 | {"type": "Polygon", "coordinates": [[[-117.77984, 33.71541], [-117.7783, 33.71699], [-117.778, 33.7168], [-117.77748, 33.71643], [-117.77739, 33.71635], [-117.77685, 33.71596], [-117.77684, 33.71585], [-117.77761, 33.7151], [-117.77826, 33.71441], [-117.77841, 33.7144], [-117.77924, 33.71497], [-117.7794, 33.715], [-117.7794, 33.7151], [-117.77984, 33.71541]]]} | Open Access 1 | David Sills Lower Peters Canyon Park | http://www.cityofirvine.org/cityhall/cs/commparks/cparks/cparks_peters.asp | 28280 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 10.266 | David Sills Lower Peters Canyon Park | |
3457 | 3457 | 3456 | {"type": "Polygon", "coordinates": [[[-121.22636, 38.76641], [-121.22597, 38.76681], [-121.22581, 38.76691], [-121.22564, 38.76699], [-121.22522, 38.76711], [-121.22482, 38.76726], [-121.22478, 38.76716], [-121.22476, 38.76704], [-121.22476, 38.7666], [-121.22479, 38.76644], [-121.22488, 38.76626], [-121.22507, 38.76605], [-121.22515, 38.76594], [-121.22521, 38.76584], [-121.22525, 38.76571], [-121.22601, 38.76549], [-121.22606, 38.76579], [-121.22614, 38.76606], [-121.22613, 38.76612], [-121.22604, 38.76622], [-121.22604, 38.76632], [-121.2261, 38.76638], [-121.22617, 38.76641], [-121.22626, 38.76641], [-121.22634, 38.76638], [-121.22636, 38.76641]]]} | Open Access 1 | David Uribe Park | 17945 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 4.0 | David Uribe Park | ||
10485 | 10485 | 10484 | {"type": "Polygon", "coordinates": [[[-118.1198, 33.76062], [-118.11979, 33.76069], [-118.11975, 33.76074], [-118.11964, 33.7608], [-118.11701, 33.75838], [-118.11694, 33.75835], [-118.1168, 33.75835], [-118.11667, 33.7584], [-118.1165, 33.75853], [-118.1164, 33.75854], [-118.11633, 33.75852], [-118.11608, 33.75832], [-118.11531, 33.75762], [-118.11527, 33.75757], [-118.11514, 33.75749], [-118.11501, 33.75745], [-118.11529, 33.7574], [-118.11572, 33.75726], [-118.11599, 33.75708], [-118.11976, 33.76053], [-118.1198, 33.76062]]]} | Open Access 1 | Davies Launch Ramp | 28975 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 6.062 | Davies Launch Ramp | ||
3458 | 3458 | 3457 | {"type": "Polygon", "coordinates": [[[-121.00784, 37.68195], [-121.00423, 37.68189], [-121.00419, 37.68185], [-121.00418, 37.68101], [-121.00418, 37.68091], [-121.00422, 37.6807], [-121.00431, 37.68051], [-121.00437, 37.68042], [-121.00451, 37.68026], [-121.00479, 37.68005], [-121.00501, 37.67995], [-121.00514, 37.67991], [-121.00541, 37.67985], [-121.00659, 37.67971], [-121.00685, 37.67964], [-121.0071, 37.67954], [-121.00732, 37.6794], [-121.00751, 37.67924], [-121.00767, 37.67905], [-121.0078, 37.67879], [-121.00784, 37.68195]]]} | Open Access 1 | Davis Community Park | 17946 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 18.933 | Davis Community Park | ||
720 | 720 | 719 | {"type": "Polygon", "coordinates": [[[-117.16091, 32.71066], [-117.16057, 32.71067], [-117.16057, 32.71053], [-117.16091, 32.71052], [-117.16091, 32.71066]]]} | Open Access 1 | Davis House Mini Park | 17950 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.118 | Davis House MP | ||
4657 | 4657 | 4656 | {"type": "Polygon", "coordinates": [[[-121.78192, 38.58316], [-121.7819, 38.58498], [-121.77783, 38.58494], [-121.77757, 38.58543], [-121.77653, 38.58543], [-121.77641, 38.59019], [-121.77351, 38.59018], [-121.77377, 38.58982], [-121.77414, 38.58934], [-121.77443, 38.58886], [-121.77478, 38.58821], [-121.77493, 38.58764], [-121.77499, 38.58733], [-121.77501, 38.58716], [-121.77501, 38.58649], [-121.77494, 38.5859], [-121.77483, 38.58458], [-121.77476, 38.58418], [-121.7724, 38.58485], [-121.77241, 38.5846], [-121.77223, 38.58458], [-121.7714, 38.58485], [-121.77148, 38.58517], [-121.7713, 38.5857], [-121.77016, 38.58608], [-121.76961, 38.58629], [-121.76878, 38.58667], [-121.769, 38.58699], [-121.76926, 38.58707], [-121.77016, 38.58729], [-121.77066, 38.58738], [-121.77094, 38.58749], [-121.77105, 38.58755], [-121.77148, 38.58782], [-121.77204, 38.58828], [-121.77228, 38.58854], [-121.77233, 38.5887], [-121.77233, 38.58884], [-121.77192, 38.58894], [-121.77101, 38.58876], [-121.76934, 38.58902], [-121.76875, 38.58875], [-121.76853, 38.58862], [-121.76833, 38.58848], [-121.76824, 38.5884], [-121.76808, 38.58823], [-121.76794, 38.58804], [-121.76783, 38.58785], [-121.76772, 38.5876], [-121.7677, 38.58744], [-121.76761, 38.58499], [-121.76762, 38.58292], [-121.76904, 38.58292], [-121.76903, 38.58251], [-121.76765, 38.5825], [-121.76803, 38.57833], [-121.76812, 38.57619], [-121.76813, 38.57567], [-121.77666, 38.57575], [-121.77661, 38.5831], [-121.78192, 38.58316]]]} | Restricted Access 2 | Davis Municipal Golf Course | 33121 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 264.624 | Davis Municipal GC | ||
3459 | 3459 | 3458 | {"type": "Polygon", "coordinates": [[[-117.34234, 34.08309], [-117.34228, 34.08314], [-117.34081, 34.08315], [-117.3408, 34.08149], [-117.34146, 34.08149], [-117.34148, 34.0814], [-117.34197, 34.0814], [-117.34198, 34.08149], [-117.3423, 34.08149], [-117.34234, 34.08152], [-117.34234, 34.08309]]]} | Open Access 1 | Davis Park | 17951 | 1062 | Colton, City of 162 | City 2 | City Agency 2 | http://www.ci.colton.ca.us/index.aspx?NID=136 | City 2 | 6.537 | Davis Park | ||
3460 | 3460 | 3459 | {"type": "Polygon", "coordinates": [[[-120.83791, 37.07101], [-120.8379, 37.0712], [-120.83756, 37.07144], [-120.83712, 37.07102], [-120.8372, 37.07098], [-120.83724, 37.0709], [-120.83757, 37.07092], [-120.83791, 37.07101]]]} | Open Access 1 | Davis Park | 17952 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.618 | Davis Park | ||
3462 | 3462 | 3461 | {"type": "Polygon", "coordinates": [[[-121.64543, 38.58948], [-121.63841, 38.58953], [-121.63129, 38.58946], [-121.63131, 38.58253], [-121.63156, 38.58084], [-121.63183, 38.58003], [-121.63258, 38.57849], [-121.63329, 38.57731], [-121.63423, 38.5762], [-121.6349, 38.57544], [-121.63534, 38.57532], [-121.63556, 38.57529], [-121.63601, 38.57532], [-121.63644, 38.57548], [-121.63674, 38.57566], [-121.63743, 38.57615], [-121.63776, 38.57626], [-121.63805, 38.5764], [-121.63835, 38.57647], [-121.63858, 38.57649], [-121.63928, 38.57661], [-121.64007, 38.57663], [-121.64366, 38.57663], [-121.64405, 38.57668], [-121.64434, 38.57677], [-121.64464, 38.57694], [-121.64491, 38.57715], [-121.64512, 38.57745], [-121.64521, 38.57777], [-121.64497, 38.58825], [-121.64504, 38.5886], [-121.64513, 38.58894], [-121.64543, 38.58948]]]} | Restricted Access 2 | Davis Wetland Demonstration | 17955 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 419.624 | Davis Wetland Demonstration | ||
3463 | 3463 | 3462 | {"type": "Polygon", "coordinates": [[[-122.24791, 37.53233], [-122.24681, 37.53332], [-122.24683, 37.53337], [-122.24596, 37.53411], [-122.24595, 37.53416], [-122.24589, 37.53417], [-122.24573, 37.53405], [-122.24777, 37.53226], [-122.24781, 37.53226], [-122.24791, 37.53233]]]} | Open Access 1 | Davit Lane | 17956 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.163 | Davit Lane | 1974 |
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]);