PostGIS Update parse error – invalid geometry The Next CEO of Stack OverflowInvalid Geometry...
Which one is the true statement?
Can someone explain this formula for calculating Manhattan distance?
Why the last AS PATH item always is `I` or `?`?
Traduction de « Life is a roller coaster »
How to use ReplaceAll on an expression that contains a rule
If Nick Fury and Coulson already knew about aliens (Kree and Skrull) why did they wait until Thor's appearance to start making weapons?
How to get the last not-null value in an ordered column of a huge table?
Is it correct to say moon starry nights?
How to properly draw diagonal line while using multicolumn inside tabular environment?
Why doesn't UK go for the same deal Japan has with EU to resolve Brexit?
Is there a way to save my career from absolute disaster?
What was Carter Burkes job for "the company" in "Aliens"?
Is it okay to majorly distort historical facts while writing a fiction story?
Is French Guiana a (hard) EU border?
Prepend last line of stdin to entire stdin
How to set page number in right side in chapter title page?
Is there an equivalent of cd - for cp or mv
Is it professional to write unrelated content in an almost-empty email?
Iterate through multiline string line by line
What happened in Rome, when the western empire "fell"?
Aggressive Under-Indexing and no data for missing index
Computationally populating tables with probability data
Decide between Polyglossia and Babel for LuaLaTeX in 2019
Is it ever safe to open a suspicious HTML file (e.g. email attachment)?
PostGIS Update parse error – invalid geometry
The Next CEO of Stack OverflowInvalid Geometry Error after ST_ConvexHullPostGIS: parse geometry wkb with OGRPostgis 2.1 error after updateInvalid join selectivity error in postgis 2.1.3postgis update multipolygon with st_makevalid() gives errorGeojson in postgis Geometry : Z dimension errorError parsing GeoJson - parse error - invalid geometryInvalid Geometry in PostGIS but Valid in FGDBPostGIS ST_AsGeoJson makes geometry invalidERROR: parse error - invalid geometry (Postgis)
I’m trying to update geometry table using the following command but get
parse error – invalid geometry
HINT: “MULTIPOINT(“ <-- parse error at position 11 within geometry
Update geo_table
Set geom =ST_ConvexHull(
ST_GeomFromText('MULTIPOINT(co_ord_string)', 4326));
WHERE
Id =1234;
originally I created this data with a perl script something like
insert into geo_table (stuff,date, co_ord_string,geom) values (‘Hello’,’02-07-2018 00:00:00’, T_ConvexHull(ST_GeomFromText('MULTIPOINT($co_ord_string)', 4326));
The co_ord_string is a series of long lat points separated by a comma.
These don’t create perfect polygons as they may contain internal points but using ST_ConvexHull a polygon is created
only by viewing the data in Qgis I can see there are errors in the original coordinates that need manually editing (Missing minus signs some points or other issues ) and the geometry recreating
Could someone help with the syntex
postgis
asked Jul 2 '18 at 18:29
HollyHolly
186514
bumped to the homepage by Community♦ 36 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I’m trying to update geometry table using the following command but get
parse error – invalid geometry
HINT: “MULTIPOINT(“ <-- parse error at position 11 within geometry
Update geo_table
Set geom =ST_ConvexHull(
ST_GeomFromText('MULTIPOINT(co_ord_string)', 4326));
WHERE
Id =1234;
originally I created this data with a perl script something like
insert into geo_table (stuff,date, co_ord_string,geom) values (‘Hello’,’02-07-2018 00:00:00’, T_ConvexHull(ST_GeomFromText('MULTIPOINT($co_ord_string)', 4326));
The co_ord_string is a series of long lat points separated by a comma.
These don’t create perfect polygons as they may contain internal points but using ST_ConvexHull a polygon is created
only by viewing the data in Qgis I can see there are errors in the original coordinates that need manually editing (Missing minus signs some points or other issues ) and the geometry recreating
Could someone help with the syntex
postgis
asked Jul 2 '18 at 18:29
HollyHolly
186514
bumped to the homepage by Community♦ 36 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
What is in coordstring?
– Ian Turton♦
Jul 3 '18 at 7:16
“MULTIPOINT(“,‘Hello’These are not ASCII quotes. Did you copy/paste everything correctly into this question?
– CL.
Jul 3 '18 at 11:16
@Ian Turton co_ord_string is the column name containing a list of Long Lat points separated by a comma. If this value is manually copied the query works.
– Holly
Jul 4 '18 at 17:47
@CL the Non ASCII Quotes are due to having to email question home in order to post I forgot to replace them sorry
– Holly
Jul 4 '18 at 17:48
add a comment |
I’m trying to update geometry table using the following command but get
parse error – invalid geometry
HINT: “MULTIPOINT(“ <-- parse error at position 11 within geometry
Update geo_table
Set geom =ST_ConvexHull(
ST_GeomFromText('MULTIPOINT(co_ord_string)', 4326));
WHERE
Id =1234;
originally I created this data with a perl script something like
insert into geo_table (stuff,date, co_ord_string,geom) values (‘Hello’,’02-07-2018 00:00:00’, T_ConvexHull(ST_GeomFromText('MULTIPOINT($co_ord_string)', 4326));
The co_ord_string is a series of long lat points separated by a comma.
These don’t create perfect polygons as they may contain internal points but using ST_ConvexHull a polygon is created
only by viewing the data in Qgis I can see there are errors in the original coordinates that need manually editing (Missing minus signs some points or other issues ) and the geometry recreating
Could someone help with the syntex
postgis
asked Jul 2 '18 at 18:29
HollyHolly
186514
I’m trying to update geometry table using the following command but get
parse error – invalid geometry
HINT: “MULTIPOINT(“ <-- parse error at position 11 within geometry
Update geo_table
Set geom =ST_ConvexHull(
ST_GeomFromText('MULTIPOINT(co_ord_string)', 4326));
WHERE
Id =1234;
originally I created this data with a perl script something like
insert into geo_table (stuff,date, co_ord_string,geom) values (‘Hello’,’02-07-2018 00:00:00’, T_ConvexHull(ST_GeomFromText('MULTIPOINT($co_ord_string)', 4326));
The co_ord_string is a series of long lat points separated by a comma.
These don’t create perfect polygons as they may contain internal points but using ST_ConvexHull a polygon is created
only by viewing the data in Qgis I can see there are errors in the original coordinates that need manually editing (Missing minus signs some points or other issues ) and the geometry recreating
Could someone help with the syntex
postgis
postgis
asked Jul 2 '18 at 18:29
HollyHolly
186514
asked Jul 2 '18 at 18:29
HollyHolly
186514
asked Jul 2 '18 at 18:29
HollyHolly
186514
asked Jul 2 '18 at 18:29
HollyHolly
186514
asked Jul 2 '18 at 18:29
HollyHolly
186514
186514
bumped to the homepage by Community♦ 36 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 36 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
What is in coordstring?
– Ian Turton♦
Jul 3 '18 at 7:16
“MULTIPOINT(“,‘Hello’These are not ASCII quotes. Did you copy/paste everything correctly into this question?
– CL.
Jul 3 '18 at 11:16
@Ian Turton co_ord_string is the column name containing a list of Long Lat points separated by a comma. If this value is manually copied the query works.
– Holly
Jul 4 '18 at 17:47
@CL the Non ASCII Quotes are due to having to email question home in order to post I forgot to replace them sorry
– Holly
Jul 4 '18 at 17:48
add a comment |
What is in coordstring?
– Ian Turton♦
Jul 3 '18 at 7:16
“MULTIPOINT(“,‘Hello’These are not ASCII quotes. Did you copy/paste everything correctly into this question?
– CL.
Jul 3 '18 at 11:16
@Ian Turton co_ord_string is the column name containing a list of Long Lat points separated by a comma. If this value is manually copied the query works.
– Holly
Jul 4 '18 at 17:47
@CL the Non ASCII Quotes are due to having to email question home in order to post I forgot to replace them sorry
– Holly
Jul 4 '18 at 17:48
What is in coordstring?
– Ian Turton♦
Jul 3 '18 at 7:16
What is in coordstring?
– Ian Turton♦
Jul 3 '18 at 7:16
“MULTIPOINT(“, ‘Hello’ These are not ASCII quotes. Did you copy/paste everything correctly into this question?– CL.
Jul 3 '18 at 11:16
“MULTIPOINT(“, ‘Hello’ These are not ASCII quotes. Did you copy/paste everything correctly into this question?– CL.
Jul 3 '18 at 11:16
@Ian Turton co_ord_string is the column name containing a list of Long Lat points separated by a comma. If this value is manually copied the query works.
– Holly
Jul 4 '18 at 17:47
@Ian Turton co_ord_string is the column name containing a list of Long Lat points separated by a comma. If this value is manually copied the query works.
– Holly
Jul 4 '18 at 17:47
@CL the Non ASCII Quotes are due to having to email question home in order to post I forgot to replace them sorry
– Holly
Jul 4 '18 at 17:48
@CL the Non ASCII Quotes are due to having to email question home in order to post I forgot to replace them sorry
– Holly
Jul 4 '18 at 17:48
add a comment |
1 Answer
1
active
oldest
votes
I found out how to do this by concatenating the query so it gets the values from the database object co_ord_string
UPDATE geo_table
SET geom =ST_ConvexHull(
ST_GeomFromText('MULTIPOINT(' || co_ord_string|| ')', 4326)
);
WHERE Id =1234;
Maybe this will help others
answered Jul 8 '18 at 17:48
HollyHolly
186514
You can accept your own answer with the checkbox
– BERA
Aug 9 '18 at 9:03
add a comment |
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
});
}
});
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%2f288214%2fpostgis-update-parse-error-invalid-geometry%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
I found out how to do this by concatenating the query so it gets the values from the database object co_ord_string
UPDATE geo_table
SET geom =ST_ConvexHull(
ST_GeomFromText('MULTIPOINT(' || co_ord_string|| ')', 4326)
);
WHERE Id =1234;
Maybe this will help others
answered Jul 8 '18 at 17:48
HollyHolly
186514
You can accept your own answer with the checkbox
– BERA
Aug 9 '18 at 9:03
add a comment |
I found out how to do this by concatenating the query so it gets the values from the database object co_ord_string
UPDATE geo_table
SET geom =ST_ConvexHull(
ST_GeomFromText('MULTIPOINT(' || co_ord_string|| ')', 4326)
);
WHERE Id =1234;
Maybe this will help others
answered Jul 8 '18 at 17:48
HollyHolly
186514
You can accept your own answer with the checkbox
– BERA
Aug 9 '18 at 9:03
add a comment |
I found out how to do this by concatenating the query so it gets the values from the database object co_ord_string
UPDATE geo_table
SET geom =ST_ConvexHull(
ST_GeomFromText('MULTIPOINT(' || co_ord_string|| ')', 4326)
);
WHERE Id =1234;
Maybe this will help others
answered Jul 8 '18 at 17:48
HollyHolly
186514
I found out how to do this by concatenating the query so it gets the values from the database object co_ord_string
UPDATE geo_table
SET geom =ST_ConvexHull(
ST_GeomFromText('MULTIPOINT(' || co_ord_string|| ')', 4326)
);
WHERE Id =1234;
Maybe this will help others
answered Jul 8 '18 at 17:48
HollyHolly
186514
answered Jul 8 '18 at 17:48
HollyHolly
186514
answered Jul 8 '18 at 17:48
HollyHolly
186514
answered Jul 8 '18 at 17:48
HollyHolly
186514
186514
You can accept your own answer with the checkbox
– BERA
Aug 9 '18 at 9:03
add a comment |
You can accept your own answer with the checkbox
– BERA
Aug 9 '18 at 9:03
You can accept your own answer with the checkbox
– BERA
Aug 9 '18 at 9:03
You can accept your own answer with the checkbox
– BERA
Aug 9 '18 at 9:03
add a comment |
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%2f288214%2fpostgis-update-parse-error-invalid-geometry%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
What is in coordstring?
– Ian Turton♦
Jul 3 '18 at 7:16
“MULTIPOINT(“,‘Hello’These are not ASCII quotes. Did you copy/paste everything correctly into this question?– CL.
Jul 3 '18 at 11:16
@Ian Turton co_ord_string is the column name containing a list of Long Lat points separated by a comma. If this value is manually copied the query works.
– Holly
Jul 4 '18 at 17:47
@CL the Non ASCII Quotes are due to having to email question home in order to post I forgot to replace them sorry
– Holly
Jul 4 '18 at 17:48