View In:   ArcGIS Online Map Viewer

Name: Smooth Streets Project

Display Field: GEOCODEID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000

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: 390331.4425000027
YMin: 128066.76000000164
XMax: 407757.2800000012
YMax: 147318.74219999835
Spatial Reference: 26985  (26985)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: UTILITY
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: DC Water
  Label: DC Water
  Description: N/A
  Symbol:
  
• Value: Pepco
  Label: Pepco
  Description: N/A
  Symbol:
  
• Value: Verizon
  Label: Verizon
  Description: N/A
  Symbol:
  
• Value: Washington Gas
  Label: Washington Gas
  Description: N/A
  Symbol:
  
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: UTILITY

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GEOCODEID ( type: esriFieldTypeString, alias: GeocodeID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GeocodeID )
• OTHERID ( type: esriFieldTypeDouble, alias: OtherID, editable: true, nullable: true, defaultValue: null, modelName: OtherID )
• DDOT_ID1 ( type: esriFieldTypeString, alias: DDOT_ID1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DDOT_ID1 )
• DDOT_ID2 ( type: esriFieldTypeString, alias: DDOT_ID2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DDOT_ID2 )
• QUADRANT ( type: esriFieldTypeSmallInteger, alias: QUADRANT, editable: true, nullable: true, defaultValue: null, modelName: QUAD , Coded Values: [1: NW] , [2: NE] , [3: SE] , ...3 more... )
• WARD ( type: esriFieldTypeSmallInteger, alias: WARD, editable: true, nullable: true, defaultValue: null, modelName: WARD_ , Coded Values: [0: Unknown] , [1: 1] , [2: 2] , ...6 more... )
• ADDR_NUM ( type: esriFieldTypeString, alias: Addr_Num, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Addr_Num )
• STREET_ORIG ( type: esriFieldTypeString, alias: Street_Orig, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Street_Orig )
• STREET_CORRECTED ( type: esriFieldTypeString, alias: Street_Corrected, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Street_Corrected )
• ADDRESSSTAGING ( type: esriFieldTypeString, alias: AddressStaging, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AddressStaging )
• GEOCODE_ADDR ( type: esriFieldTypeString, alias: Geocode_Addr, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Geocode_Addr )
• WORKTYPE ( type: esriFieldTypeString, alias: WorkType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WorkType )
• EXCAVSIZE ( type: esriFieldTypeString, alias: ExcavSize, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ExcavSize )
• AREAEXCAV ( type: esriFieldTypeString, alias: AreaExcav, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AreaExcav )
• TEMPCOMPLON ( type: esriFieldTypeDate, alias: TempComplOn, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TempComplOn )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )
• UTILITY ( type: esriFieldTypeString, alias: Utility, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Utility )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Inspector , Coded Values: [Andre Powell: Andre Powell] , [Charles Mongomery: Charles Mongomery] , [David Hill: David Hill] , ...25 more... )
• MAR_WARD ( type: esriFieldTypeString, alias: MAR_WARD, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAR_WARD )
• X_COORD ( type: esriFieldTypeDouble, alias: x_coord, editable: true, nullable: true, defaultValue: null, modelName: x_coord )
• Y_COORD ( type: esriFieldTypeDouble, alias: y_coord, editable: true, nullable: true, defaultValue: null, modelName: y_coord )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )
• INSPECTORNOTES ( type: esriFieldTypeString, alias: INSPECTORNOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: INSPECTORNOTES )
• RESTORATION_STATUS ( type: esriFieldTypeString, alias: Restoration_Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RESTORATION_STATUS , Coded Values: [Not Inspected: Not Inspected] , [Initial Inspection Complete: Initial Inspection Complete] , [Restoration Complete: Restoration Complete] )
• MARKED ( type: esriFieldTypeDate, alias: MARKED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MARKED )
• MARKED_DIMENSIONS ( type: esriFieldTypeString, alias: MARKED_DIMENSIONS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MARKED_DIMENSIONS )
• MULTIPLE_LOCS ( type: esriFieldTypeString, alias: MULTIPLE_LOCS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MULTIPLE_LOCS , Coded Values: [YES: YES] , [NO: NO] )
• SIDEWALK ( type: esriFieldTypeString, alias: SIDEWALK, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIDEWALK , Coded Values: [YES: YES] , [NO: NO] )
• YEAR ( type: esriFieldTypeInteger, alias: YEAR, editable: true, nullable: true, defaultValue: null, modelName: YEAR )

Types:

ID: DC Water
Name: DC Water
Domains:
• QUADRANT:
  Inherited
• WARD:
  Inherited
• INSPECTOR:
  Inherited
