units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where DES_TP = 8, MNG_AGENCY = 25, MNG_AG_TYP = 5 and SUID_NMA = 30441
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency · 2 ✖
MNG_AGENCY 1
- California Department of Fish and Wildlife · 2 ✖
DES_TP 1
- State Conservation Area · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16739 | 16739 | 16738 | {"type": "Polygon", "coordinates": [[[-121.66402, 38.76472], [-121.66387, 38.76479], [-121.66367, 38.76569], [-121.66354, 38.76632], [-121.66356, 38.76676], [-121.66354, 38.76708], [-121.66353, 38.76752], [-121.66345, 38.76773], [-121.66327, 38.76805], [-121.66321, 38.76823], [-121.66308, 38.7685], [-121.66299, 38.76866], [-121.66289, 38.76878], [-121.66262, 38.76896], [-121.66212, 38.76924], [-121.66181, 38.76933], [-121.66163, 38.76936], [-121.66127, 38.76937], [-121.66096, 38.76935], [-121.66005, 38.76914], [-121.65944, 38.76894], [-121.65906, 38.76878], [-121.65884, 38.76864], [-121.65837, 38.76827], [-121.65807, 38.76788], [-121.65789, 38.76751], [-121.65785, 38.76724], [-121.65792, 38.76626], [-121.65785, 38.76593], [-121.65765, 38.76562], [-121.65735, 38.76527], [-121.65671, 38.7649], [-121.65595, 38.76473], [-121.65562, 38.76462], [-121.65528, 38.76447], [-121.65482, 38.76433], [-121.65399, 38.76415], [-121.65318, 38.76411], [-121.65249, 38.76412], [-121.65204, 38.76422], [-121.65175, 38.76426], [-121.65146, 38.76435], [-121.65105, 38.76425], [-121.65059, 38.7643], [-121.65018, 38.76438], [-121.64964, 38.76446], [-121.64916, 38.76455], [-121.64824, 38.76478], [-121.64771, 38.76505], [-121.64739, 38.76518], [-121.6472, 38.76519], [-121.6469, 38.76529], [-121.64663, 38.76533], [-121.64613, 38.76544], [-121.64571, 38.7656], [-121.64539, 38.76571], [-121.64498, 38.76597], [-121.64441, 38.76615], [-121.64376, 38.76628], [-121.64312, 38.76632], [-121.64227, 38.76631], [-121.64175, 38.76634], [-121.6408, 38.76654], [-121.6405, 38.76665], [-121.6402, 38.76674], [-121.63963, 38.76663], [-121.63854, 38.76678], [-121.63745, 38.76691], [-121.63592, 38.76703], [-121.63554, 38.76703], [-121.63484, 38.76708], [-121.63519, 38.76534], [-121.63571, 38.76454], [-121.63577, 38.76431], [-121.63582, 38.76361], [-121.63581, 38.76332], [-121.63578, 38.76295], [-121.63577, 38.76268], [-121.63622, 38.76269], [-121.63623, 38.76268], [-121.63527, 38.74842], [-121.63496, 38.74139], [-121.66022, 38.74151], [-121.66026, 38.74465], [-121.66027, 38.74818], [-121.65922, 38.74819], [-121.65927, 38.75031], [-121.65813, 38.75162], [-121.65774, 38.75351], [-121.65854, 38.75422], [-121.65816, 38.75463], [-121.65802, 38.75499], [-121.65798, 38.75529], [-121.65802, 38.75552], [-121.65804, 38.75589], [-121.65808, 38.75614], [-121.658, 38.75643], [-121.65795, 38.75676], [-121.65798, 38.75709], [-121.65803, 38.75737], [-121.65808, 38.75752], [-121.65819, 38.75773], [-121.65834, 38.75814], [-121.65859, 38.75873], [-121.65875, 38.75923], [-121.65893, 38.75962], [-121.65902, 38.75986], [-121.65955, 38.76093], [-121.65966, 38.76126], [-121.66003, 38.76187], [-121.66027, 38.76198], [-121.66068, 38.76227], [-121.66162, 38.76303], [-121.66219, 38.76267], [-121.66378, 38.76462], [-121.66402, 38.76472]]]} | Open Access 1 | 21360 | Fremont Weir Wildlife Area | 30441 | 219 | Central Valley Flood Protection Board 1027 | State 5 | State Agency 5 | http://www.cvfpb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Yolo 33 | 1430.824 | Fremont Weir Wildlife Area | 1981 | State Conservation Area 8 | 2 | |
16769 | 16769 | 16768 | {"type": "Polygon", "coordinates": [[[-121.6699, 38.75847], [-121.66966, 38.75881], [-121.66912, 38.75884], [-121.66862, 38.75893], [-121.66828, 38.75904], [-121.66762, 38.75929], [-121.66717, 38.75941], [-121.66663, 38.75977], [-121.66617, 38.76013], [-121.66562, 38.76095], [-121.66491, 38.76228], [-121.66442, 38.76366], [-121.66425, 38.76403], [-121.66402, 38.76472], [-121.66378, 38.76462], [-121.66219, 38.76267], [-121.66228, 38.76192], [-121.66316, 38.76128], [-121.66353, 38.76093], [-121.66406, 38.76012], [-121.66489, 38.75876], [-121.66542, 38.75906], [-121.66683, 38.75878], [-121.66814, 38.7585], [-121.66873, 38.75845], [-121.6694, 38.75842], [-121.66985, 38.75842], [-121.6699, 38.75847]]]} | Open Access 1 | 29012 | Fremont Weir Wildlife Area | 30441 | 219 | Central Valley Flood Protection Board 1027 | State 5 | State Agency 5 | http://www.cvfpb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sutter 47 | 31.784 | Fremont Weir Wildlife Area | 1981 | 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]);