Name: Buildings

Display Field: business_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cec7d76ea52f44cab929b834ee6345f2

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: 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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• helper ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: helper, alias: Helper )
• parcel ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: parcel, alias: Parcel )
• building_number ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: building_number, alias: Building Number )
• building_street ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: building_street, alias: Building Street )
• building_address ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: building_address, alias: Building Address )
• business_name ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: business_name, alias: Business Name )
• owner_occupied_ ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: owner_occupied_, alias: Owner Occupied? )
• first_name ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: first_name, alias: First Name )
• last_name ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: last_name, alias: Last Name )
• owner_company_name ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: owner_company_name, alias: Owner Company Name )
• owner__address ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: owner__address, alias: Owner Address )
• owner_city ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: owner_city, alias: Owner City )
• owner_state ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: owner_state, alias: Owner State )
• owner_zip_code ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: owner_zip_code, alias: Owner Zip Code )
• owner_email_address_1 ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: owner_email_address_1, alias: Owner Email Address 1 )
• owner_email_address_2 ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: owner_email_address_2, alias: Owner Email Address 2 )
• owner_phone_number_1 ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: owner_phone_number_1, alias: Owner Phone Number 1 )
• owner_phone_number_2 ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: owner_phone_number_2, alias: Owner Phone Number 2 )
• total_square_footage ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_square_footage, alias: Total Square Footage )
• assessed_market_value ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: assessed_market_value, alias: Assessed Market Value )
• residential_sq ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: residential_sq, alias: Residential SQ )
• commercial_sq ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: commercial_sq, alias: Commercial SQ )
• rent ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: rent, alias: Rent )
• commercial_units ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: commercial_units, alias: Commercial Units )
• residential_units ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: residential_units, alias: Residential Units )
• f__bedrooms ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: f__bedrooms, alias: # Bedrooms )
• f__tenants ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: f__tenants, alias: # Tenants )
• last_sale_price ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: last_sale_price, alias: Last Sale Price )
• villiage_name ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: villiage_name, alias: Villiage Name )
• state ( nullable: true, editable: true, defaultValue: null, length: 8000, type: esriFieldTypeString, modelName: state, alias: State )
• date_sold ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: date_sold, alias: Date_Sold )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: globalid )

Templates:

• Name: Data_Table
  Description:
  Prototype:
  owner_email_address_1: null
  owner_city: null
  owner_phone_number_1: null
  owner_phone_number_2: null
  owner_company_name: null
  rent: null
  owner_email_address_2: null
  helper: null
  last_sale_price: null
  owner_zip_code: null
  state: null
  first_name: null
  assessed_market_value: null
  business_name: null
  parcel: null
  owner__address: null
  f__tenants: null
  building_address: null
  total_square_footage: null
  commercial_units: null
  villiage_name: null
  building_street: null
  last_name: null
  date_sold: null
  commercial_sq: null
  f__bedrooms: null
  residential_sq: null
  owner_occupied_: null
  residential_units: null
  owner_state: null
  building_number: 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: true

Supports ApplyEdits By Upload Id: 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: false

Supports Coordinates Quantization: true

Child Resources:

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