Name: Large_Project_Excavation_Permits

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"symbol":{"color":[0,178,255,255],"style":"esriSLSSolid","type":"esriSLS","width":2},"type":"simple","label":"Large Project Excavation Permits"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• appname (type: esriFieldTypeString, alias: Applicant Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• appreporg (type: esriFieldTypeString, alias: Representing Organization, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• appaddr (type: esriFieldTypeString, alias: Applicant Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• appcity (type: esriFieldTypeString, alias: Applicant City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• appstate (type: esriFieldTypeString, alias: Applicant State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [AL: AL], [AK: AK], [AZ: AZ], ... 47 more ...)
• appzip (type: esriFieldTypeString, alias: Applicant Zip, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• appphone (type: esriFieldTypeString, alias: Applicant Phone, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• appemail (type: esriFieldTypeString, alias: Applicant Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• role (type: esriFieldTypeString, alias: Applicant Role, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [contractor: Contractor], [utility: Public or Private Utility Representative], [representative: Authorized Representative])
• ownername (type: esriFieldTypeString, alias: Owner Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• ownerphone (type: esriFieldTypeString, alias: Owner Phone, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• owneremail (type: esriFieldTypeString, alias: Owner Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• sameapp (type: esriFieldTypeString, alias: Contractor Same as Applicant, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• contname (type: esriFieldTypeString, alias: Contractor Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• contaddr (type: esriFieldTypeString, alias: Contractor Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• contcity (type: esriFieldTypeString, alias: Contractor City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• contstate (type: esriFieldTypeString, alias: Contractor State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• contzip (type: esriFieldTypeString, alias: Contractor Zip, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• contphone (type: esriFieldTypeString, alias: Contractor Phone, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• contemail (type: esriFieldTypeString, alias: Contractor Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• fieldrep_name (type: esriFieldTypeString, alias: Owner Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• fieldrep_phone (type: esriFieldTypeString, alias: Owner Phone, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• fieldrep_email (type: esriFieldTypeString, alias: Owner Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• description (type: esriFieldTypeString, alias: Project Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• type (type: esriFieldTypeString, alias: Permit Type, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Trenching: Open cut trenching], [Boring: Underground boring], [Utility: Above ground utility], ... 2 more ...)
• propstartdt (type: esriFieldTypeDate, alias: Proposed Start Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• propenddt (type: esriFieldTypeDate, alias: Estimated Completion Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• laneclosure (type: esriFieldTypeString, alias: Lane Closure Required, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• submitdt (type: esriFieldTypeDate, alias: Submission Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• appagreement (type: esriFieldTypeString, alias: Terms and Conditions Agreement, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [agree: I agree to the above mentioned Excavation Permit terms and conditions.])
• status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true, Coded Values: [Submitted: Submitted], [UnderReview: Under Review], [Approved: Approved], ... 1 more ...)
• moreinfo (type: esriFieldTypeString, alias: More Information Required, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• bondedinsured (type: esriFieldTypeString, alias: Bonded and Insured, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• bond (type: esriFieldTypeString, alias: Bond Expires, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cert_ins_exp (type: esriFieldTypeDate, alias: Insurance Expires, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• receipt_no (type: esriFieldTypeInteger, alias: Receipt Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• permit_number (type: esriFieldTypeString, alias: Permit Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• actiondt (type: esriFieldTypeDate, alias: Approved or Denied Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• apprstartdt (type: esriFieldTypeDate, alias: Approved Start Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• apprenddt (type: esriFieldTypeDate, alias: Approved Completion Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• subgrade_insp (type: esriFieldTypeDate, alias: Subgrade Inspection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• subgrade_insp_status (type: esriFieldTypeString, alias: Subgrade Inspection Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• final_insp (type: esriFieldTypeDate, alias: Final Inspection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• final_insp_status (type: esriFieldTypeString, alias: Final Inspection Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/21/2026 5:44:42 PM

Schema Last Edit Date: 9/21/2026 5:44:42 PM

Data Last Edit Date: 9/21/2026 5:44:42 PM

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