units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, MNG_AGENCY = 25 and YR_EST = 1977
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY 1
- California Department of Fish and Wildlife · 5 ✖
DES_TP 1
ACCESS_TYP 1
- Open Access · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3789 | 3789 | 3788 | {"type": "Polygon", "coordinates": [[[-122.53485, 42.00248], [-122.53469, 42.00768], [-122.52356, 42.008], [-122.51518, 42.00803], [-122.51524, 42.00284], [-122.51523, 42.00283], [-122.49661, 42.00301], [-122.49641, 42.00806], [-122.47911, 42.00811], [-122.47695, 42.00243], [-122.46063, 42.00508], [-122.46071, 42.00824], [-122.44097, 42.00832], [-122.44105, 42.00534], [-122.46062, 42.00508], [-122.46063, 42.00507], [-122.46023, 41.99], [-122.44084, 41.99], [-122.44084, 41.97574], [-122.46107, 41.9753], [-122.46001, 41.96041], [-122.47665, 41.96001], [-122.49527, 41.96016], [-122.51653, 41.95928], [-122.51569, 41.97484], [-122.49676, 41.97463], [-122.49677, 41.9888], [-122.51478, 41.98873], [-122.51503, 41.98894], [-122.51525, 42.00283], [-122.53485, 42.00248]], [[-122.4765, 41.9889], [-122.47641, 41.97474], [-122.46468, 41.97517], [-122.46476, 41.98953], [-122.46491, 41.98968], [-122.4765, 41.9889]], [[-122.47696, 42.00242], [-122.4966, 42.00301], [-122.49676, 41.98889], [-122.47652, 41.9889], [-122.47696, 42.00242]]]} | Open Access 1 | 1071 | Horseshoe Ranch Wildlife Area | 30456 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Horseshoe-Ranch-WA | Siskiyou 28 | 5039.908 | Horseshoe Ranch Wildlife Area | 1977 | State Conservation Area 8 | 2 |
10508 | 10508 | 10507 | {"type": "Polygon", "coordinates": [[[-121.52114, 40.95708], [-121.51622, 40.95721], [-121.50255, 40.95658], [-121.50168, 40.94235], [-121.50182, 40.93863], [-121.51619, 40.9387], [-121.51625, 40.94229], [-121.51625, 40.94587], [-121.52105, 40.94594], [-121.52114, 40.95708]], [[-121.50644, 40.94503], [-121.50643, 40.94504], [-121.50716, 40.94577], [-121.50805, 40.94525], [-121.50735, 40.94452], [-121.50644, 40.94503]]]} | Open Access 1 | 18626 | Cinder Flats Wildlife Area | 30425 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cinder-Flats-WA | Shasta 27 | 721.677 | Cinder Flats Wildlife Area | 1977 | State Conservation Area 8 | 2 |
10899 | 10899 | 10898 | {"type": "Polygon", "coordinates": [[[-122.05051, 38.22638], [-122.04831, 38.23052], [-122.04458, 38.23041], [-122.03882, 38.23144], [-122.03895, 38.23298], [-122.03776, 38.23317], [-122.03799, 38.23288], [-122.03723, 38.23205], [-122.03681, 38.23172], [-122.03629, 38.23014], [-122.03596, 38.22989], [-122.03503, 38.22717], [-122.03484, 38.22698], [-122.03464, 38.22642], [-122.03467, 38.22634], [-122.03486, 38.22613], [-122.03509, 38.22646], [-122.03544, 38.2269], [-122.03584, 38.22711], [-122.03624, 38.22707], [-122.03655, 38.22691], [-122.03664, 38.22595], [-122.03698, 38.22601], [-122.03735, 38.22643], [-122.0379, 38.2268], [-122.03823, 38.2268], [-122.03866, 38.22655], [-122.03896, 38.22605], [-122.03922, 38.22604], [-122.03987, 38.2262], [-122.04083, 38.22673], [-122.04151, 38.22675], [-122.04164, 38.22665], [-122.0421, 38.22622], [-122.05051, 38.22638]]]} | Open Access 1 | 24425 | Peytonia Slough Ecological Reserve | 32260 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Peytonia-Slough-ER | Solano 26 | 153.527 | Peytonia Slough ER | 1977 | State Conservation Area 8 | 2 |
15560 | 15560 | 15559 | {"type": "Polygon", "coordinates": [[[-122.51309, 37.94185], [-122.51233, 37.94165], [-122.5123, 37.94128], [-122.51208, 37.94125], [-122.51177, 37.94123], [-122.51169, 37.94119], [-122.51169, 37.94101], [-122.51168, 37.94095], [-122.51166, 37.94091], [-122.51158, 37.94084], [-122.51147, 37.94082], [-122.51141, 37.94082], [-122.51131, 37.94086], [-122.51124, 37.94093], [-122.51114, 37.94119], [-122.51086, 37.94114], [-122.51089, 37.9414], [-122.50788, 37.94164], [-122.50736, 37.94159], [-122.50735, 37.9416], [-122.50743, 37.94212], [-122.50653, 37.94218], [-122.50612, 37.94214], [-122.50492, 37.94245], [-122.50442, 37.9419], [-122.49822, 37.93785], [-122.49771, 37.9377], [-122.49756, 37.93231], [-122.48843, 37.93247], [-122.48849, 37.93502], [-122.47975, 37.93517], [-122.48032, 37.93167], [-122.47993, 37.92898], [-122.49748, 37.92869], [-122.49757, 37.93231], [-122.49985, 37.93227], [-122.49976, 37.92865], [-122.50159, 37.92862], [-122.50166, 37.92813], [-122.4999, 37.92677], [-122.49976, 37.92573], [-122.49998, 37.92569], [-122.50038, 37.92567], [-122.50082, 37.92572], [-122.50127, 37.92581], [-122.50172, 37.92568], [-122.50214, 37.92546], [-122.5026, 37.92477], [-122.50292, 37.92455], [-122.50322, 37.9245], [-122.50365, 37.92455], [-122.50402, 37.92475], [-122.50465, 37.92518], [-122.50489, 37.92522], [-122.50532, 37.92522], [-122.5058, 37.92533], [-122.50631, 37.92523], [-122.50663, 37.92499], [-122.50678, 37.92501], [-122.50704, 37.92485], [-122.50756, 37.92432], [-122.5082, 37.92432], [-122.50821, 37.92438], [-122.50845, 37.92445], [-122.50852, 37.92451], [-122.50863, 37.92451], [-122.50871, 37.92446], [-122.50872, 37.92433], [-122.50879, 37.92431], [-122.50911, 37.92431], [-122.50936, 37.92435], [-122.50936, 37.92443], [-122.50942, 37.9245], [-122.50953, 37.9245], [-122.50961, 37.92445], [-122.50963, 37.9243], [-122.51036, 37.92429], [-122.51066, 37.92623], [-122.5105, 37.92629], [-122.51062, 37.9269], [-122.51068, 37.92729], [-122.51066, 37.9273], [-122.51068, 37.92739], [-122.5106, 37.92744], [-122.50987, 37.92778], [-122.50954, 37.92788], [-122.50901, 37.92814], [-122.50876, 37.92835], [-122.50865, 37.92853], [-122.50862, 37.92877], [-122.50843, 37.92956], [-122.50839, 37.92998], [-122.50832, 37.93034], [-122.50819, 37.9308], [-122.50798, 37.93199], [-122.50773, 37.93298], [-122.50753, 37.93394], [-122.50733, 37.93514], [-122.50733, 37.93585], [-122.50745, 37.93684], [-122.5122, 37.93636], [-122.5123, 37.93702], [-122.51061, 37.93718], [-122.5106, 37.9372], [-122.51082, 37.93841], [-122.51252, 37.93824], [-122.51309, 37.94185]], [[-122.50446, 37.93582], [-122.50453, 37.93582], [-122.50454, 37.93581], [-122.50437, 37.93562], [-122.50439, 37.93534], [-122.50425, 37.93454], [-122.50398, 37.93421], [-122.50415, 37.93393], [-122.50367, 37.93329], [-122.50374, 37.93288], [-122.50282, 37.93222], [-122.50222, 37.93178], [-122.50214, 37.93161], [-122.50225, 37.93586], [-122.50446, 37.93582]]]} | Open Access 1 | 14434 | Corte Madera Marsh Ecological Reserve | 32135 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Corte-Madera-Marsh-ER | Marin 23 | 599.846 | Corte Madera Marsh ER | 1977 | State Conservation Area 8 | 2 |
16714 | 16714 | 16713 | {"type": "MultiPolygon", "coordinates": [[[[-120.56401, 40.35918], [-120.56401, 40.3614], [-120.54979, 40.36155], [-120.54033, 40.36155], [-120.54033, 40.35429], [-120.53345, 40.35428], [-120.53347, 40.35366], [-120.53494, 40.35245], [-120.53464, 40.3521], [-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.51153, 40.34697], [-120.49318, 40.34684], [-120.49313, 40.34334], [-120.49074, 40.34333], [-120.49067, 40.34169], [-120.48837, 40.34159], [-120.48831, 40.33794], [-120.4859, 40.33795], [-120.48569, 40.3363], [-120.48225, 40.33629], [-120.48195, 40.32162], [-120.49729, 40.32166], [-120.49732, 40.32901], [-120.50211, 40.329], [-120.50217, 40.33264], [-120.50679, 40.33261], [-120.50678, 40.32899], [-120.53057, 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.32875], [-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.54204, 40.33065], [-120.54328, 40.33067], [-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.55885, 40.33967], [-120.55884, 40.33968], [-120.55949, 40.34067], [-120.55965, 40.34207], [-120.56046, 40.34235], [-120.56004, 40.34326], [-120.55917, 40.34505], [-120.55866, 40.34626], [-120.55835, 40.34693], [-120.55441, 40.34698], [-120.55447, 40.35061], [-120.5497, 40.35067], [-120.54976, 40.35793], [-120.55925, 40.35782], [-120.55925, 40.353], [-120.55979, 40.35354], [-120.55961, 40.35364], [-120.55961, 40.35365], [-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.35599], [-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.35806], [-120.57155, 40.35839], [-120.57076, 40.35762], [-120.56837, 40.35777], [-120.56836, 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.34056], [-120.56322, 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.57687, 40.33733], [-120.57698, 40.33738], [-120.5772, 40.33743], [-120.57782, 40.3375], [-120.57776, 40.34132], [-120.57776, 40.34684], [-120.58715, 40.34687], [-120.59183, 40.35064], [-120.59444, 40.35068], [-120.59655, 40.35069], [-120.5966, 40.35414], [-120.60011, 40.35417]]]]} | Open Access 1 | 5808 | Bass Hill Wildlife Area | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bass-Hill-WA | Lassen 54 | 5505.421 | Bass Hill Wildlife Area | 1977 | State Conservation Area 8 | 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]);