Name: AppraisalRecords

Display Field: situsStreetName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: false
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 )
• propYear ( type: esriFieldTypeInteger, alias: Property Appraisal Year, editable: true, nullable: true, defaultValue: null, modelName: propYear )
• propID ( type: esriFieldTypeString, alias: Property ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: propID )
• geoID ( type: esriFieldTypeString, alias: Geographical ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: geoID )
• appraisalKey ( type: esriFieldTypeString, alias: Appraisal Key, editable: true, nullable: true, length: 30, defaultValue: null, modelName: appraisalKey )
• situsFullAdd ( type: esriFieldTypeString, alias: Situs Full Address, editable: true, nullable: true, length: 114, defaultValue: null, modelName: situsFullAdd )
• situsStreetNum ( type: esriFieldTypeString, alias: situsStreetNum, editable: true, nullable: true, length: 15, defaultValue: null, modelName: situsStreetNum )
• situsStreetPrefix ( type: esriFieldTypeString, alias: Situs Street Prefix, editable: true, nullable: true, length: 10, defaultValue: null, modelName: situsStreetPrefix )
• situsStreetName ( type: esriFieldTypeString, alias: Situs Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: situsStreetName )
• situsStreetSuffix ( type: esriFieldTypeString, alias: Situs Street Suffix, editable: true, nullable: true, length: 5, defaultValue: null, modelName: situsStreetSuffix )
• situsUnit ( type: esriFieldTypeString, alias: Situs Unit Number, editable: true, nullable: true, length: 8, defaultValue: null, modelName: situsUnit )
• situsCity ( type: esriFieldTypeString, alias: Situs City, editable: true, nullable: true, length: 30, defaultValue: null, modelName: situsCity )
• situsZip ( type: esriFieldTypeString, alias: Situs ZIP Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: situsZip )
• ownerID ( type: esriFieldTypeString, alias: Owner ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ownerID )
• ownerConfFlag ( type: esriFieldTypeString, alias: Owner Confidential Flag, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ownerConfFlag )
• dbaName ( type: esriFieldTypeString, alias: Business Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: dbaName )
• udiPropFlag ( type: esriFieldTypeString, alias: Undivided Interest Property Flag, editable: true, nullable: true, length: 5, defaultValue: null, modelName: udiPropFlag )
• ownershipPct ( type: esriFieldTypeDouble, alias: Ownership Percentage, editable: true, nullable: true, defaultValue: null, modelName: ownershipPct )
• ownerName ( type: esriFieldTypeString, alias: Owner Name, editable: true, nullable: true, length: 70, defaultValue: null, modelName: ownerName )
• ownerNameAddtl ( type: esriFieldTypeString, alias: Owner Additional Name , editable: true, nullable: true, length: 60, defaultValue: null, modelName: ownerNameAddtl )
• ownerAddrLine1 ( type: esriFieldTypeString, alias: Owner Address Line 1, editable: true, nullable: true, length: 60, defaultValue: null, modelName: ownerAddrLine1 )
• ownerAddrLine2 ( type: esriFieldTypeString, alias: Owner Address Line 2, editable: true, nullable: true, length: 60, defaultValue: null, modelName: ownerAddrLine2 )
• ownerAddrCity ( type: esriFieldTypeString, alias: Owner City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ownerAddrCity )
• ownerAddrState ( type: esriFieldTypeString, alias: Owner State, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ownerAddrState )
• ownerAddrZip ( type: esriFieldTypeString, alias: Owner ZIP Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ownerAddrZip )
• ownerAddrCountry ( type: esriFieldTypeString, alias: Owner Country, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ownerAddrCountry )
• legalDescription ( type: esriFieldTypeString, alias: Legal Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: legalDescription )
• subdvName ( type: esriFieldTypeString, alias: Subdivision Name, editable: true, nullable: true, length: 60, defaultValue: null, modelName: subdvName )
• subdvCode ( type: esriFieldTypeString, alias: Subdivision Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: subdvCode )
• subdvBlock ( type: esriFieldTypeString, alias: Subdivision Block, editable: true, nullable: true, length: 50, defaultValue: null, modelName: subdvBlock )
• subdvLot ( type: esriFieldTypeString, alias: Subdivision Lot, editable: true, nullable: true, length: 50, defaultValue: null, modelName: subdvLot )
• propType ( type: esriFieldTypeString, alias: Property Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: propType )
• propSubType ( type: esriFieldTypeString, alias: Property Sub Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: propSubType )
• propCategoryCode ( type: esriFieldTypeString, alias: Property Category Code, editable: true, nullable: true, length: 5, defaultValue: null, modelName: propCategoryCode )
• propUseCode ( type: esriFieldTypeString, alias: Property Use Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: propUseCode )
• propStatus ( type: esriFieldTypeString, alias: Property Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: propStatus )
• comPropFlag ( type: esriFieldTypeString, alias: Commercial Property Flag, editable: true, nullable: true, length: 5, defaultValue: null, modelName: comPropFlag )
• landSizeAcres ( type: esriFieldTypeDouble, alias: Land Size Acreage, editable: true, nullable: true, defaultValue: null, modelName: landSizeAcres )
• landSizeSqft ( type: esriFieldTypeDouble, alias: Land Size Square Feet, editable: true, nullable: true, defaultValue: null, modelName: landSizeSqft )
• landAgAcres ( type: esriFieldTypeDouble, alias: Land Agricultural Acreage, editable: true, nullable: true, defaultValue: null, modelName: landAgAcres )
• imprvYearBuilt ( type: esriFieldTypeSmallInteger, alias: Improvement Year Built, editable: true, nullable: true, defaultValue: null, modelName: imprvYearBuilt )
• imprvEffYearBuilt ( type: esriFieldTypeSmallInteger, alias: Improvement Effective Year Built, editable: true, nullable: true, defaultValue: null, modelName: imprvEffYearBuilt )
• imprvMainArea ( type: esriFieldTypeDouble, alias: Improvement Main Area, editable: true, nullable: true, defaultValue: null, modelName: imprvMainArea )
• imprvUnits ( type: esriFieldTypeInteger, alias: Improvement Number of Units, editable: true, nullable: true, defaultValue: null, modelName: imprvUnits )
• imprvPoolFlag ( type: esriFieldTypeString, alias: Swimming Pool Flag, editable: true, nullable: true, length: 5, defaultValue: null, modelName: imprvPoolFlag )
• imprvClassCd ( type: esriFieldTypeString, alias: Improvement Class Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: imprvClassCd )
• entityCodes ( type: esriFieldTypeString, alias: All Entity Codes, editable: true, nullable: true, length: 100, defaultValue: null, modelName: entityCodes )
• entitySchoolCode ( type: esriFieldTypeString, alias: School Entity Code, editable: true, nullable: true, length: 5, defaultValue: null, modelName: entitySchoolCode )
• exemptCodes ( type: esriFieldTypeString, alias: Exemption Codes, editable: true, nullable: true, length: 100, defaultValue: null, modelName: exemptCodes )
• exemptHmstdFlag ( type: esriFieldTypeString, alias: Homestead Exemption Flag, editable: true, nullable: true, length: 5, defaultValue: null, modelName: exemptHmstdFlag )
• entityMUD ( type: esriFieldTypeString, alias: MUD Flag, editable: true, nullable: true, length: 5, defaultValue: null, modelName: entityMUD )
• entityTIF ( type: esriFieldTypeString, alias: TIF Flag, editable: true, nullable: true, length: 5, defaultValue: null, modelName: entityTIF )
• countyLineSplit ( type: esriFieldTypeString, alias: Split by County Line, editable: true, nullable: true, length: 5, defaultValue: null, modelName: countyLineSplit )
• taxAgentID ( type: esriFieldTypeString, alias: Tax Agency ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: taxAgentID )
• taxAgentName ( type: esriFieldTypeString, alias: Tax Agency Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: taxAgentName )
• deedTypeCd ( type: esriFieldTypeString, alias: Deed Type Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: deedTypeCd )
• deedNum ( type: esriFieldTypeString, alias: Deed Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: deedNum )
• deedBook ( type: esriFieldTypeString, alias: Deed Book Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: deedBook )
• deedPage ( type: esriFieldTypeString, alias: Deed Page Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: deedPage )
• deedEffDate ( type: esriFieldTypeDate, alias: Deed Effective Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: deedEffDate )
• certValYear ( type: esriFieldTypeSmallInteger, alias: Certified Year, editable: true, nullable: true, defaultValue: null, modelName: certValYear )
• certValImprv ( type: esriFieldTypeDouble, alias: Certified Improvement Value, editable: true, nullable: true, defaultValue: null, modelName: certValImprv )
• certValLand ( type: esriFieldTypeDouble, alias: Certified Land Value, editable: true, nullable: true, defaultValue: null, modelName: certValLand )
• certValMarket ( type: esriFieldTypeDouble, alias: Certified Market Value, editable: true, nullable: true, defaultValue: null, modelName: certValMarket )
• certValAgLoss ( type: esriFieldTypeDouble, alias: Certified Agricultural Loss, editable: true, nullable: true, defaultValue: null, modelName: certValAgLoss )
• certValAppraised ( type: esriFieldTypeDouble, alias: Certified Appraised Value, editable: true, nullable: true, defaultValue: null, modelName: certValAppraised )
• certValHSCapLoss ( type: esriFieldTypeDouble, alias: Certified Homestead Cap Loss, editable: true, nullable: true, defaultValue: null, modelName: certValHSCapLoss )
• certValNHSCapLoss ( type: esriFieldTypeDouble, alias: Certified Non-Homestead Cap Loss, editable: true, nullable: true, defaultValue: null, modelName: certValNHSCapLoss )
• certValAssessed ( type: esriFieldTypeDouble, alias: Certified Assessed Value, editable: true, nullable: true, defaultValue: null, modelName: certValAssessed )
• URL ( type: esriFieldTypeString, alias: Appraisal URL, editable: true, nullable: true, length: 150, defaultValue: null, modelName: URL )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user, required: true )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date, required: true )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user, required: true )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date, required: true )
• GlobalID ( type: esriFieldTypeGlobalID, alias: Global ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• LastQuarterlyUpdate ( type: esriFieldTypeString, alias: Last Quarterly Update, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LastQuarterlyUpdate )

Templates:

• Name: AppraisalRecords
  Description:
  Prototype:
  LastQuarterlyUpdate: null
  URL: null
  propYear: null
  propID: null
  geoID: null
  appraisalKey: null
  situsFullAdd: null
  situsStreetNum: null
  situsStreetPrefix: null
  situsStreetName: null
  situsStreetSuffix: null
  situsUnit: null
  situsCity: null
  situsZip: null
  ownerID: null
  ownerConfFlag: null
  dbaName: null
  udiPropFlag: null
  ownershipPct: null
  ownerName: null
  ownerNameAddtl: null
  ownerAddrLine1: null
  ownerAddrLine2: null
  ownerAddrCity: null
  ownerAddrState: null
  ownerAddrZip: null
  ownerAddrCountry: null
  legalDescription: null
  subdvName: null
  subdvCode: null
  subdvBlock: null
  subdvLot: null
  propType: null
  propSubType: null
  propCategoryCode: null
  propUseCode: null
  propStatus: null
  comPropFlag: null
  landSizeAcres: null
  landSizeSqft: null
  landAgAcres: null
  imprvYearBuilt: null
  imprvEffYearBuilt: null
  imprvMainArea: null
  imprvUnits: null
  imprvPoolFlag: null
  imprvClassCd: null
  entityCodes: null
  entitySchoolCode: null
  exemptCodes: null
  exemptHmstdFlag: null
  entityMUD: null
  entityTIF: null
  countyLineSplit: null
  taxAgentID: null
  taxAgentName: null
  deedTypeCd: null
  deedNum: null
  deedBook: null
  deedPage: null
  deedEffDate: null
  certValYear: null
  certValImprv: null
  certValLand: null
  certValMarket: null
  certValAgLoss: null
  certValAppraised: null
  certValHSCapLoss: null
  certValNHSCapLoss: null
  certValAssessed: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PLANO.Parcels (0) -- Related To: Parcels (0)

Capabilities: Query,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata