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 | |
Results tagged with postgis
Search options not deleted
user 1533
PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.
2
votes
Trouble with PostGIS and multiple selection sources
using the PostGIS documentation entry on ST_MakePolygon (https://postgis.net/docs/ST_MakePolygon.html) as a guide, the following should work for you:
SELECT
CASE WHEN
ST_Accum(ST_LineMerge(ST_Boundary …
- 443
3
votes
Accepted
PostGIS Error: type "geography" does not exist
all postgres plus or enterprise db components and start fresh with the installer found here:
http://www.enterprisedb.com/products-services-training/pgdownload#windows
Run this installer, selecting PostGIS … from the Application Stack Builder, and you'll have the most recent, stable, community-supported versions of PostgreSQL and PostGIS. …
- 443
6
votes
When should I use ST_Buffer?
OpenGeo provides a pretty good summary of ST_Buffer. Note the ability to pass a negative buffer radius.
The buffer function is also a useful work around at times. By passing a buffer radius of zero, …
- 443
0
votes
Join intersecting lines with PostGIS
Just spit-balling but I can think of a few other solutions. I don't know if they're better or worse, just that they're other.
First, if there are only a few road types you can go type-by-type with s …
- 443
0
votes
Removing "the_geom" field in .csv output of GeoServer
It might not help in your situation, but just in case you can make it work.
You can generate a .csv with the PostgreSQL COPY command, retrieving every column by simply naming the table OR passing a SE …
- 443
1
vote
Displaying circle with a center
Have you considered something like:
SELECT ST_GeomFromText('GEOMETRYCOLLECTION(circularstring_geometry,ST_Centroid(circularstring_geometry))',[SRID]);
where circularstring_geometry represents the g …
- 443
2
votes
File paths in a PostGIS Table in QGIS
Try double quoting your paths, or escaping your slashes.
Either
"D:\Projects\picture.jpg"
or
'D:\\Projects\\picture.jpg'
should fix you right up.
- 443
3
votes
Rename postGIS table and updating the GeoServer?
SELECT Probe_Geometry_Columns();
is a handy utility.
First, when we append a geometry column to an existing table with
SELECT AddGeometryColumn('my_table', 'geo_column', 1234, 'MULTIPOINT', 2);
…
- 443
1
vote
Accepted
To get attribute data of polygon layer by giving Lat/Lon
Based on the point-pair values I'll assume the coordinates are meant to be projected in EPSG:32643. Given your error message I'll assume your stored geometry is EPSG:4326. You can transform the point …
- 443
4
votes
1
answer
539
views
Sort by geometry using INHERITS?
PostGIS In Action (awesome resource) gives a good example of a linestring table sorted by state_fips but I haven't heard any firsthand accounts of using inheritance with geometries.
-Rob …
- 443