Name: Permitting Table

Display Field: PID

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Max Record Count: 2000

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: sqlTypeOther, length: 0, nullable: false, editable: false)
• PID (type: esriFieldTypeInteger, alias: PID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• GNMasterProjectID (type: esriFieldTypeInteger, alias: GNMasterProjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GNCommonID (type: esriFieldTypeInteger, alias: GNCommonID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PR_RecordID (type: esriFieldTypeInteger, alias: PR_RecordID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ApplicationNumber (type: esriFieldTypeString, alias: ApplicationNumber, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ApplicationDate (type: esriFieldTypeDate, alias: ApplicationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• IssueDate (type: esriFieldTypeDate, alias: IssueDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateFinaled (type: esriFieldTypeDate, alias: DateFinaled, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SQFT (type: esriFieldTypeDouble, alias: SQFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Units (type: esriFieldTypeDouble, alias: Units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AffordableHousing (type: esriFieldTypeString, alias: AffordableHousing, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Expedited (type: esriFieldTypeString, alias: Expedited, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• OnSewer (type: esriFieldTypeString, alias: OnSewer, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ProjectValuation (type: esriFieldTypeDouble, alias: ProjectValuation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OldAppType (type: esriFieldTypeString, alias: OldAppType, SQL Type: sqlTypeOther, length: 7, nullable: false, editable: true)
• ApplicationType (type: esriFieldTypeString, alias: ApplicationType, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• TypeDesc (type: esriFieldTypeString, alias: TypeDesc, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• ApplicationStatus (type: esriFieldTypeString, alias: ApplicationStatus, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• StatusDesc (type: esriFieldTypeString, alias: StatusDesc, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• ApplicationDescription (type: esriFieldTypeString, alias: ApplicationDescription, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• BldgUse (type: esriFieldTypeString, alias: BldgUse, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• UseDesc (type: esriFieldTypeString, alias: UseDesc, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• BuildingCategory (type: esriFieldTypeString, alias: BuildingCategory, SQL Type: sqlTypeOther, length: 21, nullable: true, editable: true)
• OregonBuildingCodeApplied (type: esriFieldTypeString, alias: OregonBuildingCodeApplied, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• ProposedLandUse (type: esriFieldTypeString, alias: ProposedLandUse, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• DeptCode (type: esriFieldTypeString, alias: DeptCode, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• Department (type: esriFieldTypeString, alias: Department, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• HB2306Path (type: esriFieldTypeString, alias: HB2306Path, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• HB2001ADU (type: esriFieldTypeString, alias: HB2001ADU, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• StormwaterMaintAgrmt (type: esriFieldTypeString, alias: StormwaterMaintAgrmt, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 350, nullable: true, editable: true)
• LOCID (type: esriFieldTypeInteger, alias: LOCID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SITEADDID (type: esriFieldTypeString, alias: SITEADDID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• TAXLOT (type: esriFieldTypeString, alias: TAXLOT, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
• CENTERLINEID (type: esriFieldTypeString, alias: CENTERLINEID, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• OverallStatus (type: esriFieldTypeString, alias: OverallStatus, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Migrated (type: esriFieldTypeString, alias: Migrated, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)

Templates:

Name: Permitting Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• PID: 0
• OldAppType:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2026 10:02:50 AM

Schema Last Edit Date: 8/13/2026 10:02:50 AM

Data Last Edit Date: 8/13/2026 10:02:32 AM

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