superunits_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

356 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

  • City Agency · 356 ✖

ACCESS_TYP 1

  • Restricted Access · 356 ✖
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
22 22 21 {"type": "Polygon", "coordinates": [[[-118.20225, 34.07513], [-118.20167, 34.07513], [-118.20166, 34.07528], [-118.20122, 34.07529], [-118.20119, 34.07523], [-118.20091, 34.07524], [-118.20089, 34.07513], [-118.2003, 34.07515], [-118.20011, 34.07437], [-118.20176, 34.07436], [-118.20178, 34.07497], [-118.20225, 34.07497], [-118.20225, 34.07513]]]} Restricted Access 2 Abraham Lincoln High School Park   31843 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 3.473 Abraham Lincoln High School Park  
65 65 64 {"type": "Polygon", "coordinates": [[[-122.10311, 37.87618], [-122.10304, 37.87629], [-122.10157, 37.87704], [-122.10079, 37.87704], [-122.10071, 37.87693], [-122.10056, 37.87677], [-122.09956, 37.8759], [-122.09896, 37.87548], [-122.09889, 37.87537], [-122.09866, 37.87468], [-122.09864, 37.87453], [-122.10311, 37.87618]]]} Restricted Access 2 711 St. Mary's Road Park   15210 1163 Lafayette, City of 232 City 2 City Agency 2 http://www.ci.lafayette.ca.us/index.aspx?page=87 City 2 11.502 711 St. Mary's Road Park 1983
88 88 87 {"type": "Polygon", "coordinates": [[[-121.81438, 37.97557], [-121.81346, 37.97593], [-121.81013, 37.97849], [-121.80552, 37.97659], [-121.8055, 37.97661], [-121.8055, 37.97675], [-121.80486, 37.9766], [-121.80409, 37.97634], [-121.80327, 37.97567], [-121.80324, 37.9754], [-121.80326, 37.97517], [-121.80333, 37.97497], [-121.80346, 37.97479], [-121.80354, 37.9747], [-121.80373, 37.97456], [-121.80442, 37.97421], [-121.80467, 37.97405], [-121.80478, 37.97396], [-121.80496, 37.97376], [-121.80508, 37.97352], [-121.80529, 37.97278], [-121.80555, 37.97177], [-121.80557, 37.97145], [-121.80557, 37.97081], [-121.80557, 37.97013], [-121.80559, 37.96964], [-121.80559, 37.96849], [-121.81433, 37.96848], [-121.81438, 37.97557]]]} Restricted Access 2 Lone Tree Golf Course   33051 1007 Antioch, City of 347 City 2 City Agency 2 http://www.ci.antioch.ca.us/Recreation/parks.asp City 2 198.555 Lone Tree GC  
166 166 165 {"type": "Polygon", "coordinates": [[[-118.03633, 34.13066], [-118.03547, 34.13067], [-118.03546, 34.13071], [-118.03229, 34.13073], [-118.03226, 34.12947], [-118.03497, 34.12908], [-118.03499, 34.12944], [-118.03598, 34.12943], [-118.03599, 34.1298], [-118.0363, 34.12981], [-118.03633, 34.13066]]]} Restricted Access 2 Arcadia High School Park http://ahs.ausd.net/ 31846 1009 Arcadia, City of 299 City 2 City Agency 2 http://www.ci.arcadia.ca.us/home/index.asp?page=1160 City 2 13.82 Arcadia High School Park  
167 167 166 {"type": "Polygon", "coordinates": [[[-118.04812, 34.11743], [-118.0462, 34.11746], [-118.04618, 34.11714], [-118.04576, 34.11714], [-118.04575, 34.11667], [-118.04763, 34.11665], [-118.04764, 34.11711], [-118.04812, 34.11711], [-118.04812, 34.11743]]]} Restricted Access 2 Baldwin Stocker Elementary School Park http://bs.ausd.net/ 31847 1009 Arcadia, City of 299 City 2 City Agency 2 http://www.ci.arcadia.ca.us/home/index.asp?page=1160 City 2 3.8 Baldwin Stocker Elementary School Park  
169 169 168 {"type": "MultiPolygon", "coordinates": [[[[-118.41144, 34.06052], [-118.41139, 34.0606], [-118.41084, 34.06086], [-118.41086, 34.06092], [-118.41072, 34.06099], [-118.41068, 34.06094], [-118.40952, 34.06146], [-118.40927, 34.06126], [-118.40916, 34.06114], [-118.40908, 34.061], [-118.40903, 34.06085], [-118.40902, 34.0607], [-118.40902, 34.06015], [-118.40961, 34.05987], [-118.40985, 34.05982], [-118.40998, 34.05983], [-118.41003, 34.05986], [-118.4101, 34.05989], [-118.41017, 34.05998], [-118.41025, 34.05995], [-118.4103, 34.06002], [-118.41097, 34.05971], [-118.4114, 34.06031], [-118.41144, 34.06044], [-118.41144, 34.06052]]], [[[-118.41243, 34.06254], [-118.41206, 34.06271], [-118.41213, 34.06284], [-118.41212, 34.06285], [-118.41172, 34.06272], [-118.41123, 34.06236], [-118.411, 34.06223], [-118.41066, 34.0618], [-118.41142, 34.06141], [-118.41159, 34.06162], [-118.41191, 34.06147], [-118.41231, 34.06203], [-118.41218, 34.06212], [-118.41226, 34.06224], [-118.41224, 34.06227], [-118.41243, 34.06254]]]]} Restricted Access 2 Beverly Hills High School Park   31849 1029 Beverly Hills, City of 200 City 2 City Agency 2 http://www.beverlyhills.org/living/recreationparks/ City 2 10.454 Beverly Hills High School Park  
175 175 174 {"type": "MultiPolygon", "coordinates": [[[[-121.12574, 36.20479], [-121.12572, 36.2048], [-121.12555, 36.20471], [-121.12534, 36.20465], [-121.12512, 36.20465], [-121.12496, 36.20469], [-121.12271, 36.20586], [-121.12271, 36.20588], [-121.12331, 36.20664], [-121.1226, 36.20702], [-121.12158, 36.20725], [-121.12096, 36.2065], [-121.11972, 36.20706], [-121.11881, 36.20599], [-121.11886, 36.20594], [-121.11821, 36.205], [-121.11858, 36.20483], [-121.11869, 36.20432], [-121.11985, 36.20344], [-121.12047, 36.20329], [-121.12069, 36.20336], [-121.12112, 36.20368], [-121.12174, 36.20387], [-121.12159, 36.20398], [-121.12159, 36.204], [-121.12179, 36.20394], [-121.12301, 36.20385], [-121.12318, 36.20369], [-121.12353, 36.20281], [-121.12473, 36.20293], [-121.125, 36.20297], [-121.12471, 36.2037], [-121.1249, 36.20371], [-121.12574, 36.20479]]], [[[-121.12664, 36.20208], [-121.12626, 36.20229], [-121.12648, 36.20249], [-121.12617, 36.20244], [-121.12532, 36.20239], [-121.12362, 36.20222], [-121.12415, 36.201], [-121.12359, 36.20061], [-121.12434, 36.19963], [-121.12494, 36.19982], [-121.12496, 36.20087], [-121.12489, 36.20119], [-121.12487, 36.20141], [-121.12589, 36.20169], [-121.12664, 36.20208]]]]} Restricted Access 2 King City Golf Course   33052 1152 King City, City of 473 City 2 City Agency 2 http://www.kingcity.com/ City 2 53.754 King City GC  
181 181 180 {"type": "Polygon", "coordinates": [[[-122.28084, 38.26895], [-122.2782, 38.26902], [-122.27677, 38.2671], [-122.27631, 38.26737], [-122.27697, 38.26817], [-122.27675, 38.26949], [-122.27213, 38.27026], [-122.2719, 38.2693], [-122.27173, 38.26867], [-122.27151, 38.26765], [-122.27138, 38.26693], [-122.27119, 38.26559], [-122.27113, 38.26497], [-122.27106, 38.26416], [-122.27105, 38.26351], [-122.27168, 38.26331], [-122.27332, 38.2629], [-122.27458, 38.26299], [-122.2765, 38.26337], [-122.27675, 38.2632], [-122.27694, 38.26317], [-122.27776, 38.26348], [-122.27804, 38.26326], [-122.27815, 38.26282], [-122.27845, 38.26244], [-122.27855, 38.26202], [-122.2785, 38.26124], [-122.2787, 38.26096], [-122.27943, 38.26047], [-122.28056, 38.25989], [-122.28082, 38.2597], [-122.28084, 38.26895]]]} Restricted Access 2 Napa Golf Course https://www.playnapa.com/ 33054 1397 Napa, City of 441 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 156.018 Napa GC 1958
183 183 182 {"type": "Polygon", "coordinates": [[[-119.25659, 34.24231], [-119.25428, 34.2423], [-119.25451, 34.244], [-119.25412, 34.24391], [-119.25352, 34.24372], [-119.2535, 34.2436], [-119.25333, 34.24354], [-119.25321, 34.24362], [-119.25217, 34.24328], [-119.25168, 34.24317], [-119.25117, 34.24308], [-119.25049, 34.24303], [-119.2489, 34.24299], [-119.24828, 34.24302], [-119.24768, 34.2431], [-119.24766, 34.24276], [-119.24749, 34.24276], [-119.24709, 34.24323], [-119.24437, 34.24382], [-119.2436, 34.24393], [-119.24348, 34.24318], [-119.24343, 34.24302], [-119.24322, 34.24276], [-119.24288, 34.24238], [-119.2422, 34.24282], [-119.24183, 34.24303], [-119.24184, 34.24356], [-119.24141, 34.24358], [-119.24116, 34.24321], [-119.24087, 34.23673], [-119.24288, 34.23684], [-119.25623, 34.23634], [-119.25629, 34.23783], [-119.25642, 34.23784], [-119.25659, 34.24231]]]} Restricted Access 2 Olivas Links Golf Course   33063 1366 Ventura, City of 110 City 2 City Agency 2 http://www.cityofventura.net/prcp City 2 254.625 Olivas Links GC  
188 188 187 {"type": "Polygon", "coordinates": [[[-121.01091, 37.61013], [-121.01091, 37.61163], [-121.01087, 37.61165], [-121.01029, 37.61166], [-121.01028, 37.61259], [-121.00951, 37.6126], [-121.0095, 37.61333], [-121.00713, 37.61333], [-121.00712, 37.6133], [-121.0069, 37.6132], [-121.00574, 37.61394], [-121.00469, 37.61511], [-121.00313, 37.61607], [-121.00289, 37.61661], [-121.00346, 37.61667], [-121.00337, 37.61699], [-121.00483, 37.617], [-121.00483, 37.61781], [-121.00413, 37.61781], [-121.00412, 37.61791], [-121.00265, 37.61791], [-121.00265, 37.61769], [-121.00263, 37.61768], [-121.00076, 37.62018], [-121.00023, 37.62069], [-120.99954, 37.62116], [-120.99932, 37.62134], [-120.99844, 37.62135], [-120.99856, 37.61961], [-120.99866, 37.61853], [-120.99872, 37.61772], [-120.9986, 37.61696], [-120.99845, 37.61648], [-120.99809, 37.61568], [-120.99824, 37.61515], [-121.00054, 37.61294], [-121.0023, 37.61183], [-121.00496, 37.61077], [-121.00724, 37.61022], [-121.00952, 37.60948], [-121.00953, 37.60976], [-121.00959, 37.60976], [-121.01091, 37.61013]]]} Restricted Access 2 Dryden Park Golf Course   33067 1208 Modesto, City of 510 City 2 City Agency 2 http://www.modestogov.com/prnd/ City 2 145.269 Dryden Park GC  
215 215 214 {"type": "Polygon", "coordinates": [[[-118.17442, 34.11313], [-118.17382, 34.11314], [-118.17249, 34.1138], [-118.1717, 34.11481], [-118.17141, 34.1152], [-118.17123, 34.11541], [-118.17063, 34.11525], [-118.17023, 34.11568], [-118.1699, 34.11588], [-118.16957, 34.11604], [-118.1687, 34.11633], [-118.1684, 34.11659], [-118.16778, 34.11722], [-118.16752, 34.1172], [-118.16721, 34.11716], [-118.16702, 34.11722], [-118.16668, 34.1172], [-118.16617, 34.11698], [-118.1663, 34.1167], [-118.16644, 34.11652], [-118.16714, 34.1158], [-118.16736, 34.11565], [-118.16786, 34.11535], [-118.16903, 34.11436], [-118.17094, 34.11312], [-118.17138, 34.11306], [-118.1719, 34.11287], [-118.17256, 34.11271], [-118.17296, 34.1125], [-118.17362, 34.11232], [-118.17402, 34.11239], [-118.17442, 34.11313]]]} Restricted Access 2 Arroyo Seco Golf Course http://www.arroyosecogolf.com/Home.html 29411 1340 South Pasadena, City of 306 City 2 City Agency 2 http://www.ci.south-pasadena.ca.us/ City 2 31.165 Arroyo Seco GC  
232 232 231 {"type": "Polygon", "coordinates": [[[-118.38356, 34.06628], [-118.38312, 34.0663], [-118.3831, 34.06602], [-118.38268, 34.06603], [-118.38267, 34.06595], [-118.38262, 34.06594], [-118.3826, 34.06506], [-118.38346, 34.06506], [-118.38351, 34.06508], [-118.38356, 34.06628]]]} Restricted Access 2 Horace Mann Elementary School Park   31881 1029 Beverly Hills, City of 200 City 2 City Agency 2 http://www.beverlyhills.org/living/recreationparks/ City 2 2.535 Horace Mann Elementary School Park  
235 235 234 {"type": "Polygon", "coordinates": [[[-118.39479, 34.06229], [-118.39479, 34.06361], [-118.39394, 34.06362], [-118.39394, 34.06229], [-118.39479, 34.06229]]]} Restricted Access 2 Beverly Vista Elementary School Park   31882 1029 Beverly Hills, City of 200 City 2 City Agency 2 http://www.beverlyhills.org/living/recreationparks/ City 2 2.838 Beverly Vista Elementary School Park  
236 236 235 {"type": "MultiPolygon", "coordinates": [[[[-118.40382, 34.07823], [-118.40328, 34.0785], [-118.40298, 34.07798], [-118.40351, 34.07775], [-118.40382, 34.07823]]], [[[-118.40519, 34.07988], [-118.404, 34.08055], [-118.40365, 34.08016], [-118.40422, 34.07986], [-118.40483, 34.07951], [-118.40519, 34.07988]]]]} Restricted Access 2 Hawthorne Elementary School Park   31883 1029 Beverly Hills, City of 200 City 2 City Agency 2 http://www.beverlyhills.org/living/recreationparks/ City 2 2.582 Hawthorne Elementary School Park  
237 237 236 {"type": "Polygon", "coordinates": [[[-118.41726, 34.06839], [-118.41627, 34.06893], [-118.41612, 34.06875], [-118.41596, 34.06861], [-118.41582, 34.06852], [-118.41542, 34.06833], [-118.41525, 34.0682], [-118.41505, 34.068], [-118.41489, 34.06775], [-118.41483, 34.06759], [-118.41478, 34.06733], [-118.41477, 34.06722], [-118.41588, 34.06722], [-118.41602, 34.06756], [-118.41573, 34.06767], [-118.41586, 34.06795], [-118.41595, 34.06793], [-118.416, 34.06794], [-118.41609, 34.06801], [-118.41588, 34.0681], [-118.41597, 34.06832], [-118.41609, 34.0683], [-118.41627, 34.0687], [-118.41651, 34.06863], [-118.41669, 34.06851], [-118.41654, 34.06811], [-118.41696, 34.06797], [-118.41726, 34.06839]]]} Restricted Access 2 El Rodeo Elementary School Park   31884 1029 Beverly Hills, City of 200 City 2 City Agency 2 http://www.beverlyhills.org/living/recreationparks/ City 2 4.009 El Rodeo Elementary School Park  
239 239 238 {"type": "Polygon", "coordinates": [[[-118.03099, 34.1252], [-118.02957, 34.12521], [-118.02955, 34.12535], [-118.02912, 34.12535], [-118.0291, 34.12542], [-118.02813, 34.12543], [-118.02812, 34.12478], [-118.02925, 34.12479], [-118.02927, 34.12465], [-118.02978, 34.12463], [-118.0298, 34.12408], [-118.02984, 34.12407], [-118.02985, 34.12371], [-118.03014, 34.12371], [-118.03015, 34.12396], [-118.03097, 34.12395], [-118.03099, 34.1252]]]} Restricted Access 2 Dana Middle School Park http://da.ausd.net/ 31886 1009 Arcadia, City of 299 City 2 City Agency 2 http://www.ci.arcadia.ca.us/home/index.asp?page=1160 City 2 6.605 Dana Middle School Park  
240 240 239 {"type": "Polygon", "coordinates": [[[-118.0253, 34.15295], [-118.02529, 34.15431], [-118.02515, 34.15463], [-118.02234, 34.1547], [-118.0223, 34.1529], [-118.0231, 34.15289], [-118.02313, 34.15299], [-118.0253, 34.15295]]]} Restricted Access 2 Highland Oaks Middle School Park   31887 1009 Arcadia, City of 299 City 2 City Agency 2 http://www.ci.arcadia.ca.us/home/index.asp?page=1160 City 2 12.835 Highland Oaks Middle School Park  
241 241 240 {"type": "Polygon", "coordinates": [[[-118.04253, 34.10858], [-118.04125, 34.10859], [-118.04124, 34.10783], [-118.0413, 34.1078], [-118.04245, 34.10778], [-118.04249, 34.10779], [-118.04251, 34.10784], [-118.04253, 34.10858]]]} Restricted Access 2 Longley Way Elementary School Park http://lw.ausd.net/ 31888 1009 Arcadia, City of 299 City 2 City Agency 2 http://www.ci.arcadia.ca.us/home/index.asp?page=1160 City 2 2.551 Longley Way Elementary School Park  
242 242 241 {"type": "Polygon", "coordinates": [[[-118.06394, 34.13718], [-118.06273, 34.13744], [-118.06271, 34.13685], [-118.06273, 34.13669], [-118.06278, 34.1366], [-118.06286, 34.13651], [-118.06329, 34.13619], [-118.06337, 34.13619], [-118.0634, 34.13621], [-118.06394, 34.13718]]]} Restricted Access 2 Hugo Reid Elementary School Park http://hr.ausd.net/ 31889 1009 Arcadia, City of 299 City 2 City Agency 2 http://www.ci.arcadia.ca.us/home/index.asp?page=1160 City 2 2.432 Hugo Reid Elementary School Park  
243 243 242 {"type": "Polygon", "coordinates": [[[-118.38508, 33.88995], [-118.38506, 33.89099], [-118.38313, 33.89099], [-118.38313, 33.88995], [-118.38508, 33.88995]]]} Restricted Access 2 Manhattan Beach Middle School Park   31890 1194 Manhattan Beach, City of 486 City 2 City Agency 2 http://www.ci.manhattan-beach.ca.us/city-services/parks-and-recreation City 2 5.093 Manhattan Beach Middle School Park  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);