units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where COUNTY = 40 and LAYER = 5
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, MNG_AG_ID, LABEL_NAME, GAP_STS
MNG_AGENCY 3
ACCESS_TYP 3
DES_TP 2
MNG_AG_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8247 | 8247 | 8246 | {"type": "MultiPolygon", "coordinates": [[[[-122.72165, 38.84391], [-122.72154, 38.84904], [-122.71487, 38.84901], [-122.70574, 38.84902], [-122.70549, 38.84378], [-122.70284, 38.84376], [-122.68431, 38.84373], [-122.68434, 38.84279], [-122.68496, 38.83865], [-122.685, 38.83772], [-122.68494, 38.83637], [-122.68039, 38.83604], [-122.68047, 38.83773], [-122.67152, 38.83772], [-122.67106, 38.83233], [-122.66655, 38.83217], [-122.66627, 38.82927], [-122.66623, 38.82554], [-122.66608, 38.81436], [-122.66616, 38.81074], [-122.67542, 38.81083], [-122.67552, 38.80719], [-122.68013, 38.80724], [-122.68023, 38.80362], [-122.68487, 38.80364], [-122.68479, 38.80728], [-122.69405, 38.80727], [-122.69369, 38.81492], [-122.69369, 38.8164], [-122.69361, 38.82063], [-122.69362, 38.82181], [-122.7029, 38.82182], [-122.70286, 38.8256], [-122.71223, 38.82569], [-122.71219, 38.82937], [-122.72053, 38.82944], [-122.72049, 38.83061], [-122.72084, 38.83179], [-122.72088, 38.83228], [-122.72097, 38.83257], [-122.72105, 38.8327], [-122.72116, 38.83279], [-122.72139, 38.83289], [-122.72139, 38.83408], [-122.72119, 38.83409], [-122.72119, 38.83662], [-122.72115, 38.83808], [-122.72115, 38.8387], [-122.72123, 38.84389], [-122.72165, 38.84391]]], [[[-122.72597, 38.83144], [-122.7259, 38.83145], [-122.72589, 38.83272], [-122.72595, 38.83273], [-122.72596, 38.83312], [-122.7226, 38.83309], [-122.72194, 38.83286], [-122.7213, 38.83267], [-122.72082, 38.83095], [-122.72131, 38.83138], [-122.72303, 38.8314], [-122.72304, 38.82939], [-122.72596, 38.82941], [-122.72586, 38.82956], [-122.72578, 38.82956], [-122.72579, 38.82991], [-122.72596, 38.8299], [-122.72598, 38.83025], [-122.72597, 38.83144]]]]} | Open Access 1 | 11240 | Boggs Mountain Demonstration State Forest | 1364 | 202 | California Department of Forestry and Fire Protection 346 | State 5 | State Agency 5 | http://www.fire.ca.gov/ | Other State 5 | 202 | California Department of Forestry and Fire Protection 343 | State 5 | State Agency 5 | http://www.fire.ca.gov/resource_mgt/resource_mgt_stateforests_boggsmtn.php | Lake 40 | 3425.69 | Boggs Mtn. DSF | 0 | State Resource Management Area 55 | 3 |
8348 | 8348 | 8347 | {"type": "MultiPolygon", "coordinates": [[[[-122.41094, 38.85388], [-122.4109, 38.86064], [-122.41064, 38.86043], [-122.41045, 38.86031], [-122.40971, 38.85998], [-122.40952, 38.85988], [-122.40712, 38.85804], [-122.40687, 38.85789], [-122.40358, 38.85648], [-122.40329, 38.85638], [-122.40383, 38.85581], [-122.40383, 38.8558], [-122.40339, 38.85564], [-122.40303, 38.85564], [-122.40277, 38.85567], [-122.40247, 38.85568], [-122.402, 38.85586], [-122.40174, 38.85591], [-122.4014, 38.85577], [-122.40121, 38.85547], [-122.40099, 38.85506], [-122.40086, 38.85472], [-122.40053, 38.85448], [-122.40009, 38.85431], [-122.39986, 38.85425], [-122.39967, 38.85404], [-122.39955, 38.85379], [-122.41094, 38.85388]]], [[[-122.41361, 38.86493], [-122.4059, 38.8649], [-122.40599, 38.86091], [-122.40127, 38.86083], [-122.40125, 38.86271], [-122.39731, 38.86263], [-122.4032, 38.85648], [-122.40351, 38.85657], [-122.40679, 38.85797], [-122.40702, 38.85812], [-122.40943, 38.85996], [-122.40964, 38.86008], [-122.41038, 38.86041], [-122.41067, 38.8606], [-122.4109, 38.86083], [-122.4109, 38.86098], [-122.411, 38.86098], [-122.41104, 38.86105], [-122.41215, 38.86347], [-122.41234, 38.86382], [-122.4126, 38.86414], [-122.4128, 38.86433], [-122.41303, 38.86451], [-122.41361, 38.86493]]], [[[-122.42422, 38.87573], [-122.42408, 38.87585], [-122.41522, 38.87548], [-122.41522, 38.87045], [-122.4174, 38.87051], [-122.41776, 38.87075], [-122.41802, 38.87089], [-122.42, 38.87169], [-122.42023, 38.87181], [-122.42044, 38.87195], [-122.42062, 38.87211], [-122.42078, 38.87229], [-122.42091, 38.87248], [-122.421, 38.87268], [-122.4216, 38.87421], [-122.42178, 38.87453], [-122.42203, 38.87482], [-122.42235, 38.87507], [-122.42259, 38.87521], [-122.42284, 38.87532], [-122.42311, 38.87541], [-122.42422, 38.87573]]], [[[-122.44673, 38.8798], [-122.44346, 38.87981], [-122.44345, 38.87995], [-122.44277, 38.87981], [-122.43966, 38.8804], [-122.43894, 38.88033], [-122.43696, 38.87922], [-122.43486, 38.87902], [-122.43409, 38.87868], [-122.43283, 38.8773], [-122.43267, 38.87716], [-122.43248, 38.87704], [-122.43216, 38.8769], [-122.43193, 38.87684], [-122.4317, 38.8768], [-122.43146, 38.87678], [-122.43125, 38.87679], [-122.43105, 38.87682], [-122.42927, 38.87726], [-122.42901, 38.87732], [-122.4288, 38.87734], [-122.42857, 38.87735], [-122.42823, 38.87731], [-122.42801, 38.87725], [-122.42771, 38.87711], [-122.4265, 38.87633], [-122.42616, 38.87617], [-122.42316, 38.87531], [-122.42289, 38.87522], [-122.42264, 38.8751], [-122.42241, 38.87497], [-122.42222, 38.87482], [-122.42204, 38.87465], [-122.42183, 38.87437], [-122.42173, 38.87417], [-122.42109, 38.87254], [-122.42092, 38.87226], [-122.42069, 38.872], [-122.4204, 38.87177], [-122.42007, 38.87159], [-122.41823, 38.87085], [-122.41796, 38.87073], [-122.41771, 38.87058], [-122.41748, 38.87042], [-122.41727, 38.87024], [-122.4171, 38.87004], [-122.41688, 38.86972], [-122.41623, 38.86846], [-122.41606, 38.86816], [-122.41431, 38.86544], [-122.4141, 38.86519], [-122.41381, 38.86493], [-122.41291, 38.86426], [-122.41262, 38.86397], [-122.41247, 38.86376], [-122.41228, 38.86343], [-122.41116, 38.86099], [-122.41549, 38.86112], [-122.41551, 38.85757], [-122.42008, 38.85771], [-122.42945, 38.85792], [-122.42944, 38.87069], [-122.43174, 38.87069], [-122.4321, 38.87105], [-122.43243, 38.87134], [-122.43274, 38.87195], [-122.43308, 38.87236], [-122.4334, 38.87257], [-122.43375, 38.87276], [-122.43413, 38.87264], [-122.43498, 38.87277], [-122.4339, 38.87337], [-122.4331, 38.87389], [-122.4331, 38.87391], [-122.43337, 38.87416], [-122.43348, 38.87422], [-122.4335, 38.8744], [-122.43748, 38.87427], [-122.43935, 38.87519], [-122.44673, 38.8798]]]]} | Restricted Access 2 | 48476 | McLaughlin Natural Reserve | 33195 | 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 | https://ucnrs.org/reserves/mclaughlin-natural-reserve/ | Lake 40 | 1035.449 | McLaughlin Natural Reserve | 0 | State Conservation Area 8 | 2 |
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]);