units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3, GAP_STS = 2 and MNG_AGENCY = 533
This data as json, copyable, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10898 | 10898 | 10897 | {"type": "MultiPolygon", "coordinates": [[[[-121.22561, 38.72393], [-121.22559, 38.72431], [-121.22119, 38.72428], [-121.22118, 38.7243], [-121.22195, 38.7251], [-121.22065, 38.72586], [-121.21916, 38.72429], [-121.22028, 38.7229], [-121.22046, 38.72272], [-121.22065, 38.72256], [-121.22102, 38.72233], [-121.22139, 38.72217], [-121.22183, 38.72204], [-121.2223, 38.72198], [-121.22232, 38.72214], [-121.22233, 38.7239], [-121.22561, 38.72393]]], [[[-121.25541, 38.72966], [-121.25391, 38.72967], [-121.2539, 38.72955], [-121.25075, 38.72948], [-121.25075, 38.72943], [-121.25157, 38.72942], [-121.25186, 38.72935], [-121.25236, 38.72912], [-121.25267, 38.72885], [-121.25274, 38.7289], [-121.25282, 38.72891], [-121.2529, 38.72889], [-121.25296, 38.72883], [-121.25312, 38.7288], [-121.25327, 38.72887], [-121.25345, 38.72864], [-121.25424, 38.72903], [-121.25523, 38.72961], [-121.25541, 38.72966]]], [[[-121.3323, 38.75879], [-121.3323, 38.75929], [-121.33079, 38.75928], [-121.3305, 38.7593], [-121.33002, 38.75945], [-121.32985, 38.75945], [-121.32985, 38.75845], [-121.33025, 38.75845], [-121.33028, 38.75843], [-121.3304, 38.75845], [-121.33047, 38.75843], [-121.33053, 38.75837], [-121.33088, 38.75847], [-121.33087, 38.75854], [-121.331, 38.75873], [-121.3311, 38.75881], [-121.33132, 38.75858], [-121.33143, 38.7586], [-121.33154, 38.75855], [-121.33194, 38.75878], [-121.3323, 38.75879]]], [[[-121.33422, 38.75841], [-121.33424, 38.75849], [-121.33421, 38.75857], [-121.33372, 38.75912], [-121.3334, 38.75955], [-121.33237, 38.7607], [-121.33232, 38.76072], [-121.33226, 38.76072], [-121.33225, 38.76071], [-121.33233, 38.76067], [-121.33284, 38.7601], [-121.33285, 38.75943], [-121.33248, 38.75942], [-121.33248, 38.75898], [-121.33284, 38.75898], [-121.33285, 38.7588], [-121.33312, 38.75879], [-121.33312, 38.7585], [-121.33319, 38.75849], [-121.33324, 38.75846], [-121.33327, 38.75842], [-121.33328, 38.75836], [-121.33336, 38.75835], [-121.33354, 38.75805], [-121.33322, 38.75785], [-121.33287, 38.75768], [-121.33225, 38.75745], [-121.3318, 38.75733], [-121.33138, 38.75723], [-121.33062, 38.75708], [-121.33052, 38.7571], [-121.33055, 38.75706], [-121.33061, 38.75705], [-121.33131, 38.75718], [-121.3319, 38.75731], [-121.33246, 38.75749], [-121.33289, 38.75765], [-121.33325, 38.75782], [-121.33358, 38.75803], [-121.33415, 38.75834], [-121.33422, 38.75841]]], [[[-121.34395, 38.76631], [-121.3401, 38.76633], [-121.34008, 38.76526], [-121.33485, 38.76544], [-121.33485, 38.76428], [-121.33615, 38.76423], [-121.33616, 38.7606], [-121.33339, 38.76004], [-121.3339, 38.75948], [-121.33417, 38.75923], [-121.33459, 38.75877], [-121.3347, 38.75872], [-121.33481, 38.75872], [-121.33558, 38.75912], [-121.33662, 38.7595], [-121.33744, 38.75973], [-121.33833, 38.7599], [-121.33836, 38.75993], [-121.33837, 38.75996], [-121.33831, 38.76039], [-121.33832, 38.76053], [-121.33836, 38.76066], [-121.33844, 38.76081], [-121.33857, 38.76095], [-121.33869, 38.76106], [-121.33887, 38.76116], [-121.33906, 38.76123], [-121.33923, 38.76127], [-121.33998, 38.76133], [-121.34019, 38.76137], [-121.34035, 38.76142], [-121.34153, 38.76191], [-121.34176, 38.76198], [-121.342, 38.76202], [-121.342, 38.76224], [-121.34208, 38.76286], [-121.34215, 38.7629], [-121.34244, 38.76291], [-121.34242, 38.76304], [-121.34239, 38.76313], [-121.34242, 38.76322], [-121.34216, 38.76352], [-121.34216, 38.76354], [-121.34395, 38.76354], [-121.34395, 38.76631]]], [[[-121.27652, 38.76697], [-121.27618, 38.76698], [-121.27629, 38.76722], [-121.27618, 38.76725], [-121.27606, 38.76698], [-121.27273, 38.767], [-121.27272, 38.76658], [-121.27639, 38.76656], [-121.27641, 38.76677], [-121.27646, 38.76689], [-121.27652, 38.76697]]], [[[-121.30982, 38.7664], [-121.3098, 38.76652], [-121.30975, 38.76662], [-121.30502, 38.76678], [-121.30297, 38.76742], [-121.30298, 38.7674], [-121.30435, 38.76697], [-121.30433, 38.76641], [-121.30982, 38.7664]]], [[[-121.25912, 38.75786], [-121.25908, 38.75784], [-121.25854, 38.75841], [-121.25833, 38.75842], [-121.25828, 38.75856], [-121.25802, 38.75868], [-121.25776, 38.75867], [-121.25742, 38.75888], [-121.257, 38.75904], [-121.25676, 38.75919], [-121.25667, 38.75934], [-121.25671, 38.75947], [-121.25709, 38.75987], [-121.25708, 38.75993], [-121.25665, 38.76037], [-121.25621, 38.76072], [-121.25571, 38.761], [-121.25433, 38.76191], [-121.25434, 38.76192], [-121.25468, 38.7619], [-121.25416, 38.76208], [-121.25369, 38.76265], [-121.2536, 38.763], [-121.25364, 38.76327], [-121.25375, 38.76346], [-121.25383, 38.7638], [-121.25403, 38.76437], [-121.25426, 38.76455], [-121.25432, 38.76476], [-121.25441, 38.76477], [-121.2544, 38.76485], [-121.25445, 38.76547], [-121.25441, 38.76562], [-121.25432, 38.76575], [-121.25376, 38.7663], [-121.24921, 38.76915], [-121.24737, 38.76923], [-121.24358, 38.76923], [-121.24383, 38.76898], [-121.2444, 38.76866], [-121.24454, 38.76851], [-121.24454, 38.76837], [-121.24445, 38.76825], [-121.24345, 38.76746], [-121.24315, 38.76732], [-121.24276, 38.76723], [-121.24156, 38.76722], [-121.24131, 38.76715], [-121.24132, 38.7668], [-121.2395, 38.7668], [-121.23943, 38.7667], [-121.23758, 38.76758], [-121.23763, 38.76735], [-121.23763, 38.76687], [-121.23817, 38.76687], [-121.23856, 38.76684], [-121.23897, 38.76677], [-121.23929, 38.76669], [-121.24377, 38.76669], [-121.24377, 38.76698], [-121.24555, 38.76802], [-121.24623, 38.76802], [-121.24624, 38.76788], [-121.24737, 38.76773], [-121.24743, 38.76773], [-121.24757, 38.76779], [-121.24767, 38.76785], [-121.24785, 38.76777], [-121.24796, 38.76779], [-121.248, 38.76772], [-121.24816, 38.76774], [-121.24832, 38.76773], [-121.24847, 38.7678], [-121.24867, 38.76771], [-121.2489, 38.76788], [-121.24926, 38.76778], [-121.24939, 38.76762], [-121.24954, 38.76754], [-121.24968, 38.76725], [-121.24985, 38.76724], [-121.24996, 38.76708], [-121.25015, 38.76708], [-121.25033, 38.76703], [-121.25045, 38.76691], [-121.25059, 38.76682], [-121.25074, 38.76681], [-121.25088, 38.76674], [-121.25108, 38.76643], [-121.25116, 38.76616], [-121.25106, 38.76601], [-121.25114, 38.76594], [-121.25126, 38.76603], [-121.25138, 38.76592], [-121.2513, 38.76584], [-121.25131, 38.76564], [-121.25144, 38.7655], [-121.25147, 38.76538], [-121.2516, 38.76527], [-121.25164, 38.76514], [-121.25181, 38.76493], [-121.25195, 38.76482], [-121.25186, 38.76467], [-121.25192, 38.76452], [-121.25187, 38.76441], [-121.25187, 38.76432], [-121.25175, 38.76425], [-121.25174, 38.76415], [-121.2518, 38.76401], [-121.2516, 38.76398], [-121.2514, 38.76387], [-121.25136, 38.76371], [-121.25134, 38.76369], [-121.25129, 38.76356], [-121.25124, 38.76352], [-121.25132, 38.76317], [-121.25137, 38.76283], [-121.25181, 38.76282], [-121.2522, 38.76276], [-121.25258, 38.76259], [-121.25261, 38.76246], [-121.25265, 38.76238], [-121.25258, 38.76173], [-121.25288, 38.76129], [-121.25278, 38.7611], [-121.2523, 38.76124], [-121.25211, 38.76115], [-121.25195, 38.76131], [-121.25195, 38.76133], [-121.2516, 38.76136], [-121.2512, 38.76133], [-121.25122, 38.76125], [-121.2516, 38.76126], [-121.25162, 38.76103], [-121.2517, 38.76062], [-121.25179, 38.76032], [-121.25193, 38.75995], [-121.25242, 38.75967], [-121.2524, 38.7595], [-121.25273, 38.75944], [-121.25307, 38.75931], [-121.25327, 38.75912], [-121.25345, 38.75912], [-121.2536, 38.75916], [-121.25413, 38.75896], [-121.25414, 38.75894], [-121.25401, 38.75876], [-121.25415, 38.75866], [-121.25427, 38.75875], [-121.25454, 38.75873], [-121.25488, 38.75863], [-121.25524, 38.75871], [-121.25534, 38.75855], [-121.25555, 38.75849], [-121.25549, 38.75857], [-121.25561, 38.75877], [-121.25613, 38.75891], [-121.2564, 38.75873], [-121.25677, 38.75841], [-121.25705, 38.75803], [-121.25768, 38.75766], [-121.25759, 38.75753], [-121.25739, 38.75744], [-121.25706, 38.75722], [-121.25715, 38.75704], [-121.25731, 38.75713], [-121.25782, 38.75729], [-121.258, 38.757], [-121.25898, 38.75739], [-121.25911, 38.75748], [-121.25926, 38.75754], [-121.25931, 38.7576], [-121.25931, 38.75764], [-121.25929, 38.75767], [-121.25912, 38.75786]]], [[[-121.25913, 38.76859], [-121.25871, 38.76979], [-121.25866, 38.76979], [-121.25831, 38.76959], [-121.25802, 38.76949], [-121.25776, 38.76944], [-121.25746, 38.76944], [-121.25745, 38.76894], [-121.25831, 38.76751], [-121.25913, 38.76859]]], [[[-121.29013, 38.77161], [-121.28995, 38.77182], [-121.28972, 38.77208], [-121.29013, 38.77161]]], [[[-121.27864, 38.77393], [-121.27854, 38.77395], [-121.27779, 38.77344], [-121.27714, 38.77357], [-121.27527, 38.77387], [-121.27472, 38.77347], [-121.27635, 38.77329], [-121.27702, 38.77333], [-121.27696, 38.77309], [-121.27694, 38.77291], [-121.27692, 38.77161], [-121.27678, 38.77148], [-121.27644, 38.77148], [-121.27582, 38.77155], [-121.27581, 38.77202], [-121.27526, 38.77222], [-121.27468, 38.77211], [-121.27445, 38.77175], [-121.27346, 38.77183], [-121.27298, 38.77224], [-121.27136, 38.77107], [-121.27067, 38.77061], [-121.27043, 38.77042], [-121.27207, 38.76989], [-121.27504, 38.76874], [-121.27516, 38.76873], [-121.27525, 38.76857], [-121.27534, 38.76858], [-121.27525, 38.76876], [-121.27656, 38.76946], [-121.27689, 38.76946], [-121.27689, 38.76954], [-121.27698, 38.76959], [-121.27704, 38.76966], [-121.27707, 38.76975], [-121.27711, 38.7728], [-121.2772, 38.77297], [-121.27743, 38.77311], [-121.27782, 38.77291], [-121.27842, 38.77338], [-121.27844, 38.77345], [-121.27851, 38.77351], [-121.27864, 38.77393]]], [[[-121.28835, 38.77325], [-121.2882, 38.77329], [-121.2882, 38.77331], [-121.28701, 38.77335], [-121.28618, 38.77381], [-121.28564, 38.77388], [-121.2852, 38.77401], [-121.2848, 38.77407], [-121.28385, 38.7743], [-121.28127, 38.77466], [-121.28112, 38.77429], [-121.27995, 38.7742], [-121.27887, 38.77401], [-121.27878, 38.77392], [-121.27867, 38.77373], [-121.27865, 38.77361], [-121.27868, 38.77356], [-121.27875, 38.77354], [-121.27945, 38.77356], [-121.27962, 38.77354], [-121.281, 38.77331], [-121.28203, 38.77273], [-121.28244, 38.77221], [-121.2832, 38.77231], [-121.28364, 38.77202], [-121.2841, 38.77202], [-121.28454, 38.77262], [-121.28449, 38.7728], [-121.28471, 38.77317], [-121.28551, 38.77343], [-121.28578, 38.77317], [-121.28718, 38.77267], [-121.28805, 38.773], [-121.28818, 38.77293], [-121.28835, 38.77325]]], [[[-121.2749, 38.77399], [-121.27435, 38.77408], [-121.27354, 38.77407], [-121.27351, 38.77444], [-121.27323, 38.77455], [-121.2726, 38.77439], [-121.27187, 38.7749], [-121.2719, 38.77532], [-121.27163, 38.77538], [-121.27082, 38.77591], [-121.27051, 38.77629], [-121.26983, 38.77681], [-121.26956, 38.77718], [-121.26893, 38.77739], [-121.26767, 38.77754], [-121.26734, 38.77727], [-121.26706, 38.77699], [-121.26682, 38.77668], [-121.26662, 38.77636], [-121.26649, 38.77608], [-121.26639, 38.77579], [-121.26606, 38.77432], [-121.26593, 38.77432], [-121.26597, 38.77387], [-121.26598, 38.77335], [-121.26602, 38.77331], [-121.26607, 38.77329], [-121.26616, 38.77329], [-121.2663, 38.77332], [-121.26637, 38.77337], [-121.2664, 38.77344], [-121.2663, 38.77382], [-121.26628, 38.77401], [-121.26627, 38.7743], [-121.26629, 38.77454], [-121.26651, 38.77555], [-121.26662, 38.77575], [-121.26679, 38.77622], [-121.26688, 38.77639], [-121.26704, 38.77662], [-121.2672, 38.77681], [-121.26738, 38.77695], [-121.26751, 38.77703], [-121.26769, 38.77709], [-121.26787, 38.77712], [-121.26817, 38.77713], [-121.26846, 38.7771], [-121.26869, 38.77704], [-121.26895, 38.77694], [-121.26916, 38.77681], [-121.26937, 38.77663], [-121.26965, 38.77627], [-121.26974, 38.77618], [-121.27044, 38.77566], [-121.27106, 38.77532], [-121.2712, 38.77519], [-121.27132, 38.77502], [-121.27149, 38.77502], [-121.27159, 38.77476], [-121.27192, 38.77449], [-121.27232, 38.7744], [-121.27238, 38.77413], [-121.27298, 38.77421], [-121.27334, 38.77396], [-121.27367, 38.77384], [-121.2746, 38.77376], [-121.2749, 38.77399]]], [[[-121.28707, 38.78013], [-121.287, 38.78052], [-121.28696, 38.78086], [-121.28684, 38.78074], [-121.28635, 38.78062], [-121.28589, 38.78067], [-121.28536, 38.78096], [-121.28495, 38.78141], [-121.28471, 38.78204], [-121.28376, 38.78264], [-121.28229, 38.7831], [-121.28035, 38.78292], [-121.27983, 38.783], [-121.27894, 38.78338], [-121.27864, 38.78323], [-121.27918, 38.78295], [-121.27991, 38.78237], [-121.28082, 38.78245], [-121.28215, 38.78218], [-121.28306, 38.78163], [-121.28387, 38.78074], [-121.28434, 38.78095], [-121.28453, 38.78055], [-121.28588, 38.78023], [-121.28635, 38.78029], [-121.28707, 38.78013]]], [[[-121.35548, 38.78148], [-121.35509, 38.78152], [-121.35433, 38.78261], [-121.35429, 38.78275], [-121.35394, 38.78269], [-121.35389, 38.78271], [-121.35384, 38.78267], [-121.35378, 38.78265], [-121.35362, 38.78252], [-121.35324, 38.78247], [-121.35205, 38.7822], [-121.35199, 38.78217], [-121.3519, 38.78217], [-121.35189, 38.78215], [-121.3515, 38.78206], [-121.3514, 38.78262], [-121.35135, 38.78281], [-121.35113, 38.783], [-121.35078, 38.78311], [-121.35015, 38.78319], [-121.34961, 38.7833], [-121.34904, 38.78344], [-121.34848, 38.78361], [-121.34828, 38.78364], [-121.34806, 38.78362], [-121.34667, 38.78324], [-121.34671, 38.78191], [-121.34679, 38.7816], [-121.34693, 38.78132], [-121.34708, 38.78114], [-121.34878, 38.77973], [-121.34925, 38.77952], [-121.34943, 38.77937], [-121.34917, 38.77917], [-121.34919, 38.77909], [-121.34914, 38.77901], [-121.34931, 38.77861], [-121.34933, 38.77845], [-121.3493, 38.77827], [-121.34923, 38.77811], [-121.34888, 38.77758], [-121.34962, 38.77733], [-121.3503, 38.77716], [-121.35033, 38.77722], [-121.35097, 38.77751], [-121.35159, 38.77815], [-121.35171, 38.77875], [-121.35188, 38.77911], [-121.3521, 38.7793], [-121.35299, 38.77965], [-121.35355, 38.78042], [-121.35469, 38.78081], [-121.35542, 38.78109], [-121.35523, 38.78137], [-121.35548, 38.78148]]]]} | No Public Access 3 | 20853 | Wetlands | 27444 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 394.838 | Wetlands | 0 | Local Conservation Area 4 | 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]);