units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LAYER = 1, MNG_AGENCY = 25 and YR_EST = 1989
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16994 | 16994 | 16993 | {"type": "Polygon", "coordinates": [[[-115.66703, 34.62486], [-115.66657, 34.6463], [-115.6658, 34.64635], [-115.66576, 34.66042], [-115.66559, 34.66042], [-115.66559, 34.66059], [-115.6656, 34.6606], [-115.66576, 34.66059], [-115.66577, 34.66074], [-115.66626, 34.6607], [-115.66533, 34.70415], [-115.65997, 34.70529], [-115.65749, 34.70532], [-115.64685, 34.70309], [-115.63455, 34.70275], [-115.6319, 34.7025], [-115.63217, 34.68946], [-115.61509, 34.6895], [-115.61478, 34.70057], [-115.56321, 34.69101], [-115.56468, 34.6604], [-115.58174, 34.66045], [-115.58217, 34.64588], [-115.56456, 34.64577], [-115.56455, 34.64589], [-115.56436, 34.64589], [-115.56436, 34.64575], [-115.47846, 34.64556], [-115.47848, 34.64511], [-115.47847, 34.6451], [-115.46103, 34.64563], [-115.46152, 34.58392], [-115.4617, 34.58405], [-115.47747, 34.5728], [-115.47922, 34.57281], [-115.47923, 34.5727], [-115.48788, 34.57261], [-115.48798, 34.56926], [-115.48806, 34.56561], [-115.49701, 34.55839], [-115.51456, 34.55844], [-115.51454, 34.56278], [-115.51448, 34.56938], [-115.51438, 34.5731], [-115.53183, 34.57324], [-115.53192, 34.56946], [-115.55022, 34.56967], [-115.5504, 34.57333], [-115.55902, 34.57335], [-115.55876, 34.56599], [-115.56316, 34.56599], [-115.56317, 34.56598], [-115.56301, 34.56235], [-115.55863, 34.56233], [-115.5585, 34.55884], [-115.56723, 34.55891], [-115.56679, 34.57338], [-115.5664, 34.58767], [-115.56641, 34.58768], [-115.58388, 34.58772], [-115.58447, 34.5697], [-115.58478, 34.55905], [-115.61871, 34.5593], [-115.61832, 34.57341], [-115.61833, 34.57342], [-115.63534, 34.57348], [-115.63576, 34.55923], [-115.64155, 34.55926], [-115.64159, 34.55947], [-115.64347, 34.57353], [-115.63535, 34.57349], [-115.63493, 34.58782], [-115.64661, 34.5879], [-115.66703, 34.62486]], [[-115.54964, 34.604], [-115.55447, 34.604], [-115.55451, 34.6007], [-115.55446, 34.59904], [-115.54928, 34.59906], [-115.54452, 34.59902], [-115.54452, 34.60216], [-115.53138, 34.60212], [-115.53159, 34.59497], [-115.52273, 34.59494], [-115.52243, 34.60207], [-115.51389, 34.60205], [-115.51352, 34.61654], [-115.54934, 34.61664], [-115.54964, 34.604]], [[-115.52025, 34.60039], [-115.5204, 34.59678], [-115.51593, 34.59673], [-115.51579, 34.60036], [-115.52025, 34.60039]], [[-115.55039, 34.57334], [-115.55038, 34.57333], [-115.53185, 34.57324], [-115.53159, 34.58403], [-115.53152, 34.5875], [-115.53154, 34.58752], [-115.54997, 34.5876], [-115.55039, 34.57334]], [[-115.63406, 34.61698], [-115.63448, 34.60252], [-115.6175, 34.60247], [-115.61711, 34.61699], [-115.63406, 34.61698]], [[-115.65133, 34.61716], [-115.65132, 34.61715], [-115.63407, 34.61698], [-115.63365, 34.63134], [-115.65093, 34.63166], [-115.65095, 34.63138], [-115.65133, 34.61716]]]} | Open Access 1 | 25323 | Marble Mountains Wildlife Area | 30470 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 46326.696 | Marble Mtns. Wildlife Area | 1989 | State Conservation Area 8 | 2 |
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]);