superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where MNG_AGENCY = 231 sorted by id
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8622 | 8622 | 8621 | {"type": "Polygon", "coordinates": [[[-117.66391, 33.65988], [-117.66343, 33.66021], [-117.6623, 33.66101], [-117.66222, 33.66105], [-117.66184, 33.66085], [-117.66119, 33.66067], [-117.66096, 33.66058], [-117.66078, 33.66049], [-117.66053, 33.66033], [-117.66043, 33.66025], [-117.66024, 33.66005], [-117.66022, 33.66], [-117.66022, 33.65998], [-117.66026, 33.65996], [-117.66048, 33.65989], [-117.66112, 33.65983], [-117.66151, 33.65982], [-117.66162, 33.65977], [-117.66166, 33.65969], [-117.66338, 33.65972], [-117.66339, 33.65977], [-117.6638, 33.65979], [-117.66391, 33.65988]]]} | Open Access 1 | Regency Park | 24271 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 7.312 | Regency Park | ||
8707 | 8707 | 8706 | {"type": "Polygon", "coordinates": [[[-117.68051, 33.64438], [-117.67993, 33.64591], [-117.67977, 33.64586], [-117.67956, 33.64576], [-117.67878, 33.6453], [-117.67856, 33.6452], [-117.67837, 33.64514], [-117.67799, 33.64511], [-117.67797, 33.64509], [-117.67787, 33.64457], [-117.67955, 33.6437], [-117.68051, 33.64438]]]} | Open Access 1 | Rimgate Park | 24364 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 8.429 | Rimgate Park | ||
9521 | 9521 | 9520 | {"type": "Polygon", "coordinates": [[[-117.70692, 33.65013], [-117.70605, 33.65112], [-117.70593, 33.65114], [-117.70456, 33.65042], [-117.70383, 33.65063], [-117.70301, 33.65015], [-117.70212, 33.64924], [-117.69958, 33.64878], [-117.6988, 33.64883], [-117.69849, 33.64914], [-117.69675, 33.64944], [-117.69591, 33.64907], [-117.69402, 33.64891], [-117.69335, 33.64903], [-117.69258, 33.64884], [-117.69199, 33.64856], [-117.69134, 33.6483], [-117.69111, 33.64823], [-117.69083, 33.64829], [-117.69028, 33.6487], [-117.69003, 33.64895], [-117.68951, 33.64967], [-117.68867, 33.64928], [-117.68883, 33.64922], [-117.68916, 33.64905], [-117.68924, 33.64895], [-117.68934, 33.64875], [-117.68946, 33.64858], [-117.68958, 33.64847], [-117.6898, 33.64834], [-117.69027, 33.6482], [-117.69094, 33.64786], [-117.6911, 33.64784], [-117.6913, 33.64785], [-117.69167, 33.64757], [-117.69174, 33.64727], [-117.69291, 33.64742], [-117.69348, 33.64751], [-117.69519, 33.64804], [-117.6956, 33.64809], [-117.69602, 33.6481], [-117.69643, 33.64805], [-117.69752, 33.64774], [-117.69802, 33.64759], [-117.69803, 33.64756], [-117.69825, 33.64752], [-117.69857, 33.64749], [-117.69884, 33.6475], [-117.69934, 33.64756], [-117.69997, 33.64774], [-117.69996, 33.64783], [-117.7003, 33.64792], [-117.70069, 33.64796], [-117.70095, 33.64794], [-117.70102, 33.64818], [-117.70259, 33.64881], [-117.70283, 33.64899], [-117.70335, 33.64954], [-117.70364, 33.64956], [-117.70371, 33.64927], [-117.70391, 33.64907], [-117.70413, 33.64908], [-117.70428, 33.64921], [-117.70443, 33.6496], [-117.70452, 33.64962], [-117.70451, 33.64969], [-117.70483, 33.64974], [-117.70489, 33.64967], [-117.70527, 33.64971], [-117.7056, 33.64934], [-117.70609, 33.64954], [-117.70691, 33.65], [-117.70692, 33.65013]]]} | Open Access 1 | Serrano Creek Park | 25318 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 49.705 | Serrano Creek Park | ||
10078 | 10078 | 10077 | {"type": "Polygon", "coordinates": [[[-117.6668, 33.6425], [-117.66678, 33.64252], [-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 | Sundowner Park | 25990 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 0.8 | Sundowner Park | ||
10219 | 10219 | 10218 | {"type": "Polygon", "coordinates": [[[-117.69055, 33.66025], [-117.68825, 33.66045], [-117.688, 33.65995], [-117.68796, 33.65912], [-117.68839, 33.65898], [-117.68856, 33.6589], [-117.68887, 33.6587], [-117.68906, 33.65854], [-117.68921, 33.65836], [-117.68933, 33.65816], [-117.68938, 33.65806], [-117.68951, 33.65817], [-117.69013, 33.6581], [-117.69054, 33.65827], [-117.69038, 33.65849], [-117.6903, 33.65993], [-117.69055, 33.66025]]]} | Open Access 1 | Tamaris Park | 26177 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 11.182 | Tamaris Park | ||
10897 | 10897 | 10896 | {"type": "Polygon", "coordinates": [[[-117.70889, 33.62595], [-117.70716, 33.62703], [-117.70692, 33.62672], [-117.70676, 33.62655], [-117.70639, 33.62641], [-117.70652, 33.62626], [-117.70639, 33.62614], [-117.70639, 33.62609], [-117.70666, 33.62607], [-117.70664, 33.62538], [-117.70644, 33.62536], [-117.7069, 33.62524], [-117.70721, 33.62505], [-117.70742, 33.62528], [-117.70748, 33.62526], [-117.708, 33.62579], [-117.70847, 33.62552], [-117.70889, 33.62595]]]} | Open Access 1 | Village Pond Park | 27121 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 6.341 | Village Pond Park | ||
10926 | 10926 | 10925 | {"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 | Vintage Park | 27148 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 3.327 | Vintage Park | ||
11760 | 11760 | 11759 | {"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 | Etnies Skatepark | http://www.etniesskatepark.com/ | 28372 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 3.633 | Etnies Skatepark | |
13513 | 13513 | 13512 | {"type": "MultiPolygon", "coordinates": [[[[-117.69075, 33.62392], [-117.68979, 33.62464], [-117.6881, 33.62602], [-117.68796, 33.62602], [-117.68764, 33.62571], [-117.68732, 33.6253], [-117.68703, 33.62485], [-117.68795, 33.62401], [-117.68946, 33.62275], [-117.69075, 33.62392]]], [[[-117.69308, 33.61785], [-117.69279, 33.61798], [-117.69244, 33.61822], [-117.69209, 33.61852], [-117.69108, 33.62006], [-117.69044, 33.62089], [-117.69045, 33.62091], [-117.69115, 33.62121], [-117.69006, 33.62215], [-117.68996, 33.62243], [-117.68983, 33.62274], [-117.68763, 33.62065], [-117.68806, 33.62016], [-117.68832, 33.61992], [-117.68852, 33.6197], [-117.68907, 33.61929], [-117.68969, 33.61891], [-117.69138, 33.61803], [-117.69201, 33.61773], [-117.69254, 33.61741], [-117.69268, 33.61741], [-117.69308, 33.61785]]]]} | Restricted Access 2 | Lake Forest Golf Course | 33099 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 40.437 | Lake Forest GC | ||
14843 | 14843 | 14842 | {"type": "MultiPolygon", "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]]], [[[-117.67345, 33.6375], [-117.67294, 33.63791], [-117.6725, 33.63784], [-117.67209, 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.63778], [-117.67342, 33.63747], [-117.67345, 33.6375]]]]} | Open Access 1 | City of Lake Forest Open Space | 17318 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 4.371 | City of Lake Forest OS |
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]);