units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where AGNCY_TYP = 1 and COUNTY = 12
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME
MNG_AGENCY 4
DES_TP 4
MNG_AG_TYP 2
ACCESS_TYP 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1449 | 1449 | 1448 | {"type": "Polygon", "coordinates": [[[-122.0, 38.01821], [-122.0, 38.01915], [-121.99675, 38.01907], [-121.99669, 38.01818], [-122.0, 38.01821]]]} | Open Access 1 | 9654 | BLM | 16162 | 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 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Contra Costa 12 | 7.245 | BLM | 1899 | National Public Lands 1 | 3 | |
5580 | 5580 | 5579 | {"type": "Polygon", "coordinates": [[[-121.95567, 37.92322], [-121.95099, 37.92324], [-121.9509, 37.91961], [-121.95562, 37.91959], [-121.95567, 37.92322]]]} | Restricted Access 2 | 29557 | BLM | 16163 | 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 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Contra Costa 12 | 41.201 | BLM | 1963 | National Public Lands 1 | 3 | |
9816 | 9816 | 9815 | {"type": "Polygon", "coordinates": [[[-122.13967, 37.98084], [-122.1396, 37.98692], [-122.13961, 37.98736], [-122.13778, 37.98743], [-122.13619, 37.98761], [-122.13613, 37.98749], [-122.13336, 37.9885], [-122.13194, 37.9889], [-122.13193, 37.98891], [-122.13198, 37.98902], [-122.13012, 37.98952], [-122.1298, 37.98929], [-122.12968, 37.98924], [-122.12951, 37.98922], [-122.12828, 37.98661], [-122.12717, 37.98479], [-122.1264, 37.98396], [-122.12604, 37.98333], [-122.12492, 37.98085], [-122.1249, 37.98011], [-122.12504, 37.97992], [-122.12538, 37.97956], [-122.12594, 37.97906], [-122.12647, 37.97812], [-122.12629, 37.97765], [-122.12653, 37.97673], [-122.12655, 37.97617], [-122.12693, 37.9756], [-122.12723, 37.97528], [-122.12902, 37.976], [-122.13031, 37.97702], [-122.13063, 37.9769], [-122.13173, 37.97702], [-122.13572, 37.97756], [-122.13967, 37.98084]]]} | Open Access 1 | 18113 | John Muir National Historic Site | 14229 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/jomu/index.htm | Contra Costa 12 | 340.84 | John Muir NHS | 1993 | Historic or Cultural Area 350 | 4 |
14323 | 14323 | 14322 | {"type": "Polygon", "coordinates": [[[-122.02864, 37.82513], [-122.02856, 37.8276], [-122.02498, 37.82568], [-122.02473, 37.82523], [-122.02864, 37.82513]]]} | Open Access 1 | 44305 | Eugene O'Neill Historic Site | 14214 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/euon/index.htm | Contra Costa 12 | 12.994 | Eugene O'Neill Historic Site | 0 | Historic or Cultural Area 350 | 4 |
15757 | 15757 | 15756 | {"type": "Polygon", "coordinates": [[[-122.13367, 37.99088], [-122.13367, 37.99134], [-122.13229, 37.99153], [-122.13229, 37.99169], [-122.13226, 37.99211], [-122.13226, 37.99236], [-122.13202, 37.9928], [-122.13178, 37.99307], [-122.13112, 37.99314], [-122.13038, 37.99142], [-122.1326, 37.99068], [-122.13367, 37.99088]]]} | Open Access 1 | 17094 | John Muir National Historic Site | 14229 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/jomu/index.htm | Contra Costa 12 | 9.498 | John Muir NHS | 1993 | Historic or Cultural Area 350 | 4 |
15831 | 15831 | 15830 | {"type": "MultiPolygon", "coordinates": [[[[-121.78465, 38.0124], [-121.78465, 38.01497], [-121.78434, 38.01488], [-121.78288, 38.01481], [-121.7822, 38.01481], [-121.78221, 38.01241], [-121.78465, 38.0124]]], [[[-121.80036, 38.01588], [-121.80029, 38.01594], [-121.80028, 38.01682], [-121.80004, 38.01692], [-121.79962, 38.01682], [-121.79902, 38.01709], [-121.7979, 38.01721], [-121.79723, 38.01706], [-121.79517, 38.01682], [-121.79356, 38.01646], [-121.79153, 38.01579], [-121.79155, 38.0136], [-121.79168, 38.0136], [-121.79179, 38.01355], [-121.79182, 38.01351], [-121.79184, 38.01342], [-121.7918, 38.01335], [-121.79172, 38.01329], [-121.79172, 38.01326], [-121.79496, 38.01395], [-121.79495, 38.01546], [-121.79509, 38.0155], [-121.79588, 38.01559], [-121.79633, 38.01558], [-121.79678, 38.0155], [-121.79682, 38.01544], [-121.7977, 38.01563], [-121.79804, 38.01569], [-121.79848, 38.01573], [-121.79876, 38.01573], [-121.79903, 38.0157], [-121.79905, 38.01511], [-121.79926, 38.01495], [-121.80036, 38.01588]]]]} | Restricted Access 2 | 17082 | Antioch Dunes National Wildlife Refuge | 15523 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Contra Costa 12 | 55.567 | Antioch Dunes NWR | 1980 | National Wildlife Refuge 105 | 2 | |
16336 | 16336 | 16335 | {"type": "Polygon", "coordinates": [[[-121.83759, 37.97592], [-121.83299, 37.97585], [-121.82581, 37.9799], [-121.82385, 37.97979], [-121.82383, 37.97965], [-121.82147, 37.97953], [-121.82006, 37.97971], [-121.81763, 37.97959], [-121.8175, 37.97959], [-121.81684, 37.97977], [-121.81672, 37.97978], [-121.8147, 37.97943], [-121.81469, 37.97946], [-121.8142, 37.97938], [-121.81292, 37.97929], [-121.8128, 37.97929], [-121.81268, 37.97931], [-121.81191, 37.97964], [-121.81095, 37.9796], [-121.81049, 37.9796], [-121.80944, 37.97821], [-121.81013, 37.97849], [-121.81346, 37.97593], [-121.81438, 37.97557], [-121.81433, 37.96849], [-121.80559, 37.96849], [-121.80559, 37.9677], [-121.80563, 37.96767], [-121.80647, 37.96768], [-121.80719, 37.96766], [-121.80791, 37.96758], [-121.80861, 37.96745], [-121.80929, 37.96725], [-121.80994, 37.967], [-121.81055, 37.9667], [-121.81094, 37.96647], [-121.81179, 37.96593], [-121.81205, 37.96578], [-121.81225, 37.9657], [-121.81245, 37.96564], [-121.81288, 37.96556], [-121.82247, 37.96552], [-121.82255, 37.96573], [-121.82385, 37.96572], [-121.82386, 37.9656], [-121.83352, 37.96573], [-121.83382, 37.96588], [-121.83445, 37.96601], [-121.8375, 37.96763], [-121.83762, 37.96865], [-121.83759, 37.97592]]]} | Open Access 1 | 14204 | Contra Loma Regional Park | 13801 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/contra_loma | Contra Costa 12 | 767.487 | Contra Loma RP | 1968 | Local Park 2 | 4 |
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]);