units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 2, DES_TP = 8 and MNG_AG_TYP = 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5955 | 5955 | 5954 | {"type": "Polygon", "coordinates": [[[-120.98655, 37.40316], [-120.98645, 37.4037], [-120.9858, 37.40327], [-120.98326, 37.4014], [-120.98204, 37.40081], [-120.98154, 37.40063], [-120.98443, 37.39949], [-120.98456, 37.39989], [-120.98467, 37.40012], [-120.98472, 37.40027], [-120.98493, 37.40061], [-120.98501, 37.40078], [-120.98513, 37.40095], [-120.98522, 37.40114], [-120.98557, 37.40154], [-120.98567, 37.40168], [-120.98599, 37.40248], [-120.98621, 37.40281], [-120.98643, 37.40306], [-120.98655, 37.40316]]]} | Open Access 1 | 518 | West Hilmar Wildlife Area | 30516 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/West-Hilmar-WA | Stanislaus 2 | 16.656 | West Hilmar Wildlife Area | 1994 | State Conservation Area 8 | 2 |
16685 | 16685 | 16684 | {"type": "MultiPolygon", "coordinates": [[[[-120.97841, 37.3416], [-120.97836, 37.34177], [-120.97784, 37.34216], [-120.97724, 37.34226], [-120.97631, 37.34346], [-120.97602, 37.34421], [-120.97597, 37.34438], [-120.97593, 37.34444], [-120.97592, 37.34454], [-120.97571, 37.34488], [-120.97566, 37.34507], [-120.97566, 37.34529], [-120.97585, 37.34562], [-120.97595, 37.3457], [-120.9761, 37.34578], [-120.97616, 37.34583], [-120.97623, 37.34593], [-120.97631, 37.34599], [-120.97645, 37.34618], [-120.9765, 37.34622], [-120.97653, 37.3465], [-120.97648, 37.34664], [-120.97638, 37.34675], [-120.97592, 37.34681], [-120.97522, 37.34713], [-120.97439, 37.34803], [-120.97413, 37.34834], [-120.97409, 37.349], [-120.97401, 37.34925], [-120.97384, 37.34926], [-120.9733, 37.34921], [-120.97302, 37.34913], [-120.97249, 37.34892], [-120.97213, 37.34876], [-120.97184, 37.3486], [-120.97152, 37.34829], [-120.97138, 37.34808], [-120.97134, 37.34775], [-120.97134, 37.34749], [-120.97126, 37.34733], [-120.97109, 37.34711], [-120.96997, 37.34605], [-120.96958, 37.34575], [-120.96932, 37.34557], [-120.96885, 37.34538], [-120.9684, 37.34534], [-120.96801, 37.34533], [-120.96768, 37.34541], [-120.96728, 37.34554], [-120.96644, 37.34592], [-120.966, 37.34606], [-120.9657, 37.34614], [-120.96509, 37.34611], [-120.96489, 37.34605], [-120.96472, 37.34591], [-120.96458, 37.34575], [-120.96456, 37.3457], [-120.96414, 37.34562], [-120.96368, 37.34567], [-120.96483, 37.34478], [-120.96516, 37.34488], [-120.96913, 37.34174], [-120.97186, 37.33963], [-120.97223, 37.34008], [-120.9724, 37.34033], [-120.97254, 37.34045], [-120.9729, 37.34067], [-120.97314, 37.34073], [-120.97354, 37.34078], [-120.97394, 37.34076], [-120.97433, 37.34066], [-120.97448, 37.34049], [-120.9746, 37.34029], [-120.97481, 37.34028], [-120.97511, 37.34037], [-120.97545, 37.34056], [-120.97565, 37.34081], [-120.97561, 37.34127], [-120.97572, 37.34147], [-120.97589, 37.34162], [-120.97629, 37.34168], [-120.97656, 37.34166], [-120.97675, 37.34156], [-120.97696, 37.34126], [-120.97724, 37.34099], [-120.97745, 37.34086], [-120.97767, 37.3408], [-120.97841, 37.3416]]], [[[-120.98615, 37.33757], [-120.98331, 37.3402], [-120.98007, 37.33795], [-120.97985, 37.33808], [-120.97922, 37.33829], [-120.97886, 37.33864], [-120.9787, 37.33868], [-120.97846, 37.33862], [-120.97829, 37.33845], [-120.97835, 37.33802], [-120.9782, 37.33758], [-120.97827, 37.33732], [-120.97864, 37.33699], [-120.9787, 37.33671], [-120.97849, 37.33651], [-120.97757, 37.33614], [-120.97721, 37.33617], [-120.97642, 37.33657], [-120.97703, 37.33682], [-120.97706, 37.33694], [-120.97694, 37.33726], [-120.9765, 37.3376], [-120.97605, 37.33773], [-120.97615, 37.33803], [-120.97617, 37.3384], [-120.97616, 37.33881], [-120.97622, 37.33908], [-120.97606, 37.33931], [-120.97641, 37.33963], [-120.97653, 37.33999], [-120.9768, 37.34041], [-120.97736, 37.34051], [-120.97778, 37.34046], [-120.97722, 37.34065], [-120.97696, 37.34083], [-120.97683, 37.34099], [-120.97666, 37.34109], [-120.9765, 37.34136], [-120.97641, 37.3414], [-120.9763, 37.34142], [-120.97606, 37.34137], [-120.97598, 37.34132], [-120.97594, 37.34122], [-120.97599, 37.34099], [-120.97599, 37.34083], [-120.9759, 37.34057], [-120.97565, 37.34034], [-120.97522, 37.34011], [-120.97487, 37.34], [-120.97475, 37.33999], [-120.97453, 37.34002], [-120.97436, 37.34007], [-120.9743, 37.34013], [-120.97421, 37.34031], [-120.97413, 37.3404], [-120.97404, 37.34044], [-120.97388, 37.34049], [-120.97357, 37.3405], [-120.97322, 37.34047], [-120.97311, 37.34045], [-120.97279, 37.34026], [-120.97265, 37.34015], [-120.97252, 37.33994], [-120.97224, 37.3396], [-120.97211, 37.33943], [-120.975, 37.33717], [-120.97945, 37.33371], [-120.98484, 37.33624], [-120.98615, 37.33757]]]]} | Open Access 1 | 493 | North Grasslands Wildlife Area | 30482 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/North-Grasslands-WA | Stanislaus 2 | 253.111 | North Grasslands Wildlife Area | 1992 | 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]);