superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AGENCY = 87, MNG_AG_TYP = 4 and PARK_URL = "http://www.ebparks.org/parks/eastshore"
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- Recreation/Parks District · 2 ✖
MNG_AGENCY 1
- East Bay Regional Park District · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15218 | 15218 | 15217 | {"type": "MultiPolygon", "coordinates": [[[[-122.30915, 37.84566], [-122.30817, 37.84589], [-122.30821, 37.8476], [-122.30107, 37.84921], [-122.30081, 37.84913], [-122.30112, 37.84812], [-122.30117, 37.84744], [-122.30225, 37.84717], [-122.30225, 37.84437], [-122.29844, 37.84436], [-122.29811, 37.84292], [-122.29818, 37.84243], [-122.29797, 37.84227], [-122.29795, 37.84217], [-122.29789, 37.8416], [-122.29789, 37.84144], [-122.29792, 37.84125], [-122.29802, 37.84093], [-122.29939, 37.84074], [-122.30721, 37.84074], [-122.30856, 37.84072], [-122.30858, 37.84074], [-122.30914, 37.84075], [-122.30915, 37.84566]]], [[[-122.31153, 37.86418], [-122.31141, 37.86454], [-122.31122, 37.86464], [-122.31104, 37.86465], [-122.3106, 37.86471], [-122.30577, 37.86572], [-122.30563, 37.86572], [-122.30537, 37.86541], [-122.30393, 37.86453], [-122.30218, 37.85889], [-122.3003, 37.85163], [-122.30027, 37.85145], [-122.30027, 37.85121], [-122.30025, 37.85105], [-122.30068, 37.84959], [-122.30208, 37.84924], [-122.30822, 37.84786], [-122.30848, 37.85877], [-122.31153, 37.86418]]], [[[-122.31316, 37.8691], [-122.30903, 37.86998], [-122.30548, 37.87079], [-122.30529, 37.87011], [-122.30499, 37.86879], [-122.30499, 37.86853], [-122.30507, 37.86831], [-122.30574, 37.86731], [-122.30583, 37.86703], [-122.30579, 37.8668], [-122.30572, 37.8666], [-122.30575, 37.86651], [-122.30584, 37.86647], [-122.31099, 37.86543], [-122.3112, 37.8655], [-122.31316, 37.8691]]], [[[-122.31846, 37.87579], [-122.31005, 37.87748], [-122.30873, 37.87384], [-122.30661, 37.87435], [-122.30561, 37.87119], [-122.31326, 37.86954], [-122.31446, 37.87081], [-122.31516, 37.87171], [-122.31566, 37.87224], [-122.31846, 37.87579]]], [[[-122.33944, 37.89058], [-122.32869, 37.8935], [-122.32262, 37.89493], [-122.32444, 37.89221], [-122.32409, 37.89132], [-122.32356, 37.89131], [-122.32311, 37.8899], [-122.31991, 37.88993], [-122.31763, 37.89086], [-122.31635, 37.8909], [-122.31625, 37.89169], [-122.31393, 37.8917], [-122.31197, 37.89022], [-122.312, 37.88997], [-122.31333, 37.88985], [-122.31333, 37.88964], [-122.31592, 37.88963], [-122.31594, 37.88072], [-122.31252, 37.88139], [-122.31236, 37.88109], [-122.31217, 37.88081], [-122.31211, 37.88068], [-122.31185, 37.88037], [-122.31159, 37.88009], [-122.3108, 37.8791], [-122.31005, 37.87812], [-122.3099, 37.8779], [-122.30983, 37.87775], [-122.31024, 37.87767], [-122.31046, 37.87777], [-122.31051, 37.87772], [-122.31053, 37.87761], [-122.31588, 37.87656], [-122.31865, 37.87593], [-122.32167, 37.87952], [-122.32559, 37.88404], [-122.33014, 37.88463], [-122.3307, 37.88919], [-122.33944, 37.89058]]], [[[-122.32, 37.89774], [-122.31953, 37.89799], [-122.31891, 37.89855], [-122.31905, 37.89825], [-122.31963, 37.89787], [-122.32, 37.89774]]], [[[-122.3256, 37.90938], [-122.32441, 37.90871], [-122.32387, 37.90873], [-122.32346, 37.90851], [-122.32331, 37.90864], [-122.32054, 37.90518], [-122.32029, 37.90492], [-122.31957, 37.90397], [-122.32022, 37.90468], [-122.32039, 37.90483], [-122.32094, 37.9054], [-122.32145, 37.90584], [-122.32205, 37.90627], [-122.32317, 37.90701], [-122.32432, 37.90764], [-122.32454, 37.90774], [-122.32475, 37.9078], [-122.32557, 37.90811], [-122.3256, 37.90938]]], [[[-122.3261, 37.90816], [-122.32594, 37.90814], [-122.32578, 37.90809], [-122.32458, 37.9076], [-122.3235, 37.90705], [-122.32313, 37.90684], [-122.3228, 37.9066], [-122.32235, 37.90632], [-122.32211, 37.90606], [-122.32159, 37.90561], [-122.32125, 37.90533], [-122.32088, 37.90498], [-122.3203, 37.90434], [-122.31987, 37.90381], [-122.32522, 37.90109], [-122.32523, 37.9016], [-122.32526, 37.90164], [-122.32525, 37.90223], [-122.32528, 37.90303], [-122.32537, 37.9072], [-122.3261, 37.90816]]], [[[-122.32553, 37.89867], [-122.3253, 37.89925], [-122.32527, 37.89971], [-122.32522, 37.89971], [-122.32521, 37.89939], [-122.32487, 37.89938], [-122.32487, 37.89923], [-122.32464, 37.89867], [-122.32456, 37.89855], [-122.3243, 37.8983], [-122.32386, 37.89801], [-122.32482, 37.89703], [-122.32227, 37.89542], [-122.32129, 37.89637], [-122.32156, 37.89656], [-122.32103, 37.89709], [-122.32103, 37.89664], [-122.32117, 37.8962], [-122.32142, 37.89597], [-122.32151, 37.89571], [-122.32216, 37.8953], [-122.32275, 37.89529], [-122.32297, 37.89561], [-122.32319, 37.89586], [-122.32496, 37.89698], [-122.32459, 37.89744], [-122.32537, 37.89797], [-122.32535, 37.89834], [-122.32553, 37.89867]]]]} | Open Access 1 | McLaughlin Eastshore State Park | http://www.ebparks.org/parks/eastshore | 29199 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 1225.569 | McLaughlin Eastshore SP | |
15260 | 15260 | 15259 | {"type": "MultiPolygon", "coordinates": [[[[-122.31807, 37.82977], [-122.3145, 37.83558], [-122.31384, 37.83676], [-122.31367, 37.83701], [-122.30448, 37.837], [-122.30447, 37.83642], [-122.30312, 37.83642], [-122.3031, 37.83648], [-122.30259, 37.83653], [-122.3021, 37.83672], [-122.30152, 37.83669], [-122.30051, 37.83676], [-122.29922, 37.83705], [-122.29895, 37.83704], [-122.29802, 37.83651], [-122.29744, 37.83499], [-122.29694, 37.83457], [-122.29687, 37.8339], [-122.29615, 37.83373], [-122.29546, 37.83375], [-122.29554, 37.83363], [-122.29611, 37.83345], [-122.29659, 37.83311], [-122.29672, 37.8329], [-122.29619, 37.83224], [-122.29627, 37.83193], [-122.29587, 37.83155], [-122.29613, 37.83127], [-122.29629, 37.83082], [-122.29615, 37.83062], [-122.29632, 37.83055], [-122.29641, 37.83044], [-122.29629, 37.83016], [-122.29573, 37.82964], [-122.29595, 37.82963], [-122.29654, 37.82997], [-122.29727, 37.83023], [-122.29786, 37.83006], [-122.29815, 37.83017], [-122.2983, 37.82971], [-122.2982, 37.82942], [-122.29796, 37.82915], [-122.29825, 37.82843], [-122.29849, 37.82846], [-122.29865, 37.82825], [-122.29901, 37.82821], [-122.29925, 37.8278], [-122.30111, 37.82678], [-122.3011, 37.82645], [-122.30548, 37.82556], [-122.30748, 37.82592], [-122.30868, 37.82589], [-122.31807, 37.82977]]], [[[-122.31785, 37.90207], [-122.31749, 37.90263], [-122.3175, 37.90285], [-122.31661, 37.90177], [-122.31604, 37.90104], [-122.31593, 37.90086], [-122.31581, 37.90061], [-122.31574, 37.90032], [-122.31575, 37.90024], [-122.31577, 37.90016], [-122.31585, 37.90005], [-122.31596, 37.89998], [-122.31612, 37.89993], [-122.31785, 37.90207]]], [[[-122.31976, 37.90599], [-122.31923, 37.906], [-122.3171, 37.90343], [-122.31757, 37.90318], [-122.31802, 37.90409], [-122.31829, 37.90458], [-122.31976, 37.90599]]]]} | Restricted Access 2 | McLaughlin Eastshore State Park | http://www.ebparks.org/parks/eastshore | 29198 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 464.167 | McLaughlin Eastshore SP |
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]);