units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 4 and MNG_AGENCY = 165
This data as json, copyable, CSV (advanced)
DES_TP 3
- Local Conservation Area 2
- None 1
- None 1
MNG_AG_TYP 1
MNG_AGENCY 1
- Riverside, County of · 4 ✖
ACCESS_TYP 1
- Unknown Access · 4 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
8101 | 8101 | 8100 | {"type": "Polygon", "coordinates": [[[-117.31018, 33.69849], [-117.30588, 33.69858], [-117.30592, 33.70216], [-117.30153, 33.70223], [-117.30156, 33.69865], [-117.2974, 33.69872], [-117.29732, 33.68915], [-117.30424, 33.68905], [-117.30429, 33.69122], [-117.31014, 33.69113], [-117.31018, 33.69849]]]} | Unknown Access 4 | 12138 | Alberhill Conservation Area, Expansion 1 | 15335 | 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 | 317.959 | Alberhill Conservation Area, Expansion 1 | None 674 | |||
8102 | 8102 | 8101 | {"type": "Polygon", "coordinates": [[[-117.30415, 33.68905], [-117.29733, 33.68915], [-117.29734, 33.69144], [-117.29287, 33.69151], [-117.29287, 33.69102], [-117.29327, 33.69128], [-117.29388, 33.69128], [-117.29399, 33.69136], [-117.29428, 33.69138], [-117.29457, 33.69129], [-117.29451, 33.69066], [-117.29452, 33.69039], [-117.29447, 33.69031], [-117.2946, 33.69005], [-117.29429, 33.68946], [-117.2946, 33.68922], [-117.29464, 33.68853], [-117.29508, 33.68828], [-117.29535, 33.68806], [-117.29568, 33.68802], [-117.29627, 33.6878], [-117.29667, 33.688], [-117.29688, 33.68832], [-117.29685, 33.68857], [-117.29726, 33.68882], [-117.29762, 33.68881], [-117.29775, 33.68866], [-117.29759, 33.68829], [-117.29711, 33.68815], [-117.29686, 33.68785], [-117.2964, 33.68762], [-117.29645, 33.68722], [-117.29662, 33.687], [-117.29678, 33.68667], [-117.29714, 33.68644], [-117.29761, 33.68597], [-117.29777, 33.68545], [-117.29782, 33.68494], [-117.29802, 33.68468], [-117.29801, 33.68457], [-117.29769, 33.68419], [-117.30405, 33.6841], [-117.30415, 33.68905]]]} | Unknown Access 4 | 12139 | Alberhill Conservation Area, Expansion 2 | 15336 | 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 | 109.553 | Alberhill Conservation Area, Expansion 2 | None 675 |
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]);