2,729 reputation
821
bio website
location London, United Kingdom
age
visits member for 2 years, 10 months
seen May 4 at 19:59
stats profile views 132

Jan
9
comment I would like to change all the values in a attribute field to the same text
Are you putting the text in quote marke e.g. "Times New Roman"?
Dec
20
comment So I am a programmer. What do I do to become a mapper?
@anoved not sure what you mean, there is so much about the death of traditional GIS in favour of the 'GIS programmer' that this seems like crazy talk. See for example smathermather.wordpress.com/2012/10/27/….
Dec
6
comment PostGIS - improving sql statement
Yes: postgis.refractions.net/docs/ST_Within.html
Nov
22
comment Why do some maps show Sandy Island?
Not sure how this is relevant to GIS? Geography perhaps?
Nov
21
comment Open Source GIS Problem
This question is too broad and not specific (which 2-3 tools?). Try using the Ubuntu package manager. That should help. And then come back with the ones that you have trouble with.
Nov
12
comment Small Idea to get best path between two points
I mean focus on some of the problems rather than whether it's possible. You asked three separate questions when probably one would do, and the idea of stack exchange is to ask one discreet question in each post
Nov
10
comment Small Idea to get best path between two points
This is a good question and an interesting idea - however, you might want to focus in on one of the aspects - I would say it's certainly doable from a technical perspective, probably the problems are what you want to focus on.
Nov
9
comment Cannot add layer to map in arcpy
thanks @PolyGeo. It seems to be an issue with relative paths, as per answer
Nov
8
comment How can I crawl directory tree and change Mxd relativePaths to true?
@blah238, thanks for your post. I re-looked at the esri forum post you linked to, and it seems it's only possible within the IMapDocument itself and saveAs. Have answered to say as much
Oct
12
comment Finding nearest Stop location (DB) from current location
if you have the route co-ordinates, make sure the route lines are split at stops, then select the nearest line feature to the GPS position at the time maybe using a BBox, then find the nearest line vertex, then find the nearest stop to that segment, so I would say it's a 3-step process. Probably PostGIS would be much better than MySQL though
Oct
12
comment Finding nearest Stop location (DB) from current location
@Uffe Kousgaard - I don't think this is routing in its truest sense at all - it's a problem constrained by one link in a network so it can use standard geospatial tools to find a) the nearest vertex of the route to the user position and b) is the distance from that vertex to stop s2 greater or less than the distance from that vertex to stop s3. If that is the problem, no specific "routing" functionality is required
Oct
11
comment Finding nearest Stop location (DB) from current location
I think the newest version of MySQL is ok for spatial. Why don't you use that and do all the spatial stuff with that rather than Google? With a spatial DB, you can do spatial processing within the app itself, no need for a desktop GIS. a spatial DB is already a GIS.
Sep
11
comment Zipcode overlay on OSM
Very similar question here: gis.stackexchange.com/questions/32321/…
Sep
11
comment How to cut one ESRI Shapefile with another ESRI Shapefile?
in what software and version?
Sep
3
comment OpenLayers Icon e PopUp
Posts here are expected to be in English. Can you at least use Google Translate and then other people can try and correct it. Otherwise your audience will be a very small fraction of GIS Stack Exchange
Sep
3
comment PostGIS convert geography(Point,4326) to GPS
Try ST_AsEWKT(your_column_name)
Aug
31
comment ST_Intersects returns “incomplete” results
Can you be sure that both datasets are in the same projection?
Aug
29
comment Postcode Shape Files for the UK
You could use Voroni polygons as per my method above.
Aug
29
comment Postcode Shape Files for the UK
This is wrong - OS have already released the Code Point data (which is at individual postcode centre-point detail - sufficient to create broad boundaries). It's available here: ordnancesurvey.co.uk/opendatadownload/products.html
Aug
23
comment How to create a new Spatialite database in QGIS
Can you explain the steps you are taking to get this error message?