superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 101 and PARK_URL = "http://www.sdparks.org/content/sdparks/en/park-pages/LakeMorena.html"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
935 | 935 | 934 | {"type": "Polygon", "coordinates": [[[-116.55091, 32.68226], [-116.5509, 32.68904], [-116.54671, 32.68904], [-116.54666, 32.69624], [-116.54247, 32.69617], [-116.54246, 32.69264], [-116.53813, 32.69259], [-116.53814, 32.68901], [-116.53405, 32.68894], [-116.53398, 32.69617], [-116.53815, 32.6962], [-116.53809, 32.71037], [-116.53398, 32.71042], [-116.53382, 32.71605], [-116.53385, 32.72189], [-116.52947, 32.72189], [-116.52952, 32.72556], [-116.52511, 32.72556], [-116.52519, 32.71823], [-116.52073, 32.71818], [-116.52069, 32.71598], [-116.52076, 32.7146], [-116.51671, 32.71461], [-116.51659, 32.70729], [-116.50785, 32.70736], [-116.50786, 32.71104], [-116.50351, 32.71109], [-116.5035, 32.71481], [-116.49896, 32.71499], [-116.4951, 32.71505], [-116.4951, 32.71112], [-116.49937, 32.71107], [-116.49957, 32.6966], [-116.50366, 32.69661], [-116.50365, 32.70018], [-116.50784, 32.70019], [-116.508, 32.69288], [-116.51156, 32.6929], [-116.51245, 32.69289], [-116.51259, 32.68983], [-116.51262, 32.68937], [-116.51405, 32.68937], [-116.51423, 32.68936], [-116.51428, 32.6885], [-116.51486, 32.68808], [-116.51478, 32.68764], [-116.51501, 32.68739], [-116.515, 32.68715], [-116.51517, 32.68685], [-116.51506, 32.68635], [-116.51528, 32.68609], [-116.51576, 32.68605], [-116.51581, 32.68606], [-116.51608, 32.68574], [-116.51671, 32.68595], [-116.51671, 32.68474], [-116.51678, 32.68255], [-116.51675, 32.68254], [-116.51675, 32.68218], [-116.52375, 32.68219], [-116.52542, 32.68216], [-116.52542, 32.67813], [-116.53398, 32.67817], [-116.534, 32.67113], [-116.53823, 32.67113], [-116.5382, 32.67463], [-116.54239, 32.67461], [-116.54239, 32.67816], [-116.54667, 32.67819], [-116.5467, 32.68224], [-116.55091, 32.68226]], [[-116.534, 32.67817], [-116.53399, 32.67819], [-116.53399, 32.68218], [-116.53813, 32.68223], [-116.53816, 32.6782], [-116.534, 32.67817]]]} | Open Access 1 | Lake Morena County Park | http://www.sdparks.org/content/sdparks/en/park-pages/LakeMorena.html | 10398 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 3279.849 | Lake Morena County 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]);