superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
98 rows where MNG_AGENCY = 266 sorted by rowid 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14966 | 14966 | 14965 | {"type": "MultiPolygon", "coordinates": [[[[-117.75608, 33.70195], [-117.75607, 33.70204], [-117.75468, 33.70342], [-117.75347, 33.70465], [-117.75188, 33.70622], [-117.75167, 33.70637], [-117.75113, 33.70692], [-117.75101, 33.70701], [-117.7508, 33.70702], [-117.7499, 33.70641], [-117.75001, 33.70633], [-117.75013, 33.70637], [-117.75022, 33.70635], [-117.75026, 33.70632], [-117.75032, 33.70622], [-117.75185, 33.70468], [-117.75191, 33.70459], [-117.75192, 33.70453], [-117.75197, 33.70452], [-117.75243, 33.70406], [-117.75241, 33.70396], [-117.75249, 33.70394], [-117.75254, 33.7039], [-117.75473, 33.70167], [-117.75481, 33.70162], [-117.75496, 33.70158], [-117.75503, 33.70154], [-117.75506, 33.7015], [-117.75505, 33.70142], [-117.75499, 33.70135], [-117.7549, 33.70133], [-117.75491, 33.70121], [-117.75519, 33.70141], [-117.75497, 33.70164], [-117.75498, 33.70168], [-117.7553, 33.70139], [-117.75608, 33.70195]]], [[[-117.76164, 33.69643], [-117.7592, 33.69889], [-117.75922, 33.69892], [-117.75842, 33.69973], [-117.75726, 33.70089], [-117.75642, 33.70171], [-117.75631, 33.70173], [-117.75585, 33.70141], [-117.75733, 33.69994], [-117.7586, 33.69865], [-117.7586, 33.69863], [-117.75873, 33.6985], [-117.75904, 33.6987], [-117.7591, 33.69871], [-117.75914, 33.6987], [-117.7603, 33.69749], [-117.76083, 33.69687], [-117.76085, 33.6968], [-117.76078, 33.69658], [-117.76049, 33.69637], [-117.76096, 33.69587], [-117.76161, 33.69635], [-117.76164, 33.69643]]], [[[-117.76719, 33.6909], [-117.76472, 33.69345], [-117.76204, 33.69616], [-117.76138, 33.69574], [-117.76675, 33.69044], [-117.76719, 33.6909]]]]} | Open Access 1 | Jeffrey Open Space Trail | https://www.cityofirvine.org/cityhall/cs/openspace/jost.asp | 28272 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 44.397 | Jeffrey OS Trail | |
13267 | 13267 | 13266 | {"type": "Polygon", "coordinates": [[[-117.70737, 33.69604], [-117.70643, 33.6954], [-117.70213, 33.69972], [-117.70191, 33.69964], [-117.70162, 33.69931], [-117.70047, 33.6986], [-117.70041, 33.69852], [-117.70055, 33.698], [-117.7004, 33.69788], [-117.70015, 33.69789], [-117.6996, 33.69802], [-117.69959, 33.69807], [-117.69842, 33.69803], [-117.69805, 33.69753], [-117.69777, 33.69751], [-117.69626, 33.69685], [-117.69623, 33.69676], [-117.69613, 33.69671], [-117.69603, 33.69672], [-117.69543, 33.69641], [-117.69458, 33.69585], [-117.69458, 33.6958], [-117.69451, 33.69572], [-117.69442, 33.69574], [-117.69414, 33.69555], [-117.69411, 33.69534], [-117.69409, 33.69528], [-117.69448, 33.69518], [-117.69491, 33.69511], [-117.69535, 33.69505], [-117.69579, 33.69502], [-117.69645, 33.69503], [-117.69805, 33.69516], [-117.69853, 33.69518], [-117.699, 33.69518], [-117.69948, 33.69515], [-117.69995, 33.69509], [-117.70462, 33.69436], [-117.70527, 33.69431], [-117.70591, 33.69431], [-117.70612, 33.69432], [-117.70737, 33.69604]]]} | Open Access 1 | Portola Springs Community Park | 33412 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 85.802 | Portola Springs Community Park | ||
13255 | 13255 | 13254 | {"type": "Polygon", "coordinates": [[[-117.7503, 33.71658], [-117.74985, 33.71697], [-117.74946, 33.71734], [-117.74941, 33.71733], [-117.74938, 33.71735], [-117.74772, 33.71619], [-117.74855, 33.71536], [-117.7503, 33.71658]]]} | Open Access 1 | Eastwood Neighborhood Park | 33410 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 6.129 | Eastwood Neighborhood Park | ||
13253 | 13253 | 13252 | {"type": "Polygon", "coordinates": [[[-117.75861, 33.68706], [-117.75734, 33.68834], [-117.75725, 33.68835], [-117.75724, 33.68826], [-117.75719, 33.68819], [-117.7558, 33.68723], [-117.75572, 33.6872], [-117.7556, 33.6872], [-117.7556, 33.68713], [-117.75688, 33.68585], [-117.75861, 33.68706]]]} | Open Access 1 | Cypress Grove Park | 33409 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 9.423 | Cypress Grove Park | ||
13244 | 13244 | 13243 | {"type": "Polygon", "coordinates": [[[-117.82541, 33.62489], [-117.82527, 33.62514], [-117.82498, 33.62504], [-117.82473, 33.62498], [-117.82493, 33.62461], [-117.8253, 33.62454], [-117.82541, 33.62489]]]} | Open Access 1 | Bommer Vista Point Park | 33408 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 0.661 | Bommer Vista Point Park | ||
13243 | 13243 | 13242 | {"type": "Polygon", "coordinates": [[[-117.71514, 33.7026], [-117.71503, 33.70272], [-117.71348, 33.70165], [-117.71319, 33.70188], [-117.71283, 33.70221], [-117.71279, 33.70214], [-117.71274, 33.70194], [-117.71273, 33.70165], [-117.71268, 33.70136], [-117.71263, 33.70123], [-117.71255, 33.70111], [-117.71244, 33.70099], [-117.71233, 33.70091], [-117.71232, 33.70082], [-117.7124, 33.70073], [-117.71297, 33.70113], [-117.71495, 33.7024], [-117.715, 33.70239], [-117.71508, 33.70244], [-117.71514, 33.7026]]]} | Open Access 1 | Orchard Trail Park | 33407 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.655 | Orchard Trail Park | ||
13188 | 13188 | 13187 | {"type": "Polygon", "coordinates": [[[-117.75315, 33.69734], [-117.75315, 33.69738], [-117.75187, 33.69866], [-117.75178, 33.69867], [-117.75168, 33.69877], [-117.75168, 33.69884], [-117.75097, 33.69955], [-117.75091, 33.69955], [-117.74986, 33.69882], [-117.75087, 33.69781], [-117.75087, 33.69779], [-117.75082, 33.69775], [-117.75203, 33.69654], [-117.75314, 33.69732], [-117.75315, 33.69734]]]} | Open Access 1 | Woodbury Community Park | 33411 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 10.743 | Woodbury Community Park | ||
11704 | 11704 | 11703 | {"type": "Polygon", "coordinates": [[[-117.77984, 33.71541], [-117.7783, 33.71699], [-117.778, 33.7168], [-117.77748, 33.71643], [-117.77739, 33.71635], [-117.77685, 33.71596], [-117.77684, 33.71585], [-117.77761, 33.7151], [-117.77826, 33.71441], [-117.77841, 33.7144], [-117.77924, 33.71497], [-117.7794, 33.715], [-117.7794, 33.7151], [-117.77984, 33.71541]]]} | Open Access 1 | David Sills Lower Peters Canyon Park | http://www.cityofirvine.org/cityhall/cs/commparks/cparks/cparks_peters.asp | 28280 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 10.266 | David Sills Lower Peters Canyon Park | |
11703 | 11703 | 11702 | {"type": "Polygon", "coordinates": [[[-117.80446, 33.67603], [-117.80354, 33.67696], [-117.80273, 33.67773], [-117.80154, 33.67675], [-117.80103, 33.67639], [-117.80036, 33.67589], [-117.79995, 33.67571], [-117.80052, 33.67561], [-117.80077, 33.67525], [-117.80076, 33.67515], [-117.80071, 33.67512], [-117.80104, 33.67471], [-117.80104, 33.6746], [-117.80118, 33.67444], [-117.80106, 33.67401], [-117.80071, 33.67381], [-117.80015, 33.67355], [-117.80031, 33.67336], [-117.80038, 33.67336], [-117.80061, 33.67343], [-117.8012, 33.67369], [-117.80202, 33.67412], [-117.8027, 33.67454], [-117.80327, 33.67495], [-117.8039, 33.67546], [-117.80444, 33.67593], [-117.80446, 33.67603]]]} | Open Access 1 | Mike Ward Community Park - Woodbridge | http://www.cityofirvine.org/cityhall/cs/commparks/cparks/cparks_woodbridge.asp | 28276 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 22.313 | Mike Ward Community Park - Woodbridge | |
11700 | 11700 | 11699 | {"type": "Polygon", "coordinates": [[[-117.76611, 33.69081], [-117.76411, 33.69277], [-117.76228, 33.69163], [-117.76216, 33.69146], [-117.76347, 33.69013], [-117.76434, 33.69078], [-117.76503, 33.69011], [-117.76611, 33.69081]]]} | Open Access 1 | Cypress Community Park | http://www.cityofirvine.org/cityhall/cs/commparks/cparks/cypress_community_park.asp | 28273 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 14.145 | Cypress Community Park | |
11696 | 11696 | 11695 | {"type": "Polygon", "coordinates": [[[-117.74192, 33.7062], [-117.74122, 33.70692], [-117.74093, 33.70719], [-117.74067, 33.70702], [-117.74058, 33.70702], [-117.74049, 33.70706], [-117.74046, 33.70705], [-117.73924, 33.7062], [-117.73914, 33.70618], [-117.73906, 33.70623], [-117.739, 33.70619], [-117.73902, 33.70615], [-117.7402, 33.70496], [-117.74023, 33.70497], [-117.74028, 33.70492], [-117.74123, 33.70558], [-117.74119, 33.70562], [-117.74119, 33.70563], [-117.7414, 33.70581], [-117.74192, 33.70617], [-117.74192, 33.7062]]]} | Open Access 1 | Stonegate Park | http://www.cityofirvine.org/cityhall/cs/commparks/nparks/default.asp | 28267 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 8.583 | Stonegate Park | |
11325 | 11325 | 11324 | {"type": "Polygon", "coordinates": [[[-117.78912, 33.67333], [-117.78882, 33.67355], [-117.78848, 33.67386], [-117.78822, 33.67413], [-117.78755, 33.67489], [-117.78743, 33.67491], [-117.78515, 33.67355], [-117.78515, 33.67348], [-117.78513, 33.67345], [-117.7861, 33.67249], [-117.78704, 33.67253], [-117.78744, 33.67264], [-117.78819, 33.67285], [-117.78912, 33.67333]]]} | Open Access 1 | Windrow Community Park | 27632 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 13.862 | Windrow Community Park | ||
11292 | 11292 | 11291 | {"type": "Polygon", "coordinates": [[[-117.78468, 33.69615], [-117.78458, 33.69625], [-117.78392, 33.6958], [-117.78367, 33.69604], [-117.78377, 33.69614], [-117.78375, 33.69616], [-117.78361, 33.69611], [-117.78338, 33.69634], [-117.78339, 33.69637], [-117.78313, 33.69662], [-117.78299, 33.6966], [-117.78294, 33.69647], [-117.7828, 33.6963], [-117.78299, 33.6961], [-117.78292, 33.69602], [-117.78318, 33.69576], [-117.7832, 33.69571], [-117.78344, 33.69546], [-117.78334, 33.69537], [-117.78217, 33.69454], [-117.78198, 33.69449], [-117.78203, 33.69437], [-117.78209, 33.6943], [-117.78234, 33.69449], [-117.78233, 33.69452], [-117.78397, 33.69566], [-117.78408, 33.6956], [-117.7841, 33.69562], [-117.78403, 33.69573], [-117.78457, 33.6961], [-117.78463, 33.69609], [-117.78468, 33.69615]]]} | Open Access 1 | Willows Park | 27594 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.609 | Willows Park | ||
10675 | 10675 | 10674 | {"type": "MultiPolygon", "coordinates": [[[[-117.76027, 33.70922], [-117.76023, 33.70926], [-117.76014, 33.70941], [-117.75687, 33.70715], [-117.75487, 33.70571], [-117.75375, 33.70493], [-117.75391, 33.70478], [-117.75668, 33.7067], [-117.76027, 33.70922]]], [[[-117.76357, 33.71154], [-117.76342, 33.71169], [-117.76036, 33.70957], [-117.76049, 33.7094], [-117.76357, 33.71154]]], [[[-117.76853, 33.71508], [-117.7684, 33.71517], [-117.7669, 33.71412], [-117.76624, 33.71369], [-117.76368, 33.71188], [-117.76381, 33.71176], [-117.76853, 33.71508]]], [[[-117.77278, 33.71794], [-117.7726, 33.71811], [-117.77193, 33.71765], [-117.76914, 33.71567], [-117.76862, 33.71535], [-117.76879, 33.71522], [-117.77086, 33.71666], [-117.77208, 33.71748], [-117.7721, 33.71747], [-117.77278, 33.71794]]]]} | Open Access 1 | Venta Spur Trail | 26848 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 11.543 | Venta Spur Trail | ||
10615 | 10615 | 10614 | {"type": "Polygon", "coordinates": [[[-117.7763, 33.66668], [-117.77569, 33.66727], [-117.77493, 33.66675], [-117.77477, 33.6666], [-117.77473, 33.66662], [-117.77464, 33.66656], [-117.7746, 33.66658], [-117.77459, 33.66657], [-117.77521, 33.66592], [-117.7763, 33.66668]]]} | Open Access 1 | Valley Oak Park | 26791 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.81 | Valley Oak Park | ||
10605 | 10605 | 10604 | {"type": "Polygon", "coordinates": [[[-117.77833, 33.73648], [-117.77833, 33.73656], [-117.77818, 33.73668], [-117.7779, 33.73699], [-117.7776, 33.73678], [-117.7773, 33.73706], [-117.77732, 33.7372], [-117.77749, 33.73738], [-117.77721, 33.73766], [-117.77602, 33.73683], [-117.77702, 33.73586], [-117.77701, 33.73582], [-117.77703, 33.73578], [-117.77701, 33.73576], [-117.77715, 33.73562], [-117.77719, 33.73564], [-117.77737, 33.73547], [-117.77759, 33.73572], [-117.77777, 33.73598], [-117.77795, 33.73619], [-117.77833, 33.73648]]]} | Open Access 1 | Valencia Park | 26765 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 5.856 | Valencia Park | ||
10564 | 10564 | 10563 | {"type": "Polygon", "coordinates": [[[-117.82166, 33.65937], [-117.82142, 33.65971], [-117.82114, 33.66015], [-117.82094, 33.66052], [-117.82016, 33.66035], [-117.8199, 33.6608], [-117.81962, 33.66162], [-117.81919, 33.66163], [-117.81885, 33.66175], [-117.8187, 33.66221], [-117.81898, 33.66227], [-117.81887, 33.66268], [-117.81897, 33.66287], [-117.81931, 33.66306], [-117.81842, 33.66311], [-117.81806, 33.66311], [-117.81754, 33.6631], [-117.81747, 33.66307], [-117.81745, 33.663], [-117.81755, 33.66246], [-117.81758, 33.66159], [-117.81757, 33.66132], [-117.81747, 33.66101], [-117.81739, 33.66084], [-117.81739, 33.66079], [-117.81741, 33.66076], [-117.81771, 33.66053], [-117.81786, 33.66037], [-117.81794, 33.66025], [-117.81804, 33.65999], [-117.81813, 33.65965], [-117.82004, 33.65963], [-117.82007, 33.65938], [-117.82166, 33.65937]]]} | Open Access 1 | University Community Park | 26678 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 19.637 | University Community Park | ||
10510 | 10510 | 10509 | {"type": "Polygon", "coordinates": [[[-117.80767, 33.63297], [-117.80396, 33.6349], [-117.80358, 33.63422], [-117.80308, 33.63275], [-117.80412, 33.63248], [-117.80499, 33.63217], [-117.80531, 33.63203], [-117.80683, 33.63122], [-117.80767, 33.63297]]]} | Open Access 1 | Turtle Rock Community Park | 26593 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 21.467 | Turtle Rock Community Park | ||
10183 | 10183 | 10182 | {"type": "Polygon", "coordinates": [[[-117.76768, 33.70259], [-117.7671, 33.70293], [-117.76688, 33.70316], [-117.76682, 33.70343], [-117.76653, 33.70353], [-117.76634, 33.7037], [-117.76633, 33.70385], [-117.76636, 33.704], [-117.76646, 33.70411], [-117.76663, 33.70424], [-117.76638, 33.70419], [-117.76624, 33.70418], [-117.76602, 33.70419], [-117.7657, 33.70423], [-117.76538, 33.70434], [-117.76519, 33.70443], [-117.76502, 33.70455], [-117.76534, 33.70415], [-117.76561, 33.70363], [-117.76534, 33.70351], [-117.76541, 33.70338], [-117.76568, 33.70346], [-117.76587, 33.70308], [-117.76592, 33.70249], [-117.76603, 33.70223], [-117.76621, 33.70202], [-117.76652, 33.7022], [-117.76673, 33.70199], [-117.76685, 33.70205], [-117.7673, 33.7022], [-117.7675, 33.70235], [-117.76768, 33.70259]]]} | Open Access 1 | Sycamore Park | 26135 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 6.619 | Sycamore Park | ||
10165 | 10165 | 10164 | {"type": "Polygon", "coordinates": [[[-117.81919, 33.69143], [-117.81815, 33.69225], [-117.81662, 33.69096], [-117.81635, 33.69067], [-117.81731, 33.68984], [-117.81919, 33.69143]]]} | Open Access 1 | Sweet Shade Park | 26103 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 8.022 | Sweet Shade 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]);