| 08:01:58 | hobu: | "This tickles the enterprise pink, because these sorts of developers love nothing more than hanging out around a whiteboard drawing boxes and arrows and, from time to time, writing XML to make it look like they're doing real work. Solr thrives in this environment, being an Apache Foundation project, the Apache Foundation, of course, widely known as a cruel experiment to see what happens when... |
| 08:02:00 | hobu: | ...bureaucrats do open source." |
| 08:02:07 | hobu: | http://www.theregister.co.uk/2009/05/08/dziuba_sphinx/page2.html |
| 08:02:08 | sigq: | Title: Sphinx - text search The Pirate Bay way • The Register ( at www.theregister.co.uk ) |
| 13:22:58 | epifanio: | hi All, do you know if exist a verion of the geonames files : http://download.geonames.org/export/dump/ in a "gis ready format" ? |
| 13:22:59 | sigq: | Title: GeoNames ( at download.geonames.org ) |
| 13:23:12 | epifanio: | *version |
| 13:23:36 | adamhill: | what do you mean by "GIS ready"? |
| 13:23:56 | adamhill: | KML, JSON, SHP? |
| 13:26:02 | epifanio: | yes, any of these can be good |
| 13:26:22 | epifanio: | really i'm tring to parse the text file to create a python dictionary |
| 13:28:34 | epifanio: | but the text file do not has a regular syntax, so is not so easy to parse ( for me ), maybe tring to use a gdal-ogr readable file, will be more simple to create a dict |
| 13:32:04 | adamhill: | most tutorials have you import into mysql, do you happen to be able to do that then export ( a probably very regular ) chunk of text? |
| 13:33:52 | adamhill: | someone has a MS Access DB ready to go - http://david.portabella.name/files2/geonames.mdb.zip |
| 13:36:44 | epifanio: | i'm on nix can't use acces, i'll try the db way, if problems com up i find the "postalcode" file, more simple to parse i'll try with it ( what i need si city names and relative coordinates, i don't need other data ) |
| 13:38:45 | adamhill: | there is a complete tut and scripts here - http://forum.geonames.org/gforum/posts/list/732.page |
| 13:38:46 | sigq: | Title: Importing *all* geonames tables to mysql ( at forum.geonames.org ) |
| 13:44:10 | epifanio: | adamhill: thanks!!! |
| 13:46:59 | adamhill: | google is your friend and possibly our new overlords : ) |
| 14:18:11 | epifanio: | really it is ... find postgres info too : http://forum.geonames.org/gforum/posts/list/67.page next step will be transfer the lon-lat columns to geometry colums |
| 14:18:13 | sigq: | Title: Import GeoNames dump into Postgres ( at forum.geonames.org ) |