units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Rocky Nook Park" and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5828 | 5828 | 5827 | {"type": "Polygon", "coordinates": [[[-119.71329, 34.44128], [-119.71313, 34.44136], [-119.71295, 34.44147], [-119.71282, 34.44151], [-119.71266, 34.44153], [-119.71245, 34.44158], [-119.71245, 34.44287], [-119.71164, 34.44308], [-119.71164, 34.4437], [-119.71066, 34.44371], [-119.71066, 34.44653], [-119.71063, 34.44653], [-119.7105, 34.44672], [-119.71016, 34.44668], [-119.71007, 34.4467], [-119.71016, 34.44658], [-119.71031, 34.44611], [-119.71034, 34.44557], [-119.70985, 34.44546], [-119.71031, 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.70994, 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.44137], [-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.71065, 34.4436], [-119.71066, 34.44319], [-119.71046, 34.44304], [-119.70999, 34.44353], [-119.71, 34.4436], [-119.71065, 34.4436]]]} | Open Access 1 | 142 | Rocky Nook Park | 24542 | 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 | 16.986 | Rocky Nook Park | 0 | Local Park 2 | 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]);