job-
---- time start: 2025-08-12 09:02:17----
---- TASK START ----
Bắt đầu tiến trình tính toàn chồng lớp
Xử lý dữ liệu cho bảng #5024 và #5022
Xử lý dữ liệu cho bảng dataset_88.cell_ccn_font_point và dataset_88.khu xu ly ctr_font_point
Tạo view temp.m_view_tool_intersection_5024_5022
Error: SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "ly"
LINE 10:                         JOIN dataset_88.khu xu ly ctr_font_p...
                                                        ^ (Connection: pgsql, SQL: CREATE MATERIALIZED VIEW temp.m_view_tool_intersection_5024_5022 AS SELECT
                        row_number() OVER () AS id,
                        a."ogc_fid" || '-' ||  b."ogc_fid" as feature_id,
                        a."ogc_fid" as feature_id_a,
                        b."ogc_fid" as feature_id_b,
                        jsonb_build_object('properties.a_ogc_fid', "a"."ogc_fid", 'properties.a_id', "a"."id", 'properties.a_ten_kccn', "a"."ten_kccn", 'properties.a_dt', "a"."dt", 'properties.a_xa', "a"."xa", 'properties.a_huyen', "a"."huyen", 'properties.a_tinhchat', "a"."tinhchat", 'properties.b_ogc_fid', "b"."ogc_fid", 'properties.b_id', "b"."id") as properties,
                            ST_Area(ST_Intersection(a.geom, b.geom)) AS area,
                            ST_Transform(ST_Intersection(a.geom, b.geom), 4326) AS geom
                        FROM dataset_88.cell_ccn_font_point a
                        JOIN dataset_88.khu xu ly ctr_font_point b
                            ON ST_Intersects(a.geom, b.geom)
                        WHERE a.geom IS NOT NULL AND b.geom IS NOT NULL AND ST_IsValid(a.geom) AND ST_IsValid(b.geom);
            )
---- time end: 2025-08-12 09:02:17----
---- TASK ERROR ----
job-
---- time start: 2026-04-03 04:19:53----
---- TASK START ----
Starting GDB import process
Dataset created||{"id":97,"schema":"dataset_97","display_name":"RGHC_2025.gdb"}
ogr2ogr process completed||{"result":"0...10...20...30...40...50...60...70...80...90...100 - done.","output":["0...10...20...30...40...50...60...70...80...90...100 - done."]}
ogr2ogr process completed||{"result":"0...10...20...30...40...50...60...70...80...90...100 - done.","output":["0...10...20...30...40...50...60...70...80...90...100 - done."]}
Found tables in schema||{"count":2,"table":["xa_phucthinh","quyhoach_phucthinh"]}
Table created||{"id":4911,"table":"xa_phucthinh","schema":"dataset_97","display_name":"Xa Phucthinh"}
Table created||{"id":4912,"table":"quyhoach_phucthinh","schema":"dataset_97","display_name":"Quyhoach Phucthinh"}
srid get: 4326
Fields processed||{"table":"xa_phucthinh","schema":"dataset_97","total":11,"created":10,"updated":0,"deleted":0}
srid get: 4326
Fields processed||{"table":"quyhoach_phucthinh","schema":"dataset_97","total":29,"created":28,"updated":0,"deleted":0}
Cleanup||["\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/26c0428d-971c-41e0-a02d-98a28194a209","\/var\/www\/webgis\/backend\/storage\/app\/uploads\/file\/26c0428d-971c-41e0-a02d-98a28194a209\/RGHC_2025.gdb.zip"]
Create vector tile view
Found tables in schema||{"count":2}
Processing table xa_phucthinh||{"columns":11,"count":1}
Processing table 1 of 2: xa_phucthinh
Processing table quyhoach_phucthinh||{"columns":29,"count":1799}
Processing table 2 of 2: quyhoach_phucthinh
Creating view||{"view_name":"view_title_97"}
Create vector tile view done
Create vector metadata view
Starting vector tile metadata generation process
Found layers in view||{"count":2}
Create vector metadata view done
---- time end: 2026-04-03 04:19:55----
---- TASK DONE ----