superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Tehama-WA"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15374 | 15374 | 15373 | {"type": "MultiPolygon", "coordinates": [[[[-122.02009, 40.21033], [-122.02004, 40.21402], [-122.01871, 40.21737], [-122.01367, 40.21716], [-122.01223, 40.22065], [-122.01224, 40.22067], [-122.0123, 40.22067], [-122.01732, 40.22088], [-122.01382, 40.22863], [-122.00886, 40.2286], [-121.996, 40.22881], [-121.99539, 40.22927], [-121.9942, 40.22995], [-121.99291, 40.23061], [-121.99125, 40.23153], [-121.98949, 40.23245], [-121.98909, 40.23336], [-121.98874, 40.23398], [-121.98819, 40.2348], [-121.98747, 40.2354], [-121.9865, 40.23596], [-121.98557, 40.23628], [-121.98353, 40.23759], [-121.98196, 40.23846], [-121.98026, 40.23935], [-121.97907, 40.24011], [-121.9786, 40.24046], [-121.97727, 40.24109], [-121.97613, 40.2416], [-121.97492, 40.24232], [-121.97423, 40.24285], [-121.97322, 40.24392], [-121.97301, 40.24438], [-121.97325, 40.24443], [-121.97371, 40.24448], [-121.97493, 40.24509], [-121.97517, 40.24598], [-121.97525, 40.24695], [-121.97508, 40.24791], [-121.97475, 40.24857], [-121.97424, 40.24899], [-121.97355, 40.24946], [-121.97321, 40.24983], [-121.9728, 40.25023], [-121.97238, 40.25075], [-121.97198, 40.25139], [-121.97143, 40.25224], [-121.97111, 40.25293], [-121.97066, 40.25341], [-121.96952, 40.25375], [-121.96946, 40.24424], [-121.95114, 40.24439], [-121.93223, 40.24468], [-121.92278, 40.24474], [-121.92273, 40.25833], [-121.91367, 40.25839], [-121.91368, 40.25881], [-121.93205, 40.25916], [-121.93208, 40.27363], [-121.93214, 40.28822], [-121.95116, 40.28808], [-121.9511, 40.27361], [-121.95086, 40.25912], [-121.96956, 40.25839], [-121.96974, 40.27313], [-121.95588, 40.27347], [-121.9559, 40.27522], [-121.96976, 40.27499], [-121.98914, 40.27491], [-121.99398, 40.27495], [-121.99395, 40.28139], [-121.99389, 40.28724], [-121.98914, 40.28714], [-121.97919, 40.28722], [-121.96981, 40.28722], [-121.96984, 40.30188], [-121.96043, 40.30197], [-121.9508, 40.30213], [-121.94172, 40.30222], [-121.94141, 40.30948], [-121.95092, 40.30968], [-121.951, 40.31633], [-121.93186, 40.31646], [-121.91328, 40.31646], [-121.91337, 40.30208], [-121.89491, 40.30085], [-121.89489, 40.30086], [-121.89521, 40.30861], [-121.89556, 40.31635], [-121.8956, 40.32334], [-121.88527, 40.32349], [-121.88537, 40.31629], [-121.87647, 40.31622], [-121.87662, 40.32357], [-121.85765, 40.32376], [-121.8575, 40.31626], [-121.83843, 40.31619], [-121.83867, 40.30128], [-121.83847, 40.28681], [-121.85709, 40.28667], [-121.87605, 40.28659], [-121.87616, 40.27229], [-121.87602, 40.25775], [-121.87611, 40.24337], [-121.87616, 40.22903], [-121.87594, 40.21544], [-121.87566, 40.20048], [-121.87542, 40.18683], [-121.87524, 40.17183], [-121.85646, 40.17179], [-121.85618, 40.15744], [-121.83751, 40.15737], [-121.83744, 40.14292], [-121.9309, 40.14319], [-121.93706, 40.14345], [-121.9503, 40.14391], [-121.95033, 40.15732], [-121.96935, 40.15735], [-121.96943, 40.14339], [-121.99569, 40.14267], [-121.99525, 40.15697], [-121.96938, 40.15737], [-121.96973, 40.17112], [-121.96976, 40.17115], [-121.97001, 40.17115], [-121.9955, 40.1711], [-121.99582, 40.18517], [-121.99586, 40.18519], [-121.99629, 40.19939], [-122.01544, 40.1996], [-122.01517, 40.21018], [-122.02009, 40.21033]], [[-121.87512, 40.16633], [-121.87505, 40.1642], [-121.86963, 40.16431], [-121.86983, 40.16779], [-121.87514, 40.16774], [-121.87512, 40.16633]], [[-121.91366, 40.25883], [-121.89501, 40.25773], [-121.89507, 40.27212], [-121.91356, 40.27333], [-121.91366, 40.25883]], [[-121.92141, 40.15409], [-121.9214, 40.15408], [-121.91185, 40.15412], [-121.91191, 40.15767], [-121.92138, 40.15755], [-121.92141, 40.15409]], [[-121.91338, 40.30206], [-121.93161, 40.30224], [-121.93212, 40.28823], [-121.91348, 40.2877], [-121.91338, 40.30206]]], [[[-121.92598, 40.33169], [-121.9235, 40.33328], [-121.92336, 40.33336], [-121.92325, 40.33332], [-121.92316, 40.33337], [-121.92313, 40.33346], [-121.92243, 40.33381], [-121.92239, 40.33181], [-121.92598, 40.33169]]]]} | Open Access 1 | Tehama Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Tehama-WA | 30511 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 43689.004 | Tehama Wildlife Area | 1968 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);