superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bair-Island-ER"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
ACCESS_TYP 3
MNG_AG_TYP 2
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90 | 90 | 89 | {"type": "Polygon", "coordinates": [[[-122.22785, 37.5376], [-122.22781, 37.53769], [-122.22737, 37.53832], [-122.22719, 37.53867], [-122.22695, 37.53952], [-122.22669, 37.53983], [-122.22637, 37.54034], [-122.22594, 37.54065], [-122.22587, 37.54083], [-122.22572, 37.54099], [-122.22529, 37.54163], [-122.22499, 37.54186], [-122.22456, 37.54246], [-122.22451, 37.54248], [-122.22432, 37.54215], [-122.22343, 37.54263], [-122.21888, 37.5422], [-122.21566, 37.54246], [-122.21353, 37.542], [-122.20784, 37.54198], [-122.20636, 37.54134], [-122.20455, 37.54011], [-122.20732, 37.53741], [-122.20732, 37.53739], [-122.19806, 37.53143], [-122.20588, 37.52401], [-122.20775, 37.52464], [-122.20924, 37.52534], [-122.21153, 37.52598], [-122.2154, 37.52634], [-122.21659, 37.52578], [-122.21686, 37.52402], [-122.21759, 37.52322], [-122.2194, 37.52263], [-122.21974, 37.52171], [-122.21809, 37.51903], [-122.21877, 37.51801], [-122.22009, 37.51773], [-122.22006, 37.51792], [-122.22062, 37.51804], [-122.22148, 37.52435], [-122.21606, 37.52774], [-122.21381, 37.52792], [-122.21288, 37.52874], [-122.22785, 37.5376]]]} | Restricted Access 2 | Bair Island Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bair-Island-ER | 15765 | 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 | 787.542 | Bair Island ER | 1986 |
14461 | 14461 | 14460 | {"type": "MultiPolygon", "coordinates": [[[[-122.20734, 37.53739], [-122.2062, 37.53851], [-122.20128, 37.53534], [-122.20242, 37.53423], [-122.20734, 37.53739]]], [[[-122.24253, 37.52725], [-122.24222, 37.52743], [-122.2422, 37.52768], [-122.24196, 37.52806], [-122.24137, 37.52854], [-122.24047, 37.52904], [-122.23945, 37.52935], [-122.23866, 37.5294], [-122.23766, 37.52975], [-122.23741, 37.52959], [-122.23619, 37.53009], [-122.23616, 37.53021], [-122.23449, 37.53075], [-122.23432, 37.53088], [-122.23345, 37.53138], [-122.23318, 37.53171], [-122.23251, 37.53205], [-122.23225, 37.5323], [-122.23029, 37.53341], [-122.23027, 37.53372], [-122.22946, 37.53474], [-122.22913, 37.53528], [-122.22856, 37.53554], [-122.22835, 37.53579], [-122.22847, 37.53607], [-122.22823, 37.5362], [-122.22818, 37.53641], [-122.2285, 37.53666], [-122.22805, 37.53719], [-122.22785, 37.5376], [-122.21287, 37.52873], [-122.2138, 37.52792], [-122.21606, 37.52774], [-122.22147, 37.52435], [-122.2213, 37.52306], [-122.22339, 37.52295], [-122.22463, 37.52279], [-122.22467, 37.52277], [-122.22479, 37.5234], [-122.22481, 37.52341], [-122.22493, 37.52329], [-122.22598, 37.52268], [-122.22763, 37.52109], [-122.22897, 37.51928], [-122.23016, 37.51929], [-122.23047, 37.52022], [-122.23078, 37.52072], [-122.23093, 37.52091], [-122.23115, 37.5211], [-122.23136, 37.52125], [-122.23167, 37.52139], [-122.23197, 37.52148], [-122.23221, 37.52153], [-122.23242, 37.52155], [-122.23301, 37.52156], [-122.23326, 37.52153], [-122.2335, 37.52147], [-122.23371, 37.5214], [-122.23393, 37.5213], [-122.23409, 37.5212], [-122.23517, 37.52037], [-122.23554, 37.51997], [-122.23594, 37.51911], [-122.23592, 37.51908], [-122.23597, 37.5186], [-122.23586, 37.51775], [-122.23492, 37.51646], [-122.23489, 37.51635], [-122.23504, 37.51598], [-122.23537, 37.51587], [-122.2359, 37.51608], [-122.23588, 37.51633], [-122.23668, 37.51695], [-122.23721, 37.51761], [-122.23783, 37.51901], [-122.23796, 37.51982], [-122.23766, 37.51994], [-122.23783, 37.52065], [-122.23803, 37.52085], [-122.23798, 37.52117], [-122.23835, 37.52159], [-122.23888, 37.5221], [-122.23965, 37.52243], [-122.24176, 37.52294], [-122.24224, 37.52311], [-122.24267, 37.52343], [-122.24292, 37.52386], [-122.24294, 37.52431], [-122.24253, 37.52725]]], [[[-122.23924, 37.5191], [-122.23859, 37.51912], [-122.23849, 37.51898], [-122.23846, 37.51885], [-122.23838, 37.51866], [-122.2383, 37.51852], [-122.23819, 37.51838], [-122.23806, 37.51826], [-122.23798, 37.51812], [-122.23774, 37.51761], [-122.23734, 37.517], [-122.23715, 37.51672], [-122.23654, 37.51599], [-122.23629, 37.51579], [-122.23599, 37.51561], [-122.23579, 37.51557], [-122.23544, 37.51557], [-122.2353, 37.51553], [-122.23499, 37.51554], [-122.23446, 37.51564], [-122.2342, 37.51585], [-122.23409, 37.51598], [-122.23403, 37.51616], [-122.23399, 37.51642], [-122.23397, 37.51658], [-122.234, 37.51673], [-122.23422, 37.51732], [-122.23453, 37.51787], [-122.2347, 37.51812], [-122.23483, 37.5184], [-122.23485, 37.51872], [-122.2348, 37.51897], [-122.2348, 37.519], [-122.23098, 37.51906], [-122.23095, 37.51885], [-122.2309, 37.51874], [-122.23076, 37.51855], [-122.23046, 37.51833], [-122.23022, 37.51811], [-122.22979, 37.51763], [-122.22961, 37.51757], [-122.2295, 37.51767], [-122.22939, 37.51784], [-122.2292, 37.51805], [-122.22904, 37.5181], [-122.22882, 37.51825], [-122.22856, 37.51863], [-122.22827, 37.51896], [-122.22804, 37.51913], [-122.228, 37.51913], [-122.22802, 37.51926], [-122.228, 37.51936], [-122.22738, 37.52021], [-122.22714, 37.52048], [-122.22325, 37.52052], [-122.22358, 37.51977], [-122.22333, 37.51939], [-122.22319, 37.51928], [-122.22282, 37.51875], [-122.22259, 37.51848], [-122.2223, 37.51828], [-122.2219, 37.51807], [-122.22179, 37.51799], [-122.22165, 37.51793], [-122.22126, 37.51783], [-122.22121, 37.51777], [-122.22086, 37.51767], [-122.22068, 37.51756], [-122.22059, 37.51742], [-122.2206, 37.51689], [-122.22078, 37.51604], [-122.22226, 37.51044], [-122.223, 37.50745], [-122.22473, 37.50224], [-122.22491, 37.50192], [-122.22527, 37.50178], [-122.22567, 37.50179], [-122.2262, 37.50197], [-122.2265, 37.50221], [-122.2269, 37.50275], [-122.22724, 37.50388], [-122.22776, 37.50476], [-122.22846, 37.50544], [-122.22903, 37.50576], [-122.22969, 37.50586], [-122.23017, 37.50607], [-122.23168, 37.5065], [-122.23195, 37.50667], [-122.23277, 37.50691], [-122.2336, 37.50709], [-122.23438, 37.5074], [-122.23492, 37.50767], [-122.23527, 37.50782], [-122.23541, 37.50784], [-122.23568, 37.50796], [-122.2363, 37.50839], [-122.23797, 37.50855], [-122.23801, 37.50856], [-122.23807, 37.50863], [-122.23828, 37.50862], [-122.23862, 37.50869], [-122.23878, 37.5087], [-122.23924, 37.5191]]]]} | Open Access 1 | Bair Island Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bair-Island-ER | 32033 | 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 | 1219.54 | Bair Island ER | 1986 |
14495 | 14495 | 14494 | {"type": "MultiPolygon", "coordinates": [[[[-122.2062, 37.53851], [-122.20455, 37.54011], [-122.19734, 37.53527], [-122.1973, 37.53847], [-122.19487, 37.53846], [-122.19422, 37.53582], [-122.19495, 37.53174], [-122.19634, 37.52938], [-122.20089, 37.52623], [-122.20168, 37.52658], [-122.20253, 37.52558], [-122.20578, 37.52397], [-122.20588, 37.52401], [-122.19807, 37.53143], [-122.20242, 37.53423], [-122.20129, 37.53533], [-122.20129, 37.53535], [-122.2062, 37.53851]]], [[[-122.22338, 37.50515], [-122.22009, 37.51773], [-122.21877, 37.51801], [-122.21809, 37.51903], [-122.21667, 37.51812], [-122.21775, 37.51663], [-122.21825, 37.51441], [-122.21797, 37.51278], [-122.21748, 37.51193], [-122.21674, 37.51128], [-122.21291, 37.51062], [-122.21328, 37.50919], [-122.21472, 37.50836], [-122.21516, 37.50756], [-122.22205, 37.50517], [-122.22338, 37.50515]]], [[[-122.24628, 37.50595], [-122.24562, 37.50643], [-122.24251, 37.50367], [-122.23994, 37.50552], [-122.24256, 37.50787], [-122.24216, 37.50788], [-122.24137, 37.50795], [-122.24041, 37.50791], [-122.23934, 37.50779], [-122.23901, 37.50769], [-122.23865, 37.50741], [-122.23809, 37.50775], [-122.23815, 37.5079], [-122.23796, 37.50807], [-122.23744, 37.50801], [-122.23714, 37.50802], [-122.23677, 37.50794], [-122.23623, 37.50776], [-122.23566, 37.50748], [-122.23555, 37.50727], [-122.23495, 37.50712], [-122.23456, 37.50689], [-122.23402, 37.50679], [-122.23243, 37.50611], [-122.23102, 37.50574], [-122.23027, 37.50549], [-122.22934, 37.50497], [-122.22894, 37.50458], [-122.22864, 37.50415], [-122.22815, 37.50366], [-122.22781, 37.50279], [-122.22773, 37.50232], [-122.22711, 37.50151], [-122.2261, 37.50079], [-122.22503, 37.50015], [-122.22494, 37.5003], [-122.2246, 37.50041], [-122.22486, 37.50102], [-122.22469, 37.50103], [-122.22456, 37.50109], [-122.22447, 37.5011], [-122.22336, 37.49821], [-122.21968, 37.49817], [-122.21976, 37.4979], [-122.22357, 37.49792], [-122.22364, 37.49767], [-122.22378, 37.49741], [-122.22393, 37.49721], [-122.22412, 37.49704], [-122.2243, 37.49691], [-122.22714, 37.49518], [-122.22728, 37.49534], [-122.22445, 37.49707], [-122.22422, 37.49724], [-122.22405, 37.49742], [-122.22391, 37.49765], [-122.22382, 37.49787], [-122.2238, 37.49813], [-122.23182, 37.49814], [-122.23176, 37.49823], [-122.23135, 37.49871], [-122.23132, 37.49883], [-122.23133, 37.49889], [-122.23137, 37.49895], [-122.23142, 37.499], [-122.23149, 37.49904], [-122.23155, 37.49918], [-122.23183, 37.49924], [-122.23201, 37.49918], [-122.23217, 37.49876], [-122.23249, 37.49825], [-122.23258, 37.49814], [-122.23676, 37.49811], [-122.23821, 37.49916], [-122.23884, 37.49964], [-122.24115, 37.5016], [-122.24307, 37.50329], [-122.24334, 37.50312], [-122.24409, 37.50378], [-122.24398, 37.50388], [-122.24418, 37.50407], [-122.24432, 37.50399], [-122.24458, 37.50422], [-122.24447, 37.5043], [-122.24447, 37.50432], [-122.24468, 37.50451], [-122.24481, 37.50443], [-122.24618, 37.50566], [-122.24607, 37.50575], [-122.24628, 37.50595]]], [[[-122.22714, 37.52048], [-122.22689, 37.52077], [-122.22657, 37.52111], [-122.22641, 37.52125], [-122.22609, 37.52149], [-122.22538, 37.52198], [-122.22516, 37.52212], [-122.22445, 37.52244], [-122.22405, 37.52255], [-122.2239, 37.52255], [-122.22374, 37.52258], [-122.22362, 37.52262], [-122.22341, 37.52272], [-122.22324, 37.52266], [-122.22312, 37.52267], [-122.22276, 37.52251], [-122.22266, 37.52245], [-122.22245, 37.52219], [-122.22241, 37.5221], [-122.22245, 37.52195], [-122.22254, 37.52177], [-122.22262, 37.52149], [-122.22287, 37.52094], [-122.22314, 37.52048], [-122.22323, 37.52021], [-122.22332, 37.51998], [-122.22338, 37.51976], [-122.2234, 37.5196], [-122.22319, 37.51928], [-122.22333, 37.51939], [-122.22358, 37.51978], [-122.22325, 37.5205], [-122.22326, 37.52052], [-122.22714, 37.52048]]], [[[-122.23489, 37.519], [-122.23483, 37.51918], [-122.23478, 37.51928], [-122.23448, 37.51963], [-122.23425, 37.51988], [-122.23403, 37.52006], [-122.23368, 37.52027], [-122.23317, 37.52048], [-122.23279, 37.52065], [-122.23244, 37.52075], [-122.23198, 37.52076], [-122.23175, 37.52057], [-122.23162, 37.52041], [-122.23155, 37.52019], [-122.23147, 37.51995], [-122.23143, 37.51971], [-122.23143, 37.51959], [-122.23123, 37.51926], [-122.23098, 37.51906], [-122.23489, 37.519]]], [[[-122.24449, 37.52305], [-122.24432, 37.52312], [-122.24259, 37.52249], [-122.24224, 37.52232], [-122.24156, 37.52225], [-122.24014, 37.52184], [-122.23966, 37.5216], [-122.23923, 37.52116], [-122.23916, 37.52098], [-122.23904, 37.52076], [-122.23902, 37.52064], [-122.23888, 37.52027], [-122.23881, 37.51987], [-122.23859, 37.51912], [-122.23922, 37.5191], [-122.23924, 37.51909], [-122.23879, 37.5087], [-122.24237, 37.50878], [-122.24322, 37.50895], [-122.24355, 37.50917], [-122.244, 37.5097], [-122.24412, 37.51003], [-122.24429, 37.51013], [-122.24441, 37.51041], [-122.24479, 37.5109], [-122.24612, 37.51319], [-122.24624, 37.51615], [-122.24618, 37.51781], [-122.24599, 37.51889], [-122.24597, 37.51955], [-122.24449, 37.52305]]]]} | No Public Access 3 | Bair Island Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bair-Island-ER | 15764 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 864.069 | Bair Island ER | 1986 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);