{
 "name": "SelectTool",
 "displayName": "Select Tool",
 "description": "Select Tool",
 "category": "",
 "helpUrl": "https://devgisweb.halff.com/agsdev/rest/directories/arcgisoutput/BIS/SelectTool_GPServer/BIS_SelectTool/SelectTool.htm",
 "executionType": "esriExecutionTypeAsynchronous",
 "parameters": [
  {
   "name": "sql_query",
   "dataType": "GPString",
   "displayName": "Enter a Property ID",
   "description": "Enter a property id to query against Parcel and Sales data.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "102336",
   "parameterType": "esriGPParameterTypeRequired",
   "category": ""
  },
  {
   "name": "sales_point",
   "dataType": "GPFeatureRecordSetLayer",
   "displayName": "Sales Point",
   "description": "",
   "direction": "esriGPParameterDirectionOutput",
   "defaultValue": {
    "displayFieldName": "",
    "geometryType": "esriGeometryPoint",
    "spatialReference": {
     "wkid": 102100,
     "latestWkid": 3857
    },
    "fields": [
     {
      "name": "OBJECTID_12",
      "type": "esriFieldTypeOID",
      "alias": "OBJECTID_12"
     },
     {
      "name": "prop_id_text",
      "type": "esriFieldTypeString",
      "alias": "prop_id_text",
      "length": 25
     },
     {
      "name": "prop_id",
      "type": "esriFieldTypeInteger",
      "alias": "prop_id"
     },
     {
      "name": "owner_tax_yr",
      "type": "esriFieldTypeSmallInteger",
      "alias": "owner_tax_yr"
     },
     {
      "name": "file_as_name",
      "type": "esriFieldTypeString",
      "alias": "file_as_name",
      "length": 70
     },
     {
      "name": "legal_acreage",
      "type": "esriFieldTypeDouble",
      "alias": "legal_acreage"
     },
     {
      "name": "hood_cd",
      "type": "esriFieldTypeString",
      "alias": "hood_cd",
      "length": 10
     },
     {
      "name": "school",
      "type": "esriFieldTypeString",
      "alias": "school",
      "length": 10
     },
     {
      "name": "city",
      "type": "esriFieldTypeString",
      "alias": "city",
      "length": 25
     },
     {
      "name": "county",
      "type": "esriFieldTypeString",
      "alias": "county",
      "length": 10
     },
     {
      "name": "next_appraisal_dt",
      "type": "esriFieldTypeDate",
      "alias": "next_appraisal_dt",
      "length": 8
     },
     {
      "name": "legal_desc",
      "type": "esriFieldTypeString",
      "alias": "legal_desc",
      "length": 255
     },
     {
      "name": "legal_desc2",
      "type": "esriFieldTypeString",
      "alias": "legal_desc2",
      "length": 255
     },
     {
      "name": "legal_desc3",
      "type": "esriFieldTypeString",
      "alias": "legal_desc3",
      "length": 255
     },
     {
      "name": "tract_or_lot",
      "type": "esriFieldTypeString",
      "alias": "tract_or_lot",
      "length": 50
     },
     {
      "name": "abs_subdv_cd",
      "type": "esriFieldTypeString",
      "alias": "abs_subdv_cd",
      "length": 20
     },
     {
      "name": "land_val",
      "type": "esriFieldTypeDouble",
      "alias": "land_val"
     },
     {
      "name": "imprv_val",
      "type": "esriFieldTypeDouble",
      "alias": "imprv_val"
     },
     {
      "name": "market",
      "type": "esriFieldTypeDouble",
      "alias": "market"
     },
     {
      "name": "block",
      "type": "esriFieldTypeString",
      "alias": "block",
      "length": 50
     },
     {
      "name": "map_id",
      "type": "esriFieldTypeString",
      "alias": "map_id",
      "length": 20
     },
     {
      "name": "geo_id",
      "type": "esriFieldTypeString",
      "alias": "geo_id",
      "length": 50
     },
     {
      "name": "situs_num",
      "type": "esriFieldTypeString",
      "alias": "situs_num",
      "length": 15
     },
     {
      "name": "situs_street_prefx",
      "type": "esriFieldTypeString",
      "alias": "situs_street_prefx",
      "length": 25
     },
     {
      "name": "situs_street",
      "type": "esriFieldTypeString",
      "alias": "situs_street",
      "length": 50
     },
     {
      "name": "situs_street_sufix",
      "type": "esriFieldTypeString",
      "alias": "situs_street_sufix",
      "length": 25
     },
     {
      "name": "situs_city",
      "type": "esriFieldTypeString",
      "alias": "situs_city",
      "length": 30
     },
     {
      "name": "situs_state",
      "type": "esriFieldTypeString",
      "alias": "situs_state",
      "length": 15
     },
     {
      "name": "situs_zip",
      "type": "esriFieldTypeString",
      "alias": "situs_zip",
      "length": 10
     },
     {
      "name": "addr_line1",
      "type": "esriFieldTypeString",
      "alias": "addr_line1",
      "length": 60
     },
     {
      "name": "addr_line2",
      "type": "esriFieldTypeString",
      "alias": "addr_line2",
      "length": 60
     },
     {
      "name": "addr_line3",
      "type": "esriFieldTypeString",
      "alias": "addr_line3",
      "length": 60
     },
     {
      "name": "addr_city",
      "type": "esriFieldTypeString",
      "alias": "addr_city",
      "length": 50
     },
     {
      "name": "addr_state",
      "type": "esriFieldTypeString",
      "alias": "addr_state",
      "length": 50
     },
     {
      "name": "zip",
      "type": "esriFieldTypeString",
      "alias": "zip",
      "length": 15
     },
     {
      "name": "Deed_Seq",
      "type": "esriFieldTypeInteger",
      "alias": "Deed_Seq"
     },
     {
      "name": "Deed_Date",
      "type": "esriFieldTypeString",
      "alias": "Deed_Date",
      "length": 20
     },
     {
      "name": "Volume",
      "type": "esriFieldTypeString",
      "alias": "Volume",
      "length": 20
     },
     {
      "name": "Page",
      "type": "esriFieldTypeString",
      "alias": "Page",
      "length": 20
     },
     {
      "name": "Number",
      "type": "esriFieldTypeString",
      "alias": "Number",
      "length": 50
     },
     {
      "name": "ObjectID_1",
      "type": "esriFieldTypeDouble",
      "alias": "ObjectID_1"
     },
     {
      "name": "OBJECTID",
      "type": "esriFieldTypeInteger",
      "alias": "OBJECTID"
     },
     {
      "name": "nbhd",
      "type": "esriFieldTypeString",
      "alias": "nbhd",
      "length": 1073741822
     },
     {
      "name": "prop_id_1",
      "type": "esriFieldTypeInteger",
      "alias": "prop_id"
     },
     {
      "name": "SqFtCurr",
      "type": "esriFieldTypeInteger",
      "alias": "SqFtCurr"
     },
     {
      "name": "SqFtPrev",
      "type": "esriFieldTypeInteger",
      "alias": "SqFtPrev"
     },
     {
      "name": "TotalMktCur",
      "type": "esriFieldTypeDouble",
      "alias": "TotalMktCur"
     },
     {
      "name": "TotalMktPrev",
      "type": "esriFieldTypeDouble",
      "alias": "TotalMktPrev"
     },
     {
      "name": "SaleDt",
      "type": "esriFieldTypeDate",
      "alias": "SaleDt",
      "length": 8
     },
     {
      "name": "SalePrice",
      "type": "esriFieldTypeDouble",
      "alias": "SalePrice"
     },
     {
      "name": "SaleType",
      "type": "esriFieldTypeString",
      "alias": "SaleType",
      "length": 1073741822
     },
     {
      "name": "ORIG_FID",
      "type": "esriFieldTypeInteger",
      "alias": "ORIG_FID"
     }
    ],
    "features": [],
    "exceededTransferLimit": false
   },
   "parameterType": "esriGPParameterTypeDerived",
   "category": ""
  },
  {
   "name": "show_sales",
   "dataType": "GPFeatureRecordSetLayer",
   "displayName": "Show Sales",
   "description": "",
   "direction": "esriGPParameterDirectionOutput",
   "defaultValue": {
    "displayFieldName": "",
    "geometryType": "esriGeometryPolygon",
    "spatialReference": {
     "wkid": 102100,
     "latestWkid": 3857
    },
    "fields": [
     {
      "name": "OBJECTID",
      "type": "esriFieldTypeOID",
      "alias": "OBJECTID"
     },
     {
      "name": "GEO_ID",
      "type": "esriFieldTypeString",
      "alias": "GEO_ID",
      "length": 50
     },
     {
      "name": "PROP_ID",
      "type": "esriFieldTypeInteger",
      "alias": "PROP_ID"
     },
     {
      "name": "nbhd",
      "type": "esriFieldTypeString",
      "alias": "nbhd",
      "length": 1073741822
     },
     {
      "name": "prop_id_1",
      "type": "esriFieldTypeInteger",
      "alias": "prop_id"
     },
     {
      "name": "SqFtCurr",
      "type": "esriFieldTypeInteger",
      "alias": "SqFtCurr"
     },
     {
      "name": "SqFtPrev",
      "type": "esriFieldTypeInteger",
      "alias": "SqFtPrev"
     },
     {
      "name": "TotalMktCur",
      "type": "esriFieldTypeInteger",
      "alias": "TotalMktCur"
     },
     {
      "name": "TotalMktPrev",
      "type": "esriFieldTypeInteger",
      "alias": "TotalMktPrev"
     },
     {
      "name": "SalePrice",
      "type": "esriFieldTypeInteger",
      "alias": "SalePrice"
     },
     {
      "name": "SaleType",
      "type": "esriFieldTypeString",
      "alias": "SaleType",
      "length": 1073741822
     },
     {
      "name": "nbhd_1",
      "type": "esriFieldTypeString",
      "alias": "nbhd",
      "length": 1073741822
     },
     {
      "name": "RelGlobalID",
      "type": "esriFieldTypeString",
      "alias": "RelGlobalID",
      "length": 255
     },
     {
      "name": "SaleDT",
      "type": "esriFieldTypeDate",
      "alias": "Sale Date",
      "length": 8
     },
     {
      "name": "Shape_Length",
      "type": "esriFieldTypeDouble",
      "alias": "Shape_Length"
     },
     {
      "name": "Shape_Area",
      "type": "esriFieldTypeDouble",
      "alias": "Shape_Area"
     }
    ],
    "features": [],
    "exceededTransferLimit": false
   },
   "parameterType": "esriGPParameterTypeDerived",
   "category": ""
  },
  {
   "name": "subject_property",
   "dataType": "GPFeatureRecordSetLayer",
   "displayName": "Subject Property",
   "description": "",
   "direction": "esriGPParameterDirectionOutput",
   "defaultValue": {
    "displayFieldName": "",
    "geometryType": "esriGeometryPolygon",
    "spatialReference": {
     "wkid": 102100,
     "latestWkid": 3857
    },
    "fields": [
     {
      "name": "OBJECTID",
      "type": "esriFieldTypeOID",
      "alias": "OBJECTID"
     },
     {
      "name": "GEO_ID",
      "type": "esriFieldTypeString",
      "alias": "GEO_ID",
      "length": 50
     },
     {
      "name": "PROP_ID",
      "type": "esriFieldTypeInteger",
      "alias": "PROP_ID"
     },
     {
      "name": "SUBDIVISIO",
      "type": "esriFieldTypeString",
      "alias": "SUBDIVISIO",
      "length": 10
     },
     {
      "name": "ADDITIONAL",
      "type": "esriFieldTypeString",
      "alias": "ADDITIONAL",
      "length": 50
     },
     {
      "name": "SECONDARY_",
      "type": "esriFieldTypeString",
      "alias": "SECONDARY_",
      "length": 5
     },
     {
      "name": "ACRES",
      "type": "esriFieldTypeDouble",
      "alias": "ACRES"
     },
     {
      "name": "USER_ID",
      "type": "esriFieldTypeString",
      "alias": "USER_ID",
      "length": 50
     },
     {
      "name": "DATE_",
      "type": "esriFieldTypeDate",
      "alias": "DATE_",
      "length": 8
     },
     {
      "name": "SHAPE_STAr",
      "type": "esriFieldTypeDouble",
      "alias": "SHAPE_STAr"
     },
     {
      "name": "SHAPE_STLe",
      "type": "esriFieldTypeDouble",
      "alias": "SHAPE_STLe"
     },
     {
      "name": "OBJECTID_1",
      "type": "esriFieldTypeInteger",
      "alias": "OBJECTID_1"
     },
     {
      "name": "nbhd",
      "type": "esriFieldTypeString",
      "alias": "nbhd",
      "length": 1073741822
     },
     {
      "name": "NBHD_Description",
      "type": "esriFieldTypeString",
      "alias": "NBHD Description",
      "length": 1073741822
     },
     {
      "name": "prop_id_1",
      "type": "esriFieldTypeInteger",
      "alias": "prop_id"
     },
     {
      "name": "situs_display",
      "type": "esriFieldTypeString",
      "alias": "situs_display",
      "length": 1073741822
     },
     {
      "name": "LandVal",
      "type": "esriFieldTypeInteger",
      "alias": "LandVal"
     },
     {
      "name": "Total_IMP_Value",
      "type": "esriFieldTypeInteger",
      "alias": "Total IMP Value"
     },
     {
      "name": "TotalMktCur",
      "type": "esriFieldTypeInteger",
      "alias": "TotalMktCur"
     },
     {
      "name": "SqFtCurr",
      "type": "esriFieldTypeInteger",
      "alias": "SqFtCurr"
     },
     {
      "name": "created_user",
      "type": "esriFieldTypeString",
      "alias": "created_user",
      "length": 255
     },
     {
      "name": "created_date",
      "type": "esriFieldTypeDate",
      "alias": "created_date",
      "length": 8
     },
     {
      "name": "last_edited_user",
      "type": "esriFieldTypeString",
      "alias": "last_edited_user",
      "length": 255
     },
     {
      "name": "last_edited_date",
      "type": "esriFieldTypeDate",
      "alias": "last_edited_date",
      "length": 8
     },
     {
      "name": "Shape_Length",
      "type": "esriFieldTypeDouble",
      "alias": "Shape_Length"
     },
     {
      "name": "Shape_Area",
      "type": "esriFieldTypeDouble",
      "alias": "Shape_Area"
     }
    ],
    "features": [],
    "exceededTransferLimit": false
   },
   "parameterType": "esriGPParameterTypeDerived",
   "category": ""
  },
  {
   "name": "nbhd_properties",
   "dataType": "GPFeatureRecordSetLayer",
   "displayName": "Neighborhood Properties",
   "description": "",
   "direction": "esriGPParameterDirectionOutput",
   "defaultValue": {
    "displayFieldName": "",
    "geometryType": "esriGeometryPolygon",
    "spatialReference": {
     "wkid": 102100,
     "latestWkid": 3857
    },
    "fields": [
     {
      "name": "OBJECTID",
      "type": "esriFieldTypeOID",
      "alias": "OBJECTID"
     },
     {
      "name": "GEO_ID",
      "type": "esriFieldTypeString",
      "alias": "GEO_ID",
      "length": 50
     },
     {
      "name": "PROP_ID",
      "type": "esriFieldTypeInteger",
      "alias": "PROP_ID"
     },
     {
      "name": "SUBDIVISIO",
      "type": "esriFieldTypeString",
      "alias": "SUBDIVISIO",
      "length": 10
     },
     {
      "name": "ADDITIONAL",
      "type": "esriFieldTypeString",
      "alias": "ADDITIONAL",
      "length": 50
     },
     {
      "name": "SECONDARY_",
      "type": "esriFieldTypeString",
      "alias": "SECONDARY_",
      "length": 5
     },
     {
      "name": "ACRES",
      "type": "esriFieldTypeDouble",
      "alias": "ACRES"
     },
     {
      "name": "USER_ID",
      "type": "esriFieldTypeString",
      "alias": "USER_ID",
      "length": 50
     },
     {
      "name": "DATE_",
      "type": "esriFieldTypeDate",
      "alias": "DATE_",
      "length": 8
     },
     {
      "name": "SHAPE_STAr",
      "type": "esriFieldTypeDouble",
      "alias": "SHAPE_STAr"
     },
     {
      "name": "SHAPE_STLe",
      "type": "esriFieldTypeDouble",
      "alias": "SHAPE_STLe"
     },
     {
      "name": "OBJECTID_1",
      "type": "esriFieldTypeInteger",
      "alias": "OBJECTID_1"
     },
     {
      "name": "nbhd",
      "type": "esriFieldTypeString",
      "alias": "nbhd",
      "length": 1073741822
     },
     {
      "name": "NBHD_Description",
      "type": "esriFieldTypeString",
      "alias": "NBHD Description",
      "length": 1073741822
     },
     {
      "name": "prop_id_1",
      "type": "esriFieldTypeInteger",
      "alias": "prop_id"
     },
     {
      "name": "situs_display",
      "type": "esriFieldTypeString",
      "alias": "situs_display",
      "length": 1073741822
     },
     {
      "name": "LandVal",
      "type": "esriFieldTypeInteger",
      "alias": "LandVal"
     },
     {
      "name": "Total_IMP_Value",
      "type": "esriFieldTypeInteger",
      "alias": "Total IMP Value"
     },
     {
      "name": "TotalMktCur",
      "type": "esriFieldTypeInteger",
      "alias": "TotalMktCur"
     },
     {
      "name": "SqFtCurr",
      "type": "esriFieldTypeInteger",
      "alias": "SqFtCurr"
     },
     {
      "name": "created_user",
      "type": "esriFieldTypeString",
      "alias": "created_user",
      "length": 255
     },
     {
      "name": "created_date",
      "type": "esriFieldTypeDate",
      "alias": "created_date",
      "length": 8
     },
     {
      "name": "last_edited_user",
      "type": "esriFieldTypeString",
      "alias": "last_edited_user",
      "length": 255
     },
     {
      "name": "last_edited_date",
      "type": "esriFieldTypeDate",
      "alias": "last_edited_date",
      "length": 8
     },
     {
      "name": "Shape_Length",
      "type": "esriFieldTypeDouble",
      "alias": "Shape_Length"
     },
     {
      "name": "Shape_Area",
      "type": "esriFieldTypeDouble",
      "alias": "Shape_Area"
     }
    ],
    "features": [],
    "exceededTransferLimit": false
   },
   "parameterType": "esriGPParameterTypeDerived",
   "category": ""
  }
 ]
}