units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 24, DES_TP = 55 and MNG_AGENCY = 73
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- California State Lands Commission · 1 ✖
DES_TP 1
- State Resource Management Area · 1 ✖
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16885 | 16885 | 16884 | {"type": "MultiPolygon", "coordinates": [[[[-122.83048, 38.85457], [-122.82989, 38.85862], [-122.81767, 38.86054], [-122.81815, 38.85621], [-122.83048, 38.85457]]], [[[-123.06162, 39.38585], [-123.06117, 39.38934], [-123.05691, 39.38929], [-123.05691, 39.38564], [-123.06162, 39.38585]]], [[[-123.06176, 39.37864], [-123.06158, 39.38217], [-123.05701, 39.38211], [-123.05698, 39.37847], [-123.06176, 39.37864]]], [[[-123.1287, 39.42049], [-123.12857, 39.4207], [-123.12862, 39.42089], [-123.12862, 39.42111], [-123.12856, 39.42157], [-123.12818, 39.42209], [-123.12818, 39.42226], [-123.12842, 39.42263], [-123.12838, 39.4228], [-123.12842, 39.42298], [-123.12843, 39.42327], [-123.12714, 39.42331], [-123.1244, 39.42336], [-123.12466, 39.43076], [-123.11952, 39.43094], [-123.11975, 39.43842], [-123.11413, 39.43874], [-123.09849, 39.43708], [-123.09859, 39.43342], [-123.10365, 39.43377], [-123.10374, 39.42648], [-123.09846, 39.42607], [-123.09848, 39.42961], [-123.09325, 39.42907], [-123.09324, 39.42559], [-123.09314, 39.42557], [-123.09313, 39.42544], [-123.0745, 39.42539], [-123.06521, 39.42527], [-123.06522, 39.42162], [-123.06525, 39.42164], [-123.07432, 39.42175], [-123.07493, 39.40756], [-123.07487, 39.40755], [-123.07486, 39.4075], [-123.06557, 39.40743], [-123.06563, 39.40386], [-123.06786, 39.40384], [-123.07474, 39.40398], [-123.07475, 39.40041], [-123.07955, 39.40066], [-123.07971, 39.39709], [-123.08929, 39.3977], [-123.08934, 39.3943], [-123.09414, 39.39461], [-123.09418, 39.398], [-123.09406, 39.40127], [-123.09875, 39.40141], [-123.09871, 39.40833], [-123.10366, 39.4085], [-123.10354, 39.41196], [-123.10827, 39.41224], [-123.10828, 39.41223], [-123.10809, 39.40864], [-123.11305, 39.4088], [-123.11357, 39.42001], [-123.1226, 39.41977], [-123.12718, 39.41985], [-123.12797, 39.41981], [-123.12804, 39.41994], [-123.12828, 39.42022], [-123.1287, 39.42049]], [[-123.11377, 39.42373], [-123.1088, 39.42328], [-123.10889, 39.42693], [-123.11382, 39.42741], [-123.11377, 39.42373]]], [[[-123.07588, 39.37511], [-123.07568, 39.37871], [-123.07096, 39.37882], [-123.07118, 39.37498], [-123.07588, 39.37511]]], [[[-123.07988, 39.38229], [-123.07979, 39.38617], [-123.07493, 39.38605], [-123.07532, 39.38241], [-123.07988, 39.38229]]], [[[-123.08448, 39.3645], [-123.07659, 39.36431], [-123.07515, 39.36426], [-123.07496, 39.35705], [-123.07976, 39.35722], [-123.07983, 39.36066], [-123.08438, 39.36084], [-123.08448, 39.3645]]], [[[-123.1256, 39.87478], [-123.12552, 39.8749], [-123.12536, 39.87503], [-123.12506, 39.87518], [-123.12471, 39.87549], [-123.12415, 39.87581], [-123.12363, 39.87617], [-123.12355, 39.87636], [-123.12349, 39.87664], [-123.1235, 39.87708], [-123.12361, 39.8774], [-123.12364, 39.87757], [-123.12353, 39.87769], [-123.12331, 39.87772], [-123.12321, 39.87789], [-123.12327, 39.87806], [-123.12319, 39.87825], [-123.12303, 39.87837], [-123.12287, 39.87859], [-123.12267, 39.87875], [-123.12242, 39.87899], [-123.12218, 39.8791], [-123.12201, 39.87921], [-123.12183, 39.87947], [-123.12185, 39.87968], [-123.12174, 39.88031], [-123.11959, 39.88038], [-123.11156, 39.8802], [-123.09399, 39.88096], [-123.09428, 39.88822], [-123.07667, 39.88724], [-123.07614, 39.87254], [-123.08354, 39.85782], [-123.08232, 39.85396], [-123.1021, 39.8549], [-123.10693, 39.85423], [-123.10852, 39.85775], [-123.11825, 39.85607], [-123.11757, 39.86049], [-123.12332, 39.85994], [-123.12315, 39.86242], [-123.12036, 39.86448], [-123.11576, 39.86792], [-123.11129, 39.87128], [-123.1248, 39.8713], [-123.12483, 39.87147], [-123.12482, 39.87187], [-123.12474, 39.87224], [-123.12467, 39.87241], [-123.12446, 39.87259], [-123.12435, 39.87266], [-123.12426, 39.87274], [-123.12421, 39.87283], [-123.12424, 39.87303], [-123.12449, 39.87335], [-123.12486, 39.87375], [-123.1253, 39.87403], [-123.12553, 39.87441], [-123.12558, 39.87458], [-123.1256, 39.87478]]], [[[-123.09853, 39.67054], [-123.09845, 39.68505], [-123.08017, 39.68481], [-123.07999, 39.6705], [-123.08591, 39.6704], [-123.09853, 39.67054]]], [[[-123.10381, 39.39452], [-123.10369, 39.3979], [-123.099, 39.39796], [-123.09907, 39.39457], [-123.10381, 39.39452]]], [[[-123.13041, 39.45242], [-123.13034, 39.46409], [-123.13039, 39.46819], [-123.12482, 39.46813], [-123.12476, 39.46451], [-123.11558, 39.4647], [-123.11549, 39.46107], [-123.1107, 39.46126], [-123.11072, 39.45415], [-123.12063, 39.45323], [-123.13041, 39.45242]]], [[[-123.1499, 39.39384], [-123.14043, 39.3938], [-123.14043, 39.39734], [-123.1355, 39.39739], [-123.13552, 39.40104], [-123.1311, 39.40111], [-123.13111, 39.39731], [-123.13549, 39.39739], [-123.13548, 39.3938], [-123.13111, 39.39373], [-123.12822, 39.39384], [-123.12824, 39.39346], [-123.12817, 39.39189], [-123.1282, 39.3911], [-123.12823, 39.38706], [-123.12249, 39.38691], [-123.12254, 39.37996], [-123.12644, 39.38006], [-123.12643, 39.37631], [-123.12873, 39.3765], [-123.13123, 39.37662], [-123.13118, 39.38017], [-123.13117, 39.38363], [-123.14036, 39.38359], [-123.14033, 39.38701], [-123.14042, 39.39053], [-123.14982, 39.39039], [-123.1499, 39.39384]]], [[[-123.13536, 39.43063], [-123.1353, 39.43778], [-123.13067, 39.43778], [-123.13078, 39.43045], [-123.13536, 39.43063]]], [[[-123.14911, 39.4796], [-123.14453, 39.47955], [-123.13955, 39.47936], [-123.13964, 39.4826], [-123.13504, 39.48267], [-123.13509, 39.472], [-123.13936, 39.47207], [-123.13939, 39.46855], [-123.14438, 39.46877], [-123.14448, 39.47236], [-123.14897, 39.47254], [-123.14901, 39.47604], [-123.14911, 39.4796]]], [[[-123.17373, 39.40115], [-123.17347, 39.40836], [-123.17327, 39.41198], [-123.16857, 39.412], [-123.16856, 39.4155], [-123.16401, 39.4156], [-123.16392, 39.4192], [-123.14976, 39.41941], [-123.14509, 39.4194], [-123.14502, 39.41571], [-123.14505, 39.41211], [-123.14037, 39.41211], [-123.14044, 39.40846], [-123.1404, 39.40113], [-123.1452, 39.40099], [-123.14514, 39.39745], [-123.14986, 39.39736], [-123.14979, 39.4048], [-123.15442, 39.40479], [-123.15441, 39.40842], [-123.15444, 39.41216], [-123.15922, 39.412], [-123.16396, 39.41197], [-123.16409, 39.40839], [-123.16419, 39.4047], [-123.16881, 39.40468], [-123.16887, 39.4011], [-123.17373, 39.40115]]], [[[-123.20147, 39.46191], [-123.19679, 39.46187], [-123.19654, 39.45833], [-123.2012, 39.45849], [-123.20147, 39.46191]]], [[[-123.21669, 39.37177], [-123.21658, 39.3755], [-123.21188, 39.37549], [-123.21192, 39.37175], [-123.21669, 39.37177]]], [[[-123.2542, 39.52018], [-123.25251, 39.51988], [-123.24651, 39.51914], [-123.24651, 39.52308], [-123.24647, 39.52628], [-123.24652, 39.52686], [-123.23964, 39.52624], [-123.23954, 39.52265], [-123.22491, 39.52254], [-123.22489, 39.51863], [-123.22969, 39.51872], [-123.22968, 39.51538], [-123.22488, 39.51526], [-123.22486, 39.51161], [-123.22465, 39.50059], [-123.22944, 39.50036], [-123.22942, 39.49674], [-123.23448, 39.49632], [-123.23417, 39.49283], [-123.23914, 39.49241], [-123.23936, 39.49596], [-123.24428, 39.49558], [-123.24449, 39.49989], [-123.24569, 39.50761], [-123.2507, 39.50823], [-123.25112, 39.51244], [-123.25404, 39.51297], [-123.2542, 39.52018]]], [[[-123.23498, 39.38227], [-123.23086, 39.38246], [-123.23082, 39.37989], [-123.23083, 39.37897], [-123.23495, 39.37883], [-123.23498, 39.38227]]], [[[-123.25918, 39.54181], [-123.25914, 39.55732], [-123.25112, 39.55663], [-123.2413, 39.556], [-123.24134, 39.55477], [-123.24158, 39.54055], [-123.25112, 39.5412], [-123.25918, 39.54181]]], [[[-123.26215, 39.47278], [-123.25735, 39.47239], [-123.25712, 39.46882], [-123.26191, 39.46914], [-123.26215, 39.47278]]], [[[-123.26338, 39.65655], [-123.26329, 39.66374], [-123.2583, 39.66374], [-123.25849, 39.65656], [-123.26338, 39.65655]]], [[[-123.26518, 39.39442], [-123.25976, 39.39449], [-123.2598, 39.39066], [-123.26093, 39.39061], [-123.26513, 39.39051], [-123.26518, 39.39442]]], [[[-123.29593, 39.65654], [-123.29559, 39.66827], [-123.29105, 39.66842], [-123.29114, 39.67202], [-123.29104, 39.67917], [-123.28642, 39.67914], [-123.2865, 39.67204], [-123.28648, 39.67109], [-123.28162, 39.67108], [-123.28149, 39.67514], [-123.27675, 39.67502], [-123.27671, 39.67884], [-123.26789, 39.67875], [-123.26314, 39.67874], [-123.2631, 39.67103], [-123.26785, 39.67107], [-123.26783, 39.6749], [-123.27674, 39.67501], [-123.27675, 39.67106], [-123.27719, 39.67105], [-123.27716, 39.66737], [-123.27263, 39.66737], [-123.27255, 39.66378], [-123.26788, 39.66376], [-123.26786, 39.66008], [-123.27249, 39.66008], [-123.27251, 39.65654], [-123.27765, 39.65654], [-123.28644, 39.65658], [-123.29593, 39.65654]]], [[[-123.30894, 39.50761], [-123.29976, 39.50753], [-123.29974, 39.50385], [-123.30867, 39.50401], [-123.30894, 39.50761]]], [[[-123.32233, 39.75876], [-123.32212, 39.77258], [-123.30422, 39.77307], [-123.30421, 39.76609], [-123.30417, 39.75918], [-123.32233, 39.75876]]], [[[-123.31353, 39.75885], [-123.3043, 39.75885], [-123.30434, 39.75518], [-123.30845, 39.75506], [-123.30854, 39.75136], [-123.31343, 39.75138], [-123.31353, 39.75885]]], [[[-123.31892, 39.50735], [-123.31414, 39.5074], [-123.31408, 39.50005], [-123.30446, 39.50011], [-123.30446, 39.49276], [-123.31883, 39.4927], [-123.31892, 39.50735]]], [[[-123.33645, 39.77682], [-123.33631, 39.78769], [-123.33631, 39.79181], [-123.33177, 39.79175], [-123.3318, 39.78768], [-123.32247, 39.78767], [-123.32246, 39.78768], [-123.32246, 39.79137], [-123.31967, 39.79144], [-123.31252, 39.79173], [-123.30888, 39.79183], [-123.30895, 39.78803], [-123.30879, 39.77322], [-123.32249, 39.77321], [-123.3225, 39.76961], [-123.3272, 39.76957], [-123.32718, 39.76607], [-123.32723, 39.76245], [-123.3318, 39.76248], [-123.33185, 39.76611], [-123.33194, 39.76962], [-123.33187, 39.77321], [-123.33183, 39.77689], [-123.33645, 39.77682]]], [[[-123.31328, 39.80278], [-123.30906, 39.80276], [-123.30882, 39.79908], [-123.31328, 39.79908], [-123.31328, 39.80278]]], [[[-123.3137, 39.74054], [-123.31361, 39.74405], [-123.31356, 39.74762], [-123.30897, 39.74761], [-123.30904, 39.74405], [-123.30913, 39.74046], [-123.3137, 39.74054]]], [[[-123.32269, 39.74058], [-123.32262, 39.74409], [-123.31799, 39.74408], [-123.31808, 39.74054], [-123.32269, 39.74058]]], [[[-123.32727, 39.8029], [-123.32248, 39.80284], [-123.32249, 39.79901], [-123.32247, 39.7953], [-123.32718, 39.79545], [-123.32727, 39.8029]]], [[[-123.45019, 38.79119], [-123.45019, 38.79488], [-123.44577, 38.79473], [-123.44568, 38.79114], [-123.45019, 38.79119]]], [[[-123.49864, 39.80707], [-123.49851, 39.81031], [-123.49635, 39.81035], [-123.49395, 39.81027], [-123.49381, 39.80703], [-123.494, 39.80705], [-123.49864, 39.80707]]], [[[-123.55832, 38.95493], [-123.55786, 38.95852], [-123.55329, 38.95848], [-123.5537, 38.95495], [-123.55832, 38.95493]]], [[[-123.88646, 39.98449], [-123.88157, 39.98441], [-123.88153, 39.98828], [-123.877, 39.98822], [-123.87687, 39.98442], [-123.88157, 39.9844], [-123.88145, 39.97643], [-123.8863, 39.97637], [-123.88646, 39.98449]]]]} | Open Access 1 | 23544 | 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 | Mendocino 24 | 15642.705 | 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]);