Name: Review

Display Field: property_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: c3e1c8a6fbd04bbda762fd136720559e

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• property_address ( modelName: property_address, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property_Address, type: esriFieldTypeString )
• property_name ( modelName: property_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property_Name, type: esriFieldTypeString )
• property_type ( modelName: property_type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property_Type, type: esriFieldTypeString )
• building_status ( modelName: building_status, nullable: true, editable: true, defaultValue: null, length: 255, alias: Building_Status, type: esriFieldTypeString )
• submarket_cluster ( modelName: submarket_cluster, nullable: true, editable: true, defaultValue: null, length: 255, alias: Submarket_Cluster, type: esriFieldTypeString )
• submarket_name ( modelName: submarket_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Submarket_Name, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 255, alias: City, type: esriFieldTypeString )
• state ( modelName: state, nullable: true, editable: true, defaultValue: null, length: 255, alias: State, type: esriFieldTypeString )
• zip ( modelName: zip, nullable: true, editable: true, defaultValue: null, length: 255, alias: Zip, type: esriFieldTypeString )
• county_name ( modelName: county_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: County_Name, type: esriFieldTypeString )
• year_built ( modelName: year_built, nullable: true, editable: true, defaultValue: null, alias: Year_Built, type: esriFieldTypeInteger )
• number_of_stories ( modelName: number_of_stories, nullable: true, editable: true, defaultValue: null, alias: Number_Of_Stories, type: esriFieldTypeInteger )
• year_renovated ( modelName: year_renovated, nullable: true, editable: true, defaultValue: null, length: 255, alias: Year_Renovated, type: esriFieldTypeString )
• number_of_parking_spaces ( modelName: number_of_parking_spaces, nullable: true, editable: true, defaultValue: null, alias: Number_Of_Parking_Spaces, type: esriFieldTypeInteger )
• parking_ratio ( modelName: parking_ratio, nullable: true, editable: true, defaultValue: null, alias: Parking_Ratio, type: esriFieldTypeDouble )
• rba ( modelName: rba, nullable: true, editable: true, defaultValue: null, alias: RBA, type: esriFieldTypeInteger )
• max_building_contiguous_space ( modelName: max_building_contiguous_space, nullable: true, editable: true, defaultValue: null, alias: Max_Building_Contiguous_Space, type: esriFieldTypeInteger )
• smallest_available_space ( modelName: smallest_available_space, nullable: true, editable: true, defaultValue: null, alias: Smallest_Available_Space, type: esriFieldTypeInteger )
• total_available_space__sf_ ( modelName: total_available_space__sf_, nullable: true, editable: true, defaultValue: null, alias: Total_Available_Space__SF_, type: esriFieldTypeInteger )
• direct_available_space ( modelName: direct_available_space, nullable: true, editable: true, defaultValue: null, alias: Direct_Available_Space, type: esriFieldTypeInteger )
• direct_vacant_space ( modelName: direct_vacant_space, nullable: true, editable: true, defaultValue: null, alias: Direct_Vacant_Space, type: esriFieldTypeInteger )
• sublet_available_space ( modelName: sublet_available_space, nullable: true, editable: true, defaultValue: null, alias: Sublet_Available_Space, type: esriFieldTypeInteger )
• average_weighted_rent ( modelName: average_weighted_rent, nullable: true, editable: true, defaultValue: null, length: 255, alias: Average_Weighted_Rent, type: esriFieldTypeString )
• percent_leased ( modelName: percent_leased, nullable: true, editable: true, defaultValue: null, alias: Percent_Leased, type: esriFieldTypeDouble )
• office_space ( modelName: office_space, nullable: true, editable: true, defaultValue: null, alias: Office_Space, type: esriFieldTypeInteger )
• building_tax_expenses ( modelName: building_tax_expenses, nullable: true, editable: true, defaultValue: null, length: 255, alias: Building_Tax_Expenses, type: esriFieldTypeString )
• building_operating_expenses ( modelName: building_operating_expenses, nullable: true, editable: true, defaultValue: null, length: 255, alias: Building_Operating_Expenses, type: esriFieldTypeString )
• sublet_services ( modelName: sublet_services, nullable: true, editable: true, defaultValue: null, length: 255, alias: Sublet_Services, type: esriFieldTypeString )
• direct_services ( modelName: direct_services, nullable: true, editable: true, defaultValue: null, length: 255, alias: Direct_Services, type: esriFieldTypeString )
• leasing_company_name ( modelName: leasing_company_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Leasing_Company_Name, type: esriFieldTypeString )
• leasing_company_city_state_zip ( modelName: leasing_company_city_state_zip, nullable: true, editable: true, defaultValue: null, length: 255, alias: Leasing_Company_City_State_Zip, type: esriFieldTypeString )
• leasing_company_phone ( modelName: leasing_company_phone, nullable: true, editable: true, defaultValue: null, alias: Leasing_Company_Phone, type: esriFieldTypeDouble )
• leasing_company_fax ( modelName: leasing_company_fax, nullable: true, editable: true, defaultValue: null, length: 255, alias: Leasing_Company_Fax, type: esriFieldTypeString )
• primary_agent_name ( modelName: primary_agent_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Primary_Agent_Name, type: esriFieldTypeString )
• property_manager_name ( modelName: property_manager_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property_Manager_Name, type: esriFieldTypeString )
• developer_name ( modelName: developer_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Developer_Name, type: esriFieldTypeString )
• owner_name ( modelName: owner_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Owner_Name, type: esriFieldTypeString )
• features ( modelName: features, nullable: true, editable: true, defaultValue: null, length: 255, alias: Features, type: esriFieldTypeString )
• power ( modelName: power, nullable: true, editable: true, defaultValue: null, length: 255, alias: Power, type: esriFieldTypeString )
• ceiling_ht ( modelName: ceiling_ht, nullable: true, editable: true, defaultValue: null, length: 255, alias: Ceiling_Ht, type: esriFieldTypeString )
• number_of_loading_docks ( modelName: number_of_loading_docks, nullable: true, editable: true, defaultValue: null, alias: Number_Of_Loading_Docks, type: esriFieldTypeInteger )
• drive_ins ( modelName: drive_ins, nullable: true, editable: true, defaultValue: null, length: 255, alias: Drive_Ins, type: esriFieldTypeString )
• column_spacing ( modelName: column_spacing, nullable: true, editable: true, defaultValue: null, length: 255, alias: Column_Spacing, type: esriFieldTypeString )
• sprinklers ( modelName: sprinklers, nullable: true, editable: true, defaultValue: null, length: 255, alias: Sprinklers, type: esriFieldTypeString )
• number_of_cranes ( modelName: number_of_cranes, nullable: true, editable: true, defaultValue: null, length: 255, alias: Number_Of_Cranes, type: esriFieldTypeString )
• construction_material ( modelName: construction_material, nullable: true, editable: true, defaultValue: null, length: 255, alias: Construction_Material, type: esriFieldTypeString )
• rail_lines ( modelName: rail_lines, nullable: true, editable: true, defaultValue: null, length: 255, alias: Rail_Lines, type: esriFieldTypeString )
• heating ( modelName: heating, nullable: true, editable: true, defaultValue: null, length: 255, alias: Heating, type: esriFieldTypeString )
• sewer ( modelName: sewer, nullable: true, editable: true, defaultValue: null, length: 255, alias: Sewer, type: esriFieldTypeString )
• water ( modelName: water, nullable: true, editable: true, defaultValue: null, length: 255, alias: Water, type: esriFieldTypeString )
• gas ( modelName: gas, nullable: true, editable: true, defaultValue: null, length: 255, alias: Gas, type: esriFieldTypeString )
• propertyid ( modelName: propertyid, nullable: true, editable: true, defaultValue: null, alias: PropertyID, type: esriFieldTypeInteger )
• avg_rent_direct__industrial_ ( modelName: avg_rent_direct__industrial_, nullable: true, editable: true, defaultValue: null, alias: Avg_Rent_Direct__Industrial_, type: esriFieldTypeDouble )
• avg_rent_sublet__industrial_ ( modelName: avg_rent_sublet__industrial_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Avg_Rent_Sublet__Industrial_, type: esriFieldTypeString )
• building_park ( modelName: building_park, nullable: true, editable: true, defaultValue: null, length: 255, alias: Building_Park, type: esriFieldTypeString )

Templates:

• Name: Review
  Description:
  Prototype:
  ceiling_ht: null
  column_spacing: null
  developer_name: null
  direct_vacant_space: null
  number_of_loading_docks: null
  property_name: null
  number_of_cranes: null
  year_renovated: null
  leasing_company_phone: null
  features: null
  primary_agent_name: null
  direct_available_space: null
  direct_services: null
  state: null
  heating: null
  zip: null
  number_of_stories: null
  owner_name: null
  max_building_contiguous_space: null
  percent_leased: null
  water: null
  rba: null
  property_manager_name: null
  property_address: null
  year_built: null
  building_tax_expenses: null
  drive_ins: null
  city: null
  office_space: null
  leasing_company_fax: null
  rail_lines: null
  avg_rent_sublet__industrial_: null
  building_park: null
  building_operating_expenses: null
  sewer: null
  total_available_space__sf_: null
  gas: null
  property_type: null
  leasing_company_city_state_zip: null
  power: null
  building_status: null
  construction_material: null
  sprinklers: null
  sublet_services: null
  submarket_name: null
  county_name: null
  number_of_parking_spaces: null
  leasing_company_name: null
  submarket_cluster: null
  smallest_available_space: null
  avg_rent_direct__industrial_: null
  parking_ratio: null
  sublet_available_space: null
  propertyid: null
  average_weighted_rent: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

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:   Field Groups   Contingent Values

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