units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 2, LAYER = 5 and MNG_AG_TYP = 1
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15853 | 15853 | 15852 | {"type": "Polygon", "coordinates": [[[-122.40701, 38.1558], [-122.4061, 38.15579], [-122.40609, 38.15581], [-122.40612, 38.15588], [-122.40423, 38.15594], [-122.40393, 38.15584], [-122.3963, 38.15586], [-122.36626, 38.15587], [-122.36687, 38.15482], [-122.36715, 38.15402], [-122.36716, 38.1538], [-122.36714, 38.15358], [-122.36709, 38.15336], [-122.36705, 38.15322], [-122.36685, 38.15288], [-122.36669, 38.15269], [-122.36638, 38.15247], [-122.36605, 38.1523], [-122.36565, 38.15225], [-122.36541, 38.15224], [-122.36505, 38.15233], [-122.36429, 38.15258], [-122.36438, 38.15181], [-122.36434, 38.15055], [-122.36431, 38.14595], [-122.36426, 38.14285], [-122.36434, 38.14207], [-122.36437, 38.14169], [-122.36576, 38.14221], [-122.36811, 38.14332], [-122.3696, 38.14394], [-122.37114, 38.14428], [-122.3755, 38.14554], [-122.37617, 38.14592], [-122.37659, 38.14629], [-122.37756, 38.14698], [-122.37939, 38.14793], [-122.38052, 38.14854], [-122.38053, 38.14853], [-122.38055, 38.14606], [-122.38003, 38.14598], [-122.37858, 38.14525], [-122.37742, 38.14504], [-122.37609, 38.14458], [-122.37307, 38.14323], [-122.36585, 38.14046], [-122.36362, 38.13981], [-122.36295, 38.13953], [-122.36133, 38.13896], [-122.36078, 38.13868], [-122.3602, 38.13857], [-122.35958, 38.13826], [-122.35892, 38.1379], [-122.35782, 38.13749], [-122.35577, 38.13678], [-122.35534, 38.13661], [-122.35486, 38.13658], [-122.35396, 38.13625], [-122.35318, 38.136], [-122.35183, 38.13539], [-122.35053, 38.13484], [-122.34938, 38.13437], [-122.34845, 38.13391], [-122.34763, 38.13358], [-122.3463, 38.13314], [-122.34561, 38.13282], [-122.34488, 38.13241], [-122.34449, 38.13229], [-122.34435, 38.13223], [-122.34434, 38.13224], [-122.34433, 38.13458], [-122.33483, 38.13109], [-122.32238, 38.12607], [-122.31734, 38.12411], [-122.31156, 38.12166], [-122.31076, 38.12118], [-122.30995, 38.12073], [-122.30911, 38.1203], [-122.30825, 38.1199], [-122.30738, 38.11952], [-122.30649, 38.11916], [-122.30559, 38.11883], [-122.30467, 38.11852], [-122.30374, 38.11824], [-122.30162, 38.11788], [-122.30003, 38.11771], [-122.29842, 38.11765], [-122.29514, 38.11767], [-122.29517, 38.12202], [-122.29391, 38.12176], [-122.29147, 38.12115], [-122.29096, 38.12095], [-122.28991, 38.12067], [-122.28949, 38.1205], [-122.28948, 38.12051], [-122.28961, 38.12104], [-122.28905, 38.12096], [-122.28843, 38.12096], [-122.28752, 38.12099], [-122.28684, 38.12105], [-122.28634, 38.12112], [-122.28545, 38.12115], [-122.28516, 38.12112], [-122.28475, 38.12104], [-122.28445, 38.12092], [-122.28428, 38.12081], [-122.28424, 38.12066], [-122.28424, 38.12054], [-122.28442, 38.12047], [-122.28489, 38.12022], [-122.2849, 38.12015], [-122.28483, 38.12013], [-122.28473, 38.12014], [-122.28458, 38.1202], [-122.28436, 38.12025], [-122.28389, 38.12032], [-122.28372, 38.12027], [-122.28358, 38.12021], [-122.28348, 38.12004], [-122.28343, 38.11989], [-122.28331, 38.11964], [-122.2837, 38.11942], [-122.28408, 38.11929], [-122.28482, 38.11962], [-122.28624, 38.11904], [-122.28761, 38.11865], [-122.28884, 38.11843], [-122.28879, 38.11821], [-122.2892, 38.11772], [-122.29018, 38.11765], [-122.29513, 38.11767], [-122.29515, 38.11712], [-122.29842, 38.11716], [-122.30296, 38.1171], [-122.30355, 38.11722], [-122.30514, 38.11791], [-122.30785, 38.11928], [-122.31264, 38.12161], [-122.3168, 38.12337], [-122.31755, 38.1222], [-122.31754, 38.12218], [-122.31088, 38.11879], [-122.3078, 38.11718], [-122.30626, 38.11634], [-122.30514, 38.11566], [-122.30214, 38.11361], [-122.29654, 38.11052], [-122.30158, 38.10554], [-122.37487, 38.10534], [-122.37578, 38.10654], [-122.37608, 38.10703], [-122.37609, 38.10709], [-122.37881, 38.1114], [-122.38859, 38.12709], [-122.39096, 38.13086], [-122.39201, 38.13255], [-122.39286, 38.13382], [-122.39433, 38.13619], [-122.39494, 38.13713], [-122.39602, 38.13888], [-122.3965, 38.13957], [-122.39688, 38.14018], [-122.39728, 38.14077], [-122.39768, 38.14148], [-122.3981, 38.14212], [-122.39867, 38.14315], [-122.39947, 38.14445], [-122.39999, 38.14523], [-122.40043, 38.14576], [-122.40084, 38.14642], [-122.40133, 38.14727], [-122.40173, 38.14786], [-122.40201, 38.14838], [-122.40308, 38.14995], [-122.40338, 38.15027], [-122.40366, 38.15067], [-122.40393, 38.15092], [-122.40435, 38.15143], [-122.40492, 38.15219], [-122.40548, 38.15285], [-122.40584, 38.1534], [-122.40649, 38.15446], [-122.40701, 38.1558]]]} | Restricted Access 2 | 44494 | San Pablo Bay National Wildlife Refuge | 24964 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Solano 26 | 6803.264 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
| 15855 | 15855 | 15854 | {"type": "Polygon", "coordinates": [[[-122.40525, 38.15593], [-122.40518, 38.15666], [-122.40508, 38.15728], [-122.40499, 38.15753], [-122.40485, 38.15777], [-122.4046, 38.15805], [-122.40434, 38.15824], [-122.40366, 38.15857], [-122.40302, 38.15881], [-122.40228, 38.159], [-122.40151, 38.15906], [-122.39974, 38.15901], [-122.39583, 38.15898], [-122.39499, 38.159], [-122.39251, 38.15914], [-122.39105, 38.15916], [-122.38851, 38.15912], [-122.38645, 38.15901], [-122.38456, 38.15884], [-122.38322, 38.15866], [-122.38237, 38.15848], [-122.38056, 38.15787], [-122.37873, 38.15751], [-122.37574, 38.15745], [-122.37394, 38.15744], [-122.37281, 38.15745], [-122.37204, 38.15748], [-122.37137, 38.15755], [-122.37074, 38.15771], [-122.36935, 38.15815], [-122.36896, 38.15829], [-122.36834, 38.15854], [-122.36712, 38.1591], [-122.3662, 38.15877], [-122.36573, 38.15817], [-122.36558, 38.15777], [-122.36522, 38.15586], [-122.38279, 38.15589], [-122.40393, 38.15584], [-122.40423, 38.15594], [-122.40525, 38.15593]]]} | Restricted Access 2 | 44496 | San Pablo Bay National Wildlife Refuge | 24964 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Napa 11 | 249.551 | San Pablo Bay NWR | 1970 | 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]);