Reputation
7,963
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
9 74 159
Impact
~868k people reached

Mar
2
accepted Downloading OpenStreetMap Data
Mar
2
comment Downloading OpenStreetMap Data
Thanks @Harry. I ended up using osmosis on linux and it worked fine. I currently want to use this setup on Win 7 and I'm excited to see there is a .exe of bzcat. Last time I checked there wasn't. Unfortunately there does not seem to be an easy way of using osm2pgsql on Windows, otherwise that would be my ideal choice.
Mar
2
revised Adding a marker with openlayers/geoserver
edited tags
Mar
2
revised Adding a marker with openlayers/geoserver
add image, tweaked grammar
Mar
2
revised Difference between video captured with Google Earth and Google Earth Pro
added 53 characters in body
Mar
2
revised Difference between video captured with Google Earth and Google Earth Pro
added 40 characters in body
Mar
2
answered Difference between video captured with Google Earth and Google Earth Pro
Mar
1
comment Advice on geocoding IP addresses
It seems to only have a paid version - is this correct?
Mar
1
answered How can I display “related” data in a polygon label?
Feb
28
revised Converting kml to shape file via ogr2ogr including all attributes
added 62 characters in body
Feb
28
revised How to alter transparency by spatial location
added 92 characters in body
Feb
27
revised How to copy a geometry from one feature to another without attributes?
added 2 characters in body
Feb
27
awarded  Nice Question
Feb
25
comment Identifying road intersections using PostGIS
Hi @Nicklas, I'm not able to get this to run. The two inner clauses work fine; should I be replacing the distinct_crosspoints ,roads with my table name (roads_test)? I did try that but then got an error about geom being ambiguous.
Feb
25
accepted Identifying road intersections using PostGIS
Feb
25
revised Identifying road intersections using PostGIS
added 5 characters in body
Feb
25
comment Identifying road intersections using PostGIS
Thanks @underdark. Do you know how I can count the number of lines that are intersecting? I've tried a few combinations of COUNT() such as COUNT(ST_Touches(..)) and COUNT(ST_Intersection(..)) but this does not seem to work as all of the values are 12.
Feb
24
revised Identifying road intersections using PostGIS
added 19 characters in body
Feb
24
revised Identifying road intersections using PostGIS
edited title
Feb
24
asked Identifying road intersections using PostGIS