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/Bass-Hill-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15326 | 15326 | 15325 | {"type": "MultiPolygon", "coordinates": [[[[-120.56401, 40.35918], [-120.56401, 40.3614], [-120.54979, 40.36155], [-120.54033, 40.36155], [-120.54033, 40.3543], [-120.53345, 40.35428], [-120.53347, 40.35366], [-120.53493, 40.35245], [-120.53464, 40.35211], [-120.53376, 40.35256], [-120.53031, 40.35237], [-120.52381, 40.35203], [-120.52422, 40.35061], [-120.52421, 40.3506], [-120.52179, 40.3506], [-120.51175, 40.34885], [-120.51159, 40.34885], [-120.51152, 40.34697], [-120.49318, 40.34684], [-120.49313, 40.34335], [-120.49074, 40.34333], [-120.49067, 40.34169], [-120.48837, 40.34159], [-120.48831, 40.33794], [-120.4859, 40.33795], [-120.48568, 40.3363], [-120.48225, 40.33629], [-120.48195, 40.32162], [-120.49729, 40.32166], [-120.49732, 40.32901], [-120.50211, 40.329], [-120.50218, 40.33264], [-120.50678, 40.33261], [-120.50678, 40.32899], [-120.53056, 40.3289], [-120.5305, 40.32552], [-120.53434, 40.32547], [-120.53454, 40.32548], [-120.53469, 40.32553], [-120.53486, 40.32567], [-120.53493, 40.32582], [-120.53496, 40.32839], [-120.53502, 40.32874], [-120.53512, 40.32895], [-120.53527, 40.32905], [-120.53544, 40.3291], [-120.53564, 40.32911], [-120.53595, 40.32908], [-120.53623, 40.32908], [-120.54228, 40.32889], [-120.54205, 40.33065], [-120.54463, 40.33071], [-120.54464, 40.3307], [-120.54462, 40.32913], [-120.54507, 40.32988], [-120.54558, 40.3306], [-120.54624, 40.3314], [-120.54701, 40.33221], [-120.54787, 40.33292], [-120.54875, 40.33355], [-120.54968, 40.33408], [-120.55069, 40.33452], [-120.55436, 40.33589], [-120.55499, 40.33608], [-120.55907, 40.33604], [-120.55911, 40.33967], [-120.55886, 40.33967], [-120.55885, 40.33968], [-120.55949, 40.34067], [-120.55965, 40.34207], [-120.56046, 40.34235], [-120.56004, 40.34326], [-120.55918, 40.34505], [-120.55866, 40.34626], [-120.55835, 40.34693], [-120.55441, 40.34699], [-120.55447, 40.35061], [-120.5497, 40.35068], [-120.54976, 40.35792], [-120.55925, 40.35782], [-120.55925, 40.353], [-120.55979, 40.35354], [-120.55961, 40.35363], [-120.55961, 40.35366], [-120.56007, 40.35418], [-120.56401, 40.35918]]], [[[-120.60011, 40.35417], [-120.59965, 40.3544], [-120.59914, 40.35487], [-120.59901, 40.35528], [-120.59905, 40.35573], [-120.59912, 40.356], [-120.59926, 40.35635], [-120.5993, 40.35664], [-120.59928, 40.357], [-120.5991, 40.35785], [-120.59877, 40.35879], [-120.59868, 40.35923], [-120.59864, 40.35949], [-120.59863, 40.35971], [-120.59843, 40.36012], [-120.59812, 40.36081], [-120.59811, 40.36109], [-120.59813, 40.36139], [-120.59664, 40.36139], [-120.59667, 40.36504], [-120.58709, 40.36488], [-120.57866, 40.365], [-120.57925, 40.36323], [-120.57402, 40.36078], [-120.57438, 40.35987], [-120.5723, 40.35807], [-120.57155, 40.35839], [-120.57076, 40.35762], [-120.56837, 40.35777], [-120.56835, 40.35772], [-120.56425, 40.35777], [-120.56401, 40.35746], [-120.56227, 40.35551], [-120.56161, 40.35481], [-120.56169, 40.35458], [-120.5616, 40.35445], [-120.56126, 40.35446], [-120.55925, 40.35164], [-120.55919, 40.34633], [-120.56063, 40.34329], [-120.56127, 40.34284], [-120.56198, 40.34032], [-120.56248, 40.34019], [-120.56287, 40.34055], [-120.56321, 40.34075], [-120.56384, 40.34101], [-120.56432, 40.34111], [-120.56511, 40.34111], [-120.5655, 40.34107], [-120.56583, 40.34097], [-120.56618, 40.3408], [-120.56643, 40.3406], [-120.56669, 40.34027], [-120.5669, 40.33975], [-120.56705, 40.33931], [-120.56721, 40.33904], [-120.56834, 40.33761], [-120.56956, 40.33617], [-120.57565, 40.33623], [-120.57591, 40.33645], [-120.57606, 40.33653], [-120.57614, 40.33662], [-120.57638, 40.33671], [-120.57652, 40.33682], [-120.5766, 40.33693], [-120.57679, 40.33726], [-120.57688, 40.33733], [-120.57698, 40.33738], [-120.5772, 40.33743], [-120.57782, 40.3375], [-120.57776, 40.34132], [-120.57777, 40.34684], [-120.58715, 40.34687], [-120.59183, 40.35063], [-120.59444, 40.35068], [-120.59655, 40.35069], [-120.5966, 40.35414], [-120.60011, 40.35417]]]]} | Open Access 1 | Bass Hill Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bass-Hill-WA | 30413 | 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 | 5505.979 | Bass Hill Wildlife Area | 1977 |
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]);