units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where DES_TP = 14 and MNG_AGENCY = 275 sorted by map
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Lake, County of · 36 ✖
DES_TP 1
- Local Other or Unknown · 36 ✖
ACCESS_TYP 1
- Open Access 36
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4795 | 4795 | 4794 | {"type": "MultiPolygon", "coordinates": [[[[-122.8561, 39.12309], [-122.85589, 39.12333], [-122.85598, 39.12336], [-122.85598, 39.12372], [-122.85553, 39.12412], [-122.85491, 39.12451], [-122.85491, 39.12434], [-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 | 48329 | Unnamed Site - Lake, Couty of | 32892 | 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 | http://www.lakecountyca.gov/Government/Directory/Parks/Parks/Search/Keeling_County_Park.htm | Lake 40 | 2.679 | 0 | Local Other or Unknown 14 | 4 | |
13986 | 13986 | 13985 | {"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 | 36669 | Lake holding 22 | 20909 | 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 | 4.825 | Lake holding 22 | 0 | Local Other or Unknown 14 | 4 | |
13612 | 13612 | 13611 | {"type": "Polygon", "coordinates": [[[-122.58335, 39.05434], [-122.58333, 39.06442], [-122.58269, 39.06461], [-122.58328, 39.06589], [-122.58332, 39.06588], [-122.58332, 39.06643], [-122.58147, 39.06705], [-122.58055, 39.06526], [-122.58, 39.06339], [-122.57999, 39.06218], [-122.58069, 39.06177], [-122.58002, 39.0596], [-122.58029, 39.05881], [-122.5797, 39.05518], [-122.57927, 39.05435], [-122.58335, 39.05434]]]} | Open Access 1 | 35958 | Lake holding 6 | 20941 | 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 | 91.232 | Lake holding 6 | 0 | Local Other or Unknown 14 | 4 | |
5142 | 5142 | 5141 | {"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 | 36685 | Lake holding 50 | 20940 | 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.296 | Lake holding 50 | 0 | Local Other or Unknown 14 | 4 | |
13985 | 13985 | 13984 | {"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 | 36668 | Lake holding 31 | 20919 | 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.694 | Lake holding 31 | 0 | Local Other or Unknown 14 | 4 | |
13610 | 13610 | 13609 | {"type": "Polygon", "coordinates": [[[-122.58509, 39.05743], [-122.58494, 39.05767], [-122.58471, 39.0589], [-122.58463, 39.05948], [-122.58473, 39.06], [-122.58334, 39.06003], [-122.58335, 39.05434], [-122.5838, 39.05434], [-122.58428, 39.05545], [-122.58455, 39.05592], [-122.58476, 39.05642], [-122.5849, 39.05694], [-122.58509, 39.05743]]]} | Open Access 1 | 35957 | Lake holding 5 | 20939 | 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 | 17.146 | Lake holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13599 | 13599 | 13598 | {"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.06769], [-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 | 35939 | Lake holding 38 | 20926 | 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 | 13.996 | Lake holding 38 | 0 | Local Other or Unknown 14 | 4 | |
13634 | 13634 | 13633 | {"type": "Polygon", "coordinates": [[[-122.58539, 39.06463], [-122.58501, 39.06475], [-122.58455, 39.06512], [-122.58454, 39.06572], [-122.58461, 39.06646], [-122.58332, 39.06643], [-122.58333, 39.06588], [-122.58394, 39.0657], [-122.58335, 39.06442], [-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 | 35986 | Lake holding 26 | 20913 | 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 | 25.845 | Lake holding 26 | 0 | Local Other or Unknown 14 | 4 | |
13636 | 13636 | 13635 | {"type": "Polygon", "coordinates": [[[-122.58644, 39.072], [-122.58591, 39.07249], [-122.58556, 39.07269], [-122.5852, 39.07314], [-122.58404, 39.0735], [-122.5834, 39.07464], [-122.5835, 39.07201], [-122.58382, 39.0711], [-122.58321, 39.07029], [-122.58343, 39.07025], [-122.58507, 39.0697], [-122.58515, 39.06972], [-122.58531, 39.06986], [-122.58546, 39.06993], [-122.586, 39.07005], [-122.58631, 39.07018], [-122.58652, 39.07115], [-122.58654, 39.0716], [-122.58644, 39.072]]]} | Open Access 1 | 35988 | Lake holding 23 | 20910 | 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 | 21.899 | Lake holding 23 | 0 | Local Other or Unknown 14 | 4 | |
13633 | 13633 | 13632 | {"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 | 35985 | Lake holding 27 | 20914 | 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 | 15.156 | Lake holding 27 | 0 | Local Other or Unknown 14 | 4 | |
7688 | 7688 | 7687 | {"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 | 35938 | Lake holding 39 | 20927 | 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.422 | Lake holding 39 | 0 | Local Other or Unknown 14 | 4 | |
13602 | 13602 | 13601 | {"type": "Polygon", "coordinates": [[[-122.59518, 39.07571], [-122.59512, 39.07575], [-122.59446, 39.07539], [-122.5943, 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 | 35943 | Lake holding 34 | 20922 | 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.324 | Lake holding 34 | 0 | Local Other or Unknown 14 | 4 | |
13637 | 13637 | 13636 | {"type": "Polygon", "coordinates": [[[-122.59606, 39.07511], [-122.59518, 39.07571], [-122.59489, 39.07545], [-122.5946, 39.0751], [-122.594, 39.0747], [-122.59361, 39.0744], [-122.59328, 39.07408], [-122.593, 39.07393], [-122.59211, 39.07315], [-122.5918, 39.0733], [-122.59122, 39.07237], [-122.5919, 39.07178], [-122.59202, 39.07174], [-122.59228, 39.0718], [-122.59256, 39.07206], [-122.59296, 39.07226], [-122.5928, 39.07243], [-122.59295, 39.07245], [-122.59335, 39.07298], [-122.59349, 39.07311], [-122.59358, 39.07331], [-122.59415, 39.07361], [-122.59441, 39.07371], [-122.59455, 39.0738], [-122.59482, 39.07405], [-122.59503, 39.0741], [-122.5955, 39.07444], [-122.5958, 39.07463], [-122.59582, 39.07482], [-122.59596, 39.07494], [-122.59606, 39.07511]]]} | Open Access 1 | 35990 | Lake holding 21 | 20908 | 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 | 13.417 | Lake holding 21 | 0 | Local Other or Unknown 14 | 4 | |
3936 | 3936 | 3935 | {"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 | 36271 | Lake holding 32 | 20920 | 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.651 | Lake holding 32 | 0 | Local Other or Unknown 14 | 4 | |
13632 | 13632 | 13631 | {"type": "Polygon", "coordinates": [[[-122.59666, 39.07534], [-122.59641, 39.07554], [-122.59618, 39.07535], [-122.59606, 39.07511], [-122.59631, 39.07494], [-122.59666, 39.07534]]]} | Open Access 1 | 35984 | Lake holding 41 | 20930 | 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.441 | Lake holding 41 | 0 | Local Other or Unknown 14 | 4 | |
13601 | 13601 | 13600 | {"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.59639, 39.07629], [-122.59691, 39.07631], [-122.59762, 39.07657], [-122.59791, 39.07683]]]} | Open Access 1 | 35942 | Lake holding 35 | 20923 | 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.335 | Lake holding 35 | 0 | Local Other or Unknown 14 | 4 | |
13613 | 13613 | 13612 | {"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 | 35959 | Lake holding 7 | 20942 | 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.677 | Lake holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13635 | 13635 | 13634 | {"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.59822, 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.59845, 39.0762], [-122.59856, 39.07599], [-122.59904, 39.07605], [-122.60016, 39.07662], [-122.60109, 39.07663], [-122.60164, 39.07693], [-122.60183, 39.07732], [-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 | 35987 | Lake holding 25 | 20912 | 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 | 18.095 | Lake holding 25 | 0 | Local Other or Unknown 14 | 4 | |
13631 | 13631 | 13630 | {"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 | 35983 | Lake holding 43 | 20932 | 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.787 | Lake holding 43 | 0 | Local Other or Unknown 14 | 4 | |
13588 | 13588 | 13587 | {"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 | 35921 | Lake holding 40 | 20929 | 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.028 | Lake holding 40 | 0 | Local Other or Unknown 14 | 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]);