PostGIS users

headers David B�langer | 1 Jun 2012 02:54

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Hello Sandro and Regina (et al);

Thank you both for solving that first problem ("when all else fails,
RTFM" !!  I did some digging for info regarding pgadmin3 as kindly
suggested by Regina (see below) - hope it is useful.

Rather predictably, answering that single first question brings me to
my next two questions (I suppose this is progress after a fashion):

(1) Performance (or lack thereof): I am attempting to create topology
out of a rather large (36MPixel) SRTM elevation raster.  I am
currently using a very small tile as the processing times I am seeing
suggest using a calendar rather than a stopwatch to profile my code.
Is there some obvious thing I should be doing to speed things up?
Perhaps something analogous to how raster2pgsql emits an SQL file
rather than doing a pixel-at-a-time update?  Or perhaps I am going
about this entirely the wrong way?  (I had similar performance
problems in simply reading the raster out of PostGIS, but that was
more straightforward to work around...)

(2) Are there any "gotchas" of which I should be aware due to "no
proper 3D topology support?"  False co-planarity issues?  Limitations
to modeling road overpasses, etc?

As for pgadmin3 (which I had been using to try and figure this out
myself), I did some digging as Regina kindly suggested.  FYI I am
using revision 1.14.0.  When I select the node table's geom column,
the "Data type" as displayed in the properties window is
"geometry(1107458)."  The context menu's "properties" display shows a
data type of simply "geometry."

However, if the SQL pane is open, it shows a fragment of SQL ("ALTER
TABLE"...), including "ADD COLUMN geom geometry(PointZ, 4326)."

So it WAS visible, presuming I knew where to look (and I didn't).

Sorry, and thanks again for the help!

-jm

On Wednesday 30 May 2012, Sandro Santilli wrote:
> On Tue, May 29, 2012 at 10:01:35PM -0400, John Morrison wrote:
> > Hi;
> > 
> > Sorry if this is a dumb newbie question regarding support for 3D
> > topology (as I am relatively new to both SQL and PostGIS).
> > 
> > I am running PostGIS 2.0.1SVN r9732 on FC16/x86_64.
> > 
> > When I try to add a 3D point to a topology via either ST_AddIsoNode or
> > AddNode, I get an error of the form "Geometry has Z dimension, but
> > column does not."  Adding 2D points seems to work fine.
> 
> There's no proper 3D topology support, but you do can equip your
> primitives with a per-vertex Z value (2.5D) if you account for it
> at topology creation time. See manual page entry for CreateTopology
> on how to do that.
> 
> > pgadminIII gives a rather cryptic type of "geometry(1107456)" as the
> > data type of the "geom" column of the "node" table of my topology.
> 
> That is annoying, I would expect something like "geometry(point)"
> or "geometry(pointZ)" instead. Do types of other spatial tables
> look fine in pgadminIII or is it a general issue with any geometry
> column ?
> 
> --strk;
> 
>   ,------o-.
> 
>   |   __/  |    Delivering high quality PostGIS 2.0 !
>   |  
>   |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
> 
>   `-o------'
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users <at> postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

--

-- 
--- John Morrison
--- john.nmi.morrison <at> gmail.com

I have a postgis table that contains radar. My problem is every 3
minutes I update the radar table and sometimes the end user has no
radar showing due to the new data loading
is there a more effective way than doing it like I am with the following code,

shp2pgsql -D -a -s 4269 last.shp base05 > base05.sql
psql -c "TRUNCATE TABLE base05" -d wxserver
psql -d wxserver -f base05.sql

I was dropping the table but that would cause my wms server to freakout.

You can run ddl in a transaction context, so the best way is to 

. Upload data to mynewtable
. Begin
. Alter table mytable rename to myoldtable
. Alter table mynewtable rename to mytable
. Commit
. Drop table myoldtable

P.

On 2012-06-03, at 7:02 AM, chris brisendine <ki4gyw <at> gmail.com> wrote:

> I have a postgis table that contains radar. My problem is every 3
> minutes I update the radar table and sometimes the end user has no
> radar showing due to the new data loading
> is there a more effective way than doing it like I am with the following code,
> 
> shp2pgsql -D -a -s 4269 last.shp base05 > base05.sql
> psql -c "TRUNCATE TABLE base05" -d wxserver
> psql -d wxserver -f base05.sql
> 
> I was dropping the table but that would cause my wms server to freakout.
> _______________________________________________
> postgis-users mailing list
> postgis-users <at> postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

On 6/3/2012 12:33 PM, David Quinn wrote:
> Hi List,
>
> I have been using the following approach to load a shapefile into my
> database locally:
>
> shp2pgsql -s 2831 -i -I -D D:/test.shp public.test_shapefile | psql.exe
> -U postgres -d test_db -h localhost -p 5432
>
> I now want to try to load spatial data into a database in a remote
> location. For the second part of my command, I tried the following:
>
> psql.exe -U postgres -P password -d test_db_remote -h 75.75.75.75 -p 5432
>
> I've tried a few variations of this without success. Is there anything
> that I am missing?
>
> If it is relevant, psql.exe is on a windows 7 computer, and I am
> uploading the data to a postgres database on an ubuntu installation.

The server has to be configured to listen on 75.75.75.75 and to allow 
connection over the network device.

Look at your pg_hba.conf and postgresql.conf files. and if you make 
changes to these you have to restart the server before the changes take 
effect.

-Steve

Mon	Tue	Wed	Thu	Fri	Sat	Sun

				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30

68	June 2013
151	May 2013
141	April 2013
94	March 2013
201	February 2013
280	January 2013
220	December 2012
302	November 2012
348	October 2012
247	September 2012
149	August 2012
299	July 2012
289	June 2012
468	May 2012
541	April 2012
612	March 2012
561	February 2012
244	January 2012
352	December 2011
302	November 2011
371	October 2011
249	September 2011
240	August 2011
322	July 2011
352	June 2011
222	May 2011
196	April 2011
320	March 2011
232	February 2011
290	January 2011
241	December 2010
180	November 2010
219	October 2010
223	September 2010
251	August 2010
326	July 2010
151	June 2010
323	May 2010
193	April 2010
323	March 2010
176	February 2010
325	January 2010
196	December 2009
280	November 2009
299	October 2009
310	September 2009
266	August 2009
320	July 2009
179	June 2009
282	May 2009
201	April 2009
235	March 2009
243	February 2009
322	January 2009
265	December 2008
278	November 2008
384	October 2008
338	September 2008
329	August 2008
303	July 2008
481	June 2008
499	May 2008
444	April 2008
324	March 2008
240	February 2008
369	January 2008
196	December 2007
297	November 2007
361	October 2007
285	September 2007
342	August 2007
341	July 2007
358	June 2007
346	May 2007
382	April 2007
266	March 2007
306	February 2007
259	January 2007
278	December 2006
341	November 2006
303	October 2006
326	September 2006
237	August 2006
271	July 2006
256	June 2006
323	May 2006
270	April 2006
379	March 2006
351	February 2006
505	January 2006
318	December 2005
331	November 2005
337	October 2005
355	September 2005
296	August 2005
277	July 2005
323	June 2005
378	May 2005
322	April 2005
418	March 2005
305	February 2005
280	January 2005
185	December 2004
247	November 2004
300	October 2004
247	September 2004
246	August 2004
161	July 2004
192	June 2004
224	May 2004
257	April 2004
279	March 2004
297	February 2004
149	January 2004
174	December 2003
166	November 2003
192	October 2003
152	September 2003
243	August 2003
129	July 2003
141	June 2003
130	May 2003
116	April 2003
1	November 2002
1	August 2001

Re: PostGis Raster and GDAL 1.9

PostGIS through xCode

Re: PostGIS through xCode

Re: PostGIS through xCode

Re: PostGIS through xCode

Re: 3D topology nodes?

more effective way?

Re: more effective way?

Loading a shapefile into a postgres database remotely

Re: Loading a shapefile into a postgres database remotely