Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I dont even know if QGIS is the right program for what I need..

What I need: I need a program with maps(Denmark to be specific), that I could feed with a database of users through a CSV file.. e.g. give it 500 names, adresses etc. and have them dotted on the map or shown in different graphical ways, like perhaps a heat map.

What I did: tried mappoint from microsoft, quickly realised this wasn't the right program, while it was able to accept my CSV file, the way it displayed my users was of no use to me, its a glorified 'route planner' and not suited for handling multiple selections at the same time.

Where I am at now: I downloaded and installed QGIS thinking this was it, now opening it, I have no idea what to do, and it doesn't look like it holds any standard maps. so maybe this program has nothing to do with the solution I need? if not, could you direct me to one?

Note: I'd really like to avoid uploading these CSV file and not expose my users information to the internet, which is why I found solution like google maps not to be the way to go.

share|improve this question
add comment

3 Answers 3

Try the following: use the plugin mmqgis and select: -> transfer -> geometryimport from csv . select the appropriate columns for lat /long !


try the following:

goto http://www.gpsvisualizer.com/geocoder/ enter your data, e.g.

1160;Wien;Schuhmeierplatz 7;aa
1010;Wien;Opernring 1;bb

click the button "create a gpx-file"

now your browser shows somthing like this:

Your data has been converted to GPX. Right-click on the following link to download the file to your hard drive; you may want to give it a more sensible name. Click to download 1335545432-19937-80.108.48.91.gpx

download

now open this file as vector-layer via menu layer-> add vector layer- be sure you have the file-type GPS eXchange Format !!!

Hope this works for you?

Greetings Kurt

share|improve this answer
1  
make sure that your delimiter is really the comma and not the char; (which is what a german excel version exports) otherwise you will get an error message from the mmmqgis plugin. if you cant find the plugin under your plugins menu you have to install it. goto plugins ->fetch python plugins and select it from the list and install it. –  Kurt Apr 27 '12 at 9:30
    
I can't seem to find a plugin called mmqgis in the plugin manager, I assume its something I have to download then? but before doing so, do you mean it requires my CSV file to hold lat/long for each user? cause it doesn't.. it has adresses not coordinates –  Allan Apr 27 '12 at 9:32
1  
hi allan - at this moment I posted it in the comment how to get the plugin. so please see above and let me know if this info was helpful to you –  Kurt Apr 27 '12 at 9:33
2  
Allan, why not search + replace in a good text-editor: first step: search+replace all commas by points (numbers like 3,14 become 3.14) and as second step replace alle semi-colons by commas now you should have a working csv-file –  Kurt Apr 27 '12 at 10:27
1  
It seems to work only, when you select the norminatim (openstreetmap) geocoder in the settings. google-geocoder doesnt work for me, cause the plugin wants a google-api-key,which is not available anylonger. the norminatim (openstreetmap) geocoders database seems to be not very gppd, eg. I can geocode Wien (Vienna), but it doesnt know excater addresses in vienna, like Stephansplatz 1. and btw I need mass-geocoding. try the geocoder I mentioned in the answer below: It works well for me. –  Kurt Apr 28 '12 at 16:31
show 8 more comments

Here's an alternative.

CartoDB

You can sign up for free and upload a csv directly. CartoDB will geo-code your data. You can also use some simple SQL statements and or any custom CSS to selectively visualize particular data.

CartoDB will host your map for sharing with your users. There is paid subscription that can you choose to keep the tables private only sharing the map view and selected 'info window' data

https://cartodb.com/

Example: Some sample data I want my users to see

You can also export your data back to a CSV file with the latitude and longitudes to update your data. I like to use Fulcrum to upload my data, view it on a map, and download it to my GPS enable smartphone for asset management & data collection updates. Includes photos too :)

Hope this works for you.

share|improve this answer
    
I took a look at cartodb.com . The free (unpaid) version allows you up to 5 tables, up tp 5 mb and your data are open. I stay with gpsvisualizer ... –  Kurt May 1 '12 at 16:38
add comment

(not able to comment due to reputation restriction, so writing answer instead)

Kurt, there are two answers depending on what type of data you have.

  • If you have lat/long or coordinates, you can import the CSV file to QGIS and create your map via 'Add Delimited Text Layer'. There are some limitations to the CSV parser, so your CSV needs to be formatted just right. Here are detailed instructions that may help.

  • If you do not have coordinates, then the task becomes 'geocoding' - converting addresses into coordinates. There are many ways to do that. Here is a good guide.

share|improve this answer
    
thanks for adding you tutorial qgis.spatialthoughts.com/2012/01/…. its bookmarked now by me ! the second link suggests mass-geocoding with gpsvisualizer - thats what I wrote in the post above. I prefer to export from gpsvisualizer to a gpx-file, while the posts author exports to a textfile again and uses the add delimited text plugin. well thats a matter of taste –  Kurt Apr 30 '12 at 17:15
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.