On 14 July 2011 17:27, George Rodrigues da Cunha Silva <[email protected]> wrote: > Em quinta-feira, 14 de julho de 2011 13:19:29, Elijah Meeks escreveu: >> Thanks so much, David, I've been digging through the PostGIS documentation >> but never could seem to figure out the language for describing where the >> issue was taking place. >> >> -Elijah >> >> ************ >> Elijah Meeks >> http://dhs.stanford.edu >> Digital Humanities Specialist >> Academic Computing Services >> Stanford University >> [email protected] >> (650)387-6170 >> >> ----- Original Message ----- >> From: "David Winslow"<[email protected]> >> To: "Elijah Meeks"<[email protected]> >> Cc: [email protected] >> Sent: Thursday, July 14, 2011 9:18:00 AM >> Subject: Re: [Geoserver-users] PostGIS Views >> >> This happens when GeoServer can't properly determine the geometry type for >> the column; it defaults to the default point style which is the most general >> (it will render centroids for polygons and midpoints for linestrings, so any >> vector data can be rendered with the point style.) If you add > "styles=polygon" to the URL for your OpenLayers preview then it should work. > You can also set this as the default in the configuration for the layer. >> >> You can look in the PostGIS manual for details on how to properly register >> your view with PostGIS to avoid this sort of issue in the future. > > I guess what David is telling you is to properly register the view in > geometry_columns table. Geoserver must use to determine what types of > geometry each table is holding. > > Try to insert a record corresponding to your view in geometry_columns > table and check if it works. > > George >
If you're on PostGIS 1.4+ you can just run "select populate_geometry_columns()" See: http://www.postgis.org/docs/Populate_Geometry_Columns.html Will Temperley ------------------------------------------------------------------------------ AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
