superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "5.2", MNG_AGENCY = 692 and MNG_AG_LEV = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2406 | 2406 | 2405 | {"type": "MultiPolygon", "coordinates": [[[[-121.58252, 39.5047], [-121.58152, 39.50417], [-121.58125, 39.50406], [-121.58096, 39.50397], [-121.58066, 39.5039], [-121.5803, 39.50387], [-121.57994, 39.50387], [-121.57947, 39.50391], [-121.57941, 39.5036], [-121.57999, 39.50356], [-121.58046, 39.50359], [-121.58091, 39.50366], [-121.58135, 39.50379], [-121.58175, 39.50396], [-121.58251, 39.50437], [-121.58252, 39.5047]]], [[[-121.58689, 39.50659], [-121.58597, 39.50659], [-121.58558, 39.50636], [-121.58371, 39.50535], [-121.58312, 39.505], [-121.58274, 39.50481], [-121.58273, 39.50448], [-121.58332, 39.50478], [-121.58395, 39.50515], [-121.58561, 39.50605], [-121.58613, 39.50629], [-121.58689, 39.50659]]]]} | Open Access 1 | Butte holding 36 | 16580 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 5.2 | Butte holding 36 |
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]);