superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where MNG_AGENCY = 275
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5617 | 5617 | 5616 | {"type": "Polygon", "coordinates": [[[-122.60778, 39.08981], [-122.60756, 39.08999], [-122.60624, 39.08881], [-122.60582, 39.08818], [-122.60598, 39.08813], [-122.60714, 39.08915], [-122.60778, 39.08981]]]} | Open Access 1 | Lake holding 43 | 20932 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 1.787 | Lake holding 43 | ||
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 | ||
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 | ||
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 | ||
5814 | 5814 | 5813 | {"type": "Polygon", "coordinates": [[[-122.59791, 39.07683], [-122.59784, 39.07698], [-122.59718, 39.07662], [-122.59667, 39.07654], [-122.59596, 39.07635], [-122.59569, 39.07621], [-122.59512, 39.07575], [-122.59518, 39.07571], [-122.59606, 39.07622], [-122.5964, 39.07629], [-122.59691, 39.07631], [-122.59762, 39.07657], [-122.59791, 39.07683]]]} | Open Access 1 | Lake holding 35 | 20923 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 1.335 | Lake holding 35 | ||
5863 | 5863 | 5862 | {"type": "Polygon", "coordinates": [[[-122.58526, 39.06827], [-122.58519, 39.06843], [-122.58504, 39.06928], [-122.58292, 39.06817], [-122.58196, 39.06838], [-122.58196, 39.06768], [-122.58147, 39.06706], [-122.58332, 39.06644], [-122.58461, 39.06646], [-122.58462, 39.06655], [-122.58457, 39.06748], [-122.58476, 39.06807], [-122.58526, 39.06827]]]} | Open Access 1 | Lake holding 38 | 20926 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 14.001 | Lake holding 38 | ||
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 | ||
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 | ||
5896 | 5896 | 5895 | {"type": "Polygon", "coordinates": [[[-122.58539, 39.06463], [-122.58501, 39.06475], [-122.58456, 39.06512], [-122.58454, 39.06572], [-122.58461, 39.06646], [-122.58332, 39.06643], [-122.58333, 39.06588], [-122.58394, 39.06569], [-122.58335, 39.06443], [-122.58333, 39.06442], [-122.58334, 39.06003], [-122.58473, 39.06], [-122.58484, 39.06052], [-122.58532, 39.06099], [-122.58551, 39.06152], [-122.58547, 39.06217], [-122.58519, 39.06348], [-122.58535, 39.06426], [-122.58539, 39.06463]]]} | Open Access 1 | Lake holding 26 | 20913 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 25.854 | Lake holding 26 | ||
5897 | 5897 | 5896 | {"type": "Polygon", "coordinates": [[[-122.59062, 39.0706], [-122.58996, 39.07102], [-122.58926, 39.07143], [-122.58852, 39.07099], [-122.58819, 39.07058], [-122.58765, 39.07032], [-122.58737, 39.07024], [-122.58637, 39.07005], [-122.58605, 39.06992], [-122.58628, 39.06913], [-122.5858, 39.069], [-122.58527, 39.06899], [-122.58538, 39.06842], [-122.58543, 39.06832], [-122.58585, 39.06847], [-122.58615, 39.06842], [-122.58667, 39.06877], [-122.58871, 39.06935], [-122.58927, 39.06953], [-122.59062, 39.0706]]]} | Open Access 1 | Lake holding 27 | 20914 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 15.161 | Lake holding 27 | ||
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 | ||
5907 | 5907 | 5906 | {"type": "Polygon", "coordinates": [[[-122.7831, 39.06946], [-122.78298, 39.06985], [-122.78268, 39.06984], [-122.78283, 39.06946], [-122.7831, 39.06946]]]} | Open Access 1 | Lake holding 30 | 20918 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.262 | Lake holding 30 | ||
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 | ||
5914 | 5914 | 5913 | {"type": "Polygon", "coordinates": [[[-122.59631, 39.07494], [-122.59606, 39.07511], [-122.59596, 39.07494], [-122.59582, 39.07482], [-122.5958, 39.07463], [-122.5955, 39.07444], [-122.59503, 39.0741], [-122.59482, 39.07405], [-122.59455, 39.0738], [-122.59441, 39.07371], [-122.59415, 39.07361], [-122.59358, 39.07331], [-122.59349, 39.07311], [-122.59335, 39.07298], [-122.59295, 39.07246], [-122.59279, 39.07243], [-122.59296, 39.07226], [-122.59312, 39.07235], [-122.59336, 39.07267], [-122.59341, 39.07292], [-122.59385, 39.07332], [-122.59445, 39.0736], [-122.59595, 39.07453], [-122.59631, 39.07494]]]} | Open Access 1 | Lake holding 32 | 20920 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 1.653 | Lake holding 32 | ||
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 | ||
5916 | 5916 | 5915 | {"type": "Polygon", "coordinates": [[[-122.59518, 39.07571], [-122.59512, 39.07575], [-122.59446, 39.07539], [-122.59429, 39.07507], [-122.59353, 39.07447], [-122.59313, 39.07422], [-122.59266, 39.07372], [-122.59205, 39.07329], [-122.5918, 39.0733], [-122.59211, 39.07315], [-122.593, 39.07393], [-122.59328, 39.07408], [-122.59361, 39.0744], [-122.594, 39.0747], [-122.5946, 39.0751], [-122.59489, 39.07545], [-122.59518, 39.07571]]]} | Open Access 1 | Lake holding 34 | 20922 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 1.325 | Lake holding 34 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);