superunits_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)
| Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1125 | 1125 | 1124 | {"type": "Polygon", "coordinates": [[[-117.31018, 33.69849], [-117.30588, 33.69858], [-117.30592, 33.70216], [-117.30153, 33.70223], [-117.30155, 33.69866], [-117.2974, 33.69872], [-117.29732, 33.68915], [-117.30424, 33.68905], [-117.3043, 33.69122], [-117.31014, 33.69113], [-117.31018, 33.69849]]]} | Unknown Access 4 | Alberhill Conservation Area, Expansion 1 | 15335 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 318.034 | Alberhill Conservation Area, Expansion 1 | ||
| 1431 | 1431 | 1430 | {"type": "MultiPolygon", "coordinates": [[[[-117.31639, 33.6953], [-117.31635, 33.69561], [-117.31633, 33.69569], [-117.3163, 33.69571], [-117.31632, 33.6955], [-117.3163, 33.69534], [-117.31595, 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.69668], [-117.31304, 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.31017, 33.70213], [-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.70347], [-117.30818, 33.70272], [-117.30938, 33.70245], [-117.31079, 33.7014], [-117.31122, 33.70029], [-117.31185, 33.7001], [-117.31177, 33.69849], [-117.31161, 33.69851], [-117.31168, 33.70001], [-117.31109, 33.70018], [-117.31064, 33.70131], [-117.3093, 33.70232], [-117.308, 33.70261], [-117.3081, 33.70329], [-117.30733, 33.70314], [-117.3056, 33.70454], [-117.30572, 33.70516], [-117.30515, 33.70516], [-117.30516, 33.70542], [-117.30443, 33.70565], [-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.31017, 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.68907], [-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.30627, 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.31862, 33.7203], [-117.31839, 33.72757], [-117.31126, 33.7276], [-117.31118, 33.72583], [-117.31162, 33.72582], [-117.31163, 33.7258], [-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.45899, 33.7524], [-117.45962, 33.75175], [-117.45961, 33.75163], [-117.46014, 33.75107], [-117.46029, 33.75106], [-117.46051, 33.75084], [-117.46072, 33.75067], [-117.46107, 33.75048], [-117.46108, 33.7505]]]]} | Unknown Access 4 | Alberhill Conservation Area | 15333 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 685.756 | Alberhill Conservation Area | ||
| 1432 | 1432 | 1431 | {"type": "Polygon", "coordinates": [[[-117.30415, 33.68905], [-117.29734, 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.29427, 33.69138], [-117.29456, 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.29715, 33.68644], [-117.29761, 33.68597], [-117.29777, 33.68545], [-117.29782, 33.68494], [-117.29802, 33.68467], [-117.29801, 33.68457], [-117.29769, 33.68419], [-117.30405, 33.6841], [-117.30415, 33.68905]]]} | Unknown Access 4 | Alberhill Conservation Area, Expansion 2 | 15336 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 109.586 | Alberhill Conservation Area, Expansion 2 | ||
| 4416 | 4416 | 4415 | {"type": "Polygon", "coordinates": [[[-117.09349, 33.56898], [-117.0926, 33.57066], [-117.08388, 33.57076], [-117.08394, 33.56909], [-117.09349, 33.56898]]]} | Unknown Access 4 | French Valley Conservation Area, Expansion 1 | 19108 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 38.847 | French Valley Conservation Area, Expansion 1 | ||
| 7459 | 7459 | 7458 | {"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.74032], [-117.31575, 33.74021], [-117.31534, 33.74022], [-117.31514, 33.74026], [-117.31496, 33.74044], [-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.31112, 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.74573], [-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.75506], [-117.31683, 33.75528], [-117.31663, 33.75573], [-117.31692, 33.75583], [-117.31693, 33.75672]]]]} | Unknown Access 4 | North Peak Preserve | 22845 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 193.09 | North Peak Preserve | ||
| 10463 | 10463 | 10462 | {"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.12773, 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.13231, 33.62711], [-117.13245, 33.6307], [-117.13679, 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.60657], [-117.17474, 33.60686], [-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.18323, 33.60716], [-117.1832, 33.60726], [-117.1832, 33.60735], [-117.18311, 33.60736], [-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.60797], [-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.60847], [-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.17799, 33.61052], [-117.1778, 33.61044], [-117.17762, 33.61045], [-117.17755, 33.6107], [-117.17747, 33.61075], [-117.17745, 33.61081], [-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.60687], [-117.1758, 33.60509], [-117.1804, 33.60509], [-117.1804, 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.18252, 33.60473], [-117.18361, 33.60473], [-117.18362, 33.60509], [-117.18493, 33.6051], [-117.18493, 33.60539], [-117.18499, 33.60556]], [[-117.17608, 33.61172], [-117.17615, 33.61118], [-117.17517, 33.61119], [-117.17513, 33.61172], [-117.17608, 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 | Triple Creeks Conservation Area | 26546 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 606.021 | Triple Creeks Conservation Area |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps(
id INT,
map,
ACCESS_TYP INT,
PARK_NAME TEXT,
PARK_URL TEXT,
SUID_NMA INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
ON [superunits_with_maps] ([ACCESS_TYP]);