Name: CONSTR

Display Field: CNS_STYLE

Type: Table

Geometry Type: N/A

Description:

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

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: 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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
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 ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CNS_MNC ( type: esriFieldTypeInteger, alias: CNS_MNC, editable: true, nullable: false, defaultValue: null, modelName: CNS_MNC )
• CNS_PID ( type: esriFieldTypeInteger, alias: CNS_PID, editable: true, nullable: false, defaultValue: null, modelName: CNS_PID )
• CNS_BID ( type: esriFieldTypeInteger, alias: CNS_BID, editable: true, nullable: false, defaultValue: null, modelName: CNS_BID )
• CNS_STYLE ( type: esriFieldTypeString, alias: CNS_STYLE, editable: true, nullable: true, length: 6, defaultValue: null, modelName: CNS_STYLE )
• CNS_BASE_RATE ( type: esriFieldTypeDouble, alias: CNS_BASE_RATE, editable: true, nullable: true, defaultValue: null, modelName: CNS_BASE_RATE )
• CNS_STYLE_DESC ( type: esriFieldTypeString, alias: CNS_STYLE_DESC, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CNS_STYLE_DESC )
• CNS_IS_CMRCL ( type: esriFieldTypeInteger, alias: CNS_IS_CMRCL, editable: true, nullable: false, defaultValue: null, modelName: CNS_IS_CMRCL )
• CNS_IS_CONDO ( type: esriFieldTypeInteger, alias: CNS_IS_CONDO, editable: true, nullable: false, defaultValue: null, modelName: CNS_IS_CONDO )
• CNS_IS_CONDO_MAIN ( type: esriFieldTypeInteger, alias: CNS_IS_CONDO_MAIN, editable: true, nullable: false, defaultValue: null, modelName: CNS_IS_CONDO_MAIN )
• CNS_MDL ( type: esriFieldTypeString, alias: CNS_MDL, editable: true, nullable: true, length: 4, defaultValue: null, modelName: CNS_MDL )
• CNS_MDL_DESC ( type: esriFieldTypeString, alias: CNS_MDL_DESC, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CNS_MDL_DESC )
• CNS_IS_VACANT ( type: esriFieldTypeInteger, alias: CNS_IS_VACANT, editable: true, nullable: false, defaultValue: null, modelName: CNS_IS_VACANT )
• CNS_SIZ_ADJ_FACTOR ( type: esriFieldTypeDouble, alias: CNS_SIZ_ADJ_FACTOR, editable: true, nullable: true, defaultValue: null, modelName: CNS_SIZ_ADJ_FACTOR )
• CNS_AREA_EFFECTIVE ( type: esriFieldTypeInteger, alias: CNS_AREA_EFFECTIVE, editable: true, nullable: true, defaultValue: null, modelName: CNS_AREA_EFFECTIVE )
• CNS_AREA_GROSS ( type: esriFieldTypeInteger, alias: CNS_AREA_GROSS, editable: true, nullable: true, defaultValue: null, modelName: CNS_AREA_GROSS )
• CNS_AREA_LIVING ( type: esriFieldTypeInteger, alias: CNS_AREA_LIVING, editable: true, nullable: true, defaultValue: null, modelName: CNS_AREA_LIVING )
• CNS_REPLACE_COST ( type: esriFieldTypeDouble, alias: CNS_REPLACE_COST, editable: true, nullable: true, defaultValue: null, modelName: CNS_REPLACE_COST )
• CNS_APPRAIS_VAL ( type: esriFieldTypeDouble, alias: CNS_APPRAIS_VAL, editable: true, nullable: true, defaultValue: null, modelName: CNS_APPRAIS_VAL )
• CNS_REAL_APPRAIS_VAL ( type: esriFieldTypeDouble, alias: CNS_REAL_APPRAIS_VAL, editable: true, nullable: true, defaultValue: null, modelName: CNS_REAL_APPRAIS_VAL )
• CNS_ASSESS_VAL ( type: esriFieldTypeDouble, alias: CNS_ASSESS_VAL, editable: true, nullable: true, defaultValue: null, modelName: CNS_ASSESS_VAL )
• CNS_REAL_ASSESS_VAL ( type: esriFieldTypeDouble, alias: CNS_REAL_ASSESS_VAL, editable: true, nullable: true, defaultValue: null, modelName: CNS_REAL_ASSESS_VAL )
• CNS_OVERRIDE_VAL ( type: esriFieldTypeDouble, alias: CNS_OVERRIDE_VAL, editable: true, nullable: true, defaultValue: null, modelName: CNS_OVERRIDE_VAL )
• CNS_OVERRIDE_INITIALS ( type: esriFieldTypeString, alias: CNS_OVERRIDE_INITIALS, editable: true, nullable: true, length: 4, defaultValue: null, modelName: CNS_OVERRIDE_INITIALS )
• CNS_STATUS_DATE ( type: esriFieldTypeDate, alias: CNS_STATUS_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CNS_STATUS_DATE )
• CNS_REGRESSION_VAL ( type: esriFieldTypeDouble, alias: CNS_REGRESSION_VAL, editable: true, nullable: true, defaultValue: null, modelName: CNS_REGRESSION_VAL )
• CNS_OCC ( type: esriFieldTypeString, alias: CNS_OCC, editable: true, nullable: true, length: 6, defaultValue: null, modelName: CNS_OCC )
• CNS_OCC_DESC ( type: esriFieldTypeString, alias: CNS_OCC_DESC, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CNS_OCC_DESC )
• CNS_BLDG_STORIES ( type: esriFieldTypeString, alias: CNS_BLDG_STORIES, editable: true, nullable: true, length: 6, defaultValue: null, modelName: CNS_BLDG_STORIES )
• CNS_GROUP ( type: esriFieldTypeString, alias: CNS_GROUP, editable: true, nullable: true, length: 6, defaultValue: null, modelName: CNS_GROUP )
• CNS_STRUCT_CLASS ( type: esriFieldTypeString, alias: CNS_STRUCT_CLASS, editable: true, nullable: true, length: 6, defaultValue: null, modelName: CNS_STRUCT_CLASS )
• CNS_IS_EXE1 ( type: esriFieldTypeSmallInteger, alias: CNS_IS_EXE1, editable: true, nullable: true, defaultValue: null, modelName: CNS_IS_EXE1 )
• CNS_IS_EXE1_PCT ( type: esriFieldTypeSmallInteger, alias: CNS_IS_EXE1_PCT, editable: true, nullable: true, defaultValue: null, modelName: CNS_IS_EXE1_PCT )
• CNS_IS_EXE2 ( type: esriFieldTypeSmallInteger, alias: CNS_IS_EXE2, editable: true, nullable: true, defaultValue: null, modelName: CNS_IS_EXE2 )
• CNS_IS_EXE2_PCT ( type: esriFieldTypeSmallInteger, alias: CNS_IS_EXE2_PCT, editable: true, nullable: true, defaultValue: null, modelName: CNS_IS_EXE2_PCT )
• CNS_OVERRIDE_VAL_ASSESS ( type: esriFieldTypeDouble, alias: CNS_OVERRIDE_VAL_ASSESS, editable: true, nullable: true, defaultValue: null, modelName: CNS_OVERRIDE_VAL_ASSESS )
• CNS_ALT_CODE_1 ( type: esriFieldTypeString, alias: CNS_ALT_CODE_1, editable: true, nullable: true, length: 6, defaultValue: null, modelName: CNS_ALT_CODE_1 )
• CNS_ALT_ISSUED_1 ( type: esriFieldTypeSmallInteger, alias: CNS_ALT_ISSUED_1, editable: true, nullable: true, defaultValue: null, modelName: CNS_ALT_ISSUED_1 )
• CNS_ALT_COMPLETE_1 ( type: esriFieldTypeSmallInteger, alias: CNS_ALT_COMPLETE_1, editable: true, nullable: true, defaultValue: null, modelName: CNS_ALT_COMPLETE_1 )
• CNS_ALT_CODE_2 ( type: esriFieldTypeString, alias: CNS_ALT_CODE_2, editable: true, nullable: true, length: 6, defaultValue: null, modelName: CNS_ALT_CODE_2 )
• CNS_ALT_ISSUED_2 ( type: esriFieldTypeSmallInteger, alias: CNS_ALT_ISSUED_2, editable: true, nullable: true, defaultValue: null, modelName: CNS_ALT_ISSUED_2 )
• CNS_ALT_COMPLETE_2 ( type: esriFieldTypeSmallInteger, alias: CNS_ALT_COMPLETE_2, editable: true, nullable: true, defaultValue: null, modelName: CNS_ALT_COMPLETE_2 )
• CNS_BIS_CODE ( type: esriFieldTypeString, alias: CNS_BIS_CODE, editable: true, nullable: true, length: 6, defaultValue: null, modelName: CNS_BIS_CODE )
• CNS_BIS_CODE_DESC ( type: esriFieldTypeString, alias: CNS_BIS_CODE_DESC, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CNS_BIS_CODE_DESC )
• CNS_BIS_PCT ( type: esriFieldTypeInteger, alias: CNS_BIS_PCT, editable: true, nullable: true, defaultValue: null, modelName: CNS_BIS_PCT )
• CNS_BLD_STATUS ( type: esriFieldTypeString, alias: CNS_BLD_STATUS, editable: true, nullable: true, length: 6, defaultValue: null, modelName: CNS_BLD_STATUS )
• CNS_BLD_STATUS_DESC ( type: esriFieldTypeString, alias: CNS_BLD_STATUS_DESC, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CNS_BLD_STATUS_DESC )
• CNS_COM_UNITS ( type: esriFieldTypeInteger, alias: CNS_COM_UNITS, editable: true, nullable: true, defaultValue: null, modelName: CNS_COM_UNITS )
• CNS_RES_UNITS ( type: esriFieldTypeInteger, alias: CNS_RES_UNITS, editable: true, nullable: true, defaultValue: null, modelName: CNS_RES_UNITS )
• CNS_OOSF ( type: esriFieldTypeInteger, alias: CNS_OOSF, editable: true, nullable: true, defaultValue: null, modelName: CNS_OOSF )
• CNS_ALT_CODE_1_DESC ( type: esriFieldTypeString, alias: CNS_ALT_CODE_1_DESC, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CNS_ALT_CODE_1_DESC )
• CNS_ALT_CODE_2_DESC ( type: esriFieldTypeString, alias: CNS_ALT_CODE_2_DESC, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CNS_ALT_CODE_2_DESC )
• CNS_CREATE_DATE ( type: esriFieldTypeDate, alias: CNS_CREATE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CNS_CREATE_DATE )
• CNS_LAST_UPDATE ( type: esriFieldTypeDate, alias: CNS_LAST_UPDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CNS_LAST_UPDATE )
• CNS_USE_APEX ( type: esriFieldTypeSmallInteger, alias: CNS_USE_APEX, editable: true, nullable: true, defaultValue: null, modelName: CNS_USE_APEX )
• CNS_BID_IDENT ( type: esriFieldTypeInteger, alias: CNS_BID_IDENT, editable: true, nullable: false, defaultValue: null, modelName: CNS_BID_IDENT )
• CNS_AREA_DEMO ( type: esriFieldTypeInteger, alias: CNS_AREA_DEMO, editable: true, nullable: true, defaultValue: null, modelName: CNS_AREA_DEMO )
• CNS_DEMO_COST ( type: esriFieldTypeDouble, alias: CNS_DEMO_COST, editable: true, nullable: true, defaultValue: null, modelName: CNS_DEMO_COST )
• CNS_IS_EXE1_VAL ( type: esriFieldTypeDouble, alias: CNS_IS_EXE1_VAL, editable: true, nullable: true, defaultValue: null, modelName: CNS_IS_EXE1_VAL )
• CNS_IS_EXE2_VAL ( type: esriFieldTypeDouble, alias: CNS_IS_EXE2_VAL, editable: true, nullable: true, defaultValue: null, modelName: CNS_IS_EXE2_VAL )

