units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 105 and MNG_AG_TYP = 16 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Irrigation District · 1 ✖
MNG_AGENCY 1
LABEL_NAME 1 ✖
DES_TP 1
- National Wildlife Refuge · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15809 | 15809 | 15808 | {"type": "MultiPolygon", "coordinates": [[[[-115.63163, 33.19095], [-115.6144, 33.191], [-115.61443, 33.2056], [-115.59713, 33.20562], [-115.5972, 33.19108], [-115.5972, 33.18382], [-115.61447, 33.18381], [-115.61454, 33.17663], [-115.62301, 33.17662], [-115.62302, 33.16938], [-115.63151, 33.16937], [-115.63147, 33.17661], [-115.63163, 33.19095]]], [[[-115.66647, 33.19104], [-115.66645, 33.2056], [-115.64891, 33.20566], [-115.6489, 33.20569], [-115.64885, 33.2057], [-115.64879, 33.22008], [-115.63179, 33.22008], [-115.63178, 33.22013], [-115.63178, 33.23461], [-115.61433, 33.23471], [-115.61437, 33.22014], [-115.62588, 33.2201], [-115.63177, 33.22012], [-115.63169, 33.20562], [-115.64885, 33.20569], [-115.64877, 33.19098], [-115.66647, 33.19104]]], [[[-115.7311, 33.08957], [-115.73106, 33.09675], [-115.73101, 33.09684], [-115.72246, 33.09683], [-115.72244, 33.10411], [-115.70084, 33.10413], [-115.70083, 33.1186], [-115.68339, 33.11864], [-115.68339, 33.13303], [-115.68349, 33.14739], [-115.69213, 33.14742], [-115.69213, 33.15473], [-115.68349, 33.15472], [-115.68348, 33.1474], [-115.66632, 33.14745], [-115.6663, 33.13299], [-115.66633, 33.12578], [-115.6706, 33.12579], [-115.67062, 33.11859], [-115.68339, 33.11863], [-115.68355, 33.10408], [-115.68354, 33.10044], [-115.68787, 33.10044], [-115.68787, 33.08953], [-115.69223, 33.08954], [-115.69223, 33.09318], [-115.7009, 33.0932], [-115.70094, 33.08956], [-115.71774, 33.08956], [-115.71816, 33.08953], [-115.7311, 33.08957]]], [[[-115.71804, 33.16202], [-115.70088, 33.16204], [-115.70087, 33.16205], [-115.70076, 33.16206], [-115.70072, 33.17656], [-115.68364, 33.17653], [-115.68363, 33.17655], [-115.68352, 33.17655], [-115.68349, 33.16204], [-115.70075, 33.16205], [-115.70077, 33.14743], [-115.71803, 33.14745], [-115.71804, 33.16202]]], [[[-115.75251, 33.23471], [-115.75249, 33.24929], [-115.75081, 33.24922], [-115.73556, 33.24917], [-115.73553, 33.23463], [-115.7355, 33.23461], [-115.71832, 33.2346], [-115.71831, 33.23462], [-115.71822, 33.23463], [-115.71817, 33.24918], [-115.70103, 33.24913], [-115.70107, 33.23468], [-115.71821, 33.23462], [-115.71822, 33.2346], [-115.71831, 33.23459], [-115.71827, 33.22006], [-115.73548, 33.22009], [-115.73543, 33.20556], [-115.75235, 33.20575], [-115.75237, 33.22024], [-115.75082, 33.22017], [-115.73548, 33.2201], [-115.73553, 33.2346], [-115.73559, 33.23462], [-115.75246, 33.23475], [-115.75247, 33.23471], [-115.75251, 33.23471]]], [[[-115.77013, 33.17658], [-115.75241, 33.17654], [-115.75236, 33.16205], [-115.75229, 33.16205], [-115.75228, 33.16202], [-115.75142, 33.16202], [-115.75082, 33.16201], [-115.73539, 33.16202], [-115.73536, 33.14746], [-115.73529, 33.14745], [-115.73529, 33.14742], [-115.73536, 33.14742], [-115.73537, 33.14745], [-115.75242, 33.14742], [-115.75236, 33.16205], [-115.7701, 33.162], [-115.77008, 33.16923], [-115.77013, 33.17658]]], [[[-115.83922, 33.2347], [-115.82193, 33.23467], [-115.82184, 33.25008], [-115.8218, 33.25074], [-115.80456, 33.25072], [-115.80458, 33.25007], [-115.80462, 33.2347], [-115.78738, 33.23468], [-115.78737, 33.22012], [-115.77008, 33.22014], [-115.77008, 33.20569], [-115.78738, 33.2057], [-115.78738, 33.22013], [-115.80464, 33.22014], [-115.80465, 33.22013], [-115.80464, 33.20572], [-115.80463, 33.20569], [-115.822, 33.20566], [-115.82195, 33.22014], [-115.83921, 33.22016], [-115.83922, 33.2347]], [[-115.82195, 33.22015], [-115.80465, 33.22014], [-115.80462, 33.23469], [-115.82192, 33.23467], [-115.82195, 33.22015]]], [[[-115.78737, 33.23469], [-115.78727, 33.25067], [-115.77001, 33.25062], [-115.76999, 33.25005], [-115.77008, 33.23472], [-115.78737, 33.23469]]], [[[-115.82198, 33.1766], [-115.82196, 33.17661], [-115.82195, 33.19107], [-115.80467, 33.19122], [-115.80478, 33.17658], [-115.78742, 33.17653], [-115.78748, 33.16924], [-115.7875, 33.16199], [-115.80481, 33.16192], [-115.80479, 33.17657], [-115.82198, 33.1766]]]]} | Open Access 1 | 12950 | Sonny Bono Salton Sea National Wildlife Refuge | 4597 | 2048 | Imperial Irrigation District 379 | Special District 4 | Irrigation District 17 | http://www.iid.com/ | Special District 4 | 2048 | Imperial Irrigation District 374 | Special District 4 | Irrigation District 16 | http://www.fws.gov/refuge/sonny_bono_salton_sea/ | Imperial 20 | 17446.028 | Sonny Bono Salton Sea NWR | 1930 | National Wildlife Refuge 105 | 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]);