This script pulls data from UTrans into the internal SGID database. Erik would like an updated query to be used:
(STATUS IS NULL OR STATUS NOT IN ('Planned', 'Retired')) AND CARTOCODE <> '99'
This query will include NULLs values in STATUS that the previous query did not. I also filters out roads with a 'Retired' value (the previous only filtered out 'Planned').
This script pulls data from UTrans into the internal SGID database. Erik would like an updated query to be used: