superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 2 and PARK_NAME = "Sycamore Canyon Open Space"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15000 | 15000 | 14999 | {"type": "Polygon", "coordinates": [[[-117.0175, 32.93461], [-117.01661, 32.93524], [-117.01593, 32.93601], [-117.01482, 32.93714], [-117.01292, 32.93726], [-117.01246, 32.93879], [-117.01046, 32.94041], [-117.01043, 32.94106], [-117.00988, 32.94128], [-117.00943, 32.94128], [-117.00853, 32.94152], [-117.00802, 32.94204], [-117.00245, 32.94396], [-117.00152, 32.94443], [-117.00145, 32.94445], [-116.99968, 32.94358], [-116.99946, 32.94345], [-116.99673, 32.94117], [-116.99658, 32.9411], [-116.99641, 32.94106], [-116.99629, 32.94105], [-116.9951, 32.94118], [-116.99422, 32.94116], [-116.99405, 32.94117], [-116.99386, 32.94121], [-116.99279, 32.9416], [-116.99262, 32.94171], [-116.99205, 32.94221], [-116.99184, 32.94231], [-116.9916, 32.94237], [-116.99137, 32.94239], [-116.99125, 32.94238], [-116.99077, 32.94233], [-116.99076, 32.94243], [-116.9903, 32.94238], [-116.98828, 32.94257], [-116.98707, 32.94283], [-116.98565, 32.94286], [-116.98527, 32.94284], [-116.98493, 32.94279], [-116.98446, 32.94268], [-116.98345, 32.94253], [-116.98208, 32.94262], [-116.98199, 32.94262], [-116.98079, 32.9421], [-116.98075, 32.94212], [-116.98032, 32.93986], [-116.98048, 32.93978], [-116.98109, 32.94033], [-116.98158, 32.94012], [-116.98354, 32.93871], [-116.98424, 32.93807], [-116.98441, 32.93658], [-116.98442, 32.93604], [-116.98403, 32.93561], [-116.98356, 32.9343], [-116.98363, 32.93403], [-116.9895, 32.93402], [-116.98937, 32.91955], [-116.99056, 32.91958], [-116.99768, 32.91928], [-116.99807, 32.91935], [-117.0124, 32.91959], [-117.01119, 32.92108], [-117.00748, 32.92448], [-117.00707, 32.92542], [-117.00736, 32.92672], [-117.00645, 32.92984], [-117.00695, 32.92996], [-117.00769, 32.93041], [-117.00803, 32.93069], [-117.0081, 32.93102], [-117.00837, 32.93133], [-117.0092, 32.93179], [-117.00955, 32.93191], [-117.0101, 32.93232], [-117.01037, 32.93244], [-117.01052, 32.93265], [-117.0106, 32.93284], [-117.0108, 32.93306], [-117.01116, 32.93322], [-117.01157, 32.93342], [-117.01172, 32.93371], [-117.01176, 32.93396], [-117.01186, 32.93407], [-117.01224, 32.93429], [-117.01247, 32.93448], [-117.01272, 32.93527], [-117.01306, 32.93561], [-117.01308, 32.9356], [-117.01319, 32.93516], [-117.01319, 32.93497], [-117.01339, 32.93481], [-117.01347, 32.93481], [-117.01366, 32.93476], [-117.01386, 32.93489], [-117.01417, 32.935], [-117.01441, 32.93479], [-117.01507, 32.93487], [-117.0153, 32.93482], [-117.01555, 32.93453], [-117.01572, 32.93439], [-117.01587, 32.9345], [-117.01637, 32.93459], [-117.01655, 32.93466], [-117.01714, 32.9347], [-117.0175, 32.93461]], [[-117.00331, 32.92926], [-117.00318, 32.92919], [-117.00307, 32.9292], [-117.00303, 32.92925], [-117.00302, 32.9293], [-117.00308, 32.92938], [-117.00314, 32.9294], [-117.00319, 32.9294], [-117.00324, 32.92939], [-117.00329, 32.92934], [-117.00331, 32.9293], [-117.00331, 32.92926]]]} | Open Access 1 | Sycamore Canyon Open Space | 30259 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1372.025 | Sycamore Canyon OS |
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]);