On Wed, Jul 25, 2012 at 07:47:38AM -0600, Richard Greenwood wrote:
> On Wed, Jul 25, 2012 at 12:10 AM, Sandro Santilli wrote:
>
> >> I now see what you are looking at, and it's a typo in the docs.
> >
> > Could any of you guys file a ticket with a patch for this ?
>
>
> Ticket #1934
Fixed, tha
On Wed, Jul 25, 2012 at 12:10 AM, Sandro Santilli wrote:
>> I now see what you are looking at, and it's a typo in the docs.
>
> Could any of you guys file a ticket with a patch for this ?
Ticket #1934
--
Richard Greenwood
richard.greenw...@gmail.com
www.greenwoodmap.com
_
On Tue, Jul 24, 2012 at 10:40 PM, Mike Toews wrote:
> On 25 July 2012 13:48, Richard Greenwood wrote:
>> Okay, but there is an example in the doc's showing just geometry(srid)
>> which doesn't work for me. Guess that's what you're saying?
>
> I now see what you are looking at, and it's a typo in
On Wed, Jul 25, 2012 at 04:40:23PM +1200, Mike Toews wrote:
> On 25 July 2012 13:48, Richard Greenwood wrote:
> > Okay, but there is an example in the doc's showing just geometry(srid)
> > which doesn't work for me. Guess that's what you're saying?
>
> I now see what you are looking at, and it's
On 25 July 2012 13:48, Richard Greenwood wrote:
> Okay, but there is an example in the doc's showing just geometry(srid)
> which doesn't work for me. Guess that's what you're saying?
I now see what you are looking at, and it's a typo in the docs.
> I'm dealing with a view, not a table. My table
On Tue, Jul 24, 2012 at 4:10 PM, Mike Toews wrote:
> On 25 July 2012 09:49, Richard Greenwood wrote:
>> I am having difficulty getting my views' SRIDs into the
>> geometry_columns view in PostGIS 2.0. The doc's [1] suggest casting
>> the geometry in the view so I tried:
>>wkb_geometry::geomet
On 25 July 2012 09:49, Richard Greenwood wrote:
> I am having difficulty getting my views' SRIDs into the
> geometry_columns view in PostGIS 2.0. The doc's [1] suggest casting
> the geometry in the view so I tried:
>wkb_geometry::geometry(3739)
> which generates the error:
>ERROR: Invalid
I am having difficulty getting my views' SRIDs into the
geometry_columns view in PostGIS 2.0. The doc's [1] suggest casting
the geometry in the view so I tried:
wkb_geometry::geometry(3739)
which generates the error:
ERROR: Invalid geometry type modifier: 3739
next I tried:
wkb_geometry:
There's no such thing as a PostGIS SRID, the SRID only has true
meaning local to a database instance. Now, because we happen to
install a spatial_ref_sys.sql file which not only has SRID values but
makes them identical to the EPSG numbers, there is an assumption that
the SRID == EPSG number, but th
The stock SRID in PostGIS for items from the EPSG database is always going
to be the same as the EPSG code. The PostGIS insert statement is for adding
spatial references to your PostGIS install.
David
On Wed, Sep 22, 2010 at 12:36 PM, David Fawcett wrote:
> OK, that makes sense.
>
> So, it works
OK, that makes sense.
So, it works well when installing additional SRS' , you won't mess up
your stock spatial_ref_sys.
The use case that I was going after was where a co-worker wanted to
know what srid to use when importing data from a shapefile. I was
attempting to use spatialreference.org as
David,
spatialreference.org uses a local SRID with a prepended '9' while
maintaining an auth_srid to match EPSG so as not to step on the toes of the
SRIDs that are already in the spatial_ref_sys table. While a bit ugly, this
is the intended behavior. It uses the '9' because there are no EPSG codes
A minor issue here, but I am looking for some clarification.
I am seeking the correct PostGIS srid for UTM Z15N NAD83.
If I query spatialreference.org,
(http://spatialreference.org/ref/epsg/26915/postgis/) I get:
INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text,
srtext) values
On Mon, Sep 14, 2009 at 2:57 AM, Mark Cave-Ayland
wrote:
> Brent Pedersen wrote:
>
>> hi, i'm seeing some behavior i dont understand, i'm pasting a shell
>> session for postgresql 8.3.7 below.
>> can someone explain why i'm getting the error from the first command?
>> the wkb has srid 4326 as does
Brent Pedersen wrote:
hi, i'm seeing some behavior i dont understand, i'm pasting a shell
session for postgresql 8.3.7 below.
can someone explain why i'm getting the error from the first command?
the wkb has srid 4326 as does the dwr_well.geom field. and
it's in the geometry_columns table as suc
hi, i'm seeing some behavior i dont understand, i'm pasting a shell
session for postgresql 8.3.7 below.
can someone explain why i'm getting the error from the first command?
the wkb has srid 4326 as does the dwr_well.geom field. and
it's in the geometry_columns table as such. i've found i can get t
Thanks - you pointed me in the right direction, but I've found a slightly
different, simpler problem. When I copied the query to insert the 900913
projection into PostGIS from the web, the carriage return in the middle of
the proj4text got inserted. This resulted in something that still seemed to
By saying @nadgrids=null you are implicitly saying "please don't try
to do spheroid conversions for me". In cases where you are already in
WGS84, this is good. In other cases, it isn't. The @nadgrids hack was
invented by folks in North America, where their data is usually
already in NAD83, which i
I've applied the following script to my database to install support for the
Google Spherical Mercator projection, plus to fix the well known datum
missing for SRID 27700:
INSERT into spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text)
values (900913 ,'EPSG',900913,'GEOGCS["WGS 84", DAT
I am looking for the correct SRID to use in PostGIS for some data that
is in LCC.
Here is the ESRI text summary:
Projected Coordinate System: NAD_1983_Lambert_Conformal_Conic
Projection: Lambert_Conformal_Conic
False_Easting: 0.
False_Northing: 0.
Central_Meridian: -97.
St
Hi Lisek,
http://www.fc.up.pt/pessoas/jagoncal/coordenadas/index.htm
Fred.
On Wed, Nov 19, 2008 at 9:54 AM, Nicolas Ribot <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > last time i get shapefile witp Porto Portugal streets.
> > I convert it to SQL an there was a column with data in SRID 27492.
> Hello,
>
> last time i get shapefile witp Porto Portugal streets.
> I convert it to SQL an there was a column with data in SRID 27492.
> I added this data to database, create another column with 4326 SRID and
> transform data from 27492 to 4326 using:
>
> UPDATE axes SET the_geom_wgs = Transform(
Hello,
last time i get shapefile witp Porto Portugal streets.
I convert it to SQL an there was a column with data in SRID 27492.
I added this data to database, create another column with 4326 SRID and
transform data from 27492 to 4326 using:
UPDATE axes SET the_geom_wgs = Transform(the_geom,4326)
[EMAIL PROTECTED] wrote:
Hi guys,
I'm not sure what is going on here:
I am working with some strata boundaries for a fisheries survey, mostly depth
based strata. SRID=4326
I also have some polygons of areas of untrawlable seabed & want to generate
these cropped by stratum. SRID=4326
Aas a
PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, October 30, 2008 9:31 PM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] SRID confusion
Hi Regina,
Still using 1.1 on this system.
The isssue I have is that any geometry created by a postgis geometry
processin
T have
the internal SRID specified, but PostGIS is only creating multipolygons with
the internal SIDs explicitly specified.
Cheers
Brent
--- On Fri, 10/31/08, Paragon Corporation <[EMAIL PROTECTED]> wrote:
> From: Paragon Corporation <[EMAIL PROTECTED]>
> Subje
[EMAIL PROTECTED] wrote:
select srid(hole), astext(hole) from hole_multi;
I get:
4326 | MULTIPOLYGON(SRID=0;((55.78
Er? This is not a valid WKT string. Is this a typo? It's no doubt
QGIS can't parse this.
AsEWKT, as Regina mentions, produces "SRID=0;MULTI..."
AsText should just p
MAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, October 30, 2008 5:37 PM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] SRID confusion
Hi Regina...
To add to my confusion:
I'm using AsText, as in the original example below.
If I try to open this multipolygon with QGI
Is this a bug in how geomunion() write the geometry? Does it include the
constituent SRID's when it shouldn't?
Thanks
Brent
--- On Fri, 10/31/08, Paragon Corporation <[EMAIL PROTECTED]> wrote:
> From: Paragon Corporation <[EMAIL PROTECTED]>
> Subject: RE: [po
PM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] SRID confusion
Hi guys,
I'm not sure what is going on here:
I am working with some strata boundaries for a fisheries survey, mostly
depth based strata. SRID=4326
I also have some polygons of areas of untrawlable seabed & wa
Hi guys,
I'm not sure what is going on here:
I am working with some strata boundaries for a fisheries survey, mostly depth
based strata. SRID=4326
I also have some polygons of areas of untrawlable seabed & want to generate
these cropped by stratum. SRID=4326
Aas a step in this process I crea
Hi,
I think I'm missing something with SRIDs and transformations but I don't
really know what!!!
I have some POIs in WGS84 [ex. SRID=4326;POINT(-1.78103 51.09168)].
When I transform them into "OSGB 1936 / British National Grid" I use the
function: Transform(the_geom,27700) so the result for the
Vyron Antoniou wrote:
Hi,
I think I'm missing something with SRIDs and transformations but I don't
really know what!!!
I have some POIs in WGS84 [ex. SRID=4326;POINT(-1.78103 51.09168)].
When I transform them into "OSGB 1936 / British National Grid" I use the
function: Transform(the_geom,27700
Hi Mark,
Thanks for the reply. Indeed I'm using PROJ 4.4.9!
I guess it is time for the upgrades that I was postponing for so long.
Thanks again,
Vyron
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/m
ion.
>
> Bob
>
>
> ----- Original Message - From: "Chris Hermansen"
> <[EMAIL PROTECTED]>
> To: "PostGIS Users Discussion"
> Sent: Monday, May 26, 2008 6:05 PM
> Subject: Re: [postgis-users] srid
>
>
>> Or, in another direction...
ying their position.
Bob
- Original Message -
From: "Chris Hermansen" <[EMAIL PROTECTED]>
To: "PostGIS Users Discussion"
Sent: Monday, May 26, 2008 6:05 PM
Subject: Re: [postgis-users] srid
Or, in another direction... Bob, if your "geometrical data" is
7
> > Para: postgis-users@postgis.refractions.net
> > Assunto: [postgis-users] SRID and EPSG
> >
> > The sql scripts can be found here:
> > http://downloads.sourceforge.net/dspatial/PostgreSQL-CRS.zip.
> > Note that v6.8 was used to develop this and EPSG is now
OTECTED] On Behalf Of Obe,
Regina
Sent: Tuesday, May 27, 2008 9:37 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] srid
Bob,
This looks neat. Don't quite understand all of it, but will be
interesting to see what the final finished product looks like.
This vaguely reminds me o
ractions.net
Subject: [postgis-users] SRID and EPSG
What version of EPSG-codes are used by PostGIS? I have just downloaded and
installed PostgreSQL (MS Windows) and I couldn't find anything about this
subject in the documentation.
Thanks
___
postgis-u
What version of EPSG-codes are used by PostGIS? I have just downloaded and
installed PostgreSQL (MS Windows) and I couldn't find anything about this
subject in the documentation.
Thanks
___
postgis-users mailing list
postgis-users@postgis.refractions.net
SRID is an index into the table of datums/projections/coordinate
systems that PostGIS maintains; the commands to create that table are
in the file spatial_ref_sys.sql that comes with the distribution.
If you want to build your own transformation, you could start with one
of the listed INSER
Hi
I am attempting to learn Postgis to use as a geometric tool rather than a
geographic tool.
The function ST_Transform(geometry, integer) seems to be potentially quite
useful.
Apparently, the integer required is the new coordinates referenced by the
srid. Is there some way of building a
Correct
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lee
Hachadoorian
Sent: Wednesday, March 12, 2008 3:38 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] SRID and unprojected (Census) data
Regina, Leo, Chris,
I had previously installed
Regina, Leo, Chris,
I had previously installed from packages on Ubuntu Linux, which means
Postgres 8.2 and PostGIS 1.2 (repositories aren't up to date). I just
decided to build everything from source (Postgres, Proj4, GEOS, and
PostGIS), and SRID 4269 is in spatial_ref_sys. I don't think it
you decide.
Hope that helps,
Regina and Leo
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lee
Hachadoorian
Sent: Tuesday, March 11, 2008 10:35 PM
To: PostGIS Users
Subject: [postgis-users] SRID and unprojected (Census) data
Can someone please give me s
Lee,
What about EPSG: 4269?
On Tue, Mar 11, 2008 at 8:35 PM, Lee Hachadoorian <
[EMAIL PROTECTED]> wrote:
> Can someone please give me some ideas, or pointers to where this
> question is answered elsewhere, on how to handle unprojected geographic
> data in PostGIS? Would I just create the table
Can someone please give me some ideas, or pointers to where this
question is answered elsewhere, on how to handle unprojected geographic
data in PostGIS? Would I just create the table with SRID = -1? The US
Census makes several cartographic boundary files available using the
NAD83 datum, but
problem.
Hope that helps,
Regina
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Guido Lemoine
Sent: Wednesday, February 06, 2008 9:33 AM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] SRID 32767 or 4326
Dear All,
My colleague instal
lto:[EMAIL PROTECTED] On Behalf Of
Guido Lemoine
Sent: Wednesday, February 06, 2008 9:33 AM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] SRID 32767 or 4326
Dear All,
My colleague installed postgis 1.3 recently. He then inserted some KML
polygon
data using (GDAL) ogr2ogr. Th
Dear All,
My colleague installed postgis 1.3 recently. He then inserted some KML
polygon
data using (GDAL) ogr2ogr. This gets loaded in a table which has it's SRID
set to 32767.
In the 1.3 version of the spatial_ref_sys table, SRID=32767 is defined as a
longlat projection.
In MY 1.2 version o
El jue, 20-12-2007 a las 11:58 -0800, Bochengedu Somolekae escribió:
> Anybody with the knowledge of Alberta Canada(3TM/10TM) QGIS SRSID:
> PostGIS SRID:
>
>
> __
> Never miss a thing. Make Yahoo your homepage.
> ___
Anybody with the knowledge of Alberta Canada(3TM/10TM) QGIS SRSID:
PostGIS SRID:
-
Never miss a thing. Make Yahoo your homepage.___
postgis-users mailing list
postgis-users@postgis.refractions.net
http:/
Hella All-
I am new to PostGIS, and have slowly been making some headway...
I have created a database that contains two tables, a set of Points, and
a set of MULTIPOLYGON. Following the directions, and with some false
starts,
I have a geometry_columns table with two entries, one for a field in
Is this what you're looking for?
http://spatialreference.org/ref/epsg/102671/
It looks like there is now an output format for "PostGIS spatial_ref_sys
INSERT statement". I'm not sure if it's what you need, but it might be
worth a look.
Jason
Thanks, that kinda did, it reminded me of somethi
Ryan D. Enos wrote:
--
I have determined that I am pretty sure that the SRID I am using is
incorrect and the previous user was advised to use 102671, which is said
to be the same as 26971 except that it uses the U.S. foot. However,
when I attempt to transform using this SRID in postres
Hi,
I'm new to postgis and gis in general. I see in the text of the email
posted here:
http://postgis.refractions.net/pipermail/postgis-users/2005-May/008226.html
that someone once asked about the srid for files from the city of
Chicago. I am dealing with similar files now and I am having sim
56 matches
Mail list logo
