Name: Current Data - Condo Unit Building Information

Display Field: Condo_Name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: d1a5ba01788a42bea25ed5059fc2b579

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: 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
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 )
• CDUN_PID ( type: esriFieldTypeInteger, alias: CDUN_PID, editable: true, nullable: true, defaultValue: null, modelName: CDUN_PID )
• CDNU_BID ( type: esriFieldTypeInteger, alias: CDNU_BID, editable: true, nullable: true, defaultValue: null, modelName: CDNU_BID )
• Building_Number ( type: esriFieldTypeInteger, alias: Building_Number, editable: true, nullable: true, defaultValue: null, modelName: Building_Number )
• CNS_IS_CMRCL ( type: esriFieldTypeInteger, alias: CNS_IS_CMRCL, editable: true, nullable: true, defaultValue: null, modelName: CNS_IS_CMRCL )
• CNS_IS_CONDO ( type: esriFieldTypeInteger, alias: CNS_IS_CONDO, editable: true, nullable: true, defaultValue: null, modelName: CNS_IS_CONDO )
• CNS_IS_CONDO_MAIN ( type: esriFieldTypeInteger, alias: CNS_IS_CONDO_MAIN, editable: true, nullable: true, defaultValue: null, modelName: CNS_IS_CONDO_MAIN )
• Style_Code ( type: esriFieldTypeString, alias: Style_Code, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Style_Code )
• Style_Description ( type: esriFieldTypeString, alias: Style_Description, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Style_Description )
• Model_Code ( type: esriFieldTypeString, alias: Model_Code, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Model_Code )
• Model_Description ( type: esriFieldTypeString, alias: Model_Description, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Model_Description )
• Grade_Code ( type: esriFieldTypeString, alias: Grade_Code, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Grade_Code )
• Grade_Description ( type: esriFieldTypeString, alias: Grade_Description, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Grade_Description )
• OCC_Code ( type: esriFieldTypeString, alias: OCC_Code, editable: true, nullable: true, length: 6, defaultValue: null, modelName: OCC_Code )
• OCC_Description ( type: esriFieldTypeString, alias: OCC_Description, editable: true, nullable: true, length: 40, defaultValue: null, modelName: OCC_Description )
• Condo_Name ( type: esriFieldTypeString, alias: Condo_Name, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Condo_Name )
• Condo_Main_PID ( type: esriFieldTypeInteger, alias: Condo_Main_PID, editable: true, nullable: true, defaultValue: null, modelName: Condo_Main_PID )
• Area_Effective ( type: esriFieldTypeInteger, alias: Area_Effective, editable: true, nullable: true, defaultValue: null, modelName: Area_Effective )
• Area_Gross ( type: esriFieldTypeInteger, alias: Area_Gross, editable: true, nullable: true, defaultValue: null, modelName: Area_Gross )
• Area_Living ( type: esriFieldTypeInteger, alias: Area_Living, editable: true, nullable: true, defaultValue: null, modelName: Area_Living )
• Stories ( type: esriFieldTypeString, alias: Stories, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Stories )
• Number_Of_Rooms ( type: esriFieldTypeString, alias: Number_Of_Rooms, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Number_Of_Rooms )
• Number_Of_Bedrooms ( type: esriFieldTypeString, alias: Number_Of_Bedrooms, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Number_Of_Bedrooms )
• Number_Of_Full_Bathrooms ( type: esriFieldTypeString, alias: Number_Of_Full_Bathrooms, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Number_Of_Full_Bathrooms )
• Number_Of_Half_Bathrooms ( type: esriFieldTypeString, alias: Number_Of_Half_Bathrooms, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Number_Of_Half_Bathrooms )
• Number_Of_Extra_Fixtures ( type: esriFieldTypeString, alias: Number_Of_Extra_Fixtures, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Number_Of_Extra_Fixtures )
• Bathroom_Style ( type: esriFieldTypeString, alias: Bathroom_Style, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Bathroom_Style )
• Kitchen_Style ( type: esriFieldTypeString, alias: Kitchen_Style, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Kitchen_Style )
• Heat_Type ( type: esriFieldTypeString, alias: Heat_Type, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Heat_Type )
• Heat_System_Type ( type: esriFieldTypeString, alias: Heat_System_Type, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Heat_System_Type )
• Hot_Water_System ( type: esriFieldTypeString, alias: Hot_Water_System, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Hot_Water_System )
• Air_Conditioning_Type ( type: esriFieldTypeString, alias: Air_Conditioning_Type, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Air_Conditioning_Type )
• Interior_Wall_Type_1 ( type: esriFieldTypeString, alias: Interior_Wall_Type_1, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Interior_Wall_Type_1 )
• Interior_Wall_Type_2 ( type: esriFieldTypeString, alias: Interior_Wall_Type_2, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Interior_Wall_Type_2 )
• Flooring_Type_1 ( type: esriFieldTypeString, alias: Flooring_Type_1, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Flooring_Type_1 )
• Flooring_Type_2 ( type: esriFieldTypeString, alias: Flooring_Type_2, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Flooring_Type_2 )
• Number_Of_Fireplaces ( type: esriFieldTypeString, alias: Number_Of_Fireplaces, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Number_Of_Fireplaces )
• Building_Notes_1 ( type: esriFieldTypeString, alias: Building_Notes_1, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_1 )
• Building_Notes_2 ( type: esriFieldTypeString, alias: Building_Notes_2, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_2 )
• Building_Notes_3 ( type: esriFieldTypeString, alias: Building_Notes_3, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_3 )
• Building_Notes_4 ( type: esriFieldTypeString, alias: Building_Notes_4, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_4 )
• Building_Notes_5 ( type: esriFieldTypeString, alias: Building_Notes_5, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_5 )
• Building_Notes_6 ( type: esriFieldTypeString, alias: Building_Notes_6, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_6 )
• Building_Notes_7 ( type: esriFieldTypeString, alias: Building_Notes_7, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_7 )
• Building_Notes_8 ( type: esriFieldTypeString, alias: Building_Notes_8, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_8 )
• Building_Notes_9 ( type: esriFieldTypeString, alias: Building_Notes_9, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_9 )
• Building_Notes_10 ( type: esriFieldTypeString, alias: Building_Notes_10, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_10 )
• Building_Notes_11 ( type: esriFieldTypeString, alias: Building_Notes_11, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_11 )
• Undepreciated_Value ( type: esriFieldTypeInteger, alias: Undepreciated_Value, editable: true, nullable: true, defaultValue: null, modelName: Undepreciated_Value )
• Appraised_Value ( type: esriFieldTypeInteger, alias: Appraised_Value, editable: true, nullable: true, defaultValue: null, modelName: Appraised_Value )
• Assessed_Value ( type: esriFieldTypeInteger, alias: Assessed_Value, editable: true, nullable: true, defaultValue: null, modelName: Assessed_Value )
• Year_Built ( type: esriFieldTypeInteger, alias: Year_Built, editable: true, nullable: true, defaultValue: null, modelName: Year_Built )
• Effective_Year_Built ( type: esriFieldTypeInteger, alias: Effective_Year_Built, editable: true, nullable: true, defaultValue: null, modelName: Effective_Year_Built )
• Depreciation_Code ( type: esriFieldTypeString, alias: Depreciation_Code, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Depreciation_Code )
• Percent_Good ( type: esriFieldTypeInteger, alias: Percent_Good, editable: true, nullable: true, defaultValue: null, modelName: Percent_Good )
• Depreciation_Percent ( type: esriFieldTypeInteger, alias: Depreciation_Percent, editable: true, nullable: true, defaultValue: null, modelName: Depreciation_Percent )
• Year_Remodeled ( type: esriFieldTypeInteger, alias: Year_Remodeled, editable: true, nullable: true, defaultValue: null, modelName: Year_Remodeled )
• Functional_Obsol ( type: esriFieldTypeInteger, alias: Functional_Obsol, editable: true, nullable: true, defaultValue: null, modelName: Functional_Obsol )
• Economic_Obsol ( type: esriFieldTypeInteger, alias: Economic_Obsol, editable: true, nullable: true, defaultValue: null, modelName: Economic_Obsol )
• RCNLD ( type: esriFieldTypeInteger, alias: RCNLD, editable: true, nullable: true, defaultValue: null, modelName: RCNLD )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Current Data - Condo Unit Building Information
  Description:
  Prototype:
  RCNLD: null
  GlobalID: null
  CDUN_PID: null
  CDNU_BID: null
  Building_Number: null
  CNS_IS_CMRCL: null
  CNS_IS_CONDO: null
  CNS_IS_CONDO_MAIN: null
  Style_Code: null
  Style_Description: null
  Model_Code: null
  Model_Description: null
  Grade_Code: null
  Grade_Description: null
  OCC_Code: null
  OCC_Description: null
  Condo_Name: null
  Condo_Main_PID: null
  Area_Effective: null
  Area_Gross: null
  Area_Living: null
  Stories: null
  Number_Of_Rooms: null
  Number_Of_Bedrooms: null
  Number_Of_Full_Bathrooms: null
  Number_Of_Half_Bathrooms: null
  Number_Of_Extra_Fixtures: null
  Bathroom_Style: null
  Kitchen_Style: null
  Heat_Type: null
  Heat_System_Type: null
  Hot_Water_System: null
  Air_Conditioning_Type: null
  Interior_Wall_Type_1: null
  Interior_Wall_Type_2: null
  Flooring_Type_1: null
  Flooring_Type_2: null
  Number_Of_Fireplaces: null
  Building_Notes_1: null
  Building_Notes_2: null
  Building_Notes_3: null
  Building_Notes_4: null
  Building_Notes_5: null
  Building_Notes_6: null
  Building_Notes_7: null
  Building_Notes_8: null
  Building_Notes_9: null
  Building_Notes_10: null
  Building_Notes_11: null
  Undepreciated_Value: null
  Appraised_Value: null
  Assessed_Value: null
  Year_Built: null
  Effective_Year_Built: null
  Depreciation_Code: null
  Percent_Good: null
  Depreciation_Percent: null
  Year_Remodeled: null
  Functional_Obsol: null
  Economic_Obsol: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.Parcels (7) -- Related To: Parcels (2)
• DBO.Building_FP (15) -- Related To: Building Footprints (3)

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata