units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 45, DES_TP = 209 and MNG_AGENCY = 47
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- California Department of Parks and Recreation · 1 ✖
DES_TP 1
- State Wilderness · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16598 | 16598 | 16597 | {"type": "MultiPolygon", "coordinates": [[[[-123.93946, 40.01887], [-123.93911, 40.01916], [-123.93884, 40.0194], [-123.93855, 40.01984], [-123.93854, 40.01992], [-123.9383, 40.01993], [-123.93827, 40.02004], [-123.93827, 40.02051], [-123.93832, 40.02105], [-123.93852, 40.02146], [-123.93875, 40.02156], [-123.93907, 40.02155], [-123.93843, 40.02184], [-123.93813, 40.02161], [-123.93799, 40.02145], [-123.93788, 40.02123], [-123.93784, 40.0211], [-123.93779, 40.02083], [-123.93779, 40.02065], [-123.93783, 40.02035], [-123.93783, 40.02022], [-123.93783, 40.02008], [-123.93779, 40.01993], [-123.938, 40.01962], [-123.93807, 40.01935], [-123.938, 40.01897], [-123.93784, 40.01866], [-123.93758, 40.01833], [-123.93698, 40.01786], [-123.93633, 40.01729], [-123.93564, 40.01677], [-123.93501, 40.01632], [-123.935, 40.01643], [-123.93445, 40.01596], [-123.93398, 40.01565], [-123.93358, 40.01533], [-123.93344, 40.01519], [-123.9334, 40.01486], [-123.93346, 40.0148], [-123.93373, 40.01415], [-123.93377, 40.01389], [-123.93366, 40.01369], [-123.93341, 40.01348], [-123.93258, 40.01291], [-123.93238, 40.01273], [-123.932, 40.01207], [-123.93182, 40.01192], [-123.93117, 40.0117], [-123.93093, 40.01153], [-123.93061, 40.01122], [-123.93047, 40.01105], [-123.93027, 40.01075], [-123.93002, 40.0103], [-123.92992, 40.01003], [-123.92954, 40.0101], [-123.92943, 40.00986], [-123.92996, 40.00971], [-123.93001, 40.00963], [-123.93, 40.00945], [-123.9299, 40.0092], [-123.92966, 40.00896], [-123.92552, 40.00897], [-123.92566, 40.00527], [-123.9301, 40.0054], [-123.93, 40.00572], [-123.93002, 40.006], [-123.93001, 40.00614], [-123.92988, 40.00632], [-123.92984, 40.00744], [-123.92979, 40.00758], [-123.92986, 40.00772], [-123.93002, 40.00799], [-123.92998, 40.00828], [-123.93, 40.00867], [-123.93015, 40.00907], [-123.93485, 40.00921], [-123.93475, 40.01267], [-123.935, 40.01605], [-123.93545, 40.01622], [-123.93567, 40.01643], [-123.93677, 40.01713], [-123.93719, 40.01753], [-123.93823, 40.01813], [-123.93919, 40.01849], [-123.93929, 40.01858], [-123.93928, 40.01869], [-123.93911, 40.01887], [-123.93911, 40.01889], [-123.93946, 40.01887]]], [[[-123.93798, 40.02166], [-123.9373, 40.02234], [-123.93638, 40.02269], [-123.93547, 40.02291], [-123.93529, 40.01998], [-123.93368, 40.02012], [-123.93366, 40.01977], [-123.93347, 40.01952], [-123.93331, 40.01896], [-123.93277, 40.01858], [-123.93266, 40.01823], [-123.93239, 40.01797], [-123.93202, 40.01788], [-123.9317, 40.01789], [-123.93158, 40.01776], [-123.93214, 40.0173], [-123.93266, 40.0171], [-123.9334, 40.01678], [-123.93436, 40.01603], [-123.93562, 40.01696], [-123.93686, 40.01805], [-123.93606, 40.01814], [-123.93606, 40.01816], [-123.93632, 40.0185], [-123.9357, 40.01855], [-123.93638, 40.01947], [-123.93789, 40.01943], [-123.93762, 40.01993], [-123.93765, 40.02033], [-123.93694, 40.0203], [-123.93687, 40.02137], [-123.9377, 40.02141], [-123.93777, 40.02138], [-123.93785, 40.0215], [-123.93798, 40.02166]]], [[[-124.00725, 40.1433], [-124.00629, 40.14351], [-124.00437, 40.14229], [-124.00454, 40.14135], [-124.00532, 40.14173], [-124.00725, 40.1433]]]]} | Open Access 1 | 23082 | Sinkyone Wilderness State Park | 1747 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=429 | Humboldt 45 | 138.709 | Sinkyone Wilderness SP | 1975 | State Wilderness 209 | 2 |
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]);