bdit_data-sources icon indicating copy to clipboard operation
bdit_data-sources copied to clipboard

fix to allow text_to_centreline() to handle capitalized text

Open KatiRG opened this issue 3 years ago • 0 comments

What this pull request accomplishes:

Currently, gis.text_to_centreline() fails if the input text is capitalized, e.g.:

SELECT *
FROM gis.text_to_centreline(111,'BLOOR ST W', 'BETWEEN SHAW ST AND OSSINGTON AVE', NULL);

The problem has to do with using SPLIT_PART on fixed lower-case text and in the function function-clean_bylaws_text.sql which gis.text_to_centreline() calls. The 'Between' is also only checked for first letter capitalization.

This PR adds a replace for any possible AND or BETWEEN with the lower-case before SPLIT_PART in function-clean_bylaws_text.sql.

What, in particular, needs to reviewed:

  • pls confirm that these fixes work

KatiRG avatar Jul 06 '21 13:07 KatiRG