units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
101 rows where MNG_AGENCY = 266 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST ▼ | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1673 | 1673 | 1672 | {"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 | 12635 | Silkwood Park | 25478 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 3.889 | Silkwood Park | 0 | Local Park 2 | 4 | |
1687 | 1687 | 1686 | {"type": "Polygon", "coordinates": [[[-117.77833, 33.73648], [-117.77833, 33.73656], [-117.77818, 33.73668], [-117.778, 33.73687], [-117.77801, 33.73689], [-117.7779, 33.73699], [-117.7776, 33.73678], [-117.7773, 33.73707], [-117.77732, 33.7372], [-117.77749, 33.73738], [-117.77721, 33.73766], [-117.77602, 33.73683], [-117.77703, 33.73585], [-117.77701, 33.73582], [-117.77704, 33.73579], [-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 | 12730 | Valencia Park | 26765 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 5.851 | Valencia Park | 0 | Local Park 2 | 4 | |
1688 | 1688 | 1687 | {"type": "Polygon", "coordinates": [[[-117.77315, 33.66762], [-117.77212, 33.66863], [-117.76938, 33.66672], [-117.77029, 33.66576], [-117.77079, 33.66612], [-117.77315, 33.66762]]]} | Open Access 1 | 12731 | Oak Creek Community Park | 22959 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 11.56 | Oak Creek Community Park | 0 | Local Park 2 | 4 | |
1689 | 1689 | 1688 | {"type": "Polygon", "coordinates": [[[-117.7763, 33.66668], [-117.77569, 33.66727], [-117.77493, 33.66675], [-117.77476, 33.6666], [-117.77473, 33.66662], [-117.77464, 33.66655], [-117.7746, 33.66658], [-117.77459, 33.66657], [-117.77521, 33.66592], [-117.7763, 33.66668]]]} | Open Access 1 | 12732 | Valley Oak Park | 26791 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.81 | Valley Oak Park | 0 | Local Park 2 | 4 | |
1694 | 1694 | 1693 | {"type": "Polygon", "coordinates": [[[-117.78468, 33.69615], [-117.78458, 33.69625], [-117.78392, 33.6958], [-117.78367, 33.69605], [-117.78377, 33.69614], [-117.78375, 33.69616], [-117.78362, 33.6961], [-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.783, 33.69609], [-117.78292, 33.69602], [-117.78319, 33.69576], [-117.7832, 33.69571], [-117.78345, 33.69547], [-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.69572], [-117.78457, 33.6961], [-117.78463, 33.69609], [-117.78468, 33.69615]]]} | Open Access 1 | 12756 | Willows Park | 27594 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.596 | Willows Park | 0 | Local Park 2 | 4 | |
1717 | 1717 | 1716 | {"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 | 14857 | Turtle Rock Community Park | 26593 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 21.468 | Turtle Rock Community Park | 0 | Local Park 2 | 4 | |
1926 | 1926 | 1925 | {"type": "Polygon", "coordinates": [[[-117.82166, 33.65937], [-117.82142, 33.65971], [-117.82114, 33.66015], [-117.82094, 33.66052], [-117.82017, 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.82005, 33.65963], [-117.82007, 33.65938], [-117.82166, 33.65937]]]} | Open Access 1 | 14898 | University Community Park | 26678 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 19.625 | University Community Park | 0 | Local Park 2 | 4 | |
2446 | 2446 | 2445 | {"type": "Polygon", "coordinates": [[[-117.76119, 33.70774], [-117.76076, 33.70816], [-117.76051, 33.70835], [-117.76025, 33.70817], [-117.76017, 33.70825], [-117.75947, 33.70777], [-117.75971, 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 | 12173 | Carrotwood Park | 16920 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 3.091 | Carrotwood Park | 0 | Local Park 2 | 4 | |
2448 | 2448 | 2447 | {"type": "Polygon", "coordinates": [[[-117.817, 33.6335], [-117.81679, 33.63419], [-117.81524, 33.63392], [-117.81415, 33.63424], [-117.81405, 33.63482], [-117.8138, 33.63483], [-117.81329, 33.6346], [-117.81344, 33.63358], [-117.81313, 33.63353], [-117.81317, 33.63287], [-117.81436, 33.633], [-117.81478, 33.63303], [-117.81598, 33.63317], [-117.81644, 33.63328], [-117.817, 33.6335]]]} | Open Access 1 | 12179 | Chaparral Park | 17129 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 10.442 | Chaparral Park | 0 | Local Park 2 | 4 | |
2450 | 2450 | 2449 | {"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 | 12181 | Citrusglen Park | 17289 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 3.72 | Citrusglen Park | 0 | Local Park 2 | 4 | |
2763 | 2763 | 2762 | {"type": "Polygon", "coordinates": [[[-117.79385, 33.69078], [-117.79381, 33.69084], [-117.79257, 33.69208], [-117.79239, 33.69222], [-117.79235, 33.69228], [-117.79235, 33.69234], [-117.79224, 33.69234], [-117.79206, 33.69251], [-117.79072, 33.69157], [-117.79092, 33.69136], [-117.79099, 33.69135], [-117.79104, 33.69131], [-117.79118, 33.69114], [-117.7925, 33.68983], [-117.79254, 33.68983], [-117.79257, 33.68985], [-117.79279, 33.6901], [-117.79298, 33.69025], [-117.79338, 33.69052], [-117.79383, 33.69074], [-117.79385, 33.69078]]]} | Open Access 1 | 18466 | Deerfield Community Park | 18008 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 10.245 | Deerfield Community Park | 0 | Local Park 2 | 4 | |
3011 | 3011 | 3010 | {"type": "Polygon", "coordinates": [[[-117.71297, 33.70113], [-117.71281, 33.70134], [-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]]]} | Open Access 1 | 48660 | Orchard Trail Park | 33407 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 0.424 | Orchard Trail Park | 0 | Local Park 2 | 4 | |
3012 | 3012 | 3011 | {"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 | 48661 | Bommer Vista Point Park | 33408 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 0.662 | Bommer Vista Point Park | 0 | Local Park 2 | 4 | |
3013 | 3013 | 3012 | {"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.68722], [-117.75572, 33.6872], [-117.7556, 33.6872], [-117.7556, 33.68713], [-117.75688, 33.68585], [-117.75861, 33.68706]]]} | Open Access 1 | 48662 | Cypress Grove Park | 33409 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 9.424 | Cypress Grove Park | 0 | Local Park 2 | 4 | |
3699 | 3699 | 3698 | {"type": "Polygon", "coordinates": [[[-117.79034, 33.67353], [-117.7903, 33.6736], [-117.79023, 33.67358], [-117.79005, 33.67382], [-117.78944, 33.67348], [-117.7898, 33.6732], [-117.79034, 33.67353]]]} | Open Access 1 | 30201 | Creekview Park | 17787 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 0.679 | Creekview Park | 0 | Local Park 2 | 4 | |
4040 | 4040 | 4039 | {"type": "Polygon", "coordinates": [[[-117.76064, 33.73966], [-117.76012, 33.74012], [-117.75743, 33.73842], [-117.75801, 33.73776], [-117.75829, 33.73758], [-117.75908, 33.73774], [-117.7599, 33.7381], [-117.76039, 33.73872], [-117.76064, 33.73966]]]} | Open Access 1 | 44285 | Settlers Park | 25324 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 10.852 | Settlers Park | 0 | Local Park 2 | 4 | |
4326 | 4326 | 4325 | {"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.74022, 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.74191, 33.70619], [-117.74192, 33.7062]]]} | Open Access 1 | 45461 | Stonegate Park | 28267 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.cityofirvine.org/cityhall/cs/commparks/nparks/default.asp | Orange 3 | 8.581 | Stonegate Park | 0 | Local Park 2 | 4 |
4327 | 4327 | 4326 | {"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 | 45463 | Cypress Community Park | 28273 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.cityofirvine.org/cityhall/cs/commparks/cparks/cypress_community_park.asp | Orange 3 | 14.139 | Cypress Community Park | 0 | Local Park 2 | 4 |
5035 | 5035 | 5034 | {"type": "Polygon", "coordinates": [[[-117.75315, 33.69738], [-117.75187, 33.69866], [-117.75179, 33.69867], [-117.75168, 33.69878], [-117.75168, 33.69884], [-117.75097, 33.69955], [-117.75091, 33.69955], [-117.74986, 33.69882], [-117.75088, 33.6978], [-117.75088, 33.69779], [-117.75082, 33.69775], [-117.75203, 33.69654], [-117.75314, 33.69732], [-117.75315, 33.69734], [-117.75315, 33.69738]]]} | Open Access 1 | 48664 | Woodbury Community Park | 33411 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 10.743 | Woodbury Community Park | 0 | Local Park 2 | 4 | |
5378 | 5378 | 5377 | {"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 | 12609 | San Leandro Park | 24924 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 4.053 | San Leandro Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);