Name: MD_PropertySales

Display Field: GISLink

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ID (type: esriFieldTypeDouble, alias: ID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• AssessmentID (type: esriFieldTypeDouble, alias: AssessmentID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• SaleDate (type: esriFieldTypeDate, alias: SaleDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SellerName (type: esriFieldTypeString, alias: SellerName, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• SellerAddress1 (type: esriFieldTypeString, alias: SellerAddress1, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• SellerAddress2 (type: esriFieldTypeString, alias: SellerAddress2, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• SellerZip (type: esriFieldTypeString, alias: SellerZip, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true)
• BuyerName (type: esriFieldTypeString, alias: BuyerName, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• BuyerAddress1 (type: esriFieldTypeString, alias: BuyerAddress1, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• BuyerAddress2 (type: esriFieldTypeString, alias: BuyerAddress2, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• BuyerZip (type: esriFieldTypeString, alias: BuyerZip, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true)
• SaleType (type: esriFieldTypeString, alias: SaleType, SQL Type: sqlTypeOther, length: 40, nullable: false, editable: true)
• ListingDate (type: esriFieldTypeDate, alias: ListingDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ListingPrice (type: esriFieldTypeInteger, alias: ListingPrice, SQL Type: sqlTypeOther, nullable: false, editable: true)
• SalePrice (type: esriFieldTypeInteger, alias: SalePrice, SQL Type: sqlTypeOther, nullable: false, editable: true)
• TimeAdjustedSalePrice (type: esriFieldTypeInteger, alias: TimeAdjustedSalePrice, SQL Type: sqlTypeOther, nullable: false, editable: true)
• DORArmsLengthValidation (type: esriFieldTypeString, alias: DORArmsLengthValidation, SQL Type: sqlTypeOther, length: 40, nullable: false, editable: true)
• DORRatioValidation (type: esriFieldTypeString, alias: DORRatioValidation, SQL Type: sqlTypeOther, length: 40, nullable: false, editable: true)
• RecordedDateTime (type: esriFieldTypeString, alias: RecordedDateTime, SQL Type: sqlTypeOther, length: 14, nullable: false, editable: true)
• BuyerCityState (type: esriFieldTypeString, alias: BuyerCityState, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• SellerCityState (type: esriFieldTypeString, alias: SellerCityState, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• GISLink (type: esriFieldTypeString, alias: GISLink, SQL Type: sqlTypeOther, length: 32, nullable: false, editable: true)
• ESRIUniqueID (type: esriFieldTypeInteger, alias: ESRIUniqueID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• TotalAdjustments (type: esriFieldTypeInteger, alias: TotalAdjustments, SQL Type: sqlTypeOther, nullable: false, editable: true)
• AdjustedSalePrice (type: esriFieldTypeInteger, alias: AdjustedSalePrice, SQL Type: sqlTypeOther, nullable: false, editable: true)
• TotalMarketValue (type: esriFieldTypeInteger, alias: TotalMarketValue, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ModelToSaleRatio (type: esriFieldTypeDouble, alias: ModelToSaleRatio, SQL Type: sqlTypeOther, nullable: false, editable: true)
• TotalAssessedValue (type: esriFieldTypeInteger, alias: TotalAssessedValue, SQL Type: sqlTypeOther, nullable: false, editable: true)
• AssessmentToSaleRatio (type: esriFieldTypeDouble, alias: AssessmentToSaleRatio, SQL Type: sqlTypeOther, nullable: false, editable: true)
• SellerCountry (type: esriFieldTypeString, alias: SellerCountry, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
• BuyerCountry (type: esriFieldTypeString, alias: BuyerCountry, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
• DeedType (type: esriFieldTypeString, alias: DeedType, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• DocumentNo (type: esriFieldTypeString, alias: DocumentNo, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true)
• SaleNote (type: esriFieldTypeString, alias: SaleNote, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: MD_PropertySales
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• DocumentNo:
• ID: 0
• AssessmentID: 0
• SellerName:
• SellerAddress1:
• SellerAddress2:
• SellerZip:
• BuyerName:
• BuyerAddress1:
• BuyerAddress2:
• BuyerZip:
• SaleType:
• ListingPrice: 0
• SalePrice: 0
• TimeAdjustedSalePrice: 0
• DORArmsLengthValidation:
• DORRatioValidation:
• RecordedDateTime:
• BuyerCityState:
• SellerCityState:
• GISLink:
• ESRIUniqueID: 0
• TotalAdjustments: 0
• AdjustedSalePrice: 0
• TotalMarketValue: 0
• ModelToSaleRatio: 0
• TotalAssessedValue: 0
• AssessmentToSaleRatio: 0
• SellerCountry:
• BuyerCountry:
• DeedType:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/14/2026 8:42:59 PM

Schema Last Edit Date: 3/3/2026 5:16:15 PM

Data Last Edit Date: 3/3/2026 5:15:34 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat