units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
214 rows where AGNCY_TYP = 3 and DES_TP = 14 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, COUNTY, YR_EST
MNG_AGENCY 23
- Butte, County of 52
- Santa Barbara, County of 39
- Lake, County of 36
- Orange, County of 21
- Monterey, County of 18
- Los Angeles, County of 11
- Sacramento, County of 6
- Ventura, County of 5
- Santa Cruz, County of 4
- San Diego, County of 4
- Tulare, County of 3
- Riverside, County of 3
- Merced, County of 2
- Placer, County of 1
- Imperial, County of 1
- San Bernardino, County of 1
- Napa, County of 1
- Yolo, County of 1
- Humboldt, County of 1
- Tehama, County of 1
- Trinity, County of 1
- Marin, County of 1
- Solano, County of 1
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency 214
DES_TP 1
- Local Other or Unknown · 214 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4758 | 4758 | 4757 | {"type": "Polygon", "coordinates": [[[-123.96182, 40.47601], [-123.96157, 40.47625], [-123.96067, 40.47662], [-123.95893, 40.478], [-123.95764, 40.47896], [-123.95666, 40.48], [-123.95668, 40.4767], [-123.95728, 40.4765], [-123.95804, 40.47633], [-123.9587, 40.47616], [-123.95966, 40.47599], [-123.96182, 40.47601]]]} | Restricted Access 2 | 46661 | Unnamed site - Humboldt, County of | 29996 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 19.487 | 0 | Local Other or Unknown 14 | 4 | ||
13929 | 13929 | 13928 | {"type": "Polygon", "coordinates": [[[-123.04559, 40.72947], [-123.045, 40.72987], [-123.04219, 40.72785], [-123.04232, 40.72778], [-123.0429, 40.72771], [-123.04327, 40.72772], [-123.04361, 40.72778], [-123.04451, 40.7284], [-123.04485, 40.72886], [-123.04559, 40.72947]]]} | Open Access 1 | 36535 | Trinity holding 1 | 26540 | 349 | Trinity, County of 1022 | County 3 | County Agency 3 | http://www.trinitycounty.org/ | County 3 | 349 | Trinity, County of 984 | County 3 | County Agency 3 | Trinity 46 | 6.066 | Trinity holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13607 | 13607 | 13606 | {"type": "Polygon", "coordinates": [[[-122.89337, 39.13328], [-122.88871, 39.13329], [-122.88871, 39.1332], [-122.88877, 39.13316], [-122.88878, 39.13309], [-122.88874, 39.13303], [-122.88866, 39.133], [-122.88857, 39.13303], [-122.88852, 39.13309], [-122.88854, 39.13316], [-122.8886, 39.1332], [-122.8886, 39.13329], [-122.88617, 39.13328], [-122.8858, 39.13288], [-122.88559, 39.13233], [-122.88591, 39.13145], [-122.88676, 39.12965], [-122.88655, 39.12909], [-122.88418, 39.12758], [-122.88395, 39.12737], [-122.88347, 39.12681], [-122.8834, 39.12657], [-122.88525, 39.12758], [-122.88647, 39.12756], [-122.89334, 39.12755], [-122.89337, 39.13328]]]} | Open Access 1 | 35953 | Lake holding 2 | 20906 | 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 | 102.257 | Lake holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13598 | 13598 | 13597 | {"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 | 35935 | Lake holding 12 | 20898 | 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 | 6.977 | Lake holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13629 | 13629 | 13628 | {"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 | 35975 | Lake holding 15 | 20901 | 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.73 | Lake holding 15 | 0 | Local Other or Unknown 14 | 4 | |
3768 | 3768 | 3767 | {"type": "Polygon", "coordinates": [[[-122.88764, 39.13862], [-122.88696, 39.13862], [-122.88696, 39.13744], [-122.88763, 39.13743], [-122.88764, 39.13862]]]} | Open Access 1 | 35976 | Lake holding 16 | 20902 | 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.909 | Lake holding 16 | 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 | |
13591 | 13591 | 13590 | {"type": "Polygon", "coordinates": [[[-122.88635, 39.13614], [-122.8863, 39.13862], [-122.88342, 39.13859], [-122.88375, 39.13812], [-122.88487, 39.13733], [-122.88578, 39.13657], [-122.88635, 39.13614]]]} | Open Access 1 | 35925 | Lake holding 8 | 20943 | 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 | 9.011 | Lake holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13094 | 13094 | 13093 | {"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 | 35977 | Lake holding 14 | 20900 | 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 | 9.084 | Lake holding 14 | 0 | Local Other or Unknown 14 | 4 | |
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 | |
13608 | 13608 | 13607 | {"type": "Polygon", "coordinates": [[[-122.84494, 39.12016], [-122.84493, 39.12125], [-122.84431, 39.12124], [-122.8441, 39.12121], [-122.8443, 39.12016], [-122.84494, 39.12016]]]} | Open Access 1 | 35954 | Lake holding 48 | 20937 | 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.887 | Lake holding 48 | 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 | |
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 | |
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 | |
13609 | 13609 | 13608 | {"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 | 35955 | Lake holding 46 | 20935 | 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.223 | Lake holding 46 | 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 | |
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 | |
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 |
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]);