[postgis-users] encryption of PostGIS databases

Hi, Is there a way to protect geographical data by encrypt the GIS db, if so that is the impact on performance? Kind regards, Paul ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postg

[postgis-users] ORDER BY id and distance

Hi, I wonder how I can order a result depending on two arguments. First: mapid (objects are connected to a mapid) and second: within the mapid-sorted objects they should be sorted on the distance to a certain coordinate. Thanks, Paul ___ postgis-users m

Re: [postgis-users] PostgreSQL version for PostGIS ver 1.5.1

Thanks Thomas! From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Thomas Gratier Sent: den 24 maj 2010 23:00 To: PostGIS Users Discussion Subject: Re: [postgis-users] PostgreSQL version for Post

[postgis-users] PostgreSQL version for PostGIS ver 1.5.1

Hi, when I install postgreSQL on windows I can get a choise to instal postgis as well. Is it the same on Linux x86-32? If so, what postgreSQL version shall I choose to get PostGIS ver 1.5.1 on Linux? Kind regards, Paul From: postgis-users-boun...@postgis.refra

[postgis-users] st_dwithin

Hi, I have a database stored in WGS84 EPSG:4326 I would like ti find objects within a distance from a lat/lon point. 1) If i use 1 degree as the distance, will I then get an eliptic search area? 2) Will i find objects on the other side of the Datum shift border if I enter a point like lat=60°, lon

[postgis-users] spatial extents of a PostGIS db

Hi List! I have imported a map with ogr2ogr to a "PostGIS" db, is there a way to find out the spatial extent of this map e.g the envelope that is build from all including layers? Kind regards, Paul ___ postgis-users mailing list postgis-users@postgis.

[postgis-users] schema

Hi, how can I create a secondary schema that includes all postgis functions as the default schema does? Kind regards, Paul ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-user

[postgis-users] maps as cchema???

Hi list, Today I have several charts (could be in different scales, different source types etc.) as separate databases and I've imported them ito a viewer. When I'm picking an object to view the information I must first connect and go through all the databases seperately. Is there a way to store

[postgis-users] selection of data in WGS84 lat/lon over the noth pole

Hi list, I would like to select data over the north pole inside a polygon of lat/lon coordinates For selection I create a polygon from theese coordinates 1) 80, -170 2) 80, 170 3) 75, 10 4) 75, -10 But is seems that the objects found are from around the pole instead of over the pole, it does n

RE: [postgis-users] long time for finding objects

