superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
98 rows where MNG_AGENCY = 266 and MNG_AG_TYP = 2 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4255 | 4255 | 4254 | {"type": "Polygon", "coordinates": [[[-117.79707, 33.70016], [-117.79689, 33.70036], [-117.79686, 33.70044], [-117.79687, 33.70049], [-117.79677, 33.70052], [-117.7967, 33.70048], [-117.79666, 33.70047], [-117.79649, 33.70063], [-117.79647, 33.70062], [-117.79639, 33.70077], [-117.79622, 33.70094], [-117.79604, 33.70079], [-117.7955, 33.70028], [-117.79537, 33.70008], [-117.79535, 33.69985], [-117.79538, 33.69985], [-117.79556, 33.69966], [-117.79612, 33.70005], [-117.7964, 33.70021], [-117.79662, 33.70038], [-117.79669, 33.70036], [-117.79698, 33.70006], [-117.79706, 33.70012], [-117.79707, 33.70016]]]} | Open Access 1 | Flagstone Park | 18936 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.212 | Flagstone 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 | ||
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 | ||
5367 | 5367 | 5366 | {"type": "Polygon", "coordinates": [[[-117.7653, 33.65872], [-117.76509, 33.6588], [-117.76437, 33.65776], [-117.76351, 33.65795], [-117.76318, 33.65841], [-117.76248, 33.65813], [-117.76217, 33.65813], [-117.76223, 33.65785], [-117.76297, 33.65781], [-117.76335, 33.65777], [-117.76452, 33.65754], [-117.7653, 33.65872]]]} | Open Access 1 | Irvine holding 33 | 20264 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.665 | Irvine holding 33 | ||
2073 | 2073 | 2072 | {"type": "Polygon", "coordinates": [[[-117.76214, 33.70303], [-117.76191, 33.70324], [-117.76187, 33.7033], [-117.76186, 33.70337], [-117.76172, 33.70337], [-117.76123, 33.70387], [-117.76122, 33.70391], [-117.76115, 33.70398], [-117.76079, 33.70376], [-117.76079, 33.70373], [-117.76049, 33.70352], [-117.76146, 33.70258], [-117.76214, 33.70303]]]} | Open Access 1 | Blue Gum Park | 16176 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.69 | Blue Gum Park | ||
3180 | 3180 | 3179 | {"type": "Polygon", "coordinates": [[[-117.77156, 33.70403], [-117.77163, 33.70412], [-117.77165, 33.7042], [-117.77163, 33.70443], [-117.77151, 33.70528], [-117.77148, 33.70543], [-117.7714, 33.70567], [-117.77112, 33.7056], [-117.77078, 33.70554], [-117.77069, 33.70546], [-117.77061, 33.70546], [-117.77055, 33.70549], [-117.77034, 33.70526], [-117.77156, 33.70403]]]} | Open Access 1 | Coralwood Park | 17633 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.798 | Coralwood Park | ||
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 | ||
8403 | 8403 | 8402 | {"type": "Polygon", "coordinates": [[[-117.7808, 33.69515], [-117.78058, 33.69552], [-117.78043, 33.69574], [-117.78018, 33.69602], [-117.77968, 33.69653], [-117.77962, 33.69653], [-117.77956, 33.6965], [-117.77908, 33.69618], [-117.78028, 33.69497], [-117.7808, 33.69515]]]} | Open Access 1 | Presley Park | 23995 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.887 | Presley Park | ||
5366 | 5366 | 5365 | {"type": "Polygon", "coordinates": [[[-117.8353, 33.67402], [-117.83521, 33.67442], [-117.83503, 33.6743], [-117.83174, 33.6732], [-117.83183, 33.67292], [-117.8353, 33.67402]]]} | Open Access 1 | Irvine holding 32 | 20263 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3.023 | Irvine holding 32 | ||
2665 | 2665 | 2664 | {"type": "Polygon", "coordinates": [[[-117.76119, 33.70774], [-117.76076, 33.70816], [-117.76051, 33.70835], [-117.76025, 33.70818], [-117.76017, 33.70825], [-117.75947, 33.70777], [-117.7597, 33.70754], [-117.75967, 33.7074], [-117.75973, 33.70737], [-117.75987, 33.70726], [-117.76013, 33.70701], [-117.76119, 33.70774]]]} | Open Access 1 | Carrotwood Park | 16920 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3.092 | Carrotwood Park | ||
8083 | 8083 | 8082 | {"type": "Polygon", "coordinates": [[[-117.7672, 33.70657], [-117.76702, 33.70679], [-117.76688, 33.70675], [-117.76679, 33.70675], [-117.76672, 33.70678], [-117.76664, 33.70687], [-117.76658, 33.70705], [-117.76652, 33.70706], [-117.76539, 33.70628], [-117.76536, 33.70625], [-117.76535, 33.70622], [-117.76558, 33.70597], [-117.76559, 33.70591], [-117.76558, 33.70584], [-117.76581, 33.70561], [-117.7672, 33.70657]]]} | Open Access 1 | Pepperwood Park | 23600 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3.11 | Pepperwood Park | ||
2601 | 2601 | 2600 | {"type": "Polygon", "coordinates": [[[-117.80729, 33.64338], [-117.80672, 33.64397], [-117.80653, 33.6441], [-117.80609, 33.64423], [-117.8057, 33.64424], [-117.8056, 33.64404], [-117.80559, 33.6439], [-117.80564, 33.64372], [-117.80575, 33.64351], [-117.80584, 33.6434], [-117.8064, 33.6429], [-117.80645, 33.6429], [-117.80729, 33.64338]]]} | Open Access 1 | Canyon Park | 16824 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3.433 | Canyon Park | ||
2964 | 2964 | 2963 | {"type": "Polygon", "coordinates": [[[-117.75119, 33.72167], [-117.75027, 33.7226], [-117.75014, 33.72251], [-117.75, 33.72252], [-117.7486, 33.72155], [-117.75011, 33.72153], [-117.75056, 33.72156], [-117.75119, 33.72167]]]} | Open Access 1 | Citrusglen Park | 17289 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3.72 | Citrusglen Park | ||
9665 | 9665 | 9664 | {"type": "Polygon", "coordinates": [[[-117.77093, 33.71548], [-117.77021, 33.71621], [-117.76879, 33.71521], [-117.76936, 33.71467], [-117.76948, 33.71465], [-117.77039, 33.7153], [-117.77055, 33.71535], [-117.77068, 33.71531], [-117.77093, 33.71548]]]} | Open Access 1 | Silkwood Park | 25478 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3.889 | Silkwood Park | ||
9209 | 9209 | 9208 | {"type": "Polygon", "coordinates": [[[-117.82218, 33.67671], [-117.82163, 33.67712], [-117.82156, 33.67713], [-117.82149, 33.6771], [-117.82123, 33.67686], [-117.82097, 33.67669], [-117.81984, 33.67628], [-117.82034, 33.67545], [-117.82218, 33.67671]]]} | Open Access 1 | San Leandro Park | 24924 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 4.053 | San Leandro Park | ||
5409 | 5409 | 5408 | {"type": "Polygon", "coordinates": [[[-117.75437, 33.70597], [-117.75271, 33.70675], [-117.75166, 33.70713], [-117.75164, 33.70707], [-117.75344, 33.70529], [-117.75437, 33.70597]]]} | Open Access 1 | Irvine holding 9 | 20270 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 4.153 | Irvine holding 9 | ||
9220 | 9220 | 9219 | {"type": "Polygon", "coordinates": [[[-117.8325, 33.68181], [-117.83229, 33.68203], [-117.83099, 33.68136], [-117.83031, 33.68207], [-117.82956, 33.68157], [-117.82945, 33.68151], [-117.82978, 33.68096], [-117.83001, 33.6805], [-117.83013, 33.68046], [-117.83091, 33.68084], [-117.83105, 33.68103], [-117.8325, 33.68181]]]} | Open Access 1 | San Marco Park | 24943 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 5.011 | San Marco Park | ||
7739 | 7739 | 7738 | {"type": "Polygon", "coordinates": [[[-117.77483, 33.7005], [-117.77383, 33.7011], [-117.77349, 33.70135], [-117.77324, 33.70159], [-117.77313, 33.70161], [-117.77247, 33.70114], [-117.77246, 33.70105], [-117.77341, 33.70011], [-117.77363, 33.70005], [-117.77372, 33.7], [-117.77381, 33.69988], [-117.77382, 33.6998], [-117.7738, 33.69968], [-117.7741, 33.69938], [-117.77483, 33.7005]]]} | Open Access 1 | Orchard Park | 23190 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 5.831 | Orchard 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 | ||
9160 | 9160 | 9159 | {"type": "Polygon", "coordinates": [[[-117.82971, 33.6804], [-117.82942, 33.68094], [-117.8289, 33.68179], [-117.82811, 33.68143], [-117.82745, 33.68091], [-117.82878, 33.67987], [-117.82897, 33.68003], [-117.82921, 33.68014], [-117.82967, 33.68029], [-117.82971, 33.6804]]]} | Open Access 1 | San Carlo Park | 24843 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 5.869 | San Carlo 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]);