Name: Mobile_CAMA.DBO.v_gis_cama_mobile_structures

Display Field: structure_name

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: false, length: 20, defaultValue: null, modelName: parcel_number )
• parcel_year ( type: esriFieldTypeInteger, alias: parcel_year, editable: true, nullable: false, defaultValue: null, modelName: parcel_year )
• structure_id ( type: esriFieldTypeInteger, alias: structure_id, editable: true, nullable: false, defaultValue: null, modelName: structure_id )
• manual_id ( type: esriFieldTypeInteger, alias: manual_id, editable: true, nullable: false, defaultValue: null, modelName: manual_id )
• property_use ( type: esriFieldTypeString, alias: property_use, editable: true, nullable: true, length: 10, defaultValue: null, modelName: property_use )
• quality ( type: esriFieldTypeInteger, alias: quality, editable: true, nullable: true, defaultValue: null, modelName: quality )
• structure_value ( type: esriFieldTypeDouble, alias: structure_value, editable: true, nullable: true, defaultValue: null, modelName: structure_value )
• primary_structure ( type: esriFieldTypeString, alias: primary_structure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: primary_structure )
• primary_area ( type: esriFieldTypeDouble, alias: primary_area, editable: true, nullable: true, defaultValue: null, modelName: primary_area )
• secondary_structure ( type: esriFieldTypeString, alias: secondary_structure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: secondary_structure )
• secondary_area ( type: esriFieldTypeDouble, alias: secondary_area, editable: true, nullable: true, defaultValue: null, modelName: secondary_area )
• tertiary_structure ( type: esriFieldTypeString, alias: tertiary_structure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tertiary_structure )
• tertiary_area ( type: esriFieldTypeDouble, alias: tertiary_area, editable: true, nullable: true, defaultValue: null, modelName: tertiary_area )
• base_area ( type: esriFieldTypeDouble, alias: base_area, editable: true, nullable: true, defaultValue: null, modelName: base_area )
• structure_name ( type: esriFieldTypeString, alias: structure_name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: structure_name )
• year_built ( type: esriFieldTypeInteger, alias: year_built, editable: true, nullable: true, defaultValue: null, modelName: year_built )
• adjusted_age ( type: esriFieldTypeInteger, alias: adjusted_age, editable: true, nullable: true, defaultValue: null, modelName: adjusted_age )
• sketch_id ( type: esriFieldTypeInteger, alias: sketch_id, editable: true, nullable: true, defaultValue: null, modelName: sketch_id )
• notes ( type: esriFieldTypeString, alias: notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: notes )
• manual_yn ( type: esriFieldTypeString, alias: manual_yn, editable: true, nullable: true, length: 1, defaultValue: null, modelName: manual_yn )
• original_value ( type: esriFieldTypeDouble, alias: original_value, editable: true, nullable: true, defaultValue: null, modelName: original_value )
• value_flag ( type: esriFieldTypeString, alias: value_flag, editable: true, nullable: true, length: 10, defaultValue: null, modelName: value_flag )
• value_desc ( type: esriFieldTypeString, alias: value_desc, editable: true, nullable: true, length: 100, defaultValue: null, modelName: value_desc )
• completion_percentage ( type: esriFieldTypeDouble, alias: completion_percentage, editable: true, nullable: true, defaultValue: null, modelName: completion_percentage )
• remodel_year ( type: esriFieldTypeInteger, alias: remodel_year, editable: true, nullable: true, defaultValue: null, modelName: remodel_year )
• res_percentage ( type: esriFieldTypeDouble, alias: res_percentage, editable: true, nullable: true, defaultValue: null, modelName: res_percentage )
• farm_percentage ( type: esriFieldTypeDouble, alias: farm_percentage, editable: true, nullable: true, defaultValue: null, modelName: farm_percentage )
• com_percentage ( type: esriFieldTypeDouble, alias: com_percentage, editable: true, nullable: true, defaultValue: null, modelName: com_percentage )
• ind_percentage ( type: esriFieldTypeDouble, alias: ind_percentage, editable: true, nullable: true, defaultValue: null, modelName: ind_percentage )
• building_code ( type: esriFieldTypeString, alias: building_code, editable: true, nullable: true, length: 4, defaultValue: null, modelName: building_code )
• adj_reason ( type: esriFieldTypeString, alias: adj_reason, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: adj_reason )
• appraisal_manual_used ( type: esriFieldTypeString, alias: appraisal_manual_used, editable: true, nullable: true, length: 10, defaultValue: null, modelName: appraisal_manual_used )
• appraisal_created_datetime ( type: esriFieldTypeDate, alias: appraisal_created_datetime, editable: true, nullable: true, length: 8, defaultValue: null, modelName: appraisal_created_datetime )
• appraisal_created_year ( type: esriFieldTypeInteger, alias: appraisal_created_year, editable: true, nullable: true, defaultValue: null, modelName: appraisal_created_year )
• actual_age ( type: esriFieldTypeInteger, alias: actual_age, editable: true, nullable: true, defaultValue: null, modelName: actual_age )
• gross_living_area ( type: esriFieldTypeDouble, alias: gross_living_area, editable: true, nullable: false, defaultValue: null, modelName: gross_living_area )
• structure_id_for_roll ( type: esriFieldTypeInteger, alias: structure_id_for_roll, editable: true, nullable: true, defaultValue: null, modelName: structure_id_for_roll )
• prorate_date ( type: esriFieldTypeDate, alias: prorate_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: prorate_date )
• prorate_yn ( type: esriFieldTypeString, alias: prorate_yn, editable: true, nullable: true, length: 1, defaultValue: null, modelName: prorate_yn )
• new_const_orig ( type: esriFieldTypeDouble, alias: new_const_orig, editable: true, nullable: true, defaultValue: null, modelName: new_const_orig )
• structure_multiplier ( type: esriFieldTypeInteger, alias: structure_multiplier, editable: true, nullable: true, defaultValue: null, modelName: structure_multiplier )
• qv_yn ( type: esriFieldTypeString, alias: qv_yn, editable: true, nullable: true, length: 1, defaultValue: null, modelName: qv_yn )
• qv_value ( type: esriFieldTypeDouble, alias: qv_value, editable: true, nullable: true, defaultValue: null, modelName: qv_value )
• exceptional_property_factor_yn ( type: esriFieldTypeString, alias: exceptional_property_factor_yn, editable: true, nullable: true, length: 1, defaultValue: null, modelName: exceptional_property_factor_yn )
• exceptional_property_factor ( type: esriFieldTypeDouble, alias: exceptional_property_factor, editable: true, nullable: true, defaultValue: null, modelName: exceptional_property_factor )
• tenant_roster ( type: esriFieldTypeString, alias: tenant_roster, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: tenant_roster )
• franchise_code ( type: esriFieldTypeString, alias: franchise_code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: franchise_code )
• building_id ( type: esriFieldTypeInteger, alias: building_id, editable: true, nullable: true, defaultValue: null, modelName: building_id )
• sale_yn ( type: esriFieldTypeString, alias: sale_yn, editable: true, nullable: true, length: 1, defaultValue: null, modelName: sale_yn )
• address_id ( type: esriFieldTypeInteger, alias: address_id, editable: true, nullable: true, defaultValue: null, modelName: address_id )
• condition ( type: esriFieldTypeInteger, alias: condition, editable: true, nullable: true, defaultValue: null, modelName: condition )
• source ( type: esriFieldTypeString, alias: source, editable: true, nullable: true, length: 10, defaultValue: null, modelName: source )
• transfer_id ( type: esriFieldTypeInteger, alias: transfer_id, editable: true, nullable: true, defaultValue: null, modelName: transfer_id )
• orig_structure_id ( type: esriFieldTypeInteger, alias: orig_structure_id, editable: true, nullable: true, defaultValue: null, modelName: orig_structure_id )
• orig_image_id ( type: esriFieldTypeInteger, alias: orig_image_id, editable: true, nullable: true, defaultValue: null, modelName: orig_image_id )
• transfer_structure_id ( type: esriFieldTypeInteger, alias: transfer_structure_id, editable: true, nullable: true, defaultValue: null, modelName: transfer_structure_id )
• 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_structures
  Description:
  Prototype:
  delete_flag: null
  last_chg_login: null
  last_chg_datetime: null
  parcel_number:
  parcel_year: 0
  structure_id: 0
  manual_id: 0
  property_use: null
  quality: null
  structure_value: null
  primary_structure: null
  primary_area: null
  secondary_structure: null
  secondary_area: null
  tertiary_structure: null
  tertiary_area: null
  base_area: null
  structure_name: null
  year_built: null
  adjusted_age: null
  sketch_id: null
  notes: null
  manual_yn: null
  original_value: null
  value_flag: null
  value_desc: null
  completion_percentage: null
  remodel_year: null
  res_percentage: null
  farm_percentage: null
  com_percentage: null
  ind_percentage: null
  building_code: null
  adj_reason: null
  appraisal_manual_used: null
  appraisal_created_datetime: null
  appraisal_created_year: null
  actual_age: null
  gross_living_area: 0
  structure_id_for_roll: null
  prorate_date: null
  prorate_yn: null
  new_const_orig: null
  structure_multiplier: null
  qv_yn: null
  qv_value: null
  exceptional_property_factor_yn: null
  exceptional_property_factor: null
  tenant_roster: null
  franchise_code: null
  building_id: null
  sale_yn: null
  address_id: null
  condition: null
  source: null
  transfer_id: null
  orig_structure_id: null
  orig_image_id: null
  transfer_structure_id: null
  assignment_id: 0
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• v_gis_cama_mobile_structure_attributes (1) -- Related To: Mobile_CAMA.DBO.v_gis_cama_mobile_structure_attributes (2)
• v_gis_cama_mobile_sections (2) -- Related To: Mobile_CAMA.DBO.v_gis_cama_mobile_sections (3)
• v_gis_cama_mobile_parcels (0) -- Related To: v_gis_cama_mobile_parcels (0)

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