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 7,429
- County Agency 796
- Recreation/Parks District 771
- State Agency 592
- Non Profit - Land Trust 393
- Open Space District 187
- Federal Agency 171
- County Agency - Parks 164
- Water District 153
- Community Services District 138
- Home Owners Association 127
- Non Profit - Conservation 95
- Flood District 67
- Cemetery District 41
- Non Profit - Other 30
- County Agency - Other 27
- Port/Harbor District 23
- Irrigation District 16
- School District 13
- Commercial 10
- Sanitation District 8
- Special District - Other 6
- Other 5
- Joint Powers Authority 4
- Non Profit - Cemetery District 4
- Mitigation Bank 4
- Conservation District 4
- Transportation Agency 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 364
- Los Angeles, City of 362
- California Department of Fish and Wildlife 286
- San Jose, City of 170
- California Department of Parks and Recreation 162
- San Francisco, City and County of 158
- Sacramento, City of 157
- Mountains Recreation and Conservation Authority 141
- Ventura, City of 139
- Los Angeles, County of 131
- Long Beach, City of 118
- San Diego, County of 104
- Roseville, City of 102
- East Bay Regional Park District 101
- Oakland, City of 79
- Irvine, City of 78
- Fresno, City of 75
- Consumnes Community Services District 70
- Santa Barbara, County of 68
- Orange, County of 64
- Poway, City of 61
- Torrance, City of 61
- Huntington Beach, City of 60
- Stockton, City of 60
- Santa Cruz, City of 58
- Los Angeles - Department of Parks and Recreation, County of 57
- Hayward Area Recreation and Park District 56
- Chula Vista, City of 55
- Napa, City of 54
- Modesto, City of 54
- …
ACCESS_TYP 4
- Open Access 9,651
- Restricted Access 829
- No Public Access 590
- Unknown Access 220
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4349 | 4349 | 4348 | {"type": "Polygon", "coordinates": [[[-117.12293, 32.70992], [-117.12268, 32.70992], [-117.12268, 32.70958], [-117.12293, 32.70958], [-117.12293, 32.70992]]]} | Open Access 1 | J Street Mini Park | 20289 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.219 | J Street MP | ||
4350 | 4350 | 4349 | {"type": "Polygon", "coordinates": [[[-121.76559, 37.31506], [-121.76531, 37.31511], [-121.76518, 37.31495], [-121.76504, 37.31485], [-121.76486, 37.31479], [-121.76467, 37.31476], [-121.76447, 37.31478], [-121.76431, 37.31483], [-121.76414, 37.31492], [-121.76403, 37.31502], [-121.76217, 37.31363], [-121.76214, 37.31352], [-121.76158, 37.31311], [-121.7645, 37.31267], [-121.76473, 37.31364], [-121.76477, 37.31367], [-121.76483, 37.31368], [-121.76526, 37.31361], [-121.76559, 37.31506]]]} | Open Access 1 | Fowler Creek Community Park | 19029 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 12.45 | Fowler Creek Community Park | 2004 | |
4351 | 4351 | 4350 | {"type": "Polygon", "coordinates": [[[-118.3875, 33.98305], [-118.3873, 33.98371], [-118.38674, 33.98418], [-118.38415, 33.98435], [-118.38415, 33.98429], [-118.38422, 33.98402], [-118.38431, 33.98384], [-118.38452, 33.9836], [-118.38478, 33.9834], [-118.38535, 33.98313], [-118.38565, 33.98293], [-118.38592, 33.98269], [-118.38623, 33.98231], [-118.38628, 33.98228], [-118.38634, 33.98228], [-118.38654, 33.98238], [-118.38721, 33.98288], [-118.3875, 33.98305]]]} | Open Access 1 | Fox Hills Park | 19031 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 9.991 | Fox Hills Park | ||
4352 | 4352 | 4351 | {"type": "Polygon", "coordinates": [[[-118.3823, 33.98709], [-118.38228, 33.98732], [-118.38226, 33.98736], [-118.38222, 33.98737], [-118.38191, 33.98738], [-118.3823, 33.98709]]]} | Open Access 1 | Fox Hills Parkette | 19032 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 0.13 | Fox Hills Parkette | ||
4353 | 4353 | 4352 | {"type": "Polygon", "coordinates": [[[-121.66901, 37.14031], [-121.66901, 37.14031], [-121.66891, 37.14072], [-121.66879, 37.1406], [-121.66881, 37.14056], [-121.66865, 37.14041], [-121.66888, 37.14025], [-121.66894, 37.14029], [-121.66901, 37.14031]]]} | Open Access 1 | Fox Hollow Park | 19033 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 0.201 | Fox Hollow Park | ||
4354 | 4354 | 4353 | {"type": "Polygon", "coordinates": [[[-122.26061, 38.01443], [-122.26017, 38.01496], [-122.25964, 38.01488], [-122.25894, 38.01487], [-122.25863, 38.01494], [-122.2587, 38.01457], [-122.25859, 38.0141], [-122.26007, 38.01404], [-122.26061, 38.01443]]]} | Open Access 1 | Foxboro Park | 19035 | 1133 | Hercules, City of 351 | City 2 | City Agency 2 | http://www.ci.hercules.ca.us/index.aspx?page=166 | City 2 | 3.485 | Foxboro Park | ||
4355 | 4355 | 4354 | {"type": "Polygon", "coordinates": [[[-117.71925, 33.56722], [-117.71925, 33.56736], [-117.71915, 33.56784], [-117.71894, 33.5685], [-117.71855, 33.56855], [-117.71852, 33.56887], [-117.71822, 33.56895], [-117.71714, 33.56676], [-117.71752, 33.56632], [-117.71893, 33.56711], [-117.71925, 33.56722]]]} | Open Access 1 | Foxborough Park | 19036 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 7.538 | Foxborough Park | ||
4356 | 4356 | 4355 | {"type": "Polygon", "coordinates": [[[-118.81947, 34.1388], [-118.81885, 34.13894], [-118.81893, 34.13921], [-118.81876, 34.13925], [-118.81839, 34.13851], [-118.81834, 34.13845], [-118.81827, 34.1384], [-118.81813, 34.13838], [-118.81806, 34.13839], [-118.81796, 34.13843], [-118.81782, 34.13843], [-118.81774, 34.13841], [-118.81762, 34.13841], [-118.81751, 34.13844], [-118.81733, 34.13856], [-118.81717, 34.13861], [-118.81698, 34.1386], [-118.81681, 34.13854], [-118.81671, 34.13854], [-118.81665, 34.13856], [-118.81655, 34.13865], [-118.8162, 34.13842], [-118.81601, 34.13821], [-118.81629, 34.13814], [-118.81671, 34.13813], [-118.81876, 34.13823], [-118.81896, 34.13828], [-118.81917, 34.13839], [-118.81927, 34.13847], [-118.81938, 34.13859], [-118.81945, 34.13871], [-118.81947, 34.1388]]]} | Open Access 1 | Foxfield Park | 19037 | 1377 | Westlake Village, City of 318 | City 2 | City Agency 2 | http://www.wlv.org/index.aspx?nid=194 | City 2 | 3.509 | Foxfield Park | ||
4357 | 4357 | 4356 | {"type": "Polygon", "coordinates": [[[-122.34472, 40.56826], [-122.34472, 40.56885], [-122.34406, 40.56885], [-122.34407, 40.56832], [-122.34426, 40.56832], [-122.34434, 40.56837], [-122.34442, 40.56839], [-122.34453, 40.56835], [-122.34458, 40.5683], [-122.34459, 40.56825], [-122.34472, 40.56826]]]} | Open Access 1 | Foxtail Park | 19038 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.807 | Foxtail Park | ||
4358 | 4358 | 4357 | {"type": "MultiPolygon", "coordinates": [[[[-119.69777, 34.44032], [-119.69777, 34.44084], [-119.69696, 34.44067], [-119.69697, 34.44231], [-119.69618, 34.44213], [-119.69597, 34.44191], [-119.69602, 34.4418], [-119.69605, 34.44141], [-119.69625, 34.44117], [-119.69627, 34.44112], [-119.69626, 34.44105], [-119.6962, 34.44096], [-119.69575, 34.44069], [-119.69547, 34.44062], [-119.69581, 34.44057], [-119.69589, 34.44057], [-119.6959, 34.4402], [-119.69569, 34.44015], [-119.69557, 34.44016], [-119.69546, 34.44018], [-119.69532, 34.44024], [-119.69478, 34.44055], [-119.69335, 34.44044], [-119.69273, 34.4401], [-119.69351, 34.44024], [-119.69379, 34.44013], [-119.69402, 34.4398], [-119.69447, 34.43964], [-119.69527, 34.43963], [-119.69606, 34.43974], [-119.69692, 34.43992], [-119.69777, 34.44032]]], [[[-119.69693, 34.43941], [-119.69691, 34.43943], [-119.69691, 34.43976], [-119.69613, 34.43958], [-119.6952, 34.43947], [-119.69444, 34.43947], [-119.69417, 34.43957], [-119.69415, 34.43941], [-119.69311, 34.43942], [-119.69314, 34.43877], [-119.69693, 34.43923], [-119.69693, 34.43941]]]]} | Open Access 1 | Franceschi Park | 19043 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 16.168 | Franceschi Park | ||
4359 | 4359 | 4358 | {"type": "Polygon", "coordinates": [[[-121.2254, 37.81112], [-121.22386, 37.81112], [-121.22362, 37.81108], [-121.22367, 37.81098], [-121.22372, 37.81071], [-121.22374, 37.81015], [-121.22496, 37.81013], [-121.22535, 37.81016], [-121.2254, 37.81112]]]} | Open Access 1 | Franciscan Park | 19045 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 3.933 | Franciscan Park | ||
4360 | 4360 | 4359 | {"type": "Polygon", "coordinates": [[[-122.42275, 37.64511], [-122.42239, 37.64563], [-122.42222, 37.64588], [-122.42208, 37.64571], [-122.4227, 37.64509], [-122.42275, 37.64511]]]} | Open Access 1 | Francisco Terrace Playlot | 19046 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 0.301 | Francisco Terrace Playlot | ||
4361 | 4361 | 4360 | {"type": "Polygon", "coordinates": [[[-121.74449, 36.92636], [-121.74449, 36.9264], [-121.74408, 36.92774], [-121.74406, 36.92788], [-121.74408, 36.92802], [-121.74191, 36.92759], [-121.74172, 36.92765], [-121.74168, 36.9276], [-121.74157, 36.92751], [-121.74143, 36.92745], [-121.74077, 36.92731], [-121.74115, 36.92581], [-121.74106, 36.92571], [-121.7411, 36.92569], [-121.74444, 36.92634], [-121.74449, 36.92636]]]} | Open Access 1 | Franich Park | 19047 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 14.04 | Franich Park | ||
4362 | 4362 | 4361 | {"type": "Polygon", "coordinates": [[[-118.39237, 33.74063], [-118.39224, 33.74067], [-118.39187, 33.74074], [-118.39139, 33.74079], [-118.39149, 33.73999], [-118.39171, 33.73999], [-118.39193, 33.73996], [-118.39211, 33.74029], [-118.39237, 33.74063]]]} | Open Access 1 | Frank A. Vanderlip Sr. Park | http://ca-ranchopalosverdes.civicplus.com/Facilities/Facility/Details/Frank-A-Vanderlip-Park-6 | 19048 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 1.365 | Frank A. Vanderlip Sr. Park | |
4363 | 4363 | 4362 | {"type": "Polygon", "coordinates": [[[-122.05236, 37.563], [-122.05088, 37.56366], [-122.05082, 37.56366], [-122.05079, 37.56363], [-122.05065, 37.56333], [-122.05049, 37.56308], [-122.04975, 37.56215], [-122.04974, 37.5621], [-122.04977, 37.56207], [-122.05135, 37.56137], [-122.05135, 37.56142], [-122.05139, 37.56149], [-122.05143, 37.56163], [-122.05144, 37.56184], [-122.0515, 37.56193], [-122.05152, 37.56199], [-122.05152, 37.56203], [-122.0515, 37.56209], [-122.0515, 37.56214], [-122.05159, 37.56222], [-122.05178, 37.56243], [-122.05188, 37.56251], [-122.05199, 37.5625], [-122.05206, 37.56253], [-122.05209, 37.56256], [-122.05212, 37.56261], [-122.05214, 37.56275], [-122.05218, 37.56284], [-122.05229, 37.56299], [-122.05236, 37.563]]]} | Open Access 1 | Frank Fischer Park | 19049 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 7.273 | Frank Fischer Park | ||
4364 | 4364 | 4363 | {"type": "Polygon", "coordinates": [[[-121.36917, 36.84408], [-121.36914, 36.84475], [-121.36878, 36.84477], [-121.36871, 36.84472], [-121.36862, 36.8447], [-121.36854, 36.84472], [-121.36845, 36.8448], [-121.36836, 36.84482], [-121.36722, 36.84475], [-121.36712, 36.84476], [-121.36705, 36.84482], [-121.36667, 36.84482], [-121.36667, 36.84402], [-121.36702, 36.84403], [-121.36709, 36.84407], [-121.36717, 36.84408], [-121.36726, 36.84405], [-121.36736, 36.84397], [-121.36745, 36.84396], [-121.36872, 36.84399], [-121.36895, 36.84407], [-121.36917, 36.84408]]]} | Open Access 1 | Frank Klauer Memorial Park | 19051 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://www.hollister.ca.gov/Site/html/gov/office/recreation/parkfac.asp | City 2 | 4.723 | Frank Klauer Memorial Park | ||
4365 | 4365 | 4364 | {"type": "Polygon", "coordinates": [[[-121.60386, 36.69613], [-121.60384, 36.69617], [-121.60331, 36.69641], [-121.60294, 36.69588], [-121.6035, 36.69564], [-121.60386, 36.69613]]]} | Open Access 1 | Frank Paul Park | 19052 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 0.954 | Frank Paul Park | ||
4366 | 4366 | 4365 | {"type": "Polygon", "coordinates": [[[-121.55976, 38.81045], [-121.55308, 38.81447], [-121.5516, 38.81536], [-121.55163, 38.80843], [-121.55929, 38.80831], [-121.5588, 38.8086], [-121.55869, 38.80876], [-121.55872, 38.80892], [-121.55888, 38.80918], [-121.55948, 38.80966], [-121.55948, 38.80978], [-121.5595, 38.80998], [-121.55976, 38.81045]]]} | No Public Access 3 | Frazer | 19069 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 85.164 | Frazer | ||
4367 | 4367 | 4366 | {"type": "Polygon", "coordinates": [[[-118.95592, 36.14627], [-118.95521, 36.14626], [-118.9552, 36.14479], [-118.95589, 36.1448], [-118.95592, 36.14627]]]} | Open Access 1 | Frazier Valley Cemetery | 19071 | 2060 | Lindsay-Strathmore Cemetery District 119 | Special District 4 | Cemetery District 11 | Special District 4 | 2.538 | Frazier Valley Cemetery | |||
4368 | 4368 | 4367 | {"type": "Polygon", "coordinates": [[[-117.76711, 33.82831], [-117.76638, 33.82832], [-117.7663, 33.82829], [-117.76611, 33.82829], [-117.76603, 33.82832], [-117.76546, 33.82832], [-117.76488, 33.82837], [-117.7643, 33.82849], [-117.76422, 33.82848], [-117.76403, 33.82854], [-117.76397, 33.82858], [-117.76349, 33.82876], [-117.76334, 33.8288], [-117.76307, 33.82894], [-117.76295, 33.82892], [-117.76292, 33.82894], [-117.76286, 33.82886], [-117.76283, 33.82876], [-117.76283, 33.82872], [-117.76276, 33.82868], [-117.7628, 33.82863], [-117.76285, 33.82859], [-117.76375, 33.8282], [-117.76396, 33.82822], [-117.76402, 33.82792], [-117.76711, 33.82831]]]} | Open Access 1 | Fred Barrera Park | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=5410 | 19072 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 3.206 | Fred Barrera 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]);