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 postgresql
Search options not deleted
user 7505
PostgreSQL is an open source object-relational database system.
1
vote
Get Lon Lat values from a GEOGRAPHY data type in PostGIS
Not need cast
Try to use this query.
SELECT ST_XMax(geog), ST_YMax(geog), ST_AsEWKT(geog)
FROM locations LIMIT 10;
it works for me.
- 2,354
2
votes
1
answer
485
views
How can I keep a QGIS connection as simple as psql?
So, how can I keep QGIS simple to connect with my local PostgreSQL instance?
Can I connect to QGIS using only it? Only host/user/database. … But, if you need a reference, I am using QGIS v3+ with PostgreSQL v12+, psql version 12+ and PostGIS 3+. …
- 2,354
2
votes
Get geohash neighbors with PostGIS
Sorry, I'm 5 years late... A reliable solution. Based on this old Javascript of movable-type.co.uk/scripts, that was based this oldest (2008) library, https://github.com/davetroy/geohash-js
Pure stri …
- 2,354
6
votes
1
answer
345
views
DGGS projections with PostGIS or pgLatLon
Some clue or workaround to "plug" DGGRID into PostgreSQL? It can be a plug for PostGIS or pgLatLon extensions. …
- 2,354
1
vote
DGGS projections with PostGIS or pgLatLon
PostGIS use PROJ.org, and recent PROJ versions has implemented some projections, used in DGGS candidates:
PROJ v8.2+ added S2 Geometry's projection.
PROJ v??+ added QSC projection.
PROJ v??+ added …
3
votes
How to split OSM roads into individual segments at intersections?
About your general problem, using pgRouting: I think @Uffer, @GisStudent and others that are showing how to use "OSC & etc.", they are right. Go following the clues of of "best practices" and "standa …
- 2,354
2
votes
How can I transfer data from one PostGIS database to another?
Check usual tables and "tables with geometry", then use (at shell/UNIX terminal)
pg_dump for export the usual tables (import with psql)
pgsql2shp to export the geo tables, and shp2pgsql to import.
…
- 2,354
5
votes
Why does Find_SRID return zero?
Complementing with 3 "as it's":
1. As John's answer of 2014,
SRID of 0 doesn't technically exist, it just means no SRID — ie, the default if you forget to set it.
Zero is a valid SRID, your Po …
- 2,354
0
votes
Error inserting GeoJSON in PostGIS
Modern PostgreSQL + PostGIS accepts JSONB and its functions, the best datatype for this job, because the ST_GeomFromGeoJSON function (that accepts also JSONB) only accepts pure geometries, not the most …
- 2,354
12
votes
1
answer
5k
views
Is the Geometry(4326) an alias for Geography datatype?
Of course, for PostgreSQL is important to change the data type, to do function overloading... But the guide not explains the equivalence schemas in the internal representation. …
- 2,354
2
votes
1
answer
850
views
Getting SRID Well Known Text (WKT) metadata from PostgreSQL?
Or some complex PostgreSQL query over all PostGIS tables to see the SRID metadata? …
- 2,354