[fdo-users] Re: OSM shape file limitations using with FDO due to : in column names

Greg Boone greg.boone at autodesk.com
Thu Jan 6 16:02:39 EST 2011


I notice that the only file in this data set that has problems loading is the location data (victoria_location.shp). 

I can take a look to see if something can be done here, but it may not be a trivial change.

Greg

-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Zac Spitzer
Sent: Thursday, January 06, 2011 2:48 AM
To: FDO Users Mail List
Subject: [fdo-users] Re: OSM shape file limitations using with FDO due to : in column names

the PostgreSQL FDO provider is already doing such remapping

On Thu, Jan 6, 2011 at 6:45 PM, Zac Spitzer <zac.spitzer at gmail.com> wrote:
> I've been playing around with some of the OSM shape file exports
>
> http://downloads.cloudmade.com/oceania/australia/victoria
>
> alas, FDO doesn't like the some of column conventions used
>
>  Error: An exception occurred in FDO component.
>        Invalid Feature schema element name 'ADDR:CITY'; must not contain ':'
>
> which is because the feature class used : as a delimiter
>
> as OSM data is pretty common and getting more and more popular,
> would it be possible to remap those : characters to something else ie "_"
> rather than just throwing an error and failing ?
>
> i doubt many shape files have identical column names which only differ
> between ":" and "_"
>
> even without remapping, it would be nice if such incompatible columns could
> just be ignored in the interim
>
>
> z
>
>
>
>
>
>
>
>
> --
> Zac Spitzer
> Solution Architect / Director
> Ennoble Consultancy Australia
> http://www.ennoble.com.au
> http://zacster.blogspot.com
> +61 405 847 168
>



-- 
Zac Spitzer
Solution Architect / Director
Ennoble Consultancy Australia
http://www.ennoble.com.au
http://zacster.blogspot.com
+61 405 847 168
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users


More information about the fdo-users mailing list