Re: [postgis-users] Diagram of Voronoï to Squelettis ation of polygon

2010-12-13 Thread Daniel Kastl
Hi Jérôme, As you said the idea would be to add a function that calculates a skeleton from a polygon. Currently pgRouting contains a couple of functions ( http://www.pgrouting.org/docs/1.x/index.html), but all of them require network data with at least information about "start" and "end" ID of a

Re: [postgis-users] Kyng chaos Postgis -- "PostGIS requires PostgreSQL 9.0."

2010-12-13 Thread William Kyngesburye
On Dec 13, 2010, at 2:15 PM, fork wrote: >> That looks like it's straight from my OS X installer, so PostGIS itself >> hasn't tried to run yet. >> >> The installer checks for the existence of >> /usr/local/pgsql-9.0/lib/libpq.5.3.dylib. Are you sure the Postgres install >> finished and succee

Re: [postgis-users] import shape or sql to postgres automatically

2010-12-13 Thread Ben Madin
Can you not just pipe it in : (from the manual) shp2pgsql shaperoads.shp myschema.roadstable | psql -d roadsdb or use the \i metacommand to run the created script. cheers Ben On 13/12/2010, at 10:22 PM, zhang zhe wrote: > Hello, > > Does anyone know how to import sql table or shape file t

Re: [postgis-users] Kyng chaos Postgis -- "PostGIS requires PostgreSQL 9.0."

2010-12-13 Thread fork
> That looks like it's straight from my OS X installer, so PostGIS itself > hasn't tried to run yet. > > The installer checks for the existence of > /usr/local/pgsql-9.0/lib/libpq.5.3.dylib.  Are you sure the Postgres install > finished and succeeded? Yes, but it installs as an app, not in that

Re: [postgis-users] Converting Geometry to WKT

2010-12-13 Thread Adam Eskreis
Thank you for that tip strk, I will look into that. On Mon, Dec 13, 2010 at 1:25 PM, strk wrote: > On Mon, Dec 13, 2010 at 01:00:55PM -0500, Adam Eskreis wrote: > > Thank you so much Paul, this was exactly what I was looking for. > > > > And strk, thank you for your response, but I am well aware

Re: [postgis-users] Converting Geometry to WKT

2010-12-13 Thread strk
On Mon, Dec 13, 2010 at 01:00:55PM -0500, Adam Eskreis wrote: > Thank you so much Paul, this was exactly what I was looking for. > > And strk, thank you for your response, but I am well aware of the asWKT and > asText functions, what I am trying to do is AVOID using these functions, and > parse th

Re: [postgis-users] Converting Geometry to WKT

2010-12-13 Thread Adam Eskreis
Thank you so much Paul, this was exactly what I was looking for. And strk, thank you for your response, but I am well aware of the asWKT and asText functions, what I am trying to do is AVOID using these functions, and parse the geometry myself. On Mon, Dec 13, 2010 at 12:55 PM, strk wrote: > On

Re: [postgis-users] Converting Geometry to WKT

2010-12-13 Thread strk
On Mon, Dec 13, 2010 at 12:41:47PM -0500, Adam Eskreis wrote: > I was wondering if there was any documentation out there on how to convert > PostGIS geometry to WKT. selet asWKT(geometry) ? --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html __

Re: [postgis-users] Converting Geometry to WKT

2010-12-13 Thread Paul Ramsey
The canonical output form for PostGIS is "hex-encoded extended well-known binary". The "hex encoded" part should be self-explanatory. The "extended" part is explained here: http://svn.osgeo.org/postgis/trunk/doc/ZMSgeoms.txt And the well-known-binary part is in the OGC SFSQL. Note that we also su

[postgis-users] Converting Geometry to WKT

2010-12-13 Thread Adam Eskreis
Hey all, I was wondering if there was any documentation out there on how to convert PostGIS geometry to WKT. The reason that I need this is I am looking to write a PHP library that will allow me to pull PostGIS geometry directly from the database (without having to use the AsText() function) and

Re: [postgis-users] Kyng chaos Postgis -- "PostGIS requires PostgreSQL 9.0."

2010-12-13 Thread William Kyngesburye
On Dec 13, 2010, at 5:06 AM, Mark Cave-Ayland wrote: > fork wrote: > >> Hi all, >> Not sure where else to ask -- I just installed Postgresql 9.0.1 from >> the Kyngesbury site, now trying to install postgis, and I get this >> error: >> "PostGIS requires PostgreSQL 9.0." >> Anyone have any ideas?

Re: [postgis-users] import shape or sql to postgres automatically

2010-12-13 Thread Robert Buckley
Hi, I find it easyest with the built in GUI from the opengeosuite. You can download the community edition and use the whole Shape2postgis import tool as part of the deal here is the link to the download. http://opengeo.org/community/suite/download/ Simply install the desktop version and start

Re: [postgis-users] import shape or sql to postgres automatically

2010-12-13 Thread Mark Cave-Ayland
zhang zhe wrote: Hello, Does anyone know how to import sql table or shape file to postgres database automatically? What I did before is: I have shpe file save in C:/users I go to terminal in linux, and go to the directory C:/users C:/users shp2pgsql shapefile.shp > sqlfile.sql I will get sql

[postgis-users] import shape or sql to postgres automatically

2010-12-13 Thread zhang zhe
Hello, Does anyone know how to import sql table or shape file to postgres database automatically? What I did before is: I have shpe file save in C:/users I go to terminal in linux, and go to the directory C:/users C:/users shp2pgsql shapefile.shp > sqlfile.sql I will get sql file saved into c

Re: [postgis-users] Kyng chaos Postgis -- "PostGIS requires PostgreSQL 9.0."

2010-12-13 Thread Mark Cave-Ayland
fork wrote: Hi all, Not sure where else to ask -- I just installed Postgresql 9.0.1 from the Kyngesbury site, now trying to install postgis, and I get this error: "PostGIS requires PostgreSQL 9.0." Anyone have any ideas? Does this mean "I can't find any postgres"? or "I can't find the right