This tool is designed as an import assistant to convert your preliminary database into your yellowfox portal address database. CSV files will be supported. The converted and self entried records can be previously geocoded.
After the start of "YellowFox Geocoder", the program is searching for new updates.
This procedure can take up to 1 minute, depending on your internet connection. If no new updates was found, the program is checking if you entered rti access codes.
If you have ever started this tool and you not closed your previous project, the tool will starting this one.
Immediately the status bar displayed "ready", the starting proccess is done and you will seen approximately following window.
To create a new project, just enter the wanted name of the project into the text box and click "ok". The YellowFox Geocoder will create an new project automaticly.
With the button "reload table" you will open the empty table and you are now able to insert new records.
After every program start and on every click in the menu extras --> "searching for new updates..." an update check will be procceded. If a new update is available, you will be informed about the current and the available version. If you want to procced the update, please click "yes" otherwise "no". Not installing available updates may cause malfunction up to destroying your address database. While the update is running the YellowFox Geocoder close himself, download the new update and restart
In this dialog you set the attributes of the csv file you will imprt. It is divided into 6 steps.
Source file selection. Click on "open" and select the file you want to import. The path including the filename will be shown in the textbox of step 1.
properties of the csv file:
Check the import file - at this step the settings which you have selected will be checked. Additionally the field names of the csv file will be added to the selection fields.
In this step you will allocate the fields of the csv file to the fields of the YellowFox database.
In the textbox default value, you can input default text. You can yhoose, when they will be used. Whether only if there is nothing inputed into the field or always.
At this option group you can select between delete all records from the temporaray YellowFox Geocoder database and add the records you want to import to the temporary database.
reaction if a doublet was found:
What kind of reaction do you want to proceed if a doublet was found?
A click on "import start" the import procedure will be starting. A click on " close" will close the dialog and you will go back to the main window.
While the import process you will be informed in the status bar, how many records have been imported yet. Immediately the import procedure has been completed, you will be informed how many records toal have been imported.
You will find the rti access codes in the extras menu RTI (interface)
Is the authorization code from company.
Is the authorization code from import.
The entered key pair will be checked.
Attention, this process can not be reversed!
All records from the address database in the portal will be deleted.
The requested language can be selected in the menu under settings --> language.
The table conatins all address entries, which are in the project database.
column name | description | format |
---|---|---|
ID | continous id number | number (automatic) |
company | company description 1 | text (max. 100 characters) |
company2 | company description 2 | text (max. 100 characters) |
postcode | postcode | text (max. 10 characters) |
city | city | text (max. 100 characters) |
street | street | text (max. 100 characters) |
hnr | house number | text (max. 10 characters) |
on map | do you want to display the address on the map | check (yes/ no) |
position description | text that will be shown on the map | text (max. 100 characters) |
Lat | latitude (x coordinate) | number (not editable) |
Lon | longitude (y coordinate) | number (not editable) |
LatM | latitude (x coordinate) - mercator format | number (not editable) |
LonM | Longitude (y coordinate) - mercator frmat | number (not editable) |
encoded | address is geocoded | number (1/0) (not editable) |
Online | address is transmitted | number (1/0) (not editable) |
The view can be specialised by predefined filter values.
following data views are available:
If you want to edit a record, you must check this one. After that, input the favoured value into the cell. If you want to cancel your input press the key 'ESC'. To save the record uncheck thisone or check another cell. Inside the table you can navigate with mouse and the arrow keys of your keyboard. To change the value of 'on map' you must check this cell and press the 'SPACE' key or click into the selection box with the mouse arrow. The addresses which are already geocoded, but with the comment 'to edit'(beige background), has found more than one possible geocode address. To select which address you will allocate to this entry, right-click on the record and select 'to edit'. A selective-dialog will be shown (see picture), there you can select the wanted address you will allocate. By using the button GoogleEarth you can view the addresses in GoogleEarth. You need a working installation of GoogleEarth to use this feature.
With this option you celete all displayed records from the project database. To change the data view, you only must change the filter. If you want to delete only one record, just right-click them and select 'delete record'.
With this function the geocoder will find the address values (street, hnr, city...) by the given coordinates (reverse geocoding).
result colours:
With this function you try to geocode all displayed records. If you want to change the displayed view, use the filter option 'data view'.
result colours:
If the imported material contains longitude and latitude values alreay, you can use them without any further processing needed.
With this function you try to send all displayed records to the portal address database. All successful transmitted records have a '1' in the column 'online'. Only these records will be shown the data view filter 'already transmitted'.
possible reasons for an failing geocoding: