[postgis-users] how to transfer wkt geometry from mysql to postgis?

Hi, I have wkt geometry data in mysql stored in blob format. I need to get this data into a postgis db and am looking for the quickest-easiest way to do it. I have managed to select the data "ASTEXT" but can then only copy it into QGIS -> export to shape -> import to postgisbut this is prob

Re: [postgis-users] Are views slow ing down my wms?

from default postgres >settings and information about RAM might help shed some light. > >Greg Williamson > > > >> >> From: Robert Buckley >>To: Post GIS Users Discussion >>Sent: Wednesday, July 11, 2012 10:30 PM >>Subject:

[postgis-users] Are views slow ing down my wms?

Hi, I have created a database structure which has 3 main postgis tables (1 for lines,polygones, and points) which each contain between 5-10,000 features. These tables then feed views which split the geometries into understandable groups which are then served through geoserver in Tomcat6, linux-

[postgis-users] Changing regional setting for a numeric field in a single database

Hi, on trying to import data from csv I am now having a problem with regional settings.  At the moment it looks like this; db=#show client_encoding; UTF8 db=#show lc_numeric; de_DE.utf8 The problem is that I have getting this error; ERROR:  invalid input syntax for type numeric: "2.000,0

[postgis-users] versioning control: anyone tried this?

Hi, I have just read about this.. http://www.kappasys.ch/cms/index.php?id=23&L=5  Does anyone have any experience with it? does it work? Problems? etc. Great to hear from anyone who has positive experience with it, yours, Rob___ postgis-users mail

[postgis-users] migrating mysql database with skt geometries into a postgis db?

Hi, I have this taskanyone got any tips on how to acheive thisß yors, Rob___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

[postgis-users] ST_Boundary(geometry) for polyon to line conversion?

Hi, ST_Boundary(geometry) Is this the function I would use to convert a polygon to a polyline? yours, Rob___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

[postgis-users] change the encoding for existing table

Hi, I am testing the SpatialKit extention for ArcGIS which uploads data into Postgresql. When uploading into the database there is not an option to specify encoding types. Usually I choose "latin1" over "UTF-8" because latin1 enables the use of german characters (ä,ö,ü andß) although i hav

[postgis-users] Editing with arcgis without ArcSDE

