Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

Browse Open Actuarial Jobs

Life  Health  Casualty  Pension  Entry Level  All Jobs  Salaries


Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 10-10-2018, 11:55 AM
Daniel Daniel is offline
Member
CAS SOA
 
Join Date: Jan 2012
College: Alumni
Posts: 246
Default mapping software

can anybody recommend a easy-to-learn mapping software (at the street level maybe)? Does Excel or SQL has the capacity of mapping?
Reply With Quote
  #2  
Old 10-12-2018, 02:27 PM
Tom's Avatar
Tom Tom is offline
Actuarial Outpost Administrator
Contact me: Send me a PM
or email me
tom.troceen@dwsimpson.com
CAS SOA COPA
 
Join Date: Jan 1987
Location: Sitting in front of a red button w/ your name on it
College: FSU ActSci Alumni
Favorite beer: Root
Posts: 11,548
Blog Entries: 7
Default

Not really sure what you're looking for, but I've used QGIS for several mapping projects.


https://qgis.org/en/site/



Beyond that, the Google Maps API is pretty straight forward, assuming you're comfortable using APIs.
__________________
Questions? Contact me at tom@actuarialoutpost.com or send me a PM here.
Reply With Quote
  #3  
Old 10-12-2018, 05:36 PM
Daniel Daniel is offline
Member
CAS SOA
 
Join Date: Jan 2012
College: Alumni
Posts: 246
Default

Quote:
Originally Posted by Tom View Post
Not really sure what you're looking for, but I've used QGIS for several mapping projects.


https://qgis.org/en/site/



Beyond that, the Google Maps API is pretty straight forward, assuming you're comfortable using APIs.
Thank you for your help. If I like to present written premium by county, say large dots representing high volume, small dots representing low volume, can Excel do that trick? if not, try QGIS?
Reply With Quote
  #4  
Old 10-13-2018, 01:50 AM
Tacoactuary's Avatar
Tacoactuary Tacoactuary is offline
Member
CAS Non-Actuary
 
Join Date: Nov 2014
Location: Des Moines, IA
College: Vanderbilt, UIUC
Favorite beer: Yazoo Sue
Posts: 1,129
Default

You can do that pretty easily in R
__________________
ACAS 7 8 9
Reply With Quote
  #5  
Old 10-13-2018, 10:28 AM
Maphisto's Sidekick's Avatar
Maphisto's Sidekick Maphisto's Sidekick is offline
Member
CAS
 
Join Date: Nov 2001
Location: South Park Genetics Lab
College: Ardnox
Favorite beer: The kind with alcohol
Posts: 2,641
Default

FWIW, while Excel 365 seems to be able to map data by county...I've had issues using it for countrywide data.

I miss MapPoint, where I could create territory definitions just by selecting ZIP codes, counties, etc. from the map.
Reply With Quote
  #6  
Old 10-14-2018, 08:35 AM
Kalium Kalium is offline
Member
 
Join Date: Dec 2014
Posts: 59
Default

For a one-off application, you can do it in Excel. Insert a map picture, that just covers your whole area, as a picture background to a chart. You then need some location data (say latitude/longitude) for each county or whatever, and then play around with scaling to get it to display correctly.
Reply With Quote
  #7  
Old 10-14-2018, 01:41 PM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 6,630
Blog Entries: 1
Default

We have a county map in Excel. I have no idea where it came from, but I would guess if you googled VBA, shapefiles (.shp) and excel shape objects, you'll find the code you need to extract shape files (a list of points that make up polygons) to excel shape objects (those things you can draw).

I know Google has some simple heat mapping software.

There's also some open source crap like QGIS that you don't want to touch unless you love open source crap.
__________________
Sredni Vashtar went forth,
His thoughts were red thoughts and his teeth were white.
His enemies called for peace, but he brought them death.
Sredni Vashtar the Beautiful.

Last edited by Sredni Vashtar; 10-14-2018 at 01:44 PM..
Reply With Quote
  #8  
Old 10-14-2018, 01:44 PM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 6,630
Blog Entries: 1
Default

Quote:
Originally Posted by Kalium View Post
For a one-off application, you can do it in Excel. Insert a map picture, that just covers your whole area, as a picture background to a chart. You then need some location data (say latitude/longitude) for each county or whatever, and then play around with scaling to get it to display correctly.
This would work too. But use VBA or ask someone who knows VBA! Don't go drawing dots by hand!!!
__________________
Sredni Vashtar went forth,
His thoughts were red thoughts and his teeth were white.
His enemies called for peace, but he brought them death.
Sredni Vashtar the Beautiful.
Reply With Quote
  #9  
Old 10-15-2018, 06:25 AM
Kalium Kalium is offline
Member
 
Join Date: Dec 2014
Posts: 59
Default

Quote:
Originally Posted by Sredni Vashtar View Post
This would work too. But use VBA or ask someone who knows VBA! Don't go drawing dots by hand!!!
You don't need to do either of these. Just plot longitude on the x-axis, latitude on the y-axis (both with a simple linear adjustment), with the data point as the written premium. To get different sized circles you could split this into say 3 or 4 ranges for different volumes, and then display each range as an appropriate sized dot. Then just play around with the linear adjustments until the dots display in the correct place on the background map
Reply With Quote
  #10  
Old 10-16-2018, 07:27 PM
Fish Actuary's Avatar
Fish Actuary Fish Actuary is offline
Member
Non-Actuary
 
Join Date: Jun 2006
Location: Australia
Posts: 11,141
Default

Quote:
Originally Posted by Tacoactuary View Post
You can do that pretty easily in R
+1...

For my last job I was doing some pretty complex spatial analysis in R. IIRC the Washington Post and NYT have both moved a lot of their map based figure production into R and possibly some python...

Check this link for one starting point:
https://www.molecularecologist.com/2...g-maps-with-r/

Or try googling mapping in R
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 08:16 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.17829 seconds with 9 queries