Re: [Geoserver-users] missing geometry after create sql view
ok, so problem was in postgis, reinstall of postgis solved it. I should try it earlier. Sure, I don't know why, but I deleted table the_geom, so, as in a lot of cases, problem was between chair and PC :) Thanks all for help, I really appreciate this Dan -- View this message in context: http://osgeo-org.1560.n6.nabble.com/missing-geometry-after-create-sql-view-tp4660559p4663312.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] missing geometry after create sql view
On 28/03/12 14:18, Andrea Aime wrote: Ben, this is not required when doing a sql view, that is, configuring the sql from the GUI. Thanks, Andrea, my brain just clicked into place. sql view is an overloaded term and I should really finish my morning cup of coffee before answering email. :-) -- Ben Caradoc-Davies ben.caradoc-dav...@csiro.au Software Engineer CSIRO Earth Science and Resource Engineering Australian Resources Research Centre -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] missing geometry after create sql view
Hi all, I'm trying to create sql view from two postgis tables where first has geometry and second has not, but final layer has no geometry and no srid. I don't know, if I make mistake during create postgis table from shp, because I leave srid as -1. But this table looks normal in geoserver and it has epsg 4326. I'm using this select: select * from geometry, nogeometry where geometry.postcode=nogeometry.postcode Database are qite new from me, so maybe I'm making some mistake. Thanks for help, Dan -- View this message in context: http://osgeo-org.1560.n6.nabble.com/missing-geometry-after-create-sql-view-tp4660559p4660559.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] missing geometry after create sql view
I have tried create another view, only from one table and after this: select * from table and refreshing attributes I have not column geog in list which is in the source. So I'm confused now, should I define something in select? Thanks, Dan -- View this message in context: http://osgeo-org.1560.n6.nabble.com/missing-geometry-after-create-sql-view-tp4660559p4660731.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] missing geometry after create sql view
Ok, so if I understand well. If I use during transform shp to postgis load into geography column it will generate this problem? But problem is, that without this I can't create database, it writes that Failed in pgui_exec(): ERROR: relation geometry_columns does not exist. But I suppose, that this isn't question in geoserver forum, but postgis isn't it? :) Thanks Dan -- View this message in context: http://osgeo-org.1560.n6.nabble.com/missing-geometry-after-create-sql-view-tp4660559p4660903.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] missing geometry after create sql view
My understanding is Geoserver has support for Geometry columns but not Geography columns. For more info on the distinction, see: http://postgis.refractions.net/docs/ch04.html#PostGIS_GeographyVSGeometry Best, Steve Stephen Mather Geographic Information Systems (GIS) Manager (216) 635-3243 s...@clevelandmetroparks.com clevelandmetroparks.com -Original Message- From: vrbikdan [mailto:vrbik...@gmail.com] Sent: Tuesday, March 27, 2012 9:44 AM To: geoserver-users@lists.sourceforge.net Subject: Re: [Geoserver-users] missing geometry after create sql view Ok, so if I understand well. If I use during transform shp to postgis load into geography column it will generate this problem? But problem is, that without this I can't create database, it writes that Failed in pgui_exec(): ERROR: relation geometry_columns does not exist. But I suppose, that this isn't question in geoserver forum, but postgis isn't it? :) Thanks Dan -- View this message in context: http://osgeo-org.1560.n6.nabble.com/missing-geometry-after-create-sql-view-t p4660559p4660903.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] missing geometry after create sql view
On Tue, Mar 27, 2012 at 4:01 PM, Stephen V. Mather s...@clevelandmetroparks.com wrote: My understanding is Geoserver has support for Geometry columns but not Geography columns. For more info on the distinction, see: http://postgis.refractions.net/docs/ch04.html#PostGIS_GeographyVSGeometry Not exactly, GeoServer has full support for geography columns in tables and db level views, but they don't work in sql views you configure from the GUI Cheers Andrea -- --- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 mob:+39 339 8844549 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf --- -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] missing geometry after create sql view
Yeah, but into geometry column I can't import because of error I wrote before and it's mystery for me, why :( Thanks for link, I'll write it ;) Dan -- View this message in context: http://osgeo-org.1560.n6.nabble.com/missing-geometry-after-create-sql-view-tp4660559p4661004.html Sent from the GeoServer - User mailing list archive at Nabble.com. -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] missing geometry after create sql view
So, you could construct a functional view if you had access on the database side? http://www.clemetparks.com/images/esig/cmp-ms-90x122.pngStephen Mather Geographic Information Systems (GIS) Manager (216) 635-3243 s...@clevelandmetroparks.com http://www.clemetparks.com/ clevelandmetroparks.com From: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] On Behalf Of Andrea Aime Sent: Tuesday, March 27, 2012 10:10 AM To: s...@clevelandmetroparks.com Cc: vrbikdan; geoserver-users@lists.sourceforge.net Subject: Re: [Geoserver-users] missing geometry after create sql view On Tue, Mar 27, 2012 at 4:01 PM, Stephen V. Mather s...@clevelandmetroparks.com wrote: My understanding is Geoserver has support for Geometry columns but not Geography columns. For more info on the distinction, see: http://postgis.refractions.net/docs/ch04.html#PostGIS_GeographyVSGeometry Not exactly, GeoServer has full support for geography columns in tables and db level views, but they don't work in sql views you configure from the GUI Cheers Andrea -- --- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 mob:+39 339 8844549 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf --- image001.png-- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
