ST_Centroid in view produces geometry without further definition from geometry(polygon, ssid)
Clash Royale CLAN TAG#URR8PPP
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I'm a Postgresql novice.
In a postgresql 9.2 + PostGIS instance I have one table with a geometry(polygon, ssid) column. From this table I am trying to create a view using ST_Centroid like so:
CREATE OR REPLACE VIEW schema.polys_points AS
SELECT poly_table.name,
ST_Centroid(geom) as geom
FROM poly_table;
This produces a view with a geometry() column where I would like it defined as geometry(point, ssid) column. Is this possible?
postgis-2.0
edited Mar 11 at 17:45
JGH
13.5k21139
asked Mar 11 at 16:46
David IDavid I
437
add a comment |
I'm a Postgresql novice.
In a postgresql 9.2 + PostGIS instance I have one table with a geometry(polygon, ssid) column. From this table I am trying to create a view using ST_Centroid like so:
CREATE OR REPLACE VIEW schema.polys_points AS
SELECT poly_table.name,
ST_Centroid(geom) as geom
FROM poly_table;
This produces a view with a geometry() column where I would like it defined as geometry(point, ssid) column. Is this possible?
postgis-2.0
edited Mar 11 at 17:45
JGH
13.5k21139
asked Mar 11 at 16:46
David IDavid I
437
How can I find a private key from an imported wallet?
– Eric
Mar 11 at 18:03
If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context. - From Review
– aldo_tapia
Mar 11 at 18:23
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– Jochen Schwarze
Mar 11 at 18:31
This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review
– Vince
Mar 11 at 20:38
add a comment |
I'm a Postgresql novice.
In a postgresql 9.2 + PostGIS instance I have one table with a geometry(polygon, ssid) column. From this table I am trying to create a view using ST_Centroid like so:
CREATE OR REPLACE VIEW schema.polys_points AS
SELECT poly_table.name,
ST_Centroid(geom) as geom
FROM poly_table;
This produces a view with a geometry() column where I would like it defined as geometry(point, ssid) column. Is this possible?
postgis-2.0
edited Mar 11 at 17:45
JGH
13.5k21139
asked Mar 11 at 16:46
David IDavid I
437
I'm a Postgresql novice.
In a postgresql 9.2 + PostGIS instance I have one table with a geometry(polygon, ssid) column. From this table I am trying to create a view using ST_Centroid like so:
CREATE OR REPLACE VIEW schema.polys_points AS
SELECT poly_table.name,
ST_Centroid(geom) as geom
FROM poly_table;
This produces a view with a geometry() column where I would like it defined as geometry(point, ssid) column. Is this possible?
postgis-2.0
postgis-2.0
edited Mar 11 at 17:45
JGH
13.5k21139
asked Mar 11 at 16:46
David IDavid I
437
edited Mar 11 at 17:45
JGH
13.5k21139
asked Mar 11 at 16:46
David IDavid I
437
edited Mar 11 at 17:45
JGH
13.5k21139
edited Mar 11 at 17:45
JGH
13.5k21139
edited Mar 11 at 17:45
JGH
13.5k21139
13.5k21139
asked Mar 11 at 16:46
David IDavid I
437
asked Mar 11 at 16:46
David IDavid I
437
asked Mar 11 at 16:46
David IDavid I
437
437
How can I find a private key from an imported wallet?
– Eric
Mar 11 at 18:03
If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context. - From Review
– aldo_tapia
Mar 11 at 18:23
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– Jochen Schwarze
Mar 11 at 18:31
This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review
– Vince
Mar 11 at 20:38
add a comment |
How can I find a private key from an imported wallet?
– Eric
Mar 11 at 18:03
If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context. - From Review
– aldo_tapia
Mar 11 at 18:23
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– Jochen Schwarze
Mar 11 at 18:31
This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review
– Vince
Mar 11 at 20:38
How can I find a private key from an imported wallet?
– Eric
Mar 11 at 18:03
How can I find a private key from an imported wallet?
– Eric
Mar 11 at 18:03
If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context. - From Review
– aldo_tapia
Mar 11 at 18:23
If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context. - From Review
– aldo_tapia
Mar 11 at 18:23
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– Jochen Schwarze
Mar 11 at 18:31
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– Jochen Schwarze
Mar 11 at 18:31
This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review
– Vince
Mar 11 at 20:38
This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review
– Vince
Mar 11 at 20:38
add a comment |
1 Answer
1
active
oldest
votes
Yes, this is possible but you can't do it after the view is created. Normally, the view would just inherit the geom constraints from the source table, but since you are changing the geom from polygon to point in your query, it won't automatically register. You just need to add typemods to your geom column within the view definition:
create or replace view schema.polys_points as
select poly_table.name, ST_Centroid(geom)::geometry(POINT, SRID) as geom
from poly_table;
answered Mar 11 at 17:12
pdavispdavis
5261413
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
);
);
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%2f315103%2fst-centroid-in-view-produces-geometry-without-further-definition-from-geometryp%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
Yes, this is possible but you can't do it after the view is created. Normally, the view would just inherit the geom constraints from the source table, but since you are changing the geom from polygon to point in your query, it won't automatically register. You just need to add typemods to your geom column within the view definition:
create or replace view schema.polys_points as
select poly_table.name, ST_Centroid(geom)::geometry(POINT, SRID) as geom
from poly_table;
answered Mar 11 at 17:12
pdavispdavis
5261413
add a comment |
Yes, this is possible but you can't do it after the view is created. Normally, the view would just inherit the geom constraints from the source table, but since you are changing the geom from polygon to point in your query, it won't automatically register. You just need to add typemods to your geom column within the view definition:
create or replace view schema.polys_points as
select poly_table.name, ST_Centroid(geom)::geometry(POINT, SRID) as geom
from poly_table;
answered Mar 11 at 17:12
pdavispdavis
5261413
add a comment |
Yes, this is possible but you can't do it after the view is created. Normally, the view would just inherit the geom constraints from the source table, but since you are changing the geom from polygon to point in your query, it won't automatically register. You just need to add typemods to your geom column within the view definition:
create or replace view schema.polys_points as
select poly_table.name, ST_Centroid(geom)::geometry(POINT, SRID) as geom
from poly_table;
answered Mar 11 at 17:12
pdavispdavis
5261413
Yes, this is possible but you can't do it after the view is created. Normally, the view would just inherit the geom constraints from the source table, but since you are changing the geom from polygon to point in your query, it won't automatically register. You just need to add typemods to your geom column within the view definition:
create or replace view schema.polys_points as
select poly_table.name, ST_Centroid(geom)::geometry(POINT, SRID) as geom
from poly_table;
answered Mar 11 at 17:12
pdavispdavis
5261413
answered Mar 11 at 17:12
pdavispdavis
5261413
answered Mar 11 at 17:12
pdavispdavis
5261413
answered Mar 11 at 17:12
pdavispdavis
5261413
5261413
add a comment |
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%2f315103%2fst-centroid-in-view-produces-geometry-without-further-definition-from-geometryp%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
How can I find a private key from an imported wallet?
– Eric
Mar 11 at 18:03
If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context. - From Review
– aldo_tapia
Mar 11 at 18:23
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– Jochen Schwarze
Mar 11 at 18:31
This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review
– Vince
Mar 11 at 20:38