View In:   ArcGIS Online Map Viewer

Name: SWM Project Planning

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Capitol Projects by DoE SMD and CWP

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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: 1302391.5914270729
YMin: 327151.6094008982
XMax: 1402197.1008051634
YMax: 528099.0687256455
Spatial Reference: 102685  (2248)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: BuilderImplementor
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: CWP
  Label: Clean Water Partnership
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 197, 255, 255]
  Size: 7.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 0] Width: 1
• Value: DOE
  Label: DOE CIP
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [197, 0, 255, 255]
  Size: 7.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 0] Width: 1
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: BuilderImplementor

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• BuilderImplementor ( type: esriFieldTypeString, alias: Builder or Implementor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BuilderImplementor , Coded Values: [CWP: Clean Water Partnership] , [DOE: DOE CIP] )
• ProjectNumber ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNumber )
• ProjectName ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ProjectName )
• ConPurpose ( type: esriFieldTypeString, alias: Describe type of BMP construction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ConPurpose , Coded Values: [CONV: Conversion of Existing BMP] , [REDE: Redevelopment Project] , [REST: New Restoration Project] , ...2 more... )
• ProjectType ( type: esriFieldTypeString, alias: Project Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ProjectType , Coded Values: [FC: Flood Control] , [WQ: Water Quality] , [WQ-M: Water Quality - Maintenance] , ...2 more... )
• ProjectManager ( type: esriFieldTypeString, alias: Project Manager, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectManager )
• ProjectStatus ( type: esriFieldTypeString, alias: Project Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectStatus , Coded Values: [D: Design] , [HOLD: Hold] , [P: Planning] , ...6 more... )
• DropReason ( type: esriFieldTypeString, alias: Reason Dropped, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DropReason , Coded Values: [DAM: Dam Safety Conflict] , [IAT: Inadequate Treatment or TDML Obtained] , [NCE: Not Cost Effective] , ...3 more... )
• ProjectDescription ( type: esriFieldTypeString, alias: Project Description, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ProjectDescription )
• ProjectAddress ( type: esriFieldTypeString, alias: Project Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectAddress )
• ProjectCity ( type: esriFieldTypeString, alias: Project City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectCity )
• PropertyType ( type: esriFieldTypeString, alias: Property Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PropertyType )
• StartDate ( type: esriFieldTypeDate, alias: Project Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: StartDate )
• ApprovalDate ( type: esriFieldTypeDate, alias: Permit Approval Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ApprovalDate )
• BUILT_DATE ( type: esriFieldTypeDate, alias: As-built completion date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BUILT_DATE )
• EndDate ( type: esriFieldTypeDate, alias: Project End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EndDate )
• FiscYrComp ( type: esriFieldTypeString, alias: Proposed or Actual Fiscal Year Completed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FiscYrComp )
• RestorationCredit ( type: esriFieldTypeDouble, alias: Proposed or Actual Impervious Restoration Credit, editable: true, nullable: true, defaultValue: null, modelName: RestorationCredit )
• TN_REDUCTION ( type: esriFieldTypeDouble, alias: Total Nitrogen Reduced, editable: true, nullable: true, defaultValue: null, modelName: TN_REDUCTION )
• TP_REDUCTION ( type: esriFieldTypeDouble, alias: Total Phosphorus Reduced, editable: true, nullable: true, defaultValue: null, modelName: TP_REDUCTION )
• TSS_REDUCTION ( type: esriFieldTypeDouble, alias: Total Suspended Sediment Removed, editable: true, nullable: true, defaultValue: null, modelName: TSS_REDUCTION )
• ProjectBudget ( type: esriFieldTypeDouble, alias: Total Budgeted Cost for Project, editable: true, nullable: true, defaultValue: null, modelName: ProjectBudget )
• TotalDesign ( type: esriFieldTypeDouble, alias: Total Design Cost, editable: true, nullable: true, defaultValue: null, modelName: TotalDesign )
• TotalConstruction ( type: esriFieldTypeDouble, alias: Total Construction Cost, editable: true, nullable: true, defaultValue: null, modelName: TotalConstruction )
• TotalCompleted ( type: esriFieldTypeDouble, alias: Total Completed Cost for Project, editable: true, nullable: true, defaultValue: null, modelName: TotalCompleted )
• LandAcquisition ( type: esriFieldTypeDouble, alias: Land Acquisition Cost, editable: true, nullable: true, defaultValue: null, modelName: LandAcquisition )
• AnnualMaintenance ( type: esriFieldTypeDouble, alias: Annual Maintenance Cost, editable: true, nullable: true, defaultValue: null, modelName: AnnualMaintenance )
• Watershed_8 ( type: esriFieldTypeString, alias: Watershed 8, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Watershed_8 , Coded Values: [02140205: Anacostia River] , [02140111: Mattawoman Creek] , [02140204: Oxon Creek] , ...9 more... )
• Council ( type: esriFieldTypeString, alias: Council District, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Council , Coded Values: [1: District 1] , [2: District 2] , [3: District 3] , ...6 more... )
• Municipality ( type: esriFieldTypeString, alias: Municipality, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Municipality , Coded Values: [73: EAGLE HARBOR] , [74: GREENBELT] , [75: BERWYN HEIGHTS] , ...25 more... )
• created_user ( type: esriFieldTypeString, alias: Created by, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Date created, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Last edited by, 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ConStart ( type: esriFieldTypeDate, alias: Construction Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ConStart )
• ConEnd ( type: esriFieldTypeDate, alias: Construction End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ConEnd )
• PRMT_ISSUANCE_YR_CREDIT ( type: esriFieldTypeString, alias: MS4 Permit Term Credited for Restoration, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRMT_ISSUANCE_YR_CREDIT , Coded Values: [1994: 1st Generation Permit] , [1999: 2nd Generation Permit] , [2005: 3rd Generation Permit] , ...6 more... )
• EJ ( type: esriFieldTypeSmallInteger, alias: EJ Score, editable: true, nullable: true, defaultValue: null, modelName: EJ )
• NumBMPs ( type: esriFieldTypeSmallInteger, alias: Number of BMPs Built for Project, editable: true, nullable: true, defaultValue: null, modelName: NumBMPs )
• CaseNumber ( type: esriFieldTypeString, alias: Case Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CaseNumber )
• EJScore ( type: esriFieldTypeDouble, alias: EJ Score PGC, editable: true, nullable: true, defaultValue: null, modelName: EJScore )
• Concept ( type: esriFieldTypeString, alias: Concept (describe progress, easements, public involvement, issues, delays), editable: true, nullable: true, length: 500, defaultValue: null, modelName: Concept )
• DesignTO ( type: esriFieldTypeString, alias: Design Task Order (preparation, task order issued, delays), editable: true, nullable: true, length: 500, defaultValue: null, modelName: DesignTO )
• Constructability ( type: esriFieldTypeString, alias: Constructability Review (field evaluation, notes in plans, consultant coordination, delays), editable: true, nullable: true, length: 500, defaultValue: null, modelName: Constructability )
• BidProcess ( type: esriFieldTypeString, alias: Bid Process (procurement coordination, bid documents, QA/QC on all bid documents, delays), editable: true, nullable: true, length: 500, defaultValue: null, modelName: BidProcess )
• BidAward ( type: esriFieldTypeString, alias: Bid Award (Who was awarded, cost, issues, and delays), editable: true, nullable: true, length: 500, defaultValue: null, modelName: BidAward )
• PreCon ( type: esriFieldTypeString, alias: Pre-Construction (notice to proceed, amendments, issues, and delays), editable: true, nullable: true, length: 500, defaultValue: null, modelName: PreCon )
• Construction ( type: esriFieldTypeString, alias: Construction (public notice, signs, tracking progress, issues, and delays), editable: true, nullable: true, length: 500, defaultValue: null, modelName: Construction )
• Warranty ( type: esriFieldTypeString, alias: Warranty Period, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Warranty )
• PostMonitoring ( type: esriFieldTypeString, alias: Post Construction Monitoring Period, editable: true, nullable: true, length: 500, defaultValue: null, modelName: PostMonitoring )

Types:

ID: CWP
Name: Clean Water Partnership
Domains:
• BuilderImplementor:
  Inherited
• ConPurpose:
  Inherited
• ProjectType:
  Inherited
• ProjectStatus:
  Inherited
• DropReason:
  Inherited
• Watershed_8:
  Inherited
• Council:
  Inherited
• Municipality:
  Inherited
• PRMT_ISSUANCE_YR_CREDIT:
  Inherited
Templates:
• Name: CWP
  Description:
  Prototype:
  Warranty: null
  Construction: null
  BuilderImplementor: CWP
  ProjectNumber: null
  ProjectName: null
  ConPurpose: null
  ProjectType: null
  ProjectManager: null
  ProjectStatus: null
  DropReason: null
  ProjectDescription: null
  ProjectAddress: null
  ProjectCity: null
  PropertyType: null
  StartDate: null
  ApprovalDate: null
  BUILT_DATE: null
  EndDate: null
  FiscYrComp: null
  RestorationCredit: null
  TN_REDUCTION: null
  TP_REDUCTION: null
  TSS_REDUCTION: null
  ProjectBudget: null
  TotalDesign: null
  TotalConstruction: null
  TotalCompleted: null
  LandAcquisition: null
  AnnualMaintenance: null
  Watershed_8: null
  Council: null
  Municipality: null
  PreCon: null
  BidAward: null
  BidProcess: null
  Constructability: null
  PostMonitoring: null
  ConStart: null
  ConEnd: null
  PRMT_ISSUANCE_YR_CREDIT: null
  EJ: null
  NumBMPs: null
  CaseNumber: null
  EJScore: null
  Concept: null
  DesignTO: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: DOE
Name: DOE CIP
Domains:
• BuilderImplementor:
  Inherited
• ConPurpose:
  Inherited
• ProjectType:
  Inherited
• ProjectStatus:
  Inherited
• DropReason:
  Inherited
• Watershed_8:
  Inherited
• Council:
  Inherited
• Municipality:
  Inherited
• PRMT_ISSUANCE_YR_CREDIT:
  Inherited
Templates:
• Name: DOE
  Description:
  Prototype:
  Warranty: null
  Construction: null
  BuilderImplementor: DOE
  ProjectNumber: null
  ProjectName: null
  ConPurpose: null
  ProjectType: null
  ProjectManager: null
  ProjectStatus: null
  DropReason: null
  ProjectDescription: null
  ProjectAddress: null
  ProjectCity: null
  PropertyType: null
  StartDate: null
  ApprovalDate: null
  BUILT_DATE: null
  EndDate: null
  FiscYrComp: null
  RestorationCredit: null
  TN_REDUCTION: null
  TP_REDUCTION: null
  TSS_REDUCTION: null
  ProjectBudget: null
  TotalDesign: null
  TotalConstruction: null
  TotalCompleted: null
  LandAcquisition: null
  AnnualMaintenance: null
  Watershed_8: null
  Council: null
  Municipality: null
  PreCon: null
  BidAward: null
  BidProcess: null
  Constructability: null
  PostMonitoring: null
  ConStart: null
  ConEnd: null
  PRMT_ISSUANCE_YR_CREDIT: null
  EJ: null
  NumBMPs: null
  CaseNumber: null
  EJScore: null
  Concept: null
  DesignTO: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• ESD_Structural_BMP (3) -- Related To: ESD and Structural BMP (0)
• AlternativeBMP_Linear (6) -- Related To: Alternative BMP-Linear (1)
• AlternativeBMP_Area (9) -- Related To: Alternative BMP-Area (48)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: 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 Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata