{ "name": "Model2", "displayName": "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. \n\n \n\nTo 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.\n\n \n\nCriteria 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. \n\n\nDistance 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. \n\n\nData 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": "", "helpUrl": "https://maps.grundyco.org/arcgis/rest/directories/arcgisoutput/GeoProcessingServices/CompsLocatorModel_Fabric_GPServer/GeoProcessingServices_CompsLocatorModel_Fabric/Model2.htm", "executionType": "esriExecutionTypeAsynchronous", "parameters": [ { "name": "Reference_PIN", "dataType": "GPString", "displayName": "Reference PIN", "description": "The reference parcel ID number that is used for locating comparable properties to it.", "direction": "esriGPParameterDirectionInput", "defaultValue": "05-05-276-032", "parameterType": "esriGPParameterTypeRequired", "category": "" }, { "name": "Search_Area__2_", "dataType": "GPFeatureRecordSetLayer", "displayName": "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", "defaultValue": { "displayFieldName": "", "geometryType": "esriGeometryPolygon", "spatialReference": { "wkid": 102671, "latestWkid": 3435 }, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "SHAPE_Length", "type": "esriFieldTypeDouble", "alias": "SHAPE_Length" }, { "name": "SHAPE_Area", "type": "esriFieldTypeDouble", "alias": "SHAPE_Area" } ], "features": [], "exceededTransferLimit": false }, "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "Criteria", "dataType": "GPMultiValue:GPString", "displayName": "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", "defaultValue": [ "CurrentTotalAssessedValue", "YearBuilt", "TotalBuilding_sqft", "Garage_sqft" ], "parameterType": "esriGPParameterTypeRequired", "category": "", "choiceList": [ "CurrentTotalAssessedValue", "YearBuilt", "TotalBuilding_sqft", "Garage_sqft" ] }, { "name": "Reference_Parcel", "dataType": "GPFeatureRecordSetLayer", "displayName": "Reference Parcel", "description": "The reference parcel output feature.", "direction": "esriGPParameterDirectionOutput", "defaultValue": { "displayFieldName": "", "hasZ": true, "geometryType": "esriGeometryPoint", "spatialReference": { "wkid": 102671, "latestWkid": 3435 }, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "PIN", "type": "esriFieldTypeString", "alias": "PIN", "length": 255 }, { "name": "CurrentTotalAssessedValue", "type": "esriFieldTypeSingle", "alias": "CurrentTotalAssessedValue" }, { "name": "YearBuilt", "type": "esriFieldTypeSmallInteger", "alias": "YearBuilt" }, { "name": "TotalBuilding_sqft", "type": "esriFieldTypeInteger", "alias": "TotalBuilding_sqft" }, { "name": "Garage_sqft", "type": "esriFieldTypeInteger", "alias": "Garage_sqft" }, { "name": "SIMRANK", "type": "esriFieldTypeInteger", "alias": "Similarity Rank" } ], "features": [], "exceededTransferLimit": false }, "parameterType": "esriGPParameterTypeRequired", "category": "" }, { "name": "Match_Parcels", "dataType": "GPFeatureRecordSetLayer", "displayName": "Match Parcels", "description": "The matching parcels output features.", "direction": "esriGPParameterDirectionOutput", "defaultValue": { "displayFieldName": "", "hasZ": true, "geometryType": "esriGeometryPoint", "spatialReference": { "wkid": 102671, "latestWkid": 3435 }, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "MatchingParcels_Points_PIN", "type": "esriFieldTypeString", "alias": "PIN", "length": 255 }, { "name": "MatchingParcels_Points_CurrentTotalAssessedValue", "type": "esriFieldTypeSingle", "alias": "CurrentTotalAssessedValue" }, { "name": "MatchingParcels_Points_YearBuilt", "type": "esriFieldTypeSmallInteger", "alias": "YearBuilt" }, { "name": "MatchingParcels_Points_TotalBuilding_sqft", "type": "esriFieldTypeInteger", "alias": "TotalBuilding_sqft" }, { "name": "MatchingParcels_Points_Garage_sqft", "type": "esriFieldTypeInteger", "alias": "Garage_sqft" }, { "name": "MatchingParcels_Points_SIMRANK", "type": "esriFieldTypeInteger", "alias": "Similarity Rank" }, { "name": "MatchingParcelDistances_Tbl_DISTANCE", "type": "esriFieldTypeDouble", "alias": "DISTANCE" } ], "features": [], "exceededTransferLimit": false }, "parameterType": "esriGPParameterTypeRequired", "category": "" } ] }