Basic ideas for identifying geometry columns
- WKT is easy enough to identify (try parsing each entry as WKT)
- lat/lon will have to do a header check (and maybe a bounds check?) on
any numeric columns; latlong strategy defines several potential header names
- x/y is similar to lat/long, but can skip the bounds check. Will need
to ask the user to specify a crs here
Regardless of what is guessed as the geom colum, will probably want to
provide the ability for the user to verify this throught the importer.
Still thinking about what to do when there are multiple possible matches;
probably have to leave it up to the user at this point.
We can then assign a CSV strategy and parse into a data store.
Torben
On Thu, Mar 19, 2015 at 9:50 AM, Jody Garnett <[email protected]>
wrote:
> So perhaps do a good guess at the correct CSV strategy (it may be obvious
> in the case of a WKT column) and then only fall back in cases where it is
> not decisive.
>
> --
> Jody Garnett
>
> On 19 March 2015 at 09:10, Andrea Aime <[email protected]>
> wrote:
>
>> On Thu, Mar 19, 2015 at 12:46 AM, Torben Barsballe <
>> [email protected]> wrote:
>>
>>> A few options are available:
>>>
>>> - Create a new CSV strategy that tries to guess spatial columns
>>> - If any columns are named lat / lattitude or lng / long /
>>> longitude, use a LatLong strategy.
>>> - If any columns can be parsed as WKT, use a WKT strategy
>>>
>>>
>> For the record, in order to import GML we parse the input up to 3 times,
>> once to determine the gml version
>> (a difference between GML2 and GML3.1 can only be spotted by checking
>> which xml elements are in use, gml 3.2 thankfully uses a different
>> namespace), once to determine the crs and geometry type, and _finally_ once
>> to actually parse the file.
>> Annoying, but imports are one-off businesses, so I guess having them
>> slower than they could be is not as bad as having slow OGC service code.
>>
>> Cheers
>> Andrea
>>
>> --
>> ==
>> GeoServer Professional Services from the experts! Visit
>> http://goo.gl/NWWaa2 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
>>
>> *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*
>>
>> Le informazioni contenute in questo messaggio di posta elettronica e/o
>> nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
>> loro utilizzo è consentito esclusivamente al destinatario del messaggio,
>> per le finalità indicate nel messaggio stesso. Qualora riceviate questo
>> messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
>> darcene notizia via e-mail e di procedere alla distruzione del messaggio
>> stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
>> divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
>> utilizzarlo per finalità diverse, costituisce comportamento contrario ai
>> principi dettati dal D.Lgs. 196/2003.
>>
>>
>>
>> The information in this message and/or attachments, is intended solely
>> for the attention and use of the named addressee(s) and may be confidential
>> or proprietary in nature or covered by the provisions of privacy act
>> (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
>> Code).Any use not in accord with its purpose, any disclosure, reproduction,
>> copying, distribution, or either dissemination, either whole or partial, is
>> strictly forbidden except previous formal approval of the named
>> addressee(s). If you are not the intended recipient, please contact
>> immediately the sender by telephone, fax or e-mail and delete the
>> information in this message that has been received in error. The sender
>> does not give any warranty or accept liability as the content, accuracy or
>> completeness of sent messages and accepts no responsibility for changes
>> made after they were sent or for other risks which arise as a result of
>> e-mail transmission, viruses, etc.
>>
>> -------------------------------------------------------
>>
>>
>> ------------------------------------------------------------------------------
>> Dive into the World of Parallel Programming The Go Parallel Website,
>> sponsored
>> by Intel and developed in partnership with Slashdot Media, is your hub
>> for all
>> things parallel software development, from weekly thought leadership
>> blogs to
>> news, videos, case studies, tutorials and more. Take a look and join the
>> conversation now. http://goparallel.sourceforge.net/
>> _______________________________________________
>> Geoserver-devel mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/geoserver-devel
>>
>>
>
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
