Aren,
You need a reference projection, you are correct.
For the sake of the exercise, bookmark
http://spatialreference.org/
and then try the search box for parts of the string which are maybe unusual :
I tried
"Standard_Parallel_1",27.5 Lambert_Conformal_Conic
in the search box.
then I re
Plug that WKT into http://prj2epsg.org and the answer appears to be EPSG:3082
http://prj2epsg.org/epsg/3082
P
On Sat, Jan 8, 2011 at 8:18 PM, Aren Cambre wrote:
> I have a SHP with this in its PRJ file:
>
> PROJCS["Custom",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID[
I have a SHP with this in its PRJ file:
*
PROJCS["Custom",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",150.
Ben has the solution.
Indeed, the geometry column primary key was messed up. I deleted the old
one, added the gid serial integer column and set it to the primary key.
Works like a charm.
On 1/8/2011 5:11 PM, Ben Madin wrote:
Byron,
A little bit more information may help here - what do you m
Hello everybody
I want to have a complete picture of postgis geometry data type. Could
anyone give me a flow-chart, like the OGC geometry object model??
I know that postgis supports point, linestring, polygon, multipoint,
multilinestring, multipolygon, geometrycollection and curved geometries.
Wha
On 1/8/2011 5:11 PM, Ben Madin wrote:
Byron,
A little bit more information may help here - what do you mean by 'importing'
the table into QGIS?
Ach, "Add PostGIS Layer" was use.
Have you checked that the primary key is unique
Yes, it is. They are very simple tables.
- and such a constr
Byron,
A little bit more information may help here - what do you mean by 'importing'
the table into QGIS? Have you checked that the primary key is unique - and such
a constraint exists on the table definition? and that the column is in the
geometry_columns table - you may want to try populate_g
The problem:
Missing primary key column in postgresql table imported into Quantum GIS.
Details:
43,000 object database created using Windows XP 32 bit, postgresql 8.4,
postgis 1.4, Quantum GIS 1.5.
Daily backups using pgadmin.
Several db restores were performed on the XP system for various reas
Hello
Please I want to Unsuscribe to PostGIS form because I have finished my
instership. I also want to delele my messages. what can I do.
Thanks
Erik
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refrac
Thank you Nicklas! Great answers. The latter query is useful for
determining combinations of vehicle routes that would take a passenger from
point a to point b, although there are yet other considerations, like
distance and direction.
Tom
___
postgis-
Mike
As far as i know, postgis accepts both formats as inputs. Specifically, if
you want to represent a multipoint in syntax WKT, you will use comma to
delimitate the values (e.g. "MULTIPOINT ( -1 1, 0 2, 3 4)" ). However,
postgis use an alternate and acceptable WKT representation for multipoint
us
Hello list,
Hello all - does anyone know about whether the multipoint WKT format should
have points separated with parentheses (e.g., "MULTIPOINT((1 2),(3 4))"), or
should it not (e.g., "MULTIPOINT(1 2,3 4)")? PostGIS returns the latter (no
parentheses), but if you look at the OGC doc linked fr
Hallo Tom
I will make a try answering as much as I can :-)
On Sat, 2011-01-08 at 12:11 -0600, Tom Kessler wrote:
> Hello to all,
>
> I'm developing some spatial queries and have these questions:
>
> 1) When one makes an Explain Select request, is there any
> consideration given to the computat
Hello to all,
I'm developing some spatial queries and have these questions:
1) When one makes an Explain Select request, is there any consideration
given to the computational efficiencies
of the Postgis functions themselves composing the query?I doubt it, but
want to make sure. I assume se
14 matches
Mail list logo
