3,206 reputation
1125
bio website
location London, United Kingdom
age
visits member for 4 years
seen 9 hours ago

Jul
19
comment Converting a JOSM indoor map to QGIS
pretty much - addgeometrycolumn(x,y,z....) then insert into table (geometry_column) values xxx. Easiest way to insert geometry manually is probably ST_Geom_From_Text(WKT String) but the tools above will pretty much take some of that complexity out for you. I forgot one - FME would probably be the easiest to use but it's not free
Jul
9
comment QGIS to solve projection mystery in Postgresql
In PostgreSQL, what does the SQL query "select * from public.geometry_columns" yield? And if you run the query "select ST_AsText(yourgeometrycolumn) from yourtable" do the actual co-ordinate numbers look right to you?
Jul
8
comment Translate coordinates in GeoJSON export
No, what the library does is translate the lat/lon or projected co-ordinates to the draw space, so should handle co-ordinate systems transparently. I think you need to give an example of the data you are using because it must be a data or projection issue.
Apr
10
comment Carto CSS variables
Yeah, it is in Carto, just not in the release version of TileMill - details at github.com/mapbox/carto/issues/337
Feb
13
comment GeoServer - OSM .shp file and aerial shifted
how did you convert the geofabrik shapefile from WGS84 Lat/Lon (I assume it was in that) to Google Mercator?
Feb
13
comment GeoServer - OSM .shp file and aerial shifted
what projection are they both using?
Feb
6
comment UK Postcode boundaries
I don't understand what you mean - the only things that can be considered boundaries are postcode districts e.g AB1 ... and postcode sectors AB1 2.. Otherwise it's all point locations (avaiable from OS Codepoint as per answer above. The link I gave you is in GeoJSON or WKT - I forget which. P.S. Upvotes are nice.
Dec
9
comment Alter validation in ArcGIS script tool
@bla238 - perhaps you're right - I just thought there would be a way to tell the user where they were going wrong - albeit it is fairly obvious!
Dec
9
comment Alter validation in ArcGIS script tool
The parameter with a green dot is optional, which is why I am confused. It's not exactly what I'm after - I've already got validation to work as per the screenshot - it's more the blanking out of values in addition to this error message that I'm having issues with. Thanks though
Dec
9
comment Alter validation in ArcGIS script tool
Thanks @KHibma. Have posted some code - I thought ArcGIS validation code was executed before user specified code though.
Nov
26
comment How to create a label formatted like “ 1,000' ” from a numeric field?
@chrishenrick - did my answer solve it for you?
Nov
20
comment How to create a label formatted like “ 1,000' ” from a numeric field?
Also, I didn't see what version you were using - you should upgrade to 2.0 to make this work
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