superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,191 rows where ACCESS_TYP = 1 and MNG_AG_LEV = 3 sorted by PARK_NAME
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP 3
ACCESS_TYP 1
- Open Access · 1,191 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12239 | 12239 | 12238 | {"type": "Polygon", "coordinates": [[[-117.11836, 33.00338], [-117.1183, 33.00374], [-117.11756, 33.00369], [-117.11751, 33.00406], [-117.11703, 33.00401], [-117.11706, 33.00364], [-117.11616, 33.00356], [-117.11606, 33.00392], [-117.11567, 33.00389], [-117.11564, 33.00395], [-117.11496, 33.0039], [-117.11475, 33.00393], [-117.11456, 33.00399], [-117.11441, 33.00379], [-117.11455, 33.00346], [-117.11463, 33.00323], [-117.1147, 33.00315], [-117.11495, 33.00295], [-117.11527, 33.00298], [-117.11538, 33.00296], [-117.11553, 33.00327], [-117.11583, 33.00319], [-117.11718, 33.00331], [-117.11741, 33.00327], [-117.11754, 33.0033], [-117.11808, 33.00337], [-117.11836, 33.00338]]]} | Open Access 1 | 4S Ranch Community Park | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchSports.html | 29225 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 5.824 | 4S Ranch Community Park | |
10604 | 10604 | 10603 | {"type": "Polygon", "coordinates": [[[-117.11773, 33.01502], [-117.1175, 33.01584], [-117.11707, 33.01618], [-117.11694, 33.01675], [-117.11621, 33.01663], [-117.11619, 33.01662], [-117.11626, 33.01623], [-117.11629, 33.01582], [-117.11618, 33.01481], [-117.11619, 33.01477], [-117.11623, 33.01474], [-117.11639, 33.01475], [-117.11773, 33.01502]]]} | Open Access 1 | 4S Ranch Heritage Park | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | 29226 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 5.39 | 4S Ranch Heritage Park | |
12273 | 12273 | 12272 | {"type": "Polygon", "coordinates": [[[-117.11751, 33.01214], [-117.11748, 33.01217], [-117.11743, 33.01217], [-117.11666, 33.01201], [-117.11662, 33.01199], [-117.11658, 33.01192], [-117.11651, 33.01189], [-117.11645, 33.01189], [-117.11638, 33.01191], [-117.11618, 33.01171], [-117.11606, 33.01182], [-117.11597, 33.01213], [-117.11604, 33.01169], [-117.11601, 33.0116], [-117.11591, 33.01148], [-117.11611, 33.0115], [-117.11631, 33.01148], [-117.11653, 33.01149], [-117.1168, 33.01156], [-117.11707, 33.01159], [-117.11743, 33.01151], [-117.11752, 33.01172], [-117.11755, 33.01187], [-117.11753, 33.01206], [-117.11751, 33.01214]]]} | Open Access 1 | 4S Ranch Homestead Park | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchLiberty.html | 29267 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 1.803 | 4S Ranch Homestead Park | |
10572 | 10572 | 10571 | {"type": "Polygon", "coordinates": [[[-117.11446, 33.0364], [-117.11431, 33.03678], [-117.1142, 33.03696], [-117.11407, 33.03715], [-117.11377, 33.0375], [-117.11362, 33.03763], [-117.11341, 33.03775], [-117.11311, 33.03738], [-117.1126, 33.03682], [-117.11262, 33.03678], [-117.11303, 33.03641], [-117.11347, 33.0359], [-117.11376, 33.03607], [-117.11436, 33.03631], [-117.11446, 33.0364]]]} | Open Access 1 | 4S Ranch Liberty Park | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | 29187 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 4.774 | 4S Ranch Liberty Park | |
12272 | 12272 | 12271 | {"type": "Polygon", "coordinates": [[[-117.10997, 33.02568], [-117.10993, 33.02573], [-117.10955, 33.02601], [-117.10945, 33.02613], [-117.1071, 33.02507], [-117.10729, 33.02431], [-117.10808, 33.02445], [-117.10808, 33.02453], [-117.10813, 33.02459], [-117.10823, 33.02463], [-117.10995, 33.02563], [-117.10997, 33.02568]]]} | Open Access 1 | 4S Ranch Patriot Park | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | 29266 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 5.762 | 4S Ranch Patriot Park | |
12275 | 12275 | 12274 | {"type": "Polygon", "coordinates": [[[-117.12105, 33.004], [-117.12098, 33.00409], [-117.12083, 33.00424], [-117.12067, 33.0045], [-117.12062, 33.00467], [-117.12064, 33.00492], [-117.12061, 33.00507], [-117.12023, 33.00568], [-117.11995, 33.00557], [-117.1199, 33.00545], [-117.11983, 33.00535], [-117.11975, 33.00525], [-117.11963, 33.00516], [-117.11942, 33.00505], [-117.1192, 33.00497], [-117.11907, 33.00495], [-117.11894, 33.00495], [-117.11843, 33.00502], [-117.11826, 33.00516], [-117.11817, 33.00485], [-117.11819, 33.00445], [-117.1182, 33.00431], [-117.11831, 33.00418], [-117.11838, 33.00401], [-117.11835, 33.00386], [-117.11829, 33.00382], [-117.11836, 33.00338], [-117.11849, 33.00338], [-117.11855, 33.00336], [-117.11859, 33.00332], [-117.11865, 33.00322], [-117.11868, 33.00319], [-117.11929, 33.00323], [-117.11993, 33.00317], [-117.1201, 33.0032], [-117.12038, 33.00331], [-117.12105, 33.00331], [-117.12111, 33.00375], [-117.1211, 33.00387], [-117.12105, 33.004]]]} | Open Access 1 | 4S Ranch Sports Park | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchSports.html | 29269 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 12.833 | 4S Ranch Sports Park | |
584 | 584 | 583 | {"type": "Polygon", "coordinates": [[[-118.18749, 33.88301], [-118.18743, 33.88376], [-118.18718, 33.88544], [-118.18669, 33.88544], [-118.18708, 33.88292], [-118.18749, 33.88301]]]} | Open Access 1 | 72nd Street Equestrian Park | http://parks.lacounty.gov/72nd-street-equestrian-park/ | 32687 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 2.956 | 72nd Street Equestrian Park | |
186 | 186 | 185 | {"type": "Polygon", "coordinates": [[[-121.20472, 38.7035], [-121.2046, 38.70349], [-121.20457, 38.70342], [-121.20458, 38.70338], [-121.20455, 38.70317], [-121.20444, 38.70303], [-121.2044, 38.70283], [-121.20439, 38.70266], [-121.2044, 38.70262], [-121.20442, 38.7026], [-121.20446, 38.70223], [-121.20448, 38.7022], [-121.20452, 38.70221], [-121.20453, 38.70223], [-121.20449, 38.70252], [-121.20448, 38.70283], [-121.20455, 38.70304], [-121.20463, 38.70314], [-121.20463, 38.7033], [-121.20464, 38.70339], [-121.20472, 38.7035]]]} | Open Access 1 | 9101 Sunset Ave | 15222 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 0.246 | 9101 Sunset Ave | ||
275 | 275 | 274 | {"type": "MultiPolygon", "coordinates": [[[[-119.3271, 35.23519], [-119.32338, 35.23601], [-119.32338, 35.23601], [-119.32338, 35.23584], [-119.32375, 35.23573], [-119.32462, 35.23517], [-119.3271, 35.23519]]], [[[-119.33225, 35.24252], [-119.32342, 35.24243], [-119.32339, 35.23627], [-119.32797, 35.23524], [-119.32799, 35.2355], [-119.32807, 35.23593], [-119.32811, 35.23606], [-119.32814, 35.23626], [-119.32815, 35.23644], [-119.32805, 35.23711], [-119.32806, 35.23749], [-119.32808, 35.23762], [-119.32819, 35.23794], [-119.32822, 35.2381], [-119.32822, 35.23837], [-119.32819, 35.23859], [-119.32813, 35.23876], [-119.32832, 35.23876], [-119.32838, 35.23862], [-119.32841, 35.23846], [-119.32841, 35.23804], [-119.32836, 35.2378], [-119.32825, 35.2375], [-119.32824, 35.23712], [-119.32827, 35.237], [-119.32834, 35.23645], [-119.32834, 35.23621], [-119.3282, 35.23556], [-119.32817, 35.23519], [-119.33068, 35.23462], [-119.33068, 35.2352], [-119.33113, 35.23521], [-119.33114, 35.23607], [-119.33218, 35.23608], [-119.33225, 35.24252]]]]} | Open Access 1 | A. W. Noon Park | 15225 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 154.128 | A. W. Noon Park | ||
12579 | 12579 | 12578 | {"type": "Polygon", "coordinates": [[[-118.20079, 34.47351], [-118.1974, 34.47353], [-118.19737, 34.47181], [-118.19937, 34.4718], [-118.19969, 34.47185], [-118.1999, 34.4719], [-118.20024, 34.47204], [-118.20055, 34.47224], [-118.20078, 34.47245], [-118.20079, 34.47351]]]} | Open Access 1 | Acton Park | http://parks.lacounty.gov/wps/portal/dpr/Parks/Acton_Park | 32464 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 13.922 | Acton Park | |
11633 | 11633 | 11632 | {"type": "Polygon", "coordinates": [[[-118.19365, 34.46865], [-118.19179, 34.46986], [-118.18708, 34.46989], [-118.18708, 34.47143], [-118.18489, 34.47176], [-118.18486, 34.46632], [-118.19145, 34.46629], [-118.19146, 34.4681], [-118.19365, 34.46809], [-118.19365, 34.46865]]]} | Open Access 1 | Acton Wash Wildlife Sanctuary | http://parks.lacounty.gov/wps/portal/dpr/Parks/Acton_Wash_Sanctuary | 28184 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 75.745 | Acton Wash Wildlife Sanctuary | |
577 | 577 | 576 | {"type": "Polygon", "coordinates": [[[-122.51646, 38.01272], [-122.51615, 38.01311], [-122.51571, 38.01298], [-122.51567, 38.01286], [-122.5156, 38.01274], [-122.51562, 38.0127], [-122.51608, 38.01244], [-122.51646, 38.01272]]]} | Open Access 1 | Adrian Rosall Park | 15275 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 0.826 | Adrian Rosall Park | ||
606 | 606 | 605 | {"type": "Polygon", "coordinates": [[[-118.03777, 33.94223], [-118.03775, 33.94226], [-118.03456, 33.94387], [-118.03448, 33.94386], [-118.0328, 33.9427], [-118.03497, 33.94159], [-118.03576, 33.94213], [-118.03685, 33.94158], [-118.03773, 33.94218], [-118.03774, 33.94222], [-118.03777, 33.94223]]]} | Open Access 1 | Adventure Park | 15277 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 14.562 | Adventure Park | ||
688 | 688 | 687 | {"type": "MultiPolygon", "coordinates": [[[[-122.71352, 37.90015], [-122.71308, 37.9004], [-122.71226, 37.89978], [-122.71205, 37.89957], [-122.71193, 37.89942], [-122.7113, 37.8982], [-122.71119, 37.89809], [-122.71103, 37.89801], [-122.71091, 37.89799], [-122.71077, 37.89799], [-122.71061, 37.89803], [-122.7105, 37.89808], [-122.71041, 37.89816], [-122.71024, 37.8984], [-122.71022, 37.89851], [-122.71026, 37.89864], [-122.70995, 37.89874], [-122.71006, 37.89899], [-122.71012, 37.89919], [-122.71009, 37.8992], [-122.71, 37.89905], [-122.70983, 37.89892], [-122.70962, 37.89883], [-122.70944, 37.8988], [-122.70946, 37.89864], [-122.70969, 37.89854], [-122.70981, 37.89845], [-122.70995, 37.89832], [-122.71006, 37.89814], [-122.71013, 37.89794], [-122.71013, 37.89779], [-122.7101, 37.89764], [-122.71005, 37.8975], [-122.70991, 37.89733], [-122.70955, 37.89753], [-122.70938, 37.89742], [-122.70905, 37.89729], [-122.70883, 37.89717], [-122.70862, 37.89699], [-122.70807, 37.89619], [-122.70791, 37.89605], [-122.70774, 37.89593], [-122.70819, 37.89543], [-122.70925, 37.89589], [-122.71022, 37.89622], [-122.71056, 37.89674], [-122.71082, 37.89717], [-122.71098, 37.89748], [-122.71124, 37.89769], [-122.71126, 37.89779], [-122.71136, 37.89796], [-122.71136, 37.89802], [-122.71147, 37.89821], [-122.71194, 37.89883], [-122.71208, 37.89908], [-122.71235, 37.89934], [-122.71258, 37.89954], [-122.71285, 37.89969], [-122.71345, 37.90008], [-122.71352, 37.90015]]], [[[-122.71035, 37.90018], [-122.71029, 37.90026], [-122.71004, 37.90051], [-122.70995, 37.90066], [-122.70992, 37.90061], [-122.70991, 37.90044], [-122.70986, 37.9003], [-122.7098, 37.90028], [-122.71004, 37.8995], [-122.71008, 37.89957], [-122.71007, 37.89976], [-122.70999, 37.90011], [-122.71002, 37.90025], [-122.71035, 37.90018]]]]} | Open Access 1 | Agate Beach | 15284 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 13.709 | Agate Beach | ||
12089 | 12089 | 12088 | {"type": "Polygon", "coordinates": [[[-116.31206, 32.9622], [-116.31195, 32.96223], [-116.30382, 32.96232], [-116.29498, 32.9623], [-116.29505, 32.95855], [-116.28653, 32.95866], [-116.28678, 32.95114], [-116.29521, 32.951], [-116.29529, 32.94721], [-116.30306, 32.94726], [-116.31135, 32.94726], [-116.31206, 32.9622]]]} | Open Access 1 | Agua Caliente Regional Park | http://www.sdparks.org/content/sdparks/en/park-pages/AguaCaliente.html | 29024 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 802.635 | Agua Caliente RP | |
12487 | 12487 | 12486 | {"type": "MultiPolygon", "coordinates": [[[[-118.2896, 34.44511], [-118.28959, 34.44876], [-118.2854, 34.44869], [-118.28535, 34.44505], [-118.2896, 34.44511]]], [[[-118.29626, 34.44875], [-118.29406, 34.44876], [-118.29404, 34.44571], [-118.29402, 34.44509], [-118.29623, 34.44508], [-118.29626, 34.44875]]], [[[-118.32311, 34.4672], [-118.32304, 34.46725], [-118.32117, 34.46822], [-118.32115, 34.46719], [-118.32311, 34.4672]]]]} | Open Access 1 | Agua Dulce Canyon Parkland | 29553 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 61.585 | Agua Dulce Canyon Parkland | ||
1117 | 1117 | 1116 | {"type": "Polygon", "coordinates": [[[-120.11686, 34.66391], [-120.11686, 34.66443], [-120.11666, 34.66443], [-120.11667, 34.6639], [-120.11686, 34.66391]]]} | Open Access 1 | Alamo Pintado Creek | 15318 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.262 | Alamo Pintado Creek | ||
1119 | 1119 | 1118 | {"type": "Polygon", "coordinates": [[[-120.1236, 34.60253], [-120.12359, 34.60288], [-120.12353, 34.60288], [-120.12352, 34.60259], [-120.12299, 34.60278], [-120.12308, 34.60299], [-120.12289, 34.6031], [-120.12231, 34.60349], [-120.12213, 34.60366], [-120.12199, 34.60387], [-120.12138, 34.60522], [-120.12135, 34.60536], [-120.12135, 34.60551], [-120.12041, 34.60677], [-120.12006, 34.60677], [-120.12039, 34.60648], [-120.12062, 34.60616], [-120.12062, 34.60585], [-120.12072, 34.60567], [-120.12064, 34.60526], [-120.12075, 34.60503], [-120.12118, 34.60489], [-120.12117, 34.60452], [-120.12148, 34.60432], [-120.12159, 34.60385], [-120.1212, 34.60323], [-120.12158, 34.60313], [-120.12283, 34.60232], [-120.12284, 34.60236], [-120.12279, 34.60251], [-120.1228, 34.60253], [-120.1236, 34.60253]]]} | Open Access 1 | Alamo Pintado Creek (Solvang area) | 15320 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 6.797 | Alamo Pintado Creek (Solvang area) | ||
13515 | 13515 | 13514 | {"type": "Polygon", "coordinates": [[[-117.92427, 33.98937], [-117.92229, 33.98922], [-117.92235, 33.98879], [-117.92237, 33.98878], [-117.9235, 33.98886], [-117.92365, 33.98889], [-117.92386, 33.98897], [-117.92404, 33.98909], [-117.92417, 33.98921], [-117.92427, 33.98937]]]} | Open Access 1 | Albatross Road Rest Area | http://parks.lacounty.gov/albatross-road-rest-area/ | 32670 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 1.939 | Albatross Road Rest Area | |
1440 | 1440 | 1439 | {"type": "Polygon", "coordinates": [[[-122.5538, 38.41058], [-122.55368, 38.41107], [-122.5537, 38.41226], [-122.55207, 38.41085], [-122.55355, 38.40986], [-122.5538, 38.41058]]]} | Open Access 1 | Alder Park | 15346 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 4.856 | Alder Park | 1968 |
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]);