units_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)
Suggested facets: GAP_STS
DES_TP 4
MNG_AG_TYP 1
- County Agency · 56 ✖
MNG_AGENCY 1
- Lake, County of · 56 ✖
ACCESS_TYP 1
- Open Access 56
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13754 | 13754 | 13753 | {"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 | 36266 | Lake holding 44 | 20933 | 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.025 | Lake holding 44 | 0 | Local Other or Unknown 14 | 4 | |
13755 | 13755 | 13754 | {"type": "Polygon", "coordinates": [[[-122.84342, 38.97848], [-122.84318, 38.97845], [-122.843, 38.97792], [-122.84307, 38.97802], [-122.84329, 38.97819], [-122.84336, 38.97826], [-122.84341, 38.97837], [-122.84342, 38.97848]]]} | Open Access 1 | 36267 | Lake holding 45 | 20934 | 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.214 | Lake holding 45 | 0 | Local Other or Unknown 14 | 4 | |
3968 | 3968 | 3967 | {"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 | 36680 | Lake holding 30 | 20918 | 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.262 | Lake holding 30 | 0 | Local Other or Unknown 14 | 4 | |
884 | 884 | 883 | {"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 | 35936 | Lake holding 49 | 20938 | 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.292 | Lake holding 49 | 0 | Local Other or Unknown 14 | 4 | |
927 | 927 | 926 | {"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 | 35937 | Lake holding 33 | 20921 | 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.38 | Lake holding 33 | 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 | |
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 | |
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 | |
5996 | 5996 | 5995 | {"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 | 36270 | Lake holding 29 | 20916 | 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.756 | Lake holding 29 | 0 | Local Other or Unknown 14 | 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 | |
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 | |
13621 | 13621 | 13620 | {"type": "Polygon", "coordinates": [[[-122.84421, 39.12015], [-122.84404, 39.12101], [-122.84402, 39.12101], [-122.84398, 39.1212], [-122.84359, 39.12117], [-122.84377, 39.12015], [-122.84421, 39.12015]]]} | Open Access 1 | 35967 | Lake holding 47 | 20936 | 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.05 | Lake holding 47 | 0 | Local Other or Unknown 14 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
13590 | 13590 | 13589 | {"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 | 35924 | Lake holding 1 | 20895 | 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.798 | Lake holding 1 | 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]);