Reputation
Top tag
Next privilege 100 Rep.
Edit community wikis
Badges
1 10
Newest
 Revival
Impact
~4k people reached

  • 0 posts edited
  • 0 helpful flags
  • 14 votes cast
Jan
11
comment ogr2ogr + MapInfo TAB + SQLite (SpatiaLite) = unicode problems
Had a similar problem going from a Win-1252 .TAB file to Postgres, used option (2) from above. Code follows in case it helps anyone. Convert to GML: ogr2ogr -f GML original-1252.gml original-1252.TAB --config OGR_FORCE_ASCII NO Change encoding: iconv -f CP1252 -t UTF-8 original-1252.gml >converted-utf8.gml Finally load: ogr2ogr -f PostgreSQL %PG_CONECTION_DETAILS% converted-utf8.gml -nln schema.new_table_name
Oct
22
awarded  Revival
Sep
9
awarded  Notable Question
Nov
6
awarded  Scholar
Nov
6
accepted How to call Leaflet FullScreen plug-in from code
Jul
15
awarded  Teacher
Jul
9
answered What is the path for font in mapfish print module for windows in config.yaml?
Jan
8
answered How to call Leaflet FullScreen plug-in from code
Dec
27
awarded  Tumbleweed
Dec
20
revised How to call Leaflet FullScreen plug-in from code
spelling
Dec
20
asked How to call Leaflet FullScreen plug-in from code
Jul
25
awarded  Popular Question
Feb
21
comment Allocate places according to distance
Both the tables (events & attendees) have a geometry column (as well as an separate x & y columns), I've used this to produce the distance matrix as per my original post. I've updated by question as summarised by the answerer on Stack Overflow.
Feb
21
revised Allocate places according to distance
added additional information
Feb
21
comment Allocate places according to distance
Apologies, I should have been clearer. I initially have the data in two Oracle spatial tables where the events and the attendees have a geographic co-ordinates; I skipped that part of the problem on Stack Overflow. As my GIS knowledge is much better than my math knowledge, I entered it here in case there was a solution using GIS/Spatial Databases. Willing to delete this post if that is the consensus.
Feb
21
comment Allocate places according to distance
Here is the Stack Overflow question. There has been 1 answer so far but it is more than a little over my head, but it may help someone along the way.
Feb
21
asked Allocate places according to distance
Feb
20
awarded  Informed
Nov
8
asked Convert non-spatial Oracle table to spatial Oracle table in a different database
Jul
12
awarded  Supporter