[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

[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

[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:

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

[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°,

[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] 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

[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

[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

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

(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 paul.m...@saabgroup.com wrote: 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

[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

[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

[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

[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

RE: [postgis-users] correcting polygons

use that instead of the -1 you have in place. So the line SELECT AddGeometryColumn('public','deparea2', 'poli', 'WHATEVER SRID YOU GOT ABOVE GOES HERE', 'POLYGON',2); Hope that helps, Regina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Malm Paul

RE: [postgis-users] correcting polygons

it with correct structure On 30-May-07, at 7:29 AM, Malm Paul wrote: 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] 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