Vjylku

Manager has noticed coworker's excessive breaks. Should I warn him?

Given the mapping a = 1, b = 2, ... z = 26, and an encoded message, count the number of ways it can be decoded

Have the UK Conservatives lost the working majority and if so, what does this mean?

What is the reason behind this musical reference to Pinocchio in the Close Encounters main theme?

Does this property characterize the odd primes?

When distributing a Linux kernel driver as source code, what's the difference between Proprietary and GPL license?

Is there a way to pause a running process on Linux systems and resume later?

What is formjacking?

What did Putin say about a US deep state in his state-of-the-nation speech; what has he said in the past?

Did the characters in Moving Pictures not know about cameras like Twoflower's?

For the Circle of Spores druid's Halo of Spores feature, is your reaction used regardless of whether the other creature succeeds on the saving throw?

simplicial objects in a model category

Can I combine Divination spells with Arcane Eye?

How does the spell Slow affect freefall?

Taking an academic pseudonym?

What does it mean when an external ID field follows a DML Statement?

How can I differentiate duration vs starting time

Why don't you get burned by the wood benches in a sauna?

How can I make my enemies feel real and make combat more engaging?

Build ASCII Podiums

Is it ethical to apply for a job on someone's behalf?

Why is Bernie Sanders maximum accepted donation on actblue $5600?

Coworker is trying to get me to sign his petition to run for office. How to decline politely?

Identical projects by students at two different colleges: still plagiarism?

Different SRID shown in QGIS and PostGIS for the same data

Is it possible to reproject spatial data using SQL Server?ogr2ogr srs options: where is the well known definition determined?Postgis 2.0 - public.geometry_columns view does not contain correct info for viewsPostGIS Geometry Query returns “Error: Operation on mixed SRID geometries” only for certain valuesOverride “ERROR: Operation on mixed SRID geometries” and force PostGIS to do the queryCalculating surface map from PostGIS?QGIS Layers not projecting although Coordinate Reference Systems are the samePostGIS query “Error: Operation on mixed SRID geometries” only for certain tablesproblem with django GDALRaster to load ascii grid rastersIs SRID 4326 Lon/Lat or Lat/Lon?

1

1

I have data stored in PostGIS. When I view its properties in QGIS, it says:

SRS: EPSG:4326 - WGS 84

However, when I want retrieve the SRID value directly using the Find_SRID function, it returns 0. And by looking at the data, SRID is really 0 in PostGIS.

Query:

select * from geometry_columns;

Returns:

f_table_name | f_geometry_column | coord_dimension | srid |  type



-----------------+------------------+--------------+-------------------



vector       | wkb_geometry      |               2 |    0 | POINT



vector       | wkb_geometry      |               2 |    0 | POINT



buff_out     | wkb_geometry      |               2 |    0 | POLYGON



buff_out     | wkb_geometry      |               2 |    0 | POLYGON

Question: Why is SRID for the same data different in QGIS and in PostGIS? How do I get the correct SRID value from PostGIS?

I am using PostGIS 9.5.

postgis coordinate-system postgresql srid

share|improve this question

asked Jul 22 '18 at 12:34

Jan PislJan Pisl

678

bumped to the homepage by Community♦ 5 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  5
  

  
  
  
  
  
  

  
  
  0 in PostGIS means no SRID given. In your QGIS probably the WGS84 is the default projection. The default projection is used in QGIS when the SRID is not given. You should define the correct SRID in PostGIS and QGIS will use the same.
  
  – Zoltan
  Jul 22 '18 at 12:52
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Instead of querying the geometry_columns table, can you see what ST_SRID(geom) reports from the table itself?
  
  – DPSSpatial
  Jul 22 '18 at 18:03
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i wanted to try ST_SRID() too but I dont understand what should I pass it as the (geom) argument..
  
  – Jan Pisl
  Jul 22 '18 at 23:32
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @JanPisl throughout the PostGIS docs and Q/A, geom refers to the identifier/name of the data's geometry column; it's wkb_geometry in this case, e.g. SELECT ST_SRID(wkb_geometry) FROM <your_table>
  
  – ThingumaBob
  Jul 23 '18 at 7:03
  
  
  

  
  
  
  

add a comment | 

1

1

I have data stored in PostGIS. When I view its properties in QGIS, it says:

SRS: EPSG:4326 - WGS 84

However, when I want retrieve the SRID value directly using the Find_SRID function, it returns 0. And by looking at the data, SRID is really 0 in PostGIS.

Query:

select * from geometry_columns;

Returns:

f_table_name | f_geometry_column | coord_dimension | srid |  type



-----------------+------------------+--------------+-------------------



vector       | wkb_geometry      |               2 |    0 | POINT



vector       | wkb_geometry      |               2 |    0 | POINT



buff_out     | wkb_geometry      |               2 |    0 | POLYGON



buff_out     | wkb_geometry      |               2 |    0 | POLYGON

Question: Why is SRID for the same data different in QGIS and in PostGIS? How do I get the correct SRID value from PostGIS?

I am using PostGIS 9.5.

