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

1d
awarded  Caucus
1d
awarded  Constituent
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
revised Get default values from PostGIS DB in QGIS 2.4 editor
added 199 characters in body
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..
Aug
11
revised Get default values from PostGIS DB in QGIS 2.4 editor
added qgis metadata
Aug
11
asked Get default values from PostGIS DB in QGIS 2.4 editor
Jul
27
awarded  Yearling
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
15
reviewed Edit suggested edit on Calculate distance between point and linestring and how to represent that on QGIS?
Jul
15
revised Calculate distance between point and linestring and how to represent that on QGIS?
made graphic visible in post
Jul
15
reviewed Approve suggested edit on Erasing overlay geometry with in the feature class..!
Jul
15
answered Converting a JOSM indoor map to QGIS
Jul
15
answered Update OSM data already imported in qGIS
Jul
14
answered How to create WKT file readable by QGIS 2.4.0
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.
Jul
8
answered Translate coordinates in GeoJSON export