ST_Centroid in view produces geometry without further definition from geometry(polygon, ssid)
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 5 hours ago
JGH
12.9k21139
asked 6 hours ago
David IDavid I
365
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 5 hours ago
JGH
12.9k21139
asked 6 hours ago
David IDavid I
365
How can I find a private key from an imported wallet?
– Eric
4 hours ago
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
4 hours ago
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
4 hours ago
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
2 hours ago
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 5 hours ago
JGH
12.9k21139
asked 6 hours ago
David IDavid I
365
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 5 hours ago
JGH
12.9k21139
asked 6 hours ago
David IDavid I
365
edited 5 hours ago
JGH
12.9k21139
asked 6 hours ago
David IDavid I
365
edited 5 hours ago
JGH
12.9k21139
edited 5 hours ago
JGH
12.9k21139
edited 5 hours ago
JGH
12.9k21139
12.9k21139
asked 6 hours ago
David IDavid I
365
asked 6 hours ago
David IDavid I
365
asked 6 hours ago
David IDavid I
365
365
How can I find a private key from an imported wallet?
– Eric
4 hours ago
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
4 hours ago
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
4 hours ago
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
2 hours ago
add a comment |
How can I find a private key from an imported wallet?
– Eric
4 hours ago
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
4 hours ago
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
4 hours ago
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
2 hours ago
How can I find a private key from an imported wallet?
– Eric
4 hours ago
How can I find a private key from an imported wallet?
– Eric
4 hours ago
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
4 hours ago
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
4 hours ago
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
4 hours ago
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
4 hours ago
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
2 hours ago
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
2 hours ago
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 5 hours ago
pdavispdavis
496412
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 5 hours ago
pdavispdavis
496412
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 5 hours ago
pdavispdavis
496412
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 5 hours ago
pdavispdavis
496412
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 5 hours ago
pdavispdavis
496412
answered 5 hours ago
pdavispdavis
496412
answered 5 hours ago
pdavispdavis
496412
answered 5 hours ago
pdavispdavis
496412
496412
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
4 hours ago
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
4 hours ago
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
4 hours ago
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
2 hours ago