units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 3, LABEL_NAME = "San Miguel OS" and MNG_AGENCY = 7
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Santa Barbara, County of · 1 ✖
DES_TP 1
- Local Recreation Area · 1 ✖
ACCESS_TYP 1
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15963 | 15963 | 15962 | {"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.44072], [-119.90141, 34.4408], [-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.90465, 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.44035], [-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 | 403 | San Miguel Open Space | 24956 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 5.809 | San Miguel OS | 0 | Local Recreation Area 3 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);