units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, COUNTY = 10 and DES_TP = 55
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
ACCESS_TYP 1
- Open Access · 3 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3294 | 3294 | 3293 | {"type": "MultiPolygon", "coordinates": [[[[-115.69505, 33.44121], [-115.69162, 33.43976], [-115.69116, 33.43952], [-115.69074, 33.43926], [-115.69073, 33.43927], [-115.69168, 33.44158], [-115.69109, 33.44158], [-115.69011, 33.43919], [-115.68292, 33.43597], [-115.68322, 33.43551], [-115.68927, 33.43822], [-115.68929, 33.43822], [-115.68891, 33.4378], [-115.68707, 33.43545], [-115.68663, 33.43493], [-115.68569, 33.43494], [-115.6853, 33.4346], [-115.68487, 33.43426], [-115.68257, 33.43265], [-115.68207, 33.43222], [-115.68165, 33.43176], [-115.68133, 33.43132], [-115.68095, 33.43067], [-115.68071, 33.43037], [-115.6804, 33.43007], [-115.67976, 33.42958], [-115.67945, 33.4294], [-115.67915, 33.42928], [-115.67891, 33.4292], [-115.67834, 33.42905], [-115.67769, 33.42881], [-115.67768, 33.42775], [-115.67868, 33.42774], [-115.67895, 33.42784], [-115.67952, 33.42798], [-115.6799, 33.42811], [-115.6804, 33.42834], [-115.68079, 33.42858], [-115.68153, 33.42916], [-115.68194, 33.42955], [-115.6823, 33.43001], [-115.68267, 33.43063], [-115.68286, 33.4309], [-115.68308, 33.43117], [-115.68339, 33.43147], [-115.68362, 33.43167], [-115.68558, 33.43303], [-115.68608, 33.4334], [-115.68672, 33.43392], [-115.68731, 33.43448], [-115.68771, 33.43492], [-115.68756, 33.43492], [-115.68755, 33.43494], [-115.68811, 33.4356], [-115.68978, 33.43779], [-115.69, 33.43803], [-115.69019, 33.43821], [-115.69042, 33.4384], [-115.69064, 33.43855], [-115.69154, 33.43911], [-115.69189, 33.4393], [-115.69223, 33.43946], [-115.69505, 33.44065], [-115.69505, 33.44121]]], [[[-115.22469, 33.44337], [-115.2074, 33.44372], [-115.20753, 33.42899], [-115.22066, 33.42868], [-115.22447, 33.42867], [-115.22469, 33.44337]]], [[[-115.1597, 33.42903], [-115.15952, 33.44398], [-115.14234, 33.44403], [-115.14194, 33.42881], [-115.15287, 33.42884], [-115.1597, 33.42903]]], [[[-115.05586, 33.44349], [-115.03856, 33.44347], [-115.03856, 33.42897], [-115.05586, 33.429], [-115.05586, 33.44349]]], [[[-116.06114, 33.48444], [-116.04385, 33.48449], [-116.04382, 33.46995], [-116.0438, 33.46994], [-116.0611, 33.46984], [-116.06114, 33.48444]]], [[[-114.95204, 33.44442], [-114.93469, 33.4444], [-114.93466, 33.4299], [-114.95198, 33.42983], [-114.95204, 33.44442]]], [[[-114.84817, 33.43017], [-114.84813, 33.44457], [-114.83108, 33.4446], [-114.83094, 33.43378], [-114.83122, 33.43377], [-114.8312, 33.4302], [-114.83816, 33.4302], [-114.84817, 33.43017]]], [[[-115.21187, 33.4729], [-115.21187, 33.48746], [-115.19456, 33.48748], [-115.19456, 33.47286], [-115.21187, 33.4729]]], [[[-115.1075, 33.47269], [-115.10746, 33.48736], [-115.09031, 33.48728], [-115.09034, 33.47267], [-115.1075, 33.47269]]], [[[-116.0, 33.51051], [-116.0, 33.52539], [-115.9917, 33.52531], [-115.9918, 33.5105], [-116.0, 33.51051]]], [[[-115.69548, 33.51488], [-115.69548, 33.51488], [-115.68877, 33.51491], [-115.69521, 33.51262], [-115.69545, 33.51252], [-115.69548, 33.51488]]], [[[-115.69561, 33.52576], [-115.67822, 33.52582], [-115.6782, 33.52218], [-115.69093, 33.52214], [-115.69097, 33.51851], [-115.69552, 33.51849], [-115.69561, 33.52576]]], [[[-115.38029, 33.50952], [-115.38003, 33.52395], [-115.3631, 33.52407], [-115.36299, 33.50957], [-115.38029, 33.50952]]], [[[-115.27652, 33.51571], [-115.27648, 33.53022], [-115.25907, 33.5302], [-115.25925, 33.51568], [-115.27652, 33.51571]]], [[[-115.16898, 33.51136], [-115.16889, 33.52587], [-115.15149, 33.5259], [-115.1514, 33.5113], [-115.16898, 33.51136]]], [[[-114.95996, 33.51125], [-114.95996, 33.51824], [-114.94272, 33.51821], [-114.94273, 33.5112], [-114.95996, 33.51125]]], [[[-114.84816, 33.5114], [-114.84707, 33.52587], [-114.8383, 33.52586], [-114.83824, 33.5114], [-114.84816, 33.5114]]], [[[-115.64346, 33.55444], [-115.64334, 33.56902], [-115.63394, 33.56887], [-115.63393, 33.56873], [-115.62536, 33.56868], [-115.62561, 33.56154], [-115.63006, 33.56158], [-115.63026, 33.55437], [-115.64346, 33.55444]]], [[[-115.53764, 33.56154], [-115.53317, 33.56146], [-115.53328, 33.56874], [-115.51981, 33.56849], [-115.51974, 33.5612], [-115.52869, 33.56137], [-115.52864, 33.55773], [-115.52418, 33.55765], [-115.52414, 33.55401], [-115.53752, 33.55426], [-115.53764, 33.56154]]], [[[-115.43243, 33.55303], [-115.43221, 33.56779], [-115.41471, 33.56763], [-115.41494, 33.55295], [-115.43243, 33.55303]]], [[[-115.2206, 33.56939], [-115.20342, 33.56941], [-115.20348, 33.55491], [-115.22058, 33.5549], [-115.2206, 33.56939]]], [[[-115.48539, 33.5972], [-115.48533, 33.61177], [-115.46801, 33.61162], [-115.46803, 33.59702], [-115.48539, 33.5972]]], [[[-115.3805, 33.61079], [-115.36311, 33.61098], [-115.3631, 33.59646], [-115.38018, 33.5964], [-115.3805, 33.61079]]], [[[-114.85553, 33.60851], [-114.85553, 33.60948], [-114.84685, 33.60975], [-114.84684, 33.60991], [-114.84535, 33.60996], [-114.84525, 33.6102], [-114.84452, 33.61043], [-114.83812, 33.61215], [-114.83812, 33.61186], [-114.8444, 33.61017], [-114.84498, 33.60996], [-114.84134, 33.61007], [-114.83812, 33.61008], [-114.83811, 33.60952], [-114.84133, 33.60951], [-114.84682, 33.60934], [-114.84683, 33.60879], [-114.85553, 33.60851]]], [[[-115.64262, 33.64187], [-115.6426, 33.65641], [-115.62525, 33.65634], [-115.62522, 33.64181], [-115.64262, 33.64187]]], [[[-115.43261, 33.6544], [-115.41515, 33.65431], [-115.41514, 33.63991], [-115.43249, 33.63988], [-115.43261, 33.6544]]], [[[-115.69103, 33.68909], [-115.68659, 33.68907], [-115.68654, 33.69262], [-115.67806, 33.69257], [-115.67818, 33.68563], [-115.69096, 33.68559], [-115.69103, 33.68909]]], [[[-115.69542, 33.69628], [-115.69542, 33.70012], [-115.68646, 33.70007], [-115.6864, 33.69629], [-115.69542, 33.69628]]], [[[-114.65051, 33.66583], [-114.64607, 33.66577], [-114.64602, 33.66403], [-114.65032, 33.6641], [-114.65051, 33.66583]]], [[[-115.37876, 33.68532], [-115.37872, 33.70001], [-115.36978, 33.7], [-115.36965, 33.69227], [-115.36139, 33.69227], [-115.36136, 33.68552], [-115.37876, 33.68532]]], [[[-114.96047, 33.70018], [-114.9427, 33.70011], [-114.94271, 33.68564], [-114.95999, 33.68563], [-114.96047, 33.70018]]], [[[-114.85333, 33.70028], [-114.8359, 33.70026], [-114.83593, 33.69005], [-114.83802, 33.69007], [-114.83807, 33.68571], [-114.85331, 33.68571], [-114.85333, 33.70028]]], [[[-115.32213, 33.74006], [-115.32209, 33.74384], [-115.31765, 33.74386], [-115.31768, 33.74004], [-115.32213, 33.74006]]], [[[-115.11644, 33.72951], [-115.11637, 33.74423], [-115.09884, 33.74419], [-115.09887, 33.72947], [-115.11644, 33.72951]]], [[[-115.01174, 33.72929], [-115.01171, 33.74393], [-114.99531, 33.74366], [-114.9952, 33.72901], [-115.0008, 33.72927], [-115.01174, 33.72929]]], [[[-116.10942, 33.77302], [-116.10941, 33.78754], [-116.09194, 33.78748], [-116.09195, 33.77296], [-116.10942, 33.77302]]], [[[-114.90565, 33.72931], [-114.90526, 33.74381], [-114.88833, 33.7437], [-114.8879, 33.72921], [-114.90565, 33.72931]]], [[[-114.79905, 33.74809], [-114.78161, 33.74811], [-114.78107, 33.74049], [-114.781, 33.73346], [-114.79883, 33.73344], [-114.79905, 33.74809]]], [[[-115.58196, 33.77235], [-115.5819, 33.78686], [-115.56456, 33.78683], [-115.5646, 33.77233], [-115.58196, 33.77235]]], [[[-115.15837, 33.77322], [-115.15837, 33.78065], [-115.14962, 33.78067], [-115.14957, 33.78796], [-115.14069, 33.78795], [-115.14076, 33.77324], [-115.15837, 33.77322]]], [[[-115.05166, 33.77381], [-115.05159, 33.78865], [-115.0343, 33.78873], [-115.03436, 33.77383], [-115.05166, 33.77381]]], [[[-114.94706, 33.78108], [-114.93896, 33.78098], [-114.93883, 33.7883], [-114.93026, 33.7883], [-114.92975, 33.77478], [-114.94694, 33.77378], [-114.94706, 33.78108]]], [[[-115.63412, 33.83052], [-115.61675, 33.83041], [-115.61675, 33.816], [-115.63411, 33.8161], [-115.63412, 33.83052]]], [[[-115.52984, 33.81553], [-115.52975, 33.83006], [-115.51244, 33.83], [-115.51247, 33.81543], [-115.52984, 33.81553]]], [[[-114.6315, 33.79291], [-114.6141, 33.79293], [-114.61409, 33.77834], [-114.6269, 33.77845], [-114.62691, 33.77844], [-114.62691, 33.77705], [-114.63149, 33.77697], [-114.6315, 33.79291]]], [[[-115.10466, 33.81693], [-115.10459, 33.83149], [-115.08728, 33.8315], [-115.0872, 33.81707], [-115.10466, 33.81693]]], [[[-116.61953, 33.89947], [-116.61518, 33.89944], [-116.61517, 33.89547], [-116.6157, 33.89547], [-116.61935, 33.89824], [-116.61936, 33.89823], [-116.61934, 33.89777], [-116.61952, 33.89789], [-116.61953, 33.89947]]], [[[-114.78916, 33.81967], [-114.78913, 33.83433], [-114.77193, 33.83448], [-114.77186, 33.81984], [-114.78916, 33.81967]]], [[[-115.58194, 33.86923], [-115.58, 33.86504], [-115.5795, 33.86316], [-115.57241, 33.86262], [-115.56463, 33.86293], [-115.56463, 33.85939], [-115.58191, 33.85933], [-115.58194, 33.86923]]], [[[-115.58195, 33.8738], [-115.57245, 33.87382], [-115.57262, 33.87322], [-115.57007, 33.87077], [-115.56628, 33.87061], [-115.56629, 33.86989], [-115.56799, 33.87004], [-115.568, 33.87003], [-115.5662, 33.86738], [-115.57672, 33.86772], [-115.57734, 33.86922], [-115.57782, 33.87082], [-115.58194, 33.8711], [-115.58195, 33.8738]]], [[[-114.68367, 33.83645], [-114.66628, 33.83642], [-114.6663, 33.82193], [-114.68363, 33.82193], [-114.68367, 33.83645]]], [[[-115.3717, 33.86672], [-115.37168, 33.8674], [-115.37113, 33.86781], [-115.36675, 33.87036], [-115.36444, 33.87037], [-115.3701, 33.86707], [-115.37058, 33.86672], [-115.3717, 33.86672]]], [[[-114.5793, 33.82234], [-114.5793, 33.83733], [-114.56217, 33.83737], [-114.56202, 33.82239], [-114.5793, 33.82234]]], [[[-115.05235, 33.85851], [-115.0523, 33.87281], [-115.05177, 33.87282], [-115.0498, 33.87294], [-115.03241, 33.87291], [-115.03234, 33.86052], [-115.03235, 33.85842], [-115.05175, 33.85845], [-115.05175, 33.85851], [-115.05235, 33.85851]]], [[[-115.93966, 33.91045], [-115.93553, 33.91037], [-115.93551, 33.90342], [-115.93963, 33.90343], [-115.93966, 33.91045]]], [[[-115.95272, 33.91344], [-115.95268, 33.91816], [-115.95189, 33.91816], [-115.944, 33.91807], [-115.94402, 33.91321], [-115.95272, 33.91344]]], [[[-114.84118, 33.86133], [-114.84106, 33.87579], [-114.82379, 33.87576], [-114.82383, 33.86747], [-114.82986, 33.86708], [-114.82973, 33.86566], [-114.8316, 33.86571], [-114.8316, 33.86318], [-114.83849, 33.8631], [-114.83832, 33.86214], [-114.83534, 33.86199], [-114.83539, 33.86132], [-114.84118, 33.86133]]], [[[-114.73595, 33.86934], [-114.73431, 33.86936], [-114.73453, 33.87136], [-114.73589, 33.87126], [-114.73588, 33.87835], [-114.71851, 33.87832], [-114.7192, 33.86375], [-114.7359, 33.86378], [-114.73595, 33.86934]]], [[[-114.6314, 33.8664], [-114.63137, 33.88095], [-114.61424, 33.88092], [-114.61434, 33.86653], [-114.6314, 33.8664]]], [[[-115.10428, 33.90237], [-115.10424, 33.9168], [-115.08696, 33.91675], [-115.08685, 33.90228], [-115.10428, 33.90237]]], [[[-114.99834, 33.91889], [-114.98102, 33.91873], [-114.98083, 33.90403], [-114.99823, 33.90421], [-114.99834, 33.91889]]], [[[-114.89329, 33.91902], [-114.8759, 33.91901], [-114.87579, 33.90447], [-114.89328, 33.90447], [-114.89329, 33.91902]]], [[[-114.68366, 33.90508], [-114.68361, 33.91947], [-114.66628, 33.91954], [-114.66623, 33.90509], [-114.68366, 33.90508]]], [[[-114.57521, 33.9104], [-114.5752, 33.92462], [-114.57081, 33.92461], [-114.57073, 33.9104], [-114.57521, 33.9104]]], [[[-116.37095, 34.00396], [-116.35358, 34.00332], [-116.35355, 34.00001], [-116.35383, 33.98971], [-116.37058, 33.98982], [-116.37107, 33.99968], [-116.37095, 34.00396]]], [[[-115.0503, 33.94796], [-115.05025, 33.96236], [-115.03278, 33.96256], [-115.0327, 33.94804], [-115.0503, 33.94796]]], [[[-115.94802, 34.00606], [-115.93047, 34.00615], [-115.93048, 33.9918], [-115.94801, 33.99186], [-115.94802, 34.00606]]], [[[-114.84098, 33.9484], [-114.84098, 33.96315], [-114.82353, 33.9626], [-114.82354, 33.94852], [-114.84098, 33.9484]]], [[[-115.73557, 33.99163], [-115.73557, 34.0], [-115.72366, 34.00001], [-115.72257, 33.99789], [-115.72073, 33.99834], [-115.72176, 34.00001], [-115.71803, 34.00001], [-115.71798, 33.99151], [-115.73557, 33.99163]]], [[[-115.84262, 33.99163], [-115.8426, 34.00612], [-115.82527, 34.00608], [-115.82479, 34.00001], [-115.82482, 33.99138], [-115.84262, 33.99163]]], [[[-114.62726, 33.96295], [-114.61842, 33.96296], [-114.61854, 33.94836], [-114.62724, 33.94846], [-114.62726, 33.96295]]], [[[-115.10408, 34.00673], [-115.08652, 34.00675], [-115.08622, 34.00002], [-115.08613, 33.99163], [-115.10385, 33.99168], [-115.10377, 34.00001], [-115.10408, 34.00673]]], [[[-114.57925, 33.99778], [-114.57924, 34.01241], [-114.56159, 34.01233], [-114.56182, 34.00102], [-114.56184, 33.99771], [-114.57925, 33.99778]]], [[[-115.26311, 34.04252], [-115.25701, 34.04546], [-115.25571, 34.04527], [-115.25299, 34.04729], [-115.25299, 34.04731], [-115.25474, 34.04879], [-115.25381, 34.04878], [-115.25216, 34.04739], [-115.25153, 34.04878], [-115.25143, 34.04878], [-115.25795, 34.03421], [-115.25805, 34.03421], [-115.25232, 34.04704], [-115.25233, 34.04704], [-115.25551, 34.04468], [-115.25689, 34.04488], [-115.26311, 34.04189], [-115.26311, 34.04252]]], [[[-115.1565, 34.05014], [-115.14801, 34.05018], [-115.14806, 34.03538], [-115.15647, 34.03538], [-115.1565, 34.05014]]], [[[-115.05146, 34.03568], [-115.05135, 34.0502], [-115.03286, 34.05014], [-115.03279, 34.03589], [-115.05146, 34.03568]]], [[[-114.94559, 34.03605], [-114.94551, 34.05045], [-114.9277, 34.0505], [-114.92773, 34.04312], [-114.93637, 34.04296], [-114.93655, 34.0361], [-114.94559, 34.03605]]], [[[-114.62948, 34.03618], [-114.62944, 34.05071], [-114.61221, 34.05069], [-114.61219, 34.03619], [-114.62074, 34.03614], [-114.62209, 34.03618], [-114.62948, 34.03618]]], [[[-114.52534, 34.05068], [-114.51014, 34.05074], [-114.50836, 34.04995], [-114.50779, 34.05066], [-114.50796, 34.03611], [-114.52503, 34.03611], [-114.52534, 34.05068]]]]} | Open Access 1 | 29560 | 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 | Riverside 10 | 39027.62 | SLC | 0 | State Resource Management Area 55 | 3 | |
15765 | 15765 | 15764 | {"type": "MultiPolygon", "coordinates": [[[[-115.41577, 33.9071], [-115.41501, 33.90797], [-115.41501, 33.90797], [-115.41501, 33.90709], [-115.41577, 33.9071]]], [[[-115.42113, 33.90913], [-115.42096, 33.90966], [-115.42064, 33.90959], [-115.418, 33.91076], [-115.41661, 33.91075], [-115.42056, 33.909], [-115.42113, 33.90913]]], [[[-115.42044, 33.90739], [-115.41978, 33.90743], [-115.41945, 33.9035], [-115.42011, 33.90351], [-115.42044, 33.90739]]]]} | Open Access 1 | 44795 | 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 | Riverside 10 | 13.226 | SLC | 0 | State Resource Management Area 55 | 3 | |
16352 | 16352 | 16351 | {"type": "Polygon", "coordinates": [[[-117.3542, 33.60498], [-117.34984, 33.60488], [-117.34984, 33.60123], [-117.34548, 33.60113], [-117.3455, 33.59749], [-117.35419, 33.59768], [-117.3542, 33.60498]]]} | Open Access 1 | 44762 | 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 | Riverside 10 | 121.181 | 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]);