units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where DES_TP = 13 and MNG_AGENCY = 44 sorted by rowid descending
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- United States Fish and Wildlife Service · 5 ✖
DES_TP 1
- Conservation Area · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15594 | 15594 | 15593 | {"type": "MultiPolygon", "coordinates": [[[[-122.2062, 37.53851], [-122.20455, 37.54011], [-122.19733, 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.53534], [-122.20129, 37.53535], [-122.2062, 37.53851]]], [[[-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.22363, 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.22315, 37.52048], [-122.22323, 37.52021], [-122.22332, 37.51999], [-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.2316, 37.52031], [-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.23923, 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.51004], [-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 | 17757 | Bair Island Ecological Reserve | 15764 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bair-Island-ER | San Mateo 15 | 406.137 | Bair Island ER | 1986 | Conservation Area 13 | 2 |
15565 | 15565 | 15564 | {"type": "Polygon", "coordinates": [[[-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.24397, 37.50388], [-122.24419, 37.50407], [-122.24432, 37.50399], [-122.24458, 37.50422], [-122.24447, 37.5043], [-122.24446, 37.50432], [-122.24468, 37.50451], [-122.24481, 37.50443], [-122.24618, 37.50566], [-122.24606, 37.50575], [-122.24628, 37.50595], [-122.24562, 37.50643], [-122.24251, 37.50367], [-122.23994, 37.50551], [-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.23743, 37.50801], [-122.23714, 37.50802], [-122.23677, 37.50794], [-122.23623, 37.50776], [-122.23566, 37.50748], [-122.23556, 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.22712, 37.50151], [-122.2261, 37.50079], [-122.22503, 37.50015], [-122.22494, 37.5003], [-122.22459, 37.5004], [-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.22358, 37.49793], [-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.49764], [-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]]]} | No Public Access 3 | 2389 | Bair Island Ecological Reserve | 15764 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bair-Island-ER | San Mateo 15 | 303.484 | Bair Island ER | 1986 | Conservation Area 13 | 2 |
12172 | 12172 | 12171 | {"type": "MultiPolygon", "coordinates": [[[[-122.0023, 39.55714], [-122.00067, 39.55738], [-122.00004, 39.55733], [-121.99786, 39.55722], [-121.9962, 39.55706], [-121.99474, 39.55668], [-121.99225, 39.55686], [-121.99091, 39.55726], [-121.99068, 39.55729], [-121.99098, 39.55403], [-121.99099, 39.55127], [-121.99048, 39.54485], [-121.98916, 39.54105], [-121.98522, 39.53903], [-121.9855, 39.53688], [-121.9834, 39.53577], [-121.98269, 39.53511], [-121.98042, 39.53448], [-121.9785, 39.53391], [-121.97608, 39.53414], [-121.97452, 39.53396], [-121.9725, 39.53286], [-121.97036, 39.53075], [-121.97013, 39.53024], [-121.97103, 39.53], [-121.97405, 39.52928], [-121.97381, 39.52965], [-121.9734, 39.53036], [-121.97335, 39.53079], [-121.97343, 39.53115], [-121.97367, 39.5314], [-121.9739, 39.53157], [-121.97541, 39.53246], [-121.97657, 39.53298], [-121.97737, 39.53321], [-121.97795, 39.53328], [-121.9787, 39.5333], [-121.97964, 39.53321], [-121.98059, 39.53305], [-121.98156, 39.53294], [-121.98245, 39.53293], [-121.98298, 39.53304], [-121.98325, 39.53318], [-121.9842, 39.5333], [-121.98464, 39.53314], [-121.9849, 39.53293], [-121.98493, 39.53272], [-121.9849, 39.53229], [-121.98511, 39.53188], [-121.98573, 39.53154], [-121.9862, 39.53149], [-121.98676, 39.53169], [-121.98777, 39.53231], [-121.98854, 39.53256], [-121.98931, 39.53279], [-121.99005, 39.53316], [-121.99155, 39.53382], [-121.99238, 39.53423], [-121.99333, 39.53491], [-121.99387, 39.53547], [-121.995, 39.5373], [-121.99688, 39.54166], [-121.99885, 39.54825], [-122.0023, 39.55714]]], [[[-122.00208, 39.55937], [-122.00124, 39.56031], [-121.99906, 39.56057], [-121.99884, 39.5608], [-121.99772, 39.56184], [-121.99751, 39.56216], [-121.99678, 39.56214], [-121.99612, 39.56208], [-121.99553, 39.56205], [-121.99479, 39.56198], [-121.99405, 39.56205], [-121.99334, 39.56225], [-121.99307, 39.56201], [-121.99299, 39.5624], [-121.99267, 39.56255], [-121.99254, 39.56256], [-121.99223, 39.56206], [-121.99223, 39.56278], [-121.99202, 39.5629], [-121.99105, 39.56295], [-121.99048, 39.56269], [-121.99049, 39.56174], [-121.99005, 39.56026], [-121.99016, 39.55991], [-121.99107, 39.55867], [-121.99143, 39.55837], [-121.99224, 39.55796], [-121.99316, 39.55774], [-121.99448, 39.55786], [-121.99569, 39.55781], [-121.99659, 39.55806], [-121.99659, 39.55849], [-121.99763, 39.5587], [-121.99784, 39.55903], [-121.99897, 39.55913], [-121.99977, 39.55929], [-122.00167, 39.5595], [-122.00208, 39.55937]]]]} | Restricted Access 2 | 25275 | Butte Sink Wildlife Management Area | 16605 | 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 | Butte 42 | 655.167 | Butte Sink WMA | 1980 | Conservation Area 13 | 2 | |
5067 | 5067 | 5066 | {"type": "MultiPolygon", "coordinates": [[[[-121.92364, 39.61375], [-121.91546, 39.61369], [-121.91009, 39.61404], [-121.90974, 39.58565], [-121.91651, 39.58595], [-121.91905, 39.59054], [-121.92027, 39.59046], [-121.92226, 39.60293], [-121.92315, 39.6032], [-121.92361, 39.6051], [-121.92364, 39.61375]]], [[[-121.95697, 39.57561], [-121.95661, 39.58172], [-121.95673, 39.58306], [-121.95538, 39.58764], [-121.9527, 39.59123], [-121.94897, 39.59451], [-121.94637, 39.59764], [-121.9452, 39.59967], [-121.94368, 39.60103], [-121.93282, 39.60012], [-121.93297, 39.5959], [-121.93329, 39.58805], [-121.93354, 39.58402], [-121.93359, 39.57597], [-121.94034, 39.5756], [-121.94131, 39.57612], [-121.95697, 39.57561]]]]} | Restricted Access 2 | 9050 | North Central Valley Wildlife Management Area | 22810 | 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 | Butte 42 | 1915.19 | North Central Valley WMA | 0 | Conservation Area 13 | 2 | |
107 | 107 | 106 | {"type": "Polygon", "coordinates": [[[-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.21798, 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]]]} | No Public Access 3 | 326 | Bair Island Ecological Reserve | 15764 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bair-Island-ER | San Mateo 15 | 154.18 | Bair Island ER | 1986 | Conservation Area 13 | 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]);