units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 40 and MNG_AGENCY = 73
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16502 | 16502 | 16501 | {"type": "MultiPolygon", "coordinates": [[[[-122.59311, 39.11142], [-122.57646, 39.11071], [-122.57567, 39.09937], [-122.57539, 39.09558], [-122.59275, 39.09708], [-122.59311, 39.11142]]], [[[-122.64769, 39.14144], [-122.64763, 39.15707], [-122.62982, 39.15656], [-122.62966, 39.14127], [-122.64769, 39.14144]]], [[[-122.81901, 39.20575], [-122.81461, 39.20412], [-122.80594, 39.20081], [-122.80577, 39.19854], [-122.81895, 39.20218], [-122.81901, 39.20575]]], [[[-123.04349, 39.37838], [-123.04341, 39.38187], [-123.03893, 39.38189], [-123.039, 39.37835], [-123.04349, 39.37838]]], [[[-123.05676, 39.39292], [-123.05667, 39.39647], [-123.05226, 39.39644], [-123.0523, 39.39292], [-123.05676, 39.39292]]], [[[-123.07487, 39.4075], [-123.07427, 39.42172], [-123.06524, 39.42164], [-123.06528, 39.4199], [-123.06533, 39.41819], [-123.0657, 39.41096], [-123.06585, 39.40744], [-123.07487, 39.4075]]]]} | Unknown Access 4 | 44747 | California State Lands Commission | 16726 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Lake 40 | 1718.203 | SLC | 0 | State Resource Management Area 55 | 3 | |
| 16879 | 16879 | 16878 | {"type": "MultiPolygon", "coordinates": [[[[-122.42777, 38.9418], [-122.42751, 38.94518], [-122.40757, 38.94348], [-122.4076, 38.94723], [-122.40301, 38.94742], [-122.40305, 38.94182], [-122.40304, 38.94015], [-122.40753, 38.93973], [-122.42777, 38.9418]]], [[[-122.4423, 38.94636], [-122.44197, 38.95323], [-122.42701, 38.95196], [-122.42727, 38.94858], [-122.43222, 38.94897], [-122.43244, 38.94558], [-122.4423, 38.94636]]], [[[-122.45661, 38.9506], [-122.4565, 38.95403], [-122.4563, 38.96114], [-122.45156, 38.96097], [-122.45173, 38.95385], [-122.44696, 38.95365], [-122.44709, 38.9502], [-122.4471, 38.95022], [-122.45661, 38.9506]]], [[[-122.46898, 38.96257], [-122.46893, 38.96617], [-122.46544, 38.96619], [-122.46547, 38.96508], [-122.46556, 38.96256], [-122.46898, 38.96257]]], [[[-122.48359, 38.92405], [-122.48337, 38.93836], [-122.46636, 38.93845], [-122.46661, 38.9312], [-122.46946, 38.93119], [-122.46962, 38.92395], [-122.47437, 38.92395], [-122.47439, 38.92399], [-122.48359, 38.92405]]], [[[-122.48298, 38.98375], [-122.48278, 38.98736], [-122.47802, 38.98735], [-122.47817, 38.98377], [-122.48298, 38.98375]]], [[[-122.51668, 38.97933], [-122.51278, 38.97931], [-122.51256, 38.97569], [-122.51652, 38.97566], [-122.51668, 38.97933]]], [[[-122.54356, 38.96017], [-122.54353, 38.96365], [-122.53894, 38.96324], [-122.53896, 38.95982], [-122.54356, 38.96017]]], [[[-122.54931, 38.69544], [-122.54931, 38.69905], [-122.54468, 38.69905], [-122.54466, 38.70122], [-122.54467, 38.70264], [-122.54931, 38.70264], [-122.5493, 38.70625], [-122.54464, 38.70626], [-122.54465, 38.70265], [-122.54, 38.70265], [-122.54, 38.69904], [-122.54466, 38.69904], [-122.54468, 38.69544], [-122.54931, 38.69544]]], [[[-122.5968, 38.69882], [-122.59556, 38.70606], [-122.59508, 38.70606], [-122.59507, 38.70244], [-122.59052, 38.70241], [-122.59051, 38.70602], [-122.58595, 38.70599], [-122.58596, 38.69877], [-122.57687, 38.69872], [-122.56327, 38.69896], [-122.56327, 38.69177], [-122.55862, 38.69185], [-122.5586, 38.68452], [-122.56325, 38.68448], [-122.56327, 38.6887], [-122.56792, 38.68865], [-122.56793, 38.69529], [-122.57687, 38.69514], [-122.5769, 38.69154], [-122.58599, 38.69155], [-122.58598, 38.68794], [-122.58143, 38.68794], [-122.58139, 38.68073], [-122.58138, 38.68072], [-122.57683, 38.68077], [-122.57688, 38.68795], [-122.57257, 38.68801], [-122.57252, 38.68079], [-122.57682, 38.68076], [-122.57681, 38.67946], [-122.58596, 38.67735], [-122.58597, 38.68068], [-122.58807, 38.68066], [-122.58807, 38.68161], [-122.59052, 38.68159], [-122.59053, 38.69156], [-122.58599, 38.69156], [-122.58597, 38.69877], [-122.5968, 38.69882]]], [[[-122.73991, 38.80732], [-122.73048, 38.8074], [-122.73012, 38.81479], [-122.72579, 38.81476], [-122.72594, 38.8111], [-122.72159, 38.81109], [-122.72173, 38.80747], [-122.72206, 38.80024], [-122.72208, 38.79666], [-122.73082, 38.79655], [-122.73084, 38.80001], [-122.7396, 38.79979], [-122.73991, 38.80732]]], [[[-122.73752, 38.89622], [-122.7375, 38.89987], [-122.73281, 38.89991], [-122.73285, 38.89619], [-122.73752, 38.89622]]], [[[-122.77612, 38.84469], [-122.77135, 38.84456], [-122.77135, 38.84345], [-122.77612, 38.84339], [-122.77612, 38.84469]]], [[[-122.80113, 38.83962], [-122.7977, 38.84501], [-122.7977, 38.84658], [-122.79282, 38.84647], [-122.79283, 38.84493], [-122.79468, 38.84495], [-122.7947, 38.84329], [-122.78542, 38.84335], [-122.78545, 38.83972], [-122.80113, 38.83962]]], [[[-122.79279, 38.87201], [-122.78828, 38.87174], [-122.78818, 38.86816], [-122.79264, 38.86848], [-122.79279, 38.87201]]], [[[-122.81872, 38.85147], [-122.81819, 38.85621], [-122.81815, 38.85622], [-122.81768, 38.86053], [-122.8177, 38.86054], [-122.8177, 38.86057], [-122.80268, 38.8612], [-122.80257, 38.86501], [-122.79753, 38.86512], [-122.79266, 38.8648], [-122.79268, 38.86111], [-122.78825, 38.86084], [-122.78831, 38.85342], [-122.78832, 38.84989], [-122.79766, 38.85028], [-122.79763, 38.85399], [-122.81872, 38.85147]]], [[[-122.84701, 38.89143], [-122.8423, 38.89151], [-122.84252, 38.89529], [-122.83791, 38.89539], [-122.83758, 38.89159], [-122.83263, 38.89198], [-122.83234, 38.8883], [-122.83725, 38.88779], [-122.83691, 38.884], [-122.83203, 38.88461], [-122.83172, 38.88093], [-122.82202, 38.88238], [-122.82226, 38.88583], [-122.82715, 38.88522], [-122.82742, 38.8888], [-122.81758, 38.8898], [-122.8078, 38.8897], [-122.80796, 38.8931], [-122.8178, 38.89315], [-122.82769, 38.89237], [-122.82796, 38.89594], [-122.82776, 38.9064], [-122.83392, 38.90629], [-122.83387, 38.90983], [-122.83405, 38.91322], [-122.83994, 38.91321], [-122.84469, 38.91331], [-122.84465, 38.91678], [-122.83983, 38.91663], [-122.83424, 38.91662], [-122.83404, 38.91323], [-122.81733, 38.91328], [-122.81779, 38.90995], [-122.81795, 38.89986], [-122.80805, 38.89999], [-122.80799, 38.90346], [-122.79807, 38.9037], [-122.79813, 38.90011], [-122.80308, 38.90004], [-122.80314, 38.8965], [-122.80289, 38.88965], [-122.79797, 38.88959], [-122.79781, 38.88268], [-122.79301, 38.88274], [-122.79293, 38.87552], [-122.79766, 38.87575], [-122.79775, 38.87921], [-122.81704, 38.87974], [-122.83172, 38.87723], [-122.83173, 38.88092], [-122.83658, 38.8802], [-122.83692, 38.88399], [-122.84184, 38.88396], [-122.84208, 38.88773], [-122.84689, 38.88768], [-122.84701, 38.89143]]], [[[-122.80252, 38.87237], [-122.79758, 38.87229], [-122.7975, 38.86883], [-122.80247, 38.86881], [-122.80252, 38.87237]]], [[[-122.83471, 38.92453], [-122.81742, 38.92489], [-122.81687, 38.91662], [-122.82864, 38.91663], [-122.82922, 38.92062], [-122.83448, 38.92058], [-122.83471, 38.92453]]]]} | Open Access 1 | 23559 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Lake 40 | 6195.603 | SLC | 0 | State Resource Management Area 55 | 3 |
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]);