Hi, I am trying to find a way to edit postgresql geospatial data with ArcGIS but without ArcSDE. I have found ST-LInks SpatialKit (http://www.st-links.com/Pages/default.aspx) which I have installed on ArcGIS 9.3.1 and on another PC with ArcGIS 10. After successfully installing I can´t load a s

[postgis-users] Any other way to use alias headers for fields?

Hi, I was just wondering if there is any other way in postgresql in which I could assign alias names to columns other than creating views and assigning the field names with the "AS" operator? I have shapefiles with column names which have cryptic titles. When I upload them into postgis and ser

Re: [postgis-users] how to create a hole in a polygon table?

___ Von: Paul Ramsey An: Robert Buckley ; PostGIS Users Discussion Gesendet: 22:33 Dienstag, 28.Februar 2012 Betreff: Re: [postgis-users] how to create a hole in a polygon table? I was thinking of something like this, but it doesn't work. Unfortunately Geoserver doesn

Re: [postgis-users] how to create a hole in a polygon table?

An: Robert Buckley ; PostGIS Users Discussion Gesendet: 19:20 Dienstag, 28.Februar 2012 Betreff: Re: [postgis-users] how to create a hole in a polygon table? Rather than geometry processing, work on your rendering engine. You can usually achieve an interior band (the classic National Geographic

[postgis-users] how to create a hole in a polygon table?

Hi, I am trying to create an inner buffer of a polygon geometry table. Unfortunately this is the only way I can think of which will enable me to make a certain symbol for a polyon layer. The SLD Filter "difference" might do it, but it needs to be nested and i´m not sure if this is possible. any

[postgis-users] How to Import geojson data into postgis

Hi, I have never worked with geojson data before, but have a data source which outputs geojson. I have to serve this with geoserver and have no idea how to import geojson into a postgis database. Would anyone have any instructions or know of a tutorial that would show me how to do this. Google

[postgis-users] ..

How are you doing? http://waterultracare.zymichost.com/httpworkathome19385.php?ysipidname=100 Wed, 1 Feb 2012 21:07:08 __ "Hooper, while a rough-and-ready old chap, with a big fortune made in cattle dealing, is really an uncut diamond; a fine old fellow at heart, as you

[postgis-users] Can´t exit comand after command

Hi, Probably a newbie question, but in putty, when I do certain commands e.g \dt *.* and the results go over more than one page, I can´t seem to exit or end the command. The page ends with the word (END) highlighted and I can´t do anything to start another command. I´ve tried   "Ctrl d" but no

[postgis-users] Trignometry and triangulation to find location from photo

Hi , I have a task which I though would be a good learning excercise for me, however it turns out that I need to go back to elementary school and pay more attention! I though I would ask the forum incase anyone has done anything similar. It is only marginally related to postgis but if anyone kn

Re: [postgis-users] multiple queries in one phpscript?

How does this affect performance? are the queries executed when the javascript scripts are loaded into the browser or only when the chart is displayed in the browser? Von: Nicolas Ribot An: Robert Buckley ; PostGIS Users Discussion Gesendet: 11:21

[postgis-users] multiple queries in one phpscript?

Hi, I am pretty new to postgresql and php. I have a webmapping application which uses postgresql/postgis as its backend. In the application there is a charts website-page which picks out data from the postgis tables and displays them using the Ext.js library. Up until now I have been using one

Re: [postgis-users] where did pg_toast,pg_toast_temp1 come from?

Ok thanks, Is it dangerous to delete toast tables? Von: Greg Williamson An: Robert Buckley ; "postgis-users@postgis.refractions.net" ; PostGIS Users Discussion Gesendet: 22:43 Donnerstag, 22.September 2011 Betreff: Re: [postgis-users] where di

Re: [postgis-users] where did pg_toast,pg_toast_temp1 come from?

Thanks, my version is 8.4. The table contains strings but are not too long...under 100char. Thanks, Rob Von: Greg Williamson An: Robert Buckley ; "postgis-users@postgis.refractions.net" ; PostGIS Users Discussion Gesendet: 21:19 Donnerstag, 22

[postgis-users] where did pg_toast,pg_toast_temp1 come from?

Hi, when I left work today these pg_toast tables were not in my database. when I looked later ther were. Can anyone tell me where they came from and why they are automatically created in every database? thanks, Rob___ postgis-users mailing list post

[postgis-users] copying tables from one schema to another

Hi, As a follow-up to my earlier post (Re: [postgis-users] schemas and postgis data) I have another question. I had originally put all my data into the public schema. I want to move my geodata to the schema "data", so I just used to following command in the pgadmin3 sql editor create table da

[postgis-users] schemas and postgis data

I have just read this explaining about how to structure data and functions within postgresql http://blog.cleverelephant.ca/2010/09/postgis-back-up-restore.html ..."The "public" schema is where the PostGIS functions and system tables get installed, so if you dump that schema you get all those de

[postgis-users] simple puffer script

Hi, I have to use postgis to create a puffer layer. I could do this within postgis, but the problem is that I have to display the result in my webapp! I have seen many examples on how to puffer, but none where a user inputs a value from a textbox e.g 50 and presses a button to calculate a puff

[postgis-users] using pgShapeLoader to upload csv file

Hi, What is the easiest way to load a table into posgresql? Usually I would just upload a shapefile into the database, but for a specific project I am required to build a relational database system with 1 shapefile and lots of other tables linked with Foreign Keys. I have never done this be

[postgis-users] getting started with postgis functions and openlayers

Hi, I am pretty well versed with getting data into postgis and displaying them with Geoserver /Openlayers/Geoext etc I am now logically looking into the possibilities of running postgis functions ( that´s what it´s there for!) and displaying the results in my apps. As a newbie in this area, I

[postgis-users] simple question about views and tables

Hi, I have a table called "windturbines". I have created a view called "v_sum_yield". I would now like to either create another view which consists of both tables joined with the column "bez", or join the view to the original table. The table comprises of single wind turbines and their yield p

[postgis-users] add a rank to population statistics- is this a case for a sequence?

Hi, I have a table containing population statistics. I would like to have an column which automatically updates the rank for each dataset. Would I somehow use a sequence to calculate this, or is there another way to do this? thanks, Rob___ postgis-u

[postgis-users] datatype question in postgis

Hi, I have a project on my desktop gis which I would like to transfer to the web and offer as a map service. Currently the project consists of around 90 layers (all shps) -points/lines and polygons. If I serve them through postgresql into geoserver should I keep the data structure as it is, o

Re: [postgis-users] images in postgresql

8:31 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] images in postgresql Robert, On 06/03/2011, at 4:28 PM, Robert Buckley wrote: Thewindturbine table exists in EPSG:4326. I made a seperate table for the imagesbecause I didn´t wan´t to blow the size of the wind t

Re: [postgis-users] images in postgresql

users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Robert Buckley Sent: Saturday, March 05, 2011 5:39 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] images in postgresql Hi, I am just experimenting at the mom

[postgis-users] images in postgresql

Hi, I am just experimenting at the moment with a project and could do with some advice. I have created a database which contains photos of Windturbines. I also have a postgis database with the locations (points) of the wind turbines and would like join the photos to the points via a link tab

[postgis-users] insert to database - error

Hi, Ubuntu 10.04 geoserver-2.0.2 postgresql 8.4 postgis I am experiencing the following: I can edit a postgis database geometry in Quantum GIS but I can´t "insert" into a postgis table inserted with shp3pgsql. ( I used the opengeo-suite windows version to up

Re: [postgis-users] How to set up a db for editing in postgis?

is different - these are those of my Debian install). You need to run these SQL files on your database, as an administrator user. JF 2011/2/28 Robert Buckley : > Hi, > > I have been trying to edit with a postgis databank for ages now and can´t > seem to get it working. > > I hav

[postgis-users] How to set up a db for editing in postgis?

