Display Name: Comparable Properties Locator Model

Description: The Comparable Property Locator application was developed to automate the process of locating comparable properties based on both real estate characteristic similarities, and distance to a user supplied reference property. The resulting selection set is a grouping of the most similar properties that are also the most proximal to the reference property. To locate comparable properties this application utilizes a geospatial algorithm that can be divided into three functional stages: a criteria matching stage, a distance analysis stage, and a data selection stage. Criteria Matching- A standardization is applied to all of the attributes of interest by performing a z-transformation, where each value is subtracted from the mean for all of the values, and then is similarly divided by the standard deviation for all values. This standardization ensures all of the attributes are placed on the same scale even when they are represented by very different types of numbers. Next, for each candidate the algorithm subtracts the standardized values from those of the reference object, squares the differences, and adds the squared differences together, so that the sum becomes the basis for the similarity index for that candidate. The resulting similarity index is then used to rank each candidate from the smallest index (most similar) to largest index (least similar), using a returned results threshold parameter (25) to parse out the 25 candidates exhibiting the smallest similarity indexes. Distance Analysis- In this stage point distance analysis is performed in order to record the distances from the centroids of each of the 25 comparable property candidates returned in the previous stage to the centroid of the reference property. Data Selection- The last stage pares down the selection set of comparable properties by creating a grouping that exhibit qualities of both similarity and proximity to the reference property. This final grouping is achieved in two steps: firstly, by determining the median distance value from all of the distance values returned in the previous distance analysis stage, and secondly, by selecting only those comparable properties that have a distance value less than the median.

Category:

Help URL: https://maps.grundyco.org/arcgis/rest/directories/arcgisoutput/GeoProcessingServices/CompsLocatorModel_Fabric_GPServer/GeoProcessingServices_CompsLocatorModel_Fabric/Model2.htm

Execution Type: esriExecutionTypeAsynchronous

Parameters:

Parameter: Reference_PIN

Data Type: GPString
Display Name Reference PIN
Description: The reference parcel ID number that is used for locating comparable properties to it.
Direction: esriGPParameterDirectionInput
Filter:
Dependency:
Default Value: 05-05-276-032
Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: Search_Area__2_

Data Type: GPFeatureRecordSetLayer
Display Name Search Area
Description: Optional parameter that allows users to draw a search extent to locate comparable properties within that extent. Note: By drawing a search extent only properties within that search extent will be considered when locating suitable comparable properties.
Direction: esriGPParameterDirectionInput
Filter:
Dependency:
Default Value:
Geometry Type: esriGeometryPolygon
HasZ: false
HasM: false
Spatial Reference: 102671  (3435)

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SHAPE_Length ( type: esriFieldTypeDouble, alias: SHAPE_Length )
• SHAPE_Area ( type: esriFieldTypeDouble, alias: SHAPE_Area )
Features: None.



Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: Criteria

Data Type: GPMultiValue:GPString
Display Name Criteria
Description: A required parameter that contains a list of building characteristics to be used as the basis of comparison for locating comparable properties.
Direction: esriGPParameterDirectionInput
Filter:
Dependency:
Default Value: [ CurrentTotalAssessedValue, YearBuilt, TotalBuilding_sqft, Garage_sqft ]
Parameter Type: esriGPParameterTypeRequired
Category:
Choice List: [ CurrentTotalAssessedValue, YearBuilt, TotalBuilding_sqft, Garage_sqft ]

Parameter: Reference_Parcel

Data Type: GPFeatureRecordSetLayer
Display Name Reference Parcel
Description: The reference parcel output feature.
Direction: esriGPParameterDirectionOutput
Filter:
Dependency:
Default Value:
Geometry Type: esriGeometryPoint
HasZ: true
HasM: false
Spatial Reference: 102671  (3435)

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PIN ( type: esriFieldTypeString, alias: PIN, length: 255 )
• CurrentTotalAssessedValue ( type: esriFieldTypeSingle, alias: CurrentTotalAssessedValue )
• YearBuilt ( type: esriFieldTypeSmallInteger, alias: YearBuilt )
• TotalBuilding_sqft ( type: esriFieldTypeInteger, alias: TotalBuilding_sqft )
• Garage_sqft ( type: esriFieldTypeInteger, alias: Garage_sqft )
• SIMRANK ( type: esriFieldTypeInteger, alias: Similarity Rank )
Features: None.



Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: Match_Parcels

Data Type: GPFeatureRecordSetLayer
Display Name Match Parcels
Description: The matching parcels output features.
Direction: esriGPParameterDirectionOutput
Filter:
Dependency:
Default Value:
Geometry Type: esriGeometryPoint
HasZ: true
HasM: false
Spatial Reference: 102671  (3435)

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• MatchingParcels_Points_PIN ( type: esriFieldTypeString, alias: PIN, length: 255 )
• MatchingParcels_Points_CurrentTotalAssessedValue ( type: esriFieldTypeSingle, alias: CurrentTotalAssessedValue )
• MatchingParcels_Points_YearBuilt ( type: esriFieldTypeSmallInteger, alias: YearBuilt )
• MatchingParcels_Points_TotalBuilding_sqft ( type: esriFieldTypeInteger, alias: TotalBuilding_sqft )
• MatchingParcels_Points_Garage_sqft ( type: esriFieldTypeInteger, alias: Garage_sqft )
• MatchingParcels_Points_SIMRANK ( type: esriFieldTypeInteger, alias: Similarity Rank )
• MatchingParcelDistances_Tbl_DISTANCE ( type: esriFieldTypeDouble, alias: DISTANCE )
Features: None.



Parameter Type: esriGPParameterTypeRequired
Category:

Supported Operations:   Submit Job

Child Resources:   Metadata