dear,
iv loaded data to postgis and for all geometry srid is -1.
if i want to change srid without doing and transformations, can i do that
and how?
Thank you,
Marko Cubranic
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://p
On 30/03/2010, Kevin Neufeld wrote:
> On 3/29/2010 9:58 PM, Stephen Woodbridge wrote:
>> If you have a POINT then you can find the closest centerline within
>> some RADIUS with:
>>
>> select *, distance(POINT, the_geom) as dist
>> from lines
>> where expand(POINT, RADIUS) && the_geom
>> order
On 3/29/2010 9:58 PM, Stephen Woodbridge wrote:
If you have a POINT then you can find the closest centerline within
some RADIUS with:
select *, distance(POINT, the_geom) as dist
from lines
where expand(POINT, RADIUS) && the_geom
order by dist limit 1;
-Steve
Or to find the closest center
Richard Greenwood wrote:
I'm not even sure if "reverse geocoding" is the correct term, but what
I am trying to do is improve TIGER road centerline data from known
points. I have a set a accurate address points, and I would like to
assign fromleft, toleft, fromright, toright ranges to the TIGER
ce
Mark/List,
I just replaced my postgresql.conf with the default copy that appears in
/etc/postgresql/8.4/main/ after a fresh install. The performance is pretty
much the same as before (maybe even about 400 ms worse than before).
Is there anything else I should try?
Mike
On Monday 29 March 201
I'm not even sure if "reverse geocoding" is the correct term, but what
I am trying to do is improve TIGER road centerline data from known
points. I have a set a accurate address points, and I would like to
assign fromleft, toleft, fromright, toright ranges to the TIGER
centerlines from these points
When you write: "FROM (roads, settlements, poi, province, etc...)" you
actually mean one table at a time? Because if you try more than one table
separated by commas, there will be an error. If you are trying to use more
than one table I'm afraid you will need to use a JOIN clause ...
Regards,
On
Hi Mark,
I don't recall making any changes...at least not until the error I encountered
last week cropped up - but I think I reversed those changes (I will double-
check tonight). But I think I have encountered performance problems with this
query before on other systems - I had originally dism
On Mar 28, 2010, at 6:29 PM, Nicklas Avén wrote:
Hallo everybody
PostGIS online is a new site for trying, testing and showing
PostGIS. You can try sql queries against the test datasets (so far
only one) and follow tutorials (so far only two) or you can write
tutorials yourself to let oth
Hello,
Indeed there is no -q.
But are you sure that it actually is shp2pgsql that you want to quiet down
? (there are at most 15 lines)
I think that what can annoy you is the output from the psql that usually is
piped behind shp2pgsql.
Psql do have a -q parameter.
e.g. :
shp2pgsql -W
Shreerang Patwardhan wrote:
Hey all,
I do not wish to display the output of the command shp2pgsql at the
terminal. I want the command to run in quite mode. But there is no -q
option for shp2pgsql. How do I get around this issue?
Perhaps something like:
shp2pgsql ... > /dev/null or
shp
Mike Leahy wrote:
Is this something that should be looked into, or should I just incorporate the
workaround of disabling nested loop joins into my code?
I find that generally PostgreSQL is fairly good at its estimates unless
someone has already tried to tune the database. Have you changed any
Hey all,
I do not wish to display the output of the command shp2pgsql at the
terminal. I want the command to run in quite mode. But there is no -q option
for shp2pgsql. How do I get around this issue?
Thanx,
Shreerang Patwardhan.
___
postgis-users
Hey Kevin,
Thanx a million tons.My problem is solved...Thanx a lot.!!!
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
14 matches
Mail list logo
