superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where MNG_AGENCY = 408
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5543 | 5543 | 5542 | {"type": "Polygon", "coordinates": [[[-121.08625, 38.64756], [-121.0853, 38.64768], [-121.08399, 38.64807], [-121.08395, 38.64803], [-121.08268, 38.64846], [-121.08267, 38.64852], [-121.08075, 38.64917], [-121.08069, 38.64913], [-121.07928, 38.64961], [-121.07927, 38.64966], [-121.07753, 38.65024], [-121.07718, 38.64974], [-121.07719, 38.64951], [-121.07722, 38.64951], [-121.07724, 38.64958], [-121.07732, 38.64965], [-121.0774, 38.64968], [-121.07752, 38.64967], [-121.07762, 38.64961], [-121.0777, 38.64945], [-121.07781, 38.64938], [-121.08032, 38.64854], [-121.08032, 38.64849], [-121.08225, 38.64784], [-121.08243, 38.64773], [-121.08592, 38.64685], [-121.08625, 38.64756]]]} | Open Access 1 | Joerger Park | 20425 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 15.736 | Joerger Park | ||
8177 | 8177 | 8176 | {"type": "Polygon", "coordinates": [[[-120.70427, 38.60566], [-120.70423, 38.60922], [-120.70391, 38.60931], [-120.70371, 38.60956], [-120.70367, 38.60955], [-120.70347, 38.60984], [-120.703, 38.6096], [-120.70166, 38.6083], [-120.7015, 38.60823], [-120.70042, 38.60721], [-120.70015, 38.60699], [-120.70427, 38.60566]]]} | Open Access 1 | Pioneer Park | 23716 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 22.833 | Pioneer Park | ||
13082 | 13082 | 13081 | {"type": "Polygon", "coordinates": [[[-121.08686, 38.67117], [-121.0865, 38.67114], [-121.08644, 38.67143], [-121.08638, 38.67163], [-121.08619, 38.67155], [-121.08591, 38.67149], [-121.08522, 38.67145], [-121.08502, 38.67141], [-121.0848, 38.67134], [-121.08458, 38.67124], [-121.08483, 38.67096], [-121.08454, 38.67067], [-121.08451, 38.67031], [-121.08457, 38.67029], [-121.08459, 38.67013], [-121.08451, 38.6701], [-121.08468, 38.66971], [-121.08446, 38.66955], [-121.08426, 38.66953], [-121.08428, 38.66921], [-121.08469, 38.66917], [-121.08467, 38.66889], [-121.08437, 38.66833], [-121.08293, 38.66772], [-121.08259, 38.66712], [-121.08212, 38.66619], [-121.08201, 38.66555], [-121.08178, 38.66542], [-121.08187, 38.66533], [-121.08197, 38.66525], [-121.08214, 38.66515], [-121.08218, 38.66546], [-121.08261, 38.66638], [-121.08292, 38.66712], [-121.08338, 38.66754], [-121.08477, 38.66832], [-121.08514, 38.66836], [-121.08553, 38.6683], [-121.08555, 38.66804], [-121.08579, 38.66805], [-121.08604, 38.66812], [-121.08625, 38.66824], [-121.08639, 38.66838], [-121.08647, 38.66848], [-121.08653, 38.66868], [-121.08655, 38.66925], [-121.08664, 38.66966], [-121.08624, 38.66973], [-121.08622, 38.66975], [-121.08636, 38.67023], [-121.08647, 38.67051], [-121.08686, 38.67117]]]} | Open Access 1 | Ridgeview Park | 30310 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 17.995 | Ridgeview Park | ||
13857 | 13857 | 13856 | {"type": "Polygon", "coordinates": [[[-120.58203, 38.77208], [-120.58176, 38.77203], [-120.57991, 38.772], [-120.58004, 38.76833], [-120.58042, 38.76844], [-120.58081, 38.76858], [-120.5813, 38.76903], [-120.58158, 38.7696], [-120.58168, 38.77008], [-120.58144, 38.77071], [-120.58152, 38.77158], [-120.58173, 38.77186], [-120.58203, 38.77208]]]} | Open Access 1 | Forebay Park | https://www.edcgov.us/Government/Parks/Pages/forebay_park.aspx | 33175 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 12.621 | Forebay 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]);