Name: Assessor Table

Display Field: SITUSSTREETNAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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

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 )
• APN ( type: esriFieldTypeString, alias: APN, editable: true, nullable: true, length: 13, defaultValue: null, modelName: APN )
• APN_ACA ( type: esriFieldTypeString, alias: APN_ACA, editable: true, nullable: true, length: 15, defaultValue: null, modelName: APN_ACA )
• APN_GIS ( type: esriFieldTypeString, alias: APN_GIS, editable: true, nullable: true, length: 13, defaultValue: null, modelName: APN_GIS )
• APN_PQ ( type: esriFieldTypeString, alias: APN_PQ, editable: true, nullable: true, length: 16, defaultValue: null, modelName: APN_PQ )
• SITUSADDRESS ( type: esriFieldTypeString, alias: SITUSADDRESS, editable: true, nullable: true, length: 70, defaultValue: null, modelName: SITUSADDRESS )
• SITUSUNITNUMBER ( type: esriFieldTypeString, alias: SITUSUNITNUMBER, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SITUSUNITNUMBER )
• SITUSCITY ( type: esriFieldTypeString, alias: SITUSCITY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SITUSCITY )
• SITUSSTATE ( type: esriFieldTypeString, alias: SITUSSTATE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SITUSSTATE )
• SITUSZIPCODE ( type: esriFieldTypeString, alias: SITUSZIPCODE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SITUSZIPCODE )
• SITUSSTREETNUMBER ( type: esriFieldTypeString, alias: SITUSSTREETNUMBER, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SITUSSTREETNUMBER )
• SITUSSTREETPREFIX ( type: esriFieldTypeString, alias: SITUSSTREETPREFIX, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SITUSSTREETPREFIX )
• SITUSSTREETNAME ( type: esriFieldTypeString, alias: SITUSSTREETNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SITUSSTREETNAME )
• SITUSSTREETEXT ( type: esriFieldTypeString, alias: SITUSSTREETEXT, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SITUSSTREETEXT )
• SITUSZIP4 ( type: esriFieldTypeString, alias: SITUSZIP4, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SITUSZIP4 )
• OWNERFIRSTNAME ( type: esriFieldTypeString, alias: OWNERFIRSTNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNERFIRSTNAME )
• OWNERLASTNAME ( type: esriFieldTypeString, alias: OWNERLASTNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNERLASTNAME )
• OWNERNAME ( type: esriFieldTypeString, alias: OWNERNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNERNAME )
• OWNERNAMECENSORED ( type: esriFieldTypeString, alias: OWNERNAMECENSORED, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNERNAMECENSORED )
• MAILCAREOFNAME ( type: esriFieldTypeString, alias: MAILCAREOFNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAILCAREOFNAME )
• MAILATTENTIONNAME ( type: esriFieldTypeString, alias: MAILATTENTIONNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAILATTENTIONNAME )
• MAILSTREETADDRESS ( type: esriFieldTypeString, alias: MAILSTREETADDRESS, editable: true, nullable: true, length: 75, defaultValue: null, modelName: MAILSTREETADDRESS )
• MAILUNITNUMBER ( type: esriFieldTypeString, alias: MAILUNITNUMBER, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAILUNITNUMBER )
• MAILCITY ( type: esriFieldTypeString, alias: MAILCITY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MAILCITY )
• MAILSTATE ( type: esriFieldTypeString, alias: MAILSTATE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAILSTATE )
• MAILZIPCODE ( type: esriFieldTypeString, alias: MAILZIPCODE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MAILZIPCODE )
• MAILZIPCODE4 ( type: esriFieldTypeString, alias: MAILZIPCODE4, editable: true, nullable: true, length: 4, defaultValue: null, modelName: MAILZIPCODE4 )
• MAILBARCODEWALKSEQUENCE ( type: esriFieldTypeString, alias: MAILBARCODEWALKSEQUENCE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: MAILBARCODEWALKSEQUENCE )
• MAILBARCODECHECKDIGIT ( type: esriFieldTypeString, alias: MAILBARCODECHECKDIGIT, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MAILBARCODECHECKDIGIT )
• MAILEFFECTIVEDATE ( type: esriFieldTypeString, alias: MAILEFFECTIVEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MAILEFFECTIVEDATE )
• MAILSOURCECODE ( type: esriFieldTypeString, alias: MAILSOURCECODE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MAILSOURCECODE )
• PRIMARYTRA ( type: esriFieldTypeSmallInteger, alias: PRIMARYTRA, editable: true, nullable: true, defaultValue: null, modelName: PRIMARYTRA )
• SECONDARYTRA ( type: esriFieldTypeSmallInteger, alias: SECONDARYTRA, editable: true, nullable: true, defaultValue: null, modelName: SECONDARYTRA )
• TAXRATEAREA ( type: esriFieldTypeInteger, alias: TAXRATEAREA, editable: true, nullable: true, defaultValue: null, modelName: TAXRATEAREA )
• LANDVALUE ( type: esriFieldTypeDouble, alias: LANDVALUE, editable: true, nullable: true, defaultValue: null, modelName: LANDVALUE )
• IMPROVEMENTVALUE ( type: esriFieldTypeDouble, alias: IMPROVEMENTVALUE, editable: true, nullable: true, defaultValue: null, modelName: IMPROVEMENTVALUE )
• LANDIMPROVRATIO ( type: esriFieldTypeInteger, alias: LANDIMPROVRATIO, editable: true, nullable: true, defaultValue: null, modelName: LANDIMPROVRATIO )
• CLCALANDVALUE ( type: esriFieldTypeDouble, alias: CLCALANDVALUE, editable: true, nullable: true, defaultValue: null, modelName: CLCALANDVALUE )
• CLCAIMPROVEMENTVALUE ( type: esriFieldTypeDouble, alias: CLCAIMPROVEMENTVALUE, editable: true, nullable: true, defaultValue: null, modelName: CLCAIMPROVEMENTVALUE )
• FIXTURESVALUE ( type: esriFieldTypeDouble, alias: FIXTURESVALUE, editable: true, nullable: true, defaultValue: null, modelName: FIXTURESVALUE )
• PERSONALPROPERTYVALUE ( type: esriFieldTypeDouble, alias: PERSONALPROPERTYVALUE, editable: true, nullable: true, defaultValue: null, modelName: PERSONALPROPERTYVALUE )
• HOUSEHOLDPERSONALPROPERTYVALUE ( type: esriFieldTypeDouble, alias: HOUSEHOLDPERSONALPROPERTYVALUE, editable: true, nullable: true, defaultValue: null, modelName: HOUSEHOLDPERSONALPROPERTYVALUE )
• HOMEOWNERSEXEMPTIONVALUE ( type: esriFieldTypeDouble, alias: HOMEOWNERSEXEMPTIONVALUE, editable: true, nullable: true, defaultValue: null, modelName: HOMEOWNERSEXEMPTIONVALUE )
• OTHEREXEMPTIONVALUE ( type: esriFieldTypeDouble, alias: OTHEREXEMPTIONVALUE, editable: true, nullable: true, defaultValue: null, modelName: OTHEREXEMPTIONVALUE )
• NETTOTALVALUE ( type: esriFieldTypeDouble, alias: NETTOTALVALUE, editable: true, nullable: true, defaultValue: null, modelName: NETTOTALVALUE )
• LASTDOCUMENTPREFIX ( type: esriFieldTypeString, alias: LASTDOCUMENTPREFIX, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LASTDOCUMENTPREFIX )
• LASTDOCUMENTSERIES ( type: esriFieldTypeInteger, alias: LASTDOCUMENTSERIES, editable: true, nullable: true, defaultValue: null, modelName: LASTDOCUMENTSERIES )
• LASTDOCUMENTDATE ( type: esriFieldTypeInteger, alias: LASTDOCUMENTDATE, editable: true, nullable: true, defaultValue: null, modelName: LASTDOCUMENTDATE )
• LASTDOCUMENTINPUTDATE ( type: esriFieldTypeInteger, alias: LASTDOCUMENTINPUTDATE, editable: true, nullable: true, defaultValue: null, modelName: LASTDOCUMENTINPUTDATE )
• USECODE ( type: esriFieldTypeInteger, alias: USECODE, editable: true, nullable: true, defaultValue: null, modelName: USECODE )
• USEDESCRIPTION ( type: esriFieldTypeString, alias: USEDESCRIPTION, editable: true, nullable: true, length: 81, defaultValue: null, modelName: USEDESCRIPTION )
• PROPERTYCHARACTERCHANGEDATE ( type: esriFieldTypeInteger, alias: PROPERTYCHARACTERCHANGEDATE, editable: true, nullable: true, defaultValue: null, modelName: PROPERTYCHARACTERCHANGEDATE )
• NUMBERUNITS ( type: esriFieldTypeInteger, alias: NUMBERUNITS, editable: true, nullable: true, defaultValue: null, modelName: NUMBERUNITS )
• BUILDINGCLASS ( type: esriFieldTypeString, alias: BUILDINGCLASS, editable: true, nullable: true, length: 4, defaultValue: null, modelName: BUILDINGCLASS )
• BUILDINGEFFECTIVEYEAR ( type: esriFieldTypeString, alias: BUILDINGEFFECTIVEYEAR, editable: true, nullable: true, length: 4, defaultValue: null, modelName: BUILDINGEFFECTIVEYEAR )
• BUILDINGAREA ( type: esriFieldTypeDouble, alias: BUILDINGAREA, editable: true, nullable: true, defaultValue: null, modelName: BUILDINGAREA )
• LOTSIZE ( type: esriFieldTypeDouble, alias: LOTSIZE, editable: true, nullable: true, defaultValue: null, modelName: LOTSIZE )
• ACRECODE ( type: esriFieldTypeString, alias: ACRECODE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ACRECODE )
• NUMBEROFBUILDINGS ( type: esriFieldTypeInteger, alias: NUMBEROFBUILDINGS, editable: true, nullable: true, defaultValue: null, modelName: NUMBEROFBUILDINGS )
• NUMBEROFSTORIES ( type: esriFieldTypeSingle, alias: NUMBEROFSTORIES, editable: true, nullable: true, defaultValue: null, modelName: NUMBEROFSTORIES )
• NUMBEROFROOMS ( type: esriFieldTypeSmallInteger, alias: NUMBEROFROOMS, editable: true, nullable: true, defaultValue: null, modelName: NUMBEROFROOMS )
• NUMBEROFBEDROOMS ( type: esriFieldTypeSmallInteger, alias: NUMBEROFBEDROOMS, editable: true, nullable: true, defaultValue: null, modelName: NUMBEROFBEDROOMS )
• NUMBEROFBATH ( type: esriFieldTypeSingle, alias: NUMBEROFBATH, editable: true, nullable: true, defaultValue: null, modelName: NUMBEROFBATH )
• PERCENTOFFICE ( type: esriFieldTypeInteger, alias: PERCENTOFFICE, editable: true, nullable: true, defaultValue: null, modelName: PERCENTOFFICE )
• LANDFLAG ( type: esriFieldTypeString, alias: LANDFLAG, editable: true, nullable: true, length: 1, defaultValue: null, modelName: LANDFLAG )
• CONFORMITYFLAG ( type: esriFieldTypeString, alias: CONFORMITYFLAG, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CONFORMITYFLAG )
• ADDITIONAREA ( type: esriFieldTypeInteger, alias: ADDITIONAREA, editable: true, nullable: true, defaultValue: null, modelName: ADDITIONAREA )
• MISCAREA ( type: esriFieldTypeInteger, alias: MISCAREA, editable: true, nullable: true, defaultValue: null, modelName: MISCAREA )
• RENTABLESPACE ( type: esriFieldTypeInteger, alias: RENTABLESPACE, editable: true, nullable: true, defaultValue: null, modelName: RENTABLESPACE )
• YEARBUILT ( type: esriFieldTypeString, alias: YEARBUILT, editable: true, nullable: true, length: 4, defaultValue: null, modelName: YEARBUILT )
• CONDOTYPE ( type: esriFieldTypeString, alias: CONDOTYPE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CONDOTYPE )
• ELEVATORFLAG ( type: esriFieldTypeString, alias: ELEVATORFLAG, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ELEVATORFLAG )
• SWIMMINGPOOLCODE ( type: esriFieldTypeString, alias: SWIMMINGPOOLCODE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SWIMMINGPOOLCODE )
• SWIMMINGPOOLBUILT ( type: esriFieldTypeString, alias: SWIMMINGPOOLBUILT, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SWIMMINGPOOLBUILT )
• REMODELCODE ( type: esriFieldTypeString, alias: REMODELCODE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: REMODELCODE )
• CONDITIONCODE ( type: esriFieldTypeString, alias: CONDITIONCODE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CONDITIONCODE )
• PARKINGCODE ( type: esriFieldTypeString, alias: PARKINGCODE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: PARKINGCODE )
• PARKINGTYPE ( type: esriFieldTypeString, alias: PARKINGTYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PARKINGTYPE )
• AMENITIESCODE ( type: esriFieldTypeString, alias: AMENITIESCODE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: AMENITIESCODE )
• UNITFLOOR ( type: esriFieldTypeSmallInteger, alias: UNITFLOOR, editable: true, nullable: true, defaultValue: null, modelName: UNITFLOOR )
• WALLHEIGHT ( type: esriFieldTypeSingle, alias: WALLHEIGHT, editable: true, nullable: true, defaultValue: null, modelName: WALLHEIGHT )
• VIEWCODE ( type: esriFieldTypeString, alias: VIEWCODE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: VIEWCODE )
• SLOPECODE ( type: esriFieldTypeString, alias: SLOPECODE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SLOPECODE )
• TOPOGRAPHYCODE ( type: esriFieldTypeString, alias: TOPOGRAPHYCODE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: TOPOGRAPHYCODE )
• HAZARDCODE ( type: esriFieldTypeString, alias: HAZARDCODE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: HAZARDCODE )
• ECONOMICUNITFLAG ( type: esriFieldTypeString, alias: ECONOMICUNITFLAG, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ECONOMICUNITFLAG )
• ENDDATE ( type: esriFieldTypeString, alias: ENDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ENDDATE )
• FileDate ( type: esriFieldTypeInteger, alias: FileDate, editable: true, nullable: false, defaultValue: null, modelName: FileDate )
• UpdateDate ( type: esriFieldTypeDate, alias: UpdateDate, editable: true, nullable: false, length: 8, defaultValue: null, modelName: UpdateDate )

Templates:

• Name: Assessor Table
  Description:
  Prototype:
  FileDate: 0
  UpdateDate: -2209161600000
  APN: null
  APN_ACA: null
  APN_GIS: null
  APN_PQ: null
  SITUSADDRESS: null
  SITUSUNITNUMBER: null
  SITUSCITY: null
  SITUSSTATE: null
  SITUSZIPCODE: null
  SITUSSTREETNUMBER: null
  SITUSSTREETPREFIX: null
  SITUSSTREETNAME: null
  SITUSSTREETEXT: null
  SITUSZIP4: null
  OWNERFIRSTNAME: null
  OWNERLASTNAME: null
  OWNERNAME: null
  OWNERNAMECENSORED: null
  MAILCAREOFNAME: null
  MAILATTENTIONNAME: null
  MAILSTREETADDRESS: null
  MAILUNITNUMBER: null
  MAILCITY: null
  MAILSTATE: null
  MAILZIPCODE: null
  MAILZIPCODE4: null
  MAILBARCODEWALKSEQUENCE: null
  MAILBARCODECHECKDIGIT: null
  MAILEFFECTIVEDATE: null
  MAILSOURCECODE: null
  PRIMARYTRA: null
  SECONDARYTRA: null
  TAXRATEAREA: null
  LANDVALUE: null
  IMPROVEMENTVALUE: null
  LANDIMPROVRATIO: null
  CLCALANDVALUE: null
  CLCAIMPROVEMENTVALUE: null
  FIXTURESVALUE: null
  PERSONALPROPERTYVALUE: null
  HOUSEHOLDPERSONALPROPERTYVALUE: null
  HOMEOWNERSEXEMPTIONVALUE: null
  OTHEREXEMPTIONVALUE: null
  NETTOTALVALUE: null
  LASTDOCUMENTPREFIX: null
  LASTDOCUMENTSERIES: null
  LASTDOCUMENTDATE: null
  LASTDOCUMENTINPUTDATE: null
  USECODE: null
  USEDESCRIPTION: null
  PROPERTYCHARACTERCHANGEDATE: null
  NUMBERUNITS: null
  BUILDINGCLASS: null
  BUILDINGEFFECTIVEYEAR: null
  BUILDINGAREA: null
  LOTSIZE: null
  ACRECODE: null
  NUMBEROFBUILDINGS: null
  NUMBEROFSTORIES: null
  NUMBEROFROOMS: null
  NUMBEROFBEDROOMS: null
  NUMBEROFBATH: null
  PERCENTOFFICE: null
  LANDFLAG: null
  CONFORMITYFLAG: null
  ADDITIONAREA: null
  MISCAREA: null
  RENTABLESPACE: null
  YEARBUILT: null
  CONDOTYPE: null
  ELEVATORFLAG: null
  SWIMMINGPOOLCODE: null
  SWIMMINGPOOLBUILT: null
  REMODELCODE: null
  CONDITIONCODE: null
  PARKINGCODE: null
  PARKINGTYPE: null
  AMENITIESCODE: null
  UNITFLOOR: null
  WALLHEIGHT: null
  VIEWCODE: null
  SLOPECODE: null
  TOPOGRAPHYCODE: null
  HAZARDCODE: null
  ECONOMICUNITFLAG: null
  ENDDATE: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• publication.SDE.HaywardParcels (0) -- Related To: Parcel APN Labels (43)

Capabilities: Query

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

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