topic Re: Need to map Lat and Long to street level in Graphics Programming

Need to map Lat and Long to street level

Kaushansky — Sun, 31 Mar 2024 14:19:41 GMT

I have a crime lat and Long file and would love to map the crime stats at the street level? What is the best approach?

Re: Need to map Lat and Long to street level

AhmedAl_Attar — Sun, 31 Mar 2024 15:20:26 GMT

Hi @Kaushansky

Which SAS software stack you have access to / planning to use?

SAS Foundation: You can browse through the papers returned from this search: https://www.lexjansen.com/search/searchresults.php?q=Latitute
SAS Visual Analytics:
- https://support.sas.com/resources/papers/proceedings16/SAS3480-2016.pdf
- https://support.sas.com/resources/papers/proceedings19/3348-2019.pdf
- https://video.sas.com/detail/video/4027587163001/adding-report-objects:-working-with-geo-map-report-objects
- https://www.youtube.com/watch?v=HvEAWG34eE4
- For inspiration: Have a look at this sample Dashboards
  - https://communities.sas.com/t5/SAS-Visual-Analytics-Gallery/Mapping-Crimes-in-Washington-D-C-using-SAS-Visual-Analytics/ta-p/709588
  - https://public.tableau.com/app/search/vizzes/crime (Tableau dashboards, but their designs and contents may be relevant)
JMP: https://community.jmp.com/t5/Discovery-Summit-Americas-2022/The-Understanding-of-Criminal-Rate-and-Crime-Prediction-2022-US/ta-p/521432

Hope this helps,

Ahmed

Re: Need to map Lat and Long to street level

Kaushansky — Sun, 31 Mar 2024 16:50:57 GMT

Hi there.
I’m using desktop SAS 9.4 and have SAS Studio 3.8

Re: Need to map Lat and Long to street level

AhmedAl_Attar — Sun, 31 Mar 2024 18:15:27 GMT

@Kaushansky

@Kaushansky wrote:
Hi there.
I’m using desktop SAS 9.4 and have SAS Studio 3.8

Hmm, to my knowledge, in this case you are limited to SAS/GIS (if licensed) and maybe Proc Geocode!?

Re: Need to map Lat and Long to street level

Quentin — Sun, 31 Mar 2024 19:36:56 GMT

There is an article on reverse geocoding here:

https://communities.sas.com/t5/SAS-Communities-Library/Reverse-Geocoding-Using-PROC-GINSIDE/ta-p/895337

I would think that would be good for, say, mapping lat and long to state level, or county level, because a polygon can represent a state or county. Not sure how well it would work for mapping to a street.

I guess another option would be to use a google maps API or similar to do the lookups.

I also stumbled across this solution, which uses an R package to reverse geocode, and looks like it will look up street addresses. https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-do-reverse-geocoding-in-SAS/td-p/342193

Re: Need to map Lat and Long to street level

GraphGuy — Mon, 08 Apr 2024 20:50:34 GMT

Someone mentioned SAS/GIS - that would probably be the best SAS solution for this type of thing ... but it was never finished, and the current version of the software has been 'frozen' (no new decelopment) for many years, and it would be difficult to find expertise/advice/examples to help you with that.

You could plot lat/long crime data on streetmaps using SAS/Graph Proc Gmap, but it's a bit cumbersome (you have to download all the map tiles, and stitch them together, and then get a bit tricky to annotate your data onto the map tile images).

SAS Proc SGmap makes overlaying lat/long data onto streetmaps very simple - that's what I would recommend. I put an example in a blog that might get you started (sample code at bottom of the blog): https://blogs.sas.com/content/graphicallyspeaking/2021/08/17/cary-nc-data-fire-incidents/

Re: Need to map Lat and Long to street level

Kaushansky — Sun, 14 Apr 2024 17:55:00 GMT

Thanks but that did not work. Here is the dataset I have (attached). In terms of SAS I have Proc Map and Proc GIS loaded.

What is the best way top map by zipcode?

Re: Need to map Lat and Long to street level

Quentin — Sun, 14 Apr 2024 18:09:51 GMT

If you go to lexjansen.com index of user group papers, there are lots of papers about mapping by zipcode:

https://www.lexjansen.com/search/searchresults.php?q=map+zipcode

This isn't something I do, so can't recommend a specific approach.