Can somebody give me a rough query for the equivalent of an ArcGIS ERASE
using two polygons. Cheers, Sean.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Hello, I am fairly new to POSTGIS and postgresql in general and am
wondering if somebody can explain to me the best and most efficient way
to backup and restore postgresql databases. Kind regards,
Sean.
___
postgis-users mailing list
postgis-users
I'm trying to figure out if this is a problem with Natural Earth data
or with PostgreSQL/PostGIS.
The Natural Earth data contains coordinates for Antarctica with
longitude values of exactly 180. If I try to cast this to the
geography type it gives the error, "ERROR: Coordinate values are out
of ra
Hello, thank you for your reply. Yes, essentially I have done this exact
SQL, but when I export it using quantum gis or FME, i get the following
projection parameters
Geographic Coordinate System:GCS_WGS_1984
Datum: D_WGS_1984
Prime Meridian: Greenwich
Angular Unit: Degree
wh
Hello, I would like to create a custom projection which is essentially a
variation on the geographic coordinate system EPSG 4326, i have created
one and the srtext is "GEOGCS["Geographic Coordinate
System",DATUM["WGS84",SPHEROID["WGS84",6378137,298.257223560493]],PRIMEM["Greenwich",0],UNIT["degr
You need PostGIS if you want GIS data types and functions.
PostgreSQL has some built in geometry types but it doesn't know
anything about spatial reference systems or have a myriad of useful
spatial data management and analysis functions.
Sean
On Jul 23, 10:50 am, Patrick Gostovic wrote:
On Jun 6, 10:57 am, James David Smith
wrote:
> Hi all,
>
> Would love some help with this update query please. I have two tables
> with three columns...
>
> Table: vehicles
> Columns: date, incident, incident_link
>
> Table: incident
> Columns: date, incident, key
>
> What I would like to do is
you simply trying to return the attributes of
intersecting geometries? It would help if you showed the table
definitions or simplified versions and a table definition of the table
you want to create.
Note: ST_Intersects returns True or False. It doesn't ret
Not the number of vertices but the number of quad segments which
should be the same as (number of vertices) / 4.
http://postgis.refractions.net/docs/ST_Buffer.html
Sean
On Apr 14, 4:18 pm, "Lopez, Anthony" wrote:
> All,
>
> Does anyone know if it's possible to specify t
th a where clause based only
on the primary key and any field with a unique constraint.
The setting is buried in:
Settings > Control Panel > Administrative Tools > Data Sources (ODBC)
> File DSN > "your database dsn" > Configure > Connection > Page 2
Sean
p://opengeo.org/technology/suite/download/
Or, if you're never going to use the database in a multi-user
environment, take a look at SpatialLite (http://www.gaia-gis.it/
spatialite/) and see if it will do what you need. It's not as robust
as PostGIS but it does a lot.
Sean
On Mar 9, 4:13 am
You can a year of Amazon AWS for free:
http://aws.amazon.com/free/
OpenGeo has an AMI you can use:
http://blog.opengeo.org/2010/09/13/opengeo-suite-community-edition-on-amazon-web-services/
That combination might give a free platform for testing for a year.
Sean
On Mar 9, 5:38 am, Saka
Did you start PostgreSQL?
It should be under:
Start -> PostgreSQL 9.x.x -> Start database
Look up how to have it start as a service so you don't have to
manually start it.
Sean
On Mar 8, 8:11 am, "Florian Reimer" wrote:
> Hi,
>
> I am totally new to PostgreSQL
geometry. This is more correct, it preserves
the information about the actual road on which they travel. Showing
direction of travel is strictly a symbology issue.
Sean
On Dec 22, 9:13 pm, Ben Madin wrote:
> G'day all,
>
> I have a problem where I am trying to show the rout
LTIPOLYGON and GEOMETRYCOLLECTION. Am I doing something
wrong or is this a bug?
System info:
PostgreSQL 8.3
POSTGIS="1.5.1" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21 August
2008" LIBXML="2.7.6" USE_STATS
Windows XP
Thanks,
Sean
axing. A bounding box check in the where
clause should help speed things up. e.g.
select p.id
from parcels p left join geocache g on st_contains(p.geom, g.geom)
where p.geom && g.geom
You'll only really know how efficient it is when you try it
ode
and you'll probably have to UNION this with a query that gets the
pieces that don't touch.
Sean
On Dec 29, 9:42 am, "Nicolas Gillet - MARKET-IP"
wrote:
> Hello
>
> Thanks for the answer,
>
> I knew about ST_touches(geometry, geometry) function.
>
>
Sounds like ST_Touches:
http://postgis.refractions.net/docs/ST_Touches.html
Sean
On Dec 29, 5:39 am, "Nicolas Gillet - MARKET-IP"
wrote:
> Hello
>
> I am trying to aggregate linestrings together based on their attributes and
> the fact that they are touching each other.
Like, I said uDig will load the layer. Quantum GIS with load and edit it.
Try Quantum GIS http://www.qgis.org/en/download.html
Sean
On 2009-07-05 04:53:54 -0400, tommy408 said:
Thank you for your help Sean and Ralf.
When I load polygon table with srid of -1, Udig keeps saying undefined
I'm not sure why you want to assign it an SRS of EPSG:4326.
uDig will load and Quantum GIS will happily load and edit the layers if
you assign an SRID of -1.
Sean
On 2009-07-01 16:36:44 -0400, tommy408 said:
A lot of these tools that connect to postigs db requires a srid.
Can you just set the SRID to -1. What 'map design tool' are you
using?
Sean
On Jun 30, 3:00 pm, tommy408 wrote:
> I'm not mapping anything on earth. The world I'm doing is flat. The
> polygons I'm drawing over is raster image I made. So I'm trying n
It's not clear what you're trying to do but can you simply store the
15000 as positive or negative? Then you always add. Adding a
negative is same as subtracting.
Sean
On Jul 1, 2:35 pm, "Bob Pawley" wrote:
> Hi
>
> I have an expression such as -
>
On 2009-04-25 12:10:33 -0400, Sachin Srivastava
said:
2009/4/25 Sean Fulton
On 2009-04-25 09:50:55 -0400, Sachin Srivastava <
sachin.srivastava1...@gmail.com> said:
I am a newbie, could somebody explain what distance transformation should
i
use to eliminate discrepancy in resul
will never get meters out of Query 1 without
transforming the coordinates as you did in Query 2. You could try to
convert the result of Query 1 from degrees to meters but that's really
doing it backwards and I wouldn't trust the results. Query 2 is the
correct approac
Hi All,
I am going through your documentation on how to load Tiger data that was
at:
http://geoserver.org/display/GEOSDOC/Loading+TIGER+polygons
I cannot find either the tigerpoly.py script nor the recommended
tigerpolygonformation.zip file
Thanks in advance for your help.
Sean
etry) FROM scale15 LIMIT 1;
st_isempty
f
(1 row)
ST_NPOINTS works. It seems like there should be a more direct way.
Sean
On 2008-07-04 12:03:33 -0400, Martin Davis <[EMAIL PROTECTED]> said:
Actually JTS/GEOS handle empty MultiPolygons just fine. I don't know
How do I test for an empty feature such as 'MULTIPOLYGON(( EMPTY ))' ?
IsEmpty seems to work only for collections.
astext(wkb_geometry) = 'MULTIPOLYGON(( EMPTY ))' doesn't seem to work.
Thanks,
Sean
___
postgis-u
I've been with http://hub.org/ for several years, I like them a lot.
Richard Greenwood wrote:
On Tue, Jul 1, 2008 at 10:08 AM, Donald Ijams <[EMAIL PROTECTED]> wrote:
I'm searching for a Postgis enabled web host and noticed the 2006 discussion
of this topic on this list. Is there a more rec
Yep. ST_IsValid returns true.
Sean
On 2008-06-23 10:02:10 -0400, "Paul Ramsey" <[EMAIL PROTECTED]> said:
Have you run as ST_IsValid test on it?
On Sun, Jun 22, 2008 at 7:47 PM, Sean Fulton <[EMAIL PROTECTED]> wrote:
I have Census congressional district data loa
aste.com/58232/plain/
Is it a problem with the data? With Postgis?
Thanks in advance,
Sean<>___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Hi Paul,
Thanks for "magic incantation", I seem to be on the right track. Does
this projection exist in the spatial_sys_ref table? I don't see it, so I
added it. Of course there is no srtext info.
Sean
Paul Ramsey wrote:
The magic incantation is as follows.
+proj=mer
es line up correctly. Am I be able to
project some map data from my postGIS database into Google's projection, and
then either scale or transform it with relative ease? I know this is against
Google's policy, but if I can get it to work, I'll see
ndary.
Sean
Shape Yahoo! in your own image. Join our Network Research Panel today!
http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
___
postgis-
_geom, m.the_geom) AS
intersection_geom,
r.*
FROM hydro.watrcrsl AS r, cadastre.countries_2004 AS m
WHERE r.the_geom && m.the_geom
AND intersects(r.the_geom, m.the_geom)
AND m.iso_3digit = 'BRA';
Sean
___
e and share. I'd say that
it will be well worth the trip for anyone from Wheatland, Wyoming to
Raton, New Mexico.
Cheers,
Sean
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
35 matches
Mail list logo