postgis coordinate-system postgresql srid

share|improve this question

asked Jul 22 '18 at 12:34

Jan PislJan Pisl

678

bumped to the homepage by Community♦ 5 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  5
  

  
  
  
  
  
  

  
  
  0 in PostGIS means no SRID given. In your QGIS probably the WGS84 is the default projection. The default projection is used in QGIS when the SRID is not given. You should define the correct SRID in PostGIS and QGIS will use the same.
  
  – Zoltan
  Jul 22 '18 at 12:52
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Instead of querying the geometry_columns table, can you see what ST_SRID(geom) reports from the table itself?
  
  – DPSSpatial
  Jul 22 '18 at 18:03
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i wanted to try ST_SRID() too but I dont understand what should I pass it as the (geom) argument..
  
  – Jan Pisl
  Jul 22 '18 at 23:32
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @JanPisl throughout the PostGIS docs and Q/A, geom refers to the identifier/name of the data's geometry column; it's wkb_geometry in this case, e.g. SELECT ST_SRID(wkb_geometry) FROM <your_table>
  
  – ThingumaBob
  Jul 23 '18 at 7:03
  
  
  

  
  
  
  

add a comment | 

I have data stored in PostGIS. When I view its properties in QGIS, it says:

SRS: EPSG:4326 - WGS 84

However, when I want retrieve the SRID value directly using the Find_SRID function, it returns 0. And by looking at the data, SRID is really 0 in PostGIS.

Query:

select * from geometry_columns;

Returns:

f_table_name | f_geometry_column | coord_dimension | srid |  type



-----------------+------------------+--------------+-------------------



vector       | wkb_geometry      |               2 |    0 | POINT



vector       | wkb_geometry      |               2 |    0 | POINT



buff_out     | wkb_geometry      |               2 |    0 | POLYGON



buff_out     | wkb_geometry      |               2 |    0 | POLYGON

Question: Why is SRID for the same data different in QGIS and in PostGIS? How do I get the correct SRID value from PostGIS?

I am using PostGIS 9.5.

postgis coordinate-system postgresql srid

share|improve this question

asked Jul 22 '18 at 12:34

Jan PislJan Pisl

678

SRS: EPSG:4326 - WGS 84

select * from geometry_columns;

f_table_name | f_geometry_column | coord_dimension | srid |  type



-----------------+------------------+--------------+-------------------



vector       | wkb_geometry      |               2 |    0 | POINT



vector       | wkb_geometry      |               2 |    0 | POINT



buff_out     | wkb_geometry      |               2 |    0 | POLYGON



buff_out     | wkb_geometry      |               2 |    0 | POLYGON

share|improve this question

asked Jul 22 '18 at 12:34

Jan PislJan Pisl

678

share|improve this question

asked Jul 22 '18 at 12:34

Jan PislJan Pisl

678

asked Jul 22 '18 at 12:34

Jan PislJan Pisl

678

asked Jul 22 '18 at 12:34

Jan PislJan Pisl

678

1 Answer
1

active

oldest

votes

0

You could try the following (as an example) if you still have issues.

SELECT UpdateGeometrySRID('vector','wkb_geometry',4326);

In QGIS when you add layers to canvas you only set the SRID for that proyect's layers

share|improve this answer

edited Jan 23 at 0:06

tinlyx

5,31553374

answered Jan 22 at 23:46

YPCAYPCA

13

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f290256%2fdifferent-srid-shown-in-qgis-and-postgis-for-the-same-data%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

You could try the following (as an example) if you still have issues.

SELECT UpdateGeometrySRID('vector','wkb_geometry',4326);

In QGIS when you add layers to canvas you only set the SRID for that proyect's layers

share|improve this answer

edited Jan 23 at 0:06

tinlyx

5,31553374

answered Jan 22 at 23:46

YPCAYPCA

13

add a comment | 

0

You could try the following (as an example) if you still have issues.

SELECT UpdateGeometrySRID('vector','wkb_geometry',4326);

In QGIS when you add layers to canvas you only set the SRID for that proyect's layers

share|improve this answer

edited Jan 23 at 0:06

tinlyx

5,31553374

answered Jan 22 at 23:46

YPCAYPCA

13

add a comment | 

You could try the following (as an example) if you still have issues.

SELECT UpdateGeometrySRID('vector','wkb_geometry',4326);

In QGIS when you add layers to canvas you only set the SRID for that proyect's layers

share|improve this answer

edited Jan 23 at 0:06

tinlyx

5,31553374

answered Jan 22 at 23:46

YPCAYPCA

13

SELECT UpdateGeometrySRID('vector','wkb_geometry',4326);

share|improve this answer

edited Jan 23 at 0:06

tinlyx

5,31553374

answered Jan 22 at 23:46

YPCAYPCA

13

edited Jan 23 at 0:06

tinlyx

5,31553374

edited Jan 23 at 0:06

tinlyx

5,31553374

answered Jan 22 at 23:46

YPCAYPCA

13

answered Jan 22 at 23:46

YPCAYPCA

13