units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where COUNTY = 45 and DES_TP = 39
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, LAYER, MNG_AG_ID, YR_EST
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3144 | 3144 | 3143 | {"type": "Polygon", "coordinates": [[[-124.10173, 40.49177], [-124.09991, 40.49269], [-124.09979, 40.49248], [-124.1004, 40.49204], [-124.10081, 40.4918], [-124.1015, 40.49158], [-124.10173, 40.49177]]]} | Open Access 1 | 21596 | Eel River -- Rio Dell Fishing Access | 32156 | 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 | Humboldt 45 | 1.525 | Eel River -- Rio Dell FA | 0 | State Recreation Area 39 | 4 | |
| 3145 | 3145 | 3144 | {"type": "MultiPolygon", "coordinates": [[[[-124.12175, 41.03989], [-124.12131, 41.03991], [-124.12121, 41.03987], [-124.12108, 41.03988], [-124.12093, 41.03992], [-124.12068, 41.04038], [-124.12061, 41.04044], [-124.12043, 41.04052], [-124.12027, 41.04068], [-124.12019, 41.04085], [-124.12012, 41.04095], [-124.12012, 41.04076], [-124.11999, 41.04031], [-124.11976, 41.04003], [-124.11934, 41.03975], [-124.11887, 41.03953], [-124.11879, 41.03945], [-124.11867, 41.03927], [-124.11859, 41.0391], [-124.11854, 41.03893], [-124.11849, 41.03884], [-124.11888, 41.03883], [-124.11962, 41.0388], [-124.12031, 41.03915], [-124.12093, 41.03936], [-124.1213, 41.03963], [-124.12175, 41.03989]]], [[[-124.12038, 41.04196], [-124.12008, 41.04195], [-124.1199, 41.04196], [-124.11979, 41.04199], [-124.11958, 41.04198], [-124.11972, 41.04168], [-124.11995, 41.04141], [-124.11995, 41.04147], [-124.12003, 41.04161], [-124.12008, 41.04164], [-124.12021, 41.04175], [-124.12038, 41.04196]]]]} | Open Access 1 | 21601 | Luffenholtz Creek Fishing Access | 32210 | 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 | Humboldt 45 | 6.71 | Luffenholtz Creek FA | 0 | State Recreation Area 39 | 4 | |
| 15639 | 15639 | 15638 | {"type": "MultiPolygon", "coordinates": [[[[-123.77482, 40.18351], [-123.77339, 40.18521], [-123.77292, 40.1862], [-123.77241, 40.18737], [-123.77148, 40.18859], [-123.77097, 40.189], [-123.77031, 40.19059], [-123.77002, 40.19148], [-123.77011, 40.19293], [-123.77114, 40.19444], [-123.76896, 40.19433], [-123.76867, 40.19404], [-123.76903, 40.19328], [-123.76916, 40.19245], [-123.76916, 40.19172], [-123.76911, 40.19145], [-123.76887, 40.19146], [-123.76897, 40.19109], [-123.76951, 40.1906], [-123.76952, 40.19017], [-123.76983, 40.18938], [-123.77129, 40.18818], [-123.77164, 40.18773], [-123.77168, 40.18709], [-123.77179, 40.18692], [-123.77214, 40.1862], [-123.77302, 40.18471], [-123.77339, 40.184], [-123.77392, 40.1835], [-123.77482, 40.18351]]], [[[-123.77704, 40.18211], [-123.77516, 40.18275], [-123.77499, 40.18248], [-123.77676, 40.18179], [-123.77704, 40.18211]]], [[[-123.78179, 40.17873], [-123.78177, 40.17879], [-123.78185, 40.17932], [-123.7816, 40.18012], [-123.78034, 40.18038], [-123.7814, 40.17917], [-123.7816, 40.17874], [-123.78179, 40.17873]]], [[[-123.78232, 40.17179], [-123.78261, 40.17241], [-123.78267, 40.17276], [-123.78248, 40.17395], [-123.78221, 40.17459], [-123.78193, 40.17583], [-123.78199, 40.17663], [-123.78188, 40.17722], [-123.78159, 40.17857], [-123.78136, 40.17848], [-123.78169, 40.1757], [-123.7819, 40.17248], [-123.7819, 40.17179], [-123.78232, 40.17179]]]]} | Open Access 1 | 21580 | South Fork Eel River Fishing Access | 32314 | 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 | Humboldt 45 | 35.527 | South Fork Eel River FA | 0 | State Recreation Area 39 | 4 | |
| 16660 | 16660 | 16659 | {"type": "Polygon", "coordinates": [[[-123.82852, 40.06923], [-123.8284, 40.06931], [-123.82833, 40.06939], [-123.82828, 40.06949], [-123.82826, 40.06959], [-123.82827, 40.07021], [-123.82842, 40.07231], [-123.82843, 40.07264], [-123.8284, 40.07297], [-123.82833, 40.0733], [-123.82808, 40.07413], [-123.82689, 40.07376], [-123.82684, 40.0739], [-123.82676, 40.07407], [-123.82658, 40.07434], [-123.8256, 40.07545], [-123.82526, 40.07581], [-123.82483, 40.07622], [-123.82452, 40.07647], [-123.82412, 40.07673], [-123.82374, 40.06606], [-123.80985, 40.06641], [-123.80979, 40.06534], [-123.80793, 40.06484], [-123.80484, 40.06488], [-123.80483, 40.06482], [-123.80471, 40.06483], [-123.8042, 40.0651], [-123.80364, 40.06525], [-123.80347, 40.06558], [-123.80301, 40.06575], [-123.80266, 40.06613], [-123.80256, 40.06617], [-123.80256, 40.06644], [-123.80024, 40.06774], [-123.80024, 40.0678], [-123.80016, 40.06779], [-123.79981, 40.06784], [-123.7995, 40.06776], [-123.79917, 40.06752], [-123.79772, 40.06758], [-123.79738, 40.06753], [-123.79627, 40.06769], [-123.79588, 40.0676], [-123.79569, 40.06768], [-123.79552, 40.06801], [-123.79547, 40.06804], [-123.79534, 40.0674], [-123.7951, 40.06749], [-123.79484, 40.06755], [-123.79474, 40.06762], [-123.7947, 40.0676], [-123.79468, 40.06756], [-123.79457, 40.06756], [-123.79453, 40.06765], [-123.79448, 40.06771], [-123.79439, 40.06774], [-123.79427, 40.06772], [-123.79413, 40.06777], [-123.79392, 40.06782], [-123.79367, 40.06795], [-123.79372, 40.06816], [-123.79287, 40.06815], [-123.7926, 40.06816], [-123.79233, 40.06823], [-123.79191, 40.06816], [-123.79158, 40.06816], [-123.79115, 40.06823], [-123.79111, 40.06822], [-123.79117, 40.06798], [-123.79118, 40.06779], [-123.79115, 40.0676], [-123.79108, 40.06741], [-123.79098, 40.06723], [-123.79085, 40.06707], [-123.7907, 40.06692], [-123.79042, 40.06673], [-123.7903, 40.06668], [-123.79021, 40.06679], [-123.78984, 40.06661], [-123.78964, 40.06684], [-123.78808, 40.06607], [-123.78779, 40.06582], [-123.7876, 40.0656], [-123.78713, 40.06543], [-123.78523, 40.0648], [-123.78464, 40.06456], [-123.78358, 40.06403], [-123.78338, 40.06392], [-123.7832, 40.06379], [-123.78213, 40.06291], [-123.78185, 40.06274], [-123.78164, 40.06264], [-123.78142, 40.06256], [-123.78119, 40.0625], [-123.78087, 40.06245], [-123.78032, 40.06239], [-123.77935, 40.06218], [-123.77916, 40.06213], [-123.77899, 40.06205], [-123.77875, 40.06191], [-123.77863, 40.06179], [-123.77854, 40.06167], [-123.77837, 40.06134], [-123.77835, 40.06121], [-123.77835, 40.06109], [-123.77838, 40.06096], [-123.77863, 40.06044], [-123.7787, 40.06024], [-123.77874, 40.06006], [-123.77886, 40.05898], [-123.77926, 40.05863], [-123.7813, 40.05827], [-123.78128, 40.05728], [-123.7815, 40.05719], [-123.78192, 40.05699], [-123.78352, 40.05645], [-123.78374, 40.0564], [-123.78396, 40.05637], [-123.78418, 40.05636], [-123.7847, 40.05642], [-123.78558, 40.05629], [-123.78578, 40.05624], [-123.78663, 40.05596], [-123.78729, 40.05583], [-123.78786, 40.05578], [-123.78825, 40.05577], [-123.78947, 40.05585], [-123.79003, 40.05584], [-123.79041, 40.0558], [-123.7918, 40.05562], [-123.79169, 40.05432], [-123.79151, 40.05406], [-123.79142, 40.05389], [-123.79137, 40.05372], [-123.79135, 40.05354], [-123.79137, 40.05336], [-123.79164, 40.05219], [-123.79172, 40.0517], [-123.79141, 40.05007], [-123.79106, 40.04968], [-123.79508, 40.05025], [-123.80534, 40.05096], [-123.80536, 40.05429], [-123.81047, 40.05452], [-123.81046, 40.06236], [-123.81511, 40.06221], [-123.82203, 40.06227], [-123.82216, 40.06203], [-123.82224, 40.06162], [-123.82227, 40.06152], [-123.82239, 40.06132], [-123.82246, 40.06124], [-123.82272, 40.06102], [-123.82291, 40.06089], [-123.82318, 40.06078], [-123.82344, 40.06072], [-123.82362, 40.06223], [-123.8255, 40.06223], [-123.82538, 40.06249], [-123.82526, 40.06297], [-123.82519, 40.06337], [-123.82524, 40.06358], [-123.82541, 40.06413], [-123.82557, 40.06458], [-123.8257, 40.06488], [-123.82606, 40.06571], [-123.82615, 40.06587], [-123.82649, 40.06624], [-123.8272, 40.0669], [-123.82734, 40.06707], [-123.82746, 40.06728], [-123.8276, 40.06762], [-123.82788, 40.06854], [-123.82796, 40.06897], [-123.82789, 40.06923], [-123.82852, 40.06923]]]} | Open Access 1 | 20458 | Benbow State Recreation Area | 30556 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=426 | Humboldt 45 | 1137.787 | Benbow SRA | 1958 | State Recreation Area 39 | 4 |
| 16661 | 16661 | 16660 | {"type": "MultiPolygon", "coordinates": [[[[-124.1124, 41.20089], [-124.11204, 41.20192], [-124.11204, 41.20256], [-124.11222, 41.20256], [-124.11238, 41.21322], [-124.10991, 41.21318], [-124.10924, 41.2132], [-124.10963, 41.21092], [-124.11022, 41.21091], [-124.11038, 41.20755], [-124.11095, 41.207], [-124.11037, 41.20464], [-124.10903, 41.20462], [-124.10868, 41.20478], [-124.10886, 41.20683], [-124.10788, 41.21034], [-124.10767, 41.21045], [-124.10741, 41.21049], [-124.10737, 41.20966], [-124.10763, 41.19497], [-124.10316, 41.19499], [-124.10313, 41.19331], [-124.09829, 41.19327], [-124.09844, 41.18766], [-124.10357, 41.18762], [-124.10355, 41.18726], [-124.10368, 41.18398], [-124.10472, 41.18279], [-124.10437, 41.18133], [-124.10396, 41.18068], [-124.1038, 41.18012], [-124.10357, 41.17963], [-124.1022, 41.17826], [-124.10121, 41.17805], [-124.10077, 41.1779], [-124.10056, 41.17758], [-124.10094, 41.17704], [-124.10072, 41.17651], [-124.10085, 41.17576], [-124.10108, 41.17533], [-124.10145, 41.17434], [-124.10083, 41.17374], [-124.101, 41.17317], [-124.10094, 41.17288], [-124.10077, 41.17277], [-124.0992, 41.1728], [-124.09928, 41.17223], [-124.0996, 41.17199], [-124.10001, 41.17157], [-124.0996, 41.17142], [-124.09968, 41.17114], [-124.09987, 41.17098], [-124.10072, 41.17072], [-124.10084, 41.17053], [-124.10092, 41.16969], [-124.1007, 41.16935], [-124.10038, 41.16911], [-124.09962, 41.1692], [-124.09944, 41.16893], [-124.09977, 41.16838], [-124.09977, 41.16778], [-124.10048, 41.16786], [-124.10121, 41.16781], [-124.1017, 41.1675], [-124.10206, 41.16686], [-124.10122, 41.16541], [-124.10073, 41.16462], [-124.10058, 41.16429], [-124.10023, 41.16391], [-124.10005, 41.16353], [-124.09968, 41.16318], [-124.09909, 41.16298], [-124.09846, 41.16298], [-124.09915, 41.16242], [-124.09977, 41.16265], [-124.10085, 41.16313], [-124.10098, 41.16349], [-124.1015, 41.16403], [-124.10226, 41.16472], [-124.10237, 41.16489], [-124.10277, 41.1649], [-124.10315, 41.16478], [-124.10364, 41.16478], [-124.10411, 41.16474], [-124.10551, 41.16531], [-124.10558, 41.16537], [-124.10496, 41.16582], [-124.10455, 41.16617], [-124.10402, 41.16652], [-124.10374, 41.16678], [-124.10375, 41.16679], [-124.10432, 41.16713], [-124.10405, 41.16739], [-124.10334, 41.16793], [-124.1032, 41.16827], [-124.10306, 41.16853], [-124.10289, 41.16872], [-124.10288, 41.16936], [-124.10296, 41.16958], [-124.10337, 41.17], [-124.10355, 41.17034], [-124.10356, 41.1709], [-124.10371, 41.17148], [-124.10396, 41.17186], [-124.10373, 41.17215], [-124.1042, 41.17209], [-124.10432, 41.17214], [-124.10457, 41.17289], [-124.10469, 41.17488], [-124.10514, 41.1768], [-124.10575, 41.17774], [-124.10668, 41.17859], [-124.10811, 41.17934], [-124.10838, 41.18056], [-124.10823, 41.18095], [-124.10823, 41.18117], [-124.1088, 41.18225], [-124.10871, 41.18273], [-124.10868, 41.18357], [-124.10941, 41.18435], [-124.1095, 41.18472], [-124.10968, 41.18502], [-124.11011, 41.18643], [-124.1099, 41.18714], [-124.11013, 41.18762], [-124.11017, 41.18848], [-124.11035, 41.18927], [-124.11098, 41.19036], [-124.11094, 41.19104], [-124.11123, 41.19205], [-124.11092, 41.19381], [-124.11104, 41.1941], [-124.11157, 41.19496], [-124.11157, 41.19546], [-124.11143, 41.19577], [-124.11062, 41.19629], [-124.11062, 41.19659], [-124.11083, 41.19691], [-124.11131, 41.1974], [-124.11156, 41.19785], [-124.11213, 41.19982], [-124.11222, 41.19986], [-124.1124, 41.20089]]], [[[-124.12092, 41.15818], [-124.12041, 41.15901], [-124.11729, 41.15942], [-124.11479, 41.16065], [-124.11038, 41.15781], [-124.10682, 41.15805], [-124.10704, 41.16014], [-124.10782, 41.16134], [-124.10738, 41.1635], [-124.10769, 41.16389], [-124.10616, 41.16484], [-124.10596, 41.16507], [-124.10209, 41.16289], [-124.10195, 41.16038], [-124.10048, 41.15779], [-124.10217, 41.15608], [-124.1094, 41.15427], [-124.10969, 41.15409], [-124.10983, 41.15374], [-124.10999, 41.15346], [-124.11028, 41.15324], [-124.11061, 41.15292], [-124.11085, 41.15257], [-124.11092, 41.15231], [-124.11079, 41.15209], [-124.1109, 41.15152], [-124.11119, 41.15132], [-124.11146, 41.15141], [-124.1123, 41.15193], [-124.11264, 41.15202], [-124.1139, 41.15203], [-124.11465, 41.15207], [-124.11487, 41.15213], [-124.11526, 41.15243], [-124.11556, 41.15258], [-124.11585, 41.15278], [-124.11598, 41.153], [-124.11608, 41.15338], [-124.11607, 41.15386], [-124.11617, 41.15419], [-124.11632, 41.15446], [-124.11652, 41.15459], [-124.11688, 41.1546], [-124.11734, 41.1548], [-124.11779, 41.15507], [-124.11803, 41.15536], [-124.11811, 41.15562], [-124.11824, 41.15589], [-124.11846, 41.15616], [-124.11873, 41.15625], [-124.11902, 41.1564], [-124.11924, 41.15656], [-124.11956, 41.15685], [-124.11983, 41.15707], [-124.12015, 41.15729], [-124.12092, 41.15818]]], [[[-124.10916, 41.16539], [-124.10773, 41.1663], [-124.10511, 41.16632], [-124.1082, 41.16457], [-124.10916, 41.16539]]], [[[-124.10821, 41.21082], [-124.10799, 41.2132], [-124.10738, 41.2132], [-124.10743, 41.21081], [-124.10821, 41.21082]]], [[[-124.13239, 41.15603], [-124.13027, 41.15729], [-124.13026, 41.15832], [-124.1303, 41.15847], [-124.1304, 41.15862], [-124.13055, 41.15874], [-124.13074, 41.15881], [-124.13096, 41.15884], [-124.12739, 41.15883], [-124.12711, 41.1586], [-124.12569, 41.15878], [-124.12905, 41.16372], [-124.12905, 41.16386], [-124.12907, 41.164], [-124.12922, 41.16447], [-124.12922, 41.16472], [-124.12465, 41.1647], [-124.12412, 41.16504], [-124.12443, 41.16529], [-124.12452, 41.16546], [-124.12454, 41.16571], [-124.12449, 41.16597], [-124.12433, 41.1655], [-124.12355, 41.16533], [-124.12289, 41.16524], [-124.12296, 41.16247], [-124.11843, 41.16239], [-124.11796, 41.16107], [-124.11793, 41.16066], [-124.11794, 41.15993], [-124.11992, 41.15947], [-124.12082, 41.1593], [-124.12164, 41.15903], [-124.12268, 41.15858], [-124.12494, 41.15718], [-124.1263, 41.15671], [-124.12735, 41.1561], [-124.12993, 41.15714], [-124.13238, 41.15569], [-124.13239, 41.15603]]]]} | Open Access 1 | 20482 | Harry A. Merlo State Recreation Area | 1556 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=431 | Humboldt 45 | 988.422 | Harry A. Merlo SRA | 1982 | State Recreation Area 39 | 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]);