Parse Address

Instructions for use

When we need to visualize a region, we often need to obtain the spatial coordinates of the geographic entity in order to make the spatial location more accurate. At present, a large number of data on the network usually only contain specific address text Description, lacking coordinate information. In this case, you need to use the Parse Address function to match the address described in the text with the existing address of the Online Resource, so as to obtain the specific longitude and latitude coordinate values.

Currently, only address information in pure Tabular Dataset is supported. If your data is in the format of Save as Excel, CSV, txt, etc., it needs to be converted to pure Tabular Dataset first. Refer to the Import Data page for conversion details. At the same time, before using this function, it is necessary to ensure that the current computer network is available.

Operating instructions

There is an Excel File of Beijing Homelink real estate data, in which the detailed address of the house source is recorded in detail. The following will take this data as an example for Parse Address, and finally superimpose it on the map to view the Position Info of the house source more intuitively.

Figure: Tabular Dataset after Excel import
Caution:

If there is a null value in the parsed X and Y fields, it means that the program has no record of successful parsing, and the user can execute the operation of Parse Address again. On the Parse Address dialog, select the Only parse empty coordinates check box to parse an empty coordinate record again.

Figure: Parse Address Result
Figure: Result of Overlaying Online Map After Property Transferred to Point Dataset
  1. Excel File is imported into the Target DatasetData source through the Data Import function, and the imported file exists as Tabular Dataset. See Import Data for details on Data Import functionality.
  2. Click the Online tab-> Service group-> Parse Address button and on the Parse Address dialog, set the following parameter information:
    • Datasource: Select the Datasource where the Parse AddressDataset is located.
    • Dataset: Select the Tabular Dataset to be parsed. Currently, only Tabular Dataset is supported.
    • City field: Select the field where the city information is located. For example, select the city field here. It is used to avoid the incorrect position phenomenon that a place name appears in different cities but no city information appears in the detailed address field.
    • Address field: Select the field that stores detailed address information in Tabular Dataset. For example, select the address field here.
    • X, Y Fields: The X and Y fields store the parsed X and Y coordinate values. By default, the X and Y fields are created. You can also select an existing field. New X and Y fields are created here by default.
    • Generate Points: Check this box to generate Points set based on X and Y coordinates. Click here to check.
    • Only parse empty coordinates: This check box is for the parsed data and there is an empty coordinate value in the parsing result. It is required to check only when the empty coordinate record is parsed again. If Parse Address is executed for the first time, this item is not required to be checked.
  3. After setting the above parameters, click the OK button to execute the Parse Address operation. After the execution completed, two Property Fields, X and Y, are automatically generated in the property table, recording the detailed coordinate values of the parsed address respectively, as shown in the following figure.
  4. Overlay the generated Point Dataset in the Online Map to view the spatial location of each apartment source on the map. As shown below: