superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 87 and YR_EST = 1986
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15476 | 15476 | 15475 | {"type": "Polygon", "coordinates": [[[-122.16525, 37.78676], [-122.16506, 37.78688], [-122.16491, 37.78714], [-122.16476, 37.78733], [-122.16457, 37.78752], [-122.16421, 37.78766], [-122.16373, 37.78763], [-122.16354, 37.78767], [-122.1629, 37.78754], [-122.16274, 37.78737], [-122.16258, 37.78761], [-122.16245, 37.78776], [-122.16234, 37.78786], [-122.16203, 37.78835], [-122.16177, 37.78857], [-122.16157, 37.78861], [-122.16137, 37.78923], [-122.16043, 37.78943], [-122.16001, 37.78928], [-122.15824, 37.78893], [-122.15759, 37.78815], [-122.15745, 37.78804], [-122.15629, 37.78755], [-122.15559, 37.78706], [-122.15504, 37.78605], [-122.15449, 37.78564], [-122.15417, 37.78576], [-122.15443, 37.78605], [-122.15217, 37.78722], [-122.15125, 37.78633], [-122.15082, 37.7865], [-122.1481, 37.78385], [-122.14729, 37.78418], [-122.14632, 37.78324], [-122.14716, 37.78258], [-122.1464, 37.78191], [-122.14535, 37.7826], [-122.1441, 37.78144], [-122.14443, 37.78125], [-122.14444, 37.7801], [-122.14421, 37.77962], [-122.14389, 37.77932], [-122.14361, 37.7788], [-122.14269, 37.77805], [-122.14293, 37.77764], [-122.14311, 37.77694], [-122.14215, 37.77641], [-122.14156, 37.77587], [-122.14158, 37.77571], [-122.14071, 37.77463], [-122.14364, 37.77317], [-122.14385, 37.77327], [-122.14361, 37.77387], [-122.14447, 37.77466], [-122.14494, 37.7756], [-122.14547, 37.77601], [-122.14569, 37.77594], [-122.14746, 37.77701], [-122.14791, 37.77762], [-122.14792, 37.7776], [-122.14774, 37.77684], [-122.14723, 37.7765], [-122.14726, 37.77641], [-122.14726, 37.77616], [-122.14639, 37.77552], [-122.14603, 37.77537], [-122.14643, 37.77506], [-122.14682, 37.77504], [-122.14742, 37.77574], [-122.15095, 37.77612], [-122.15047, 37.77682], [-122.15219, 37.77819], [-122.15346, 37.77871], [-122.15343, 37.77878], [-122.15164, 37.78013], [-122.15252, 37.78086], [-122.15355, 37.78118], [-122.15398, 37.78099], [-122.15464, 37.78148], [-122.1556, 37.78194], [-122.15551, 37.78278], [-122.15631, 37.78297], [-122.15682, 37.78317], [-122.15727, 37.78351], [-122.1581, 37.78461], [-122.15869, 37.784], [-122.1589, 37.78419], [-122.15953, 37.78446], [-122.16022, 37.78487], [-122.16076, 37.78526], [-122.16109, 37.78563], [-122.16157, 37.78596], [-122.16184, 37.7862], [-122.16259, 37.78645], [-122.16331, 37.78679], [-122.16337, 37.78696], [-122.16341, 37.78749], [-122.16382, 37.78749], [-122.16415, 37.78742], [-122.16454, 37.78728], [-122.16467, 37.78702], [-122.16473, 37.78683], [-122.16519, 37.78661], [-122.16525, 37.78676]]]} | Open Access 1 | Leona Heights Regional Open Space | http://www.ebparks.org/parks/leona | 3282 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 297.193 | Leona Heights Reg. OS | 1986 |
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]);