View In:   ArcGIS Online Map Viewer

Name: CIP Stormwater

Display Field: A_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="margin:0 0 0 0;"><SPAN>Stormwater layer provides up to date information on active CIP projects involving sewer lines, pump stations, and local drainage projects </SPAN><SPAN>that are in various stages such as Future (Unfunded/ Unscheduled) (F), Future Programmed (FP), Programmed (P), Design (E), Pending Construction (PC), Construction (C) and Complete (CP).</SPAN></P><P><SPAN /></P></DIV></DIV></DIV><DIV><P>This layer was last updated: 2023-09-18 09:08:07.499628.</P></DIV>

Copyright Text: Disclaimer: This COH data is prepared and made available for general reference purposes only and should not be used, or relied upon for specific applications, without independent verification. The City of Houston neither represents, nor warrants data accuracy, or completeness, nor will the City of Houston accept liability of any kind in conjunction with its use.

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: 3008796.8392143846
YMin: 1.3772145747545227E7
XMax: 3243183.5672903806
YMax: 1.3961236048497722E7
Spatial Reference: 102740  (2278)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [170, 138, 51, 255]
Width: 1
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• A_NAME ( type: esriFieldTypeString, alias: Agency Name, editable: true, nullable: true, length: 22, defaultValue: COH, modelName: AGENCY )
• DEPT_NAME ( type: esriFieldTypeString, alias: Department Name, editable: true, nullable: true, length: 22, defaultValue: STORM, modelName: DEPARTMENT )
• CIP_NUM ( type: esriFieldTypeString, alias: CIP Number, editable: true, nullable: true, length: 13, defaultValue: M-000, modelName: CIP_NO )
• PROJECTNUM ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 13, defaultValue: M-000, modelName: PROJ_NO )
• FILE_NUM ( type: esriFieldTypeString, alias: File Number, editable: true, nullable: true, length: 10, defaultValue: SM, modelName: FILE_NO )
• PROJ_DCSR ( type: esriFieldTypeString, alias: Project Description, editable: true, nullable: false, length: 100, defaultValue: M_AJ, modelName: PRO_DESC )
• PROJ_SCOPE ( type: esriFieldTypeString, alias: Project Scope, editable: true, nullable: true, length: 225, defaultValue: null, modelName: PRO_SCOPE )
• KEY_MAP ( type: esriFieldTypeString, alias: Key Map, editable: true, nullable: true, length: 200, defaultValue: null, modelName: KEY_MAP )
• DESIGN_ENG ( type: esriFieldTypeString, alias: Design Engineering Co, editable: true, nullable: true, length: 55, defaultValue: null, modelName: DES_ENGR )
• DESPRO_MGR ( type: esriFieldTypeString, alias: Design Project Manager, editable: true, nullable: true, length: 25, defaultValue: null, modelName: DPRO_MAN )
• DESPRMGRPH ( type: esriFieldTypeString, alias: Design Project Manager Phone, editable: true, nullable: true, length: 14, defaultValue: null, modelName: DPRO_MAN_P )
• CONPRO_MGR ( type: esriFieldTypeString, alias: Construction Project Manager, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CPRO_MAN )
• CONPRMGRPH ( type: esriFieldTypeString, alias: Construction Project Manager Phone, editable: true, nullable: true, length: 14, defaultValue: null, modelName: CPRO_MAN_P )
• CONSTR_CO ( type: esriFieldTypeString, alias: Construction Company, editable: true, nullable: true, length: 55, defaultValue: null, modelName: CONTR )
• CONSTARTYR ( type: esriFieldTypeDate, alias: Construction Start Year, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONST_STAR )
• CON_END_YR ( type: esriFieldTypeDate, alias: Construction End Year, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONST_END )
• MOD_DATE ( type: esriFieldTypeDate, alias: Modified Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MOD_DATE )
• MOD_CODE ( type: esriFieldTypeString, alias: Modified Code, editable: true, nullable: true, length: 4, defaultValue: M_AJ, modelName: MOD_CODE )
• SUPERNEIGH ( type: esriFieldTypeString, alias: Super Neighborhood, editable: true, nullable: true, length: 125, defaultValue: null, modelName: SNAP )
• REMARKS ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 225, defaultValue: null, modelName: REMARKS )
• CN_MEM ( type: esriFieldTypeString, alias: Council Member, editable: true, nullable: true, length: 25, defaultValue: null, modelName: COUN_MEMBE )
• DES_FY ( type: esriFieldTypeInteger, alias: Design Fiscal Year, editable: true, nullable: true, defaultValue: null, modelName: DES_FY )
• CON_FY ( type: esriFieldTypeInteger, alias: Construction Fiscal Year, editable: true, nullable: true, defaultValue: null, modelName: CON_FY )
• ENTRY_DATE ( type: esriFieldTypeDate, alias: Entry Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ENTRY_DATE )
• DRAWING_NO ( type: esriFieldTypeString, alias: Drawing Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DRAWING_NO )
• CIPMS_STAT ( type: esriFieldTypeString, alias: Status on CIPMS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CIPMS_STATUS )
• COUNCIL ( type: esriFieldTypeString, alias: Council District, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COUN_DIST )
• TRACKNO ( type: esriFieldTypeInteger, alias: Tracking Number, editable: true, nullable: true, defaultValue: null, modelName: TRACKNO )
• P_COST ( type: esriFieldTypeInteger, alias: Project Cost, editable: true, nullable: true, defaultValue: null, modelName: COST )
• WorkOrder ( type: esriFieldTypeSmallInteger, alias: Work Order Number, editable: true, nullable: true, defaultValue: null, modelName: WorkOrder )
• PROJ_TYPE ( type: esriFieldTypeString, alias: Project Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROJ_TYPE )
• PROJ_STAGE ( type: esriFieldTypeString, alias: Stage, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROJ_STAGE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )

Templates:

• Name: CIP Stormwater
  Description:
  Prototype:
  LATITUDE: null
  LONGITUDE: null
  A_NAME: COH
  DEPT_NAME: STORM
  CIP_NUM: M-000
  PROJECTNUM: M-000
  FILE_NUM: SM
  PROJ_DCSR: M_AJ
  PROJ_SCOPE: null
  KEY_MAP: null
  DESIGN_ENG: null
  DESPRO_MGR: null
  DESPRMGRPH: null
  CONPRO_MGR: null
  CONPRMGRPH: null
  CONSTR_CO: null
  CONSTARTYR: null
  CON_END_YR: null
  MOD_DATE: null
  MOD_CODE: M_AJ
  SUPERNEIGH: null
  REMARKS: null
  CN_MEM: null
  DES_FY: null
  CON_FY: null
  ENTRY_DATE: null
  DRAWING_NO: null
  CIPMS_STAT: null
  COUNCIL: null
  TRACKNO: null
  P_COST: null
  WorkOrder: null
  PROJ_TYPE: null
  PROJ_STAGE: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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