units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1 and UNIT_NAME = "Santa Rosa Plateau Ecological Reserve"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY
MNG_AG_TYP 3
DES_TP 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 |
15587 | 15587 | 15586 | {"type": "Polygon", "coordinates": [[[-117.25406, 33.55451], [-117.25253, 33.56096], [-117.24683, 33.5616], [-117.24552, 33.56023], [-117.24566, 33.55849], [-117.24724, 33.55612], [-117.24602, 33.55264], [-117.24327, 33.55101], [-117.24324, 33.54786], [-117.24168, 33.54458], [-117.24149, 33.54456], [-117.24152, 33.54438], [-117.24157, 33.54416], [-117.24171, 33.54383], [-117.24191, 33.54353], [-117.24204, 33.54337], [-117.24225, 33.54317], [-117.2408, 33.54033], [-117.23339, 33.54632], [-117.22864, 33.54271], [-117.22887, 33.54253], [-117.22887, 33.54252], [-117.22643, 33.54067], [-117.22561, 33.54005], [-117.22537, 33.54023], [-117.2253, 33.54017], [-117.226, 33.53963], [-117.22419, 33.53825], [-117.22281, 33.53721], [-117.22209, 33.53775], [-117.21106, 33.52939], [-117.21102, 33.52829], [-117.21103, 33.52817], [-117.21106, 33.528], [-117.21112, 33.52783], [-117.2112, 33.52767], [-117.21131, 33.5275], [-117.21143, 33.52738], [-117.21158, 33.52724], [-117.21173, 33.52713], [-117.21191, 33.52704], [-117.21221, 33.52692], [-117.21278, 33.52679], [-117.213, 33.5267], [-117.21319, 33.52659], [-117.21335, 33.52648], [-117.2135, 33.52634], [-117.21363, 33.52619], [-117.21374, 33.52601], [-117.21385, 33.52572], [-117.21409, 33.52468], [-117.21437, 33.52406], [-117.21445, 33.52382], [-117.21448, 33.52363], [-117.21448, 33.52344], [-117.21445, 33.52325], [-117.21439, 33.52308], [-117.21866, 33.52143], [-117.22166, 33.51869], [-117.21882, 33.51411], [-117.21989, 33.51229], [-117.22153, 33.51238], [-117.22236, 33.50986], [-117.22285, 33.5099], [-117.22321, 33.50995], [-117.22368, 33.51004], [-117.22428, 33.51022], [-117.22491, 33.51048], [-117.22532, 33.5107], [-117.22566, 33.51092], [-117.22599, 33.51116], [-117.22692, 33.51191], [-117.22726, 33.51215], [-117.22766, 33.51238], [-117.22809, 33.5126], [-117.22861, 33.51281], [-117.22889, 33.51291], [-117.23077, 33.51346], [-117.23127, 33.51364], [-117.2316, 33.51379], [-117.23215, 33.51409], [-117.23256, 33.51437], [-117.23298, 33.51471], [-117.23341, 33.51513], [-117.2337, 33.51489], [-117.23662, 33.51215], [-117.23969, 33.51163], [-117.24188, 33.50703], [-117.24828, 33.50454], [-117.25383, 33.51734], [-117.25377, 33.5195], [-117.24323, 33.52422], [-117.24132, 33.52305], [-117.24029, 33.52069], [-117.23797, 33.5209], [-117.23768, 33.51976], [-117.23719, 33.51948], [-117.23606, 33.52001], [-117.23536, 33.51836], [-117.23254, 33.52021], [-117.2309, 33.51924], [-117.23011, 33.51651], [-117.22905, 33.51536], [-117.22688, 33.51494], [-117.22433, 33.51347], [-117.22264, 33.51402], [-117.2206, 33.51356], [-117.22059, 33.51357], [-117.22518, 33.51826], [-117.22448, 33.51937], [-117.22218, 33.51968], [-117.2206, 33.52139], [-117.22061, 33.5214], [-117.22413, 33.52116], [-117.224, 33.52437], [-117.22322, 33.52492], [-117.2242, 33.52581], [-117.22559, 33.5261], [-117.22588, 33.52645], [-117.22633, 33.52759], [-117.22621, 33.52965], [-117.22676, 33.53007], [-117.2286, 33.52873], [-117.23179, 33.5306], [-117.2308, 33.53201], [-117.23041, 33.53267], [-117.23223, 33.53295], [-117.23305, 33.53376], [-117.23405, 33.53327], [-117.23607, 33.53089], [-117.2367, 33.53318], [-117.23592, 33.53433], [-117.23733, 33.53479], [-117.23864, 33.53444], [-117.23992, 33.53463], [-117.23958, 33.53654], [-117.24223, 33.53693], [-117.25139, 33.55059], [-117.25406, 33.55451]]]} | Open Access 1 | 12823 | Santa Rosa Plateau Ecological Reserve | 9507 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/education/santa-rosa-plateau/santa-rosa-plateau/ | Riverside 10 | 1994.248 | Santa Rosa Plateau ER | 1994 | Local Conservation Area 4 | 2 |
15591 | 15591 | 15590 | {"type": "Polygon", "coordinates": [[[-117.30212, 33.52516], [-117.30028, 33.52911], [-117.29792, 33.53406], [-117.29703, 33.53775], [-117.29677, 33.53867], [-117.29553, 33.54139], [-117.29365, 33.54205], [-117.29295, 33.54294], [-117.28821, 33.54579], [-117.28777, 33.54435], [-117.28727, 33.54342], [-117.2852, 33.54184], [-117.28378, 33.54002], [-117.28221, 33.53975], [-117.27324, 33.54364], [-117.27138, 33.54321], [-117.2717, 33.54223], [-117.27183, 33.54172], [-117.27195, 33.54103], [-117.27201, 33.54033], [-117.27209, 33.53702], [-117.27206, 33.53615], [-117.27192, 33.53432], [-117.27192, 33.53403], [-117.27197, 33.53357], [-117.27205, 33.53314], [-117.27267, 33.53064], [-117.27278, 33.53023], [-117.27297, 33.52969], [-117.27346, 33.52855], [-117.27706, 33.52778], [-117.27748, 33.52772], [-117.27781, 33.5277], [-117.27813, 33.52771], [-117.27977, 33.52793], [-117.28008, 33.52795], [-117.28038, 33.52794], [-117.28039, 33.52793], [-117.2807, 33.5279], [-117.28101, 33.52785], [-117.28201, 33.5276], [-117.28234, 33.52753], [-117.28272, 33.52749], [-117.2831, 33.52748], [-117.28584, 33.5276], [-117.28614, 33.52763], [-117.28646, 33.52768], [-117.28692, 33.52781], [-117.28726, 33.52796], [-117.28882, 33.52881], [-117.28926, 33.529], [-117.28963, 33.5291], [-117.29, 33.52916], [-117.29044, 33.52918], [-117.29083, 33.52916], [-117.29109, 33.52913], [-117.29141, 33.52905], [-117.29181, 33.52892], [-117.29205, 33.52881], [-117.29233, 33.52865], [-117.29254, 33.5285], [-117.29273, 33.52834], [-117.29291, 33.52817], [-117.29315, 33.52786], [-117.2933, 33.52762], [-117.29422, 33.52577], [-117.29437, 33.5255], [-117.29462, 33.52513], [-117.29514, 33.52451], [-117.29576, 33.5249], [-117.296, 33.525], [-117.2964, 33.52509], [-117.29671, 33.5251], [-117.29697, 33.52508], [-117.29806, 33.52484], [-117.29827, 33.52483], [-117.29844, 33.52484], [-117.29873, 33.52491], [-117.29901, 33.52503], [-117.29924, 33.52519], [-117.29937, 33.52531], [-117.29972, 33.52575], [-117.29988, 33.52589], [-117.30011, 33.52601], [-117.30029, 33.52607], [-117.30048, 33.52609], [-117.30067, 33.5261], [-117.30082, 33.52608], [-117.30097, 33.52604], [-117.30117, 33.52596], [-117.30141, 33.52579], [-117.30185, 33.52533], [-117.30212, 33.52516]]]} | Open Access 1 | 12824 | Santa Rosa Plateau Ecological Reserve | 9398 | 2123 | Riverside County Regional Park and Open Space District 262 | Special District 4 | Recreation/Parks District 4 | http://www.riversidecountyparks.org/ | Special District 4 | 2123 | Riverside County Regional Park and Open Space District 258 | Special District 4 | Recreation/Parks District 4 | http://www.rivcoparks.org/education/santa-rosa-plateau/santa-rosa-plateau/ | Riverside 10 | 986.313 | Santa Rosa Plateau ER | 1994 | 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]);