superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where MNG_AGENCY = 356 sorted by map descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4950 | 4950 | 4949 | {"type": "Polygon", "coordinates": [[[-117.16228, 33.53348], [-117.16196, 33.53361], [-117.16192, 33.53368], [-117.16186, 33.53367], [-117.16178, 33.53369], [-117.16159, 33.5339], [-117.16119, 33.53413], [-117.16087, 33.53437], [-117.16082, 33.53437], [-117.16047, 33.5341], [-117.1602, 33.53392], [-117.15983, 33.53373], [-117.15956, 33.53364], [-117.15923, 33.53355], [-117.15881, 33.53349], [-117.15846, 33.53347], [-117.1581, 33.53348], [-117.15805, 33.53342], [-117.158, 33.53309], [-117.15794, 33.53289], [-117.15786, 33.53272], [-117.1577, 33.53248], [-117.15764, 33.53236], [-117.1576, 33.53218], [-117.15761, 33.53199], [-117.15771, 33.53184], [-117.15772, 33.53173], [-117.15782, 33.53171], [-117.15803, 33.53138], [-117.15884, 33.53175], [-117.15922, 33.53187], [-117.15974, 33.53197], [-117.1604, 33.53201], [-117.16064, 33.53206], [-117.16088, 33.53213], [-117.16125, 33.53228], [-117.16128, 33.53238], [-117.16155, 33.5325], [-117.1616, 33.53245], [-117.16184, 33.53253], [-117.16207, 33.53258], [-117.16212, 33.53263], [-117.16213, 33.53284], [-117.16217, 33.53307], [-117.16228, 33.53348]]]} | Open Access 1 | Harveston Community Park | 19726 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 19.65 | Harveston Community Park | ||
4951 | 4951 | 4950 | {"type": "Polygon", "coordinates": [[[-117.15937, 33.53929], [-117.15932, 33.53932], [-117.1593, 33.53935], [-117.15819, 33.53992], [-117.15795, 33.53946], [-117.15772, 33.53921], [-117.15759, 33.53887], [-117.15708, 33.53847], [-117.15689, 33.53833], [-117.15648, 33.53811], [-117.15602, 33.53795], [-117.15587, 33.5379], [-117.1558, 33.5379], [-117.15572, 33.53793], [-117.15564, 33.538], [-117.15526, 33.53789], [-117.15524, 33.5379], [-117.15454, 33.53771], [-117.15448, 33.53764], [-117.15436, 33.5376], [-117.1543, 33.53752], [-117.1542, 33.53748], [-117.15423, 33.53727], [-117.1543, 33.53704], [-117.15446, 33.53677], [-117.15463, 33.53658], [-117.1547, 33.53663], [-117.15474, 33.53672], [-117.15484, 33.53674], [-117.15487, 33.53677], [-117.15489, 33.53685], [-117.15551, 33.53701], [-117.15566, 33.53702], [-117.15589, 33.537], [-117.15603, 33.53702], [-117.15646, 33.53717], [-117.15658, 33.53694], [-117.15667, 33.53699], [-117.15723, 33.53718], [-117.15745, 33.53717], [-117.15766, 33.53705], [-117.15795, 33.53675], [-117.15823, 33.53691], [-117.15816, 33.53716], [-117.15813, 33.53743], [-117.15817, 33.53769], [-117.15825, 33.53792], [-117.15831, 33.53804], [-117.15898, 33.53897], [-117.15905, 33.53899], [-117.15913, 33.539], [-117.15931, 33.53925], [-117.15934, 33.53925], [-117.15937, 33.53929]]]} | Open Access 1 | Harveston Lake Park | 19727 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 15.938 | Harveston Lake Park | ||
11311 | 11311 | 11310 | {"type": "Polygon", "coordinates": [[[-117.15257, 33.54356], [-117.15135, 33.5445], [-117.15049, 33.54371], [-117.1517, 33.54277], [-117.15257, 33.54356]]]} | Open Access 1 | Winchester Creek Park | 27617 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 4.497 | Winchester Creek Park | ||
9141 | 9141 | 9140 | {"type": "Polygon", "coordinates": [[[-117.15188, 33.49686], [-117.15163, 33.49762], [-117.15158, 33.49761], [-117.15143, 33.49804], [-117.15136, 33.49802], [-117.15092, 33.49756], [-117.15013, 33.49809], [-117.15002, 33.49794], [-117.15099, 33.4971], [-117.15102, 33.49711], [-117.15112, 33.49702], [-117.15094, 33.49684], [-117.15137, 33.49681], [-117.15138, 33.49683], [-117.15166, 33.49683], [-117.15188, 33.49686]]]} | Open Access 1 | Sam Hicks Monument Park | 24817 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 2.62 | Sam Hicks Monument Park | ||
10257 | 10257 | 10256 | {"type": "Polygon", "coordinates": [[[-117.14821, 33.50276], [-117.1482, 33.50286], [-117.14645, 33.50406], [-117.14639, 33.5039], [-117.14645, 33.50371], [-117.14658, 33.50354], [-117.14665, 33.50357], [-117.14669, 33.50356], [-117.14671, 33.50353], [-117.1467, 33.50348], [-117.14663, 33.50345], [-117.1466, 33.50337], [-117.14668, 33.50331], [-117.14669, 33.50323], [-117.14663, 33.50308], [-117.14666, 33.50306], [-117.14666, 33.50301], [-117.14661, 33.50298], [-117.14655, 33.503], [-117.1465, 33.50298], [-117.14649, 33.50276], [-117.14637, 33.50277], [-117.14634, 33.50282], [-117.14614, 33.50278], [-117.14611, 33.50265], [-117.14601, 33.50244], [-117.14596, 33.50238], [-117.14587, 33.50233], [-117.14551, 33.50191], [-117.14595, 33.50177], [-117.14605, 33.50172], [-117.14614, 33.50166], [-117.1464, 33.50141], [-117.14799, 33.50258], [-117.14821, 33.50276]]]} | Open Access 1 | Temecula Duck Pond | 26227 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 7.505 | Temecula Duck Pond | ||
13460 | 13460 | 13459 | {"type": "Polygon", "coordinates": [[[-117.14814, 33.49415], [-117.14811, 33.4942], [-117.14791, 33.49437], [-117.14766, 33.49416], [-117.14786, 33.49399], [-117.14794, 33.49397], [-117.14803, 33.49397], [-117.14808, 33.494], [-117.14813, 33.49406], [-117.14814, 33.49415]]]} | Open Access 1 | Town Square | 30871 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 0.288 | Town Square | ||
9024 | 9024 | 9023 | {"type": "Polygon", "coordinates": [[[-117.14777, 33.48896], [-117.14754, 33.48901], [-117.1464, 33.48571], [-117.14663, 33.48566], [-117.14777, 33.48896]]]} | Open Access 1 | Rotary Park | 24698 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 2.062 | Rotary Park | ||
6628 | 6628 | 6627 | {"type": "Polygon", "coordinates": [[[-117.14724, 33.50857], [-117.14673, 33.50922], [-117.14464, 33.51176], [-117.14419, 33.51166], [-117.14335, 33.51155], [-117.14327, 33.5087], [-117.14724, 33.50857]]]} | Open Access 1 | Margarita Community Park | 21804 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 20.37 | Margarita Community Park | ||
13346 | 13346 | 13345 | {"type": "Polygon", "coordinates": [[[-117.14566, 33.52561], [-117.14522, 33.52578], [-117.14436, 33.52614], [-117.14366, 33.52501], [-117.14504, 33.52448], [-117.14566, 33.52561]]]} | Open Access 1 | Long Canyon Creek Park | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/LongCanyonCreekPark.htm | 30851 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 4.714 | Long Canyon Creek Park | |
7373 | 7373 | 7372 | {"type": "Polygon", "coordinates": [[[-117.13628, 33.53783], [-117.1363, 33.53802], [-117.13629, 33.53814], [-117.13615, 33.53855], [-117.13606, 33.53872], [-117.13577, 33.53862], [-117.13556, 33.53846], [-117.13547, 33.53844], [-117.13542, 33.53845], [-117.13535, 33.53849], [-117.13532, 33.53853], [-117.13532, 33.53858], [-117.13521, 33.53864], [-117.13517, 33.53864], [-117.1351, 33.53885], [-117.13473, 33.53879], [-117.13436, 33.53867], [-117.13439, 33.5383], [-117.13445, 33.53824], [-117.13628, 33.53783]]]} | Open Access 1 | Nicholas Road Park | 22746 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 2.913 | Nicholas Road Park | ||
10840 | 10840 | 10839 | {"type": "Polygon", "coordinates": [[[-117.13417, 33.5384], [-117.13414, 33.53866], [-117.13392, 33.5387], [-117.13353, 33.53869], [-117.13336, 33.53866], [-117.1325, 33.5387], [-117.13407, 33.53834], [-117.13417, 33.5384]]]} | Open Access 1 | Voorburg Park | 27197 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 0.728 | Voorburg Park | ||
8926 | 8926 | 8925 | {"type": "Polygon", "coordinates": [[[-117.12532, 33.49784], [-117.1252, 33.49987], [-117.1246, 33.49986], [-117.12394, 33.49991], [-117.12358, 33.49997], [-117.12323, 33.50005], [-117.12271, 33.50021], [-117.12219, 33.50042], [-117.12175, 33.50065], [-117.12135, 33.5009], [-117.12068, 33.50139], [-117.1206, 33.50131], [-117.12045, 33.50134], [-117.12044, 33.50141], [-117.12054, 33.50149], [-117.12035, 33.50163], [-117.11966, 33.50101], [-117.11988, 33.50085], [-117.11986, 33.50076], [-117.11974, 33.50064], [-117.11947, 33.50083], [-117.11675, 33.49838], [-117.11641, 33.49809], [-117.1162, 33.49795], [-117.11677, 33.49763], [-117.11708, 33.4975], [-117.1174, 33.49739], [-117.11773, 33.4973], [-117.11807, 33.49724], [-117.11841, 33.49721], [-117.12046, 33.4971], [-117.12032, 33.49805], [-117.12014, 33.49817], [-117.12002, 33.4985], [-117.11986, 33.49908], [-117.12005, 33.4992], [-117.12076, 33.49932], [-117.12135, 33.49928], [-117.12141, 33.4986], [-117.12104, 33.49844], [-117.12172, 33.49814], [-117.1221, 33.49799], [-117.12241, 33.4979], [-117.12281, 33.49781], [-117.12314, 33.49776], [-117.12364, 33.49772], [-117.12426, 33.49773], [-117.12532, 33.49784]]]} | Open Access 1 | Ronald Reagan Sports Park | 24591 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 52.457 | Ronald Reagan Sports Park | ||
13448 | 13448 | 13447 | {"type": "Polygon", "coordinates": [[[-117.12483, 33.54045], [-117.12482, 33.5405], [-117.12439, 33.5407], [-117.1243, 33.54083], [-117.1236, 33.54113], [-117.12349, 33.54113], [-117.12349, 33.5408], [-117.12355, 33.54074], [-117.12483, 33.54045]]]} | Open Access 1 | Nakayama Park | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/NakayamaPark.htm | 30841 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 0.85 | Nakayama Park | |
10835 | 10835 | 10834 | {"type": "Polygon", "coordinates": [[[-117.12176, 33.51628], [-117.12161, 33.51668], [-117.12156, 33.51689], [-117.12153, 33.5171], [-117.12152, 33.51731], [-117.12153, 33.51752], [-117.12166, 33.51861], [-117.12166, 33.51883], [-117.1216, 33.51921], [-117.12154, 33.51939], [-117.12138, 33.51971], [-117.12105, 33.52013], [-117.12081, 33.52035], [-117.12045, 33.52058], [-117.12027, 33.51798], [-117.12028, 33.51762], [-117.12038, 33.51558], [-117.12172, 33.51621], [-117.12176, 33.51628]]]} | Open Access 1 | Veterans Park | 27053 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 13.721 | Veterans Park | ||
13452 | 13452 | 13451 | {"type": "Polygon", "coordinates": [[[-117.12141, 33.49859], [-117.12135, 33.49929], [-117.12075, 33.49932], [-117.12005, 33.4992], [-117.11986, 33.49909], [-117.12002, 33.4985], [-117.12015, 33.49817], [-117.12032, 33.49805], [-117.12097, 33.49847], [-117.12104, 33.49844], [-117.12141, 33.49859]]]} | Open Access 1 | Temecula Skate Park | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/SkatePark.htm | 30864 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 3.466 | Temecula Skate Park | |
7860 | 7860 | 7859 | {"type": "Polygon", "coordinates": [[[-117.11883, 33.47183], [-117.11881, 33.47215], [-117.11855, 33.47215], [-117.11859, 33.47236], [-117.11831, 33.47245], [-117.11803, 33.47263], [-117.11786, 33.47257], [-117.11659, 33.47255], [-117.11712, 33.4707], [-117.11736, 33.47089], [-117.11786, 33.4712], [-117.11811, 33.47138], [-117.11835, 33.47165], [-117.11848, 33.47191], [-117.11877, 33.47183], [-117.11883, 33.47183]]]} | Open Access 1 | Pala Community Park | 23324 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 6.208 | Pala Community Park | ||
2540 | 2540 | 2539 | {"type": "Polygon", "coordinates": [[[-117.1166, 33.50629], [-117.11631, 33.50635], [-117.11602, 33.50645], [-117.11596, 33.50643], [-117.11587, 33.50631], [-117.11612, 33.50616], [-117.11647, 33.50585], [-117.1166, 33.50629]]]} | Open Access 1 | Calle Aragon Park | 16734 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 0.518 | Calle Aragon Park | ||
1720 | 1720 | 1719 | {"type": "Polygon", "coordinates": [[[-117.11583, 33.50748], [-117.11567, 33.50773], [-117.11554, 33.50786], [-117.11541, 33.50795], [-117.11516, 33.50761], [-117.11542, 33.50749], [-117.11557, 33.50746], [-117.11583, 33.50748]]]} | Open Access 1 | Bahia Vista Park | 15757 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 0.448 | Bahia Vista Park | ||
10258 | 10258 | 10257 | {"type": "Polygon", "coordinates": [[[-117.11426, 33.52396], [-117.11345, 33.52488], [-117.11317, 33.52517], [-117.11287, 33.52545], [-117.11255, 33.5257], [-117.11242, 33.52579], [-117.1123, 33.52579], [-117.11191, 33.5253], [-117.11159, 33.52479], [-117.11148, 33.52458], [-117.11115, 33.52369], [-117.11119, 33.5236], [-117.11147, 33.5235], [-117.11158, 33.52342], [-117.11167, 33.52332], [-117.11174, 33.5233], [-117.11215, 33.52338], [-117.11289, 33.52342], [-117.11307, 33.52345], [-117.1132, 33.5235], [-117.11346, 33.52362], [-117.11374, 33.52384], [-117.11387, 33.52385], [-117.11394, 33.52383], [-117.11399, 33.52379], [-117.11426, 33.52396]]]} | Open Access 1 | Temeku Hills Park | 26228 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 11.412 | Temeku Hills Park | ||
8798 | 8798 | 8797 | {"type": "Polygon", "coordinates": [[[-117.11174, 33.54046], [-117.11064, 33.54088], [-117.11044, 33.54051], [-117.11037, 33.5403], [-117.11029, 33.54023], [-117.11017, 33.5402], [-117.10995, 33.54022], [-117.10945, 33.54022], [-117.1094, 33.54018], [-117.10941, 33.54007], [-117.10945, 33.53995], [-117.1102, 33.53848], [-117.1105, 33.53856], [-117.11048, 33.53876], [-117.1105, 33.53919], [-117.11049, 33.53968], [-117.11064, 33.53993], [-117.11174, 33.54046]]]} | Open Access 1 | Riverton Park | 24461 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 4.98 | Riverton Park |
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]);