units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, MNG_AG_LEV = 1 and SUID_NMA = 21950
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11423 | 11423 | 11422 | {"type": "MultiPolygon", "coordinates": [[[[-121.30305, 38.54735], [-121.30211, 38.5479], [-121.30127, 38.54837], [-121.2953, 38.55181], [-121.29482, 38.55207], [-121.29427, 38.55231], [-121.2937, 38.5525], [-121.29335, 38.5526], [-121.29265, 38.55275], [-121.29246, 38.55278], [-121.29003, 38.5528], [-121.28957, 38.55274], [-121.28897, 38.55261], [-121.28836, 38.55242], [-121.28791, 38.55226], [-121.28551, 38.5512], [-121.28518, 38.55109], [-121.28486, 38.55102], [-121.28379, 38.55086], [-121.28308, 38.55082], [-121.28265, 38.55083], [-121.28259, 38.54964], [-121.28298, 38.54965], [-121.28397, 38.54949], [-121.28537, 38.54886], [-121.28599, 38.54831], [-121.28692, 38.54751], [-121.28713, 38.54683], [-121.28788, 38.54565], [-121.28812, 38.54522], [-121.28839, 38.54526], [-121.28848, 38.54518], [-121.29005, 38.54547], [-121.29024, 38.54486], [-121.29018, 38.54435], [-121.28998, 38.54383], [-121.28964, 38.54334], [-121.28791, 38.54363], [-121.28759, 38.54403], [-121.28589, 38.54301], [-121.28583, 38.54294], [-121.28639, 38.54202], [-121.28574, 38.54162], [-121.28514, 38.54238], [-121.28501, 38.54227], [-121.28488, 38.54207], [-121.28543, 38.54142], [-121.28547, 38.54098], [-121.28481, 38.54044], [-121.28397, 38.54], [-121.28293, 38.54004], [-121.28244, 38.54027], [-121.28118, 38.53964], [-121.28064, 38.53961], [-121.27946, 38.54002], [-121.27897, 38.54049], [-121.27866, 38.54086], [-121.2783, 38.54113], [-121.27786, 38.54135], [-121.27631, 38.54189], [-121.2764, 38.54203], [-121.27556, 38.54252], [-121.27453, 38.54244], [-121.27376, 38.54246], [-121.27307, 38.54332], [-121.27282, 38.54358], [-121.27375, 38.54468], [-121.27278, 38.54507], [-121.27227, 38.54435], [-121.27224, 38.54368], [-121.27233, 38.54302], [-121.27252, 38.54256], [-121.27246, 38.54215], [-121.27209, 38.54127], [-121.27177, 38.54079], [-121.27132, 38.5405], [-121.27142, 38.5403], [-121.27227, 38.54066], [-121.27301, 38.5409], [-121.27377, 38.54112], [-121.27493, 38.54155], [-121.27598, 38.54132], [-121.27663, 38.54074], [-121.2757, 38.53913], [-121.27535, 38.53918], [-121.27453, 38.53879], [-121.2726, 38.53884], [-121.27114, 38.53948], [-121.27019, 38.54032], [-121.26992, 38.54086], [-121.26982, 38.54135], [-121.26894, 38.54175], [-121.26856, 38.54449], [-121.2689, 38.54555], [-121.26937, 38.54647], [-121.26788, 38.54711], [-121.26917, 38.54757], [-121.26919, 38.54759], [-121.26923, 38.54765], [-121.2689, 38.54865], [-121.2688, 38.54869], [-121.26872, 38.54877], [-121.26856, 38.54887], [-121.26839, 38.54894], [-121.26831, 38.549], [-121.26706, 38.54949], [-121.26703, 38.54956], [-121.2661, 38.54997], [-121.26584, 38.54992], [-121.26464, 38.54933], [-121.26446, 38.54912], [-121.2637, 38.54838], [-121.26341, 38.54821], [-121.26297, 38.54721], [-121.26298, 38.54713], [-121.26297, 38.54709], [-121.26302, 38.54687], [-121.26313, 38.54672], [-121.26313, 38.5467], [-121.26121, 38.54672], [-121.2612, 38.54482], [-121.26109, 38.54475], [-121.26111, 38.53501], [-121.26859, 38.53502], [-121.26859, 38.53527], [-121.28764, 38.5349], [-121.29213, 38.53601], [-121.2884, 38.53879], [-121.28755, 38.53809], [-121.28787, 38.53781], [-121.28787, 38.53779], [-121.28664, 38.53694], [-121.2863, 38.53673], [-121.28504, 38.53627], [-121.28387, 38.53604], [-121.28242, 38.53602], [-121.28172, 38.5361], [-121.28183, 38.53748], [-121.28205, 38.5376], [-121.28355, 38.53763], [-121.28389, 38.53766], [-121.28467, 38.53784], [-121.28628, 38.5387], [-121.28665, 38.5387], [-121.28746, 38.53816], [-121.28831, 38.53886], [-121.28745, 38.53963], [-121.28745, 38.53965], [-121.30255, 38.53981], [-121.30254, 38.54027], [-121.29962, 38.54163], [-121.30305, 38.54735]]], [[[-121.27303, 38.54697], [-121.27298, 38.54745], [-121.27276, 38.5477], [-121.27231, 38.54795], [-121.27189, 38.54805], [-121.27153, 38.54807], [-121.27114, 38.54797], [-121.27069, 38.5477], [-121.27032, 38.54743], [-121.27016, 38.54712], [-121.27014, 38.54691], [-121.27016, 38.54678], [-121.27086, 38.54634], [-121.27185, 38.54597], [-121.27209, 38.54611], [-121.27236, 38.54639], [-121.27303, 38.54697]]]]} | Restricted Access 2 | 22251 | Mather | 21950 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Sacramento 41 | 927.044 | Mather | 0 | Federal Other or Unknown 87 | 4 |
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]);