Jump to content

 
Photo

Non-GIS Person Struggling to Get Started

- - - - -

  • Please log in to reply
19 replies to this topic

#1
JKurzFKZ

JKurzFKZ

    Newbie

  • Validated Member
  • Pip
  • 9 posts
  • No Country Selected

Dear all,

I work for a microfinance institution, and we're very interested in using GIS to help us cut costs and improve efficiency. We're considering purchasing GPS units to map our entire network of clients all across the country. We want to be able to plot all of these clients, an include specific data about them on each plot like: the responsible loan officer, the size of the loan, the affiliated branch, etc. It's important that I can search for specific data points and can count data by selecting a series of points.

So for example, I might have an Excel file which has:
Longitude Latitude Client Name Loan Officer Loan Size Branch

As the column headings.

I've successfully done a very nice plot in Google Earth Pro, but it gives me virtually no ability to perform analysis on those points. My efforts to try ArcGIS, GRASS, and others has been frustrating because I can't even figure out how to get the maps setup and my data plotted.

What direction should I being going in so I can implement this project? Please help!

Best,
James

#2
David25

David25

    Key Contributor

  • Validated Member
  • PipPipPip
  • 70 posts
  • Gender:Male
  • Location:Calgary
  • Canada

Hi,

I'm not sure how you will map this yet (template wise), but for starters you said you had trouble plotting the data. For this, what you would need to do (in ArcGIS) is Add XY data and use the Lat and Long. This will plot points in ArcMap and you will be able to open the attribute table and see your data.

You might have to give a bit more info on what exactly you want to be able to do so people can help abit more.

Cheers,

Dave.

#3
David Medeiros

David Medeiros

    Hall of Fame

  • Validated Member
  • PipPipPipPipPipPipPip
  • 1,085 posts
  • Gender:Male
  • Location:Redwood City CA
  • Interests:Cartography, wood working, wooden boats, fishing, camping, overland travel, exploring.
  • United States

I'm not sure I see the need for GPS recordings of your clients? For typical analysis of this type you would be fine geocoding by address or manually digitizing a point location for each client in the GIS.

If you have address for each client you can easily generate a co ordinate table for you entire network. I think Batchgeo.com will do this for you.

GIS Reference and Instruction Specialist, Stanford Geospatial Center.

 

www.mapbliss.com

 


#4
dsl

dsl

    Master Contributor

  • Validated Member
  • PipPipPipPip
  • 225 posts
  • Gender:Male
  • Location:Denver
  • United States

For typical analysis of this type you would be fine geocoding by address or manually digitizing a point location for each client in the GIS.


That would depend if there is address information available in that area. Even in remote parts of the Northern Territory Australia, they don't have regular numbered addresses. I don't know where the project is.

it gives me virtually no ability to perform analysis on those points.


What type of analyses are you looking at doing? You may want to look into plotting this as a graph (related to GIS somewhat) to explore the links between loan officers and clients. You could do that in excel with NodeXL. Just a thought.

Cheers,
David

#5
Charles Syrett

Charles Syrett

    Ultimate Contributor

  • Validated Member
  • PipPipPipPipPipPip
  • 537 posts
  • Canada

From what I understand, you've already been able to plot your points on Google Earth, but you haven't been able to have them mapped on a GIS. In Google Earth, you should be able to export your plots as a kml file, which can be opened by any GIS. Then you can use whatever analysis tools are available to work with the data.

Charles Syrett
Map Graphics
http://www.mapgraphics.com

#6
Paul H

Paul H

    Paul from JIMAPCO

  • Validated Member
  • PipPipPip
  • 74 posts
  • Location:Round Lake, NY
  • United States

Please contact me through a personal message and I will help you out.

#7
JKurzFKZ

JKurzFKZ

    Newbie

  • Validated Member
  • Pip
  • 9 posts
  • No Country Selected

This is in Haiti, so address do absolutely no good.

I want to be able to highlight data points by characteristic. For example, I want to be able to highlight all clients for a given credit agent so that I can see exactly what their territory is.

Getting them into KML is no problem, I just have no clue how to analyze them in a GIS program. When I put them in, they're just static dots.

#8
JKurzFKZ

JKurzFKZ

    Newbie

  • Validated Member
  • Pip
  • 9 posts
  • No Country Selected

Please contact me through a personal message and I will help you out.



Hey Paul,

Would love your help but for some reason I can't message personally on here.

#9
Paul H

Paul H

    Paul from JIMAPCO

  • Validated Member
  • PipPipPip
  • 74 posts
  • Location:Round Lake, NY
  • United States

Please contact me through a personal message and I will help you out.



Hey Paul,

Would love your help but for some reason I can't message personally on here.

