Name: Mobile_CAMA.DBO.v_gis_cama_mobile_sections

Display Field: last_chg_login

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

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• last_chg_login ( type: esriFieldTypeString, alias: last_chg_login, editable: true, nullable: true, length: 28, defaultValue: null, modelName: last_chg_login )
• last_chg_datetime ( type: esriFieldTypeDate, alias: last_chg_datetime, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_chg_datetime )
• parcel_number ( type: esriFieldTypeString, alias: parcel_number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: parcel_number )
• parcel_year ( type: esriFieldTypeInteger, alias: parcel_year, editable: true, nullable: true, defaultValue: null, modelName: parcel_year )
• structure_id ( type: esriFieldTypeInteger, alias: structure_id, editable: true, nullable: false, defaultValue: null, modelName: structure_id )
• section_id ( type: esriFieldTypeInteger, alias: section_id, editable: true, nullable: false, defaultValue: null, modelName: section_id )
• improvement_number ( type: esriFieldTypeInteger, alias: improvement_number, editable: true, nullable: true, defaultValue: null, modelName: improvement_number )
• construction_type ( type: esriFieldTypeString, alias: construction_type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: construction_type )
• section_desc ( type: esriFieldTypeString, alias: section_desc, editable: true, nullable: true, length: 100, defaultValue: null, modelName: section_desc )
• sq_ft_per_floor ( type: esriFieldTypeInteger, alias: sq_ft_per_floor, editable: true, nullable: true, defaultValue: null, modelName: sq_ft_per_floor )
• number_of_levels_section ( type: esriFieldTypeDouble, alias: number_of_levels_section, editable: true, nullable: true, defaultValue: null, modelName: number_of_levels_section )
• number_of_levels_building ( type: esriFieldTypeDouble, alias: number_of_levels_building, editable: true, nullable: true, defaultValue: null, modelName: number_of_levels_building )
• perimeter ( type: esriFieldTypeInteger, alias: perimeter, editable: true, nullable: true, defaultValue: null, modelName: perimeter )
• shape ( type: esriFieldTypeString, alias: shape, editable: true, nullable: true, length: 10, defaultValue: null, modelName: shape )
• effective_age ( type: esriFieldTypeInteger, alias: effective_age, editable: true, nullable: true, defaultValue: null, modelName: effective_age )
• base_date ( type: esriFieldTypeDate, alias: base_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: base_date )
• depreciation_id ( type: esriFieldTypeInteger, alias: depreciation_id, editable: true, nullable: true, defaultValue: null, modelName: depreciation_id )
• lower_level_height ( type: esriFieldTypeDouble, alias: lower_level_height, editable: true, nullable: true, defaultValue: null, modelName: lower_level_height )
• main_level_height ( type: esriFieldTypeDouble, alias: main_level_height, editable: true, nullable: true, defaultValue: null, modelName: main_level_height )
• upper_level_height ( type: esriFieldTypeDouble, alias: upper_level_height, editable: true, nullable: true, defaultValue: null, modelName: upper_level_height )
• market_adjustment ( type: esriFieldTypeDouble, alias: market_adjustment, editable: true, nullable: true, defaultValue: null, modelName: market_adjustment )
• identical_buildings ( type: esriFieldTypeDouble, alias: identical_buildings, editable: true, nullable: true, defaultValue: null, modelName: identical_buildings )
• orig_section_id ( type: esriFieldTypeInteger, alias: orig_section_id, editable: true, nullable: true, defaultValue: null, modelName: orig_section_id )
• orig_structure_id ( type: esriFieldTypeInteger, alias: orig_structure_id, editable: true, nullable: true, defaultValue: null, modelName: orig_structure_id )
• transfer_id ( type: esriFieldTypeInteger, alias: transfer_id, editable: true, nullable: true, defaultValue: null, modelName: transfer_id )
• transfer_structure_id ( type: esriFieldTypeInteger, alias: transfer_structure_id, editable: true, nullable: true, defaultValue: null, modelName: transfer_structure_id )
• transfer_section_id ( type: esriFieldTypeInteger, alias: transfer_section_id, editable: true, nullable: true, defaultValue: null, modelName: transfer_section_id )
• section_id_for_roll ( type: esriFieldTypeInteger, alias: section_id_for_roll, editable: true, nullable: true, defaultValue: null, modelName: section_id_for_roll )
• assignment_id ( type: esriFieldTypeInteger, alias: assignment_id, editable: true, nullable: false, defaultValue: null, modelName: assignment_id )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• delete_flag ( type: esriFieldTypeInteger, alias: delete_flag, editable: true, nullable: true, defaultValue: null, modelName: delete_flag )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Mobile_CAMA.DBO.v_gis_cama_mobile_sections
  Description:
  Prototype:
  delete_flag: null
  last_chg_login: null
  last_chg_datetime: null
  parcel_number: null
  parcel_year: null
  structure_id: 0
  section_id: 0
  improvement_number: null
  construction_type: null
  section_desc: null
  sq_ft_per_floor: null
  number_of_levels_section: null
  number_of_levels_building: null
  perimeter: null
  shape: null
  effective_age: null
  base_date: null
  depreciation_id: null
  lower_level_height: null
  main_level_height: null
  upper_level_height: null
  market_adjustment: null
  identical_buildings: null
  orig_section_id: null
  orig_structure_id: null
  transfer_id: null
  transfer_structure_id: null
  transfer_section_id: null
  section_id_for_roll: null
  assignment_id: 0
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• v_gis_cama_mobile_section_attributes (3) -- Related To: Mobile_CAMA.DBO.v_gis_cama_mobile_section_attributes (4)
• v_gis_cama_mobile_structures (2) -- Related To: Mobile_CAMA.DBO.v_gis_cama_mobile_structures (1)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: 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

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata