units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 231 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME, YR_EST
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES ▼ | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1579 | 1579 | 1578 | {"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.70929, 33.61684], [-117.70923, 33.61681], [-117.70925, 33.61678], [-117.7093, 33.61673], [-117.70966, 33.61712]]]} | Open Access 1 | 12176 | Cavanaugh Mini Park | 16980 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 0.28 | Cavanaugh MP | 0 | Local Park 2 | 4 | |
3729 | 3729 | 3728 | {"type": "Polygon", "coordinates": [[[-117.6668, 33.6425], [-117.66678, 33.64251], [-117.66672, 33.64265], [-117.66674, 33.64269], [-117.66677, 33.64271], [-117.66671, 33.64276], [-117.66642, 33.64269], [-117.66636, 33.64283], [-117.66605, 33.64307], [-117.66583, 33.64287], [-117.66602, 33.64271], [-117.66608, 33.64263], [-117.66613, 33.64255], [-117.66621, 33.64235], [-117.6668, 33.6425]]]} | Open Access 1 | 14558 | Sundowner Park | 25990 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 0.799 | Sundowner Park | 0 | Local Park 2 | 4 | |
12801 | 12801 | 12800 | {"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.65591, 33.69005], [-117.65587, 33.68998], [-117.65611, 33.68981], [-117.65586, 33.68957], [-117.65588, 33.68954], [-117.65606, 33.68947], [-117.65619, 33.68938], [-117.65656, 33.68958], [-117.65662, 33.68957], [-117.65672, 33.68967], [-117.65701, 33.68986]]]} | Open Access 1 | 30244 | Borrego Canyon Overlook Park | 32176 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 1.579 | Borrego Canyon Overlook Park | 0 | Local Park 2 | 4 | |
7548 | 7548 | 7547 | {"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.68491, 33.63476], [-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.63482], [-117.68594, 33.63502]]]} | Open Access 1 | 9469 | Ranchwood Park | 24182 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 1.839 | Ranchwood Park | 0 | Local Park 2 | 4 | |
6645 | 6645 | 6644 | {"type": "Polygon", "coordinates": [[[-117.67345, 33.6375], [-117.67294, 33.63791], [-117.6725, 33.63784], [-117.67208, 33.63789], [-117.67167, 33.63814], [-117.67156, 33.63826], [-117.67133, 33.63887], [-117.67176, 33.63918], [-117.67131, 33.63947], [-117.67099, 33.6397], [-117.67087, 33.6397], [-117.67077, 33.63963], [-117.67119, 33.63911], [-117.67151, 33.63824], [-117.67164, 33.63811], [-117.67205, 33.63786], [-117.67219, 33.6375], [-117.67245, 33.6373], [-117.67302, 33.63779], [-117.67342, 33.63747], [-117.67345, 33.6375]]]} | Open Access 1 | 4657 | City of Lake Forest Open Space | 17318 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 1.902 | City of Lake Forest OS | 0 | Local Recreation Area 3 | 4 | |
6904 | 6904 | 6903 | {"type": "Polygon", "coordinates": [[[-117.66979, 33.63888], [-117.66965, 33.639], [-117.66949, 33.63888], [-117.66934, 33.6388], [-117.6691, 33.63861], [-117.669, 33.63849], [-117.66862, 33.63822], [-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.66884, 33.63804], [-117.6692, 33.63832], [-117.66929, 33.63845], [-117.66941, 33.63854], [-117.66955, 33.63861], [-117.66963, 33.63874], [-117.66979, 33.63888]]]} | Open Access 1 | 5748 | Pebble Creek Park | 23552 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 1.998 | Pebble Creek Park | 0 | Local Park 2 | 4 | |
12802 | 12802 | 12801 | {"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 | 30245 | Alton Park | 15430 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 2.216 | Alton Park | 0 | Local Park 2 | 4 | |
1774 | 1774 | 1773 | {"type": "Polygon", "coordinates": [[[-117.67073, 33.63992], [-117.67031, 33.64036], [-117.66935, 33.64163], [-117.66896, 33.6421], [-117.66848, 33.64251], [-117.66885, 33.64158], [-117.66945, 33.64111], [-117.66954, 33.64096], [-117.66992, 33.64057], [-117.67033, 33.63966], [-117.67051, 33.63963], [-117.67073, 33.63982], [-117.67073, 33.63992]]]} | Open Access 1 | 7165 | City of Lake Forest Open Space | 17318 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 2.46 | City of Lake Forest OS | 0 | Local Recreation Area 3 | 4 | |
12808 | 12808 | 12807 | {"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 | 30252 | Peachwood Park | 23543 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 3.016 | Peachwood Park | 0 | Local Park 2 | 4 | |
670 | 670 | 669 | {"type": "Polygon", "coordinates": [[[-117.69047, 33.64202], [-117.68949, 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 | 3382 | Lake Forest Park | 20890 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 3.075 | Lake Forest Park | 0 | Local Park 2 | 4 | |
12806 | 12806 | 12805 | {"type": "Polygon", "coordinates": [[[-117.65823, 33.6523], [-117.65805, 33.65271], [-117.65789, 33.65323], [-117.65753, 33.65399], [-117.65755, 33.6541], [-117.65746, 33.65409], [-117.65687, 33.65388], [-117.65667, 33.65369], [-117.65668, 33.65365], [-117.65697, 33.65334], [-117.65721, 33.65313], [-117.65773, 33.65215], [-117.65823, 33.6523]]]} | Open Access 1 | 30249 | Vintage Park | 27148 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 3.326 | Vintage Park | 0 | Local Park 2 | 4 | |
6828 | 6828 | 6827 | {"type": "Polygon", "coordinates": [[[-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.66818, 33.64359], [-117.66827, 33.64326], [-117.66871, 33.64372], [-117.66901, 33.64391], [-117.66902, 33.64395], [-117.66895, 33.64416]]]} | Open Access 1 | 5436 | Montbury Park | 22385 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 3.438 | Montbury Park | 0 | Local Park 2 | 4 | |
14943 | 14943 | 14942 | {"type": "Polygon", "coordinates": [[[-117.66104, 33.66981], [-117.66059, 33.67149], [-117.65906, 33.67088], [-117.65939, 33.67065], [-117.65956, 33.67056], [-117.6599, 33.67046], [-117.66104, 33.66981]]]} | Open Access 1 | 45542 | Etnies Skatepark | 28372 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.etniesskatepark.com/ | Orange 3 | 3.634 | Etnies Skatepark | None 1290 | ||
12804 | 12804 | 12803 | {"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.67234, 33.66352], [-117.67208, 33.66339], [-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 | 30247 | Nature Park | 22673 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 4.54 | Nature Park | 0 | Local Park 2 | 4 | |
6890 | 6890 | 6889 | {"type": "Polygon", "coordinates": [[[-117.71182, 33.62878], [-117.71138, 33.62912], [-117.71137, 33.6292], [-117.71122, 33.62921], [-117.71074, 33.62956], [-117.71074, 33.62963], [-117.71067, 33.62965], [-117.71061, 33.62964], [-117.71032, 33.62984], [-117.70936, 33.62894], [-117.70979, 33.62875], [-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 | 5727 | Mountain View Park | 22556 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 5.253 | Mtn. View Park | 0 | Local Park 2 | 4 | |
9372 | 9372 | 9371 | {"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.68121, 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.63167], [-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.68144, 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 | 15664 | Cherry Park | 17172 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 5.435 | Cherry Park | 0 | Local Park 2 | 4 | |
2723 | 2723 | 2722 | {"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.63658], [-117.6756, 33.63612], [-117.67573, 33.63623], [-117.67517, 33.6367], [-117.67653, 33.63794], [-117.67673, 33.63807], [-117.67695, 33.63815], [-117.677, 33.63836]]]} | Open Access 1 | 18365 | Darrin Park | 17930 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 5.443 | Darrin Park | 0 | Local Park 2 | 4 | |
7844 | 7844 | 7843 | {"type": "Polygon", "coordinates": [[[-117.69628, 33.65981], [-117.69568, 33.66048], [-117.69348, 33.66067], [-117.69341, 33.65989], [-117.69537, 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 | 9434 | Rancho Serrano Park | 24176 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 5.454 | Rancho Serrano Park | 0 | Local Park 2 | 4 | |
12800 | 12800 | 12799 | {"type": "Polygon", "coordinates": [[[-117.63156, 33.6871], [-117.63147, 33.6871], [-117.63145, 33.68724], [-117.63121, 33.68741], [-117.63114, 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 | 30243 | Concourse Park | 17578 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 5.62 | Concourse Park | 1991 | Local Park 2 | 4 | |
12803 | 12803 | 12802 | {"type": "Polygon", "coordinates": [[[-117.66255, 33.6812], [-117.66146, 33.6811], [-117.66012, 33.68094], [-117.65998, 33.68041], [-117.66041, 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.68099], [-117.66256, 33.6811], [-117.66255, 33.6812]]]} | Open Access 1 | 30246 | Borrego Park | 16287 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 5.738 | Borrego Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);