• RESTORATION_STATUS:
  Inherited
• MULTIPLE_LOCS:
  Inherited
• SIDEWALK:
  Inherited
Templates:
• Name: DC Water
  Description:
  Prototype:
  NOTES: null
  SIDEWALK: null
  GEOCODEID: null
  OTHERID: null
  DDOT_ID1: null
  DDOT_ID2: null
  QUADRANT: null
  WARD: null
  ADDR_NUM: null
  STREET_ORIG: null
  STREET_CORRECTED: null
  ADDRESSSTAGING: null
  GEOCODE_ADDR: null
  WORKTYPE: null
  EXCAVSIZE: null
  AREAEXCAV: null
  TEMPCOMPLON: null
  UTILITY: DC Water
  INSPECTOR: null
  MAR_WARD: null
  X_COORD: null
  Y_COORD: null
  YEAR: null
  MULTIPLE_LOCS: null
  MARKED_DIMENSIONS: null
  MARKED: null
  INSPECTORNOTES: null
  RESTORATION_STATUS: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Pepco
Name: Pepco
Domains:
• QUADRANT:
  Inherited
• WARD:
  Inherited
• INSPECTOR:
  Inherited
• RESTORATION_STATUS:
  Inherited
• MULTIPLE_LOCS:
  Inherited
• SIDEWALK:
  Inherited
Templates:
• Name: Pepco
  Description:
  Prototype:
  NOTES: null
  SIDEWALK: null
  GEOCODEID: null
  OTHERID: null
  DDOT_ID1: null
  DDOT_ID2: null
  QUADRANT: null
  WARD: null
  ADDR_NUM: null
  STREET_ORIG: null
  STREET_CORRECTED: null
  ADDRESSSTAGING: null
  GEOCODE_ADDR: null
  WORKTYPE: null
  EXCAVSIZE: null
  AREAEXCAV: null
  TEMPCOMPLON: null
  UTILITY: Pepco
  INSPECTOR: null
  MAR_WARD: null
  X_COORD: null
  Y_COORD: null
  YEAR: null
  MULTIPLE_LOCS: null
  MARKED_DIMENSIONS: null
  MARKED: null
  INSPECTORNOTES: null
  RESTORATION_STATUS: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Verizon
Name: Verizon
Domains:
• QUADRANT:
  Inherited
• WARD:
  Inherited
• INSPECTOR:
  Inherited
• RESTORATION_STATUS:
  Inherited
• MULTIPLE_LOCS:
  Inherited
• SIDEWALK:
  Inherited
Templates:
• Name: Verizon
  Description:
  Prototype:
  NOTES: null
  SIDEWALK: null
  GEOCODEID: null
  OTHERID: null
  DDOT_ID1: null
  DDOT_ID2: null
  QUADRANT: null
  WARD: null
  ADDR_NUM: null
  STREET_ORIG: null
  STREET_CORRECTED: null
  ADDRESSSTAGING: null
  GEOCODE_ADDR: null
  WORKTYPE: null
  EXCAVSIZE: null
  AREAEXCAV: null
  TEMPCOMPLON: null
  UTILITY: Verizon
  INSPECTOR: null
  MAR_WARD: null
  X_COORD: null
  Y_COORD: null
  YEAR: null
  MULTIPLE_LOCS: null
  MARKED_DIMENSIONS: null
  MARKED: null
  INSPECTORNOTES: null
  RESTORATION_STATUS: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Washington Gas
Name: Washington Gas
Domains:
• QUADRANT:
  Inherited
• WARD:
  Inherited
• INSPECTOR:
  Inherited
• RESTORATION_STATUS:
  Inherited
• MULTIPLE_LOCS:
  Inherited
• SIDEWALK:
  Inherited
Templates:
• Name: Washington Gas
  Description:
  Prototype:
  NOTES: null
  SIDEWALK: null
  GEOCODEID: null
  OTHERID: null
  DDOT_ID1: null
  DDOT_ID2: null
  QUADRANT: null
  WARD: null
  ADDR_NUM: null
  STREET_ORIG: null
  STREET_CORRECTED: null
  ADDRESSSTAGING: null
  GEOCODE_ADDR: null
  WORKTYPE: null
  EXCAVSIZE: null
  AREAEXCAV: null
  TEMPCOMPLON: null
  UTILITY: Washington Gas
  INSPECTOR: null
  MAR_WARD: null
  X_COORD: null
  Y_COORD: null
  YEAR: null
  MULTIPLE_LOCS: null
  MARKED_DIMENSIONS: null
  MARKED: null
  INSPECTORNOTES: null
  RESTORATION_STATUS: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata