RE: [OSGeo-Discuss] Shapefile's dfb editing
Silvia, I am surprised that Open Office couldn't open the DBF. Most open source desktop GIS programs like OpenJUMP can open and edit the attributes of Shapefile. Is that an option? If not, you could send me the file and I could see if I could open it in Microsoft Excel. Landon Office Phone Number: (209) 946-0268 Cell Phone Number: (209) 992-0658 -Original Message- From: discuss-boun...@lists.osgeo.org [mailto:discuss-boun...@lists.osgeo.org] On Behalf Of Silvia Franceschi Sent: Friday, December 12, 2008 8:12 AM To: discuss@lists.osgeo.org Subject: [OSGeo-Discuss] Shapefile's dfb editing Hi all, do some of you know how to edit a shapefile's dbf file? I tried with OpenOffice Calc but I have the following error: Connection to file could not be established I have to add some attribute that I have in an other file and they are a lot of data. Thanks in advance for help Silvia ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss Warning: Information provided via electronic media is not guaranteed against defects including translation and transmission errors. If the reader is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this information in error, please notify the sender immediately. ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] Shapefile's dfb editing
I don't know if this would matter but file name length could be something to look at. Some dbf files that open in Excel won't open in Access unless renamed to 8 (I think) characters or less. Maybe if you rename it shorter and try it might work. Definitely be careful with a live shapefile dbf though - you should probably rename the shapefile to a shorter name and then try to open the dbf again. Nif On Fri, Dec 12, 2008 at 12:17 PM, Landon Blake lbl...@ksninc.com wrote: Silvia, I am surprised that Open Office couldn't open the DBF. Most open source desktop GIS programs like OpenJUMP can open and edit the attributes of Shapefile. Is that an option? If not, you could send me the file and I could see if I could open it in Microsoft Excel. Landon Office Phone Number: (209) 946-0268 Cell Phone Number: (209) 992-0658 -Original Message- From: discuss-boun...@lists.osgeo.org [mailto:discuss-boun...@lists.osgeo.org] On Behalf Of Silvia Franceschi Sent: Friday, December 12, 2008 8:12 AM To: discuss@lists.osgeo.org Subject: [OSGeo-Discuss] Shapefile's dfb editing Hi all, do some of you know how to edit a shapefile's dbf file? I tried with OpenOffice Calc but I have the following error: Connection to file could not be established I have to add some attribute that I have in an other file and they are a lot of data. Thanks in advance for help Silvia ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss Warning: Information provided via electronic media is not guaranteed against defects including translation and transmission errors. If the reader is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this information in error, please notify the sender immediately. ___ 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
Re: [OSGeo-Discuss] Shapefile's dfb editing
Thanks to all! The problem is in the length, but not in the column name but in the dimension of the numbers given in the column header. I really don't know exactly what they means... but it works!! For example: heigth,N,33,31 is not a valid length for an attribute column to be saved with OpenOffice. If I change it into: heigth,N,8,2 and in general if the sum of the last two numbers is less than 16 (bytes...?) it works fine and I can save the edited dbf. Thanks again for the attention, Ciao Silvia M J wrote: I don't know if this would matter but file name length could be something to look at. Some dbf files that open in Excel won't open in Access unless renamed to 8 (I think) characters or less. Maybe if you rename it shorter and try it might work. Definitely be careful with a live shapefile dbf though - you should probably rename the shapefile to a shorter name and then try to open the dbf again. Nif On Fri, Dec 12, 2008 at 12:17 PM, Landon Blake lbl...@ksninc.com mailto:lbl...@ksninc.com wrote: Silvia, I am surprised that Open Office couldn't open the DBF. Most open source desktop GIS programs like OpenJUMP can open and edit the attributes of Shapefile. Is that an option? If not, you could send me the file and I could see if I could open it in Microsoft Excel. Landon Office Phone Number: (209) 946-0268 Cell Phone Number: (209) 992-0658 -Original Message- From: discuss-boun...@lists.osgeo.org mailto:discuss-boun...@lists.osgeo.org [mailto:discuss-boun...@lists.osgeo.org mailto:discuss-boun...@lists.osgeo.org] On Behalf Of Silvia Franceschi Sent: Friday, December 12, 2008 8:12 AM To: discuss@lists.osgeo.org mailto:discuss@lists.osgeo.org Subject: [OSGeo-Discuss] Shapefile's dfb editing Hi all, do some of you know how to edit a shapefile's dbf file? I tried with OpenOffice Calc but I have the following error: Connection to file could not be established I have to add some attribute that I have in an other file and they are a lot of data. Thanks in advance for help Silvia ___ Discuss mailing list Discuss@lists.osgeo.org mailto:Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss Warning: Information provided via electronic media is not guaranteed against defects including translation and transmission errors. If the reader is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this information in error, please notify the sender immediately. ___ Discuss mailing list Discuss@lists.osgeo.org mailto: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 ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] Shapefile's dfb editing
My usual trick for dealing with dbf files is to import them into R and manipulate them there. The read.dbf and write.dbf functions in the R foreign library (see http://cran.r-project.org/doc/manuals/R-data.html) seem quite robust. R is a programming environment for statistical computing; it's probably overkill to start learning R just to manipulate your dbf files, but R is an incredibly useful and powerful system, which by the way has a lot of spatial analysis capabilities (see http://cran.cnr.berkeley.edu/web/views/Spatial.html), including links to GRASS. -- Allan Hollander On Friday 12 December 2008 08:11:48 Silvia Franceschi wrote: Hi all, do some of you know how to edit a shapefile's dbf file? I tried with OpenOffice Calc but I have the following error: Connection to file could not be established I have to add some attribute that I have in an other file and they are a lot of data. Thanks in advance for help Silvia ___ 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
Re: [OSGeo-Discuss] Shapefile's dfb editing
On Fri, Dec 12, 2008 at 5:11 PM, Silvia Franceschi silvia.frances...@gmail.com wrote: Hi all, do some of you know how to edit a shapefile's dbf file? I tried with OpenOffice Calc but I have the following error: Connection to file could not be established I have to add some attribute that I have in an other file and they are a lot of data. I have written up a small help text here: http://grass.osgeo.org/wiki/Openoffice.org_with_SQL_Databases#DBF_files_.28OpenOffice.org_2.x.29 Hope it helps, Markus ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] ICA Working Group on Open Source GeospatialTechnologies
Suchith, It is good to hear this news and it will be great to hear how ICA and OSGeo can complement each other. You have identified enviable ICA Open Source GIS goals, many which are shared with OSGeo. This is great. Have there been any discussions yet about how these goals will be achieved? What resources does ICA have at it's disposal? Suchith Anand wrote: Tyler, It is very important that Open Source GIS has high profile in ICA and other international bodies. I welcome participation from OSGeo members from different countries in the ICA WG. Especially from countries in South America, Asia and Africa. The ICA Commissions were established by the ICA General Assembly (all member nations voting) in 2007, and they have a four year term. The Working Groups are set up by the ICA Executive Committee between the General Assemblies. The next General Assembly is in 2011. I aim to work to make the Open Source Geospatial Technologies as an ICA Commission in 2011. I look forward to active participation by OSGeo members for the First Open Source GIS UK conference at University of Nottingham on June 22nd 2008. The call for papers and conference website will be activated on December 15, 2008. Suchith Dr Suchith Anand Centre for Geospatial Science Sir Clive Granger Building University of Nottingham Tel: (0)115 846 8408 url: http://www.nottingham.ac.uk/cgs/cgs_suchith_anand.html -Original Message- From: discuss-boun...@lists.osgeo.org [mailto:discuss-boun...@lists.osgeo.org] On Behalf Of Tyler Mitchell (OSGeo) Sent: 10 December 2008 16:37 To: OSGeo Discussions Subject: Re: [OSGeo-Discuss] ICA Working Group on Open Source GeospatialTechnologies Suchith, How can OSGeo members help with this initiative and how/where do you see overlap with any OSGeo current activities? Sounds like a very good development for keeping the ICA's eyes open about new technology. Thanks for sharing and looking forward to your guidance and ideas. Tyler On 9-Dec-08, at 7:59 AM, Suchith Anand wrote: Hi All, The International Cartographic Association's Executive Committee http://cartography.tuwien.ac.at/ica/ has approved the establishment of Working Group on Open Source Geospatial Technologies at its meeting last week in Chile. The Open Source Geospatial Technologies Working Group aims to promote multi-national holistic research in open source geospatial technologies in order to make accessible the latest developments in open source tools to the wider cartographic community. The WG attempts to enhance the usage of open source geospatial tools among the cartographic community worldwide, especially for education. Finally, the working group will promote the usage of professional and technical standards (ISO TC 211, OGC) for the development of open source geospatial software. Working group membership is open to all interested parties and we aim for representation by as many countries. Promotional strategies of the working group include regular e-mails to members, meetings, conferences, workshops, promotion of geospatial standards and publications. Terms of Reference - Working Group on Open Source Geospatial Technologies 1. To promote the widespread use of open source geospatial software 2. To provide support for the use of open source geospatial software in education through relevant publications 3. To organise conferences, workshops and training sessions for open source geospatial technologies 4. To organise special lectures and demonstrations on open source geospatial technologies 5. To make open source geospatial software more accessible to end users 6. To serve as a network for ICA members interested in open source geospatial technologies by the use of mailing lists, wiki etc 7. Through collaboration with other ICA commissions and working groups promote coordination with different open source geospatial organisations (eg. Open Source Geospatial Foundation) and developer communities. 8. Develop and keep updated the working group's website to disseminate the working group activities. 9. Produce annual reports of the working group activities. ICA have adopted a policy of approving WGs on a one year approval period and within this period it is essential to prove sufficient activity and the First Open Source GIS UK Conference to be jointly organised with OSGeo UK Chapter and Open Knowledge Foundation on 22nd June 2009 at CGS, University of Nottingham will be one of the key events planned as part of the WG activities. We are inviting expressions of interest from interested people to become members of the Working Group and to help steer its activities. If interested to join the WG please email suchith.an...@nottingham.ac.uk The Working Group's website and mailing lists will be activated in January 2009. Please contact me for any information needed. Best wishes, Suchith Dr Suchith Anand Centre for Geospatial