Get Help With Batch Geocoding

Introduction

CSV-2-Geodata is a batch online geocoder software service.
It provides live conversion of batch addresses into geographic coordinates (latitude and longitude).

  • What makes csv2geo.com different from the other great competitor tools out there:

  • It is built with simplicity and flexibility to allow easy batch/batch geocoding.
  • It accepts any type of address tokens, and process them into geographic coordinates with minimal interaction from the user.
  • It provides very accurate online geocoding results. It does provide live, real time geocode conversion.
  • It is built with responsive design - works natively well on laptop, iPod, Smartphone.
  • It has unique authentication/authorization mechanism so user does not have to even remember its password.
Use cases
  • Use cases

    There are a variety of areas where geolocation is used to facilitate, understand, drive, and improve the quality of life. With the ability to capture and process data becoming an element of our daily habits, having batch geocoder analogous to CSV 2 Geo Data can assist first hand to gather useful data in minutes.

  • Civic and Political activism

    Do you have a number of residential or commercial addresses that you would wish to convert to geolocation with latitude and longitude as output? Are you involved in an effort to promote a cause you care, or you desire to promote political, social or environmental transformation at your local, state or federal level of government? Would you like to prepare geo data for political canvassing campaigns? With csv2geo.com, you could do that.

  • Email marketing

    Do you prepare for a marketing campaign and you desire to segment your target audience by geolocation? Are you sending emails out and you wish the recipients to be receiving them in a specific time zone based on geodata?

  • Real Estate

    Have you heard the phrase: “Location, Location, Location." In these days, geodata had become synonyms for real estate developers, agencies, and appraisers’ daily job. Do you have large numbers of multiple listing services (MLS listings) and you wish their geodata to prepare your campaign? Just insert your CSV file and in minutes, you would acquire clean addresses with attached geolocation coordinates(latitude, longitude).

  • Company inventory

    Do you have difficulties counting all the locations you are operating at each moment as geodata? Do you spend a significant amount of time assembling geolocation data on daily, weekly, or monthly basis? With csv2geo.com, all you need is to insert your input data and obtain as output clean addresses with a compliment of latitude and longitude.

  • Financial Services

    Are you a bank, financial audit, risk, advisory or a tax company? Do you have anti-money laundering segment in your portfolio of operations or VIP clients across the globe? Do you desire to do geolocation profile of the account holder's property? Within minutes, you can do that by secure upload clean data addresses CSV file without client personal information (like name, account number, etc..) and obtain the geolocation data. Csv2geo.com is built from the ground up to handle security risks and prevent unauthorized attempts to access data.

Login / Logout
  • Login as a guest.

    This is the default login state of the application. Regardless if you are a registered user or never visited before, the login as a guest offers you full access to process geolocation data. The system is already set up for you to log in as a guest.

    There is no logout if you are logged in as a guest.

  • Login, Logout as registered user.

    There are two ways that you can log in as a registered user. The first way is to enter user email and password. Click on the Guest link and supply registered already email and password.

    The second way is to click on a link inside an email with processed job sent to your registered email account. The system will automatically log you in with proper credentials. To log out, simply click on user link and select log out.

Upload data
  • Upload data

    The user can upload data from a local device - cell phone, iPad, PC, laptop, etc... also, the user also can upload data from the cloud if local device is connected to the cloud and offers upload capabilities. To upload data, the user drags and drops a file inside the designated file upload area or clicks on that area and then navigates to the desired file and selects the file.

  • File type and size

    Csv2geo.com accepts only comma separated value type files . We limit the size of the file to 100 MB, as large files take an hour or more to process live data. For example, a voter file may consist of more than 100 columns per row, where 100 Mb file will consist of about 300,000 records.

  • Upload from source

    The user is liberated to upload the data file from any location granted by the device the user is using. For example, iPad or cell phone user may decide to use iCloud or similar cloud storage directly.

  • File properties

    After successfully uploading the data file, the following file properties are displayed: - Name of the file, including the CSV extension - Size of the file in bytes - Number of rows in the file.

