You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I checked the edit table and those segments were present, renderable both in QGIS and in CARTO web UI, and I couldn't see anything obviously wrong with them.
I wondered if they were newest edits. They were not, but they were the newest ADDED -- the max pline_id in the prod table was 1126507 while the max in the edit table was 1126644
Here's a map preview:
When I ran segments of the SQL that should find and insert all plines that are in the ecg_route_lines table but not in ecg_route_lines_prod, I got null results. As if they'd all been synced over.
But when I queried for any of the larger pline_id values in teh prod table, I got nothing.
When ECG did an edit>prod update today, they saw big breaks in the trail. I did the update myself and saw the same issue.
We use this SQL:
https://github.com/EastCoastGreenwayAlliance/ecg-map/blob/master/sql/ecg_lines_update_prod_table.sql
I checked the edit table and those segments were present, renderable both in QGIS and in CARTO web UI, and I couldn't see anything obviously wrong with them.
I wondered if they were newest edits. They were not, but they were the newest ADDED -- the max
pline_id
in the prod table was1126507
while the max in the edit table was1126644
Here's a map preview:
When I ran segments of the SQL that should find and insert all
plines
that are in theecg_route_lines
table but not inecg_route_lines_prod
, I got null results. As if they'd all been synced over.But when I queried for any of the larger
pline_id
values in teh prod table, I got nothing.Had to run this SQL to drag them over:
The text was updated successfully, but these errors were encountered: