>* For my import I will update the pointers of edges my own, could you*>*
>Sandro point me to*>* specifications of next_*_edge.*
I guess shoulkd better spend time to optimize the actual ISO function
rather than think to do own low level function.
The controls to do a right ISO topology are man
True :D
On Sat, Sep 29, 2012 at 1:42 AM, Puneet Kishor wrote:
>
>
> On Sep 28, 2012, at 9:31 PM, George Silva wrote:
>
> OMG, I'm sorry,
>
> I've confused the whole thing. I'm awake for a long long time. Way too
> long.
>
>
>
>
> It's only PostGIS. At least your weren't driving. ;-)
>
>
>
>
> M
On Sep 28, 2012, at 9:31 PM, George Silva wrote:
> OMG, I'm sorry,
>
> I've confused the whole thing. I'm awake for a long long time. Way too long.
It's only PostGIS. At least your weren't driving. ;-)
>
> Mathieu, sorry for the trouble.
>
> On Sat, Sep 29, 2012 at 1:28 AM, wrote:
>>
I was truly thinking in
SELECT ST_MaxDistance(
ST_MakeLine(ST_MakePoint(0,0),ST_MakePoint(1,1)),
ST_MakeLine(ST_MakePoint(0,0),ST_MakePoint(-1,1)));
I had the extra -1 on y there...sorry for the noise.
On Sat, Sep 29, 2012 at 1:31 AM, George Silva wrote:
> OMG, I'm sorry,
>
> I've confused the
OMG, I'm sorry,
I've confused the whole thing. I'm awake for a long long time. Way too long.
Mathieu, sorry for the trouble.
On Sat, Sep 29, 2012 at 1:28 AM, wrote:
> Not weird for me: the max distance is between (1,1) and (-1,-1), which is
> sqrt(2^2 + 2^2) = 2.828427
> At least, that's what
Not weird for me: the max distance is between (1,1) and (-1,-1), which is
sqrt(2^2 + 2^2) = 2.828427
At least, that's what Pythagoras told me once :)
Mathieu.
Le 28/09/2012 23:58, George Silva a écrit :
Hey guys, weird results here...
Check this:
SELECT ST_MaxDistance(
ST_MakeLine(ST_MakePo
Robert,
Your normalize_address syntax is no good as that will call normalize_address
numerous times per address (because of the .*) .
Compare with speed of:
SELECT (normalize_address(address)) As addy FROM respondents_addr WHERE
address IS NOT NULL LIMIT 1000;
There are a lot of reasons sad
Hey guys, weird results here...
Check this:
SELECT ST_MaxDistance(
ST_MakeLine(ST_MakePoint(0,0),ST_MakePoint(1,1)),
ST_MakeLine(ST_MakePoint(0,0),ST_MakePoint(-1,-1)));
-- 2.82842712474619 (this corresponds to 2x sqrt(2)?)
For me the max distance between these polylines is 2.
Or am I expectin
Dear Leo and Regina (and everyone else too):
Thanks very much for your detailed reply. I'm just now to the point
where I've implemented your recommendations, but no positive outcome
yet. I simplified the addresses to address the regex expression variable
error, performed a soft upgrade to 2.0.1,
On Fri, Sep 28, 2012 at 05:00:59PM +0200, Mario Jurcevic wrote:
> It will help if Topology validation could be defined by rules, so
> that during import
> of already topological data the user can disable it or enable it as needed.
That you can do it yourself.
Make up a schema, write your rules, im
It will help if Topology validation could be defined by rules, so that
during import
of already topological data the user can disable it or enable it as needed.
For my import I will update the pointers of edges my own, could you
Sandro point me to
specifications of next_*_edge.
Thanks
--
On Fri, Sep 28, 2012 at 02:50:03PM +0200, Mario Jurcevic wrote:
>
> On 09/27/2012 10:06 AM, Sandro Santilli wrote:
> >You can always skip all tests and insert the edges straight away, if
> >you know exactly what's expected as the structure. It will be faster.
> >You can then check with ST_Validate
On Fri, Sep 28, 2012 at 8:25 AM, tasneem dewaswala
wrote:
> Hello,
>
> I am very much new to postgreSQL and postgis.
> I installed postgreSQL on my windows XP few months back. This are my version
> details.
>
> "PostgreSQL 8.4.13, compiled by Visual C++ build 1400, 32-bit"
>
> I created a database
On 09/27/2012 10:06 AM, Sandro Santilli wrote:
You can always skip all tests and insert the edges straight away, if
you know exactly what's expected as the structure. It will be faster.
You can then check with ST_ValidateTopology what's missing
(theoretically). That's what the TIGER loader does,
Hi,
http://postgis.org/documentation/manual-1.5/ch02.html#id2661925
Nicolas
On 28 September 2012 08:25, tasneem dewaswala wrote:
> Hello,
>
> I am very much new to postgreSQL and postgis.
> I installed postgreSQL on my windows XP few months back. This are my version
> details.
>
> "PostgreSQL 8
On 09/27/2012 02:50 PM, Sandro Santilli wrote:
On Thu, Sep 27, 2012 at 02:44:12PM +0200, Sandro Santilli wrote:
On Thu, Sep 27, 2012 at 04:58:24AM -0700, ps.tiara wrote:
but when i visualized the result of topology in x3d, it was mess..maybe i
made a mistake by wrong query??
How did you vis
16 matches
Mail list logo
