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 ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
13399 | 13399 | 13398 | {"type": "MultiPolygon", "coordinates": [[[[-122.67532, 39.01951], [-122.67283, 39.01962], [-122.67266, 39.01962], [-122.67255, 39.0196], [-122.67255, 39.01946], [-122.6727, 39.01937], [-122.6729, 39.0194], [-122.67309, 39.01937], [-122.67338, 39.01925], [-122.67343, 39.01921], [-122.67356, 39.01926], [-122.6738, 39.01927], [-122.67398, 39.01925], [-122.67418, 39.01926], [-122.67483, 39.01921], [-122.67515, 39.01925], [-122.6753, 39.01922], [-122.67532, 39.01951]]], [[[-122.67393, 39.01971], [-122.67382, 39.01973], [-122.67348, 39.01981], [-122.67348, 39.0197], [-122.67393, 39.01967], [-122.67393, 39.01971]]]]} | Open Access 1 | Clearlake Oaks Beach County Park | 30779 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 2.024 | Clearlake Oaks Beach County Park | ||
5886 | 5886 | 5885 | {"type": "Polygon", "coordinates": [[[-122.76448, 39.00476], [-122.76443, 39.00541], [-122.76419, 39.00534], [-122.76351, 39.00525], [-122.7632, 39.00528], [-122.76329, 39.00446], [-122.76448, 39.00476]]]} | Open Access 1 | Lake holding 40 | 20929 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 2.027 | Lake holding 40 | ||
5934 | 5934 | 5933 | {"type": "Polygon", "coordinates": [[[-122.58394, 39.06571], [-122.58328, 39.06589], [-122.58268, 39.0646], [-122.58334, 39.06442], [-122.58394, 39.06571]]]} | Open Access 1 | Lake holding 50 | 20940 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 2.296 | Lake holding 50 | ||
1453 | 1453 | 1452 | {"type": "Polygon", "coordinates": [[[-122.80164, 39.09403], [-122.80152, 39.09441], [-122.80067, 39.09487], [-122.79979, 39.09391], [-122.80015, 39.09374], [-122.80017, 39.09381], [-122.80021, 39.09387], [-122.80034, 39.09397], [-122.80057, 39.09394], [-122.80068, 39.09403], [-122.80164, 39.09403]]]} | Open Access 1 | Alpine County Park | 15406 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 2.314 | Alpine County Park | ||
14371 | 14371 | 14370 | {"type": "MultiPolygon", "coordinates": [[[[-122.8561, 39.12309], [-122.8559, 39.12333], [-122.85598, 39.12336], [-122.85598, 39.12372], [-122.85553, 39.12412], [-122.85491, 39.12451], [-122.85491, 39.12435], [-122.8548, 39.12417], [-122.8548, 39.12402], [-122.85488, 39.12397], [-122.85512, 39.12361], [-122.8558, 39.12311], [-122.8561, 39.12309]]], [[[-122.85561, 39.12309], [-122.85501, 39.12353], [-122.85481, 39.12388], [-122.85482, 39.12309], [-122.85494, 39.12304], [-122.8551, 39.12301], [-122.85525, 39.12302], [-122.85561, 39.12309]]]]} | Open Access 1 | Unnamed Site - Lake, Couty of | http://www.lakecountyca.gov/Government/Directory/Parks/Parks/Search/Keeling_County_Park.htm | 32892 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 2.681 | ||
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 | ||
5698 | 5698 | 5697 | {"type": "Polygon", "coordinates": [[[-122.83362, 38.97767], [-122.83362, 38.97822], [-122.83322, 38.97823], [-122.8332, 38.97841], [-122.83194, 38.97842], [-122.83194, 38.97749], [-122.83362, 38.97767]]]} | Open Access 1 | Kelseyville County Park | 20592 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 3.158 | Kelseyville County Park | ||
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 | ||
5925 | 5925 | 5924 | {"type": "Polygon", "coordinates": [[[-122.58053, 39.05051], [-122.57867, 39.0505], [-122.5787, 39.04838], [-122.58003, 39.04844], [-122.58027, 39.04833], [-122.58037, 39.04845], [-122.58009, 39.04849], [-122.5799, 39.04854], [-122.57937, 39.04851], [-122.57927, 39.04866], [-122.57929, 39.0489], [-122.5794, 39.04938], [-122.57964, 39.04988], [-122.58009, 39.05022], [-122.58037, 39.05029], [-122.58053, 39.05041], [-122.58053, 39.05051]]]} | Open Access 1 | Lake holding 22 | 20909 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 4.826 | Lake holding 22 | ||
5875 | 5875 | 5874 | {"type": "Polygon", "coordinates": [[[-122.5919, 39.07178], [-122.59122, 39.07237], [-122.58979, 39.07174], [-122.58926, 39.07143], [-122.58996, 39.07102], [-122.59062, 39.0706], [-122.5919, 39.07178]]]} | Open Access 1 | Lake holding 39 | 20927 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 5.422 | Lake holding 39 | ||
6453 | 6453 | 6452 | {"type": "MultiPolygon", "coordinates": [[[[-122.79578, 39.09064], [-122.79316, 39.09184], [-122.7929, 39.09159], [-122.79562, 39.09034], [-122.79578, 39.09064]]], [[[-122.79712, 39.0901], [-122.79604, 39.09058], [-122.79567, 39.0898], [-122.79554, 39.08961], [-122.79536, 39.08941], [-122.7961, 39.08908], [-122.79625, 39.08915], [-122.79632, 39.08922], [-122.79651, 39.08943], [-122.79661, 39.08959], [-122.79677, 39.08968], [-122.79696, 39.08974], [-122.79707, 39.08983], [-122.79713, 39.08998], [-122.79712, 39.0901]]]]} | Open Access 1 | Lucerne Harbor County Park | 21576 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 5.641 | Lucerne Harbor County Park | ||
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 | ||
1201 | 1201 | 1200 | {"type": "MultiPolygon", "coordinates": [[[[-122.85802, 39.12304], [-122.85668, 39.12262], [-122.85602, 39.12265], [-122.85573, 39.12268], [-122.85483, 39.12265], [-122.85409, 39.12267], [-122.85405, 39.12257], [-122.85435, 39.12248], [-122.85549, 39.12201], [-122.85601, 39.12188], [-122.85651, 39.1218], [-122.85686, 39.12178], [-122.85739, 39.12185], [-122.85768, 39.12209], [-122.85802, 39.12297], [-122.85802, 39.12304]]], [[[-122.85601, 39.12126], [-122.8559, 39.12129], [-122.85574, 39.12139], [-122.85532, 39.12188], [-122.85485, 39.12209], [-122.85486, 39.12147], [-122.85601, 39.1211], [-122.85601, 39.12126]]], [[[-122.85601, 39.12176], [-122.85601, 39.12176], [-122.85549, 39.12188], [-122.85584, 39.12147], [-122.85601, 39.12137], [-122.85601, 39.12176]]]]} | Open Access 1 | Keeling Park | 32891 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 7.374 | Keeling Park | ||
5913 | 5913 | 5912 | {"type": "Polygon", "coordinates": [[[-122.58418, 39.06987], [-122.58329, 39.07017], [-122.58306, 39.07018], [-122.58283, 39.07012], [-122.58263, 39.07], [-122.58141, 39.06881], [-122.58132, 39.0687], [-122.58124, 39.06857], [-122.5818, 39.06862], [-122.58196, 39.06838], [-122.58292, 39.06817], [-122.58318, 39.06844], [-122.58324, 39.06859], [-122.58332, 39.0687], [-122.58357, 39.06894], [-122.58389, 39.06918], [-122.58406, 39.06939], [-122.58418, 39.06987]]]} | Open Access 1 | Lake holding 31 | 20919 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 7.694 | Lake holding 31 | ||
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 | ||
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 | ||
5699 | 5699 | 5698 | {"type": "Polygon", "coordinates": [[[-122.83564, 38.97899], [-122.83528, 38.98054], [-122.8352, 38.98055], [-122.83488, 38.98199], [-122.83373, 38.98198], [-122.83372, 38.98059], [-122.83372, 38.97955], [-122.83425, 38.97961], [-122.83427, 38.97881], [-122.83564, 38.97899]]]} | Open Access 1 | Kelseyville Park | 20593 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 10.479 | Kelseyville 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]);