Templates:

• Name: CONSTR
  Description:
  Prototype:
  CNS_IS_EXE1_VAL: null
  CNS_IS_EXE2_VAL: null
  CNS_MNC: 0
  CNS_PID: 0
  CNS_BID: 0
  CNS_STYLE: null
  CNS_BASE_RATE: null
  CNS_STYLE_DESC: null
  CNS_IS_CMRCL: 0
  CNS_IS_CONDO: 0
  CNS_IS_CONDO_MAIN: 0
  CNS_MDL: null
  CNS_MDL_DESC: null
  CNS_IS_VACANT: 0
  CNS_SIZ_ADJ_FACTOR: null
  CNS_AREA_EFFECTIVE: null
  CNS_AREA_GROSS: null
  CNS_AREA_LIVING: null
  CNS_REPLACE_COST: null
  CNS_APPRAIS_VAL: null
  CNS_REAL_APPRAIS_VAL: null
  CNS_ASSESS_VAL: null
  CNS_REAL_ASSESS_VAL: null
  CNS_OVERRIDE_VAL: null
  CNS_OVERRIDE_INITIALS: null
  CNS_STATUS_DATE: null
  CNS_REGRESSION_VAL: null
  CNS_OCC: null
  CNS_OCC_DESC: null
  CNS_BLDG_STORIES: null
  CNS_GROUP: null
  CNS_STRUCT_CLASS: null
  CNS_IS_EXE1: null
  CNS_IS_EXE1_PCT: null
  CNS_IS_EXE2: null
  CNS_IS_EXE2_PCT: null
  CNS_OVERRIDE_VAL_ASSESS: null
  CNS_ALT_CODE_1: null
  CNS_ALT_ISSUED_1: null
  CNS_ALT_COMPLETE_1: null
  CNS_ALT_CODE_2: null
  CNS_ALT_ISSUED_2: null
  CNS_ALT_COMPLETE_2: null
  CNS_BIS_CODE: null
  CNS_BIS_CODE_DESC: null
  CNS_BIS_PCT: null
  CNS_BLD_STATUS: null
  CNS_BLD_STATUS_DESC: null
  CNS_COM_UNITS: null
  CNS_RES_UNITS: null
  CNS_OOSF: null
  CNS_ALT_CODE_1_DESC: null
  CNS_ALT_CODE_2_DESC: null
  CNS_CREATE_DATE: null
  CNS_LAST_UPDATE: null
  CNS_USE_APEX: null
  CNS_BID_IDENT: 0
  CNS_AREA_DEMO: null
  CNS_DEMO_COST: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata