3,359 reputation
1327
bio website
location London, United Kingdom
age
visits member for 4 years, 4 months
seen 7 hours ago

Oct
29
comment How can I calculate route using travel time in network analyst?
Have you made 100% sure that if you count up all the travel time totals using segements g-e-c-b-h it is more than g-a-b-f-h. It looks like the problem is in the data. Also can you clarify - is the problem the spatial route it gives you or the textual description of the route?
Oct
28
answered Find lat/lng weighted midpoint from a list of points
Oct
28
answered GeoJSON from OpenStreetMap with bike routes of a city only?
Oct
27
revised How to calculate polygon areas in QGIS?
clarification of answer
Oct
27
answered QGIS Forms - How Do I Display a Read-Only Value?
Oct
27
comment How to calculate polygon areas in QGIS?
see comment below - click the edit button and you should see it enabled
Oct
22
awarded  Good Answer
Sep
30
awarded  Explainer
Sep
1
asked insert row into postgis query table in QGIS
Aug
26
awarded  Caucus
Aug
26
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