units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 53, AGNCY_WEB = "http://nrs.ucop.edu/" and DES_TP = 1422
This data as json, copyable, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17007 | 17007 | 17006 | {"type": "Polygon", "coordinates": [[[-121.30092, 39.26083], [-121.30093, 39.25141], [-121.29619, 39.25136], [-121.29138, 39.25136], [-121.29148, 39.25507], [-121.28722, 39.2551], [-121.28722, 39.25573], [-121.28719, 39.25571], [-121.2868, 39.25585], [-121.28659, 39.25617], [-121.28643, 39.25645], [-121.28622, 39.25661], [-121.28578, 39.25669], [-121.28505, 39.25674], [-121.28474, 39.25696], [-121.28466, 39.25718], [-121.28448, 39.25737], [-121.28427, 39.2575], [-121.28398, 39.25754], [-121.28378, 39.25754], [-121.28316, 39.2576], [-121.28261, 39.25767], [-121.28241, 39.25761], [-121.28191, 39.25751], [-121.28135, 39.25708], [-121.28104, 39.25682], [-121.28063, 39.25662], [-121.28032, 39.25643], [-121.27993, 39.25627], [-121.27955, 39.25596], [-121.27898, 39.25524], [-121.27852, 39.25483], [-121.27772, 39.25438], [-121.277, 39.25428], [-121.27645, 39.25429], [-121.27583, 39.25439], [-121.27542, 39.25453], [-121.2751, 39.25473], [-121.27493, 39.25496], [-121.27223, 39.25492], [-121.27226, 39.25134], [-121.27005, 39.25133], [-121.26974, 39.25132], [-121.26978, 39.25105], [-121.26978, 39.25075], [-121.26949, 39.25002], [-121.26946, 39.24989], [-121.26952, 39.24989], [-121.26953, 39.24988], [-121.26939, 39.24965], [-121.26923, 39.24933], [-121.26916, 39.24918], [-121.26909, 39.24896], [-121.26878, 39.24763], [-121.26876, 39.24718], [-121.26882, 39.24667], [-121.26904, 39.24527], [-121.26905, 39.2448], [-121.26891, 39.24278], [-121.26889, 39.24173], [-121.2689, 39.24109], [-121.27325, 39.24134], [-121.27327, 39.23722], [-121.27748, 39.23723], [-121.27788, 39.23052], [-121.27806, 39.23032], [-121.2796, 39.2303], [-121.28206, 39.23057], [-121.283, 39.23055], [-121.28773, 39.2288], [-121.28768, 39.23274], [-121.29249, 39.23272], [-121.29248, 39.22873], [-121.29618, 39.2287], [-121.29612, 39.22304], [-121.30887, 39.22298], [-121.30758, 39.22803], [-121.30814, 39.22973], [-121.3148, 39.23303], [-121.31623, 39.23359], [-121.32226, 39.23519], [-121.32623, 39.23328], [-121.3269, 39.23267], [-121.32789, 39.23237], [-121.32841, 39.23194], [-121.32872, 39.23012], [-121.32905, 39.23011], [-121.32909, 39.23355], [-121.3338, 39.23349], [-121.33372, 39.23727], [-121.3243, 39.23737], [-121.32429, 39.23738], [-121.32452, 39.24449], [-121.33368, 39.24449], [-121.33366, 39.24792], [-121.32917, 39.24796], [-121.32919, 39.25147], [-121.32924, 39.25513], [-121.33372, 39.25512], [-121.33371, 39.26605], [-121.31481, 39.26614], [-121.30732, 39.2662], [-121.30748, 39.27044], [-121.31484, 39.27044], [-121.31493, 39.2805], [-121.30538, 39.28061], [-121.30542, 39.28434], [-121.30106, 39.2844], [-121.301, 39.29499], [-121.30318, 39.295], [-121.30147, 39.29639], [-121.30123, 39.29678], [-121.30095, 39.29746], [-121.30085, 39.29796], [-121.30099, 39.29839], [-121.30121, 39.29871], [-121.30158, 39.29893], [-121.30153, 39.29925], [-121.30093, 39.29933], [-121.30101, 39.30572], [-121.29676, 39.30573], [-121.2967, 39.30303], [-121.28711, 39.30295], [-121.2869, 39.29512], [-121.28248, 39.29517], [-121.28234, 39.2807], [-121.28742, 39.28071], [-121.2873, 39.27731], [-121.29637, 39.27717], [-121.29623, 39.26629], [-121.30109, 39.26624], [-121.30092, 39.26083]]]} | Restricted Access 2 | 620 | Sierra Foothill Research & Extension Center | 25454 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Yuba 25 | 5779.172 | Sierra Foothill Research & Extension Ctr. | 0 | None 1422 |
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]);