superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where MNG_AGENCY = 275 and MNG_AG_TYP = 3 sorted by map descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10578 | 10578 | 10577 | {"type": "Polygon", "coordinates": [[[-122.90651, 39.16174], [-122.90459, 39.16158], [-122.90524, 39.15939], [-122.9065, 39.15944], [-122.90653, 39.16111], [-122.90651, 39.16174]]]} | Open Access 1 | Upper Lake County Park | 26729 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 8.592 | Upper Lake County Park | ||
5923 | 5923 | 5922 | {"type": "Polygon", "coordinates": [[[-122.89337, 39.13328], [-122.88871, 39.13329], [-122.88871, 39.1332], [-122.88877, 39.13316], [-122.88878, 39.13309], [-122.88874, 39.13303], [-122.88866, 39.133], [-122.88857, 39.13303], [-122.88852, 39.13309], [-122.88854, 39.13316], [-122.8886, 39.1332], [-122.8886, 39.13329], [-122.88617, 39.13328], [-122.8858, 39.13288], [-122.88559, 39.13233], [-122.88591, 39.13145], [-122.88676, 39.12965], [-122.88655, 39.12909], [-122.88418, 39.12758], [-122.88395, 39.12737], [-122.88347, 39.12681], [-122.8834, 39.12657], [-122.88525, 39.12758], [-122.88647, 39.12756], [-122.89334, 39.12755], [-122.89337, 39.13328]]]} | Open Access 1 | Lake holding 2 | 20906 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 102.264 | Lake holding 2 | ||
5919 | 5919 | 5918 | {"type": "Polygon", "coordinates": [[[-122.8886, 39.13329], [-122.88859, 39.13509], [-122.88709, 39.13506], [-122.88729, 39.13459], [-122.88721, 39.13418], [-122.88617, 39.13328], [-122.8886, 39.13329]]]} | Open Access 1 | Lake holding 12 | 20898 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 6.977 | Lake holding 12 | ||
5921 | 5921 | 5920 | {"type": "Polygon", "coordinates": [[[-122.88859, 39.13865], [-122.88764, 39.13862], [-122.88763, 39.13743], [-122.88859, 39.13742], [-122.88859, 39.13865]]]} | Open Access 1 | Lake holding 15 | 20901 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 2.73 | Lake holding 15 | ||
5922 | 5922 | 5921 | {"type": "Polygon", "coordinates": [[[-122.88764, 39.13862], [-122.88696, 39.13862], [-122.88696, 39.13744], [-122.88763, 39.13743], [-122.88764, 39.13862]]]} | Open Access 1 | Lake holding 16 | 20902 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 1.908 | Lake holding 16 | ||
5917 | 5917 | 5916 | {"type": "Polygon", "coordinates": [[[-122.88696, 39.13744], [-122.88696, 39.13862], [-122.88631, 39.13862], [-122.88633, 39.13744], [-122.88696, 39.13744]]]} | Open Access 1 | Lake holding 1 | 20895 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 1.798 | Lake holding 1 | ||
5938 | 5938 | 5937 | {"type": "Polygon", "coordinates": [[[-122.88635, 39.13614], [-122.8863, 39.13862], [-122.88342, 39.13859], [-122.88375, 39.13812], [-122.88487, 39.13733], [-122.88578, 39.13657], [-122.88635, 39.13614]]]} | Open Access 1 | Lake holding 8 | 20943 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 9.011 | Lake holding 8 | ||
5920 | 5920 | 5919 | {"type": "Polygon", "coordinates": [[[-122.88631, 39.13873], [-122.88627, 39.14019], [-122.88546, 39.14008], [-122.88385, 39.14009], [-122.88351, 39.13976], [-122.8834, 39.13871], [-122.88631, 39.13873]]]} | Open Access 1 | Lake holding 14 | 20900 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 9.084 | Lake holding 14 | ||
8897 | 8897 | 8896 | {"type": "Polygon", "coordinates": [[[-122.88176, 39.1186], [-122.88175, 39.11912], [-122.87917, 39.11957], [-122.87867, 39.11973], [-122.87835, 39.11987], [-122.8781, 39.12], [-122.87511, 39.12088], [-122.87443, 39.11976], [-122.87471, 39.11975], [-122.87471, 39.11945], [-122.87507, 39.11938], [-122.87554, 39.11916], [-122.87567, 39.11893], [-122.87573, 39.11877], [-122.87571, 39.11844], [-122.87566, 39.11801], [-122.87569, 39.11746], [-122.87738, 39.11623], [-122.87753, 39.11618], [-122.87832, 39.11638], [-122.87874, 39.11687], [-122.87937, 39.11686], [-122.87941, 39.11692], [-122.87975, 39.1171], [-122.88022, 39.11721], [-122.88119, 39.1179], [-122.88155, 39.11829], [-122.88158, 39.11856], [-122.88166, 39.11861], [-122.88176, 39.1186]]]} | Open Access 1 | Rodman Slough | 24551 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 43.703 | Rodman Slough | ||
5663 | 5663 | 5662 | {"type": "Polygon", "coordinates": [[[-122.87408, 39.00329], [-122.87407, 39.0034], [-122.87395, 39.0034], [-122.874, 39.00329], [-122.87408, 39.00329]]]} | Open Access 1 | Lake holding 44 | 20933 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.025 | Lake holding 44 | ||
12498 | 12498 | 12497 | {"type": "Polygon", "coordinates": [[[-122.86885, 39.12496], [-122.86874, 39.1253], [-122.86734, 39.12488], [-122.86722, 39.12495], [-122.867, 39.12504], [-122.86675, 39.12513], [-122.86661, 39.1252], [-122.86634, 39.12572], [-122.86476, 39.12547], [-122.8655, 39.12316], [-122.86581, 39.12261], [-122.86586, 39.12261], [-122.86608, 39.12222], [-122.86677, 39.12251], [-122.86602, 39.12361], [-122.86717, 39.12424], [-122.86885, 39.12496]]]} | Open Access 1 | Hammond Avenue Park | 31181 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 12.691 | Hammond Avenue Park | ||
5960 | 5960 | 5959 | {"type": "Polygon", "coordinates": [[[-122.85229, 39.02769], [-122.85033, 39.02801], [-122.84847, 39.02937], [-122.84759, 39.02973], [-122.84753, 39.02691], [-122.84753, 39.02424], [-122.85208, 39.02421], [-122.85209, 39.026], [-122.85226, 39.02602], [-122.85229, 39.02769]]]} | Open Access 1 | Lakeside Park | 20977 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 47.438 | Lakeside Park | ||
13687 | 13687 | 13686 | {"type": "Polygon", "coordinates": [[[-122.8466, 39.12359], [-122.8459, 39.1236], [-122.84588, 39.12313], [-122.84659, 39.12311], [-122.8466, 39.12359]]]} | Open Access 1 | Hinman County Park | 31183 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.799 | Hinman County Park | ||
5931 | 5931 | 5930 | {"type": "Polygon", "coordinates": [[[-122.84494, 39.12016], [-122.84493, 39.12125], [-122.84431, 39.12124], [-122.8441, 39.12121], [-122.8443, 39.12016], [-122.84494, 39.12016]]]} | Open Access 1 | Lake holding 48 | 20937 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 1.887 | Lake holding 48 | ||
5898 | 5898 | 5897 | {"type": "Polygon", "coordinates": [[[-122.84426, 39.00039], [-122.84378, 39.00039], [-122.84377, 38.99973], [-122.84425, 38.99973], [-122.84426, 39.00039]]]} | Open Access 1 | Lake holding 29 | 20916 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.755 | Lake holding 29 | ||
4848 | 4848 | 4847 | {"type": "Polygon", "coordinates": [[[-122.84421, 39.12015], [-122.84404, 39.12101], [-122.84402, 39.12102], [-122.84398, 39.1212], [-122.84359, 39.12117], [-122.84377, 39.12015], [-122.84421, 39.12015]]]} | Open Access 1 | Lake holding 47 | 20936 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 1.05 | Lake holding 47 | ||
5915 | 5915 | 5914 | {"type": "Polygon", "coordinates": [[[-122.84377, 39.00039], [-122.84353, 39.00038], [-122.84353, 38.99972], [-122.84377, 38.99973], [-122.84377, 39.00039]]]} | Open Access 1 | Lake holding 33 | 20921 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.38 | Lake holding 33 | ||
5930 | 5930 | 5929 | {"type": "Polygon", "coordinates": [[[-122.8436, 39.12015], [-122.84342, 39.12115], [-122.84209, 39.12103], [-122.84189, 39.12087], [-122.84231, 39.12014], [-122.8436, 39.12015]]]} | Open Access 1 | Lake holding 46 | 20935 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 3.223 | Lake holding 46 | ||
5929 | 5929 | 5928 | {"type": "Polygon", "coordinates": [[[-122.84342, 38.97848], [-122.84318, 38.97845], [-122.843, 38.97792], [-122.84307, 38.97802], [-122.84336, 38.97826], [-122.84341, 38.97837], [-122.84342, 38.97848]]]} | Open Access 1 | Lake holding 45 | 20934 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.209 | Lake holding 45 | ||
13688 | 13688 | 13687 | {"type": "Polygon", "coordinates": [[[-122.83865, 38.97834], [-122.83859, 38.97859], [-122.83774, 38.97848], [-122.83779, 38.97823], [-122.83865, 38.97834]]]} | Open Access 1 | Pioneer Mini-Park | 31184 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.524 | Pioneer Mini-Park |
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]);