Name: Tenant

Display Field: companyname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 801d5c5b7f384f08b70f40e347fde08e

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: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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: false
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:

• tenant_uid ( modelName: tenant_uid, nullable: false, defaultValue: null, editable: false, alias: Tenant_UID, type: esriFieldTypeOID )
• propertyid ( modelName: propertyid, nullable: true, editable: true, defaultValue: null, alias: PropertyID, type: esriFieldTypeInteger )
• propertygroupid ( modelName: propertygroupid, nullable: true, editable: true, defaultValue: null, alias: PropertyGroupID, type: esriFieldTypeInteger )
• tenantcompanyid ( modelName: tenantcompanyid, nullable: false, editable: true, defaultValue: null, alias: tenantCompanyID, type: esriFieldTypeInteger )
• futurepropertyid ( modelName: futurepropertyid, nullable: true, editable: true, defaultValue: null, alias: futurePropertyID, type: esriFieldTypeInteger )
• companyname ( modelName: companyname, nullable: false, editable: true, defaultValue: null, length: 50, alias: companyName, type: esriFieldTypeString )
• buildingname ( modelName: buildingname, nullable: true, editable: true, defaultValue: null, length: 50, alias: buildingName, type: esriFieldTypeString )
• suite ( modelName: suite, nullable: true, editable: true, defaultValue: null, length: 20, alias: Suite, type: esriFieldTypeString )
• address ( modelName: address, nullable: true, editable: true, defaultValue: null, length: 150, alias: address, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 30, alias: city, type: esriFieldTypeString )
• statecode ( modelName: statecode, nullable: true, editable: true, defaultValue: null, length: 3, alias: stateCode, type: esriFieldTypeString )
• zipcode ( modelName: zipcode, nullable: true, editable: true, defaultValue: null, length: 5, alias: zipCode, type: esriFieldTypeString )
• zip4 ( modelName: zip4, nullable: true, editable: true, defaultValue: null, length: 4, alias: zip4, type: esriFieldTypeString )
• companyphone ( modelName: companyphone, nullable: true, editable: true, defaultValue: null, length: 20, alias: CompanyPhone, type: esriFieldTypeString )
• companyfax ( modelName: companyfax, nullable: true, editable: true, defaultValue: null, length: 20, alias: CompanyFax, type: esriFieldTypeString )
• numberofemployees ( modelName: numberofemployees, nullable: false, editable: true, defaultValue: null, alias: NumberOfEmployees, type: esriFieldTypeInteger )
• industrytypedesc ( modelName: industrytypedesc, nullable: true, editable: true, defaultValue: null, length: 50, alias: industryTypeDesc, type: esriFieldTypeString )
• buildinglocation ( modelName: buildinglocation, nullable: true, editable: true, defaultValue: null, length: 50, alias: BuildingLocation, type: esriFieldTypeString )
• submarketname ( modelName: submarketname, nullable: true, editable: true, defaultValue: null, length: 255, alias: SubmarketName, type: esriFieldTypeString )
• webaddress ( modelName: webaddress, nullable: true, editable: true, defaultValue: null, length: 255, alias: WebAddress, type: esriFieldTypeString )
• occupiedsqft ( modelName: occupiedsqft, nullable: false, editable: true, defaultValue: null, alias: OccupiedSqFt, type: esriFieldTypeInteger )
• siccode ( modelName: siccode, nullable: true, editable: true, defaultValue: null, length: 4, alias: SICCode, type: esriFieldTypeString )
• sicdescription ( modelName: sicdescription, nullable: true, editable: true, defaultValue: null, length: 255, alias: SICDescription, type: esriFieldTypeString )
• movedate ( modelName: movedate, nullable: true, editable: true, defaultValue: null, length: 50, alias: MoveDate, type: esriFieldTypeString )
• researchupdatedate ( modelName: researchupdatedate, nullable: true, editable: true, defaultValue: null, length: 50, alias: ResearchUpdateDate, type: esriFieldTypeString )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• anchor ( modelName: anchor, nullable: false, editable: true, defaultValue: null, length: 1, alias: Anchor, type: esriFieldTypeString )
• est_employee ( modelName: est_employee, nullable: true, editable: true, defaultValue: null, alias: Est_Employee, type: esriFieldTypeInteger )
• lv_extractdate ( modelName: lv_extractdate, nullable: true, editable: true, defaultValue: null, length: 10, alias: LV_ExtractDate, type: esriFieldTypeString )

Templates:

• Name: Tenant
  Description:
  Prototype:
  siccode: null
  propertygroupid: null
  buildingname: null
  city: null
  latitude: null
  sicdescription: null
  zip4: null
  numberofemployees: 0
  statecode: null
  webaddress: null
  futurepropertyid: null
  buildinglocation: null
  longitude: null
  address: null
  est_employee: null
  researchupdatedate: null
  lv_extractdate: null
  occupiedsqft: 0
  zipcode: null
  tenantcompanyid: 0
  movedate: null
  suite: null
  companyname:
  companyphone: null
  anchor:
  companyfax: null
  industrytypedesc: null
  submarketname: null
  propertyid: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Property (1) -- Related To: CoStarProperty (0)

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata