superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where MNG_AGENCY = 408 and MNG_AG_TYP = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1795 | 1795 | 1794 | {"type": "Polygon", "coordinates": [[[-121.02867, 38.67828], [-121.02866, 38.67981], [-121.02866, 38.68191], [-121.0275, 38.68193], [-121.02633, 38.68374], [-121.02633, 38.6846], [-121.02169, 38.68456], [-121.01836, 38.67788], [-121.01832, 38.67709], [-121.01842, 38.67699], [-121.01883, 38.67516], [-121.0189, 38.67499], [-121.01899, 38.67485], [-121.01914, 38.67478], [-121.0193, 38.67476], [-121.0195, 38.67479], [-121.01975, 38.67492], [-121.02137, 38.67628], [-121.02188, 38.67638], [-121.02234, 38.67651], [-121.02373, 38.67706], [-121.02408, 38.67719], [-121.02444, 38.67728], [-121.02488, 38.67735], [-121.02524, 38.67737], [-121.02568, 38.67737], [-121.02617, 38.67701], [-121.02624, 38.67689], [-121.02625, 38.67681], [-121.02636, 38.67682], [-121.02635, 38.67829], [-121.02867, 38.67828]]]} | Open Access 1 | Bass Lake | 15855 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 152.117 | Bass Lake | ||
1814 | 1814 | 1813 | {"type": "Polygon", "coordinates": [[[-121.01029, 38.67025], [-121.00859, 38.67106], [-121.00596, 38.67107], [-121.00591, 38.67096], [-121.00832, 38.67042], [-121.0086, 38.67009], [-121.00799, 38.66978], [-121.00808, 38.66966], [-121.00871, 38.66997], [-121.00918, 38.6694], [-121.01029, 38.67025]]]} | Open Access 1 | Cameron Park-Shingle Springs 1 | 16762 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 6.404 | Cameron Park-Shingle Springs 1 | ||
2198 | 2198 | 2197 | {"type": "Polygon", "coordinates": [[[-120.92638, 38.66545], [-120.92512, 38.66575], [-120.92479, 38.66594], [-120.92458, 38.66569], [-120.92491, 38.6655], [-120.92627, 38.66518], [-120.92638, 38.66545]]]} | Open Access 1 | Bradford Park | 16323 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 1.212 | Bradford Park | ||
5031 | 5031 | 5030 | {"type": "Polygon", "coordinates": [[[-120.91121, 38.80136], [-120.91028, 38.80279], [-120.91016, 38.80327], [-120.91004, 38.8035], [-120.9097, 38.80378], [-120.90942, 38.80387], [-120.90941, 38.80409], [-120.90835, 38.8041], [-120.90657, 38.80434], [-120.90645, 38.80435], [-120.90543, 38.8045], [-120.90504, 38.80472], [-120.90409, 38.80498], [-120.9032, 38.80497], [-120.90243, 38.8056], [-120.90242, 38.80568], [-120.90217, 38.80582], [-120.90133, 38.8066], [-120.90101, 38.80719], [-120.90106, 38.8074], [-120.90104, 38.80778], [-120.90059, 38.80847], [-120.90017, 38.80857], [-120.90017, 38.8085], [-120.90008, 38.80835], [-120.90008, 38.80822], [-120.90013, 38.80769], [-120.90017, 38.8074], [-120.89996, 38.80736], [-120.90003, 38.80711], [-120.90012, 38.8069], [-120.90012, 38.80679], [-120.90037, 38.80639], [-120.90047, 38.80641], [-120.90081, 38.806], [-120.9008, 38.80597], [-120.90118, 38.80559], [-120.90117, 38.80555], [-120.90142, 38.80532], [-120.90185, 38.80501], [-120.90241, 38.80503], [-120.90262, 38.80481], [-120.90334, 38.80446], [-120.90367, 38.80416], [-120.90387, 38.80373], [-120.90415, 38.80324], [-120.90364, 38.80302], [-120.90546, 38.80173], [-120.90683, 38.80131], [-120.9076, 38.80179], [-120.90709, 38.80188], [-120.907, 38.80194], [-120.907, 38.80196], [-120.90927, 38.80203], [-120.90948, 38.80139], [-120.91121, 38.80136]]]} | Open Access 1 | Henningsen Lotus Park | 19821 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 49.262 | Henningsen Lotus Park | ||
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]);