Latest Contributions by ClaireKolaja1

‎04-20-2023

Ah, thank you for sharing this! If I was using point data this would be the way to go. I will keep this in mind if the project decides to move forward that way.

‎04-20-2023

Hi, my apologies, I am just getting back to this task. Do you have a link with more information on how to do that (dump to a CSV)? I have not done that before. V/r, Claire

‎03-28-2023

Please let me know if this should be posted somewhere else. I need well know text (WKT) information to download data from another source. I have a shapefile that represents zip code polygons; what tool or process can be used to create WKT information for each of the polygons? I am using ArcGIS Pro 3.1.0 and the largest dataset has ~1500 zip codes. Thanks, C

‎03-27-2017

We do not have names in this dataset, so thankfully one less thing to clean (we use studyids). I will start on the tables for those with the most address entries (I think the highest number was around 20-30). For the parsing the code that you linked to, all of the address are similar in that the do not have apartment numbers at the end. I have noticed for our address the apartment number was sometimes provided (or unit, room or lot number). I think to parse the addresses correctly I am going to have to identify those with this sometimes extra information and then move than information to the address2 field, right? That law enforcement dataset sounds daunting! I am glad you get to share what you learned from it with us on here

‎03-23-2017

Thank you for your help. I am definitely going to start with parsing the data and see where it takes me. Hopefully my eyes won't take too long to uncross!

‎03-23-2017

Thank you for your response! To be honest I am somewhat new to geocoding this large of datasets (with so many rows for each person and self reported data leads to some very creative spellings of street names!) so had not even thought to parse and standardize the fields. I don't think we would spend money validating through a company but after reading your response I think I am going to follow the steps you suggest. Thank you again for the advice!

‎03-22-2017

Hi all. I have a question that I am hoping you all could help me with. I am using ArcGIS Pro (but I could also use ArcMap 10.5). I use StreetMap Premium for geocoding. I have a large dataset with addresses where one person may have multiple addresses. Sometime these are actually different address and sometime they are the same address repeated. I want to geocode the address then (if they geocode to the same address/XY coordinate) collapse the address so that each address will only be one row (with the begin and end date from the first and last row respectively). If the address fields are not exactly the same it will not match it to the same geocoordinate and usually skips to the zip code. You can see in the example below the rows 1 and 2 below will match to the same coordinate but row 3 will probably geocode to the zip code since the street name is not recognized (please take into account I made up the address). Usually this is because the street name is misspelled but all of the other fields are the same. Is there some tool to clean these address when this happens? I am familiar with SAS programming if anyone know of a way to clean the addresses in that program. I was wondering if anyone on here has ever done this or if there is an easier way to do this in ArcGIS rather than geocoding then exporting and cleaning in SAS and the bringing back into ArcGIS Pro. Row ID Address City State Zipcode DateBegin DateEnd 1 1 123 Northbay Lane Sometown CA 12345 1/1/2015 2/28/2015 2 1 123 Northbay Ln Sometown CA 12345 3/1/2015 11/30/2016 3 1 123 Nrthby Lane Sometown CA 12345 12/1/2016 3/10/2017 Change to: Row ID Address City State Zipcode DateBegin DateEnd 1 1 123 Northbay Lane Sometown CA 12345 1/1/2015 3/10/2017 In this example I just show one example for one person but this could happen several times for one person then the data sets are several hundred thousand observations so I can't manually make the changes. Any advice would be greatly appreciated! - Claire

‎09-13-2016

I am using ArcMap 10.4 Desktop (not Pro) and the color scheme/color ramp drop down is not available when I open some maps.I am trying to create a symbol that is a range of colors depending on the value but cannot select a color so the symbol all appear as the same color. I can close the map where this is a problem and open a different map and the color ramp is available. Does anyone know a solution?

Online Status	Offline
Date Last Visited	‎04-20-2023 11:30 PM

My Ideas

Latest Contributions by ClaireKolaja1

Re: Shapefile to Well know text (WKT)

Re: Shapefile to Well know text (WKT)

Shapefile to Well know text (WKT)

Re: Address dataset problem

Re: Address dataset problem

Re: Address dataset problem

Address dataset problem

Color scheme /color ramp options drop-down boxes not available.