Styjun

Sanitise a high score table

Is It normal to keep log file larger than data file?

Postman Delivery

A sentient carnivorous species trying to preserve life. How could they find a new food source?

What is the next number in the series: 21, 21, 23, 20, 5, 25, 31, 24,?

Can a Creature at 0 HP Take Damage?

Do "chess engine in the cloud" services exist?

Is it fine to ask this kind of question to the corresponding author of a paper?

QGIS can't detect negative values?

I am confused with the word order when putting a sentence into passé composé with reflexive verbs

Are there any official mechanics for grafts or anything similar?

Is having your hand in your pocket during a presentation bad?

Looking for PC graphics demo software from the early 90s called "Unreal"

Why does unique_ptr<Derived> implicitly cast to unique_ptr<Base>?

Translation Golf XLVIII — We're sorry to see you go

Can you be promoted and then fired for-cause? (Performance)

Can I perform Umrah while on a Saudi Arabian visit e-visa

Tikz – Box/frame arround Text with interruption

How do lasers measure short distances (<1cm) when electronics are too slow for time-of-flight to work?

Why didn't Snape ask Dumbledore why he let "Moody" search his office?

Reduction of carbamate with LAH

Modern warfare theory in a medieval setting

Find the percentage

How do I break the broom in Untitled Goose Game?

postgis - ST_Intersects not working, different measurement system

Get PostGIS versionPOSTGIS: ERROR: Operation on mixed SRID geometries. Trying to find overlapping geoms with two different SRIDS/tablesOptimize PostGIS query, ST_IntersectsPostGIS ST_Intersects not returning valuesOptimizing ST_Intersects in PostgreSQL(PostGIS)ST_DWithin optimization for multiple SRIDsPOSTGIS unwanted results with St_INTERSECTS and ST_CROSSESCalling postgis ST_DWithin in a rails queryPOSTGIS multiple polygons ST_Intersects checkPostGIS st_intersects() and spatial index

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty
margin-bottom:0;

0

I have 2 tables, parcels and units. Parcels is in Meters, and Units is in Feet

I'm attempting the following:

SELECT p.pin, ST_AsGeoJSON(ST_Transform(p.geom,4326)) as geojson
 FROM susquehanna_parcels p, units_pa u
 WHERE ST_Intersects(p.geom, u.the_geom)
 AND u.unit_name='Traver E North 07-081'

I'm not getting any results because the measurement system is off. You can see I"m trying to get a decimal degrees out (which works in other queries), but since there aren't any intersections with the data, there are no results.

How can I convert either p.geom to feet on the fly or u.the_geom to meters on the fly so the ST_Intersects can work properly?

postgis

share|improve this question

asked Mar 28 at 21:01

PhotovorPhotovor

14111 gold badge33 silver badges1313 bronze badges

add a comment
 | 

0

I have 2 tables, parcels and units. Parcels is in Meters, and Units is in Feet

I'm attempting the following:

SELECT p.pin, ST_AsGeoJSON(ST_Transform(p.geom,4326)) as geojson
 FROM susquehanna_parcels p, units_pa u
 WHERE ST_Intersects(p.geom, u.the_geom)
 AND u.unit_name='Traver E North 07-081'

I'm not getting any results because the measurement system is off. You can see I"m trying to get a decimal degrees out (which works in other queries), but since there aren't any intersections with the data, there are no results.

How can I convert either p.geom to feet on the fly or u.the_geom to meters on the fly so the ST_Intersects can work properly?

postgis

share|improve this question

asked Mar 28 at 21:01

PhotovorPhotovor

14111 gold badge33 silver badges1313 bronze badges

add a comment
 | 

I have 2 tables, parcels and units. Parcels is in Meters, and Units is in Feet

I'm attempting the following:

SELECT p.pin, ST_AsGeoJSON(ST_Transform(p.geom,4326)) as geojson
 FROM susquehanna_parcels p, units_pa u
 WHERE ST_Intersects(p.geom, u.the_geom)
 AND u.unit_name='Traver E North 07-081'

I'm not getting any results because the measurement system is off. You can see I"m trying to get a decimal degrees out (which works in other queries), but since there aren't any intersections with the data, there are no results.

How can I convert either p.geom to feet on the fly or u.the_geom to meters on the fly so the ST_Intersects can work properly?

postgis

share|improve this question

asked Mar 28 at 21:01

PhotovorPhotovor

14111 gold badge33 silver badges1313 bronze badges

SELECT p.pin, ST_AsGeoJSON(ST_Transform(p.geom,4326)) as geojson
 FROM susquehanna_parcels p, units_pa u
 WHERE ST_Intersects(p.geom, u.the_geom)
 AND u.unit_name='Traver E North 07-081'

share|improve this question

asked Mar 28 at 21:01

PhotovorPhotovor

14111 gold badge33 silver badges1313 bronze badges

share|improve this question

asked Mar 28 at 21:01

PhotovorPhotovor

14111 gold badge33 silver badges1313 bronze badges

asked Mar 28 at 21:01

PhotovorPhotovor

14111 gold badge33 silver badges1313 bronze badges

asked Mar 28 at 21:01

PhotovorPhotovor

14111 gold badge33 silver badges1313 bronze badges

1 Answer
1

active

oldest

votes

0

