superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "17.041" and MNG_AGENCY = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8881 | 8881 | 8880 | {"type": "Polygon", "coordinates": [[[-119.71329, 34.44128], [-119.71313, 34.44136], [-119.71295, 34.44147], [-119.71282, 34.44151], [-119.71265, 34.44153], [-119.71246, 34.44158], [-119.71245, 34.44287], [-119.71165, 34.44308], [-119.71164, 34.4437], [-119.71066, 34.44371], [-119.71066, 34.44653], [-119.71063, 34.44654], [-119.7105, 34.44672], [-119.71016, 34.44668], [-119.71007, 34.4467], [-119.71016, 34.44658], [-119.71031, 34.44611], [-119.71034, 34.44558], [-119.70985, 34.44546], [-119.7103, 34.44459], [-119.70909, 34.44465], [-119.70909, 34.44366], [-119.70929, 34.44354], [-119.70944, 34.44331], [-119.7096, 34.4432], [-119.70973, 34.44302], [-119.70993, 34.44291], [-119.71007, 34.44279], [-119.71024, 34.44249], [-119.71044, 34.44241], [-119.71062, 34.44227], [-119.71067, 34.4423], [-119.71086, 34.44233], [-119.71111, 34.44215], [-119.71177, 34.44203], [-119.71206, 34.44138], [-119.71215, 34.4408], [-119.71243, 34.44063], [-119.71244, 34.44033], [-119.7126, 34.44032], [-119.7126, 34.44071], [-119.71329, 34.44128]], [[-119.71064, 34.4436], [-119.71066, 34.4432], [-119.71046, 34.44304], [-119.70999, 34.44353], [-119.71001, 34.4436], [-119.71064, 34.4436]]]} | Open Access 1 | Rocky Nook Park | 24542 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 17.041 | Rocky Nook 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]);