superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13,512 rows where ACCESS_TYP = 1 sorted by YR_EST descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 1
- Open Access · 13,512 ✖
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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13182 | 13182 | 13181 | {"type": "Polygon", "coordinates": [[[-118.29523, 33.84631], [-118.29172, 33.84632], [-118.29173, 33.84625], [-118.2918, 33.84623], [-118.29178, 33.84558], [-118.29179, 33.84535], [-118.29492, 33.84531], [-118.29492, 33.84546], [-118.29489, 33.84556], [-118.29492, 33.84563], [-118.29498, 33.8457], [-118.29507, 33.84574], [-118.29523, 33.84572], [-118.29523, 33.84631]]]} | Open Access 1 | Wishing Tree Park | https://www.lanlt.org/projectupdates | 33392 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 8.289 | Wishing Tree Park | 2020 |
766 | 766 | 765 | {"type": "Polygon", "coordinates": [[[-119.22071, 35.67312], [-119.2207, 35.67438], [-119.21686, 35.67441], [-119.21687, 35.67315], [-119.22071, 35.67312]]]} | Open Access 1 | Jim White "Blanco" Park | https://www.mcfarlandcity.org/194/Parks-Recreation | 32709 | 1691 | McFarland, City of 944 | City 2 | City Agency 2 | http://www.mcfarlandcity.org/194/Parks-Recreation | City 2 | 11.995 | Jim White "Blanco" Park | 2019 |
901 | 901 | 900 | {"type": "Polygon", "coordinates": [[[-117.1632, 33.14385], [-117.16316, 33.14408], [-117.16282, 33.14405], [-117.16279, 33.144], [-117.16284, 33.1438], [-117.16288, 33.14375], [-117.16304, 33.14365], [-117.1632, 33.14385]]]} | Open Access 1 | Mark J. Noy Jr. Adult Fitness Zone | https://www.san-marcos.net/Home/Components/Calendar/Event/9174/5349 | 32784 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 0.308 | Mark J. Noy Jr. Adult Fitness Zone | 2019 |
6817 | 6817 | 6816 | {"type": "Polygon", "coordinates": [[[-121.91965, 37.40115], [-121.91878, 37.40193], [-121.91857, 37.40145], [-121.91833, 37.40099], [-121.91804, 37.40054], [-121.91838, 37.40024], [-121.9184, 37.40032], [-121.91845, 37.40039], [-121.91922, 37.40091], [-121.91923, 37.40098], [-121.91927, 37.40103], [-121.91937, 37.40106], [-121.91947, 37.40102], [-121.91965, 37.40115]]]} | Open Access 1 | Iris Chang Park | https://www.sanjoseca.gov/Home/Components/News/News/402/5103 | 33665 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2.664 | Iris Chang Park | 2019 |
11588 | 11588 | 11587 | {"type": "Polygon", "coordinates": [[[-118.33306, 33.97936], [-118.33306, 33.97952], [-118.33244, 33.97953], [-118.33244, 33.97936], [-118.33306, 33.97936]]]} | Open Access 1 | South Victoria Avenue Park | http://www.tpl.org/our-work/parks-for-people/fitness-zones/south-victoria-avenue-park | 28103 | 3094 | Trust for Public Land 718 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/ | Non Governmental Organization 10 | 0.26 | South Victoria Avenue Park | 2019 |
12063 | 12063 | 12062 | {"type": "Polygon", "coordinates": [[[-117.2044, 33.66004], [-117.2044, 33.66054], [-117.20364, 33.66054], [-117.20359, 33.66062], [-117.20354, 33.6606], [-117.20346, 33.66061], [-117.20341, 33.66063], [-117.20336, 33.66068], [-117.20329, 33.66065], [-117.20297, 33.66079], [-117.20284, 33.66059], [-117.20195, 33.66065], [-117.20188, 33.66067], [-117.20183, 33.66063], [-117.20176, 33.6606], [-117.20171, 33.6606], [-117.20164, 33.66063], [-117.20158, 33.66056], [-117.20124, 33.66056], [-117.20122, 33.66075], [-117.20087, 33.66075], [-117.2008, 33.66083], [-117.20069, 33.6608], [-117.20062, 33.66083], [-117.20058, 33.66086], [-117.20052, 33.66083], [-117.19977, 33.66082], [-117.19974, 33.66126], [-117.19976, 33.66132], [-117.19984, 33.66137], [-117.19983, 33.66196], [-117.19965, 33.66189], [-117.19954, 33.6619], [-117.1991, 33.66179], [-117.19873, 33.66179], [-117.19872, 33.66073], [-117.1987, 33.66058], [-117.19865, 33.66043], [-117.19893, 33.6603], [-117.19895, 33.66028], [-117.19946, 33.66011], [-117.19943, 33.66016], [-117.19942, 33.66021], [-117.19946, 33.66029], [-117.19955, 33.66033], [-117.19967, 33.66031], [-117.19976, 33.6604], [-117.20039, 33.66041], [-117.20046, 33.66038], [-117.20053, 33.66044], [-117.20062, 33.66045], [-117.20069, 33.66043], [-117.20073, 33.66038], [-117.20075, 33.66033], [-117.20074, 33.66025], [-117.20105, 33.66025], [-117.20106, 33.66021], [-117.201, 33.66008], [-117.20101, 33.65909], [-117.2012, 33.65907], [-117.20127, 33.65938], [-117.20143, 33.65965], [-117.20138, 33.65968], [-117.20135, 33.65973], [-117.20134, 33.65978], [-117.20136, 33.65984], [-117.20125, 33.6599], [-117.20127, 33.66018], [-117.2015, 33.66018], [-117.20169, 33.66026], [-117.20192, 33.66029], [-117.20226, 33.66029], [-117.20232, 33.66025], [-117.20237, 33.66029], [-117.20245, 33.66031], [-117.20256, 33.66027], [-117.20261, 33.66031], [-117.20297, 33.66035], [-117.2034, 33.66029], [-117.20345, 33.66024], [-117.20352, 33.66027], [-117.20358, 33.66026], [-117.20366, 33.66022], [-117.20372, 33.66026], [-117.20405, 33.66026], [-117.20406, 33.66004], [-117.2044, 33.66004]]]} | Open Access 1 | Hidden Hills Park | https://www.cityofmenifee.us/285/Parks | 33218 | 1707 | Menifee, City of 655 | City 2 | City Agency 2 | http://www.cityofmenifee.us/284/Community-Services | City 2 | 9.657 | Hidden Hills Park | 2019 |
13187 | 13187 | 13186 | {"type": "Polygon", "coordinates": [[[-118.28333, 34.05806], [-118.28325, 34.05818], [-118.28282, 34.05798], [-118.2829, 34.05786], [-118.28333, 34.05806]]]} | Open Access 1 | Golden Age Park | https://www.lanlt.org/projectupdates | 33393 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 0.172 | Golden Age Park | 2019 |
13302 | 13302 | 13301 | {"type": "Polygon", "coordinates": [[[-117.865, 33.73375], [-117.86499, 33.73389], [-117.86457, 33.7339], [-117.86456, 33.73403], [-117.86354, 33.73405], [-117.86354, 33.73356], [-117.86456, 33.73363], [-117.86494, 33.7337], [-117.865, 33.73375]]]} | Open Access 1 | Pacific Electric Park | https://www.santa-ana.org/parks/parks-location/pacific-electric | 33426 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1.405 | Pacific Electric Park | 2019 |
13905 | 13905 | 13904 | {"type": "Polygon", "coordinates": [[[-121.49612, 38.47412], [-121.4957, 38.47412], [-121.49569, 38.47406], [-121.49534, 38.47406], [-121.49534, 38.47374], [-121.49529, 38.47367], [-121.49522, 38.47363], [-121.49445, 38.47365], [-121.4944, 38.47363], [-121.49437, 38.47359], [-121.49437, 38.47308], [-121.49435, 38.47289], [-121.49436, 38.47286], [-121.49441, 38.47283], [-121.49467, 38.47279], [-121.49482, 38.47278], [-121.49491, 38.47272], [-121.49494, 38.47263], [-121.49518, 38.47266], [-121.49612, 38.47412]]]} | Open Access 1 | LaVar Burton Park | https://www.cityofsacramento.org/ParksandRec/Parks/Park-Directory/South-Sacramento/LeVar-Burton-Park | 33228 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.152 | LaVar Burton Park | 2019 |
14001 | 14001 | 14000 | {"type": "Polygon", "coordinates": [[[-116.89516, 33.73953], [-116.89482, 33.73953], [-116.89475, 33.73958], [-116.89469, 33.73966], [-116.89468, 33.73973], [-116.89469, 33.73984], [-116.89473, 33.73995], [-116.8947, 33.73996], [-116.89471, 33.7402], [-116.89484, 33.74024], [-116.89493, 33.74035], [-116.89516, 33.74035], [-116.89515, 33.74049], [-116.89326, 33.74049], [-116.89328, 33.73866], [-116.89512, 33.73866], [-116.89515, 33.73902], [-116.89516, 33.73953]]]} | Open Access 1 | Jim Venable Exchange Club Park | 33315 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 7.858 | Jim Venable Exchange Club Park | 2019 | |
14129 | 14129 | 14128 | {"type": "Polygon", "coordinates": [[[-119.82045, 34.43733], [-119.81874, 34.43735], [-119.81907, 34.43679], [-119.81909, 34.43626], [-119.82044, 34.43625], [-119.82045, 34.43733]]]} | Open Access 1 | Jonny D. Wallis Neighborhood Park | https://www.cityofgoleta.org/projects-programs/parks-open-space/old-town-park | 32654 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 3.959 | Jonny D. Wallis Neighborhood Park | 2019 |
14440 | 14440 | 14439 | {"type": "Polygon", "coordinates": [[[-121.26493, 38.83074], [-121.26429, 38.83085], [-121.26318, 38.83041], [-121.26365, 38.82968], [-121.26371, 38.82953], [-121.26376, 38.8292], [-121.26378, 38.82917], [-121.26384, 38.82915], [-121.26484, 38.82927], [-121.2648, 38.82959], [-121.2648, 38.83], [-121.26485, 38.8304], [-121.26493, 38.83074]]]} | Open Access 1 | Willard Park | 33743 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 4.813 | Willard Park | 2019 | |
15613 | 15613 | 15612 | {"type": "Polygon", "coordinates": [[[-116.71662, 33.74341], [-116.71529, 33.74392], [-116.71542, 33.7442], [-116.71505, 33.74429], [-116.71457, 33.7435], [-116.71464, 33.7433], [-116.71463, 33.7428], [-116.71464, 33.74276], [-116.71524, 33.74258], [-116.71632, 33.74263], [-116.71628, 33.74276], [-116.71662, 33.74341]]]} | Open Access 1 | Idyllwild Community Center | https://www.idyllwildcommunitycenter.org/faq | 33128 | 3387 | San Jacinto Mountain Community Center 831 | Non Profit 6 | Non Profit - Other 20 | https://www.idyllwildcommunitycenter.org/faq | Non Governmental Organization 10 | 5.567 | Idyllwild Community Ctr. | 2019 |
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 |
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 |
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 | |
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 |
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 |
1244 | 1244 | 1243 | {"type": "Polygon", "coordinates": [[[-121.84613, 37.71921], [-121.8461, 37.71922], [-121.84608, 37.71928], [-121.84603, 37.71931], [-121.84534, 37.71946], [-121.84486, 37.71953], [-121.84439, 37.71957], [-121.84435, 37.71956], [-121.84433, 37.71954], [-121.8443, 37.71954], [-121.84428, 37.71905], [-121.84432, 37.71882], [-121.84438, 37.7186], [-121.84448, 37.71838], [-121.84461, 37.71818], [-121.84485, 37.7179], [-121.84492, 37.71786], [-121.84498, 37.71786], [-121.84503, 37.71789], [-121.84529, 37.7181], [-121.84554, 37.71833], [-121.84584, 37.71871], [-121.84599, 37.71894], [-121.84613, 37.71921]]]} | Open Access 1 | Sean Diamond Park | https://www.dublin.ca.gov/Facilities/Facility/Details/Sean-Diamond-Park-33 | 32917 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 4.986 | Sean Diamond 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]);