3,246 reputation
1226
bio website
location London, United Kingdom
age
visits member for 4 years, 1 month
seen 5 hours ago

Aug
11
comment Get default values from PostGIS DB in QGIS 2.4 editor
I might file a bug on this - the only thing I have got so far is that if I open the postgres layer via the Add Vector Layer -> Database ->Postgres option I get no ID form, whereas if I do Add PostGIS layer I get an empty ID form with the same database connection. This is a little inconsistent to say the least. Thanks for your help Get Spatial
Aug
11
comment Get default values from PostGIS DB in QGIS 2.4 editor
OK that is quite odd, if I create a new OGR database connection via the add vector data window and type in all my credentials, it works, apart from there is not even an ID box - it disappears totally. I wonder if you need to refresh the DB connection in order to get these things through - I will test
Aug
11
comment Get default values from PostGIS DB in QGIS 2.4 editor
They are in different databases - not sure why the connection strings are different - can't seem to change that. Have added my screenshot. Permissions are the same - the superuser owns both table and sequence.
Aug
11
comment Get default values from PostGIS DB in QGIS 2.4 editor
I have added the metadata from the table definitions. I notice that the layer sources are different, but that is about all..
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?