st_isvalid and duplicate vertexUsing group by to set a PostGIS datasource using QGIS Python APIPostGIS Intermittent INDEX PerformanceUsing ST_MakeEnvelope over the antimeridianEmpty geometry resulting from pgrouting functionGIST slows down query?How to loop in PostGIS to add the next lat long to a routePostGIS Multipolygon when converted to shapefile doesn't match the source geometryHow can a Point NOT be Within or Touch but still Intersect a polygon?Finding Closest Point to Polyline Vertex and Apply ElevationBackup QGIS (3.2.1) layer to independent PostGIS table?
Why is infinite intersection "towards infinity" an empty set?
How do we create our own symbolisms?
Dragons and gems
How to plot two curves with the same area under?
How to finish my PhD?
Why did Tony's Arc Reactor do this?
Can taking my 1-week-old on a 6-7 hours journey in the car lead to medical complications?
Word for something that used to be popular but not anymore
Capacitors with same voltage, same capacitance, same temp, different diameter?
I multiply the source, you (probably) multiply the output!
How would two worlds first establish an exchange rate between their currencies
Contour plot of a sequence of spheres with increasing radius
Supervisor wants me to support a diploma-thesis SW tool after I graduated
How to improvise or make pot grip / pot handle
Friend is very nitpicky about side comments I don't intend to be taken too seriously
The meaning of "offing" in "an agreement in the offing"
What can we do about our 9-month-old putting fingers down his throat?
st_isvalid and duplicate vertex
Extra arrow heads appearing tikz
Why are UK MPs allowed to abstain (but it counts as a no)?
PWM on 5V GPIO pin
Bacteria vats to generate edible biomass, require intermediary species?
Was Robin Hood's point of view ethically sound?
What is the purpose of the rotating plate in front of the lock?
st_isvalid and duplicate vertex
Using group by to set a PostGIS datasource using QGIS Python APIPostGIS Intermittent INDEX PerformanceUsing ST_MakeEnvelope over the antimeridianEmpty geometry resulting from pgrouting functionGIST slows down query?How to loop in PostGIS to add the next lat long to a routePostGIS Multipolygon when converted to shapefile doesn't match the source geometryHow can a Point NOT be Within or Touch but still Intersect a polygon?Finding Closest Point to Polyline Vertex and Apply ElevationBackup QGIS (3.2.1) layer to independent PostGIS table?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I expected to get 'false' from the following statement:
select st_isvalid(st_geomfromtext('POLYGON((0 0,10 0,10 10,10 10,0 10,0 0))'));
instead it returns true! even if the vertex in 10,10 is followed by another one with the same coordinates. Maybe I misunderstood something and/or I am making some mistake. where can I find a complete explain of that makes a geometry not valid?
postgis geometry invalid-data
New contributor
add a comment |
I expected to get 'false' from the following statement:
select st_isvalid(st_geomfromtext('POLYGON((0 0,10 0,10 10,10 10,0 10,0 0))'));
instead it returns true! even if the vertex in 10,10 is followed by another one with the same coordinates. Maybe I misunderstood something and/or I am making some mistake. where can I find a complete explain of that makes a geometry not valid?
postgis geometry invalid-data
New contributor
add a comment |
I expected to get 'false' from the following statement:
select st_isvalid(st_geomfromtext('POLYGON((0 0,10 0,10 10,10 10,0 10,0 0))'));
instead it returns true! even if the vertex in 10,10 is followed by another one with the same coordinates. Maybe I misunderstood something and/or I am making some mistake. where can I find a complete explain of that makes a geometry not valid?
postgis geometry invalid-data
New contributor
I expected to get 'false' from the following statement:
select st_isvalid(st_geomfromtext('POLYGON((0 0,10 0,10 10,10 10,0 10,0 0))'));
instead it returns true! even if the vertex in 10,10 is followed by another one with the same coordinates. Maybe I misunderstood something and/or I am making some mistake. where can I find a complete explain of that makes a geometry not valid?
postgis geometry invalid-data
postgis geometry invalid-data
New contributor
New contributor
New contributor
asked 8 hours ago
Jacopo RussoJacopo Russo
61 bronze badge
61 bronze badge
New contributor
New contributor
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
The canonical definition of geometry validity is the OGC Simple Feature Access for SQL standard.
There is also the PostGIS documentation, although it is more descriptive than formal.
In short, repeated points are valid. This is defined implicitly in the above references. It certainly wouldn't hurt to make it explicit in the PostGIS doc.
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/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
);
);
Jacopo Russo 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%2f334261%2fst-isvalid-and-duplicate-vertex%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The canonical definition of geometry validity is the OGC Simple Feature Access for SQL standard.
There is also the PostGIS documentation, although it is more descriptive than formal.
In short, repeated points are valid. This is defined implicitly in the above references. It certainly wouldn't hurt to make it explicit in the PostGIS doc.
add a comment |
The canonical definition of geometry validity is the OGC Simple Feature Access for SQL standard.
There is also the PostGIS documentation, although it is more descriptive than formal.
In short, repeated points are valid. This is defined implicitly in the above references. It certainly wouldn't hurt to make it explicit in the PostGIS doc.
add a comment |
The canonical definition of geometry validity is the OGC Simple Feature Access for SQL standard.
There is also the PostGIS documentation, although it is more descriptive than formal.
In short, repeated points are valid. This is defined implicitly in the above references. It certainly wouldn't hurt to make it explicit in the PostGIS doc.
The canonical definition of geometry validity is the OGC Simple Feature Access for SQL standard.
There is also the PostGIS documentation, although it is more descriptive than formal.
In short, repeated points are valid. This is defined implicitly in the above references. It certainly wouldn't hurt to make it explicit in the PostGIS doc.
answered 6 hours ago
dr_jtsdr_jts
1261 silver badge2 bronze badges
1261 silver badge2 bronze badges
add a comment |
add a comment |
Jacopo Russo is a new contributor. Be nice, and check out our Code of Conduct.
Jacopo Russo is a new contributor. Be nice, and check out our Code of Conduct.
Jacopo Russo is a new contributor. Be nice, and check out our Code of Conduct.
Jacopo Russo 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%2f334261%2fst-isvalid-and-duplicate-vertex%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