ou a better feel for the true speed (e.g., instead of pulling geom, pull st_area(geom), instead of pulling bytea, pull length(bytea). P On Wed, Apr 29, 2009 at 7:32 AM, Malm Paul wrote: > Hi I find it slow to select objects in the PostgreSQL/PostGIS db I'm > using windows XP, postgreSQ

[postgis-users] long time for finding objects

Hi I find it slow to select objects in the PostgreSQL/PostGIS db I'm using windows XP, postgreSQL 8.3.7 I have a table "map" with the columns: mapid: small int scale: small int rectangle: geometry binary_field: bytea The database concist of 81 "map" rows, where the binary has a avarage size of 8

[postgis-users] selecting geometries, using 2 polygons

Hi, I have 2 polygons (rectangeles) p1 and p2, they intersect each other. I would like to select all geometries within p1 excluding all geometries within p2. How can I do this with postGIS and SQL ? Kind regards, Paul___ postgis-users mailing list post

[postgis-users] selecting features intersecting a multipolygon

Hi, I´m trying this: SELECT submapid, mapid, blob, AsText(the_geom) as the_geom FROM submap WHERE the_geom && GeomFromText('MULTIPOLYGON(((-119.2 33.46, -118.7 333.46, -118.7 32.66, -119.2 33.66, -119.2 33.46)))' ) I´ve also tried this: SELECT submapid, mapid, blob, AsText(the_geom) as the_geom FR

[postgis-users] adding a geometry to a Postgis db

Hi list, I have a geometry (com.vividsolutions.jts.geom.Geometry) which I would like to add as a geometry to the geometry colunm see below. how can I do this in java (I don´t know so much of databases)? PreparedStatement pstmt = null; String query = "insert into submap(submapid, mapid, blob

[postgis-users] blob in postgis database

Hi, I have a byte array that I would like to att to a table as a blob. I have not succeded. I managed to ad it as an "bytea", but it is really slow. Could some one please help me? I'm using Java to populate the database on a windows XP OS. Kind regards, Paul ___

[postgis-users] 3D maps

Hi! I have a geometry set of triangles (e.g land area), including elevations. To be able to view e.g roads ontop those triangles I must insert points in the road polylines with the correct elevation in each intersection (roadline - triangle border). Att the same time I would like to insert the corr

[postgis-users] NewBee, connect to a PostgisDatabase via ODBC and C++

Hi, This is perhaps a trivial issue, but I cant find any examples of connecting to a postgis db via a C++ application and ODBC. The example below is take from the PostGis manual and is an example of what I would like to do. When I installed PostgreSQL and PostGIS I entered the following parameters:

[postgis-users] reading postgis objects

Hi, I have not found any description of the binary format of polygons, points etc.. is there any? I would like to select objects of an Postgis feature type an save them into a propiatary graphic format. I can do it with: Select astext... But I imagine that it will be faster to get the selection s

RE: [postgis-users] correcting polygons

iginal dataset? Hoep that helps, Regina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Malm Paul Sent: Friday, June 08, 2007 1:08 AM To: PostGIS Users Discussion Subject: RE: [postgis-users] correcting polygons You are right, what would I do without

RE: [postgis-users] correcting polygons

na -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Malm Paul Sent: Thursday, June 07, 2007 9:08 AM To: PostGIS Users Discussion Subject: RE: [postgis-users] correcting polygons Regina, I hope this is what you mean: -- Table: depare_area -- DROP TABL

RE: [postgis-users] correcting polygons

ON parceltime_2006 USING gist (the_point); -- Index: idx_zip_2006 -- DROP INDEX idx_zip_2006; CREATE INDEX idx_zip_2006 ON parceltime_2006 USING btree (fn_chartonumber(zipcode, '99'::character varying)); -Original Message- From: [EMAIL PROTECTED] [mailto:[

RE: [postgis-users] correcting polygons

D] On Behalf Of Malm Paul Sent: Monday, June 04, 2007 9:56 AM To: PostGIS Users Discussion Subject: RE: [postgis-users] correcting polygons Regina, It is still the same even if I don't use multi() If I enter: SELECT distinct (srid(poli)) as the_srid From Depare_area2; I will get onl

RE: [postgis-users] correcting polygons

why you are getting an "enforce_srid_poli" error. What does your enforce_srid_poli constraint look like? It should look something like CONSTRAINT enforce_srid_poli CHECK (srid(poli) = -1) -Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Malm

RE: [postgis-users] correcting polygons

n SRID different from -1. To check try SELECT distinct(srid(the_geom)) as the_srid FROM deparea You should only get 1 record unless you have a mixed bag of SRIDs. Now whatever that srid is, your add geometry should use that instead of the -1 you have in place. So the line SELECT AddGeomet

RE: [postgis-users] correcting polygons

geometry within the multigeometry, buffer will convert that multipolygon to a polygon. To prevent that from happening, you would then apply the multi function. multi function in essence wraps your single polygon into a multipolygon encasement. Hope that helps, Regina -Original Message-

[postgis-users] ArcCatalog

Hi, I wounder if someone knows of an application like ArcCatologe for Postgis (import/export/adding/correcting/joining etc)? Kind regards, Paul ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/li

RE: [postgis-users] correcting polygons

age- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Ramsey Sent: den 30 maj 2007 20:01 To: PostGIS Users Discussion Subject: Re: [postgis-users] correcting polygons buffer(polygon,0.0) should re-build it with correct structure On 30-May-07, at 7:29 AM, Malm Paul wrote: >

[postgis-users] correcting polygons

Hi list, Is there a simple way to correct a polygon that has a hole and where one of the coordinates of that hole is exactly the same as one coordinate in the external ring? Kind regards, Paul ___ postgis-users mailing list postgis-users@postgis.refrac

[postgis-users] multipolygons to polygons

Hi, I'm trying to run shp2pgsql with a polygon file but I'm getting the folloing error: "We have a multipolygon with 2 parts, can't use -S switch!" I know there is: -Multipolygons with holes. -Multipolygons with 2 external rings (originally one polygon cut into 2 polygons). Is anything of this th