[postgis-users] extending sides of parcels to cut/intersect roads before merge

Hi all, I am working on a PostGIS polygon (parcel) layer where I need to merge adjacent parcels of the same land use.In between the parcels there are roads (that I would want to get rid of) by merging them to the adjacent land use area they share the longest common boundary with. One complicat

Re: [postgis-users] Is there a robust way to strip off special characters?

Add the ‘g’ option. See the PgSQL docs > On Mar 30, 2020, at 3:10 AM, Shaozhong SHI wrote: > > I ran the following code. > > ---strip special characters > area_name = regexp_replace(area_name, '[^\w]+',''); > > It only stripped away the first bracket - (. But, it left the closing > bracket

[postgis-users] Is there a robust way to strip off special characters?

I ran the following code. ---strip special characters area_name = regexp_replace(area_name, '[^\w]+',''); It only stripped away the first bracket - (. But, it left the closing bracket ). I had to run it twice in order to stripped the second. Is there a robust way to strip off special character