I am brand-new to PostGIS and PostGre. I have just installed PostGre
9.1, and installed PostGIS 1.5.3 with the PostGre install (the PostGre
install prompted me if I wanted to download and install it, and I
checked it).
Now I see on the PostGIS web page, it says to install Proj4 and GEOS 3.2
/www.postgis.us
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of
Bistrais, Bob
Sent: Friday, February 10, 2012 2:36 PM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] Question on new PostG
I am having trouble on a pretty basic level. I loaded a couple
shapefiles into PostGIS. I can see that they successfully loaded when I
use pgAdmin. But when I go to command line, I have trouble. I can do a
\d command and see the tables exist in the database. But if I do a
select * from mytable
ng tables
Bob, do you review if there exists mytable in the geometry_columns
table?
How do you loaded this table?
Francisco salas
De: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] En nombre de
Bistrais, Bob
Enviado el: lunes, 13
users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of
pcr...@pcreso.com
Sent: Monday, February 13, 2012 5:06 PM
To: PostGIS Users Discussion
Cc: Bistrais, Bob
Subject: Re: [postgis-users] Trouble seeinglisting tables
Nothing obvious that I can see.
ps
.@pcreso.com
Sent: Monday, February 13, 2012 5:06 PM
To: PostGIS Users Discussion
Cc: Bistrais, Bob
Subject: Re: [postgis-users] Trouble seeinglisting tables
Nothing obvious that I can see.
psql -d
\d # should list the tables
\d mytable # should list the structure of the
___
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of
pcr...@pcreso.com
Sent: Monday, February 13, 2012 5:06 PM
To: PostGIS Users Discussion
Cc: Bistrais, Bob
Subject: Re: [postgis-users] Trouble seeinglisting tables
Not
CLASS
NAME "Suelos"
STYLE
ANGLE 360
COLOR 174 183 180
OPACITY 100
OUTLINECOLOR 35 80 65
SYMBOL 0
END
END
END
Francisco Salas
De: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...
: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of
pcr...@pcreso.com
Sent: Monday, February 13, 2012 5:06 PM
To: PostGIS Users Discussion
Cc: Bistrais, Bob
Subject: Re: [postgis-users] Trouble seeinglisting tables
Nothing obvious that I can
So at this point I figured out how to get a PostGIS layer to display
through MapServer, but that is only where host=localhost. Now I'm
trying to figure out how to access the data from other machines. I'm
looking through the documentation but haven't found out how yet. Can
anyone point me in the
l for users with dynamic ip
address allocation.
good luck.
cheers
Ben
On 14/02/2012, at 11:04 PM, Bistrais, Bob wrote:
So at this point I figured out how to get a PostGIS layer to display
through MapServer, but that is only where host=localhost. Now I'm
trying t
As some of you already know, I'm a newbie to PostGIS and have just
barely got a test PostGIS database up and running. So, my latest
question is in regards to draw times. I created a statewide parcel
layer from a shapefile. At statewide scale, when the application loads,
the parcel data draws far
esday, February 14, 2012 2:15 PM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] advice for quicker display?
On 2/14/2012 1:57 PM, Bistrais, Bob wrote:
> As some of you already know, I'm a newbie to PostGIS and have just
> barely got a test PostGIS database up
From: Stephen Woodbridge
Subject: Re: [postgis-users] advice for quicker display?
To: postgis-users@postgis.refractions.net
Date: Wednesday, February 15, 2012, 8:14 AM
On 2/14/2012 1:57 PM, Bistrais, Bob wrote:
> As some of you already know, I'm a newbie to PostGIS and have just
> b
[postgis-users] advice for quicker display?
You can find the documentation here. Also look at ST_SimplifyPreserveTopology,
might be better depending on how strict you are with how your data gets
modified.
http://postgis.org/docs/ST_Simplify.html
On Tue, Feb 14, 2012 at 3:09 PM, Bistr
s-users] advice for quicker display?
DATA "the_geom from (select ST_Simplify(the_geom, 10.0) as the_geom from
mytable) as foo USING SRID=26919 USING Unique gid"
On 2/15/2012 11:03 AM, Bistrais, Bob wrote:
> OK, I am trying to use the ST_simplify command but I'm not doing i
oun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Sandro
Santilli
Sent: Wednesday, February 15, 2012 2:50 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] advice for quicker display?
On Wed, Feb 15, 2012 at 02:26:19PM -0500, Bistrais, Bob
SRID=26919 USING Unique gid"
-Steve W
On 2/15/2012 2:58 PM, Bistrais, Bob wrote:
> Interesting- that works until I zoom in to about 1:5 scale, then
> the layer stops drawing with this error:
>
> prepare_database(): Query error. Error declaring cursor: ERROR:
> column "map
es.
I'm suprised that the fully qualified domain name of the machine is
working - the documentation has :
IP addresses can only be specified numerically, not as domain or
host names
cheers
Ben
On 15/02/2012, at 12:46 AM, Bistrais, Bob wrote:
Hi Ben,
(Also posted on MapServer and GeoMoose lists, please excuse the
duplication)
I'm having trouble doing an attribute query on a PostGIS layer. The
data in this layer was formerly in shapefile, and the query worked fine
with it. But with the PostGIS layer, I get no results.
The PHP MapScript
You should check the metadata for the layer. But by convention, cell
values on a raster layer are generally the value at the center of each
cell.
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Beh
21 matches
Mail list logo