superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where YR_EST = 2018 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3519 | 3519 | 3518 | {"type": "Polygon", "coordinates": [[[-118.19815, 33.85938], [-118.19488, 33.86461], [-118.19471, 33.86483], [-118.19365, 33.86651], [-118.19195, 33.86924], [-118.1908, 33.86927], [-118.19254, 33.86619], [-118.19511, 33.86194], [-118.19574, 33.86094], [-118.19576, 33.86083], [-118.19594, 33.86053], [-118.1961, 33.86064], [-118.19622, 33.86062], [-118.19765, 33.85861], [-118.19767, 33.85857], [-118.19766, 33.85851], [-118.19785, 33.85833], [-118.19815, 33.85938]]]} | Open Access 1 | DeForest Park | 18015 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 34.119 | DeForest Park | 2018 | |
11138 | 11138 | 11137 | {"type": "Polygon", "coordinates": [[[-118.80576, 34.14426], [-118.8047, 34.14528], [-118.80453, 34.14521], [-118.80449, 34.14517], [-118.80449, 34.14512], [-118.80453, 34.14505], [-118.80458, 34.14491], [-118.8046, 34.14475], [-118.80458, 34.14458], [-118.80453, 34.14442], [-118.80447, 34.14433], [-118.80433, 34.14417], [-118.80363, 34.14356], [-118.80351, 34.14348], [-118.80339, 34.14343], [-118.8035, 34.1432], [-118.8033, 34.14264], [-118.80264, 34.14255], [-118.80005, 34.14275], [-118.79893, 34.14304], [-118.79865, 34.14331], [-118.7987, 34.14355], [-118.7982, 34.14363], [-118.79819, 34.14374], [-118.79827, 34.14399], [-118.79828, 34.1443], [-118.79819, 34.14432], [-118.7982, 34.14496], [-118.79803, 34.14496], [-118.79803, 34.14247], [-118.7992, 34.14145], [-118.80462, 34.14143], [-118.8045, 34.14252], [-118.8046, 34.14314], [-118.80377, 34.14324], [-118.80375, 34.14354], [-118.80398, 34.14383], [-118.80444, 34.14425], [-118.80498, 34.14465], [-118.80511, 34.14463], [-118.80562, 34.14413], [-118.80567, 34.1442], [-118.80576, 34.14426]]]} | Open Access 1 | Westlake Village City Parkland | 27404 | 1377 | Westlake Village, City of 318 | City 2 | City Agency 2 | http://www.wlv.org/index.aspx?nid=194 | City 2 | 24.69 | Westlake Village City Parkland | 2018 | |
9929 | 9929 | 9928 | {"type": "Polygon", "coordinates": [[[-118.2041, 33.77812], [-118.20413, 33.77876], [-118.20407, 33.77891], [-118.20398, 33.77908], [-118.20386, 33.77925], [-118.20372, 33.7794], [-118.2035, 33.77958], [-118.20334, 33.77968], [-118.20106, 33.78128], [-118.20102, 33.78137], [-118.2007, 33.78153], [-118.20044, 33.7817], [-118.20015, 33.78197], [-118.19976, 33.78248], [-118.19955, 33.78248], [-118.19977, 33.78213], [-118.20005, 33.78181], [-118.20033, 33.78157], [-118.20115, 33.781], [-118.20119, 33.78077], [-118.20134, 33.7806], [-118.20151, 33.78056], [-118.20132, 33.78016], [-118.20164, 33.78003], [-118.20194, 33.77984], [-118.20211, 33.77969], [-118.20269, 33.7791], [-118.20278, 33.77899], [-118.20299, 33.77911], [-118.20318, 33.77899], [-118.20317, 33.77898], [-118.20309, 33.77895], [-118.20314, 33.77882], [-118.20323, 33.77885], [-118.20344, 33.77871], [-118.20348, 33.77854], [-118.2035, 33.77836], [-118.20347, 33.77806], [-118.20393, 33.778], [-118.20395, 33.77813], [-118.2041, 33.77812]]]} | Open Access 1 | Drake/Chavez Soccer Fields and Parkway | 27996 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 7.972 | Drake/Chavez Soccer Fields and Parkway | 2018 | |
13010 | 13010 | 13009 | {"type": "Polygon", "coordinates": [[[-117.02716, 32.57161], [-117.02625, 32.5719], [-117.02589, 32.5711], [-117.02577, 32.57094], [-117.02564, 32.57082], [-117.02547, 32.57071], [-117.02522, 32.5706], [-117.02501, 32.57054], [-117.02477, 32.57052], [-117.02459, 32.57053], [-117.02427, 32.5706], [-117.02399, 32.57074], [-117.02375, 32.57093], [-117.02269, 32.57021], [-117.02263, 32.56916], [-117.02312, 32.56929], [-117.0232, 32.5694], [-117.02325, 32.56944], [-117.02381, 32.56969], [-117.02396, 32.56992], [-117.02418, 32.56988], [-117.02471, 32.56986], [-117.0249, 32.56983], [-117.02503, 32.56978], [-117.02526, 32.56966], [-117.0254, 32.56956], [-117.02554, 32.56942], [-117.02626, 32.56929], [-117.02631, 32.56932], [-117.02656, 32.56937], [-117.02697, 32.56951], [-117.02698, 32.57061], [-117.02715, 32.57064], [-117.02716, 32.57161]]]} | Open Access 1 | Cesar Solis Park | 31542 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 15.469 | Cesar Solis Park | 2018 | |
14193 | 14193 | 14192 | {"type": "Polygon", "coordinates": [[[-122.41835, 37.78009], [-122.41831, 37.78014], [-122.41724, 37.78028], [-122.41712, 37.78022], [-122.41685, 37.77889], [-122.41694, 37.77881], [-122.41801, 37.77868], [-122.41807, 37.77871], [-122.41835, 37.78009]]]} | Open Access 1 | Helen Diller Civic Center Playgrounds | 31697 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 4.432 | Helen Diller Civic Ctr. Playgrounds | 2018 | |
47 | 47 | 46 | {"type": "Polygon", "coordinates": [[[-118.18057, 33.81348], [-118.18057, 33.81362], [-118.18053, 33.8138], [-118.18, 33.81378], [-118.17999, 33.81348], [-118.18057, 33.81348]]]} | Open Access 1 | Signal Hill Dog Park | http://www.cityofsignalhill.org/Facilities/Facility/Details/Signal-Hill-Dog-Park-27 | 31767 | 1334 | Signal Hill, City of 366 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/index.aspx?nid=26 | City 2 | 0.441 | Signal Hill Dog Park | 2018 |
13132 | 13132 | 13131 | {"type": "MultiPolygon", "coordinates": [[[[-122.7194, 38.39457], [-122.71939, 38.39494], [-122.71929, 38.39502], [-122.7191, 38.39504], [-122.71903, 38.39508], [-122.719, 38.39512], [-122.71863, 38.39513], [-122.71863, 38.39457], [-122.71871, 38.3945], [-122.71931, 38.3945], [-122.7194, 38.39457]]], [[[-122.72084, 38.39557], [-122.72046, 38.39557], [-122.72044, 38.39548], [-122.7203, 38.39548], [-122.72019, 38.39556], [-122.71965, 38.39556], [-122.71958, 38.39553], [-122.71956, 38.39549], [-122.71957, 38.39456], [-122.71966, 38.39449], [-122.72027, 38.39449], [-122.72029, 38.39452], [-122.72083, 38.39452], [-122.72084, 38.39557]]]]} | Open Access 1 | Andy's Unity Park | https://parks.sonomacounty.ca.gov/Visit/Andys-Unity-Park/ | 31788 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 4.213 | Andy's Unity Park | 2018 |
79 | 79 | 78 | {"type": "Polygon", "coordinates": [[[-122.58436, 38.47825], [-122.57965, 38.47824], [-122.57935, 38.47459], [-122.58412, 38.47455], [-122.58436, 38.47825]]]} | No Public Access 3 | Santa Rosa Creek Redwoods | 31790 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 41.699 | Santa Rosa Creek Redwoods | 2018 | |
80 | 80 | 79 | {"type": "Polygon", "coordinates": [[[-121.77853, 37.07588], [-121.76509, 37.07542], [-121.76501, 37.07143], [-121.76791, 37.06968], [-121.76826, 37.07015], [-121.76836, 37.07057], [-121.76857, 37.07105], [-121.76854, 37.07122], [-121.76836, 37.07142], [-121.76851, 37.07179], [-121.76829, 37.07195], [-121.76806, 37.07225], [-121.76777, 37.07252], [-121.76769, 37.0727], [-121.76771, 37.07293], [-121.76757, 37.0733], [-121.76764, 37.07378], [-121.76775, 37.07403], [-121.76803, 37.07423], [-121.76821, 37.07467], [-121.76813, 37.0749], [-121.76814, 37.07491], [-121.77093, 37.07339], [-121.77067, 37.07249], [-121.77067, 37.07238], [-121.77157, 37.07239], [-121.77158, 37.07188], [-121.77848, 37.07211], [-121.77853, 37.07588]]]} | No Public Access 3 | Croy Redwoods | 31791 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 115.547 | Croy Redwoods | 2018 | |
84 | 84 | 83 | {"type": "Polygon", "coordinates": [[[-122.69582, 38.54625], [-122.69567, 38.54622], [-122.6949, 38.54581], [-122.69432, 38.54576], [-122.69338, 38.54514], [-122.69307, 38.54474], [-122.69284, 38.54396], [-122.69244, 38.5437], [-122.69183, 38.54277], [-122.69113, 38.54204], [-122.69108, 38.54018], [-122.69581, 38.54015], [-122.69582, 38.54625]]]} | No Public Access 3 | Wendle Property | 31796 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 50.237 | Wendle Property | 2018 | |
87 | 87 | 86 | {"type": "Polygon", "coordinates": [[[-117.85212, 33.98947], [-117.85182, 33.9896], [-117.8517, 33.98973], [-117.8516, 33.9899], [-117.85177, 33.99025], [-117.85212, 33.99036], [-117.85201, 33.99068], [-117.85197, 33.99071], [-117.85185, 33.99073], [-117.8518, 33.99078], [-117.85179, 33.99085], [-117.85186, 33.99093], [-117.85186, 33.99097], [-117.85184, 33.99102], [-117.8518, 33.99105], [-117.85106, 33.99068], [-117.85088, 33.99061], [-117.8507, 33.99056], [-117.85041, 33.99053], [-117.8496, 33.99057], [-117.84933, 33.99061], [-117.84932, 33.99034], [-117.84954, 33.99025], [-117.8496, 33.99], [-117.84997, 33.98961], [-117.85022, 33.98963], [-117.85052, 33.98959], [-117.85071, 33.9896], [-117.85108, 33.98948], [-117.85119, 33.98952], [-117.85127, 33.98952], [-117.85144, 33.98945], [-117.85182, 33.98949], [-117.85208, 33.98939], [-117.85212, 33.98947]]]} | Open Access 1 | Larkstone Park | https://www.diamondbarca.gov/Facilities/Facility/Details/Larkstone-Park-38 | 31798 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 6.425 | Larkstone Park | 2018 |
14027 | 14027 | 14026 | {"type": "Polygon", "coordinates": [[[-122.35609, 37.93146], [-122.35606, 37.93145], [-122.35474, 37.93145], [-122.35472, 37.93152], [-122.35051, 37.93153], [-122.35051, 37.93113], [-122.35375, 37.93111], [-122.35377, 37.93086], [-122.35455, 37.93086], [-122.35457, 37.93111], [-122.35605, 37.93111], [-122.35609, 37.93146]]]} | Open Access 1 | Unity Park | http://www.ci.richmond.ca.us/3591/Unity-Park | 32596 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 5.722 | Unity Park | 2018 |
14049 | 14049 | 14048 | {"type": "Polygon", "coordinates": [[[-118.70524, 34.03269], [-118.7051, 34.03271], [-118.705, 34.03281], [-118.70477, 34.03297], [-118.7047, 34.03306], [-118.70468, 34.03313], [-118.70472, 34.03338], [-118.70461, 34.03363], [-118.70448, 34.03373], [-118.70442, 34.0338], [-118.70438, 34.03389], [-118.70431, 34.03394], [-118.70414, 34.03411], [-118.70403, 34.03416], [-118.70399, 34.0342], [-118.70393, 34.0343], [-118.70398, 34.03454], [-118.70318, 34.03461], [-118.70322, 34.03458], [-118.70324, 34.03453], [-118.7032, 34.03412], [-118.70314, 34.03406], [-118.70196, 34.03413], [-118.70185, 34.0341], [-118.70174, 34.03404], [-118.70166, 34.03395], [-118.70162, 34.03385], [-118.70158, 34.03349], [-118.70147, 34.03323], [-118.70161, 34.03318], [-118.70168, 34.03309], [-118.70175, 34.03306], [-118.70212, 34.03299], [-118.70313, 34.03263], [-118.70331, 34.03259], [-118.70355, 34.0327], [-118.70387, 34.0326], [-118.70399, 34.03258], [-118.70407, 34.03252], [-118.70413, 34.0325], [-118.70422, 34.03252], [-118.70429, 34.03261], [-118.70519, 34.03253], [-118.70524, 34.03269]]]} | Open Access 1 | Malibu Bluffs Park | https://www.malibucity.org | 32624 | 1193 | Malibu, City of 928 | City 2 | City Agency 2 | http://www.malibucity.org/Index.aspx?NID=335 | City 2 | 11.492 | Malibu Bluffs Park | 2018 |
600 | 600 | 599 | {"type": "Polygon", "coordinates": [[[-117.74684, 34.02858], [-117.74645, 34.02859], [-117.74644, 34.02843], [-117.74684, 34.02842], [-117.74684, 34.02858]]]} | Open Access 1 | Esperanza y Alegria Park | 32693 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 0.165 | Esperanza y Alegria Park | 2018 | |
912 | 912 | 911 | {"type": "MultiPolygon", "coordinates": [[[[-121.84156, 37.15629], [-121.82926, 37.15028], [-121.83063, 37.15027], [-121.83065, 37.14667], [-121.83978, 37.1467], [-121.83977, 37.15016], [-121.84132, 37.15017], [-121.84156, 37.15629]]], [[[-121.83961, 37.14302], [-121.83061, 37.14311], [-121.83054, 37.13592], [-121.83954, 37.1359], [-121.83961, 37.14302]]]]} | No Public Access 3 | Barrett Canyon | 32789 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 325.475 | Barrett Canyon | 2018 | |
886 | 886 | 885 | {"type": "Polygon", "coordinates": [[[-121.83058, 37.13955], [-121.82145, 37.13957], [-121.82142, 37.1362], [-121.82285, 37.1362], [-121.82287, 37.13618], [-121.82285, 37.13563], [-121.82141, 37.13563], [-121.82138, 37.13232], [-121.8305, 37.1323], [-121.83058, 37.13955]]]} | No Public Access 3 | Punch Bowl | 32790 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 159.193 | Punch Bowl | 2018 | |
1107 | 1107 | 1106 | {"type": "Polygon", "coordinates": [[[-121.24668, 38.66644], [-121.24542, 38.66644], [-121.24542, 38.66616], [-121.24668, 38.66616], [-121.24668, 38.66644]]]} | Open Access 1 | Madison Place Park | https://www.facebook.com/events/5524-cannes-way-fair-oaks-ca-95628-2677-united-states/madison-place-park-grand-opening/1890095377727994/ | 32865 | 2221 | Fair Oaks Recreation and Park District 940 | Special District 4 | Recreation/Parks District 4 | http://www.fairoakspark.org/ | Special District 4 | 0.827 | Madison Place Park | 2018 |
1108 | 1108 | 1107 | {"type": "Polygon", "coordinates": [[[-121.07771, 39.22081], [-121.07676, 39.22153], [-121.07673, 39.22149], [-121.07655, 39.22152], [-121.07648, 39.22149], [-121.07549, 39.22233], [-121.07526, 39.22221], [-121.07499, 39.22212], [-121.07443, 39.22199], [-121.07444, 39.22102], [-121.07551, 39.22103], [-121.07557, 39.22092], [-121.07556, 39.22075], [-121.07569, 39.22072], [-121.07668, 39.22003], [-121.07771, 39.22081]]]} | Restricted Access 2 | Margaret G Scotten School Ballfields | 32866 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks | City 2 | 8.568 | Margaret G Scotten School Ballfields | 2018 | |
1232 | 1232 | 1231 | {"type": "Polygon", "coordinates": [[[-121.85783, 37.71464], [-121.85783, 37.71473], [-121.85752, 37.71497], [-121.85728, 37.71519], [-121.85684, 37.71563], [-121.85657, 37.71602], [-121.85649, 37.71603], [-121.85605, 37.71585], [-121.85602, 37.71588], [-121.85346, 37.71482], [-121.85305, 37.71458], [-121.8528, 37.71439], [-121.85265, 37.71425], [-121.85239, 37.71397], [-121.85226, 37.71378], [-121.85214, 37.71356], [-121.85206, 37.71337], [-121.85199, 37.71316], [-121.85194, 37.71283], [-121.85194, 37.71254], [-121.85207, 37.71144], [-121.85213, 37.71121], [-121.85217, 37.71065], [-121.85226, 37.71058], [-121.8536, 37.71047], [-121.85423, 37.71036], [-121.85473, 37.71025], [-121.85511, 37.71013], [-121.85564, 37.70992], [-121.85597, 37.70976], [-121.85643, 37.7095], [-121.85715, 37.70914], [-121.85726, 37.70917], [-121.85745, 37.70949], [-121.85759, 37.70985], [-121.85766, 37.71022], [-121.85766, 37.71057], [-121.85762, 37.71079], [-121.85756, 37.71101], [-121.85703, 37.71255], [-121.85698, 37.7128], [-121.85697, 37.71317], [-121.85701, 37.71341], [-121.85708, 37.71364], [-121.85725, 37.71398], [-121.85748, 37.71429], [-121.85783, 37.71464]]]} | Open Access 1 | Fallon Sports Park | https://www.dublin.ca.gov/Facilities/Facility/Details/Fallon-Sports-Park-22 | 32911 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 65.297 | Fallon Sports Park | 2018 |
1233 | 1233 | 1232 | {"type": "Polygon", "coordinates": [[[-121.84712, 37.7135], [-121.84714, 37.71357], [-121.8472, 37.71362], [-121.84726, 37.71372], [-121.84732, 37.71388], [-121.84734, 37.71403], [-121.84733, 37.71419], [-121.84728, 37.71435], [-121.8472, 37.71449], [-121.84701, 37.71468], [-121.84686, 37.71478], [-121.84668, 37.71486], [-121.84649, 37.71491], [-121.84569, 37.71507], [-121.84554, 37.71508], [-121.84533, 37.71505], [-121.8452, 37.71499], [-121.84505, 37.71487], [-121.84496, 37.71473], [-121.84487, 37.71469], [-121.84546, 37.71433], [-121.84589, 37.71411], [-121.84639, 37.7139], [-121.8468, 37.71366], [-121.84707, 37.71355], [-121.84712, 37.7135]]]} | Open Access 1 | Jordan Ranch Park | https://ca-dublin2.civicplus.com/Facilities/Facility/Details/Jordan-Ranch-Park-31 | 32912 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 4.982 | Jordan Ranch Park | 2018 |
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]);