Name: CPCRGIS.DBO.bldg_database_12_2017

Display Field: Building_Name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 412972a668cf4225abd5fbcd6a4f0097

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:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Building_Name ( type: esriFieldTypeString, alias: Building_Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Building_Name )
• Official_Long ( type: esriFieldTypeString, alias: Official_Long, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Official_Long )
• Abbrev_Short ( type: esriFieldTypeString, alias: Abbrev_Short, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Abbrev_Short )
• FDX_Code ( type: esriFieldTypeString, alias: FDX_Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FDX_Code )
• CAAN_Number ( type: esriFieldTypeDouble, alias: CAAN_Number, editable: true, nullable: true, defaultValue: null, modelName: CAAN_Number )
• Facility_Code ( type: esriFieldTypeString, alias: Facility_Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Facility_Code )
• Architect ( type: esriFieldTypeString, alias: Architect, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Architect )
• Style ( type: esriFieldTypeString, alias: Style, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Style )
• Region ( type: esriFieldTypeString, alias: Region, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Region )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location )
• Affiliation ( type: esriFieldTypeString, alias: Affiliation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Affiliation )
• Category ( type: esriFieldTypeString, alias: Category, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Category )
• Primary_Use ( type: esriFieldTypeString, alias: Primary_Use, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Primary_Use )
• UBC_Code ( type: esriFieldTypeString, alias: UBC_Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UBC_Code )
• Planning ( type: esriFieldTypeString, alias: Planning, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Planning )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Condition )
• Operations ( type: esriFieldTypeString, alias: Operations, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Operations )
• Ownership ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Ownership )
• Financing ( type: esriFieldTypeString, alias: Financing, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Financing )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Address )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 255, defaultValue: null, modelName: City )
• County ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 255, defaultValue: null, modelName: County )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 255, defaultValue: null, modelName: State )
• Zip_Code ( type: esriFieldTypeString, alias: Zip_Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Zip_Code )
• Address_Code ( type: esriFieldTypeString, alias: Address_Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Address_Code )
• City_Code ( type: esriFieldTypeDouble, alias: City_Code, editable: true, nullable: true, defaultValue: null, modelName: City_Code )
• County_Code ( type: esriFieldTypeDouble, alias: County_Code, editable: true, nullable: true, defaultValue: null, modelName: County_Code )
• Floors ( type: esriFieldTypeDouble, alias: Floors, editable: true, nullable: true, defaultValue: null, modelName: Floors )
• Height ( type: esriFieldTypeDouble, alias: Height, editable: true, nullable: true, defaultValue: null, modelName: Height )
• Footprint ( type: esriFieldTypeDouble, alias: Footprint, editable: true, nullable: true, defaultValue: null, modelName: Footprint )
• Perimeter ( type: esriFieldTypeDouble, alias: Perimeter, editable: true, nullable: true, defaultValue: null, modelName: Perimeter )
• Total_Rooms ( type: esriFieldTypeDouble, alias: Total_Rooms, editable: true, nullable: true, defaultValue: null, modelName: Total_Rooms )
• Assignable ( type: esriFieldTypeDouble, alias: Assignable, editable: true, nullable: true, defaultValue: null, modelName: Assignable )
• Assignable_Spaces ( type: esriFieldTypeDouble, alias: Assignable_Spaces, editable: true, nullable: true, defaultValue: null, modelName: Assignable_Spaces )
• Non_Assignable ( type: esriFieldTypeDouble, alias: Non_Assignable, editable: true, nullable: true, defaultValue: null, modelName: Non_Assignable )
• Non_Asgn_Spaces ( type: esriFieldTypeDouble, alias: Non_Asgn_Spaces, editable: true, nullable: true, defaultValue: null, modelName: Non_Asgn_Spaces )
• Net_Usable ( type: esriFieldTypeDouble, alias: Net_Usable, editable: true, nullable: true, defaultValue: null, modelName: Net_Usable )
• Circulation ( type: esriFieldTypeDouble, alias: Circulation, editable: true, nullable: true, defaultValue: null, modelName: Circulation )
• Custodial ( type: esriFieldTypeDouble, alias: Custodial, editable: true, nullable: true, defaultValue: null, modelName: Custodial )
• Mechanical ( type: esriFieldTypeDouble, alias: Mechanical, editable: true, nullable: true, defaultValue: null, modelName: Mechanical )
• Parking ( type: esriFieldTypeDouble, alias: Parking, editable: true, nullable: true, defaultValue: null, modelName: Parking )
• Toilet ( type: esriFieldTypeDouble, alias: Toilet, editable: true, nullable: true, defaultValue: null, modelName: Toilet )
• Special_Area ( type: esriFieldTypeDouble, alias: Special_Area, editable: true, nullable: true, defaultValue: null, modelName: Special_Area )
• Basic_Gross ( type: esriFieldTypeDouble, alias: Basic_Gross, editable: true, nullable: true, defaultValue: null, modelName: Basic_Gross )
• C_U_Gross ( type: esriFieldTypeDouble, alias: C_U_Gross, editable: true, nullable: true, defaultValue: null, modelName: C_U_Gross )
• Outside_Gross ( type: esriFieldTypeDouble, alias: Outside_Gross, editable: true, nullable: true, defaultValue: null, modelName: Outside_Gross )
• Outside_Gross_50 ( type: esriFieldTypeDouble, alias: Outside_Gross_50, editable: true, nullable: true, defaultValue: null, modelName: Outside_Gross_50 )
• Structural_Area ( type: esriFieldTypeDouble, alias: Structural_Area, editable: true, nullable: true, defaultValue: null, modelName: Structural_Area )
• Unrelated_Gross ( type: esriFieldTypeDouble, alias: Unrelated_Gross, editable: true, nullable: true, defaultValue: null, modelName: Unrelated_Gross )
• Related_Gross ( type: esriFieldTypeDouble, alias: Related_Gross, editable: true, nullable: true, defaultValue: null, modelName: Related_Gross )
• Maintained_Gross ( type: esriFieldTypeDouble, alias: Maintained_Gross, editable: true, nullable: true, defaultValue: null, modelName: Maintained_Gross )
• Janitorized__SQF4_ ( type: esriFieldTypeDouble, alias: Janitorized__SQF4_, editable: true, nullable: true, defaultValue: null, modelName: Janitorized__SQF4_ )
• Constructed ( type: esriFieldTypeDate, alias: Constructed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Constructed )
• Occupied ( type: esriFieldTypeDate, alias: Occupied, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Occupied )
• Renovated ( type: esriFieldTypeDate, alias: Renovated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Renovated )
• Vacated ( type: esriFieldTypeString, alias: Vacated, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Vacated )
• Demolished ( type: esriFieldTypeString, alias: Demolished, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Demolished )
• Construction ( type: esriFieldTypeDouble, alias: Construction, editable: true, nullable: true, defaultValue: null, modelName: Construction )
• Capitalized ( type: esriFieldTypeDouble, alias: Capitalized, editable: true, nullable: true, defaultValue: null, modelName: Capitalized )
• Replacement ( type: esriFieldTypeDouble, alias: Replacement, editable: true, nullable: true, defaultValue: null, modelName: Replacement )
• CAAN_2 ( type: esriFieldTypeString, alias: CAAN_2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CAAN_2 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: CPCRGIS.DBO.bldg_database_12_2017
  Description:
  Prototype:
  last_edited_user: null
  created_date: null
  Building_Name: null
  Official_Long: null
  Abbrev_Short: null
  FDX_Code: null
  CAAN_Number: null
  Facility_Code: null
  Architect: null
  Style: null
  Region: null
  Location: null
  Affiliation: null
  Category: null
  Primary_Use: null
  UBC_Code: null
  Planning: null
  Condition: null
  Operations: null
  Ownership: null
  Financing: null
  Address: null
  City: null
  County: null
  State: null
  Zip_Code: null
  Address_Code: null
  City_Code: null
  County_Code: null
  Floors: null
  Height: null
  Footprint: null
  Perimeter: null
  Total_Rooms: null
  Assignable: null
  Assignable_Spaces: null
  Non_Assignable: null
  Non_Asgn_Spaces: null
  Net_Usable: null
  Circulation: null
  Custodial: null
  Mechanical: null
  Parking: null
  Toilet: null
  Special_Area: null
  Basic_Gross: null
  C_U_Gross: null
  Outside_Gross: null
  Outside_Gross_50: null
  Structural_Area: null
  Unrelated_Gross: null
  Related_Gross: null
  Maintained_Gross: null
  Janitorized__SQF4_: null
  Constructed: null
  Occupied: null
  Renovated: null
  Vacated: null
  Demolished: null
  Construction: null
  Capitalized: null
  Replacement: null
  CAAN_2: null
  last_edited_date: null
  created_user: null
  
  Drawing Tool: esriFeatureEditToolNone

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

Sync Can Return Changes: true

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

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