Hi,
The objective of the query is to find the roads that run along the state
boundry. I have tried and written a query, can somebody give me suggestion
on it. this below query runs but system hangs. i don't know what is wrong.
*select s.name from state s, road r where
st_intersects(ST_Buffer(s.th
The example creates an ellipse directly in a projected coordinate
space. What you need is the difference between latitude and longitude
of 1 meter at the location you want. Your code should be:
translate(rotate(scale(buffer(GeomFromText('Point(0.0 0.0)', 4326),
r),a,b),alpha),cx,cy)
Where r
Would someone please explain the units in this snippet modeled after the
exampled offered in
http://postgis.refractions.net/pipermail/postgis-users/2007-March/014971.html
?
translate(rotate(scale(buffer(GeomFromText('Point(0.0 0.0)', 4326),
r),a,b),alpha),cx,cy)
What are the units of r, a, a
On Thu, 2008-11-13 at 09:44 +, Mark Cave-Ayland wrote:
> Hi everyone,
>
> The PostGIS team are pleased to announce that PostGIS 1.3.4 RC3 is now
> available for download from
> http://postgis.refractions.net/download/postgis-1.3.4rc3.tar.gz.
>
> In particular, the team are interested in co
GIS Day in Boston is Wednesday Nov 19, 2008.
If any of you happen to be in town, feel free to stop by.
Details are here
http://www.cityofboston.gov/maps/
I'll be giving a small little presentation on Abandoned Property Survey
which uses Mapserver, MassGIS webservices, PostGIS back-end, OpenLaye
The girth of my experience is in MSSQL where you can do "DELETE table1
from mytable table1 join mytable table2" this syntax pukes in PG as
it probably should. So I took the shortcut. Thanks for the tip.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED
Hi Maria,
You need to have a field for ordering your points. (gid in this example)
SELECT ST_MakeLine(pts.the_geom)
FROM (SELECT the_geom FROM your_points_table ORDER BY gid) as pts
Fred.
On Mon, Nov 17, 2008 at 5:33 PM, Maria Arias de Reyna <[EMAIL PROTECTED]>wrote:
> Hi,
>
> I'm trying
Hi,
I'm trying to convert a table of points to a table of multilinestring. Is it
posible? How?
Background: I want to use PgRouting to find quickest routes and I have two
shape files with data: a point shape and a multilinestring shape. As
PgRouting can't work with both, I want to convert the p
Stan,
This looks good. I would add a couple of suggestions
1) ST_Equals doesn't include an && check. I know it seems like an
oversight to me and I think Kevin even mentioned it and possibly fixed
it. Might be changed in 1.4 (and maybe 1.3.4)
2) With the self-join you have you lose the penalty
Sound like this was never definitively answered, so here's my 2 cents.
1) Create a unique field on your table AFTER importing with shp2pgsql.
alter table mytable add myidcolumn serial
2) Then use the st_equals function to get rid of duplicates with a lower
serial.
delete from mytable
where
Balkan Uraz wrote:
Dear All;
We have been informed that Postgre 8.3.5 Update is critical for
especially GIST indexes. Therefore we decided to upgrade both Postgre &
PostGIS.
We have backed up our system:
* Postgre 8.3.3
* PostGIS 2008-10-08 SVN
* PROJ.4 SVN
* GEOS 3.0.0
11 matches
Mail list logo
