superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 7 and PARK_NAME = "San Miguel 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14838 | 14838 | 14837 | {"type": "MultiPolygon", "coordinates": [[[[-119.90372, 34.44055], [-119.90337, 34.44064], [-119.90304, 34.44075], [-119.90228, 34.44082], [-119.90212, 34.44081], [-119.9019, 34.44074], [-119.9018, 34.44071], [-119.90159, 34.44073], [-119.90141, 34.44081], [-119.90103, 34.44128], [-119.90044, 34.44129], [-119.90044, 34.44119], [-119.90054, 34.44119], [-119.90067, 34.44116], [-119.90084, 34.44107], [-119.90091, 34.441], [-119.90125, 34.44054], [-119.9014, 34.44043], [-119.90154, 34.44038], [-119.90164, 34.44037], [-119.90178, 34.44039], [-119.90217, 34.44055], [-119.90229, 34.44058], [-119.90243, 34.44059], [-119.90262, 34.44056], [-119.90312, 34.44039], [-119.90321, 34.44038], [-119.90344, 34.44039], [-119.90363, 34.44036], [-119.90367, 34.44038], [-119.90372, 34.44055]]], [[[-119.90635, 34.43896], [-119.90632, 34.43909], [-119.90622, 34.43924], [-119.90594, 34.43954], [-119.90539, 34.43967], [-119.90513, 34.43993], [-119.90497, 34.4404], [-119.90466, 34.44068], [-119.90455, 34.44101], [-119.90449, 34.44101], [-119.90448, 34.44078], [-119.90438, 34.44049], [-119.90389, 34.44046], [-119.90385, 34.44036], [-119.90389, 34.44031], [-119.90399, 34.44031], [-119.90417, 34.44034], [-119.90427, 34.44034], [-119.90442, 34.4403], [-119.90455, 34.44022], [-119.90469, 34.44007], [-119.90481, 34.43981], [-119.90508, 34.4395], [-119.90518, 34.43942], [-119.90535, 34.43934], [-119.90543, 34.43927], [-119.90548, 34.43918], [-119.90549, 34.43905], [-119.90547, 34.43895], [-119.90539, 34.43885], [-119.90549, 34.43857], [-119.90613, 34.43873], [-119.9063, 34.43887], [-119.90635, 34.43896]]]]} | Open Access 1 | San Miguel Open Space | 24956 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 5.812 | San Miguel 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]);