pg解析json

json文本：

{"alarmnames":["A1","J3"],"signames":["台风白色","森林火险黄色"],"data":{"A":[{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"三元里街","qxcode":"Q11002","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"石井街","qxcode":"Q11014","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"石门街","qxcode":"Q11019","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"松洲街","qxcode":"Q11003","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"太和镇","qxcode":"Q11107","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"棠景街","qxcode":"Q11007","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"同德街","qxcode":"Q11005","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"同和街","qxcode":"Q11009","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"新市街","qxcode":"Q11008","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"永平街","qxcode":"Q11011","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"云城街","qxcode":"Q11016","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"钟落潭镇","qxcode":"Q11108","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","qxcode":"Q00000","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"大龙街","qxcode":"Q13016","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"大石镇","qxcode":"Q13012","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"东环街","qxcode":"Q13009","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"化龙镇","qxcode":"Q13104","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"洛浦街","qxcode":"Q13013","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"南村镇","qxcode":"Q13102","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"桥南街","qxcode":"Q13010","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"沙头街","qxcode":"Q13008","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"沙湾镇","qxcode":"Q13118","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"石壁街","qxcode":"Q13014","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"石碁镇","qxcode":"Q13120","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"石楼镇","qxcode":"Q13105","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"市桥街","qxcode":"Q13007","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"小谷围街","qxcode":"Q13011","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"新造镇","qxcode":"Q13103","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","town":"钟村街","qxcode":"Q13015","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 08:56","country":"番禺区","qxcode":"Q00000","bbcc":"GDPY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 12:44","country":"海珠区","qxcode":"Q00000","bbcc":"GDHH","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"长岭街道","qxcode":"Q12016","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"长洲街道","qxcode":"Q12010","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"大沙街道","qxcode":"Q12005","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"红山街道","qxcode":"Q12002","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"黄埔街道","qxcode":"Q12001","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"九佛街道","qxcode":"Q12017","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"白云湖街","qxcode":"Q11018","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"鹤龙街","qxcode":"Q11017","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"黄石街","qxcode":"Q11006","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"嘉禾街","qxcode":"Q11012","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"江高镇","qxcode":"Q11113","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"金沙街","qxcode":"Q11015","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"京溪街","qxcode":"Q11010","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"景泰街","qxcode":"Q11004","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"均禾街","qxcode":"Q11013","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:49","country":"白云区","town":"人和镇","qxcode":"Q11103","bbcc":"GDBY","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"联和街道","qxcode":"Q12014","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"龙湖街道","qxcode":"Q12018","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"萝岗街道","qxcode":"Q12012","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"南岗街道","qxcode":"Q12008","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"穗东街道","qxcode":"Q12007","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"文冲街道","qxcode":"Q12006","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"夏港街道","qxcode":"Q12011","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"新龙镇","qxcode":"Q12101","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"永和街道","qxcode":"Q12015","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"鱼珠街道","qxcode":"Q12003","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","town":"云埔街道","qxcode":"Q12013","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 13:00","country":"黄埔区","qxcode":"Q00000","bbcc":"GDHU","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 12:55","country":"荔湾区","qxcode":"Q00000","bbcc":"GDLW","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:27","country":"南沙区","town":"大岗镇","qxcode":"Q15104","bbcc":"GDNS","signame":"A","signame_cn":"台风","signcolor":"2","signcolor_cn":"蓝色","color":"#0C0EEC","sig":"A2"},{"ddatetime":"2020-10-12 17:27","country":"南沙区","town":"东涌镇","qxcode":"Q15103","bbcc":"GDNS","signame":"A","signame_cn":"台风","signcolor":"2","signcolor_cn":"蓝色","color":"#0C0EEC","sig":"A2"},{"ddatetime":"2020-10-12 17:27","country":"南沙区","town":"横沥镇","qxcode":"Q15101","bbcc":"GDNS","signame":"A","signame_cn":"台风","signcolor":"2","signcolor_cn":"蓝色","color":"#0C0EEC","sig":"A2"},{"ddatetime":"2020-10-12 17:27","country":"南沙区","town":"黄阁镇","qxcode":"Q15102","bbcc":"GDNS","signame":"A","signame_cn":"台风","signcolor":"2","signcolor_cn":"蓝色","color":"#0C0EEC","sig":"A2"},{"ddatetime":"2020-10-12 17:27","country":"南沙区","town":"龙穴街","qxcode":"Q15003","bbcc":"GDNS","signame":"A","signame_cn":"台风","signcolor":"2","signcolor_cn":"蓝色","color":"#0C0EEC","sig":"A2"},{"ddatetime":"2020-10-12 17:27","country":"南沙区","town":"南沙街","qxcode":"Q15001","bbcc":"GDNS","signame":"A","signame_cn":"台风","signcolor":"2","signcolor_cn":"蓝色","color":"#0C0EEC","sig":"A2"},{"ddatetime":"2020-10-12 17:27","country":"南沙区","town":"万顷沙镇","qxcode":"Q15100","bbcc":"GDNS","signame":"A","signame_cn":"台风","signcolor":"2","signcolor_cn":"蓝色","color":"#0C0EEC","sig":"A2"},{"ddatetime":"2020-10-12 17:27","country":"南沙区","town":"珠江街","qxcode":"Q15002","bbcc":"GDNS","signame":"A","signame_cn":"台风","signcolor":"2","signcolor_cn":"蓝色","color":"#0C0EEC","sig":"A2"},{"ddatetime":"2020-10-12 17:27","country":"南沙区","town":"榄核镇","qxcode":"Q15105","bbcc":"GDNS","signame":"A","signame_cn":"台风","signcolor":"2","signcolor_cn":"蓝色","color":"#0C0EEC","sig":"A2"},{"ddatetime":"2020-10-12 17:27","country":"南沙区","qxcode":"Q00000","bbcc":"GDNS","signame":"A","signame_cn":"台风","signcolor":"2","signcolor_cn":"蓝色","color":"#0C0EEC","sig":"A2"},{"ddatetime":"2020-10-12 12:39","country":"天河区","qxcode":"Q06000","bbcc":"BCGZ","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 12:39","country":"越秀区","qxcode":"Q04000","bbcc":"BCGZ","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:37","country":"增城区","town":"荔城街","qxcode":"Q18001","bbcc":"GDZC","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:37","country":"增城区","town":"荔湖街","qxcode":"Q18005","bbcc":"GDZC","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:37","country":"增城区","town":"宁西街","qxcode":"Q18006","bbcc":"GDZC","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:37","country":"增城区","town":"派潭镇","qxcode":"Q18105","bbcc":"GDZC","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:37","country":"增城区","town":"石滩镇","qxcode":"Q18102","bbcc":"GDZC","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:37","country":"增城区","town":"仙村镇","qxcode":"Q18107","bbcc":"GDZC","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:37","country":"增城区","town":"小楼镇","qxcode":"Q18106","bbcc":"GDZC","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:37","country":"增城区","town":"新塘镇","qxcode":"Q18101","bbcc":"GDZC","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:37","country":"增城区","town":"永宁街","qxcode":"Q18004","bbcc":"GDZC","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:37","country":"增城区","town":"增江街","qxcode":"Q18002","bbcc":"GDZC","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:37","country":"增城区","town":"正果镇","qxcode":"Q18104","bbcc":"GDZC","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:37","country":"增城区","town":"中新镇","qxcode":"Q18103","bbcc":"GDZC","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:37","country":"增城区","town":"朱村街","qxcode":"Q18003","bbcc":"GDZC","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"},{"ddatetime":"2020-10-12 17:37","country":"增城区","qxcode":"Q00000","bbcc":"GDZC","signame":"A","signame_cn":"台风","signcolor":"1","signcolor_cn":"白色","color":"#F6F6F6","sig":"A1"}],"J":[{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"石井街","qxcode":"Q11014","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"石门街","qxcode":"Q11019","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"松洲街","qxcode":"Q11003","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"太和镇","qxcode":"Q11107","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"棠景街","qxcode":"Q11007","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"同德街","qxcode":"Q11005","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"同和街","qxcode":"Q11009","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"新市街","qxcode":"Q11008","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"永平街","qxcode":"Q11011","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"云城街","qxcode":"Q11016","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"钟落潭镇","qxcode":"Q11108","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","qxcode":"Q00000","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:18","country":"从化区","town":"城郊街","qxcode":"Q17003","bbcc":"GDCO","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:18","country":"从化区","town":"江埔街","qxcode":"Q17002","bbcc":"GDCO","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:18","country":"从化区","town":"街口街","qxcode":"Q17001","bbcc":"GDCO","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:18","country":"从化区","town":"良口镇","qxcode":"Q17104","bbcc":"GDCO","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:18","country":"从化区","town":"吕田镇","qxcode":"Q17107","bbcc":"GDCO","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:18","country":"从化区","town":"太平镇","qxcode":"Q17111","bbcc":"GDCO","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:18","country":"从化区","town":"温泉镇","qxcode":"Q17103","bbcc":"GDCO","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:18","country":"从化区","town":"鳌头镇","qxcode":"Q17113","bbcc":"GDCO","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:18","country":"从化区","qxcode":"Q00000","bbcc":"GDCO","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 11:02","country":"海珠区","qxcode":"Q00000","bbcc":"GDHH","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:02","country":"花都区","town":"赤坭镇","qxcode":"Q14108","bbcc":"GDHX","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:02","country":"花都区","town":"花城街","qxcode":"Q14002","bbcc":"GDHX","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:02","country":"花都区","town":"花东镇","qxcode":"Q14105","bbcc":"GDHX","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:02","country":"花都区","town":"花山镇","qxcode":"Q14104","bbcc":"GDHX","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:02","country":"花都区","town":"狮岭镇","qxcode":"Q14109","bbcc":"GDHX","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:02","country":"花都区","town":"炭步镇","qxcode":"Q14107","bbcc":"GDHX","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:02","country":"花都区","town":"梯面镇","qxcode":"Q14103","bbcc":"GDHX","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:02","country":"花都区","town":"新华街","qxcode":"Q14001","bbcc":"GDHX","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:02","country":"花都区","town":"新雅街","qxcode":"Q14004","bbcc":"GDHX","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:02","country":"花都区","town":"秀全街","qxcode":"Q14003","bbcc":"GDHX","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:02","country":"花都区","qxcode":"Q00000","bbcc":"GDHX","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"长岭街道","qxcode":"Q12016","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"长洲街道","qxcode":"Q12010","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"大沙街道","qxcode":"Q12005","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"红山街道","qxcode":"Q12002","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"黄埔街道","qxcode":"Q12001","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"九佛街道","qxcode":"Q12017","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"联和街道","qxcode":"Q12014","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"白云湖街","qxcode":"Q11018","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"鹤龙街","qxcode":"Q11017","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"黄石街","qxcode":"Q11006","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"嘉禾街","qxcode":"Q11012","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"江高镇","qxcode":"Q11113","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"金沙街","qxcode":"Q11015","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"京溪街","qxcode":"Q11010","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"景泰街","qxcode":"Q11004","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"均禾街","qxcode":"Q11013","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"人和镇","qxcode":"Q11103","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:15","country":"白云区","town":"三元里街","qxcode":"Q11002","bbcc":"GDBY","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"龙湖街道","qxcode":"Q12018","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"萝岗街道","qxcode":"Q12012","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"南岗街道","qxcode":"Q12008","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"穗东街道","qxcode":"Q12007","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"文冲街道","qxcode":"Q12006","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"夏港街道","qxcode":"Q12011","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"新龙镇","qxcode":"Q12101","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"永和街道","qxcode":"Q12015","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"鱼珠街道","qxcode":"Q12003","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","town":"云埔街道","qxcode":"Q12013","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:55","country":"黄埔区","qxcode":"Q00000","bbcc":"GDHU","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:47","country":"荔湾区","qxcode":"Q00000","bbcc":"GDLW","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:43","country":"天河区","qxcode":"Q06000","bbcc":"BCGZ","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 10:43","country":"越秀区","qxcode":"Q04000","bbcc":"BCGZ","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 11:09","country":"增城区","town":"荔城街","qxcode":"Q18001","bbcc":"GDZC","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 11:09","country":"增城区","town":"荔湖街","qxcode":"Q18005","bbcc":"GDZC","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 11:09","country":"增城区","town":"宁西街","qxcode":"Q18006","bbcc":"GDZC","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 11:09","country":"增城区","town":"派潭镇","qxcode":"Q18105","bbcc":"GDZC","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 11:09","country":"增城区","town":"石滩镇","qxcode":"Q18102","bbcc":"GDZC","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 11:09","country":"增城区","town":"仙村镇","qxcode":"Q18107","bbcc":"GDZC","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 11:09","country":"增城区","town":"小楼镇","qxcode":"Q18106","bbcc":"GDZC","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 11:09","country":"增城区","town":"新塘镇","qxcode":"Q18101","bbcc":"GDZC","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 11:09","country":"增城区","town":"永宁街","qxcode":"Q18004","bbcc":"GDZC","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 11:09","country":"增城区","town":"增江街","qxcode":"Q18002","bbcc":"GDZC","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 11:09","country":"增城区","town":"正果镇","qxcode":"Q18104","bbcc":"GDZC","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 11:09","country":"增城区","town":"中新镇","qxcode":"Q18103","bbcc":"GDZC","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 11:09","country":"增城区","town":"朱村街","qxcode":"Q18003","bbcc":"GDZC","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"},{"ddatetime":"2020-10-06 11:09","country":"增城区","qxcode":"Q00000","bbcc":"GDZC","signame":"J","signame_cn":"森林火险","signcolor":"3","signcolor_cn":"黄色","color":"#CCCA04","sig":"J3"}]}}

postgresql 解析json

SELECT (a.json_text::json->>'data')::json->>'A'
   FROM 
   gz_ods_schema.ods_qxj_json_test a ;

SELECT json_array_elements(((a.json_text::json->>'data')::json->>'A')::json)->>'ddatetime' as ddatetime,
       json_array_elements(((a.json_text::json->>'data')::json->>'A')::json)->>'country' as country,
    json_array_elements(((a.json_text::json->>'data')::json->>'A')::json)->>'town' as country
   FROM 
   gz_ods_schema.ods_qxj_json_test a ;


SELECT json_array_elements(((a.json_text::json->>'data')::json->>'J')::json)->>'ddatetime' as ddatetime,
       json_array_elements(((a.json_text::json->>'data')::json->>'J')::json)->>'country' as country,
    json_array_elements(((a.json_text::json->>'data')::json->>'J')::json)->>'town' as country
   FROM 
   gz_ods_schema.ods_qxj_json_test a ;