[postgis-users] loading only geometries of shp files into PostGIS

2012-06-06 Thread karsten
Hi All, I am working on a data upload function where for a web map a user can upload a shape file onto the server, the file will then be loaded via a utility into PostGIS e.g. using ogr2ogr or shp2pgsql. Now we all know that usually a shape files has at least 3 files shp, shx and dbf to be compl

Re: [postgis-users] Error adding raster support

2012-06-06 Thread Bborie Park
Luis, The problem is that the libgdal.so.1 file can't be found. Did you use a GDAL package or compile your own? If you're using a GDAL package through ubuntu or debian, the gdal libraries having their version number attached to the filename causing problems. You should search the list for the l

Re: [postgis-users] Error adding raster support

2012-06-06 Thread Nordgren, Bryce L -FS
> -Original Message- > But I'm getting the following error: > > psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/rtpostgis.sql:70: ERROR: > could not load library "/usr/lib/postgresql/9.1/lib/rtpostgis-2.0.so": > libgdal.so.1: cannot open shared object file: No such file or directory >

Re: [postgis-users] Intersection of LineStrings

2012-06-06 Thread Stephen Woodbridge
Gist is an r-tree like index, only use if on the geometry column. -Steve On 6/6/2012 11:10 AM, Ed Linde wrote: Hi Steve, What indexes can I put on the linestring column? Is there an option of using a R-Tree index? Thanks, Ed On Wed, Jun 6, 2012 at 4:54 PM, Stephen Woodbridge mailto:wood...@sw

[postgis-users] PostgreSQL/PostGIS x64 Error on PostGIS Install

2012-06-06 Thread donald . kerr
Hi List, I am trying to set up a Windows 7 x64 laptop with PostgreSQL and PostGIS. Both program versions are x64 as follows: PostgreSQL: postgresql-9.1.4-1-windows-x64.exe PostGIS: postgis-pg91x64-setup-2.0.0-4.exe I am using an existing data directory and the PostgreSQL goes well, reporting n

Re: [postgis-users] RE : AddRasterColumn support

2012-06-06 Thread Yogesh Dahiya
Thanks -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Francois Hugues Sent: Wednesday, June 06, 2012 6:41 PM To: PostGIS Users Discussion Subject: [postgis-users] RE : AddRasterColumn support Maybe

Re: [postgis-users] Intersection of LineStrings

2012-06-06 Thread Ed Linde
Thanks All. On Wed, Jun 6, 2012 at 5:14 PM, Puneet Kishor wrote: > > On Jun 6, 2012, at 10:10 AM, Ed Linde wrote: > > > Hi Steve, > > What indexes can I put on the linestring column? Is there an option of > > using a R-Tree index? > > > Yup, use the GiST index. > > > > > -- > Puneet Kishor > ___

Re: [postgis-users] Intersection of LineStrings

2012-06-06 Thread Puneet Kishor
On Jun 6, 2012, at 10:10 AM, Ed Linde wrote: > Hi Steve, > What indexes can I put on the linestring column? Is there an option of > using a R-Tree index? Yup, use the GiST index. -- Puneet Kishor ___ postgis-users mailing list postgis-users@postgi

Re: [postgis-users] Intersection of LineStrings

2012-06-06 Thread Ed Linde
Hi Steve, What indexes can I put on the linestring column? Is there an option of using a R-Tree index? Thanks, Ed On Wed, Jun 6, 2012 at 4:54 PM, Stephen Woodbridge wrote: > On 6/6/2012 9:57 AM, Ed Linde wrote: > >> Hi All, >> Simple question. I have a table with half a million linestring >> geo

Re: [postgis-users] Intersection of LineStrings

2012-06-06 Thread Stephen Woodbridge
On 6/6/2012 9:57 AM, Ed Linde wrote: Hi All, Simple question. I have a table with half a million linestring geometries, and I want to compute the intersection points and also the linestring pairs that intersect with each other. How can I do this? Is there an index that can avoid having to do a se

Re: [postgis-users] Intersection of LineStrings

2012-06-06 Thread Frederik Ramm
Hi, On 06/06/2012 03:57 PM, Ed Linde wrote: Simple question. I have a table with half a million linestring geometries, and I want to compute the intersection points Not exactly what you were looking for but maybe related: http://lists.osgeo.org/pipermail/geos-devel/2012-April/005771.html Bye

[postgis-users] Intersection of LineStrings

2012-06-06 Thread Ed Linde
Hi All, Simple question. I have a table with half a million linestring geometries, and I want to compute the intersection points and also the linestring pairs that intersect with each other. How can I do this? Is there an index that can avoid having to do a self-join and computing the intersections

Re: [postgis-users] AddRasterColumn support

2012-06-06 Thread Peter Baumann
you may want to look at the rasdaman extension to PostgreSQL, it supports n-D large rasters with a raster query language: www.rasdaman.com. Further, OGC standards WMS, WCS, WCPS, WPS standards. -Peter On 06/06/2012 02:53 PM, Yogesh Dahiya wrote: I am working on somebody else postgis project

[postgis-users] Error adding raster support

2012-06-06 Thread Luis
Hello everyone, I have Postgres 9.1 and Postgis 2.0 on Ubuntu Server 10.04. I'd like to add raster support to a spatial database, feeding the raster SQL file: $ psql -f /usr/share/postgresql/9.1/contrib/postgis-2.0/rtpostgis.sql -d mydatabase But I'm getting the following error: psql:/usr/share

[postgis-users] RE : AddRasterColumn support

2012-06-06 Thread Francois Hugues
Maybe you should try something like : http://postgis.refractions.net/docs/RT_AddRasterConstraints.html Hugues http://postgis.refractions.net/docs/PostGIS_Special_Functions_Index.html#NewFunctions_2_0 : In PostGIS 2.0, raster type and raster functionality has been integrated. There ar

[postgis-users] AddRasterColumn support

2012-06-06 Thread Yogesh Dahiya
I am working on somebody else postgis project and he used addrastercolumn but postgis does not have reference to that function. And that is because wkt raster support has been abandoned by postgis. So what alternatives do I have for providing raster support. _

[postgis-users] extracting attributes from non-standard text field to cross with polygon

2012-06-06 Thread perikut
hello, If I have a table structured like this POINT TABLE the_geom, genus_array my_geom genus1+300||genus2+5000||genus3+1000... my_geom2 genus1+300||genus2+8000. how should I do if I want to extract the info for genus2 (5000 and 8000) and cross its geometry to mak