Re: [udig-devel] Import txt, csv or xml

[Jesse Eichar <jeichar@xxxxxxxxxxxxxxx>]

Could you give me a few more details about the CSV format?  Would it be

10,10,attribute1value,attribute2value
20,10,attribute1value2,attribute2value2


something like that?

Would the properties based format work for you? It more or less looks  
like:

_=geom:Polygon,id:Integer,name:String
fid1=10,30,40,50,10,30|id1|firstFeature
fid2=0,0,40,50,0,0|id2|secondFeature

Jesse

On Mar 27, 2007, at 5:53 PM, Alan WILLMORE wrote:

> Hi Jesse,
>
> Thanks for the reply.
>
> I am evaluating and considering the utility of a number of free  
> desktop
> GIS software tools for deployment within the NSW Department of  
> Health. I
> consider the ability to import textual data containing geographic
> variables (e.g. lat/long, postcode, etc) as a critical component of  
> the
> selected software. Users will want to import geocoded address data, as
> well as aggregated statistics with geographic identifiers (e.g.
> postcode) that can then be merged with the spatial datasets to create
> thematic maps. Most NSW Health staff are able to output data in CSV
> format and would be immediately able to work with this format in a  
> GIS.
> Requiring users to create GML formatted data would just not work  
> within
> our department.
>
> Can you advise if this development is likely to occur, and if "yes",
> the timeframe for such development ?
>
> I sincerely hope that such development is in the short-term framework
> as I am impressed with uDig and would like to recommend it's use
> internally.
>
> Regards,
> Alan
>
>
>
> Hi currently we only support GML and other standard formats for
> importing data.  But we don't have that functionality...  We really
> should and it would be stupidly simple to do so.  Especially since
> there is a format in geotools that can do this almost directly.  The
> job for this is at most a couple days of work... Probably less.
>
> Jesse
>
>
> 	
> On Mar 26, 2007, at 5:45 PM, Alan WILLMORE wrote:
>
> > Hi,
> >
> > I am just starting to play with uDig v1.1-RC9, which looks like
> being
> > a
> > terrific resource.
> >
> > I have a simple question on importing text data (csv, txt, xml)
> which
> > I
> > haven't been able to find in the documentation, and I started
> looking
> > through the monthly archives but it was too laborious. So sorry if
> > this
> > has already been covered.
> >
> > I would like to import a csv or txt file of point data containing,
> > amongst other variables, latitude and longitude. The import wizard
> > only
> > offers xml and gml through the "Files" Data Sources. I converted my
> > csv
> > file to a simple xml file but when I select it for import the next
> > screen has "Files. Open one or more files" but there is nothing to
> > select and I can't progress.
> >
> > I would appreciate any advice from the user group.
> >
> > Also, when I try and access the help pages at
> > http://udig.refractions.net/help I get the following error:
> >
> > Bad Gateway
> > The proxy server received an invalid response from an upstream
> server.
> > Regards,
> > Alan Willmore
>
>
> Disclaimer: This message is intended for the addressee named and may
> contain confidential information. If you are not the intended
> recipient, please delete it and notify the sender. Views
> expressed in this message are those of the individual sender,
> and are not necessarily the views of NSW Health.
>
> ______________________________________________________________________
> This email has been scanned for the NSW Department of Health by the  
> MessageLabs Email Security System. The Department regularly  
> monitors emails and attachments to ensure compliance with its  
> Electronic Messaging Policy.
> _____________________________________________________________________
> _______________________________________________
> User-friendly Desktop Internet GIS (uDig)
> http://udig.refractions.net
> http://lists.refractions.net/mailman/listinfo/udig-devel