On Thu, Apr 05, 2012 at 09:25:40AM +1000, Evan Martin wrote:
70 west, 10 north is in venezuela which is outside the bounds of
available NAD27 to NAD83 conversion files. Try (-120 40).
Thanks, Frank. Yes, (-120 40) works. Just to confirm, will PostGIS
always return the input coordinates now
Hi all,
I'm using PG 9.1.3 with pgAdmin 1.14.2 on Windows 7 Home Edition to
get familiar with PostGIS and TimeZone data.
PostGIS 1.5.3 is installed and the postgis database was created by the
installer.
My immediate end goal is to be able to take a Lat/Lon and query PG to
find the correct
hi
where can i find postgis 1.5 for 9.1 postgresql 64-bit(windows) installer?
best regards
superman0920___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Hello,
On the website e.g http://www.postgis.org/download/windows/#windbinaries
Regards
ThomasG
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Hi Jack,
I believe that your problem is that the 4326 projection does have a 3rd
dimension. I think I saw that 4329 is the one you'll want.
cheers,
a
On Thu, Apr 5, 2012 at 9:34 AM, Gold, Jack L (US SSA)
jack.g...@baesystems.com wrote:
Recently updated to beta5 and now I’m having problems
On Thu, Apr 05, 2012 at 09:34:32AM -0400, Gold, Jack L (US SSA) wrote:
Recently updated to beta5 and now I'm having problems with selections on a
geography column when I do ST_geographyFromText('0 0 0', 4326). I get:
ERROR: Geometry has Z dimension but column does not. The column is
Thanks Steve, let me explain you a bit the problem:
1. the geographical positions of these tracks were recorded with a device
without enough precision, this is, instead of having for example:
67.534221 9.988212
67.534223 9.988210
67.534225 9.988207
I'm getting:
67.534100 9.987500
67.534100
Thanks Bob, in fact I posted that recently to the list, it is exactly what
I'm looking for, the output image posted by David Bitner reflects exactly my
problem, however he used 4 parameters for this process, but I only have two,
i.e., longitude and latitude in geographical coordinates (WGS84). So,
I didn't read into the solution he provided, so I don't know the background of
the parameters he's using, but I would suspect that are intended for R to use
as some sort of smoothing config. Unless I'm mis reading your reply.
I've never used R myself, but I have looked at it's capabilities,
select distinct lat, lon
unless I misunderstood the problem...
steve
Gery gameji...@hotmail.com@postgis.refractions.net
Envoyé par : postgis-users-boun...@postgis.refractions.net
2012-04-05 11:15
Veuillez répondre à
PostGIS Users Discussion postgis-users@postgis.refractions.net
A
Can someone explain the difference between the two types of shape
files and the advantages/disadvantages of each in more general terms?
As far as I understandd from http://efele.net/maps/tz/world/:
and a TZ timezone will sometimes have multiple polygons. for the
first file, and
and there is
What does that mean in use? I'm not familiar with this stuff yet. :)
On Thu, Apr 5, 2012 at 9:41 AM, Nicolas Ribot nicolas.ri...@gmail.com wrote:
Can someone explain the difference between the two types of shape
files and the advantages/disadvantages of each in more general terms?
As far
My apologies, I sent the previous post in a hurry. Below is the query I am
using to insert a geography from text. I still receive the error indicated. I
am, in fact, looking to insert a geography with a Z value.
CREATE TABLE myTable(location geography(PointZ,4326));
INSERT INTO myTable
On Thu, Apr 05, 2012 at 01:53:59PM -0400, Gold, Jack L (US SSA) wrote:
My apologies, I sent the previous post in a hurry. Below is the query I am
using to insert a geography from text. I still receive the error indicated.
I am, in fact, looking to insert a geography with a Z value.
On Thu, Apr 5, 2012 at 11:15 AM, Sandro Santilli s...@keybit.net wrote:
On Thu, Apr 05, 2012 at 01:53:59PM -0400, Gold, Jack L (US SSA) wrote:
My apologies, I sent the previous post in a hurry. Below is the query I am
using to insert a geography from text. I still receive the error
Working here. It's a problem with the st_geographyFromText somehow,
you can insert values into the table if you feed it text directly.
INSERT INTO myTable (location) VALUES ('SRID=4326;PointZ(85 35 500)');
P
On Thu, Apr 5, 2012 at 11:16 AM, Paul Ramsey pram...@opengeo.org wrote:
On Thu, Apr 5,
Il giorno gio, 05/04/2012 alle 11.16 -0700, Paul Ramsey ha scritto:
On Thu, Apr 5, 2012 at 11:15 AM, Sandro Santilli s...@keybit.net wrote:
On Thu, Apr 05, 2012 at 01:53:59PM -0400, Gold, Jack L (US SSA) wrote:
My apologies, I sent the previous post in a hurry. Below is the query I
am
Fixed.
http://trac.osgeo.org/postgis/ticket/1755
On Thu, Apr 5, 2012 at 11:23 AM, Salvatore Larosa lrssv...@gmail.com wrote:
Il giorno gio, 05/04/2012 alle 11.16 -0700, Paul Ramsey ha scritto:
On Thu, Apr 5, 2012 at 11:15 AM, Sandro Santilli s...@keybit.net wrote:
On Thu, Apr 05, 2012 at
I'm beginning to think the problem is actually a corrupted database. I don't
even have a geometry_columns table anymore. The SELECT Postgis_full_version()
results in postgis_libjson_version() error shown below. I'm going to call it a
corrupted database and rebuild from scratch. Thanks for
Il giorno gio, 05/04/2012 alle 11.25 -0700, Paul Ramsey ha scritto:
Fixed.
http://trac.osgeo.org/postgis/ticket/1755
Sorry, I had escaped. Now everything works fine!
Cheers,
-SL
___
postgis-users mailing list
postgis-users@postgis.refractions.net
Thanks for your suggestion Pierre. I am working with v2.0 and it seems that
ST_PixelsAsPolygons() is not available. The singular Pixel version works
though. Any idea why that would be?
Peter
On Wed, Apr 4, 2012 at 7:31 AM, Pierre Racine
pierre.rac...@sbf.ulaval.cawrote:
I would like to create
Thanks for your suggestion Pierre. I am working with v2.0 and it seems that
ST_PixelsAsPolygons() is not available. The singular Pixel version works
though.
Any idea why that would be?
Try ST_PixelAsPolygons()... (without the firs 's')
___
Scott,
It's greyed out if you don't have a database selected. As long as your
database
has postgis installed, it should work fine.
Regarding world files as I recall, I think the 394 one has one record per
TZ, and the other has further broken out.
I usually use the 28,000 one for spatial
I am working with postgis 2.0.0 and have found several issues when trying to
upload shapefiles into a postgis database.
The most pressing issue I have found is that when setting up the postgis
extension in a schema other than public, AddGeometryColumn() completely
fails to do anything.
For
You'll want to make sure that the postgis schema is in the user
account's search_path.
-bborie
On 04/05/2012 03:05 PM, THX1138 wrote:
I am working with postgis 2.0.0 and have found several issues when trying to
upload shapefiles into a postgis database.
The most pressing issue I have found
It sounds like you might have a mix of postgis installs. Did you upgrade
from a prior version and how did you do it?
What does
SELECT postgis_full_verion();
return.
I just moved my postgis extension from public to postgis schema. Added
postgis to my search path and then imported a shape
He has that it seems in fact he has it in the first slot since all his test
tables are being created in postgis. It should be at the end.
The AddGeometryColumn error and non-unique would happen if you have some
obsolete functions in your install. All these would be in public if they
are from an
27 matches
Mail list logo