View In:   ArcGIS Online Map Viewer

Name: Excavation Permit Points

Display Field: PtName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Savede a separate copy of the *.mxd for a feature service for internal management of the Excavation Permits after the Survey123 Form is submitted. This *.mxd's feature service is on gis-arcsrv-01, and the other *.mxd in this forlder is the feature service for the 'non-federated' service that is used by the Survey123 Connect Forms.

Service Item Id: 5d36f6b2b5c344b78cda648e1680cba6

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -1.0780712193711994E7
YMin: 5912485.764172611
XMax: -1.067853054739806E7
YMax: 6210172.155498769
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• PtPermitNumber ( type: esriFieldTypeString, alias: Permit Number, editable: true, nullable: true, length: 12, defaultValue: null, modelName: PermitNumber )
• PtExcavationType ( type: esriFieldTypeString, alias: Excavation Type, editable: true, nullable: true, length: 40, defaultValue: null, modelName: ExcavationType , Coded Values: [Street Surface: Street Surface] , [Boulevard: Boulevard] , [Boring - Trenching: Boring - Trenching] )
• PtExcavationContractor ( type: esriFieldTypeString, alias: Excavation Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ExcavationContractor , Coded Values: [Xcel Energy: Xcel Energy] , [Moorhead Public Service: Moorhead Public Service] , [Master Construction: Master Construction] , ...29 more... )
• PtLinearFeet ( type: esriFieldTypeDouble, alias: Linear Feet, editable: true, nullable: true, defaultValue: null, modelName: LinearFeet )
• PtSquareFeet ( type: esriFieldTypeDouble, alias: Square Feet, editable: true, nullable: true, defaultValue: null, modelName: SquareFeet )
• PtNumber_of_ADARamps ( type: esriFieldTypeSmallInteger, alias: Number of ADA Ramps, editable: true, nullable: true, defaultValue: null, modelName: Number_of_ADARamps )
• PtNumber_of_BorePits ( type: esriFieldTypeSmallInteger, alias: Number of Bore Pits, editable: true, nullable: true, defaultValue: null, modelName: Number_of_BorePits )
• PtNumber_of_Inlets ( type: esriFieldTypeSmallInteger, alias: Number of Inlets, editable: true, nullable: true, defaultValue: null, modelName: Number_of_Inlets )
• PtPublicPrivateUtility ( type: esriFieldTypeString, alias: Public Private Utility, editable: true, nullable: true, length: 16, defaultValue: null, modelName: PublicPrivateUtility , Coded Values: [Public Utility: Public Utility] , [Private Utility: Private Utility] )
• PtWorkStartDate ( type: esriFieldTypeDate, alias: Work Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WorkStartDate )
• PtWorkEndDate ( type: esriFieldTypeDate, alias: Work End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WorkEndDate )
• PtRestorationCompleteDate ( type: esriFieldTypeDate, alias: Restoration Complete Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RestorationCompleteDate )
• PtTrafficAffected ( type: esriFieldTypeString, alias: Traffic Affected, editable: true, nullable: true, length: 3, defaultValue: null, modelName: TrafficAffected , Coded Values: [Yes: Yes] , [No: No] , [Hol: Hold] )
• PtPermitIssuedTo ( type: esriFieldTypeString, alias: PermitIssued To, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PermitIssuedTo , Coded Values: [Contractor: Contractor] , [Party: Party] )
• PtBondWithCity ( type: esriFieldTypeString, alias: Bond With City, editable: true, nullable: true, length: 3, defaultValue: null, modelName: BondWithCity , Coded Values: [Yes: Yes] , [No: No] , [Hol: Hold] )
• PtBondExpirationDate ( type: esriFieldTypeDate, alias: Bond Expiration Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BondExpirationDate )
• PtDescriptionOfWork ( type: esriFieldTypeString, alias: Description of Work, editable: true, nullable: true, length: 500, defaultValue: null, modelName: DescriptionOfWork )
• PtComments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Comments )
• PtCertificate_of_Completion ( type: esriFieldTypeString, alias: Certificate of Completion, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Certificate_of_Completion , Coded Values: [Yes: Yes] , [No: No] , [Hol: Hold] )
• PtEmergencyContact ( type: esriFieldTypeString, alias: Emergency Contact, editable: true, nullable: true, length: 40, defaultValue: null, modelName: EmergencyContact )
• PtName ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 40, defaultValue: null, modelName: PartyName )
• PtPhone ( type: esriFieldTypeString, alias: Phone, editable: true, nullable: true, length: 16, defaultValue: null, modelName: PartyPhone )
• PtPhoneExtension ( type: esriFieldTypeString, alias: Phone Extension, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PartyPhoneExtension )
• PtFax ( type: esriFieldTypeString, alias: Fax, editable: true, nullable: true, length: 16, defaultValue: null, modelName: PartyFax )
• PtFaxExtension ( type: esriFieldTypeString, alias: Fax Extension, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PartyFaxExtension )
• PtAddress ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 80, defaultValue: null, modelName: PartyAddress )
• PtContactEMail ( type: esriFieldTypeString, alias: Contact EMail, editable: true, nullable: true, length: 40, defaultValue: null, modelName: ContactEMail )
• PtCreatedBy ( type: esriFieldTypeString, alias: CreatedBy, editable: false, nullable: true, length: 36, defaultValue: null, modelName: CreatedBy )
• PtCreatedDate ( type: esriFieldTypeDate, alias: CreatedDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )
• PtModifyBy ( type: esriFieldTypeString, alias: ModifyBy, editable: false, nullable: true, length: 36, defaultValue: null, modelName: ModifyBy )
• PtModifyDate ( type: esriFieldTypeDate, alias: ModifyDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: ModifyDate )
• PtFee ( type: esriFieldTypeDouble, alias: Fee, editable: true, nullable: true, defaultValue: null, modelName: Fee )
• PtFee2 ( type: esriFieldTypeDouble, alias: Fee 2, editable: true, nullable: true, defaultValue: null, modelName: Fee2 )
• PtParentGUID ( type: esriFieldTypeGUID, alias: Parent GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PtParentGUID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PtPermitStatus ( type: esriFieldTypeString, alias: Permit Status, editable: true, nullable: true, length: 24, defaultValue: null, modelName: PermitStatus , Coded Values: [Declined: Declined] , [Failed Inspection: Failed Inspection] , [Restoration Passed: Restoration Passed] , ...2 more... )
• PtExcavationSize ( type: esriFieldTypeString, alias: Excavation Size, editable: true, nullable: true, length: 12, defaultValue: null, modelName: PtExcavationSize )

Templates:

• Name: Excavation Permit Points
  Description:
  Prototype:
  PtPermitStatus: null
  PtPermitNumber: null
  PtExcavationType: null
  PtExcavationContractor: null
  PtLinearFeet: null
  PtSquareFeet: null
  PtNumber_of_ADARamps: null
  PtNumber_of_BorePits: null
  PtNumber_of_Inlets: null
  PtPublicPrivateUtility: null
  PtWorkStartDate: null
  PtWorkEndDate: null
  PtRestorationCompleteDate: null
  PtTrafficAffected: null
  PtPermitIssuedTo: null
  PtBondWithCity: null
  PtBondExpirationDate: null
  PtDescriptionOfWork: null
  PtComments: null
  PtCertificate_of_Completion: null
  PtEmergencyContact: null
  PtName: null
  PtPhone: null
  PtPhoneExtension: null
  PtFax: null
  PtFaxExtension: null
  PtAddress: null
  PtContactEMail: null
  PtExcavationSize: null
  PtParentGUID: null
  PtFee2: null
  PtFee: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: PtCreatedDate
• Creator Field: PtCreatedBy
• Edit Date Field: PtModifyDate
• Editor Field: PtModifyBy

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

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