superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 1 and PARK_NAME = "Dos Palmas Area of Critical Environmental Concern"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14422 | 14422 | 14421 | {"type": "MultiPolygon", "coordinates": [[[[-115.78321, 33.44046], [-115.78316, 33.44832], [-115.76464, 33.44898], [-115.76464, 33.4417], [-115.78321, 33.44046]]], [[[-115.77388, 33.45584], [-115.77386, 33.46303], [-115.76465, 33.46354], [-115.76465, 33.45626], [-115.77388, 33.45584]]], [[[-115.85252, 33.51076], [-115.83465, 33.51079], [-115.83502, 33.52542], [-115.81741, 33.52547], [-115.81703, 33.51085], [-115.79957, 33.51096], [-115.79965, 33.49967], [-115.7996, 33.49245], [-115.80831, 33.49243], [-115.80829, 33.48881], [-115.81701, 33.48879], [-115.81704, 33.49241], [-115.81053, 33.49243], [-115.81054, 33.49605], [-115.80836, 33.49605], [-115.80835, 33.49607], [-115.80838, 33.49968], [-115.81709, 33.49969], [-115.81707, 33.50334], [-115.81271, 33.50334], [-115.81269, 33.50642], [-115.81174, 33.50609], [-115.81117, 33.50592], [-115.81001, 33.50564], [-115.80942, 33.50552], [-115.80828, 33.50534], [-115.80826, 33.50561], [-115.80935, 33.50579], [-115.80992, 33.5059], [-115.81106, 33.50618], [-115.81163, 33.50635], [-115.81269, 33.50672], [-115.8127, 33.50699], [-115.81705, 33.507], [-115.81705, 33.51085], [-115.82588, 33.51079], [-115.82578, 33.49967], [-115.8258, 33.49966], [-115.82569, 33.48508], [-115.79955, 33.48515], [-115.79979, 33.47773], [-115.79977, 33.47772], [-115.79144, 33.48149], [-115.79135, 33.48498], [-115.79085, 33.48497], [-115.79083, 33.48499], [-115.79094, 33.49983], [-115.78223, 33.5], [-115.78262, 33.48482], [-115.76466, 33.48538], [-115.76466, 33.47082], [-115.77842, 33.46992], [-115.77845, 33.46635], [-115.78305, 33.46607], [-115.78316, 33.44835], [-115.8003, 33.44836], [-115.80026, 33.44125], [-115.81733, 33.44127], [-115.81769, 33.45551], [-115.79184, 33.45546], [-115.79175, 33.46966], [-115.79146, 33.48084], [-115.79148, 33.48084], [-115.79899, 33.47745], [-115.79899, 33.47743], [-115.79802, 33.47742], [-115.79983, 33.4764], [-115.80005, 33.46969], [-115.80022, 33.46258], [-115.8176, 33.46263], [-115.8175, 33.46975], [-115.81724, 33.47742], [-115.82592, 33.47756], [-115.82577, 33.48507], [-115.83449, 33.48504], [-115.8513, 33.48518], [-115.85132, 33.48575], [-115.852, 33.48576], [-115.85231, 33.49799], [-115.85012, 33.49797], [-115.8501, 33.49798], [-115.85015, 33.49978], [-115.85235, 33.49981], [-115.85252, 33.51076]], [[-115.84518, 33.50711], [-115.8452, 33.50709], [-115.84508, 33.49975], [-115.83891, 33.49969], [-115.8389, 33.496], [-115.8345, 33.49596], [-115.83449, 33.49966], [-115.83455, 33.50346], [-115.84107, 33.50346], [-115.84112, 33.50711], [-115.84518, 33.50711]]], [[[-115.80473, 33.45904], [-115.8047, 33.46082], [-115.80257, 33.46081], [-115.80261, 33.45903], [-115.80473, 33.45904]]], [[[-115.81322, 33.45906], [-115.81318, 33.46084], [-115.81106, 33.46083], [-115.81109, 33.45906], [-115.81322, 33.45906]]], [[[-115.85255, 33.45598], [-115.85205, 33.47058], [-115.85202, 33.47781], [-115.8434, 33.47768], [-115.84342, 33.47046], [-115.8348, 33.47032], [-115.83499, 33.4556], [-115.8375, 33.45565], [-115.83733, 33.45978], [-115.83734, 33.45979], [-115.83945, 33.45978], [-115.83962, 33.4557], [-115.85255, 33.45598]]]]} | Open Access 1 | Dos Palmas Area of Critical Environmental Concern | 33262 | 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 | 8077.229 | Dos Palmas Area of Critical Environmental Concern | 2016 |
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]);