Tag Info

New answers tagged

0

AFAIK there is currently no 'best practise' on how you organize the OSM data at your PostGIS backend. There are different database schemas that are tuned for specific purposes: rendering geospatial lookups / reverse geocoding fulltext search / gazetter ... If you have a very specific usecase, you might tweak the OSM importer mappings (e.g. at osmosis or ...


0

The top open-source alternative is MapBox. It's lets you utilize multiple baselayers from Google Maps, Bing, ArcGIS, etc. Ultimately, it's better to host your GIS server "in the cloud" using Amazon EC2, or Rackspace, which will allow you to easily scale horizontally (more servers), and vertically (more powerful hardware). If your intent is to keep data ...


0

National Earth SQLite database uses Well-known binary format in GEOMETRY column. It's well described on this Wikipedia page, however you can also find some libraries to handle it, for example http://geophp.net/ If you want to use it with SpatiaLite, here is example of SQL query: SELECT name, GeometryType(GeomFromWKB(GEOMETRY)) FROM ne_10m_admin_0_countries ...


2

No, but use can use PostGIS function ST_Length for that. It returns length in meters if way field is of geography type. That is, to get length in meters, convert it: ST_Length(ST_Transform(way, 4326)::geography).


2

I was running into this error (001156) on the same line of a large pipe-delimited text file (2,712,391) rows about a quarter of the way through. So I thought there was something wrong with that line, but it was identical to the remainder of the rows. I ended up deleting the rows from the partial import and then loading the data (Load>Load Data...) and was ...



Top 50 recent answers are included