superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3, LABEL_NAME = "Lawrence and Barbara Daley Preserve", MNG_AGENCY = 101 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- County Agency · 1 ✖
MNG_AGENCY 1
- San Diego, County of · 1 ✖
ACCESS_TYP 1
- No Public Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13798 | 13798 | 13797 | {"type": "Polygon", "coordinates": [[[-116.80495, 32.6658], [-116.7972, 32.66593], [-116.79691, 32.66573], [-116.79678, 32.66565], [-116.79554, 32.66464], [-116.79569, 32.65742], [-116.78827, 32.65749], [-116.7882, 32.65701], [-116.77957, 32.65689], [-116.77935, 32.64654], [-116.78382, 32.64644], [-116.78381, 32.64588], [-116.78409, 32.64598], [-116.78439, 32.64605], [-116.78463, 32.64607], [-116.78512, 32.64609], [-116.7853, 32.64611], [-116.78551, 32.64618], [-116.78574, 32.64629], [-116.78584, 32.64636], [-116.78591, 32.64644], [-116.78597, 32.64653], [-116.786, 32.64664], [-116.78603, 32.64793], [-116.78609, 32.64813], [-116.78635, 32.64851], [-116.78641, 32.64863], [-116.78641, 32.64876], [-116.78636, 32.64911], [-116.78634, 32.64918], [-116.78636, 32.64927], [-116.78685, 32.65008], [-116.78694, 32.65019], [-116.78706, 32.65029], [-116.78722, 32.65038], [-116.7874, 32.65043], [-116.78819, 32.65052], [-116.78833, 32.65059], [-116.78845, 32.65071], [-116.7885, 32.65082], [-116.78869, 32.65163], [-116.7887, 32.65178], [-116.78869, 32.65209], [-116.78872, 32.65231], [-116.78884, 32.65264], [-116.78898, 32.65285], [-116.78902, 32.65304], [-116.78907, 32.65314], [-116.78922, 32.65323], [-116.78954, 32.65329], [-116.78969, 32.65328], [-116.78976, 32.65325], [-116.78984, 32.6532], [-116.79019, 32.65284], [-116.79056, 32.65268], [-116.7907, 32.65263], [-116.79084, 32.65261], [-116.791, 32.65262], [-116.79115, 32.65265], [-116.79157, 32.65279], [-116.79173, 32.6529], [-116.79181, 32.65303], [-116.79189, 32.65332], [-116.79204, 32.65374], [-116.79201, 32.65377], [-116.79204, 32.65382], [-116.79217, 32.65397], [-116.79232, 32.65409], [-116.7925, 32.6542], [-116.7927, 32.65427], [-116.79413, 32.65454], [-116.79453, 32.65443], [-116.79454, 32.65439], [-116.79458, 32.65438], [-116.79479, 32.65439], [-116.79609, 32.65457], [-116.79742, 32.65446], [-116.79772, 32.65438], [-116.798, 32.65424], [-116.79813, 32.65414], [-116.7988, 32.65358], [-116.79906, 32.65341], [-116.79963, 32.65313], [-116.79982, 32.65306], [-116.80012, 32.65298], [-116.80041, 32.65296], [-116.80065, 32.65297], [-116.8009, 32.65301], [-116.80291, 32.6536], [-116.80322, 32.65367], [-116.80397, 32.6538], [-116.80484, 32.65407], [-116.80495, 32.6658]]]} | No Public Access 3 | Lawrence and Barbara Daley Preserve | 31315 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 580.943 | Lawrence and Barbara Daley Preserve |
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]);