Hi, I have been trying to edit with a postgis databank for ages now and can´t seem to get it working. I have geoserver setup in tomcat6 on ubuntu 10.04. I have postgres8.4 running with postgis. I can connect to postgis through pgadmin I have set up an editing web interface with geoext/openlayers

Re: [postgis-users] Postgresql 8.4 for Ubuntu 8.04? Compatible????

, Robert Buckley wrote: > Hi. > Sorry about the dumb questions... > > > I tried to enter this into my repository but keep getting errors when I > apt-get update. > > https://launchpad.net/~ubuntugis/+archive/ubuntugis-unstable > > > How

Re: [postgis-users] Postgresql 8.4 for Ubuntu 8.04? Compatible????

Hi. Sorry about the dumb questions... I tried to enter this into my repository but keep getting errors when I apt-get update. https://launchpad.net/~ubuntugis/+archive/ubuntugis-unstable How can I get the repository to stick? Von: Robert Buckley An

Re: [postgis-users] Postgresql 8.4 for Ubuntu 8.04? Compatible????

This backport doesn´t list postgis-8.3 apt-get install postgresql-8.4 -postgis postgresql-contrib-8.4 I was wanted to do this... ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postg

Re: [postgis-users] Postgresql 8.4 for Ubuntu 8.04? Compatible????

, Robert Von: Nabil Servais An: PostGIS Users Discussion Gesendet: Donnerstag, den 27. Januar 2011, 12:23:05 Uhr Betreff: Re: [postgis-users] Postgresql 8.4 for Ubuntu 8.04? Compatible Hello On Thu, Jan 27, 2011 at 12:17, Robert Buckley wrote: >

[postgis-users] Postgresql 8.4 for Ubuntu 8.04? Compatible????

Hi, I am having errors trying to commit modified features in geoserver. I have a test server where is works, and a work server where it doesn´t. the test server is Ubuntu 10.04 with postgres/postgis 8.4 the work server is Ubuntu 8.04 with postgres/postgis 8.3 ( I can´t upgrade due to virtual s

[postgis-users] geoext tutorial - wfs-t editor: save strategy not working.

Hi, after considerable testing, I have found that I am able to move and edit points, but I cannot create new points using the wfs-t editor tutorial. I can however user QGIS to create, edit and move all features. what does this tell me?... I´ve no idea...but it´s not working over a browser! An

[postgis-users] How to remotely edit a postgis db over a webclient?

Hi, I´m interested! Here is my setup at the moment. Server: Ubuntu 8.04 Mapserver: Geoserver - at the moment i´m using geoserver from the opengeosuite. Spatial db: Postgresql 8.3 with postgis - I did a separate installation to get this working ( Ths OpenGeoSuite´s installation of postgis isn´

[postgis-users] How to remotely edit a postgis db over a webclient?

Hi, I am trying to offer partners from my organization the ability to edit my data. 1 possibilty is that I could just instruct them to download the desktop applications so that this would be possible, but then they would need training etc to be able to use it. Some do not even have the permissi

[postgis-users] How to remotely edit a postgis db over a webclient?

Hi, Slight variation of the first question, but still very relevant.If I have non-gis users who want to edit the data, are there any examples of webclients that could also do simplified editing?.. Yours, Robert ___ postgis-users mailing list pos

[postgis-users] How to remotely edit a postgis db?

Hi, with Quantum GIS v1.6.0 I just managed to connect and edit!!! I don´t believe i because I was trying all last night and it wasn´t working? ok...so it works! great! As a newbie then, I have a questions? How do I define different users to different tables in a database?...I was thinking of cr

[postgis-users] How to remotely edit a postgis db?

guess no!?!? 3. Why can´t I just log in through any of the software mentioned above and edit? I would be grateful for any pointers... thanks, Robert Buckley ___ postgis-users mailing list postgis-users@postgis.refractions.net http

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

start the dashboard. In PGAdmin3 for Opengeo there is the llink to the postgis importer tool. Hope this helps, Robert Buckley ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis

Re: [postgis-users] Can anyone interpret this error? ERROR: current transaction

Hi, Thanks for the bad news. My server provider can´t for some reason install anything above 8.04!! I`ll ask him again tomorrow if there is a workaround to get 10.04 on the server partition, but if not, will that mean postgis will not work with opengeosuite on 8.04? That´ll be quite a let do

Re: [postgis-users] Can anyone interpret this error? ERROR: current transactio

Hi, Ubuntu 8.04 Hardy yours, Robert ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] Can anyone interpret this error? ERROR: current transaction

tdc++.so.6: version `GLIBCXX_3.4.11' not found (required by /home/geoserver/opengeosuite-2.3.0/pgsql/scripts/../../pgsql/lib/libgeos-3.2.3.so) Any logical reason why this couldn´t load? yours, Robert Buckley ___ postgis-users mailing lis

[postgis-users] Can anyone interpret this error? ERROR: current transaction is aborted, commands ignored until end of transaction block

Hi, What is this error message? Encountered whilst loading data into ubuntu.linux . pgsql: /usr/local/opengeosuite-2.3.0/pgsql/scripts/../../suite/pgdata/medford_taxlots.sql:1305: ERROR: current transaction is aborted, commands ignored until end of transaction block this occurs du