units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, DES_TP = 8, MNG_AGENCY = 25 and YR_EST = 2003
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15548 | 15548 | 15547 | {"type": "MultiPolygon", "coordinates": [[[[-121.45789, 38.26582], [-121.45767, 38.26729], [-121.45774, 38.2673], [-121.45751, 38.26975], [-121.45732, 38.26973], [-121.45657, 38.26972], [-121.45655, 38.26957], [-121.45464, 38.27005], [-121.4543, 38.27018], [-121.45301, 38.26681], [-121.45491, 38.26671], [-121.4556, 38.26691], [-121.45678, 38.26697], [-121.45789, 38.26582]]], [[[-121.39224, 38.26209], [-121.39208, 38.27592], [-121.38748, 38.27593], [-121.3876, 38.28325], [-121.37871, 38.28322], [-121.37877, 38.27595], [-121.37624, 38.27596], [-121.37622, 38.27665], [-121.37362, 38.27663], [-121.37364, 38.27447], [-121.37322, 38.27423], [-121.37277, 38.27395], [-121.37227, 38.27359], [-121.37202, 38.27336], [-121.37184, 38.27315], [-121.37152, 38.27271], [-121.37138, 38.27249], [-121.37132, 38.27233], [-121.3713, 38.27225], [-121.37129, 38.27196], [-121.37118, 38.27188], [-121.37072, 38.2715], [-121.37003, 38.27122], [-121.36776, 38.27164], [-121.36546, 38.27173], [-121.3639, 38.27148], [-121.363, 38.27114], [-121.36152, 38.27125], [-121.35993, 38.27092], [-121.35983, 38.26368], [-121.35984, 38.26194], [-121.36997, 38.26204], [-121.36994, 38.26662], [-121.37924, 38.26667], [-121.37929, 38.26206], [-121.39224, 38.26209]]], [[[-121.37865, 38.29094], [-121.37858, 38.29856], [-121.36937, 38.29852], [-121.36879, 38.29851], [-121.36912, 38.29823], [-121.36956, 38.29807], [-121.37005, 38.29797], [-121.37038, 38.29798], [-121.37067, 38.29794], [-121.37086, 38.29787], [-121.37113, 38.29771], [-121.37121, 38.29757], [-121.37127, 38.29718], [-121.37136, 38.29707], [-121.37179, 38.2968], [-121.37218, 38.29665], [-121.37238, 38.29651], [-121.3725, 38.29627], [-121.37254, 38.29608], [-121.37255, 38.29576], [-121.37268, 38.29546], [-121.37292, 38.29516], [-121.37312, 38.29483], [-121.37332, 38.29444], [-121.37347, 38.2939], [-121.37394, 38.29319], [-121.3741, 38.29298], [-121.37411, 38.29118], [-121.37422, 38.29107], [-121.37501, 38.29094], [-121.37568, 38.2909], [-121.37834, 38.29089], [-121.37865, 38.29094]]], [[[-121.38512, 38.31501], [-121.38431, 38.31541], [-121.38404, 38.31529], [-121.38224, 38.31617], [-121.38094, 38.31689], [-121.3799, 38.31769], [-121.3773, 38.32209], [-121.36688, 38.32234], [-121.36679, 38.33285], [-121.35757, 38.3328], [-121.35753, 38.33645], [-121.35294, 38.33642], [-121.35293, 38.3367], [-121.33795, 38.33676], [-121.33642, 38.33261], [-121.33636, 38.33264], [-121.3362, 38.33267], [-121.33593, 38.33266], [-121.33745, 38.33677], [-121.33518, 38.33678], [-121.33665, 38.34043], [-121.33646, 38.34184], [-121.3362, 38.34175], [-121.33567, 38.34166], [-121.33534, 38.34153], [-121.33516, 38.34143], [-121.335, 38.3413], [-121.33485, 38.34113], [-121.33476, 38.34098], [-121.32949, 38.32963], [-121.32784, 38.32601], [-121.32748, 38.32505], [-121.32777, 38.32497], [-121.32793, 38.32489], [-121.32808, 38.32479], [-121.32819, 38.32465], [-121.32825, 38.32453], [-121.32828, 38.32438], [-121.32827, 38.32425], [-121.32821, 38.32404], [-121.32824, 38.32401], [-121.32836, 38.32395], [-121.32843, 38.32387], [-121.32845, 38.32377], [-121.32842, 38.32369], [-121.32835, 38.32358], [-121.32823, 38.32347], [-121.32808, 38.32337], [-121.32712, 38.32297], [-121.32693, 38.32287], [-121.32677, 38.32277], [-121.32657, 38.3226], [-121.32644, 38.32245], [-121.32631, 38.32224], [-121.32628, 38.32211], [-121.3376, 38.32217], [-121.33754, 38.31278], [-121.34387, 38.31278], [-121.34384, 38.30808], [-121.34543, 38.30807], [-121.34544, 38.30772], [-121.34581, 38.30768], [-121.346, 38.30771], [-121.34615, 38.30772], [-121.34628, 38.30769], [-121.34649, 38.3076], [-121.34671, 38.30746], [-121.34694, 38.30737], [-121.34722, 38.30735], [-121.34757, 38.30738], [-121.34772, 38.30735], [-121.3478, 38.30731], [-121.34795, 38.30716], [-121.34841, 38.30662], [-121.34857, 38.30647], [-121.34881, 38.30632], [-121.34903, 38.30615], [-121.34947, 38.3057], [-121.35, 38.30531], [-121.35018, 38.30521], [-121.35032, 38.30517], [-121.35059, 38.30523], [-121.35078, 38.30529], [-121.3509, 38.30529], [-121.35102, 38.30525], [-121.35114, 38.30519], [-121.3513, 38.30507], [-121.35136, 38.30495], [-121.35137, 38.30463], [-121.35143, 38.30444], [-121.35159, 38.30428], [-121.35183, 38.30417], [-121.35211, 38.30411], [-121.35249, 38.30411], [-121.35282, 38.30413], [-121.35307, 38.3041], [-121.35353, 38.30399], [-121.35381, 38.30392], [-121.35406, 38.30381], [-121.35435, 38.30364], [-121.35468, 38.30349], [-121.35501, 38.30338], [-121.35527, 38.30333], [-121.35557, 38.30331], [-121.35652, 38.30335], [-121.35685, 38.30332], [-121.35716, 38.30324], [-121.3574, 38.30314], [-121.35876, 38.3022], [-121.35902, 38.3021], [-121.35936, 38.30203], [-121.35953, 38.30197], [-121.35969, 38.30187], [-121.35975, 38.30173], [-121.35973, 38.30161], [-121.35964, 38.3015], [-121.35949, 38.30137], [-121.35946, 38.30128], [-121.35947, 38.30117], [-121.35957, 38.30109], [-121.35994, 38.30104], [-121.36058, 38.30087], [-121.36085, 38.30082], [-121.36102, 38.30081], [-121.36126, 38.30084], [-121.36147, 38.30084], [-121.36161, 38.30081], [-121.36206, 38.3005], [-121.36233, 38.30011], [-121.36253, 38.29992], [-121.36272, 38.2998], [-121.36316, 38.29966], [-121.36397, 38.29965], [-121.36428, 38.2996], [-121.36459, 38.2996], [-121.36476, 38.29969], [-121.36485, 38.29982], [-121.36488, 38.30006], [-121.36488, 38.30021], [-121.36502, 38.30047], [-121.36515, 38.30053], [-121.36536, 38.30054], [-121.36596, 38.30039], [-121.36648, 38.30029], [-121.36657, 38.30025], [-121.36653, 38.30031], [-121.36523, 38.3013], [-121.3652, 38.30557], [-121.36531, 38.31376], [-121.37112, 38.31378], [-121.37568, 38.30826], [-121.38512, 38.31501]]], [[[-121.33304, 38.34475], [-121.33237, 38.34524], [-121.33106, 38.34628], [-121.32177, 38.35345], [-121.32052, 38.35213], [-121.3206, 38.34373], [-121.33156, 38.34376], [-121.33304, 38.34475]]], [[[-121.32501, 38.35685], [-121.32198, 38.35367], [-121.3313, 38.34648], [-121.33261, 38.34544], [-121.33322, 38.34499], [-121.336, 38.34501], [-121.33603, 38.34468], [-121.33641, 38.34546], [-121.33682, 38.3462], [-121.33919, 38.3504], [-121.34277, 38.35679], [-121.34305, 38.3575], [-121.34449, 38.36005], [-121.34476, 38.36046], [-121.34505, 38.36085], [-121.34559, 38.36148], [-121.34595, 38.36184], [-121.34633, 38.36218], [-121.34704, 38.36273], [-121.34705, 38.36272], [-121.34665, 38.36164], [-121.34681, 38.3618], [-121.34766, 38.36405], [-121.34755, 38.36409], [-121.3479, 38.36507], [-121.34296, 38.36327], [-121.34284, 38.36304], [-121.34272, 38.3627], [-121.34266, 38.36246], [-121.34242, 38.36216], [-121.34186, 38.36158], [-121.34178, 38.36135], [-121.34176, 38.36107], [-121.34171, 38.36066], [-121.34167, 38.3605], [-121.34129, 38.36076], [-121.33881, 38.36217], [-121.33816, 38.36257], [-121.33741, 38.363], [-121.3368, 38.36336], [-121.33647, 38.36353], [-121.3361, 38.36368], [-121.33596, 38.36371], [-121.33515, 38.36101], [-121.32958, 38.35914], [-121.32829, 38.3586], [-121.32591, 38.3578], [-121.32501, 38.35685]]]]} | Open Access 1 | 124 | Cosumnes River Ecological Reserve | 32137 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cosumnes-River-ER | Sacramento 41 | 4574.064 | Cosumnes River ER | 2003 | State Conservation Area 8 | 2 |
15557 | 15557 | 15556 | {"type": "MultiPolygon", "coordinates": [[[[-121.42502, 37.04646], [-121.41822, 37.05058], [-121.41609, 37.05063], [-121.41615, 37.05185], [-121.40969, 37.05176], [-121.40962, 37.05477], [-121.40454, 37.05794], [-121.40327, 37.05796], [-121.40331, 37.0588], [-121.40269, 37.05882], [-121.39201, 37.05815], [-121.38528, 37.05828], [-121.37624, 37.05776], [-121.37597, 37.05067], [-121.367, 37.05022], [-121.36694, 37.04679], [-121.36411, 37.04661], [-121.36429, 37.05471], [-121.36382, 37.05474], [-121.3635, 37.05469], [-121.36324, 37.05458], [-121.36307, 37.05448], [-121.36274, 37.0542], [-121.3626, 37.05411], [-121.36242, 37.05405], [-121.36229, 37.05399], [-121.36223, 37.0539], [-121.36213, 37.05361], [-121.36202, 37.05352], [-121.36175, 37.05347], [-121.36156, 37.05341], [-121.36095, 37.05298], [-121.36075, 37.0528], [-121.36072, 37.05269], [-121.36072, 37.05249], [-121.3607, 37.05238], [-121.36053, 37.05228], [-121.36035, 37.05219], [-121.3602, 37.0521], [-121.35999, 37.05199], [-121.35978, 37.05194], [-121.35962, 37.05196], [-121.35917, 37.05219], [-121.35905, 37.05222], [-121.35878, 37.05222], [-121.35866, 37.05216], [-121.35855, 37.05201], [-121.35844, 37.05191], [-121.35833, 37.05185], [-121.35808, 37.05176], [-121.35788, 37.05175], [-121.35697, 37.05178], [-121.35581, 37.05178], [-121.35555, 37.05174], [-121.35544, 37.05168], [-121.35536, 37.05155], [-121.35525, 37.05151], [-121.35509, 37.05149], [-121.35481, 37.0515], [-121.35468, 37.05149], [-121.35425, 37.05134], [-121.35406, 37.05129], [-121.35387, 37.05126], [-121.35342, 37.05128], [-121.35321, 37.05125], [-121.35304, 37.05125], [-121.35275, 37.05133], [-121.3521, 37.0516], [-121.35196, 37.05164], [-121.3515, 37.05169], [-121.35113, 37.0516], [-121.35086, 37.0515], [-121.35056, 37.05142], [-121.35026, 37.05145], [-121.34996, 37.05154], [-121.34982, 37.05156], [-121.34965, 37.05154], [-121.34929, 37.05139], [-121.34913, 37.05137], [-121.34877, 37.05117], [-121.34864, 37.05112], [-121.34852, 37.0511], [-121.34825, 37.05109], [-121.34813, 37.05111], [-121.3477, 37.05128], [-121.34731, 37.05137], [-121.34691, 37.05142], [-121.34606, 37.05149], [-121.34604, 37.05023], [-121.32957, 37.05031], [-121.33085, 37.04625], [-121.33651, 37.02905], [-121.33662, 37.02903], [-121.33827, 37.02371], [-121.34022, 37.0239], [-121.35088, 37.02542], [-121.35101, 37.02998], [-121.35212, 37.03097], [-121.3523, 37.03188], [-121.35303, 37.03303], [-121.35334, 37.03426], [-121.35557, 37.03629], [-121.35847, 37.03391], [-121.36146, 37.0343], [-121.36309, 37.03399], [-121.3631, 37.03621], [-121.36402, 37.04303], [-121.37749, 37.04357], [-121.37955, 37.04217], [-121.38009, 37.04178], [-121.38075, 37.04154], [-121.38122, 37.04116], [-121.3819, 37.04043], [-121.38297, 37.04016], [-121.38367, 37.03954], [-121.38366, 37.0363], [-121.39177, 37.03632], [-121.3938, 37.03631], [-121.394, 37.03598], [-121.39463, 37.03564], [-121.39526, 37.03506], [-121.39602, 37.03502], [-121.39648, 37.03495], [-121.39709, 37.03525], [-121.39753, 37.03527], [-121.39793, 37.0349], [-121.39896, 37.03458], [-121.39951, 37.03458], [-121.40003, 37.03472], [-121.40067, 37.03467], [-121.40131, 37.03454], [-121.40427, 37.03508], [-121.40506, 37.03536], [-121.40557, 37.03567], [-121.40701, 37.0349], [-121.40769, 37.03476], [-121.40807, 37.03454], [-121.40852, 37.03441], [-121.40913, 37.03467], [-121.40939, 37.03462], [-121.40997, 37.0341], [-121.4101, 37.03389], [-121.41053, 37.03391], [-121.41123, 37.0342], [-121.41116, 37.0331], [-121.41192, 37.033], [-121.41215, 37.03267], [-121.42487, 37.0343], [-121.42446, 37.03451], [-121.42097, 37.03407], [-121.42099, 37.03551], [-121.42093, 37.03553], [-121.42104, 37.03879], [-121.42111, 37.0429], [-121.4207, 37.04324], [-121.42062, 37.04364], [-121.42095, 37.04403], [-121.42172, 37.0447], [-121.4229, 37.04543], [-121.42372, 37.0454], [-121.42502, 37.04646]]], [[[-121.38565, 37.08728], [-121.36412, 37.08649], [-121.36454, 37.05709], [-121.38534, 37.05845], [-121.38565, 37.08728]]]]} | Open Access 1 | 1196 | Canada de los Osos Ecological Reserve | 32087 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Canada-de-los-Osos-ER | Santa Clara 19 | 5588.786 | Canada de los Osos ER | 2003 | State Conservation Area 8 | 2 |
16906 | 16906 | 16905 | {"type": "MultiPolygon", "coordinates": [[[[-121.60793, 39.58166], [-121.60081, 39.5817], [-121.59597, 39.58558], [-121.59611, 39.58892], [-121.59097, 39.58899], [-121.59104, 39.59439], [-121.57821, 39.59409], [-121.57835, 39.59764], [-121.57872, 39.60328], [-121.5788, 39.60478], [-121.5769, 39.6048], [-121.57691, 39.60674], [-121.57682, 39.60678], [-121.5766, 39.60692], [-121.57649, 39.60708], [-121.57648, 39.60715], [-121.57645, 39.60719], [-121.57627, 39.60729], [-121.57599, 39.60754], [-121.57578, 39.60741], [-121.57545, 39.60743], [-121.57518, 39.60741], [-121.57506, 39.60752], [-121.57446, 39.60759], [-121.57424, 39.60776], [-121.57363, 39.60793], [-121.57338, 39.60803], [-121.57311, 39.60833], [-121.57306, 39.60847], [-121.57286, 39.60856], [-121.5726, 39.6087], [-121.57194, 39.60881], [-121.57126, 39.60867], [-121.57102, 39.60878], [-121.57049, 39.60913], [-121.57047, 39.61007], [-121.56819, 39.61017], [-121.55882, 39.60999], [-121.55891, 39.60509], [-121.54952, 39.60743], [-121.54956, 39.60515], [-121.54017, 39.60521], [-121.54014, 39.59796], [-121.54014, 39.59575], [-121.5405, 39.59585], [-121.54069, 39.59582], [-121.54184, 39.59484], [-121.54319, 39.59373], [-121.54335, 39.59357], [-121.54419, 39.59171], [-121.54435, 39.59155], [-121.54458, 39.59101], [-121.54476, 39.59023], [-121.54478, 39.59794], [-121.55409, 39.59788], [-121.55415, 39.58322], [-121.55414, 39.57947], [-121.55441, 39.57917], [-121.55454, 39.57875], [-121.55478, 39.57852], [-121.55476, 39.57697], [-121.55493, 39.57624], [-121.55482, 39.57597], [-121.55439, 39.57572], [-121.55439, 39.57495], [-121.55449, 39.57477], [-121.55458, 39.57452], [-121.55457, 39.57421], [-121.5548, 39.57386], [-121.55486, 39.57351], [-121.55481, 39.57321], [-121.55484, 39.57287], [-121.55495, 39.57237], [-121.57665, 39.57227], [-121.57666, 39.57245], [-121.57729, 39.57244], [-121.57729, 39.57243], [-121.57715, 39.57088], [-121.58621, 39.57083], [-121.5863, 39.5781], [-121.60766, 39.57796], [-121.60777, 39.57805], [-121.60792, 39.57827], [-121.60811, 39.57857], [-121.60827, 39.57888], [-121.60834, 39.57906], [-121.60839, 39.57926], [-121.60845, 39.57967], [-121.60846, 39.57995], [-121.60845, 39.58022], [-121.60842, 39.58048], [-121.60836, 39.58074], [-121.60828, 39.581], [-121.60817, 39.58126], [-121.60801, 39.58158], [-121.60793, 39.58166]]], [[[-121.55476, 39.57624], [-121.5546, 39.57695], [-121.55458, 39.57795], [-121.55455, 39.57844], [-121.55432, 39.57872], [-121.55423, 39.57904], [-121.55414, 39.57921], [-121.55412, 39.57238], [-121.55467, 39.57238], [-121.55469, 39.57258], [-121.55464, 39.5728], [-121.55464, 39.57331], [-121.55465, 39.57357], [-121.55461, 39.57386], [-121.55434, 39.57413], [-121.55431, 39.57458], [-121.55419, 39.57489], [-121.55424, 39.5758], [-121.55469, 39.57606], [-121.55476, 39.57624]]], [[[-121.60956, 39.58165], [-121.60873, 39.58166], [-121.60884, 39.58145], [-121.60896, 39.58116], [-121.60909, 39.5807], [-121.60917, 39.58024], [-121.60917, 39.57977], [-121.60912, 39.5793], [-121.60903, 39.57892], [-121.60885, 39.57852], [-121.60861, 39.57809], [-121.60855, 39.57796], [-121.60952, 39.57795], [-121.60956, 39.58165]]]]} | Open Access 1 | 2497 | North Table Mountain Ecological Reserve | 32246 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/North-Table-Mountain-ER | Butte 42 | 3239.967 | North Table Mtn. ER | 2003 | 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]);