If parcels is in meter and units in feet, as long as the measure unit depends on the SRID, they aren't in the same SRID. You should make sure both geoms are in the same SRID if you are checking if they intersect.

SELECT p.pin, ST_AsGeoJSON(ST_Transform(p.geom,4326)) as geojson
 FROM susquehanna_parcels p, units_pa u
 WHERE ST_Intersects(ST_Transform(p.geom, 4326), ST_Transform(u.the_geom, 4326))
 AND u.unit_name='Traver E North 07-081'

I used EPSG 4326 here because is the same you used before but any other should be fine as long as is the same for both geoms inside ST_Intersects

share|improve this answer

answered Mar 28 at 21:51

CarlosAlbaladejoCarlosAlbaladejo

6644 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This still doesn't work for me. However, I did notice during the import of the data into postgis using shp2pgsql that it used SRID 2271, so not sure if that makes a difference.
  
  – Photovor
  Mar 29 at 12:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Maybe one of your geoms does not have any SRID defined because it was not set properly in the shp2pgsql. You can set the SRID with ST_setSRID or check if the SRID is correct with ST_SRID
  
  – CarlosAlbaladejo
  Mar 29 at 20:24
  
  

  
  
  
  

add a comment
 | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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/4.0/"u003ecc by-sa 4.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%2fstackoverflow.com%2fquestions%2f55406795%2fpostgis-st-intersects-not-working-different-measurement-system%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

If parcels is in meter and units in feet, as long as the measure unit depends on the SRID, they aren't in the same SRID. You should make sure both geoms are in the same SRID if you are checking if they intersect.

SELECT p.pin, ST_AsGeoJSON(ST_Transform(p.geom,4326)) as geojson
 FROM susquehanna_parcels p, units_pa u
 WHERE ST_Intersects(ST_Transform(p.geom, 4326), ST_Transform(u.the_geom, 4326))
 AND u.unit_name='Traver E North 07-081'

I used EPSG 4326 here because is the same you used before but any other should be fine as long as is the same for both geoms inside ST_Intersects

share|improve this answer

answered Mar 28 at 21:51

CarlosAlbaladejoCarlosAlbaladejo

6644 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This still doesn't work for me. However, I did notice during the import of the data into postgis using shp2pgsql that it used SRID 2271, so not sure if that makes a difference.
  
  – Photovor
  Mar 29 at 12:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Maybe one of your geoms does not have any SRID defined because it was not set properly in the shp2pgsql. You can set the SRID with ST_setSRID or check if the SRID is correct with ST_SRID
  
  – CarlosAlbaladejo
  Mar 29 at 20:24
  
  

  
  
  
  

add a comment
 | 

0

If parcels is in meter and units in feet, as long as the measure unit depends on the SRID, they aren't in the same SRID. You should make sure both geoms are in the same SRID if you are checking if they intersect.

SELECT p.pin, ST_AsGeoJSON(ST_Transform(p.geom,4326)) as geojson
 FROM susquehanna_parcels p, units_pa u
 WHERE ST_Intersects(ST_Transform(p.geom, 4326), ST_Transform(u.the_geom, 4326))
 AND u.unit_name='Traver E North 07-081'

I used EPSG 4326 here because is the same you used before but any other should be fine as long as is the same for both geoms inside ST_Intersects

share|improve this answer

answered Mar 28 at 21:51

CarlosAlbaladejoCarlosAlbaladejo

6644 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This still doesn't work for me. However, I did notice during the import of the data into postgis using shp2pgsql that it used SRID 2271, so not sure if that makes a difference.
  
  – Photovor
  Mar 29 at 12:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Maybe one of your geoms does not have any SRID defined because it was not set properly in the shp2pgsql. You can set the SRID with ST_setSRID or check if the SRID is correct with ST_SRID
  
  – CarlosAlbaladejo
  Mar 29 at 20:24
  
  

  
  
  
  

add a comment
 | 

If parcels is in meter and units in feet, as long as the measure unit depends on the SRID, they aren't in the same SRID. You should make sure both geoms are in the same SRID if you are checking if they intersect.

SELECT p.pin, ST_AsGeoJSON(ST_Transform(p.geom,4326)) as geojson
 FROM susquehanna_parcels p, units_pa u
 WHERE ST_Intersects(ST_Transform(p.geom, 4326), ST_Transform(u.the_geom, 4326))
 AND u.unit_name='Traver E North 07-081'

I used EPSG 4326 here because is the same you used before but any other should be fine as long as is the same for both geoms inside ST_Intersects

share|improve this answer

answered Mar 28 at 21:51

CarlosAlbaladejoCarlosAlbaladejo

6644 bronze badges

SELECT p.pin, ST_AsGeoJSON(ST_Transform(p.geom,4326)) as geojson
 FROM susquehanna_parcels p, units_pa u
 WHERE ST_Intersects(ST_Transform(p.geom, 4326), ST_Transform(u.the_geom, 4326))
 AND u.unit_name='Traver E North 07-081'

share|improve this answer

answered Mar 28 at 21:51

CarlosAlbaladejoCarlosAlbaladejo

6644 bronze badges

answered Mar 28 at 21:51

CarlosAlbaladejoCarlosAlbaladejo

6644 bronze badges

answered Mar 28 at 21:51

CarlosAlbaladejoCarlosAlbaladejo

6644 bronze badges