Tag Info

New answers tagged

1

Just wish to add two things to John Barça's fine answer: First, ST_PointFromText() would be most useful if your coordinate data were already in the form of lines of text like this POINT(xxx.xx yyy.yy) where each xxx.xx yyy.yy were actual coordinates, perhaps as output from another process/system. Going out of your way to add in the text "POINT" is ... ...


4

First of all, some performance metrics, comparing the two different ways of producing points for a random selection of a million points. create table test (id serial, x real, y real, geom geometry(POINT, 27700)); insert into test (x, y) select random(), random() from generate_series(1, 1000000); update test set geom = ST_SetSRID(ST_MakePoint(x, y),27700); ...


2

I clearly don't know the "best" solution between ST_PointFromText and ST_MakePoint. The thing you should notice is that ST_PointFromText and PointFromText are the same function (syntax change due to function normalisation SQL MM). Now, the right ones are ST_* So what you want is something like below (|| are for concatenation) UPDATE points_of_interest SET ...


0

I agree that @nhopton's answer solves the OP's problem as VMD is a cartographic product and not a routing one. For what it's worth though, I have created two routeable networks using PgRouting and OS datasets. I have a full UK "quick and dirty" network made using the OS Strategi shapefiles and a more detailed network of Scottish roads from ITN (Integrated ...


3

You can manually download your Ordnance Survey Translator plugin from the repository and extract the folder to the following directory: C:\Users\(your user name)\.qgis2\python\plugins\ Restart QGIS and from the toolbar, go to Plugins > Manage and Install Plugins... Your plugin should be listed, check the box next to the plugin name to enable it.


0

It's no possible using only web services. The images coming from the Ordnance Ordnance Survey are using projections EPSG:27700 and the Bing Maps are using EPSG:3857. Different projections means different scales, different x,y origins, different units, different images deformations. It's not possible to apply transformations to correct this on client side ...



Top 50 recent answers are included