superunits_with_maps

Table actions

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

30 rows where MNG_AGENCY = 231

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Lake Forest, City of · 30 ✖
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
1276 1276 1275 {"type": "Polygon", "coordinates": [[[-117.65701, 33.68986], [-117.65686, 33.69005], [-117.65663, 33.69011], [-117.65643, 33.69021], [-117.6562, 33.69028], [-117.65611, 33.69034], [-117.6559, 33.69012], [-117.6559, 33.69005], [-117.65587, 33.68998], [-117.6561, 33.6898], [-117.65586, 33.68957], [-117.65588, 33.68954], [-117.65605, 33.68947], [-117.65619, 33.68938], [-117.65656, 33.68957], [-117.65662, 33.68957], [-117.65672, 33.68967], [-117.65701, 33.68986]]]} Open Access 1 Borrego Canyon Overlook Park   32176 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 1.582 Borrego Canyon Overlook Park  
1464 1464 1463 {"type": "Polygon", "coordinates": [[[-117.66429, 33.68713], [-117.66336, 33.68697], [-117.66269, 33.68701], [-117.66265, 33.68698], [-117.66237, 33.68708], [-117.66234, 33.68711], [-117.66236, 33.68706], [-117.66239, 33.68702], [-117.66272, 33.68686], [-117.66321, 33.68652], [-117.66377, 33.6861], [-117.66394, 33.68624], [-117.66408, 33.68632], [-117.66405, 33.68643], [-117.6641, 33.68657], [-117.66405, 33.68661], [-117.66403, 33.6867], [-117.66405, 33.68674], [-117.6641, 33.68678], [-117.66418, 33.6868], [-117.66426, 33.68679], [-117.66426, 33.68697], [-117.66429, 33.68713]]]} Open Access 1 Alton Park   15430 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 2.217 Alton Park  
2161 2161 2160 {"type": "Polygon", "coordinates": [[[-117.66255, 33.6812], [-117.66146, 33.6811], [-117.66012, 33.68094], [-117.65998, 33.68041], [-117.6604, 33.68029], [-117.66039, 33.68014], [-117.6613, 33.67972], [-117.66186, 33.68024], [-117.66223, 33.68056], [-117.66242, 33.68075], [-117.66254, 33.681], [-117.66256, 33.6811], [-117.66255, 33.6812]]]} Open Access 1 Borrego Park   16287 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 5.739 Borrego Park  
2294 2294 2293 {"type": "Polygon", "coordinates": [[[-117.65864, 33.66425], [-117.65843, 33.66496], [-117.65853, 33.665], [-117.65847, 33.66516], [-117.65837, 33.66515], [-117.65817, 33.66558], [-117.65756, 33.66544], [-117.65723, 33.66615], [-117.65658, 33.66736], [-117.65606, 33.66707], [-117.65557, 33.66674], [-117.65503, 33.6663], [-117.65502, 33.66621], [-117.65489, 33.66611], [-117.65478, 33.6661], [-117.65431, 33.66572], [-117.65377, 33.66536], [-117.65339, 33.66514], [-117.65288, 33.6649], [-117.65284, 33.66481], [-117.653, 33.66444], [-117.65313, 33.66407], [-117.65324, 33.6637], [-117.65332, 33.66332], [-117.65343, 33.66343], [-117.65379, 33.66356], [-117.65403, 33.66361], [-117.65418, 33.66354], [-117.65435, 33.6635], [-117.65449, 33.66343], [-117.65459, 33.66335], [-117.65479, 33.66312], [-117.65494, 33.66283], [-117.65495, 33.66247], [-117.65501, 33.66234], [-117.6551, 33.66185], [-117.65509, 33.6618], [-117.65506, 33.66176], [-117.65498, 33.66171], [-117.65485, 33.66168], [-117.65482, 33.66164], [-117.65481, 33.66159], [-117.65484, 33.66155], [-117.65505, 33.66138], [-117.65531, 33.66114], [-117.65554, 33.66104], [-117.65564, 33.66109], [-117.65573, 33.66102], [-117.6557, 33.66098], [-117.65577, 33.66093], [-117.65583, 33.66087], [-117.65588, 33.66078], [-117.65588, 33.66072], [-117.65586, 33.66069], [-117.65579, 33.66063], [-117.65559, 33.66053], [-117.65557, 33.66048], [-117.65568, 33.66038], [-117.65632, 33.66031], [-117.65652, 33.66013], [-117.65669, 33.66003], [-117.65696, 33.65992], [-117.65716, 33.65989], [-117.65736, 33.65988], [-117.65765, 33.65991], [-117.65784, 33.65997], [-117.65802, 33.66005], [-117.65859, 33.66037], [-117.65923, 33.66092], [-117.65931, 33.66101], [-117.65937, 33.66111], [-117.6594, 33.66122], [-117.6594, 33.66134], [-117.65934, 33.66151], [-117.65819, 33.66297], [-117.65793, 33.66386], [-117.65794, 33.66387], [-117.65837, 33.66381], [-117.65835, 33.66409], [-117.65864, 33.66425]]]} Open Access 1 Lake Forest Sports Park http://lfsportspark.com/ 32259 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 66.115 Lake Forest Sports Park 2014
2723 2723 2722 {"type": "Polygon", "coordinates": [[[-117.70966, 33.61712], [-117.70951, 33.6172], [-117.70949, 33.61728], [-117.70942, 33.61718], [-117.70936, 33.61714], [-117.70928, 33.61711], [-117.70919, 33.61711], [-117.70913, 33.61713], [-117.70922, 33.617], [-117.70927, 33.61697], [-117.7093, 33.61692], [-117.70928, 33.61684], [-117.70923, 33.61681], [-117.70925, 33.61678], [-117.7093, 33.61673], [-117.70966, 33.61712]]]} Open Access 1 Cavanaugh Mini Park   16980 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 0.281 Cavanaugh MP  
2878 2878 2877 {"type": "Polygon", "coordinates": [[[-117.68222, 33.63233], [-117.68179, 33.63268], [-117.68138, 33.63282], [-117.68118, 33.63301], [-117.68117, 33.63328], [-117.6815, 33.63322], [-117.68152, 33.63326], [-117.68122, 33.63333], [-117.68122, 33.63341], [-117.68106, 33.63342], [-117.68088, 33.6332], [-117.68062, 33.63271], [-117.68045, 33.6325], [-117.68046, 33.63244], [-117.68071, 33.6321], [-117.68077, 33.63193], [-117.68077, 33.63168], [-117.68075, 33.63156], [-117.68068, 33.63139], [-117.68055, 33.63121], [-117.68018, 33.63089], [-117.68011, 33.63081], [-117.68004, 33.63061], [-117.68005, 33.63042], [-117.68062, 33.6309], [-117.68128, 33.63149], [-117.68133, 33.6315], [-117.68133, 33.63154], [-117.68136, 33.63158], [-117.68144, 33.63161], [-117.68145, 33.63169], [-117.6818, 33.63199], [-117.68194, 33.63201], [-117.68197, 33.63204], [-117.68204, 33.63208], [-117.68202, 33.63215], [-117.68222, 33.63233]]]} Open Access 1 Cherry Park   17172 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 5.441 Cherry Park  
3141 3141 3140 {"type": "Polygon", "coordinates": [[[-117.63156, 33.6871], [-117.63148, 33.6871], [-117.63145, 33.68724], [-117.63121, 33.68741], [-117.63115, 33.68749], [-117.6311, 33.68757], [-117.63079, 33.68762], [-117.63038, 33.68767], [-117.63018, 33.68767], [-117.62999, 33.68762], [-117.62989, 33.68757], [-117.62982, 33.68752], [-117.62966, 33.68734], [-117.62947, 33.68701], [-117.62931, 33.68677], [-117.62927, 33.68674], [-117.62958, 33.68662], [-117.62974, 33.68653], [-117.6301, 33.68626], [-117.63026, 33.68639], [-117.63041, 33.68646], [-117.63057, 33.68644], [-117.63102, 33.68643], [-117.63129, 33.68627], [-117.63156, 33.6871]]]} Open Access 1 Concourse Park   17578 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 5.621 Concourse Park 1991
3444 3444 3443 {"type": "Polygon", "coordinates": [[[-117.677, 33.63836], [-117.67659, 33.63842], [-117.67612, 33.63844], [-117.67544, 33.63843], [-117.67543, 33.63777], [-117.67505, 33.63704], [-117.67456, 33.63718], [-117.67429, 33.63694], [-117.67389, 33.63718], [-117.67362, 33.63742], [-117.67354, 33.63736], [-117.67476, 33.63636], [-117.67502, 33.63657], [-117.6756, 33.63612], [-117.67573, 33.63623], [-117.67518, 33.63671], [-117.67653, 33.63794], [-117.67673, 33.63807], [-117.67695, 33.63815], [-117.677, 33.63836]]]} Open Access 1 Darrin Park   17930 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 5.461 Darrin Park  
3928 3928 3927 {"type": "Polygon", "coordinates": [[[-117.69609, 33.61357], [-117.69569, 33.61418], [-117.6956, 33.61436], [-117.69548, 33.6154], [-117.69545, 33.61558], [-117.69515, 33.6161], [-117.69455, 33.617], [-117.69455, 33.61708], [-117.69458, 33.61712], [-117.69462, 33.61712], [-117.69418, 33.61781], [-117.69372, 33.61814], [-117.69289, 33.61725], [-117.69478, 33.61459], [-117.69567, 33.61338], [-117.69609, 33.61357]]]} Open Access 1 El Toro Park   18546 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 12.738 El Toro Park  
5080 5080 5079 {"type": "Polygon", "coordinates": [[[-117.68927, 33.62278], [-117.68788, 33.62387], [-117.68692, 33.62467], [-117.6864, 33.62386], [-117.68614, 33.62354], [-117.68581, 33.62322], [-117.6855, 33.623], [-117.6855, 33.6229], [-117.68727, 33.62139], [-117.68738, 33.62148], [-117.68763, 33.62149], [-117.68788, 33.62168], [-117.68788, 33.62176], [-117.68811, 33.62195], [-117.68821, 33.62195], [-117.68867, 33.62235], [-117.68883, 33.62243], [-117.68897, 33.62244], [-117.68927, 33.62278]]]} Open Access 1 Heroes Park   19876 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 15.63 Heroes Park  
5909 5909 5908 {"type": "Polygon", "coordinates": [[[-117.7145, 33.62239], [-117.71426, 33.62257], [-117.71372, 33.62197], [-117.71285, 33.62261], [-117.71277, 33.62251], [-117.71271, 33.62237], [-117.71269, 33.62221], [-117.71271, 33.62207], [-117.71276, 33.62196], [-117.71287, 33.62183], [-117.71322, 33.62159], [-117.71326, 33.6215], [-117.71325, 33.6214], [-117.71319, 33.62132], [-117.71167, 33.6197], [-117.70952, 33.61734], [-117.70949, 33.61728], [-117.70951, 33.6172], [-117.70966, 33.61712], [-117.71251, 33.62021], [-117.71284, 33.62061], [-117.71319, 33.62099], [-117.71328, 33.62106], [-117.71339, 33.62129], [-117.71362, 33.62142], [-117.71374, 33.62152], [-117.71413, 33.62196], [-117.71412, 33.62198], [-117.7145, 33.62239]]]} Open Access 1 Lake Forest holding 1   20889 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 6.314 Lake Forest holding 1  
5910 5910 5909 {"type": "Polygon", "coordinates": [[[-117.69047, 33.64202], [-117.6895, 33.64248], [-117.68928, 33.64248], [-117.68929, 33.64228], [-117.68926, 33.64185], [-117.68917, 33.64134], [-117.68929, 33.64128], [-117.68948, 33.64105], [-117.68975, 33.64092], [-117.69047, 33.64202]]]} Open Access 1 Lake Forest Park   20890 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 3.075 Lake Forest Park  
6119 6119 6118 {"type": "Polygon", "coordinates": [[[-117.71182, 33.62878], [-117.71138, 33.62912], [-117.71137, 33.6292], [-117.71122, 33.62922], [-117.71074, 33.62955], [-117.71074, 33.62963], [-117.71067, 33.62965], [-117.7106, 33.62964], [-117.71032, 33.62984], [-117.70936, 33.62894], [-117.70979, 33.62874], [-117.71033, 33.62839], [-117.71053, 33.62831], [-117.71077, 33.62828], [-117.71083, 33.62825], [-117.71087, 33.62821], [-117.71139, 33.62839], [-117.71137, 33.62845], [-117.71139, 33.62852], [-117.71144, 33.62855], [-117.71157, 33.62858], [-117.71182, 33.62878]]]} Open Access 1 Mountain View Park   22556 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 5.254 Mtn. View Park  
6819 6819 6818 {"type": "Polygon", "coordinates": [[[-117.66979, 33.63888], [-117.66965, 33.639], [-117.6695, 33.63888], [-117.66934, 33.6388], [-117.6691, 33.63861], [-117.669, 33.63849], [-117.66863, 33.63823], [-117.66843, 33.63838], [-117.66835, 33.63834], [-117.66828, 33.63833], [-117.66827, 33.63826], [-117.66805, 33.63807], [-117.66877, 33.63745], [-117.6691, 33.63767], [-117.66906, 33.63776], [-117.66907, 33.63785], [-117.66885, 33.63805], [-117.6692, 33.63832], [-117.66929, 33.63845], [-117.66941, 33.63854], [-117.66955, 33.63861], [-117.66964, 33.63874], [-117.66979, 33.63888]]]} Open Access 1 Pebble Creek Park   23552 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 2.005 Pebble Creek Park  
7120 7120 7119 {"type": "Polygon", "coordinates": [[[-117.66901, 33.64391], [-117.66902, 33.64395], [-117.66895, 33.64416], [-117.66852, 33.644], [-117.66844, 33.64402], [-117.66818, 33.64458], [-117.6681, 33.64484], [-117.66779, 33.64488], [-117.66755, 33.64433], [-117.66741, 33.64419], [-117.66707, 33.64408], [-117.66675, 33.64408], [-117.66681, 33.64401], [-117.66776, 33.64365], [-117.66791, 33.64361], [-117.66817, 33.64358], [-117.66827, 33.64326], [-117.66871, 33.64372], [-117.66901, 33.64391]]]} Open Access 1 Montbury Park   22385 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 3.44 Montbury Park  
7321 7321 7320 {"type": "Polygon", "coordinates": [[[-117.67366, 33.663], [-117.6735, 33.66295], [-117.67336, 33.66296], [-117.67292, 33.66329], [-117.67268, 33.66345], [-117.67245, 33.66352], [-117.67235, 33.66352], [-117.67208, 33.6634], [-117.67157, 33.66367], [-117.67065, 33.664], [-117.67024, 33.66426], [-117.67014, 33.66429], [-117.66986, 33.66453], [-117.66977, 33.66473], [-117.66977, 33.665], [-117.66957, 33.66482], [-117.67001, 33.66419], [-117.67009, 33.66418], [-117.67033, 33.66362], [-117.67187, 33.66317], [-117.67253, 33.66266], [-117.67312, 33.66259], [-117.67356, 33.6629], [-117.67366, 33.663]]]} Open Access 1 Nature Park   22673 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 4.542 Nature Park  
8041 8041 8040 {"type": "Polygon", "coordinates": [[[-117.68791, 33.65494], [-117.68763, 33.65546], [-117.68727, 33.6562], [-117.68717, 33.65645], [-117.68653, 33.65628], [-117.68721, 33.65464], [-117.68731, 33.65466], [-117.6876, 33.65485], [-117.68791, 33.65494]]]} Open Access 1 Peachwood Park   23543 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 3.016 Peachwood Park  
8212 8212 8211 {"type": "Polygon", "coordinates": [[[-117.67237, 33.6469], [-117.67233, 33.64708], [-117.67221, 33.64734], [-117.67221, 33.64761], [-117.67231, 33.6481], [-117.6723, 33.64822], [-117.67224, 33.64843], [-117.67217, 33.64849], [-117.67198, 33.64854], [-117.67183, 33.64863], [-117.67141, 33.64905], [-117.67136, 33.64914], [-117.67134, 33.64934], [-117.67115, 33.64964], [-117.67018, 33.64921], [-117.67055, 33.64859], [-117.67071, 33.64827], [-117.67086, 33.64794], [-117.67094, 33.64768], [-117.67102, 33.64723], [-117.67103, 33.6469], [-117.67101, 33.64654], [-117.67201, 33.64633], [-117.67231, 33.64674], [-117.67237, 33.6469]]]} Open Access 1 Pittsford Park   23751 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 9.932 Pittsford Park  
8543 8543 8542 {"type": "Polygon", "coordinates": [[[-117.69628, 33.65981], [-117.69568, 33.66048], [-117.69348, 33.66067], [-117.69341, 33.65989], [-117.69536, 33.65978], [-117.69538, 33.65943], [-117.69552, 33.65942], [-117.69558, 33.65938], [-117.69563, 33.65926], [-117.69628, 33.65981]]]} Open Access 1 Rancho Serrano Park   24176 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 5.458 Rancho Serrano Park  
8547 8547 8546 {"type": "Polygon", "coordinates": [[[-117.68594, 33.63502], [-117.68551, 33.63537], [-117.68527, 33.63507], [-117.68506, 33.63488], [-117.68481, 33.635], [-117.68477, 33.63496], [-117.6849, 33.63475], [-117.68448, 33.63438], [-117.68447, 33.63431], [-117.68442, 33.63425], [-117.68451, 33.63412], [-117.68465, 33.63406], [-117.68471, 33.63411], [-117.68481, 33.63412], [-117.68523, 33.6345], [-117.68548, 33.63439], [-117.68553, 33.63442], [-117.68538, 33.63463], [-117.6856, 33.63483], [-117.68594, 33.63502]]]} Open Access 1 Ranchwood Park   24182 1167 Lake Forest, City of 231 City 2 City Agency 2 http://www.lakeforestca.gov/depts/cs/city_parks/default.asp City 2 1.847 Ranchwood 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]);