No problem. Go to locationintel.com and see if this can help. You can contact me through there.

Thanks.

#10
Hans van der Maarel

Hans van der Maarel

    CartoTalk Editor-in-Chief

  • Admin
  • PipPipPipPipPipPipPip
  • 3,882 posts
  • Gender:Male
  • Location:The Netherlands
  • Interests:Cartography, GIS, history, popular science, music.
  • Netherlands

Would love your help but for some reason I can't message personally on here.


I've upgraded you to a validated member, you can PM now.
Hans van der Maarel - Cartotalk Editor
Red Geographics
Email: hans@redgeographics.com / Twitter: @redgeographics

#11
David Medeiros

David Medeiros

    Hall of Fame

  • Validated Member
  • PipPipPipPipPipPipPip
  • 1,085 posts
  • Gender:Male
  • Location:Redwood City CA
  • Interests:Cartography, wood working, wooden boats, fishing, camping, overland travel, exploring.
  • United States

This is in Haiti, so address do absolutely no good.

I want to be able to highlight data points by characteristic. For example, I want to be able to highlight all clients for a given credit agent so that I can see exactly what their territory is.

Getting them into KML is no problem, I just have no clue how to analyze them in a GIS program. When I put them in, they're just static dots.


If you don't already have coordinate information and addressing is of no use then how did you locate your clients in GE?

If you are getting your dots into a GIS but are unable to do any analysis with them it's likely that you have brought in point locations only and no other attached attributes to analyze on. It's actually a pretty minor task to add attribute info but the specifics vary by software. What GIS exactly are you using? Whatever the software, you should be able to create a table with all of the desired information and simply join this to your existing plotted points. From there making simple selection by attribute info is fairly straightforward.

GIS Reference and Instruction Specialist, Stanford Geospatial Center.

 

www.mapbliss.com

 


#12
JKurzFKZ

JKurzFKZ

    Newbie

  • Validated Member
  • Pip
  • 9 posts
  • No Country Selected

This is in Haiti, so address do absolutely no good.

I want to be able to highlight data points by characteristic. For example, I want to be able to highlight all clients for a given credit agent so that I can see exactly what their territory is.

Getting them into KML is no problem, I just have no clue how to analyze them in a GIS program. When I put them in, they're just static dots.


If you don't already have coordinate information and addressing is of no use then how did you locate your clients in GE?

If you are getting your dots into a GIS but are unable to do any analysis with them it's likely that you have brought in point locations only and no other attached attributes to analyze on. It's actually a pretty minor task to add attribute info but the specifics vary by software. What GIS exactly are you using? Whatever the software, you should be able to create a table with all of the desired information and simply join this to your existing plotted points. From there making simple selection by attribute info is fairly straightforward.


I've piloted it by taking some sample points using GPS. We're thinking about purchasing a few hundred Garmin units and measuring all of the meeting locations and many of the client locations.

GRASS would be ideal because it is free, but honestly I'm completely lost when I load up the software. Where is the map? I wish it was a little more plug and play, but in any case I really need help getting started. I'm fine with my Excel file full of coordinates and I have all of the attribute data available to add, but when I convert the points to KML and load them up in a demo version of ARCGIS, I just get these data points and I really don't understand how to manipulate them. I try to click on them, but they're none clickable... really just don't know how to use the software I guess but I have no time to learn everything, I just want to know how to do these specific tasks.

#13
JKurzFKZ

JKurzFKZ

    Newbie

  • Validated Member
  • Pip
  • 9 posts
  • No Country Selected

Would love your help but for some reason I can't message personally on here.


I've upgraded you to a validated member, you can PM now.


Thanks so much Hans.

#14
David25

David25

    Key Contributor

  • Validated Member
  • PipPipPip
  • 70 posts
  • Gender:Male
  • Location:Calgary
  • Canada

If you can download some free shapefiles of Haiti and are able to use them you can use ArcGIS to add your XY data (from Excel) and export to shapefile. Then your attributes will be there and you can symbolise by given credit etc to see where they are geographically.

If you're set on GE then I will leave it someone else to help you.........

#15
JKurzFKZ

JKurzFKZ

    Newbie

  • Validated Member
  • Pip
  • 9 posts
  • No Country Selected

If you can download some free shapefiles of Haiti and are able to use them you can use ArcGIS to add your XY data (from Excel) and export to shapefile. Then your attributes will be there and you can symbolise by given credit etc to see where they are geographically.

If you're set on GE then I will leave it someone else to help you.........



Here's my dream. I highlight with my mouse a series of client locations and it sums up the total loan outstanding, just like highlighting a series of cells on Excel. Can this be done?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

-->