Re: [postgis-users] Postgresql JDBC Driver source download problem

Hi Jenny; The source code downloadable from the page you mention is not a zip file. http://jdbc.postgresql.org/download/postgresql-jdbc-8.3-604.src.tar.gz is a gzipped tar file. You need gnu tar or any old tar and gunzip to get this back into a source tree. You may need other gnu tools to buil

Re: [postgis-users] Postgresql JDBC Driver source download problem

Try using 7-zip to read/write compressed archives. It can read that tar.gz file format on Windows (as well as many other formats). I was able to open the version 8.3 source tarball with 7-zip 4.65 and decompress it fine. On Tue, Jun 30, 2009 at 9:20 PM, "Jenny" Guilian Wang wrote: > Hi, > > Fro

[postgis-users] Postgresql JDBC Driver source download problem

Hi, >From http://jdbc.postgresql.org/download.html, I tried to download JDBC source, no source zip of the supported versions can be opened by WinZip, and WinZip complains 'Error reading header after processing 0 entries". Did anyone meet the same problem? Could you please let me know how you reso

Re: [postgis-users] Define spatial reference system for local datum

I'm not mapping anything on earth. The world I'm doing is flat. The polygons I'm drawing over is raster image I made. So I'm trying not to use any ellipsoid projection. Suhr, Ralf wrote: > > Do not use a local system. For everything larger than 200meters you need a > srs definition, because

Re: [postgis-users] Data modeling tool

I use Open System Architect. http://www.codebydesign.com/ It is available on several platforms and free to use. -Original Message- From: Frode Wiseth Jørgensen Sent: Tuesday, June 30, 2009 10:25 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] Data modeling tool I'm using "

Re: [postgis-users] Data modeling tool

I'm using "Dezign for databases" delivered by http://www.datanamic.com/ It has'nt by default a GEOMETRY datatype but it can easily be added. Frode 2009/6/30 > > Hello, > I searched for a data modeling/build/management tool for postresql and > postgis. > > I would like to have the opinion of

Re: [postgis-users] Data modeling tool

Steve, There is an excellent tool for ERD, SQL script and an Excel spreadsheet report. Jude Professional http://jude.change-vision.com/jude-web/product/professional.html The graphics are much better than DB Designer. There's a $40 educational timed license (1 year). Many other tools as well - s

Re: [postgis-users] Data modeling tool

Steve, there is a nice tool out there developed by MicroOLAP (http://www.microolap.com/), the Database Designer for PostgreSQL, which lets you draw ERM diagrams and then generates the database from that diagram. There's a free trial version on their webpage. This tool is also capable of reverse-en

Re: [postgis-users] Data modeling tool

There is a free version of DBVisualizer. János On Jun 30, 2009, at 11:19 AM, steve.tout...@inspq.qc.ca wrote: Thanks Martin, I'm already using pgAdminIII to manually manage databases. What I meant is I need a tool to design a database structure (tables, fields, relations), so it can generat

Re: [postgis-users] Data modeling tool

Thanks Martin, I'm already using pgAdminIII to manually manage databases. What I meant is I need a tool to design a database structure (tables, fields, relations), so it can generate scripts to physically create the tables when the model is complete. I need this tools to make reverse engineering

Re: [postgis-users] Data modeling tool

Hi Steve pgAdminIII (pgadmin.org) Martin F steve.tout...@inspq.qc.ca a écrit : Hello, I searched for a data modeling/build/management tool for postresql and postgis. I would like to have the opinion of users, which one really works? Could be open source or commercial. Regards, Steve /S

[postgis-users] Data modeling tool

Hello, I searched for a data modeling/build/management tool for postresql and postgis. I would like to have the opinion of users, which one really works? Could be open source or commercial. Regards, Steve Steve Toutant, M. Sc. Analyste en géomatique Secteur environnement Direction des risques

Re: [postgis-users] compundcurve in polygons is supported in 1.4

Mario, Actually Mark L just fixed the bug in trunk (and he is patching the fix into 1.4 and I believe 1.3 as well). So it will be fully functional in PostGIS 1.4 probably due out next week and 1.3 about a month later. st_curvetoline has always worked with curve polygons (with either circular

Re: [postgis-users] Define spatial reference system for local datum

Do not use a local system. For everything larger than 200meters you need a srs definition, because you can't messure it exactly. Take a projection from your living area und shift your geometrys to the right place. -Ursprüngliche Nachricht- Von: postgis-users-boun...@postgis.refractions.

[postgis-users] Define spatial reference system for local datum

I don't need special projection. My map is a flat plane so I'm trying to use local datum as my srs because a bunch of gis map design tool ask for it. So I'm trying to add a new srs into postgis spatial_ref_sys table with the following srstext LOCAL_CS["Non-Earth (Meter)",LOCAL_DATUM["Local Da

Re: [postgis-users] compundcurve in polygons is supported in 1.4

Hi, thanks very much I really need this datatype. Will be possible to create polygons with multiple rings of compoundcurve? A function like stcurvetoline with the interpolation of arcs will be available for the polygons too? Thanks Mario -Original Message- From: postgis-users-boun...@pos