Re: [postgis-users] Help!, how i can create a SRID

2007-11-16 Thread Chris Hermansen
Hi folks; Marco and I have been writing back and forth off-list as Dane suspected. I have got him as far as I can but he is now looking for some info on projections used in Mexico. I suggested the UTM to him as Dane points out below. Marco is also interested in some kind of projection that is s

Re: [postgis-users] Help!, how i can create a SRID

2007-11-16 Thread Dane Springmeyer
Hola Marco, Chris probablimente ayudate mejor de yo, pero... Para coordinates en X, Y, si necessitas una projecion differente de WGS84. No neccesitas hacer una SRID nuevo, puedas usar una SRID por una projecion differente. Entonces, usted problamente necessitas cambiar la projecion desde

[postgis-users] Help!, how i can create a SRID

2007-11-16 Thread Marco Aurelio (Skull Leader)
Hi everybody, i have a lot of coordinates in WGS84 and i what a projection for it ('coz WGS84 have Lat/Lon and i need all this data en X and Y). I've the Lon/Lat of mi country (the section of the projection that i need), some person told me that i can create a SRID for use it whit the function

Re: [postgis-users] How can I get points of a polygon

2007-11-16 Thread Kevin Neufeld
Amrita p wrote: Hi All, I want to display all coodinates of a polygon. Is there any function in postgis to get the coordinate of a polygon. In a round-about kind of way. Use can use ST_ExteriorRing(...) and ST_InteriorRingN(...) to extract the lines from the polygon. Then use ST_Point

Re: [postgis-users] Multipolygons UNION

2007-11-16 Thread Brent Pedersen
On Nov 16, 2007 4:20 AM, Kirill Zinov <[EMAIL PROTECTED]> wrote: > Hello, > > I'm newbie with PostGIS and would like to ask to point me to a right > direction. I need to unite all of the multipolygons that have the same > attribute and that are contiguous to each other. Actually I need to > unite t

[postgis-users] postgis schema tool

2007-11-16 Thread David Potts
Can any body suggest any tools for drawing a postgis schema ? David Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of the Pinan Software ___ postgis-users mailing

[postgis-users] Multipolygons UNION

2007-11-16 Thread Kirill Zinov
Hello, I’m newbie with PostGIS and would like to ask to point me to a right direction. I need to unite all of the multipolygons that have the same attribute and that are contiguous to each other. Actually I need to unite the sub-divisions like the States in the US and keep the islands apart f

[postgis-users] Overlap still not works

2007-11-16 Thread Andreas Laggner
Hi, I try to overlap huge files (up to 8 million polygons in a single file) since two months now. Two approaches were used, they both worked fine with small files (about some hundred polygons each file), but none ran through with the bigger ones! Right now i have two tables, the first one "sg

Re: [postgis-users] RE: Data security via Postgis

2007-11-16 Thread Guido Lemoine
Yong, A WMS request to Mapserver "only" serves a painted composition of your (feature and raster) data, i.e. not the actual feature or original raster data itself. Your mapserver set-up controls what detail the user can get. Your user would need to recompose your complete data sets, and re-dig

Re: [postgis-users] RE: Data security via Postgis

2007-11-16 Thread mchapman
Yong, Web servers are outside the firewall and thus not secure. One way to make it (more) secure is to put your database and imagery on a server behind the fire wall. Then run map server on your web server and have map server reference postgis through a dedicated user account with limited priv