GeoEnrichment Lookup - Latest

Property Historical Sales Getting Started Guide
Product type
Data
Portfolio
Enrich
Product family
Enrich Addresses > Property Features
Product
Property Historical Sales
Version
Latest
ft:locale
en-US
Product name
Property Historical Sales
ft:title
Property Historical Sales Getting Started Guide
Copyright
2023
First publish date
2020
ft:lastEdition
2023-07-31
ft:lastPublication
2023-07-31T10:42:31.621000

The Management Console is used to set global default values for the GeoEnrichmentLookup stage.

  1. Click Services > Other Services > GeoEnrichmentLookup.
  2. In the Options tab, set the options for the specific instance of the GeoEnrichmentLookup stage by populating the fields as shown:
    • Database: The database resource to use for key lookup. This field is mandatory.
    • Database Name: The specific database file in the database resource to use for key lookup. This field is mandatory.
    • Single Result: False value will help you to view the multiple records associated with a single unique ID. This is important when using Property Attribute data with GEM is using the PreciselyID, the unique and persistent address ID, as the lookup key. It is possible to have more than one property attribute record associated to an address.
  3. Click Save.
  4. Under the Preview tab you can preview the results of the GeoEnrichmentLookup stage.
  5. Enter the lookup key that is present in the input record entered.
    • You can also click the Add button under Input Records to add additional records manually.
    • If you are importing data, click the Import button under Input Records. The Import Data popup appears.
    • To delete all records, click the Delete button at the top of the preview area.
  6. Click Run Preview. The service processes the input records and displays the results in the Output Records column that appears.
  7. Review your output data, making sure the results are what you intended to get from the module. If necessary you can make changes to the module's settings and click Run Preview again. You do not need to input the data again.

Limitations of using GEM Module with Property Attributes Data

  • Only 500 records are returned when using the Single Result = FALSE option.
  • Most users append property attributes to an address via the PreciselyID. As stated in step 2 above, it is possible for more than one property record to be assigned to a single address. For this reason, the user may choose to query the data directly from a database. For example, in the Spectrum Designer Flow below, the Property Attributes data is being queried for the attributes of Year Built, square footage, and assessed for PreciselyID PXXXXXXX.Output