Re: [postgis-users] Installing on Debian

Pehaps Check if you have a bad symbolic link on libxml2.so I had an issue with that Alex Borrell @postgis.refractions.net Envoyé par : postgis-users-boun...@postgis.refractions.net 2012-06-15 10:56 Veuillez répondre à PostGIS Users Discussion A PostGIS Users Discussion cc Objet Re: [postg

Re: [postgis-users] Organizations relying on PostGIS

Here are 2 recents publications, public health related http://www.ij-healthgeographics.com/content/10/1/39 http://www.ij-healthgeographics.com/content/11/1/2 steve Andy Colson @postgis.refractions.net Envoyé par : postgis-users-boun...@postgis.refractions.net 2012-06-12 12:52 Veuillez rép

Re: [postgis-users] navigation tracks (x,zy) h

select distinct lat, lon unless I misunderstood the problem... steve Gery @postgis.refractions.net Envoyé par : postgis-users-boun...@postgis.refractions.net 2012-04-05 11:15 Veuillez répondre à PostGIS Users Discussion A postgis-users@postgis.refractions.net cc Objet Re: [postgis-u

[postgis-users] distance between 2 polygons

Hi For each polygon I need to find the nearest polygon. I used ST_Distance(geometry, geometry) I succesfully did it but I want to make sure to interpret the result correctly Does A distance of 0 mean that the polygons touch each other or it means that their bounding box touch each other? What do

[postgis-users] RE [Polluriel potentiel] Re: Postgis installation on sles 11 sp1

pendencies > > I just begin with linux, don't know wich solution is best... > Good night! > Steve > Steve Toutant, M. Sc. > Analyste en géomatique > Secteur environnement > Direction de la santé environnementale et de la toxicologie > Institut national de santé

Re: [postgis-users] Postgis installation on sles 11 sp1

to install a solvable providing > postgresql-server.x86_64 > Solution 2: break postgresql-server by ignoring some of its dependencies > > I just begin with linux, don't know wich solution is best... > Good night! > Steve > Steve Toutant, M. Sc. > Analyste en géomati

Re: [postgis-users] Postgis installation on sles 11 sp1

thing provides libpq.so.5()(64bit) needed by > postgresql-server-9.1.2-64.1.x86_64 > Solution 1: do not ask to install a solvable providing > postgresql-server.x86_64 > Solution 2: break postgresql-server by ignoring some of its dependencies > > I just begin with linux, don't kno

Re: [postgis-users] Postgis installation on sles 11 sp1

linux, don't know wich solution is best... Good night! Steve Steve Toutant, M. Sc. Analyste en géomatique Secteur environnement Direction de la santé environnementale et de la toxicologie Institut national de santé publique du Québec Tél.: 418 646-6777 poste 30015 Téléc.: 418 644-4593 steve

Re: [postgis-users] Postgis installation on sles 11 sp1

If I install postgres 9 using postgresql-libs v8.3 from sles 11 distribution I got this error when I create a database createdb: symbol lookup error: createdb: undefined symbol: PQconnectdbParams Thanks for your support Regards steve Steve Toutant, M. Sc. Analyste en géomatique Secteur

Re: [postgis-users] Postgis installation on sles 11 sp1

Thanks Otto, I saw that these packages are now available in sles11_sp1. quick...!! But the repo contains package postgresql-libs-8.3.9-0.1.1.x86_64 Should it be 9.1.2-64.1 as per postgresql-server? many thanks again Steve Steve Toutant, M. Sc. Analyste en géomatique Secteur environnement

Re: [postgis-users] Postgis installation on sles 11 sp1

Hi Otto, I need postgis to work with at least postgres v9.0 regards, Steve Otto Dassau @postgis.refractions.net Envoyé par : postgis-users-boun...@postgis.refractions.net 2012-01-04 09:49 Veuillez répondre à PostGIS Users Discussion A postgis-users@postgis.refractions.net cc Objet Re: [po

[postgis-users] Postgis installation on sles 11 sp1

Hi, I still can't make postgis work on sles 11 sp1 I successfully installed postgres 9.1.2-64.1 from this repository http://download.opensuse.org/repositories/server:/database:/postgresql/SLE_11_SP1 Then I installed postgis from this repo of sles11 (not sp1) http://download.opensuse.org/repositori

[postgis-users] postgis installation fail on sles11

Hi,I'm on SLES11 _SP1 trying to compile postgis 1.5.3./configure went well but make gives me this error /usr/lib64/libxml2.a(parser.o): relocation R_X86_64_32S against `.rodata.str1.1' can not be used when making a shared object; recompile with -fPIC/usr/lib64/libxml2.a: could not read symbols: Bad

[postgis-users] Linux installation

Hi,Sorry for cross-posting on several lists, but we are in the process of taking some important decisions, on the OS to use...For several years we have mapserver, gdal and Postgis, etc... running on a Windows server.We plan to migrate our GIS tools from the Windows server to SUSE Linux Enterprise S

[postgis-users] ogr2ogr and special character

Hi,I'm trying to import a mapinfo file into my db and I got these 2 errors- Permission denied for relation geometry_columns- ERROR 1: PostgreSQL driver doesn't currently support database creation.Please create database with the `createdb' command.PostgreSQL driver failed to create PG:host=ogldev us

[postgis-users] RE help

Do you mean that you want to read postgis data with mapserver? Perhaps this will help http://mapserver.org/input/vector/postgis.html steve Linnet Kwamboka @postgis.refractions.net Envoyé par : postgis-users-boun...@postgis.refractions.net 03/05/2010 03:37 AM Veuillez répondre à PostGIS Users

[postgis-users] Excel to Postgres

Hi, Every day I receive an Excel file containing lat long coordinates. I need to import it to postgis. Currently, I save the Excel file in CSV format and I use ogr2ogr to import the contents into postgis. I would like to avoid human intervention. I tried unsuccessfully to define an ODBC link on

Re: [postgis-users] Error Using WKTRASTER!

I didn't use fw tools. I have installed python 2.6 and python gdal package (see bottom of this page) http://pypi.python.org/pypi/GDAL/ You might need numpy as well http://sourceforge.net/projects/numpy/ Hope this help, Steve mukesh karanwal @postgis.refractions.net Envoyé par : postgis-

[postgis-users] RE Importing shapefiles to PostGIS

Here is an example shp2pgsql -s 4326 -I -S yourshppath\yourshapefile schema.tablename > yourshppath\import.sql psql -d database -U username -f yourshppath\import.sql You could send your command so will see what is wrong Shreerang Patwardhan @postgis.refractions.net Envoyé par : postgis-user

[postgis-users] RE insert query does not work anymore...

I modified postgresql.conf and set debug5 to some parameters and I see in the log that the problem is from PHP script it doesn,t get the posted parameters for unknown reason yet. So, Postgres is working perfectly...as usual. Steve steve.tout...@inspq.qc.ca@postgis.refractions.net Envoyé pa

[postgis-users] insert query does not work anymore...

Hi, Something strange I have PHP page that send a simple insert query to postgis. Until now this was working perfectly. Now the INSERT queries do not work without any changes...as I recall... If I execute the same query with pgAdminIII it works. I'm able do to delete, select and create tables

[postgis-users] windows 2008 server

Hi, My IT service wants to install windows 2008 server on my server. Does Postgres/Postgis work on this platform? Is there known issues? thanks in advance Steve ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refract

[postgis-users] importing Raster with wkt raster

INTERLEAVE=BAND Corner Coordinates: Upper Left ( -464859.389, 348513.395) ( 74d37'31.17"W, 46d57'11.19"N) Lower Left ( -464859.389, 126213.395) ( 74d23'5.99"W, 44d57'37.51"N) Upper Right ( -231729.389, 348513.395) ( 71d33'32.58"W, 47d 5'

[postgis-users] RE RE : RE RE : RE RE : using WKT Raster

ok, installation successfull using the readme.txt and Pierre'note below thanks Steve Steve Toutant, M. Sc. Analyste en géomatique Secteur environnement Direction de la santé environnementale et de la toxicologie Institut national de santé publique du Québec 945, avenue Wolfe Québec, Qc G1

Re: [postgis-users] RE RE : RE RE : using WKT Raster

Hi Regina, I'm on winXP. I use postgres 8.3 and postgis 1.4.1 I copied the dll in this folder C:\Program Files\PostgreSQL\8.3\lib In pgAdminIII I ran rtpostgis.sql and I get this error NOTICE: argument type raster is only a shell ERROR: function geometry_gist_joinsel(internal, oid, internal, sm

[postgis-users] RE RE : RE RE : using WKT Raster

I was not aware that I needed to place a DLL somewhere...Perhaps it is obvious, but I'm not a programmer and I don't know much about dll and software structure. Running rtpostgis.sql and moving a dll , is that documented somewhere, maybe I missed it. Please provide a url if the doc to properly i

[postgis-users] RE RE : using WKT Raster

I got this error when running the script NOTICE: type "raster" is not yet defined DETAIL: Creating a shell type definition. ERROR: could not access file "$libdir/rtpostgis": No such file or directory ** Error ** ERROR: could not access file "$libdir/rtpostgis": No such file o

[postgis-users] using WKT Raster

cit type casts. psql:wkt.sql:4: ERROR: current transaction is aborted, commands ignored until e nd of transaction block ROLLBACK I read this on the page's project The wktraster_database must be a PostgreSQL database with PostGIS and WKT Raster extensions enabled How do I get the functions

[postgis-users] RE WKT Raster

I got it working. I adjust the Path environment variables with the location of gdal-ogr I also needed to install numpy http://sourceforge.net/projects/numpy/ steve.tout...@inspq.qc.ca@postgis.refractions.net Envoyé par : postgis-users-boun...@postgis.refractions.net 12/01/2010 03:33 PM Veuil

[postgis-users] WKT Raster

HI, I just installed wktraster_pg83 using this link http://www.postgis.org/download/windows/pg83/experimental/wktraster/ I guess the next step is to use gdal2wktraster.py to load an image in postgis. I don't know the syntax to use so I tried this command C:\Python\python.exe gdal2wktraster.py --

Re: [postgis-users] Suggestion Needed

I know nothing about compiling, dll'S, etc.. So, I'm willing to try this. But My current version of postgres is 8.3 and postgis 1.3. I guess I need to upgrade to postgis 1.4. Should I upgrade postgres also? Is this procedure is the best and safest way to upgrade postgis? http://www.postgis.org/dow

Re: [postgis-users] several SRID on one table

Thanks Pavel for your answer. Do you suggest that I could use one geometry column and create several index instead? Steve Toutant, M. Sc. Analyste en géomatique Secteur environnement Direction des risques biologiques, environnementaux et occupationnels Institut national de santé publique du

[postgis-users] several SRID on one table

Hello, We need to use a table for several purposes with different SRID. Is it a good practice to have several geometry columns on one table or should we create one table per SRID? What are the pros and cons of using several geometry columns on one table? thanks Steve Steve Toutant, M. Sc

Re: [postgis-users] KML Export

s\\tmp\\'; $shellcommand = $ogr2ogr.' -f KML '. $stock . 'data_'. $layerName . '.kml PG:" host= dbname=xx user=xx password=xxx" -sql "'.$query.'"'; $shellresult = shell_exec($shellcommand); steve Steve Toutant, M. Sc. Analys

Re: [postgis-users] Data modeling tool

verse engineering, generate documentation about a database, etc As far as I know pgAdmin doesn't do that. steve Steve Toutant, M. Sc. Analyste en géomatique Secteur environnement Direction des risques biologiques, environnementaux et occupationnels Institut national de santé publique du Québec 9

[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] How to create a custom SRID record and proj4 text in postGIS provided I have my custom Proj4js.def

(srid, auth_name, auth_srid, proj4text, srtext) values ( 93411, 'epsg', 3411, '+proj=stere +lat_0=90 +lat_ts=70 +lon_0=-45 +k=1 +x_ If you're projection doesn't already have a epsg code you can modify these statement Steve Steve Toutant, M. Sc. Analyste en géomatique Secte

RE [postgis-users] spatial_ref_sys

That seems to be EPSG:23031 If it doesn't exist in spatial_ref_sys This site provides the syntax to insert it in postgis http://spatialreference.org/ref/epsg/23031/ Steve Steve Toutant, M. Sc. Analyste en géomatique Secteur environnement Direction des risques biologiques, environnementa