Re: [postgis-users] Antwort: Re: Projection(s) for global point-and-radius searches

2010-07-07 Thread Chen, Li [Contractor]
I think you can try to covert lat/longs to meters, but this is highly inaccurate, especially in places where the latitude is greater than 75. This problem troubles us as well From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of S

Re: [postgis-users] Instructions on Installing Postgis on Solaris

2010-06-24 Thread Chen, Li [Contractor]
yland Sent: Friday, 25 June 2010 2:40 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] Instructions on Installing Postgis on Solaris Chen, Li [Contractor] wrote: > So I am sending the following instructions to share experience with > others who also want to install postgis on solari

[postgis-users] Instructions on Installing Postgis on Solaris

2010-06-23 Thread Chen, Li [Contractor]
Hi Everyone, I just finished installing the Postgis on a Solaris system. I had some problems during the process and I am lucky all got solved with the help of the community and google. So I am sending the following instructions to share experience with others who also want to install postgis on

[postgis-users] How inaccurate is Geometry

2010-04-28 Thread Chen, Li [Contractor]
Hi Everyone, I just want to ask a question regarding Geometry data type. According to the manual, geometry use a planar coordinate system for measurement and the geography data type use a geodetic coordinate system. In my application, I need to deal with data from all over the world and I can

Re: [postgis-users] ST_Buffer questions

2010-04-14 Thread Chen, Li [Contractor]
users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Ben Madin Sent: Thursday, 1 April 2010 4:42 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] ST_Buffer questions G'day Li, I can't help with Q2, but On 01/04/2010, at 12:28 , Chen, L

[postgis-users] Function to draw a sector

2010-04-07 Thread Chen, Li [Contractor]
Hi, I want to ask whether there is a function to draw a sector of a circle? I could draw one with POLYGON and have a lot of points to simulate the arc. But are there more convenient and precise ways to do that? Thanks, Li ___ postgis-users mailing lis

[postgis-users] function for querying overlapping shapes

2010-04-06 Thread Chen, Li [Contractor]
Apologize about an empty mail just sent... Here is my question: Imaging I have several 2D shapes and they are all sectors of circles. And then I want to define a circle and query which of the previous sectors overlaps this circle, or contains this circle. Is there any functions to do that? Do I

[postgis-users] (no subject)

2010-04-06 Thread Chen, Li [Contractor]
___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] ST_Buffer questions

2010-03-31 Thread Chen, Li [Contractor]
...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Ben Madin Sent: Thursday, 1 April 2010 4:42 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] ST_Buffer questions G'day Li, I can't help with Q2, but On 01/04/2010, at 12:28 , Chen, Li [

[postgis-users] ST_Buffer questions

2010-03-31 Thread Chen, Li [Contractor]
Hi Everyone, I am a newbie to this community and I would like to ask a question/s :). Q1. ST_Buffer(g1, range) is able to return a geometry within the range of g1. So, I define two point using lon/lat (SRID=4326) and range 10km. I want to see whether they cross each other by using ST_Crosses(g1,