Name: BuildingPermitDataAll

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:

• Category (type: esriFieldTypeString, alias: Category, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Record_Number (type: esriFieldTypeString, alias: Record Number, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Commercial_Subtype (type: esriFieldTypeString, alias: Commercial Subtype, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Residential_Subtype (type: esriFieldTypeString, alias: Residential Subtype, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ADU_TED_on_Permit_ (type: esriFieldTypeString, alias: ADU/TED on Permit?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Work_Description (type: esriFieldTypeString, alias: Work Description, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Business_Name (type: esriFieldTypeString, alias: Business Name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Project_Cost (type: esriFieldTypeDouble, alias: Project Cost, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Job_Cost_Valuation (type: esriFieldTypeDouble, alias: Job Cost Valuation, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Current_Valuation___Commercial (type: esriFieldTypeString, alias: Current Valuation - Commercial, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Current_Valuation___Residential (type: esriFieldTypeDouble, alias: Current Valuation - Residential, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ADU_or_TED_on_Address_ (type: esriFieldTypeString, alias: ADU or TED on Address?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Total_Construction_Valuation (type: esriFieldTypeDouble, alias: Total Construction Valuation, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Current_Market_Valuation (type: esriFieldTypeDouble, alias: Current Market Valuation, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Property_Type (type: esriFieldTypeString, alias: Property Type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Project_Type (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Property_Type_Order (type: esriFieldTypeDouble, alias: Property Type Order, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Units (type: esriFieldTypeInteger, alias: Units, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Data_Dump (type: esriFieldTypeString, alias: Data Dump, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Permit_Date (type: esriFieldTypeDateOnly, alias: Permit Date, SQL Type: sqlTypeDate, nullable: true, editable: true)
• Permit_Month (type: esriFieldTypeString, alias: Permit Month, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Month_Number (type: esriFieldTypeInteger, alias: Month Number, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Year_Type (type: esriFieldTypeString, alias: Year Type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Permit_Year (type: esriFieldTypeInteger, alias: Permit Year, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/29/2025 5:13:51 PM

Schema Last Edit Date: 7/29/2025 5:13:51 PM

Data Last Edit Date: 7/29/2025 5:13:51 PM

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