units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where GAP_STS = 2, MNG_AGENCY = 165 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5589 | 5589 | 5588 | {"type": "MultiPolygon", "coordinates": [[[[-117.31639, 33.6953], [-117.31635, 33.69561], [-117.31633, 33.69569], [-117.3163, 33.69571], [-117.31632, 33.6955], [-117.31631, 33.69534], [-117.31594, 33.69537], [-117.31592, 33.69538], [-117.31574, 33.69537], [-117.31571, 33.69539], [-117.31553, 33.69534], [-117.3153, 33.6952], [-117.31512, 33.69522], [-117.31503, 33.69526], [-117.31476, 33.69552], [-117.31443, 33.69569], [-117.31383, 33.6958], [-117.31368, 33.69593], [-117.31364, 33.69608], [-117.31361, 33.69625], [-117.31355, 33.6964], [-117.31344, 33.69654], [-117.31328, 33.69667], [-117.31326, 33.69671], [-117.31313, 33.69667], [-117.31303, 33.69689], [-117.31324, 33.69696], [-117.31297, 33.69761], [-117.31285, 33.69777], [-117.31286, 33.69781], [-117.31274, 33.69796], [-117.31275, 33.69801], [-117.31267, 33.6982], [-117.31269, 33.69825], [-117.31261, 33.69844], [-117.31263, 33.69849], [-117.31232, 33.6985], [-117.31228, 33.69878], [-117.31228, 33.69934], [-117.31217, 33.69939], [-117.3121, 33.69984], [-117.31209, 33.70031], [-117.31159, 33.70037], [-117.31143, 33.70065], [-117.31153, 33.70092], [-117.31154, 33.7013], [-117.31183, 33.70143], [-117.31253, 33.70148], [-117.31263, 33.70165], [-117.31269, 33.70186], [-117.31269, 33.70201], [-117.31283, 33.70211], [-117.31016, 33.70212], [-117.31015, 33.70437], [-117.30948, 33.70421], [-117.30905, 33.70422], [-117.30873, 33.70414], [-117.30802, 33.70393], [-117.30754, 33.70366], [-117.30723, 33.70357], [-117.30706, 33.70356], [-117.30739, 33.70329], [-117.3083, 33.70348], [-117.30818, 33.70272], [-117.30938, 33.70245], [-117.31079, 33.7014], [-117.31122, 33.70029], [-117.31185, 33.70011], [-117.31177, 33.69849], [-117.31161, 33.6985], [-117.31168, 33.70001], [-117.31109, 33.70018], [-117.31064, 33.70131], [-117.3093, 33.70232], [-117.30799, 33.70262], [-117.3081, 33.70329], [-117.30734, 33.70313], [-117.3056, 33.70454], [-117.30572, 33.70516], [-117.30514, 33.70516], [-117.30516, 33.70542], [-117.30442, 33.70566], [-117.30445, 33.70582], [-117.3015, 33.70585], [-117.30154, 33.70315], [-117.30153, 33.70223], [-117.30591, 33.70216], [-117.30588, 33.69857], [-117.31018, 33.69849], [-117.31016, 33.69487], [-117.31638, 33.69484], [-117.31639, 33.6953]]], [[[-117.31014, 33.69113], [-117.30429, 33.69122], [-117.30424, 33.68906], [-117.30415, 33.68905], [-117.30405, 33.6841], [-117.3101, 33.68401], [-117.31014, 33.69113]]], [[[-117.30638, 33.70411], [-117.30631, 33.70476], [-117.30632, 33.7049], [-117.30628, 33.70497], [-117.30595, 33.70515], [-117.30589, 33.70515], [-117.30578, 33.70459], [-117.30638, 33.70411]]], [[[-117.32739, 33.71393], [-117.32716, 33.72027], [-117.31861, 33.7203], [-117.31839, 33.72757], [-117.31126, 33.7276], [-117.31118, 33.72583], [-117.31162, 33.72582], [-117.31163, 33.72581], [-117.31115, 33.725], [-117.31105, 33.72502], [-117.31013, 33.72438], [-117.30997, 33.72377], [-117.31012, 33.71407], [-117.3188, 33.71403], [-117.32739, 33.71393]]], [[[-117.36159, 33.71668], [-117.35971, 33.71664], [-117.35975, 33.7135], [-117.36052, 33.71444], [-117.36112, 33.71589], [-117.36129, 33.71621], [-117.36152, 33.71654], [-117.36159, 33.71668]]], [[[-117.45455, 33.74791], [-117.45432, 33.74847], [-117.45404, 33.74872], [-117.45382, 33.74846], [-117.45382, 33.74819], [-117.45451, 33.74787], [-117.45455, 33.74791]]], [[[-117.46108, 33.7505], [-117.46077, 33.75067], [-117.46048, 33.7509], [-117.45889, 33.75254], [-117.45869, 33.75269], [-117.45844, 33.75282], [-117.45841, 33.75283], [-117.4583, 33.75281], [-117.45827, 33.75277], [-117.45859, 33.75261], [-117.45884, 33.75242], [-117.45898, 33.75241], [-117.45962, 33.75175], [-117.45961, 33.75163], [-117.46014, 33.75107], [-117.46029, 33.75106], [-117.46051, 33.75083], [-117.46072, 33.75067], [-117.46107, 33.75048], [-117.46108, 33.7505]]]]} | Unknown Access 4 | 14103 | Alberhill Conservation Area | 15333 | 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 | Riverside 10 | 685.557 | Alberhill Conservation Area | 0 | Local Conservation Area 4 | 2 | |
| 6298 | 6298 | 6297 | {"type": "MultiPolygon", "coordinates": [[[[-117.35822, 33.80178], [-117.35821, 33.80646], [-117.35818, 33.8076], [-117.35807, 33.80825], [-117.35787, 33.80896], [-117.35779, 33.8093], [-117.35773, 33.80975], [-117.35771, 33.81021], [-117.35791, 33.81283], [-117.3581, 33.81404], [-117.35812, 33.81452], [-117.34499, 33.8145], [-117.34509, 33.80721], [-117.34514, 33.79991], [-117.35388, 33.79993], [-117.35386, 33.80178], [-117.35822, 33.80178]]], [[[-117.36258, 33.8088], [-117.36255, 33.81453], [-117.35849, 33.81452], [-117.35846, 33.81401], [-117.35827, 33.8128], [-117.35807, 33.81031], [-117.35807, 33.80999], [-117.35811, 33.80956], [-117.35817, 33.80924], [-117.35828, 33.80883], [-117.36258, 33.8088]]]]} | Open Access 1 | 1420 | Harford Springs Reserve | 9495 | 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/?s=Harford+Springs+Reserve | Riverside 10 | 523.302 | Harford Springs Reserve | 0 | Local Conservation Area 4 | 2 |
| 8096 | 8096 | 8095 | {"type": "MultiPolygon", "coordinates": [[[[-117.1101, 33.63438], [-117.10578, 33.63443], [-117.10578, 33.63085], [-117.11002, 33.63089], [-117.1101, 33.63438]]], [[[-117.14335, 33.6307], [-117.14334, 33.63428], [-117.13682, 33.63432], [-117.12331, 33.63432], [-117.12328, 33.62709], [-117.12774, 33.62709], [-117.12773, 33.6253], [-117.13201, 33.62537], [-117.13196, 33.62358], [-117.13678, 33.62359], [-117.1368, 33.62711], [-117.14106, 33.62711], [-117.14101, 33.63071], [-117.14335, 33.6307]], [[-117.1368, 33.62892], [-117.13679, 33.62712], [-117.1323, 33.6271], [-117.13244, 33.6307], [-117.1368, 33.6307], [-117.1368, 33.62892]]], [[[-117.17557, 33.6052], [-117.17555, 33.60545], [-117.17549, 33.60567], [-117.17542, 33.60583], [-117.17531, 33.60603], [-117.17514, 33.60627], [-117.17498, 33.60645], [-117.17482, 33.60656], [-117.17474, 33.60687], [-117.17478, 33.60688], [-117.17458, 33.6074], [-117.17448, 33.60762], [-117.17443, 33.60768], [-117.17426, 33.60784], [-117.17285, 33.60876], [-117.17273, 33.60885], [-117.17261, 33.609], [-117.17252, 33.60922], [-117.17248, 33.60964], [-117.17239, 33.6123], [-117.17157, 33.61232], [-117.17175, 33.60688], [-117.17185, 33.6052], [-117.17557, 33.6052]]], [[[-117.18499, 33.60556], [-117.18491, 33.6057], [-117.18461, 33.60563], [-117.18433, 33.60581], [-117.1842, 33.60612], [-117.18415, 33.60618], [-117.1841, 33.60639], [-117.18399, 33.60653], [-117.18375, 33.60674], [-117.18341, 33.60694], [-117.18334, 33.607], [-117.18326, 33.60709], [-117.18322, 33.60716], [-117.1832, 33.60726], [-117.1832, 33.60735], [-117.18311, 33.60735], [-117.18293, 33.60756], [-117.18287, 33.60758], [-117.18277, 33.60769], [-117.18272, 33.60771], [-117.18263, 33.60781], [-117.18257, 33.60783], [-117.18247, 33.60795], [-117.18241, 33.60796], [-117.1823, 33.60809], [-117.18226, 33.60811], [-117.18214, 33.60825], [-117.18211, 33.60827], [-117.18203, 33.6084], [-117.18232, 33.60857], [-117.1823, 33.60861], [-117.18196, 33.60846], [-117.18187, 33.60863], [-117.18179, 33.60881], [-117.18174, 33.60898], [-117.18169, 33.60936], [-117.18143, 33.6094], [-117.18119, 33.60947], [-117.18086, 33.60962], [-117.18057, 33.60978], [-117.1803, 33.60997], [-117.18006, 33.61018], [-117.17985, 33.61042], [-117.17969, 33.61063], [-117.17936, 33.61055], [-117.17798, 33.61052], [-117.1778, 33.61044], [-117.17762, 33.61044], [-117.17755, 33.6107], [-117.17747, 33.61075], [-117.17745, 33.61081], [-117.17729, 33.61104], [-117.17719, 33.61116], [-117.17722, 33.61136], [-117.17717, 33.61148], [-117.17717, 33.61174], [-117.17713, 33.61181], [-117.17714, 33.61187], [-117.17717, 33.61191], [-117.17715, 33.61194], [-117.17715, 33.61229], [-117.17257, 33.6123], [-117.17267, 33.60987], [-117.17271, 33.60933], [-117.17278, 33.60911], [-117.17287, 33.60896], [-117.17297, 33.60887], [-117.17444, 33.6079], [-117.17454, 33.60782], [-117.17464, 33.60769], [-117.17483, 33.60732], [-117.17499, 33.60688], [-117.17561, 33.60688], [-117.1758, 33.60509], [-117.18041, 33.60509], [-117.18041, 33.605], [-117.17934, 33.605], [-117.17929, 33.60497], [-117.17935, 33.60327], [-117.1819, 33.60327], [-117.18203, 33.60324], [-117.18251, 33.60323], [-117.18251, 33.60473], [-117.18361, 33.60473], [-117.18362, 33.60509], [-117.18493, 33.6051], [-117.18493, 33.60539], [-117.18499, 33.60556]], [[-117.17609, 33.61172], [-117.17615, 33.61117], [-117.17517, 33.61118], [-117.17512, 33.61172], [-117.17609, 33.61172]]], [[[-117.17919, 33.60327], [-117.17913, 33.60499], [-117.17906, 33.60501], [-117.17582, 33.60501], [-117.17578, 33.60497], [-117.1758, 33.60455], [-117.17581, 33.6034], [-117.17586, 33.60335], [-117.17663, 33.60335], [-117.17677, 33.60337], [-117.1769, 33.60343], [-117.17699, 33.60345], [-117.17706, 33.60343], [-117.17711, 33.60339], [-117.17714, 33.60333], [-117.17713, 33.60327], [-117.17919, 33.60327]]]]} | Unknown Access 4 | 12134 | Triple Creeks Conservation Area | 26546 | 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 | Riverside 10 | 605.784 | Triple Creeks Conservation Area | 0 | Local Conservation Area 4 | 2 | |
| 8099 | 8099 | 8098 | {"type": "MultiPolygon", "coordinates": [[[[-117.3176, 33.73889], [-117.31758, 33.73902], [-117.31747, 33.73927], [-117.31747, 33.73948], [-117.31751, 33.73969], [-117.31747, 33.74002], [-117.31721, 33.74052], [-117.31696, 33.74085], [-117.31673, 33.74099], [-117.31643, 33.74097], [-117.3163, 33.74056], [-117.31613, 33.74033], [-117.31575, 33.74021], [-117.31534, 33.74022], [-117.31514, 33.74026], [-117.31496, 33.74045], [-117.31491, 33.74076], [-117.31494, 33.74106], [-117.3152, 33.74142], [-117.31518, 33.74158], [-117.31022, 33.74163], [-117.31021, 33.7349], [-117.31004, 33.7308], [-117.31109, 33.73079], [-117.31111, 33.73124], [-117.31218, 33.73123], [-117.31232, 33.73491], [-117.31235, 33.73673], [-117.31448, 33.73673], [-117.31453, 33.73853], [-117.31669, 33.73852], [-117.31731, 33.73871], [-117.31749, 33.7388], [-117.3176, 33.73889]]], [[[-117.31506, 33.74212], [-117.31498, 33.74281], [-117.31466, 33.74341], [-117.31466, 33.74368], [-117.31472, 33.74395], [-117.31467, 33.74408], [-117.31471, 33.74421], [-117.31481, 33.74432], [-117.3148, 33.7446], [-117.31458, 33.7448], [-117.31425, 33.74484], [-117.31339, 33.74521], [-117.31311, 33.74535], [-117.31288, 33.74572], [-117.31285, 33.74613], [-117.31302, 33.74649], [-117.31324, 33.7467], [-117.3137, 33.74691], [-117.31383, 33.74731], [-117.3138, 33.74753], [-117.31367, 33.74757], [-117.3136, 33.74783], [-117.31372, 33.74837], [-117.314, 33.74886], [-117.31422, 33.74919], [-117.3142, 33.74942], [-117.31032, 33.74949], [-117.31022, 33.74218], [-117.31506, 33.74212]]], [[[-117.31693, 33.75672], [-117.31471, 33.75675], [-117.31464, 33.75079], [-117.31488, 33.75098], [-117.31518, 33.7513], [-117.31552, 33.75149], [-117.31597, 33.75207], [-117.3161, 33.75232], [-117.31615, 33.75314], [-117.31607, 33.75341], [-117.31611, 33.75354], [-117.31621, 33.7538], [-117.31624, 33.75394], [-117.3165, 33.75429], [-117.3166, 33.75455], [-117.31673, 33.7548], [-117.31682, 33.75507], [-117.31683, 33.75528], [-117.31663, 33.75573], [-117.31692, 33.75583], [-117.31693, 33.75672]]]]} | Unknown Access 4 | 12135 | North Peak Preserve | 22845 | 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 | Riverside 10 | 193.051 | North Peak Preserve | 0 | Local Conservation Area 4 | 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 |
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]);