View In:   ArcGIS Online Map Viewer

Name: Punchlist Inspections

Display Field: sysgen_districtname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: soe_dev_ext_transactional.SOE_DATAOWNER.pwu_inspection

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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.14528692608E7
YMin: 3000865.0469000004
XMax: -1.04363896232E7
YMax: 4344610.448100001
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [38, 175, 102, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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:

• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid )
• inspectionstatus ( type: esriFieldTypeString, alias: Inspection Status, editable: true, nullable: true, length: 255, defaultValue: NewInspection, modelName: inspection_type , Coded Values: [ItemComplete: Item Complete] , [NewInspection: New Inspection] )
• reinspectiondate ( type: esriFieldTypeDate, alias: Accepted Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: reinspection_date )
• itemcode ( type: esriFieldTypeString, alias: Item Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: item_code , Coded Values: [100: Preparing Right of Way 100] , [103: Disposal of Wells 103] , [104: Removing Concrete 104] , ...211 more... )
• othercode ( type: esriFieldTypeString, alias: Other Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: why_other )
• reinspectioninitials ( type: esriFieldTypeString, alias: Accepted By, editable: true, nullable: true, length: 10, defaultValue: null, modelName: initials )
• contractor ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: contractor )
• issuedesc ( type: esriFieldTypeString, alias: Issue Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: issue_desc )
• addphoto2 ( type: esriFieldTypeString, alias: Add Photo 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: more_pictures , Coded Values: [Yes: Yes] , [No: No] )
• addphoto3 ( type: esriFieldTypeString, alias: Add Photo 3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: more_pictures2 , Coded Values: [Yes: Yes] , [No: No] )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• recommendedaction ( type: esriFieldTypeString, alias: Recommended Action, editable: true, nullable: true, length: 500, defaultValue: null, modelName: RecommendedAction )
• sysgen_districtname ( type: esriFieldTypeString, alias: District Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: sysgen_districtname )
• sysgen_districtnumber ( type: esriFieldTypeInteger, alias: District Number, editable: true, nullable: true, defaultValue: null, modelName: sysgen_districtnumber )
• sysgen_districtconcat ( type: esriFieldTypeString, alias: District Number and Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: sysgen_districtconcat )
• sysgen_countyname ( type: esriFieldTypeString, alias: County Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: sysgen_countyname )
• sysgen_countynumber ( type: esriFieldTypeInteger, alias: County Number, editable: true, nullable: true, defaultValue: null, modelName: sysgen_countynumber )
• sysgen_countyconcat ( type: esriFieldTypeString, alias: County Number and Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: sysgen_countyconcat )
• sysgen_countyfips ( type: esriFieldTypeInteger, alias: County FIPS, editable: true, nullable: true, defaultValue: null, modelName: sysgen_countyfips )
• sysgen_cityname ( type: esriFieldTypeString, alias: City Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: sysgen_cityname )
• sysgen_citynumber ( type: esriFieldTypeInteger, alias: City Number, editable: true, nullable: true, defaultValue: null, modelName: sysgen_citynumber )
• sysgen_cityfips ( type: esriFieldTypeInteger, alias: City FIPS, editable: true, nullable: true, defaultValue: null, modelName: sysgen_cityfips )
• sysgen_areaoffice ( type: esriFieldTypeString, alias: Area Office, editable: true, nullable: true, length: 50, defaultValue: null, modelName: sysgen_areaoffice )
• sysgen_latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: sysgen_latitude )
• sysgen_longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: sysgen_longitude )
• sysgen_highwaynumber ( type: esriFieldTypeString, alias: Highway Number (TxDOT Projects), editable: true, nullable: true, length: 10, defaultValue: null, modelName: sysgen_highwaynumber )
• sysgen_worktype ( type: esriFieldTypeString, alias: Type of Work (TxDOT Projects), editable: true, nullable: true, length: 50, defaultValue: null, modelName: sysgen_worktype )
• sysgen_maintenancesection ( type: esriFieldTypeInteger, alias: Nearest Maintenance Section, editable: true, nullable: true, defaultValue: null, modelName: sysgen_maintenancesection )
• reportdate ( type: esriFieldTypeDate, alias: Report Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: reportdate )
• reportstatus ( type: esriFieldTypeString, alias: Report Status, editable: true, nullable: true, length: 15, defaultValue: null, modelName: reportstatus , Coded Values: [Complete: Complete] , [Final: Final] , [Interim: Interim] )
• projectnumber ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: projectnumber )
• sysgen_reportaging ( type: esriFieldTypeString, alias: Report Aging, editable: true, nullable: true, length: 255, defaultValue: New Inspection, modelName: reportaging , Coded Values: [New Inspection: New Inspection] , [In Progress: In Progress] , [Aging: Aging] , ...1 more... )
• sysgen_inspectionid ( type: esriFieldTypeInteger, alias: Inspection ID, editable: true, nullable: true, defaultValue: null, modelName: sysgen_inspectionid )
• initialreportdate ( type: esriFieldTypeDate, alias: Initial Report Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: initialreportdate )
• csj ( type: esriFieldTypeString, alias: Control Section Job, editable: true, nullable: true, length: 9, defaultValue: null, modelName: csj )
• objectid ( type: esriFieldTypeOID, alias: ObjectID, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• districtname ( type: esriFieldTypeString, alias: User Selected District Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: districtname )
• areaoffice ( type: esriFieldTypeString, alias: User Selected Area Office, editable: true, nullable: true, length: 50, defaultValue: null, modelName: areaoffice )

Templates:

• Name: New Punchlist Item
  Description:
  Prototype:
  areaoffice: null
  projectnumber: null
  districtname: null
  inspectionstatus: NewInspection
  reinspectiondate: null
  itemcode: null
  othercode: null
  reinspectioninitials: null
  contractor: null
  issuedesc: null
  addphoto2: null
  addphoto3: null
  csj: null
  initialreportdate: null
  sysgen_inspectionid: null
  sysgen_reportaging: New Inspection
  recommendedaction: null
  sysgen_districtname: null
  sysgen_districtnumber: null
  sysgen_districtconcat: null
  sysgen_countyname: null
  sysgen_countynumber: null
  sysgen_countyconcat: null
  sysgen_countyfips: null
  sysgen_cityname: null
  sysgen_citynumber: null
  sysgen_cityfips: null
  sysgen_areaoffice: null
  sysgen_latitude: null
  sysgen_longitude: null
  sysgen_highwaynumber: null
  sysgen_worktype: null
  sysgen_maintenancesection: null
  reportdate: null
  reportstatus: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync,Extract,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: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

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