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_LEV = 3 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
5937 | 5937 | 5936 | {"type": "Polygon", "coordinates": [[[-122.59856, 39.07599], [-122.59846, 39.0762], [-122.5984, 39.07616], [-122.59726, 39.07576], [-122.59696, 39.07574], [-122.59671, 39.07565], [-122.59692, 39.07546], [-122.59764, 39.07578], [-122.59831, 39.07595], [-122.59856, 39.07599]]]} | Open Access 1 | Lake holding 7 | 20942 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.677 | Lake holding 7 | ||
5927 | 5927 | 5926 | {"type": "Polygon", "coordinates": [[[-122.60266, 39.07852], [-122.60246, 39.07885], [-122.60223, 39.07853], [-122.60188, 39.07828], [-122.60102, 39.07803], [-122.60051, 39.07797], [-122.59998, 39.07801], [-122.59948, 39.07772], [-122.59909, 39.07741], [-122.59823, 39.07719], [-122.59784, 39.07698], [-122.59791, 39.07683], [-122.59762, 39.07657], [-122.59691, 39.07631], [-122.59639, 39.07629], [-122.59606, 39.07622], [-122.59518, 39.07571], [-122.59606, 39.07511], [-122.59618, 39.07535], [-122.59641, 39.07554], [-122.59696, 39.07574], [-122.59726, 39.07576], [-122.5984, 39.07616], [-122.59844, 39.07619], [-122.59856, 39.07599], [-122.59904, 39.07605], [-122.60016, 39.07662], [-122.60109, 39.07663], [-122.60164, 39.07693], [-122.60183, 39.07731], [-122.60206, 39.07727], [-122.60226, 39.07761], [-122.60234, 39.07804], [-122.60242, 39.07821], [-122.60253, 39.07838], [-122.60266, 39.07852]]]} | Open Access 1 | Lake holding 25 | 20912 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 18.101 | Lake holding 25 | ||
13689 | 13689 | 13688 | {"type": "Polygon", "coordinates": [[[-122.60707, 38.91107], [-122.6068, 38.91108], [-122.60679, 38.91127], [-122.60621, 38.91127], [-122.6062, 38.91083], [-122.60707, 38.91083], [-122.60707, 38.91107]]]} | Open Access 1 | Russell Rustici County Park | 31185 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.77 | Russell Rustici County Park | ||
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 | ||
6976 | 6976 | 6975 | {"type": "Polygon", "coordinates": [[[-122.61613, 38.75511], [-122.61574, 38.75571], [-122.61516, 38.75555], [-122.61543, 38.75493], [-122.61613, 38.75511]]]} | Open Access 1 | Middletown Park | 22209 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 1.072 | Middletown Park | ||
12499 | 12499 | 12498 | {"type": "Polygon", "coordinates": [[[-122.64111, 38.75882], [-122.64108, 38.75887], [-122.64102, 38.75892], [-122.64095, 38.75895], [-122.64084, 38.75895], [-122.64033, 38.75884], [-122.63064, 38.75622], [-122.63516, 38.74947], [-122.63921, 38.75517], [-122.63967, 38.75585], [-122.63994, 38.75632], [-122.64034, 38.75706], [-122.6411, 38.75872], [-122.64111, 38.75882]]]} | Open Access 1 | Middleton Trailside Park | 31182 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 106.71 | Middleton Trailside Park | ||
4963 | 4963 | 4962 | {"type": "Polygon", "coordinates": [[[-122.64546, 38.95345], [-122.64465, 38.95406], [-122.64401, 38.95384], [-122.64484, 38.95319], [-122.64546, 38.95345]]]} | Open Access 1 | Highlands Park | 19942 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 1.412 | Highlands Park | ||
1692 | 1692 | 1691 | {"type": "Polygon", "coordinates": [[[-122.64942, 38.96071], [-122.6494, 38.96072], [-122.64938, 38.96077], [-122.64933, 38.9608], [-122.6478, 38.96099], [-122.64748, 38.96099], [-122.64546, 38.96091], [-122.64543, 38.96088], [-122.64543, 38.9608], [-122.6454, 38.96078], [-122.64541, 38.95935], [-122.64913, 38.95936], [-122.64916, 38.95938], [-122.64919, 38.95955], [-122.64921, 38.95956], [-122.64942, 38.96071]]]} | Open Access 1 | Austin Park | 15713 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 14.576 | Austin Park | ||
12497 | 12497 | 12496 | {"type": "Polygon", "coordinates": [[[-122.67605, 39.02326], [-122.67603, 39.0234], [-122.6756, 39.02335], [-122.67556, 39.02348], [-122.67511, 39.02344], [-122.67522, 39.02283], [-122.67546, 39.02268], [-122.67605, 39.02326]]]} | Open Access 1 | Nylander County Park | 31180 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 1.08 | Nylander 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 | ||
5932 | 5932 | 5931 | {"type": "Polygon", "coordinates": [[[-122.78298, 39.06985], [-122.78285, 39.07024], [-122.78253, 39.07024], [-122.78268, 39.06984], [-122.78298, 39.06985]]]} | Open Access 1 | Lake holding 49 | 20938 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.292 | Lake holding 49 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);