Name: Certificates_of_Disclosure

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• PERMIT_ID (type: esriFieldTypeString, alias: PERMIT_ID, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• FILE_DATE (type: esriFieldTypeDate, alias: FILE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PRIMARY_PARCEL (type: esriFieldTypeString, alias: PRIMARY_PARCEL, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• PRIMARY_ADDRESS (type: esriFieldTypeString, alias: PRIMARY_ADDRESS, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• WARD (type: esriFieldTypeString, alias: WARD, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• OWNER_NAME (type: esriFieldTypeString, alias: OWNER_NAME, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TITLE_AGENCY_NAME (type: esriFieldTypeString, alias: TITLE_AGENCY_NAME, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• TITLE_AGENCY_BUSINESS_NAME (type: esriFieldTypeString, alias: TITLE_AGENCY_BUSINESS_NAME, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• BUYER_NAME (type: esriFieldTypeString, alias: BUYER_NAME, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• BUYER_BUSINESS_NAME (type: esriFieldTypeString, alias: BUYER_BUSINESS_NAME, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• MORTGAGE_BROKER_NAME (type: esriFieldTypeString, alias: MORTGAGE_BROKER_NAME, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• MORTGAGE_BROKER_BUSINESS_NAME (type: esriFieldTypeString, alias: MORTGAGE_BROKER_BUSINESS_NAME, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• MORTGAGE_COMPANY (type: esriFieldTypeString, alias: MORTGAGE_COMPANY, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• MORTGAGE_COMPANY_BUSINESS_NAME (type: esriFieldTypeString, alias: MORTGAGE_COMPANY_BUSINESS_NAME, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ISSUED_BY (type: esriFieldTypeString, alias: ISSUED_BY, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ISSUE_DATE (type: esriFieldTypeDate, alias: ISSUE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CONDEMNED_STATUS (type: esriFieldTypeString, alias: CONDEMNED_STATUS, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• CONDEMNED_EVER (type: esriFieldTypeString, alias: CONDEMNED_EVER, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• CURRENT_VIOLATIONS (type: esriFieldTypeString, alias: CURRENT_VIOLATIONS, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• CURRENT_BH_LEAD_VIOLATIONS (type: esriFieldTypeString, alias: CURRENT_BH_LEAD_VIOLATIONS, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• CURRENT_CDPH_LEAD_VIOLATIONS (type: esriFieldTypeString, alias: CURRENT_CDPH_LEAD_VIOLATIONS, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ACCELA_CITIZEN_ACCESS_URL (type: esriFieldTypeString, alias: ACCELA_CITIZEN_ACCESS_URL, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• DW_Parcel (type: esriFieldTypeString, alias: DW_Parcel, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• DW_Ward (type: esriFieldTypeString, alias: DW_Ward, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• DW_Ward2026 (type: esriFieldTypeDouble, alias: DW_Ward2026, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DW_Ward2014 (type: esriFieldTypeDouble, alias: DW_Ward2014, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DW_Tract2020 (type: esriFieldTypeString, alias: DW_Tract2020, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• DW_Neighborhood (type: esriFieldTypeString, alias: DW_Neighborhood, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/27/2025 10:16:53 AM

Schema Last Edit Date: 7/27/2025 10:16:53 AM

Data Last Edit Date: 7/27/2025 10:16:53 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat