Accuracy of ST_Contains on geometry column with WGS84 dataProject twitter geo data into WGS84 mapPostgis...
Why are the books in the Game of Thrones citadel library shelved spine inwards?
What's a good word to describe a public place that looks like it wouldn't be rough?
How would an AI self awareness kill switch work?
If I delete my router's history can my ISP still provide it to my parents?
integral inequality of length of curve
Slow moving projectiles from a hand-held weapon - how do they reach the target?
Does Windows 10's telemetry include sending *.doc files if Word crashed?
How can I improve my fireworks photography?
Why avoid shared user accounts?
Can I become debt free or should I file for bankruptcy? How do I manage my debt and finances?
Why is working on the same position for more than 15 years not a red flag?
What kind of hardware implements Fourier transform?
"On one hand" vs "on the one hand."
Longest Jewish year
How to acknowledge an embarrassing job interview, now that I work directly with the interviewer?
Compound Interest... with Wizard Money
Everyone is beautiful
Approaches to criticizing short fiction
How to remove trailing forward slash
How should I handle players who ignore the session zero agreement?
Getting a UK passport renewed when you have dual nationality and a different name in your second country?
Shimano Shadow vs Non-Shadow Rear Derailleur for Commuter Bike
Word or phrase for showing great skill at something without formal training in it
Why did Bush enact a completely different foreign policy to that which he espoused during the 2000 Presidential election campaign?
Accuracy of ST_Contains on geometry column with WGS84 data
Project twitter geo data into WGS84 mapPostgis geometry column with different sridTransforming geometry PostGIS column with unknown geometry type?Transforming data from GCS Krasovsky to GCS WGS84?WGS84 to OSGB36 relative accuracyUnknown geometry type in postgis on ST_containsWGS84 with elevation zST_Contains(geometry A, geometry B) doesn't return polygons of B sharing external border with AST_Contains for 3D geometrySNPP Viirs swath data reprojection to wgs84
Apologies if this has been asked before; I found some similar questions (this mailing list post was particularly interesting: https://lists.osgeo.org/pipermail/postgis-users/2008-June/020353.html) but nothing quite satisfied my curiosity.
I have a table containing WGS84 data for a bunch of multipolygons (very large ones; multiple countries in most cases). I want to know which one contains an arbitrary point (where the point is also in WGS84 lat/long).
I am not sure if the geometry or the geography type is best suited for this. I implemented it first using geometry and it seems to work for some spot checks. I tried it with geography as well, and it was orders of magnitude slower.
1) Is geometry acceptable for modeling this, or will it have trouble?
2) If there will be some error using geometry, what are the error characteristics and magnitude to expect? (For example, will there be issues near boundaries of adjacent multipolygons, etc.)
EDIT: Since ST_Contains doesn't work with geography columns, I guess ST_Intersects would be the closest thing?
postgis coordinate-system wgs84
asked 11 mins ago
ianthetechieianthetechie
1011
New contributor
ianthetechie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Apologies if this has been asked before; I found some similar questions (this mailing list post was particularly interesting: https://lists.osgeo.org/pipermail/postgis-users/2008-June/020353.html) but nothing quite satisfied my curiosity.
I have a table containing WGS84 data for a bunch of multipolygons (very large ones; multiple countries in most cases). I want to know which one contains an arbitrary point (where the point is also in WGS84 lat/long).
I am not sure if the geometry or the geography type is best suited for this. I implemented it first using geometry and it seems to work for some spot checks. I tried it with geography as well, and it was orders of magnitude slower.
1) Is geometry acceptable for modeling this, or will it have trouble?
2) If there will be some error using geometry, what are the error characteristics and magnitude to expect? (For example, will there be issues near boundaries of adjacent multipolygons, etc.)
EDIT: Since ST_Contains doesn't work with geography columns, I guess ST_Intersects would be the closest thing?
postgis coordinate-system wgs84
asked 11 mins ago
ianthetechieianthetechie
1011
New contributor
ianthetechie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Apologies if this has been asked before; I found some similar questions (this mailing list post was particularly interesting: https://lists.osgeo.org/pipermail/postgis-users/2008-June/020353.html) but nothing quite satisfied my curiosity.
I have a table containing WGS84 data for a bunch of multipolygons (very large ones; multiple countries in most cases). I want to know which one contains an arbitrary point (where the point is also in WGS84 lat/long).
I am not sure if the geometry or the geography type is best suited for this. I implemented it first using geometry and it seems to work for some spot checks. I tried it with geography as well, and it was orders of magnitude slower.
1) Is geometry acceptable for modeling this, or will it have trouble?
2) If there will be some error using geometry, what are the error characteristics and magnitude to expect? (For example, will there be issues near boundaries of adjacent multipolygons, etc.)
EDIT: Since ST_Contains doesn't work with geography columns, I guess ST_Intersects would be the closest thing?
postgis coordinate-system wgs84
asked 11 mins ago
ianthetechieianthetechie
1011
New contributor
ianthetechie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Apologies if this has been asked before; I found some similar questions (this mailing list post was particularly interesting: https://lists.osgeo.org/pipermail/postgis-users/2008-June/020353.html) but nothing quite satisfied my curiosity.
I have a table containing WGS84 data for a bunch of multipolygons (very large ones; multiple countries in most cases). I want to know which one contains an arbitrary point (where the point is also in WGS84 lat/long).
I am not sure if the geometry or the geography type is best suited for this. I implemented it first using geometry and it seems to work for some spot checks. I tried it with geography as well, and it was orders of magnitude slower.
1) Is geometry acceptable for modeling this, or will it have trouble?
2) If there will be some error using geometry, what are the error characteristics and magnitude to expect? (For example, will there be issues near boundaries of adjacent multipolygons, etc.)
EDIT: Since ST_Contains doesn't work with geography columns, I guess ST_Intersects would be the closest thing?
postgis coordinate-system wgs84
postgis coordinate-system wgs84
asked 11 mins ago
ianthetechieianthetechie
1011
New contributor
ianthetechie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 11 mins ago
ianthetechieianthetechie
1011
New contributor
ianthetechie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 1 min ago
ianthetechie
asked 11 mins ago
ianthetechieianthetechie
1011
New contributor
ianthetechie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 11 mins ago
ianthetechieianthetechie
1011
asked 11 mins ago
ianthetechieianthetechie
1011
1011
New contributor
ianthetechie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
ianthetechie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
ianthetechie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
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
});
}
});
ianthetechie is a new contributor. Be nice, and check out our Code of Conduct.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f314181%2faccuracy-of-st-contains-on-geometry-column-with-wgs84-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
ianthetechie is a new contributor. Be nice, and check out our Code of Conduct.
ianthetechie is a new contributor. Be nice, and check out our Code of Conduct.
ianthetechie is a new contributor. Be nice, and check out our Code of Conduct.
ianthetechie is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f314181%2faccuracy-of-st-contains-on-geometry-column-with-wgs84-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