Set up map address fields.
  • Set up map address fields

    Geographical address is a complicated structure and over time nearly everyone takes it for granted. For example, just the street number may occasionally have 4-5 parts. Street name every so often may consist of 5-6 parts. At csv2geo.com, we look it differently. We separate an address into six major components (tokens) and give the user the ability to associate on the fly one or more file columns to single address token. One of the reasons geodata manipulation is expensive since the majority of the competitor tools will require either flat file template that restricts user of what input data to load or awfully inefficient file manipulation.

    In csv2geo.com you can specify the following combinations:
    country if omitted is consider USA

    • street number, street name,city,state,zip, country
    • street number, street name, city, state
    • street,city,state (street will include the number as onecolumn)
    • zip
    • zip,country(uses postal code instead of zip)
    • street
    • etc...
  • File header

    The user has the ability at every point while setting up map address fields to clear the selection by pressing Clear address button.

  • Address components(tokens)

  • Street Number

    The street number can consist of several parts that form the street number fully. For example, a street number can consist of and not limited to;

    • - house number character - an alpha prefix to house
    • - Resident street number - actual street number
    • - House suffix

  • Street Name

    This segment indicates the general street name.Street name can consist of several parts listed below, and not limited to:

    • - Pre-direction - N, S, NE, etc...
    • - Street name
    • - Street Type - Ave, St, RD, etc...
    • - Suffix direction - N, S, NE, etc...
    • - Residence extension: lot #, app #, etc...

  • City Name

    City name can consist of one or more words, often in separate columns in the input file

  • State Name

    This segment indicates state name, province, or similar territory.

  • Zip Code

    Zip indicates Zone Improvement Plan code number orpostal number outside of USA

  • Country

    Country or region that indicates a distinct area in political geography. If a country is omitted from selection, United States is used by default.

  • Select address tokens from uploaded file columns

    When imported to csv2geo.com, a letter driven header is added on the top of the imported file data that will be used to mark selection inside address token segments.

    The user can select zero, one or more columns from the imported file to map to one of the six map filed address segments.

    For example, a file that has a column with the following data:

    To make the selection, use the tiny pointing down triangle type arrow.

    On the example for column J we might notice that street number and street name are combined into one column. Therefore, the user can decide to select under the columns both, the street number, and street name or just street using the tiny arrow in the right corner of the column. The system will indicate the user's choice by adding street number and street token under column J to indicate the selection. Also, column J label is placed under two address token - Street number and Street name.

    Regardless of whether the order of checks, user's choice are always ordered left to right.

    For example selecting street number and street name will be street number first and street name second.

  • Deselect address token selection

    Similar to selecting the address token, in reverse order, the user may decide to deselect already selected columns in the address tokens. To do that, the user simply traces the letter from address token segment to which column represents in the data file and using the tiny arrow un-checks the selection.

Process data
  • Process data

    In order for the service to process imported data, a minimal valid address compilation must be selected by the user.For US, that could be just a zip file.

    If you select street, then you would need to select at a minimum, the city and zip code in order to process the data. A green button labeled Process appears.The Example shows a minimal selection of just a zip code.

    Process file

    Clicking on Process button will process the first ten addresses and compile and display their geolocation. The data will be added to the right of the last column of the file inside the grid.

    Also, by default all non-selected columns from file data will be hidden. Only columns that were part of geolocation calculation will be shown. The user may decide to see all columns by checking Show all columns check box

    The User could verify the accuracy of calculating data before buying it by examining the first ten rows.

Prepare to Purchase data

Clicking on the buy button will trigger one ofthe two events:

  • Buy data as already logged in user

    In case when the user is already logged in, PayPal/Credit Card payment page will be open, and the user has to fill the mandatory data to complete the purchase.

  • Buy records as guest or non logged in user

    Buy records as guest or non-logged in user. In case the user was never registered in the system, orcurrently is logged out, simply fill the open text box with your email and agree to the company policy and terms of services by checking the check box under the email entry.

  • Notification email to complete purchase

    Finally, after submitting the email address and agreeing to the license, the user should receive an email on the email address that was supplied.

    The email contains a direct link to Working History page where the purchase needs to be finalized.

Navigate to Work history to pay

Work History page is where the user can buy the actual data and download the desired result. There are two ways to navigate to that page.

  • Navigate to Work History using email

    Clicking on the email link from your email you received after submitting desire to buy records will bring you to Work History page.

  • Navigate to Work History by log in

    Click on Guest link and enter your email and password

Pay

Records via file are available to buy the moment the user sees the buy button
Buy

Inside Work history page the user can pay to obtain the calculated geocoding results.

There are two ways currently the user can pay:

  • Pay by credit card

    By clicking on the Credit card button the user navigates to the credit card payment page. Csv2geo.com does not store credit card information. Also, csv2geo.com rely on PayPal to handle security and maintenance of the credit card payment process.

  • Pay directly by PayPal

    By clicking on PayPal card button, the user navigates to the PayPal payment page.

Download results

After successful payment, csv2geo.com starts to process the data. Depends on the size of the file it may take minutes to hours. The user can see the progress inside the Work history page. When the process is completed, the user will receive an email with a link to download the file. Also, inside Work history page the records will be available for download via a download button.