[OSGeo-Discuss] Event: III Jornadas de SIG Libre en Girona, Marzo de 2009
Dear colleagues, SORRY for the cross-postings: Maybe you or someone in your team can be interested in the III FOSS for GIS Spanish meeting that will be held on Girona (Spain) from 11th to 13th of March 2009. All available information concerning to the planned plenary sessions [1] and workshops [2], can be accessed in the website. Note that Spanish is the official language of the meeting but English papers and presentations will also be accepted. The registration process is open now [3] We encourage you to send your abstracts (300 words max.) to [EMAIL PROTECTED] if you are interested to participate in the event with a presentation Important deadlines to remember: For Papers Abstract reception deadlines: 10th November 2008 Full paper reception deadline: 6th February 2009 For Registration Early registration: until 15th December 2008 Late registration: from 16th December 2008 to 17th February 2009 For any doubt or comment, please don't hesitate to contact us on [EMAIL PROTECTED] Best regards, Lluís [1] http://www.sigte.udg.es/jornadassiglibre/index.php?page=jornadas [2] http://www.sigte.udg.es/jornadassiglibre/index.php?page=talleres [3] http://www.sigte.udg.es/jornadassiglibre/index.php?page=inscripcion = Lluís Vicens SIGTE - Universitat de Girona Pl. Ferrater Mora, 1 17071 Girona email: [EMAIL PROTECTED] T:(34) 972 418 039 = ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
RE: [OSGeo-Discuss] methods for programatically adding fields toshapefiles
Tyler, Here is a link to some python code that I wrote to read a delimited text file and write out a shapefile. It uses the ogr and osr python modules. The code is not particularly clean or efficient, but it does include the case of creating a shapefile, creating columns, and populating the columns. http://code.google.com/p/flatlandmaps/source/browse/trunk/csv2shp.py You can email me directly if you have any questions about how it works. David. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tyler Erickson Sent: Wednesday, October 29, 2008 4:49 PM To: discuss@lists.osgeo.org Subject: [OSGeo-Discuss] methods for programatically adding fields toshapefiles I am interested in approaches for adding a populated field to a shapefile (for example, adding a new field named 'source_url' with the value 'http://somewebsite.com'). I would like to do this for several thousand files. At first I thought that I might be able to accomplish it using ogr2org with a sql clause, such as: ogr2ogr -sql select *, 'http://somewebsite.com' as source_url from infile outfile.shp infile.shp but that didn't work since ogr2ogr supports a limited set of SQL, described at: http://www.gdal.org/ogr/ogr_sql.html Any ideas on how to accomplish this? (I would prefer suggestions that can be scripted with python.) - Tyler -- View this message in context: http://n2.nabble.com/methods-for-programatically-adding-fields-to-shapef iles-tp1395535p1395535.html Sent from the OSGeo Discuss mailing list archive at Nabble.com. ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
[OSGeo-Discuss] Re: Raster data on RDBMS
Dear all I would like to take a broader view of the issue of raster data in a DBMS. Issues of performance are relevant, but the benefits of having raster data on a DBMS are much more important. Consider that raster sensors and grid models are by far the dominant source of new geospatial data. If FOOS4G solutions do not include the capability of handling raster data in a DBMS, they would be lacking in functionality compared to commercial solutions from Oracle and ESRI. INPE´s FOSS4G developement of raster data on RDBMS using the TerraLib library is a tangible proof of concept. TerraAmazon (built using TerraLib) is INPE's OS solution for monitoring tropical forests operationally. The application was described in a recent article on the OSGEO journal, and it is arguably one of the biggest geospatial databases built using FOSS4G. Hundreds of images and hundreds of thousands of polygons are used operationally in Brazil´s real-time monitoring of deforestation. We hope our example helps to convince the community that we should not waste time arguing that we shouldn't store raster data in DBMS. FOOS4G needs this capability. Better yet, we already HAVE this capability on a production level. Best Regards Gilberto -- === Dr.Gilberto Camara Director General National Institute for Space Research (INPE) Sao Jose dos Campos, Brazil voice: +55-12-3945-6035 fax: +55-12-3921-6455 web: http://www.dpi.inpe.br/gilberto blog: http://techne-episteme.blogspot.com/ ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] Re: Raster data on RDBMS
On Thu, Oct 30, 2008 at 5:25 PM, Gilberto Camara [EMAIL PROTECTED] wrote: but the benefits of having raster data on a DBMS are much more important. And those benefits are? ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] Re: Raster data on RDBMS
Paul, That is not the answer your are waiting for but... IMHO, once you overcome the mythical concept that a database server will always perform slower than a direct file access then Spatial is not special anymore! [who said that?] and you can think on the benefits just like a banker or an accounting bureau. Database servers in general are capable of making a good use of the available resources. For raster what is needed is a good BLOB support with cursor preferably. Spatial extension and schemas are indispensable accessories, they should provide metadata, georeferences definition, spatial indexation, etc. but they should not drag down the performance. Just my two cents. Ivan ---Original Message--- From: Paul Ramsey [EMAIL PROTECTED] Subject: Re: [OSGeo-Discuss] Re: Raster data on RDBMS Sent: Oct 31 '08 02:11 On Thu, Oct 30, 2008 at 5:25 PM, Gilberto Camara [EMAIL PROTECTED] wrote: but the benefits of having raster data on a DBMS are much more important. And those benefits are? ___ Discuss mailing list [EMAIL PROTECTED] http://lists.osgeo.org/mailman/listinfo/discuss ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss