Name: Sales History

Display Field: OwnrName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 4b0fa436a1434d98b7f1145823e0756d

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PIN ( type: esriFieldTypeString, alias: PIN, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PIN )
• PrintKey ( type: esriFieldTypeString, alias: PrintKey, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PrintKey )
• SwisCode ( type: esriFieldTypeString, alias: SwisCode, editable: true, nullable: true, length: 6, defaultValue: null, modelName: SwisCode )
• OwnrName ( type: esriFieldTypeString, alias: OwnrName, editable: true, nullable: true, length: 40, defaultValue: null, modelName: OwnrName )
• PrclStreet ( type: esriFieldTypeString, alias: PrclStreet, editable: true, nullable: true, length: 35, defaultValue: null, modelName: PrclStreet )
• PrclNumb ( type: esriFieldTypeString, alias: PrclNumb, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PrclNumb )
• PrclMuni ( type: esriFieldTypeString, alias: PrclMuni, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PrclMuni )
• Bldgstyl ( type: esriFieldTypeString, alias: Bldgstyl, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Bldgstyl )
• SFLA ( type: esriFieldTypeInteger, alias: SFLA, editable: true, nullable: true, defaultValue: null, modelName: SFLA )
• Grade ( type: esriFieldTypeString, alias: Grade, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Grade )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Condition )
• YrBuilt ( type: esriFieldTypeInteger, alias: YrBuilt, editable: true, nullable: true, defaultValue: null, modelName: YrBuilt )
• NbhdCode ( type: esriFieldTypeString, alias: NbhdCode, editable: true, nullable: true, length: 5, defaultValue: null, modelName: NbhdCode )
• SchCode ( type: esriFieldTypeString, alias: SchCode, editable: true, nullable: true, length: 6, defaultValue: null, modelName: SchCode )
• PropClsite ( type: esriFieldTypeString, alias: PropClsite, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PropClsite )
• LandAssess ( type: esriFieldTypeDouble, alias: LandAssess, editable: true, nullable: true, defaultValue: null, modelName: LandAssess )
• TotAssess ( type: esriFieldTypeDouble, alias: TotAssess, editable: true, nullable: true, defaultValue: null, modelName: TotAssess )
• SiteNbr ( type: esriFieldTypeInteger, alias: SiteNbr, editable: true, nullable: true, defaultValue: null, modelName: SiteNbr )
• ZoneCode ( type: esriFieldTypeString, alias: ZoneCode, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ZoneCode )
• SaleDate ( type: esriFieldTypeString, alias: SaleDate, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SaleDate )
• SalePrice ( type: esriFieldTypeDouble, alias: SalePrice, editable: true, nullable: true, defaultValue: null, modelName: SalePrice )
• Book ( type: esriFieldTypeString, alias: Book, editable: true, nullable: true, length: 11, defaultValue: null, modelName: Book )
• Page ( type: esriFieldTypeString, alias: Page, editable: true, nullable: true, length: 11, defaultValue: null, modelName: Page )
• Frontage ( type: esriFieldTypeDouble, alias: Frontage, editable: true, nullable: true, defaultValue: null, modelName: Frontage )
• Depth ( type: esriFieldTypeDouble, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: Depth )
• Acres ( type: esriFieldTypeDouble, alias: Acres, editable: true, nullable: true, defaultValue: null, modelName: Acres )
• SqFt ( type: esriFieldTypeInteger, alias: SqFt, editable: true, nullable: true, defaultValue: null, modelName: SqFt )
• SBL ( type: esriFieldTypeString, alias: SBL, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SBL )
• ParcelId ( type: esriFieldTypeInteger, alias: ParcelId, editable: true, nullable: true, defaultValue: null, modelName: ParcelId )
• RecordType ( type: esriFieldTypeString, alias: RecordType, editable: true, nullable: true, length: 1, defaultValue: null, modelName: RecordType )
• ValUseable ( type: esriFieldTypeString, alias: ValUseable, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ValUseable )
• AV_SP ( type: esriFieldTypeDouble, alias: AV\SP, editable: true, nullable: true, defaultValue: null, modelName: AV_SP )
• CODExclude ( type: esriFieldTypeString, alias: CODExclude, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CODExclude )
• AddlFlag ( type: esriFieldTypeString, alias: AddlFlag, editable: true, nullable: true, length: 1, defaultValue: null, modelName: AddlFlag )
• MultiSited ( type: esriFieldTypeString, alias: MultiSited, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MultiSited )
• OwnerID ( type: esriFieldTypeInteger, alias: OwnerID, editable: true, nullable: true, defaultValue: null, modelName: OwnerID )
• TimeAdjSP ( type: esriFieldTypeDouble, alias: TimeAdjSP, editable: true, nullable: true, defaultValue: null, modelName: TimeAdjSP )
• CostTotal ( type: esriFieldTypeDouble, alias: CostTotal, editable: true, nullable: true, defaultValue: null, modelName: CostTotal )
• AEPTotal ( type: esriFieldTypeDouble, alias: AEPTotal, editable: true, nullable: true, defaultValue: null, modelName: AEPTotal )
• MktRegTot ( type: esriFieldTypeDouble, alias: MktRegTot, editable: true, nullable: true, defaultValue: null, modelName: MktRegTot )
• MktSiteTot ( type: esriFieldTypeDouble, alias: MktSiteTot, editable: true, nullable: true, defaultValue: null, modelName: MktSiteTot )
• TotalAVTOS ( type: esriFieldTypeDouble, alias: TotalAVTOS, editable: true, nullable: true, defaultValue: null, modelName: TotalAVTOS )
• LandAVTOS ( type: esriFieldTypeDouble, alias: LandAVTOS, editable: true, nullable: true, defaultValue: null, modelName: LandAVTOS )
• ManModlTot ( type: esriFieldTypeDouble, alias: ManModlTot, editable: true, nullable: true, defaultValue: null, modelName: ManModlTot )
• CompTotEst ( type: esriFieldTypeDouble, alias: CompTotEst, editable: true, nullable: true, defaultValue: null, modelName: CompTotEst )
• CompLndEst ( type: esriFieldTypeDouble, alias: CompLndEst, editable: true, nullable: true, defaultValue: null, modelName: CompLndEst )
• CostRCNLD ( type: esriFieldTypeDouble, alias: CostRCNLD, editable: true, nullable: true, defaultValue: null, modelName: CostRCNLD )
• PriorTotal ( type: esriFieldTypeDouble, alias: PriorTotal, editable: true, nullable: true, defaultValue: null, modelName: PriorTotal )
• PriorLand ( type: esriFieldTypeDouble, alias: PriorLand, editable: true, nullable: true, defaultValue: null, modelName: PriorLand )
• FinalTotal ( type: esriFieldTypeDouble, alias: FinalTotal, editable: true, nullable: true, defaultValue: null, modelName: FinalTotal )
• FinalLand ( type: esriFieldTypeDouble, alias: FinalLand, editable: true, nullable: true, defaultValue: null, modelName: FinalLand )
• DisclosTot ( type: esriFieldTypeDouble, alias: DisclosTot, editable: true, nullable: true, defaultValue: null, modelName: DisclosTot )
• RevalLand ( type: esriFieldTypeDouble, alias: RevalLand, editable: true, nullable: true, defaultValue: null, modelName: RevalLand )
• RevalTotal ( type: esriFieldTypeDouble, alias: RevalTotal, editable: true, nullable: true, defaultValue: null, modelName: RevalTotal )
• FullMktVal ( type: esriFieldTypeDouble, alias: FullMktVal, editable: true, nullable: true, defaultValue: null, modelName: FullMktVal )
• CostLand ( type: esriFieldTypeDouble, alias: CostLand, editable: true, nullable: true, defaultValue: null, modelName: CostLand )
• CostRCN ( type: esriFieldTypeDouble, alias: CostRCN, editable: true, nullable: true, defaultValue: null, modelName: CostRCN )
• CmpAsmtTot ( type: esriFieldTypeInteger, alias: CmpAsmtTot, editable: true, nullable: true, defaultValue: null, modelName: CmpAsmtTot )
• CmpAsmtLnd ( type: esriFieldTypeInteger, alias: CmpAsmtLnd, editable: true, nullable: true, defaultValue: null, modelName: CmpAsmtLnd )
• InvDate ( type: esriFieldTypeString, alias: InvDate, editable: true, nullable: true, length: 25, defaultValue: null, modelName: InvDate )
• SP_SFLA ( type: esriFieldTypeDouble, alias: SP\SFLA, editable: true, nullable: true, defaultValue: null, modelName: SP_SFLA )
• SP_Acre ( type: esriFieldTypeDouble, alias: SP\Acre, editable: true, nullable: true, defaultValue: null, modelName: SP_Acre )
• SP_SQFT ( type: esriFieldTypeDouble, alias: SP\SQFT, editable: true, nullable: true, defaultValue: null, modelName: SP_SQFT )
• TAJSP_SFLA ( type: esriFieldTypeDouble, alias: TAJSP\SFLA, editable: true, nullable: true, defaultValue: null, modelName: TAJSP_SFLA )
• TAJSP_Acre ( type: esriFieldTypeDouble, alias: TAJSP\Acre, editable: true, nullable: true, defaultValue: null, modelName: TAJSP_Acre )
• TAJSP_SQFT ( type: esriFieldTypeDouble, alias: TAJSP\SQFT, editable: true, nullable: true, defaultValue: null, modelName: TAJSP_SQFT )
• AV_TADJSP ( type: esriFieldTypeDouble, alias: AV\TADJSP, editable: true, nullable: true, defaultValue: null, modelName: AV_TADJSP )
• AV_TOS_SP ( type: esriFieldTypeDouble, alias: AV_TOS\SP, editable: true, nullable: true, defaultValue: null, modelName: AV_TOS_SP )
• ExCode1 ( type: esriFieldTypeString, alias: ExCode1, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ExCode1 )
• ExCode2 ( type: esriFieldTypeString, alias: ExCode2, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ExCode2 )
• ExCode3 ( type: esriFieldTypeString, alias: ExCode3, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ExCode3 )
• ExCode4 ( type: esriFieldTypeString, alias: ExCode4, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ExCode4 )
• ExCode5 ( type: esriFieldTypeString, alias: ExCode5, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ExCode5 )
• ExCode6 ( type: esriFieldTypeString, alias: ExCode6, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ExCode6 )
• ExCode7 ( type: esriFieldTypeString, alias: ExCode7, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ExCode7 )
• ExCode8 ( type: esriFieldTypeString, alias: ExCode8, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ExCode8 )
• ExCode9 ( type: esriFieldTypeString, alias: ExCode9, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ExCode9 )
• ExCode10 ( type: esriFieldTypeString, alias: ExCode10, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ExCode10 )
• SpDsCode1 ( type: esriFieldTypeString, alias: SpDsCode1, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpDsCode1 )
• SpDsCode2 ( type: esriFieldTypeString, alias: SpDsCode2, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpDsCode2 )
• SpDsCode3 ( type: esriFieldTypeString, alias: SpDsCode3, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpDsCode3 )
• SpDsCode4 ( type: esriFieldTypeString, alias: SpDsCode4, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpDsCode4 )
• SpDsCode5 ( type: esriFieldTypeString, alias: SpDsCode5, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpDsCode5 )
• SpDsCode6 ( type: esriFieldTypeString, alias: SpDsCode6, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpDsCode6 )
• SpDsCode7 ( type: esriFieldTypeString, alias: SpDsCode7, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpDsCode7 )
• SpDsCode8 ( type: esriFieldTypeString, alias: SpDsCode8, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpDsCode8 )
• SpDsCode9 ( type: esriFieldTypeString, alias: SpDsCode9, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpDsCode9 )
• SpDsCode10 ( type: esriFieldTypeString, alias: SpDsCode10, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpDsCode10 )
• InspDate ( type: esriFieldTypeString, alias: InspDate, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InspDate )
• PriorLndAV ( type: esriFieldTypeDouble, alias: PriorLndAV, editable: true, nullable: true, defaultValue: null, modelName: PriorLndAV )
• PriorTotAV ( type: esriFieldTypeDouble, alias: PriorTotAV, editable: true, nullable: true, defaultValue: null, modelName: PriorTotAV )

Templates:

• Name: Sales History
  Description:
  Prototype:
  PriorLndAV: null
  PriorTotAV: null
  PIN: null
  PrintKey: null
  SwisCode: null
  OwnrName: null
  PrclStreet: null
  PrclNumb: null
  PrclMuni: null
  Bldgstyl: null
  SFLA: null
  Grade: null
  Condition: null
  YrBuilt: null
  NbhdCode: null
  SchCode: null
  PropClsite: null
  LandAssess: null
  TotAssess: null
  SiteNbr: null
  ZoneCode: null
  SaleDate: null
  SalePrice: null
  Book: null
  Page: null
  Frontage: null
  Depth: null
  Acres: null
  SqFt: null
  SBL: null
  ParcelId: null
  RecordType: null
  ValUseable: null
  AV_SP: null
  CODExclude: null
  AddlFlag: null
  MultiSited: null
  OwnerID: null
  TimeAdjSP: null
  CostTotal: null
  AEPTotal: null
  MktRegTot: null
  MktSiteTot: null
  TotalAVTOS: null
  LandAVTOS: null
  ManModlTot: null
  CompTotEst: null
  CompLndEst: null
  CostRCNLD: null
  PriorTotal: null
  PriorLand: null
  FinalTotal: null
  FinalLand: null
  DisclosTot: null
  RevalLand: null
  RevalTotal: null
  FullMktVal: null
  CostLand: null
  CostRCN: null
  CmpAsmtTot: null
  CmpAsmtLnd: null
  InvDate: null
  SP_SFLA: null
  SP_Acre: null
  SP_SQFT: null
  TAJSP_SFLA: null
  TAJSP_Acre: null
  TAJSP_SQFT: null
  AV_TADJSP: null
  AV_TOS_SP: null
  ExCode1: null
  ExCode2: null
  ExCode3: null
  ExCode4: null
  ExCode5: null
  ExCode6: null
  ExCode7: null
  ExCode8: null
  ExCode9: null
  ExCode10: null
  SpDsCode1: null
  SpDsCode2: null
  SpDsCode3: null
  SpDsCode4: null
  SpDsCode5: null
  SpDsCode6: null
  SpDsCode7: null
  SpDsCode8: null
  SpDsCode9: null
  SpDsCode10: null
  InspDate: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SQLSDE.DBO.Parcel (0) -- Related To: Parcels (0)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata