Search Results
Search type | Search syntax |
---|---|
Tags | [tag] |
Exact | "words here" |
Author |
user:1234 user:me (yours) |
Score |
score:3 (3+) score:0 (none) |
Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
Views | views:250 |
Code | code:"if (foo != bar)" |
Sections |
title:apples body:"apples oranges" |
URL | url:"*.example.com" |
Saves | in:saves |
Status |
closed:yes duplicate:no migrated:no wiki:no |
Types |
is:question is:answer |
Exclude |
-[tag] -apples |
For more details on advanced search visit our help page |
PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.
6
votes
How to replace polyline Z value equal to Nan is PostGIS?
-- replace Nan in the text representation of the geometry
UPDATE line SET geom = ST_SetSRID(st_geomfromtext(replace(replace(st_astext(geom), 'nan,', '0,'), 'nan)', '0)')), ST_SRID(geom))
WHERE …
4
votes
1
answer
234
views
How to replace polyline Z value equal to Nan is PostGIS?
In some polylines stored in PostGIS, I found Z values equal to NaN.
For example:
LINESTRING Z (30 10 0, 10 30 nan, 40 40 nan)
I want to replace the 'nan' with 0 to prevent subsequent errors. …
1
vote
Difficulty connecting QField to connect to PostGIS
Since the version 2.0 the pg_service.conf file must be placed in : Android\data\ch.opengis.qfield\files\QField and no more directly in a directory named QField in the main folder.
0
votes
QGIS form performance
If you have a problem of QGIS form performance you can also check if you have relations or joined layers which are slowing the form display. In my case the form took up to 30 second to appear.
You can …