units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "7795.792", DES_TP = 55 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency · 1 ✖
MNG_AGENCY 1
DES_TP 1
- State Resource Management Area · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8126 | 8126 | 8125 | {"type": "MultiPolygon", "coordinates": [[[[-114.68296, 34.3398], [-114.6829, 34.35425], [-114.66553, 34.35431], [-114.66563, 34.33982], [-114.68296, 34.3398]]], [[[-114.68326, 34.51393], [-114.68325, 34.52852], [-114.66592, 34.52856], [-114.66591, 34.51398], [-114.68326, 34.51393]]], [[[-114.7991, 34.61705], [-114.7905, 34.61714], [-114.78964, 34.60968], [-114.79824, 34.60959], [-114.7991, 34.61705]]], [[[-114.88529, 35.17127], [-114.86761, 35.17123], [-114.86761, 35.15694], [-114.88528, 35.15695], [-114.88529, 35.17127]]], [[[-114.89428, 35.13283], [-114.87683, 35.13283], [-114.87681, 35.11849], [-114.88106, 35.11848], [-114.88548, 35.1185], [-114.89428, 35.11847], [-114.89425, 35.12797], [-114.89428, 35.13283]]], [[[-114.90745, 34.70247], [-114.89003, 34.70345], [-114.89002, 34.70331], [-114.88985, 34.70332], [-114.88985, 34.68886], [-114.90723, 34.68779], [-114.90724, 34.68794], [-114.90742, 34.68793], [-114.90745, 34.70247]]], [[[-114.90784, 34.96717], [-114.90772, 34.96717], [-114.90772, 34.96727], [-114.89044, 34.96737], [-114.89047, 34.95306], [-114.90783, 34.95295], [-114.90784, 34.96717]]], [[[-114.95009, 34.7308], [-114.95002, 34.7454], [-114.93246, 34.74534], [-114.93246, 34.74521], [-114.93228, 34.7452], [-114.93231, 34.73056], [-114.94991, 34.73067], [-114.94991, 34.7308], [-114.95009, 34.7308]]], [[[-114.95011, 34.64364], [-114.95011, 34.65819], [-114.93256, 34.65819], [-114.93254, 34.64359], [-114.95011, 34.64364]]], [[[-114.95123, 34.55668], [-114.95122, 34.57118], [-114.93355, 34.57114], [-114.9337, 34.55663], [-114.95123, 34.55668]]], [[[-114.99959, 34.51577], [-114.99957, 34.53029], [-114.98195, 34.53015], [-114.98202, 34.51566], [-114.99959, 34.51577]]], [[[-115.05707, 34.57155], [-115.03971, 34.57147], [-115.03971, 34.5571], [-115.05707, 34.55719], [-115.05707, 34.57155]]], [[[-115.26678, 34.83271], [-115.24935, 34.8326], [-115.24934, 34.83047], [-115.24988, 34.81813], [-115.26674, 34.81823], [-115.2668, 34.82226], [-115.26678, 34.83271]]]]} | No Public Access 3 | 12300 | East Mojave Desert | 32154 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 7795.792 | East Mojave Desert | 0 | State Resource Management Area 55 | 3 |
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]);