superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Cypress Mtn. Natural Area" and MNG_AGENCY = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15496 | 15496 | 15495 | {"type": "MultiPolygon", "coordinates": [[[[-120.96273, 35.60361], [-120.96271, 35.60713], [-120.95836, 35.60702], [-120.95844, 35.61045], [-120.95429, 35.61023], [-120.95415, 35.60679], [-120.94985, 35.60655], [-120.94983, 35.60657], [-120.94996, 35.61005], [-120.94566, 35.60986], [-120.93796, 35.60988], [-120.93801, 35.6062], [-120.94277, 35.60623], [-120.94269, 35.60249], [-120.92903, 35.60221], [-120.92436, 35.60208], [-120.92442, 35.5942], [-120.9233, 35.59408], [-120.92287, 35.59058], [-120.92739, 35.5904], [-120.92768, 35.59447], [-120.93814, 35.59539], [-120.93804, 35.59881], [-120.94261, 35.59879], [-120.94271, 35.60248], [-120.94543, 35.60252], [-120.94524, 35.59601], [-120.95809, 35.59654], [-120.95823, 35.60342], [-120.96273, 35.60361]]], [[[-120.94475, 35.5896], [-120.94126, 35.58977], [-120.94098, 35.58624], [-120.94449, 35.58608], [-120.94475, 35.5896]]], [[[-120.96337, 35.62004], [-120.95981, 35.61993], [-120.95943, 35.6174], [-120.95534, 35.6172], [-120.9548, 35.61378], [-120.95895, 35.61399], [-120.95944, 35.6174], [-120.96312, 35.61759], [-120.96337, 35.62004]]]]} | Open Access 1 | Cypress Mountain Natural Area | 17875 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 962.51 | Cypress Mtn. Natural Area |
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]);