ST_Centroid in view produces geometry without further definition from geometry(polygon, ssid)












1















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?










share|improve this question

























  • 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
    3 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
    3 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
    1 hour ago
















1















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?










share|improve this question

























  • 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
    3 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
    3 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
    1 hour ago














1












1








1








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?










share|improve this question
















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 4 hours ago









JGH

12.9k21139




12.9k21139










asked 5 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
    3 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
    3 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
    1 hour 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
    3 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
    3 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
    1 hour 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
3 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
3 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
3 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
3 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
1 hour 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
1 hour ago










1 Answer
1






active

oldest

votes


















3














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;





share|improve this answer























    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
    });


    }
    });














    draft saved

    draft discarded


















    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









    3














    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;





    share|improve this answer




























      3














      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;





      share|improve this answer


























        3












        3








        3







        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;





        share|improve this answer













        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;






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered 4 hours ago









        pdavispdavis

        496412




        496412






























            draft saved

            draft discarded




















































            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.




            draft saved


            draft discarded














            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





















































            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







            Popular posts from this blog

            Plaza Victoria

            Puebla de Zaragoza

            Musa