superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where ACCESS_TYP = 1, LAYER = 2, MNG_AGENCY = 356 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1084 | 1084 | 1083 | {"type": "MultiPolygon", "coordinates": [[[[-117.10094, 33.54351], [-117.10092, 33.54417], [-117.10087, 33.54452], [-117.10078, 33.54487], [-117.10066, 33.54521], [-117.1005, 33.54554], [-117.10031, 33.54585], [-117.1001, 33.54616], [-117.1, 33.54617], [-117.09914, 33.54571], [-117.0987, 33.54552], [-117.09824, 33.54537], [-117.09776, 33.54525], [-117.09728, 33.54517], [-117.0976, 33.543], [-117.09919, 33.54308], [-117.0995, 33.54315], [-117.10023, 33.54346], [-117.10051, 33.54351], [-117.10094, 33.54351]]], [[[-117.10296, 33.5503], [-117.10246, 33.55222], [-117.10125, 33.55193], [-117.1012, 33.55185], [-117.10134, 33.55129], [-117.10135, 33.55116], [-117.10134, 33.5509], [-117.10126, 33.55063], [-117.10113, 33.55039], [-117.10105, 33.55027], [-117.10296, 33.5503]]]]} | Open Access 1 | Skyview Park | 32843 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 27.721 | Skyview 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 | ||
1730 | 1730 | 1729 | {"type": "Polygon", "coordinates": [[[-117.07266, 33.49507], [-117.07261, 33.49514], [-117.0725, 33.49519], [-117.07242, 33.49519], [-117.07234, 33.49515], [-117.07199, 33.49485], [-117.07171, 33.49426], [-117.07232, 33.49361], [-117.07254, 33.49376], [-117.07268, 33.49391], [-117.0728, 33.49405], [-117.07282, 33.49416], [-117.07281, 33.49428], [-117.0727, 33.49468], [-117.07266, 33.49507]]]} | Open Access 1 | Butterfield Stage Park | 16610 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 2.798 | Butterfield Stage 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 | ||
3359 | 3359 | 3358 | {"type": "Polygon", "coordinates": [[[-117.07528, 33.4991], [-117.07508, 33.49922], [-117.07485, 33.49926], [-117.07477, 33.49928], [-117.07472, 33.49934], [-117.07471, 33.49943], [-117.07465, 33.49937], [-117.07456, 33.49911], [-117.07455, 33.49897], [-117.07444, 33.49882], [-117.07437, 33.49867], [-117.07419, 33.49838], [-117.0741, 33.49817], [-117.07404, 33.49763], [-117.07405, 33.49747], [-117.07413, 33.49735], [-117.07447, 33.49703], [-117.07482, 33.49778], [-117.07483, 33.4979], [-117.07478, 33.49807], [-117.07479, 33.49817], [-117.07528, 33.4991]]]} | Open Access 1 | Crown Hill Park | 17836 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 3.554 | Crown Hill Park | ||
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 | ||
5568 | 5568 | 5567 | {"type": "Polygon", "coordinates": [[[-117.11049, 33.47644], [-117.11016, 33.47649], [-117.10983, 33.47658], [-117.10978, 33.47649], [-117.10973, 33.47622], [-117.10966, 33.47605], [-117.11027, 33.47583], [-117.11049, 33.47644]]]} | Open Access 1 | John Magee Park | 20454 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1.004 | John Magee Park | ||
5715 | 5715 | 5714 | {"type": "Polygon", "coordinates": [[[-117.10801, 33.46849], [-117.10772, 33.46877], [-117.10777, 33.46892], [-117.10753, 33.4688], [-117.10734, 33.46872], [-117.10704, 33.46862], [-117.10696, 33.46861], [-117.10693, 33.46872], [-117.10732, 33.46885], [-117.10764, 33.469], [-117.10757, 33.46905], [-117.10746, 33.46925], [-117.10715, 33.46966], [-117.10693, 33.46989], [-117.1067, 33.4697], [-117.1064, 33.46989], [-117.10623, 33.46997], [-117.10552, 33.47017], [-117.10529, 33.47014], [-117.10436, 33.46922], [-117.10495, 33.46856], [-117.10552, 33.46853], [-117.1059, 33.46854], [-117.10626, 33.46858], [-117.10661, 33.46864], [-117.10662, 33.46862], [-117.10627, 33.46816], [-117.10631, 33.4681], [-117.10696, 33.46824], [-117.1073, 33.46834], [-117.10762, 33.46841], [-117.1078, 33.46848], [-117.10801, 33.46849]]]} | Open Access 1 | Kent Hintergardt Park | 20618 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 10.608 | Kent Hintergardt Park | ||
6327 | 6327 | 6326 | {"type": "MultiPolygon", "coordinates": [[[[-117.11599, 33.46106], [-117.11574, 33.46129], [-117.11556, 33.46115], [-117.11541, 33.46097], [-117.11535, 33.46094], [-117.11528, 33.46094], [-117.11525, 33.46092], [-117.11581, 33.4604], [-117.11594, 33.4605], [-117.1159, 33.46055], [-117.1159, 33.46061], [-117.11593, 33.46067], [-117.11597, 33.46071], [-117.11578, 33.4609], [-117.11599, 33.46106]]], [[[-117.11583, 33.46164], [-117.11582, 33.4617], [-117.11559, 33.46182], [-117.1155, 33.46171], [-117.11575, 33.46154], [-117.11583, 33.46164]]], [[[-117.1169, 33.46281], [-117.11663, 33.46291], [-117.1164, 33.46307], [-117.11633, 33.46307], [-117.11625, 33.46301], [-117.11649, 33.46272], [-117.11645, 33.46267], [-117.11623, 33.46263], [-117.11609, 33.46256], [-117.1159, 33.46244], [-117.1157, 33.46211], [-117.11561, 33.46201], [-117.11591, 33.46184], [-117.11597, 33.46186], [-117.11624, 33.4623], [-117.1163, 33.46233], [-117.11636, 33.46234], [-117.11647, 33.4623], [-117.11673, 33.46255], [-117.11681, 33.46253], [-117.1169, 33.46281]]], [[[-117.1174, 33.46295], [-117.11732, 33.46333], [-117.11706, 33.46324], [-117.11694, 33.46328], [-117.11684, 33.46334], [-117.11662, 33.46312], [-117.11679, 33.46302], [-117.11699, 33.46296], [-117.1172, 33.46294], [-117.1174, 33.46295]]]]} | Open Access 1 | Loma Linda Park | 21404 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 2.831 | Loma Linda 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 | ||
6688 | 6688 | 6687 | {"type": "Polygon", "coordinates": [[[-117.10272, 33.48405], [-117.10188, 33.48425], [-117.10114, 33.4824], [-117.10199, 33.48216], [-117.10272, 33.48405]]]} | Open Access 1 | Paloma Del Sol | 23362 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 4.481 | Paloma Del Sol | ||
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 | ||
7834 | 7834 | 7833 | {"type": "Polygon", "coordinates": [[[-117.08454, 33.47208], [-117.0844, 33.47245], [-117.0842, 33.47242], [-117.08399, 33.47242], [-117.08296, 33.47253], [-117.08286, 33.47192], [-117.0832, 33.47194], [-117.08362, 33.47192], [-117.084, 33.47187], [-117.08447, 33.47176], [-117.08454, 33.47208]]]} | Open Access 1 | Pablo Apis Park | 23288 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 2.31 | Pablo Apis 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 | ||
8000 | 8000 | 7999 | {"type": "Polygon", "coordinates": [[[-117.09041, 33.45956], [-117.08996, 33.45999], [-117.08989, 33.46], [-117.08897, 33.45931], [-117.08964, 33.45898], [-117.09041, 33.45956]]]} | Open Access 1 | Paseo Gallante Park | 23497 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1.821 | Paseo Gallante Park | ||
8006 | 8006 | 8005 | {"type": "Polygon", "coordinates": [[[-117.09832, 33.45288], [-117.09729, 33.45379], [-117.09709, 33.45401], [-117.09692, 33.45424], [-117.09675, 33.45454], [-117.09662, 33.45489], [-117.09655, 33.45521], [-117.09653, 33.45553], [-117.09333, 33.45554], [-117.09182, 33.4544], [-117.09582, 33.45067], [-117.09649, 33.45127], [-117.09803, 33.4527], [-117.09814, 33.45279], [-117.09832, 33.45288]]]} | Open Access 1 | Patricia H. Birdsall Sports Park | 23508 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 44.043 | Patricia H. Birdsall Sports Park | ||
8027 | 8027 | 8026 | {"type": "Polygon", "coordinates": [[[-117.08147, 33.51191], [-117.08005, 33.5122], [-117.07996, 33.51216], [-117.07978, 33.51167], [-117.07967, 33.51143], [-117.07953, 33.51121], [-117.08118, 33.5104], [-117.08111, 33.51081], [-117.08147, 33.51191]]]} | Open Access 1 | Pauba Ridge Park | 23528 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 5.175 | Pauba Ridge 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 | ||
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 |
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]);