On Mon, Oct 29, 2012 at 9:10 PM, Rahkonen Jukka <[email protected]> wrote: > Hi, > > I was meaning that <ogc:PropertyName>addr:housename</ogc:PropertyName> > is not valid in the layer / feature type schema. See discussion in > http://lists.openstreetmap.org/pipermail/dev/2011-November/023664.html > > I do not know if addr:streetname works with Geoserver and WMS but with WFS it > is for sure invalid. > > Osm2pgsql does not have an option for renaming attributes. You can use "alter > table" in the database after the import or you can create a view as "select > addr:streetname AS addr_streetname". Or then you can use the new GDAL/OGR > OSM driver for the import, it applies "launder" by default. And ogr2ogr > supports also the -sql parameter which can also be used for renaming columns > and doing other stuff you can do with SQL.
Or you can use a "sql view" in GeoServer to do the renaming on the fly: http://docs.geoserver.org/stable/en/user/data/database/sqlview.html Cheers Andrea -- == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- ------------------------------------------------------------------------------ The Windows 8 Center - In partnership with Sourceforge Your idea - your app - 30 days. Get started! http://windows8center.sourceforge.net/ what-html-developers-need-to-know-about-coding-windows-8-metro-style-apps/ _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
