units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, COUNTY = 41 and DES_TP = 8
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
| 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 |
| 16700 | 16700 | 16699 | {"type": "Polygon", "coordinates": [[[-121.83768, 38.06205], [-121.83141, 38.06038], [-121.8314, 38.06039], [-121.8314, 38.06208], [-121.82966, 38.0619], [-121.82234, 38.05983], [-121.822, 38.05971], [-121.82123, 38.05898], [-121.8211, 38.05889], [-121.82095, 38.05875], [-121.82046, 38.0584], [-121.82031, 38.05831], [-121.82009, 38.05823], [-121.81988, 38.05814], [-121.81952, 38.05786], [-121.81936, 38.05769], [-121.81913, 38.05754], [-121.81855, 38.05722], [-121.81828, 38.05708], [-121.81771, 38.05684], [-121.81729, 38.05673], [-121.81705, 38.05664], [-121.81678, 38.05661], [-121.81654, 38.05649], [-121.81634, 38.05644], [-121.81577, 38.05642], [-121.81556, 38.05636], [-121.81529, 38.05621], [-121.81515, 38.05606], [-121.815, 38.05597], [-121.81485, 38.05598], [-121.81453, 38.05611], [-121.81424, 38.05608], [-121.81398, 38.05596], [-121.81373, 38.05583], [-121.81354, 38.05582], [-121.81319, 38.05565], [-121.81287, 38.05557], [-121.81232, 38.0553], [-121.81204, 38.05515], [-121.8119, 38.05499], [-121.81178, 38.05483], [-121.81169, 38.05473], [-121.81156, 38.0547], [-121.81134, 38.0547], [-121.81111, 38.05481], [-121.81089, 38.05478], [-121.81068, 38.0548], [-121.81052, 38.05489], [-121.81032, 38.05495], [-121.81022, 38.05502], [-121.81011, 38.05503], [-121.80996, 38.05497], [-121.8097, 38.05496], [-121.80942, 38.05498], [-121.80915, 38.05498], [-121.80893, 38.05486], [-121.80881, 38.05472], [-121.80864, 38.05458], [-121.80846, 38.05458], [-121.8083, 38.0545], [-121.80816, 38.05438], [-121.8078, 38.05428], [-121.80747, 38.05415], [-121.80711, 38.05404], [-121.80673, 38.0539], [-121.80625, 38.0539], [-121.8058, 38.05405], [-121.80563, 38.05397], [-121.80539, 38.05391], [-121.80519, 38.05392], [-121.80491, 38.05399], [-121.80474, 38.05407], [-121.80453, 38.05404], [-121.80411, 38.05404], [-121.80364, 38.05379], [-121.80303, 38.05352], [-121.80292, 38.0535], [-121.80279, 38.05351], [-121.8025, 38.05358], [-121.80218, 38.0538], [-121.80185, 38.05394], [-121.80147, 38.054], [-121.80113, 38.054], [-121.80075, 38.05393], [-121.79652, 38.0544], [-121.79652, 38.05442], [-121.79686, 38.05445], [-121.79695, 38.05449], [-121.79704, 38.05459], [-121.79705, 38.05465], [-121.79704, 38.0547], [-121.79691, 38.05482], [-121.79681, 38.05486], [-121.79652, 38.05493], [-121.79613, 38.05496], [-121.79599, 38.055], [-121.79591, 38.05505], [-121.79582, 38.05513], [-121.79562, 38.05538], [-121.79555, 38.05547], [-121.7955, 38.05563], [-121.79533, 38.05579], [-121.79518, 38.05601], [-121.79511, 38.05607], [-121.79497, 38.05613], [-121.79486, 38.05605], [-121.79482, 38.05601], [-121.7947, 38.05571], [-121.79471, 38.05561], [-121.79469, 38.05553], [-121.79456, 38.0553], [-121.79442, 38.05518], [-121.79326, 38.05568], [-121.79285, 38.05598], [-121.79287, 38.0562], [-121.79286, 38.05624], [-121.79279, 38.05635], [-121.79265, 38.0564], [-121.79231, 38.05636], [-121.79074, 38.05749], [-121.78848, 38.05937], [-121.7855, 38.06069], [-121.78533, 38.0608], [-121.78453, 38.06117], [-121.78453, 38.06067], [-121.78537, 38.0598], [-121.78537, 38.05941], [-121.78572, 38.05835], [-121.78574, 38.05715], [-121.78517, 38.05557], [-121.78424, 38.05544], [-121.78418, 38.05466], [-121.78414, 38.0538], [-121.78414, 38.05268], [-121.78417, 38.05227], [-121.78415, 38.05216], [-121.78406, 38.05184], [-121.7839, 38.05174], [-121.78388, 38.05175], [-121.78453, 38.05121], [-121.78542, 38.05035], [-121.78674, 38.04934], [-121.78729, 38.04818], [-121.78733, 38.04693], [-121.78715, 38.04565], [-121.78699, 38.04394], [-121.78631, 38.04142], [-121.78566, 38.04016], [-121.78451, 38.03939], [-121.78476, 38.03862], [-121.78504, 38.02658], [-121.78569, 38.02648], [-121.7865, 38.0263], [-121.78749, 38.02626], [-121.78759, 38.02622], [-121.78796, 38.02619], [-121.78813, 38.02613], [-121.78877, 38.0261], [-121.7892, 38.02604], [-121.78992, 38.02601], [-121.79098, 38.02588], [-121.79175, 38.02583], [-121.79251, 38.02574], [-121.79333, 38.02572], [-121.79409, 38.02567], [-121.79427, 38.02567], [-121.79445, 38.02581], [-121.79484, 38.02578], [-121.79489, 38.02573], [-121.7952, 38.0257], [-121.7957, 38.02572], [-121.79629, 38.02569], [-121.79634, 38.02566], [-121.79824, 38.02557], [-121.79863, 38.02549], [-121.79902, 38.02547], [-121.79928, 38.02542], [-121.79941, 38.02537], [-121.79951, 38.02528], [-121.79978, 38.02511], [-121.79978, 38.02504], [-121.79984, 38.02495], [-121.80015, 38.025], [-121.80053, 38.025], [-121.80066, 38.02495], [-121.80072, 38.02487], [-121.8011, 38.02484], [-121.80126, 38.02481], [-121.80179, 38.02479], [-121.80199, 38.02473], [-121.80217, 38.02462], [-121.8023, 38.02457], [-121.80269, 38.02465], [-121.80296, 38.02483], [-121.80309, 38.02495], [-121.80309, 38.02509], [-121.80337, 38.02535], [-121.80355, 38.02541], [-121.80372, 38.02543], [-121.8039, 38.02552], [-121.80408, 38.02558], [-121.80437, 38.02561], [-121.80537, 38.02569], [-121.80613, 38.02578], [-121.80664, 38.02589], [-121.80699, 38.02602], [-121.80781, 38.02621], [-121.80861, 38.02646], [-121.8088, 38.02651], [-121.80909, 38.02656], [-121.80956, 38.02672], [-121.80971, 38.0268], [-121.81054, 38.027], [-121.81074, 38.02711], [-121.81099, 38.02716], [-121.81127, 38.02728], [-121.81208, 38.02772], [-121.81226, 38.0278], [-121.81287, 38.02812], [-121.81398, 38.02877], [-121.81411, 38.02888], [-121.8143, 38.02893], [-121.81522, 38.02952], [-121.8155, 38.02978], [-121.81594, 38.03004], [-121.81632, 38.03033], [-121.81699, 38.03079], [-121.81733, 38.03108], [-121.81779, 38.03152], [-121.81893, 38.03242], [-121.81918, 38.03257], [-121.8195, 38.03269], [-121.82126, 38.03344], [-121.8218, 38.0336], [-121.8226, 38.03396], [-121.8237, 38.03437], [-121.82419, 38.03462], [-121.82481, 38.03485], [-121.82504, 38.03498], [-121.82596, 38.03539], [-121.82631, 38.0356], [-121.82702, 38.03595], [-121.8279, 38.03642], [-121.82844, 38.03677], [-121.82892, 38.03713], [-121.82933, 38.03739], [-121.82969, 38.03773], [-121.83016, 38.03842], [-121.83042, 38.03889], [-121.83075, 38.03939], [-121.83111, 38.03991], [-121.83146, 38.04047], [-121.83186, 38.04101], [-121.83231, 38.04185], [-121.83246, 38.04207], [-121.83255, 38.04217], [-121.83274, 38.04227], [-121.83283, 38.04261], [-121.83282, 38.04299], [-121.83284, 38.04325], [-121.83289, 38.04352], [-121.83289, 38.04403], [-121.83292, 38.04469], [-121.83303, 38.04482], [-121.83331, 38.04524], [-121.83327, 38.04539], [-121.83329, 38.04562], [-121.83338, 38.04577], [-121.83344, 38.04593], [-121.83344, 38.04604], [-121.83371, 38.04629], [-121.83371, 38.04656], [-121.83366, 38.04676], [-121.83366, 38.04695], [-121.83358, 38.04706], [-121.83357, 38.04709], [-121.8336, 38.04716], [-121.83376, 38.04725], [-121.83391, 38.04741], [-121.83398, 38.04761], [-121.83442, 38.04922], [-121.83433, 38.04942], [-121.8342, 38.04945], [-121.83409, 38.0494], [-121.83398, 38.04939], [-121.83403, 38.05001], [-121.83416, 38.05013], [-121.83423, 38.05039], [-121.83421, 38.05082], [-121.83427, 38.05097], [-121.83427, 38.0513], [-121.83416, 38.05166], [-121.83421, 38.0518], [-121.83422, 38.05202], [-121.83421, 38.0523], [-121.83414, 38.05238], [-121.83429, 38.0537], [-121.83442, 38.05516], [-121.83484, 38.05699], [-121.8353, 38.05789], [-121.83535, 38.05795], [-121.83549, 38.05819], [-121.83561, 38.0585], [-121.83561, 38.05858], [-121.83599, 38.05948], [-121.83631, 38.05981], [-121.83678, 38.06023], [-121.83711, 38.06071], [-121.83725, 38.06095], [-121.83742, 38.06111], [-121.83757, 38.06128], [-121.83757, 38.0615], [-121.83763, 38.0617], [-121.83761, 38.06186], [-121.83763, 38.06199], [-121.83768, 38.06205]]]} | Open Access 1 | 1855 | Lower Sherman Island Wildlife Area | 30468 | 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/Lower-Sherman-Island-WA | Sacramento 41 | 3234.531 | Lower Sherman Island Wildlife Area | 1976 | 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]);