[postgis-users] Could not add all rasters to a table

2012-08-16 Thread Jean-Daniel Sylvain
ql -I -C -e -Y -F -s 26986 -t 300x300 -l 2,4 F:\PostGIS\raster\*.jpg private_schema.rasterly1 | psql -h localhost -U postgres -d gis_raster -p 5433 pause ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.

Re: [postgis-users] Vector overviews in postgis

2012-08-03 Thread Jean-Daniel Sylvain
Thanks you guys for this proposal. I think we are on the same vibe on this problem; I think simplification and agregation of polygon appears promising, but I'm not sure of how I will be able to manage it dynamically out of postgres (automatic display) unless using a wms/wfs aproach (what original

[postgis-users] Vector overviews in postgis

2012-08-02 Thread Jean-Daniel Sylvain
Hi, Is it possible to create overviews in postgis to optimise the speed of display for very big vectorial dataset (10 000 000) ? The aim is to be able to look quickly the dataset via a GIS tool like Quantum GIS or GV SIG or any suggestions. Jean-Daniel Sylvain

Re: [postgis-users] install PostgreSQL

2011-05-17 Thread Sylvain Racine
quot;localhost". If you have still error messages after these tips, please post another message with your detailed configuration and what you did. Best regard Sylvain Racine But when I install it still got errors as the detai

Re: [postgis-users] Help for my error when I install Postgis

2011-05-16 Thread Sylvain Racine
hen, connect to the database. If you didn't remember the password of your postgres Windows account, try to delete this account as Administrator in your Windows Control Panel first before reinstalling your new PostgreSQL installation. Hope it will be us

Re: [postgis-users] pgrestore

2011-04-15 Thread Sylvain Racine
(pg_dump -Fc...). If your backup is not created with -Fc option, you need to unzipped it (if necessary), then remove in a text editor the lines who bug. e.g. CREATE LANGAGE plpgsql... CREATE FUNCTION box_2d... etc. And then, restore your file using pgAdmin. Hope it will be useful. Sylvain

Re: [postgis-users] "Linux" geocoder script ?

2011-04-13 Thread Sylvain Racine
nd. Note: The above script is slower than the first one because you write you data on your disk drive between each operation. SATA or IDE disk access is always slower than RAM access, except if you use SSD disk. Hope it will be useful. Sylvain Racine O

Re: [postgis-users] "Linux" geocoder script ?

2011-04-12 Thread Sylvain Racine
scripting option that I don't check. Regards Sylvain Racine On 2011-04-12 03:08, Don wrote: My database is encoded as  geocoder  | drh  | UTF8 | C | en_US.UTF-8 | . All my shp2pgsql statements have the -W option like thi

Re: [postgis-users] "Linux" geocoder script ?

2011-04-11 Thread Sylvain Racine
n't mix it with the database encoding. It is the one you us to create your databse. There is also a default database charset, depending of your OS. It is the one you use to create template1 database in init-db. Mine is "UTF8" on Ubuntu. Hope that this information will help you Re

Re: [postgis-users] Export as X3D

2011-02-03 Thread Sylvain
Oh ! Collada format is available in Postgressql / Postgis ? If yes could you tell me which version to use for testing ? Thank you. Le jeudi 03 février 2011 à 09:22 +0100, Olivier Courtin a écrit : > On Feb 3, 2011, at 9:17 AM, Sylvain wrote: > > > Can I use postgres 8.3 and

Re: [postgis-users] Export as X3D

2011-02-03 Thread Sylvain
Thank you Olivier for your quick reply ! Can I use postgres 8.3 and the patch or unfortunately it's deprecated ? X3d and collada format is still in the roadmap or not ? Sylvain Le jeudi 03 février 2011 à 08:28 +0100, Olivier Courtin a écrit : > On Feb 3, 2011, at 7:36 AM, Sylva

[postgis-users] Export as X3D

2011-02-02 Thread Sylvain
d-et-de-la-fonction-asx3d but the post is very old ! Is there anyway to export asx3d under postgresql 8.4 or 9 ? Thanks for your reply, Sylvain ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailma

Re: [postgis-users] the nearest point of a line from a point

2008-01-31 Thread sylvain dubouis
It works, thanks for your help 2008/1/30, Kevin Neufeld <[EMAIL PROTECTED]>: > > Hi Sylvain, > > ST_ prefixed functions is the new way to access PostGIS methods, > following the SQL-MM specifications. It sounds like you'll need to > upgrade your PostGIS versio

Re: [postgis-users] the nearest point of a line from a point

2008-01-30 Thread sylvain dubouis
? and how I can Install this functions on my postgresql/postgis server Sylvain 2008/1/30, Kevin Neufeld <[EMAIL PROTECTED]>: > > See the section on linear referencing (sec. 6.2.7). > (http://postgis.refractions.net/docs/ch06.html#id2775904) > > You'll need to use two met

[postgis-users] the nearest point of a line from a point

2008-01-30 Thread sylvain dubouis
hello, I have a point and a line. I'd like to know the nearest point on the line from the point. but I don't find any function to do this... is there one? thanks for your help. Sylvain ___ postgis-users mailing list postgis-users@postgis.refra