1,738 reputation
713
bio website blog.loudhush.ro
location Bucharest, Romania
age
visits member for 4 years, 3 months
seen Jun 25 '13 at 10:01

Sep
30
awarded  Explainer
Aug
11
awarded  Yearling
May
17
awarded  Popular Question
Aug
11
awarded  Yearling
Apr
9
comment What format is lat/long stored in OSM PostGIS?
Did you check your default.style file for an entry for the "toll_booth" attribute? Presuming the id field is common between planet_osm_nodes and planet_osm_point, what does "select name from planet_osm_point where osm_id = 496668427" return?
Apr
8
comment What format is lat/long stored in OSM PostGIS?
Also check that your import style file actually contains an entry for attribute name "toll" (see wiki.openstreetmap.org/wiki/Osm2pgsql#Import_style). If it's not there, osm2pgsql will not add it to the table definition.
Apr
8
comment What format is lat/long stored in OSM PostGIS?
I don't know what MetersToLatLon does. If your planet_osm_points has less points than planet_osm_nodes it's likely your osm2pgsql import went wrong. Look for errors.
Apr
8
answered How to create a function by passing polygon datatype as a parameter
Apr
8
answered What format is lat/long stored in OSM PostGIS?
Apr
6
awarded  Nice Answer
Mar
22
awarded  Critic
Mar
21
answered Missing function ST_Extent in PostGIS db
Mar
15
revised In PostGIS, how to count nearby points efficiently?
deleted 1 characters in body
Mar
15
comment In PostGIS, how to count nearby points efficiently?
<#> computes distances. Your query first computes the entire result set of distances and then applies a filter (<100) on the result set. What you're asking for is a smart(er) execution plan and not a more optimized <#> operator.
Mar
15
answered In PostGIS, how to count nearby points efficiently?
Mar
11
revised Multiple response from nominatim service call (Geocoding) in openstreetMap
formatting code
Mar
11
answered Multiple response from nominatim service call (Geocoding) in openstreetMap
Mar
11
suggested suggested edit on Multiple response from nominatim service call (Geocoding) in openstreetMap
Nov
28
awarded  Enlightened
Nov
28
awarded  Nice Answer