units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where DES_TP = 8, MNG_AGENCY = 25, MNG_AG_TYP = 5 and UNIT_NAME = "Santa Rosa Plateau Ecological Reserve"
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- State Agency · 2 ✖
MNG_AGENCY 1
- California Department of Fish and Wildlife · 2 ✖
DES_TP 1
- State Conservation Area · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15581 | 15581 | 15580 | {"type": "MultiPolygon", "coordinates": [[[[-117.29312, 33.50408], [-117.29307, 33.50521], [-117.2931, 33.50555], [-117.29316, 33.50588], [-117.29536, 33.51376], [-117.29547, 33.51397], [-117.29552, 33.51415], [-117.29554, 33.51442], [-117.29521, 33.51755], [-117.2952, 33.51774], [-117.29529, 33.5184], [-117.29537, 33.51867], [-117.29548, 33.51893], [-117.29613, 33.52027], [-117.29632, 33.52073], [-117.2964, 33.52107], [-117.29644, 33.52146], [-117.29643, 33.5217], [-117.2964, 33.52197], [-117.29631, 33.52233], [-117.29624, 33.52253], [-117.29611, 33.52281], [-117.29584, 33.52322], [-117.29444, 33.52486], [-117.29418, 33.52521], [-117.29392, 33.52566], [-117.293, 33.52751], [-117.29281, 33.5278], [-117.29259, 33.52806], [-117.29235, 33.52827], [-117.29205, 33.52848], [-117.2917, 33.52866], [-117.29136, 33.52866], [-117.29052, 33.52891], [-117.29022, 33.5289], [-117.2899, 33.52887], [-117.28948, 33.52877], [-117.28908, 33.52862], [-117.28743, 33.52772], [-117.28706, 33.52756], [-117.2866, 33.52743], [-117.28636, 33.52738], [-117.286, 33.52734], [-117.28299, 33.52721], [-117.28258, 33.52722], [-117.28228, 33.52726], [-117.28192, 33.52733], [-117.28094, 33.52758], [-117.28066, 33.52763], [-117.28037, 33.52765], [-117.28036, 33.52764], [-117.28009, 33.52765], [-117.2798, 33.52763], [-117.27817, 33.52741], [-117.2778, 33.5274], [-117.27732, 33.52743], [-117.27697, 33.52749], [-117.27324, 33.52829], [-117.27318, 33.52835], [-117.27263, 33.52959], [-117.27243, 33.53016], [-117.27231, 33.53058], [-117.2717, 33.53308], [-117.27161, 33.53353], [-117.27157, 33.53383], [-117.27156, 33.53432], [-117.2717, 33.53617], [-117.27173, 33.53702], [-117.27165, 33.54032], [-117.27161, 33.54083], [-117.27151, 33.5415], [-117.27139, 33.542], [-117.27124, 33.5425], [-117.26835, 33.54184], [-117.26868, 33.54483], [-117.27035, 33.54522], [-117.26953, 33.54772], [-117.26932, 33.54829], [-117.26907, 33.54904], [-117.26901, 33.5493], [-117.26881, 33.5502], [-117.26851, 33.55262], [-117.26844, 33.55299], [-117.26835, 33.55328], [-117.26823, 33.55356], [-117.2681, 33.55384], [-117.26608, 33.55736], [-117.26591, 33.55762], [-117.26572, 33.55787], [-117.26551, 33.55811], [-117.26451, 33.55909], [-117.26427, 33.55936], [-117.26408, 33.55934], [-117.26402, 33.55972], [-117.26384, 33.56006], [-117.26371, 33.56037], [-117.26362, 33.56066], [-117.26357, 33.56094], [-117.26353, 33.56126], [-117.26353, 33.56152], [-117.26356, 33.56185], [-117.26362, 33.56213], [-117.26288, 33.56667], [-117.25985, 33.56821], [-117.2562, 33.56808], [-117.25485, 33.55451], [-117.25406, 33.55451], [-117.25139, 33.55059], [-117.24223, 33.53693], [-117.23958, 33.53654], [-117.23991, 33.53463], [-117.23864, 33.53444], [-117.23733, 33.53479], [-117.23591, 33.53433], [-117.2367, 33.53318], [-117.23607, 33.5309], [-117.23405, 33.53327], [-117.23304, 33.53377], [-117.23223, 33.53295], [-117.2304, 33.53267], [-117.2308, 33.53201], [-117.23179, 33.53061], [-117.23178, 33.53059], [-117.2286, 33.52874], [-117.22677, 33.53007], [-117.22621, 33.52966], [-117.22633, 33.52759], [-117.22588, 33.52645], [-117.22559, 33.5261], [-117.2242, 33.52581], [-117.22321, 33.52492], [-117.224, 33.52437], [-117.22413, 33.52116], [-117.22059, 33.5214], [-117.22219, 33.51968], [-117.22448, 33.51937], [-117.22518, 33.51826], [-117.22114, 33.51413], [-117.22072, 33.51365], [-117.22134, 33.51373], [-117.22264, 33.51402], [-117.22433, 33.51347], [-117.22688, 33.51494], [-117.22906, 33.51536], [-117.23011, 33.51652], [-117.2309, 33.51925], [-117.23255, 33.52021], [-117.23536, 33.51836], [-117.23606, 33.52], [-117.23719, 33.51948], [-117.23768, 33.51976], [-117.23797, 33.5209], [-117.24029, 33.52068], [-117.24132, 33.52305], [-117.24323, 33.52422], [-117.25377, 33.5195], [-117.25383, 33.51733], [-117.24828, 33.50454], [-117.24932, 33.50413], [-117.25358, 33.50389], [-117.25435, 33.50148], [-117.25638, 33.50026], [-117.25852, 33.50429], [-117.2655, 33.50652], [-117.2702, 33.5057], [-117.27186, 33.50667], [-117.27974, 33.50322], [-117.28244, 33.50308], [-117.28429, 33.50088], [-117.2858, 33.50203], [-117.28838, 33.50252], [-117.29051, 33.50126], [-117.29065, 33.50448], [-117.29247, 33.50414], [-117.29281, 33.50409], [-117.29312, 33.50408]]], [[[-117.29902, 33.51487], [-117.29882, 33.51725], [-117.2956, 33.51705], [-117.29588, 33.51462], [-117.29902, 33.51487]]]]} | Open Access 1 | 11581 | Santa Rosa Plateau Ecological Reserve | 32302 | 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/Santa-Rosa-Plateau-ER | Riverside 10 | 5375.386 | Santa Rosa Plateau ER | 1994 | State Conservation Area 8 | 2 |
15620 | 15620 | 15619 | {"type": "MultiPolygon", "coordinates": [[[[-117.29691, 33.50922], [-117.29443, 33.50925], [-117.29366, 33.50656], [-117.29686, 33.50664], [-117.29691, 33.50922]]], [[[-117.30422, 33.51102], [-117.30312, 33.51228], [-117.30368, 33.51239], [-117.303, 33.51312], [-117.30271, 33.51322], [-117.30252, 33.51335], [-117.30249, 33.5134], [-117.30241, 33.51367], [-117.30233, 33.51377], [-117.30222, 33.51386], [-117.30211, 33.51393], [-117.30192, 33.51401], [-117.30179, 33.5141], [-117.30168, 33.51422], [-117.30163, 33.51432], [-117.30151, 33.51438], [-117.3001, 33.51427], [-117.3002, 33.51413], [-117.30163, 33.51258], [-117.30174, 33.51242], [-117.30178, 33.51231], [-117.3018, 33.51212], [-117.30169, 33.51097], [-117.30171, 33.51072], [-117.30173, 33.51061], [-117.30179, 33.51047], [-117.30185, 33.51044], [-117.30196, 33.51045], [-117.30211, 33.51043], [-117.30222, 33.5104], [-117.30241, 33.51031], [-117.3026, 33.51027], [-117.30273, 33.51026], [-117.30292, 33.51029], [-117.30304, 33.51033], [-117.30396, 33.51075], [-117.30411, 33.51086], [-117.30422, 33.51102]]], [[[-117.30682, 33.48342], [-117.30671, 33.48384], [-117.30668, 33.4842], [-117.3067, 33.48445], [-117.30681, 33.48526], [-117.30682, 33.48547], [-117.30678, 33.48578], [-117.30672, 33.48598], [-117.30664, 33.48618], [-117.30653, 33.48637], [-117.3064, 33.48655], [-117.30459, 33.48881], [-117.30434, 33.48908], [-117.30405, 33.48934], [-117.30282, 33.48822], [-117.30539, 33.48498], [-117.30585, 33.48446], [-117.30682, 33.48342]]], [[[-117.31602, 33.50967], [-117.31583, 33.51591], [-117.31468, 33.51586], [-117.3134, 33.51573], [-117.31277, 33.51564], [-117.30935, 33.51506], [-117.3095, 33.51398], [-117.31151, 33.51178], [-117.31074, 33.51132], [-117.30996, 33.51076], [-117.30875, 33.51199], [-117.30459, 33.5112], [-117.30457, 33.51113], [-117.30441, 33.51095], [-117.30433, 33.51084], [-117.30415, 33.51066], [-117.30657, 33.51076], [-117.30871, 33.50862], [-117.3119, 33.50877], [-117.31204, 33.50873], [-117.31335, 33.50519], [-117.31602, 33.50967]]], [[[-117.32402, 33.49267], [-117.32243, 33.49476], [-117.31894, 33.49287], [-117.31878, 33.49351], [-117.31866, 33.49348], [-117.31854, 33.4935], [-117.31846, 33.49356], [-117.31848, 33.49368], [-117.31856, 33.49373], [-117.31596, 33.49402], [-117.3132, 33.49064], [-117.3083, 33.49327], [-117.3042, 33.48946], [-117.30492, 33.4887], [-117.30523, 33.48833], [-117.30608, 33.48721], [-117.30659, 33.48659], [-117.30682, 33.48629], [-117.30689, 33.4861], [-117.30698, 33.4859], [-117.30934, 33.48625], [-117.30964, 33.48626], [-117.30978, 33.48625], [-117.30998, 33.4863], [-117.3101, 33.48625], [-117.31019, 33.48617], [-117.31013, 33.48608], [-117.31001, 33.48605], [-117.3099, 33.48608], [-117.30963, 33.48613], [-117.30929, 33.48608], [-117.30709, 33.48574], [-117.30703, 33.48566], [-117.30705, 33.48544], [-117.30698, 33.48461], [-117.30697, 33.48376], [-117.30721, 33.48315], [-117.30742, 33.48289], [-117.30759, 33.48275], [-117.31294, 33.48675], [-117.31524, 33.48853], [-117.31715, 33.4866], [-117.31719, 33.48657], [-117.32346, 33.49117], [-117.32288, 33.4918], [-117.32402, 33.49267]]], [[[-117.33472, 33.4949], [-117.33416, 33.49536], [-117.33374, 33.49581], [-117.33365, 33.49597], [-117.33356, 33.49623], [-117.33351, 33.49662], [-117.32591, 33.49765], [-117.32575, 33.49765], [-117.32222, 33.49646], [-117.32227, 33.49633], [-117.32248, 33.49528], [-117.32262, 33.49499], [-117.32333, 33.49408], [-117.32339, 33.49407], [-117.32407, 33.4944], [-117.32433, 33.49449], [-117.32521, 33.49472], [-117.32551, 33.49484], [-117.32559, 33.49484], [-117.32566, 33.49478], [-117.32569, 33.4947], [-117.32567, 33.49465], [-117.3256, 33.49459], [-117.32553, 33.49457], [-117.32528, 33.49456], [-117.32427, 33.4943], [-117.32404, 33.49421], [-117.32356, 33.49396], [-117.32348, 33.49387], [-117.32452, 33.49255], [-117.32476, 33.49229], [-117.32496, 33.49214], [-117.32529, 33.49197], [-117.32566, 33.49186], [-117.32592, 33.49182], [-117.32632, 33.49183], [-117.33029, 33.49216], [-117.33068, 33.49221], [-117.33101, 33.49229], [-117.33155, 33.49246], [-117.3319, 33.49263], [-117.33222, 33.49282], [-117.33304, 33.49347], [-117.33472, 33.4949]]], [[[-117.33364, 33.50621], [-117.333, 33.507], [-117.33283, 33.50726], [-117.33255, 33.50758], [-117.32478, 33.50323], [-117.32545, 33.50184], [-117.3255, 33.50169], [-117.33364, 33.50621]]], [[[-117.33772, 33.50251], [-117.33705, 33.50292], [-117.33622, 33.50346], [-117.33563, 33.50294], [-117.33546, 33.50276], [-117.33527, 33.50254], [-117.33508, 33.50225], [-117.33488, 33.50192], [-117.33455, 33.50105], [-117.33423, 33.49964], [-117.33642, 33.49965], [-117.33636, 33.5007], [-117.33772, 33.50251]]], [[[-117.34065, 33.50668], [-117.33987, 33.50717], [-117.33667, 33.50408], [-117.33722, 33.50368], [-117.33762, 33.50343], [-117.33864, 33.50448], [-117.33868, 33.50464], [-117.33873, 33.50472], [-117.33897, 33.50474], [-117.33904, 33.50461], [-117.339, 33.50449], [-117.33886, 33.50441], [-117.33876, 33.50431], [-117.33784, 33.5033], [-117.33866, 33.50282], [-117.33894, 33.50274], [-117.3393, 33.50256], [-117.33949, 33.50245], [-117.33994, 33.50227], [-117.34, 33.50231], [-117.34064, 33.50368], [-117.34055, 33.50372], [-117.33997, 33.50393], [-117.33957, 33.50403], [-117.33949, 33.50414], [-117.33953, 33.50427], [-117.34065, 33.50668]]], [[[-117.34556, 33.50156], [-117.34541, 33.50193], [-117.34536, 33.50228], [-117.34543, 33.50264], [-117.34549, 33.50274], [-117.34158, 33.50425], [-117.34161, 33.50612], [-117.34156, 33.50612], [-117.34147, 33.50618], [-117.34137, 33.50627], [-117.34097, 33.50656], [-117.34081, 33.50656], [-117.34065, 33.50616], [-117.34054, 33.50594], [-117.33978, 33.50417], [-117.33992, 33.50413], [-117.34053, 33.50391], [-117.3408, 33.50389], [-117.34089, 33.50378], [-117.34091, 33.50366], [-117.34086, 33.50358], [-117.34078, 33.5035], [-117.34028, 33.50237], [-117.34027, 33.50217], [-117.34045, 33.50212], [-117.34072, 33.502], [-117.3412, 33.50186], [-117.34155, 33.50179], [-117.34317, 33.50141], [-117.3437, 33.50133], [-117.34452, 33.50133], [-117.34498, 33.5014], [-117.34541, 33.50151], [-117.34556, 33.50156]]], [[[-117.35154, 33.50447], [-117.35082, 33.5055], [-117.35061, 33.50561], [-117.35037, 33.50566], [-117.35013, 33.50565], [-117.34987, 33.50557], [-117.34969, 33.50541], [-117.34955, 33.50519], [-117.34907, 33.50416], [-117.34886, 33.50397], [-117.3487, 33.50387], [-117.34843, 33.50384], [-117.34765, 33.50384], [-117.34745, 33.5038], [-117.3473, 33.50371], [-117.34719, 33.50359], [-117.34705, 33.50346], [-117.34683, 33.50335], [-117.34629, 33.50317], [-117.34601, 33.50304], [-117.34582, 33.50292], [-117.34566, 33.50272], [-117.34556, 33.50248], [-117.34554, 33.50222], [-117.34562, 33.50191], [-117.34577, 33.50162], [-117.34619, 33.50181], [-117.34652, 33.50192], [-117.3472, 33.50231], [-117.34796, 33.50266], [-117.34952, 33.50347], [-117.35029, 33.50381], [-117.35154, 33.50447]]], [[[-117.35429, 33.50591], [-117.35306, 33.50668], [-117.35206, 33.5065], [-117.35204, 33.50638], [-117.35195, 33.5063], [-117.35178, 33.50624], [-117.35106, 33.50551], [-117.35172, 33.50458], [-117.35251, 33.50497], [-117.35429, 33.50591]]], [[[-117.36579, 33.50162], [-117.36439, 33.50466], [-117.3635, 33.50465], [-117.3628, 33.50619], [-117.36176, 33.5088], [-117.35747, 33.5067], [-117.35318, 33.50452], [-117.35375, 33.50444], [-117.35434, 33.50422], [-117.35495, 33.50386], [-117.35539, 33.50351], [-117.35578, 33.50295], [-117.35602, 33.50239], [-117.35604, 33.50175], [-117.35596, 33.50113], [-117.35591, 33.5005], [-117.35585, 33.49994], [-117.35989, 33.49968], [-117.36579, 33.50162]]]]} | Restricted Access 2 | 47975 | Santa Rosa Plateau Ecological Reserve | 25137 | 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 | Riverside 10 | 905.397 | Santa Rosa Plateau ER | 1994 | 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]);