units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where COUNTY = 40 and DES_TP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, LABEL_NAME
MNG_AGENCY 3
MNG_AG_TYP 2
- County Agency 18
- City Agency 5
DES_TP 1
- Local Park · 23 ✖
ACCESS_TYP 1
- Open Access 23
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3098 | 3098 | 3097 | {"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 | 25217 | Alpine County Park | 15406 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 2.313 | Alpine County Park | 0 | Local Park 2 | 4 | |
3432 | 3432 | 3431 | {"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 | 25218 | Clearlake Oaks Beach County Park | 30779 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 2.026 | Clearlake Oaks Beach County Park | 0 | Local Park 2 | 4 | |
3433 | 3433 | 3432 | {"type": "Polygon", "coordinates": [[[-122.83362, 38.97767], [-122.83362, 38.97822], [-122.83321, 38.97823], [-122.8332, 38.97841], [-122.83194, 38.97842], [-122.83194, 38.97749], [-122.83362, 38.97767]]]} | Open Access 1 | 25234 | Kelseyville County Park | 20592 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 3.157 | Kelseyville County Park | 0 | Local Park 2 | 4 | |
3434 | 3434 | 3433 | {"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 | 25235 | Lucerne Harbor County Park | 21576 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 5.642 | Lucerne Harbor County Park | 0 | Local Park 2 | 4 | |
3462 | 3462 | 3461 | {"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 | 44168 | Highlands Park | 19942 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 1.413 | Highlands Park | 0 | Local Park 2 | 4 | |
3590 | 3590 | 3589 | {"type": "Polygon", "coordinates": [[[-122.91354, 39.04526], [-122.91319, 39.04525], [-122.91325, 39.04397], [-122.91353, 39.04397], [-122.91354, 39.04526]]]} | Open Access 1 | 48776 | Lakefront Park | 33502 | 1418 | Lakeport, City of 665 | City 2 | City Agency 2 | http://www.cityoflakeport.com/departments/home.aspx?deptID=79 | City 2 | 1418 | Lakeport, City of 653 | City 2 | City Agency 2 | Lake 40 | 0.958 | Lakefront Park | 0 | Local Park 2 | 4 | |
5613 | 5613 | 5612 | {"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 | 47465 | Pioneer Mini-Park | 31184 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 0.524 | Pioneer Mini-Park | 0 | Local Park 2 | 4 | |
5614 | 5614 | 5613 | {"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 | 47466 | Russell Rustici County Park | 31185 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 0.769 | Russell Rustici County Park | 0 | Local Park 2 | 4 | |
10195 | 10195 | 10194 | {"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 | 24766 | Middletown Park | 22209 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 1.072 | Middletown Park | 0 | Local Park 2 | 4 | |
12063 | 12063 | 12062 | {"type": "Polygon", "coordinates": [[[-122.64151, 38.95038], [-122.64118, 38.95123], [-122.64086, 38.9511], [-122.64118, 38.95027], [-122.64151, 38.95038]]]} | Open Access 1 | 24760 | Austin Park | 15714 | 1417 | Clearlake, City of 1003 | City 2 | City Agency 2 | http://www.clearlake.ca.us/ | City 2 | 1417 | Clearlake, City of 966 | City 2 | City Agency 2 | Lake 40 | 0.739 | Austin Park | 0 | Local Park 2 | 4 | |
12064 | 12064 | 12063 | {"type": "Polygon", "coordinates": [[[-122.63534, 38.94947], [-122.63525, 38.94947], [-122.63524, 38.9494], [-122.63406, 38.94939], [-122.63405, 38.94945], [-122.63181, 38.94943], [-122.63183, 38.94842], [-122.63533, 38.94841], [-122.63534, 38.94947]]]} | Open Access 1 | 24761 | Redbud Park | 24231 | 1417 | Clearlake, City of 1003 | City 2 | City Agency 2 | http://www.clearlake.ca.us/ | City 2 | 1417 | Clearlake, City of 966 | City 2 | City Agency 2 | Lake 40 | 8.446 | Redbud Park | 0 | Local Park 2 | 4 | |
12065 | 12065 | 12064 | {"type": "Polygon", "coordinates": [[[-122.91412, 39.0423], [-122.91409, 39.04383], [-122.9136, 39.04383], [-122.91332, 39.04381], [-122.91323, 39.04343], [-122.91317, 39.04286], [-122.91307, 39.0423], [-122.91404, 39.04229], [-122.91412, 39.0423]]]} | Open Access 1 | 24762 | Library Park | 21222 | 1418 | Lakeport, City of 665 | City 2 | City Agency 2 | http://www.cityoflakeport.com/departments/home.aspx?deptID=79 | City 2 | 1418 | Lakeport, City of 653 | City 2 | City Agency 2 | Lake 40 | 3.327 | Library Park | 0 | Local Park 2 | 4 | |
12066 | 12066 | 12065 | {"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 | 24763 | Keeling Park | 32891 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 7.376 | Keeling Park | 0 | Local Park 2 | 4 | |
12067 | 12067 | 12066 | {"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.02601], [-122.85226, 39.02602], [-122.85229, 39.02769]]]} | Open Access 1 | 24764 | Lakeside Park | 20977 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 47.437 | Lakeside Park | 0 | Local Park 2 | 4 | |
12068 | 12068 | 12067 | {"type": "Polygon", "coordinates": [[[-122.83564, 38.97899], [-122.83528, 38.98054], [-122.8352, 38.98054], [-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 | 24765 | Kelseyville Park | 20593 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 10.473 | Kelseyville Park | 0 | Local Park 2 | 4 | |
12089 | 12089 | 12088 | {"type": "MultiPolygon", "coordinates": [[[[-122.79242, 39.08558], [-122.79204, 39.08575], [-122.7918, 39.08552], [-122.79166, 39.08535], [-122.7915, 39.08507], [-122.79145, 39.08486], [-122.7914, 39.08451], [-122.79189, 39.08428], [-122.79198, 39.08444], [-122.7921, 39.08494], [-122.79217, 39.08506], [-122.79233, 39.08547], [-122.79242, 39.08558]]], [[[-122.79502, 39.08842], [-122.79451, 39.08867], [-122.79377, 39.08745], [-122.79383, 39.08734], [-122.79383, 39.0873], [-122.7938, 39.08722], [-122.79366, 39.08727], [-122.79352, 39.08714], [-122.79358, 39.08712], [-122.79358, 39.0871], [-122.79347, 39.0871], [-122.79242, 39.08611], [-122.79288, 39.08589], [-122.79301, 39.08596], [-122.79308, 39.0861], [-122.79325, 39.08622], [-122.79356, 39.08657], [-122.79421, 39.08685], [-122.79432, 39.087], [-122.79431, 39.08752], [-122.79436, 39.08767], [-122.79453, 39.08784], [-122.79458, 39.08795], [-122.79466, 39.08809], [-122.79486, 39.08824], [-122.79502, 39.08842]]], [[[-122.79734, 39.09099], [-122.7968, 39.09122], [-122.79645, 39.09104], [-122.79631, 39.09093], [-122.7962, 39.09079], [-122.79608, 39.09056], [-122.79712, 39.0901], [-122.79712, 39.09016], [-122.79706, 39.09028], [-122.79704, 39.09036], [-122.7971, 39.09061], [-122.79717, 39.09082], [-122.79734, 39.09099]]], [[[-122.79938, 39.09182], [-122.79934, 39.09201], [-122.79853, 39.09245], [-122.7981, 39.092], [-122.79897, 39.09161], [-122.79938, 39.09182]]], [[[-122.79971, 39.0928], [-122.79909, 39.09308], [-122.79874, 39.09269], [-122.79924, 39.09247], [-122.79931, 39.09262], [-122.79939, 39.09271], [-122.79947, 39.09275], [-122.79956, 39.09271], [-122.79964, 39.09277], [-122.79971, 39.0928]]], [[[-122.80016, 39.09381], [-122.80014, 39.09374], [-122.79982, 39.09389], [-122.79943, 39.09346], [-122.80005, 39.09318], [-122.8, 39.09328], [-122.80009, 39.09362], [-122.80014, 39.0937], [-122.80016, 39.09381]]], [[[-122.80057, 39.09394], [-122.80057, 39.09394], [-122.80056, 39.09394], [-122.80056, 39.09394], [-122.80057, 39.09394]]], [[[-122.80049, 39.09395], [-122.80054, 39.09395], [-122.80042, 39.09397], [-122.80049, 39.09395]]], [[[-122.80166, 39.09528], [-122.80146, 39.09536], [-122.80125, 39.09547], [-122.80071, 39.09487], [-122.80152, 39.09441], [-122.80144, 39.09468], [-122.80166, 39.09528]]]]} | Open Access 1 | 24899 | Lucerne Park | 21577 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 11.441 | Lucerne Park | 0 | Local Park 2 | 4 | |
12156 | 12156 | 12155 | {"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 | 25237 | Upper Lake County Park | 26729 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 8.593 | Upper Lake County Park | 0 | Local Park 2 | 4 | |
12578 | 12578 | 12577 | {"type": "MultiPolygon", "coordinates": [[[[-122.93251, 39.03039], [-122.93252, 39.03089], [-122.93244, 39.03317], [-122.93108, 39.03316], [-122.93107, 39.03334], [-122.93097, 39.03334], [-122.93064, 39.03419], [-122.93021, 39.03448], [-122.92929, 39.03452], [-122.92855, 39.03481], [-122.928, 39.03491], [-122.9272, 39.0347], [-122.92715, 39.03438], [-122.92945, 39.03441], [-122.92944, 39.03436], [-122.92805, 39.03433], [-122.92805, 39.03428], [-122.92814, 39.03423], [-122.92814, 39.03314], [-122.93107, 39.03316], [-122.93103, 39.03038], [-122.93251, 39.03039]]], [[[-122.93798, 39.03322], [-122.93792, 39.03639], [-122.93793, 39.03684], [-122.93451, 39.03685], [-122.9345, 39.03648], [-122.93338, 39.03647], [-122.93339, 39.03318], [-122.93569, 39.03321], [-122.93798, 39.03322]]]]} | Open Access 1 | 29139 | Westside Park and Dog Park | 27429 | 1418 | Lakeport, City of 665 | City 2 | City Agency 2 | http://www.cityoflakeport.com/departments/home.aspx?deptID=79 | City 2 | 1418 | Lakeport, City of 653 | City 2 | City Agency 2 | Lake 40 | 57.783 | Westside Park and Dog Park | 0 | Local Park 2 | 4 | |
13190 | 13190 | 13189 | {"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 | 35980 | Hinman County Park | 31183 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 0.8 | Hinman County Park | 0 | Local Park 2 | 4 | |
13592 | 13592 | 13591 | {"type": "Polygon", "coordinates": [[[-122.67605, 39.02326], [-122.67603, 39.0234], [-122.67559, 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 | 35927 | Nylander County Park | 31180 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 1.079 | Nylander County Park | 0 | Local Park 2 | 4 |
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]);