units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 2, COUNTY = 41 and MNG_AGENCY = 128
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, LABEL_NAME
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3108 | 3108 | 3107 | {"type": "MultiPolygon", "coordinates": [[[[-121.46234, 38.2686], [-121.46231, 38.26876], [-121.46161, 38.26911], [-121.46002, 38.26922], [-121.45923, 38.26938], [-121.45839, 38.2697], [-121.45775, 38.26965], [-121.45753, 38.26953], [-121.45774, 38.2673], [-121.45781, 38.26714], [-121.4579, 38.2664], [-121.45801, 38.26606], [-121.4583, 38.26581], [-121.45862, 38.26576], [-121.45932, 38.26588], [-121.46083, 38.2659], [-121.46118, 38.26624], [-121.46112, 38.26713], [-121.46132, 38.26782], [-121.46167, 38.26823], [-121.46211, 38.2684], [-121.46234, 38.2686]]], [[[-121.68459, 38.14478], [-121.68456, 38.14487], [-121.68445, 38.14505], [-121.68418, 38.14541], [-121.68404, 38.14611], [-121.68393, 38.14638], [-121.68387, 38.14656], [-121.68386, 38.14674], [-121.68389, 38.14684], [-121.6838, 38.14733], [-121.68366, 38.14777], [-121.68363, 38.148], [-121.68355, 38.14839], [-121.68327, 38.14912], [-121.68318, 38.14929], [-121.68312, 38.1493], [-121.68345, 38.14644], [-121.68406, 38.14476], [-121.68459, 38.14478]]]]} | Restricted Access 2 | 25288 | Cosumnes River Preserve | 17678 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 35.364 | Cosumnes River Preserve | 0 | State Conservation Area 8 | 2 | ||
| 4306 | 4306 | 4305 | {"type": "Polygon", "coordinates": [[[-121.47627, 38.28439], [-121.47627, 38.28439], [-121.47626, 38.29098], [-121.47106, 38.28433], [-121.47627, 38.28439]]]} | Restricted Access 2 | 45350 | Stone Lakes | 25872 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 41.206 | Stone Lakes | None 380 | ||||
| 11278 | 11278 | 11277 | {"type": "MultiPolygon", "coordinates": [[[[-121.47063, 38.2699], [-121.4706, 38.27064], [-121.45934, 38.27057], [-121.45744, 38.27053], [-121.45753, 38.26953], [-121.45775, 38.26965], [-121.45839, 38.2697], [-121.45923, 38.26938], [-121.46002, 38.26922], [-121.46161, 38.26911], [-121.46231, 38.26876], [-121.46234, 38.2686], [-121.46211, 38.2684], [-121.46167, 38.26823], [-121.46132, 38.26782], [-121.46112, 38.26713], [-121.46118, 38.26625], [-121.46083, 38.2659], [-121.45932, 38.26588], [-121.45862, 38.26576], [-121.45831, 38.26581], [-121.45801, 38.26607], [-121.4579, 38.2664], [-121.45781, 38.26714], [-121.45774, 38.2673], [-121.45767, 38.2673], [-121.45787, 38.26584], [-121.45678, 38.26697], [-121.4556, 38.26691], [-121.45491, 38.26671], [-121.45329, 38.26679], [-121.45334, 38.26641], [-121.45342, 38.2664], [-121.45386, 38.26294], [-121.45446, 38.25887], [-121.45447, 38.25847], [-121.45468, 38.2569], [-121.45524, 38.25732], [-121.45555, 38.2575], [-121.45556, 38.25748], [-121.45578, 38.25759], [-121.45787, 38.25723], [-121.45864, 38.25732], [-121.45909, 38.25763], [-121.45934, 38.25812], [-121.45982, 38.25857], [-121.46072, 38.25902], [-121.46149, 38.25921], [-121.46136, 38.26017], [-121.46129, 38.2603], [-121.46105, 38.26172], [-121.46263, 38.26384], [-121.46222, 38.26635], [-121.46232, 38.26641], [-121.46232, 38.26645], [-121.46266, 38.26659], [-121.46431, 38.26748], [-121.46447, 38.26828], [-121.46365, 38.26984], [-121.47063, 38.2699]]], [[[-121.50963, 38.2458], [-121.50927, 38.24638], [-121.50921, 38.24636], [-121.50864, 38.24741], [-121.50384, 38.24617], [-121.5037, 38.24612], [-121.50353, 38.24609], [-121.50271, 38.24588], [-121.50332, 38.25019], [-121.50249, 38.25022], [-121.50189, 38.25041], [-121.50176, 38.25041], [-121.50146, 38.25033], [-121.50137, 38.25027], [-121.50135, 38.2503], [-121.5013, 38.25028], [-121.50021, 38.25049], [-121.50021, 38.25051], [-121.5007, 38.25092], [-121.50104, 38.25101], [-121.50058, 38.25107], [-121.50044, 38.25101], [-121.50033, 38.25084], [-121.50004, 38.2507], [-121.49992, 38.25044], [-121.49966, 38.25014], [-121.49947, 38.24987], [-121.49933, 38.24952], [-121.49916, 38.24938], [-121.49894, 38.24893], [-121.4988, 38.24871], [-121.49867, 38.24842], [-121.49845, 38.24755], [-121.49846, 38.24721], [-121.4984, 38.24683], [-121.49827, 38.24643], [-121.49813, 38.2461], [-121.49781, 38.24554], [-121.49768, 38.24512], [-121.49757, 38.24494], [-121.49745, 38.24449], [-121.49737, 38.24423], [-121.49733, 38.24387], [-121.49726, 38.24348], [-121.49726, 38.24268], [-121.49731, 38.24198], [-121.49738, 38.24147], [-121.49733, 38.24066], [-121.49736, 38.24046], [-121.49739, 38.2404], [-121.49744, 38.24035], [-121.49751, 38.24033], [-121.49763, 38.24034], [-121.49767, 38.2403], [-121.49771, 38.24021], [-121.49806, 38.24029], [-121.498, 38.24057], [-121.49802, 38.2411], [-121.49806, 38.24127], [-121.49818, 38.24151], [-121.49846, 38.24191], [-121.49871, 38.24222], [-121.49906, 38.24253], [-121.49937, 38.24273], [-121.49966, 38.24285], [-121.50023, 38.24302], [-121.5084, 38.24517], [-121.50877, 38.24532], [-121.50886, 38.24538], [-121.50905, 38.24565], [-121.50963, 38.2458]]]]} | Restricted Access 2 | 21796 | Cosumnes River Preserve | 17678 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 329.27 | Cosumnes River Preserve | 0 | 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]);