Name: LACoPW Merged Project Polygon

Display Field: PROJECT_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Integrating GIS feature classes with flat table data from other databases is a common goal. Previously, this was done using spatial views and DB links; however, the draw and query performance suffered. To work around performance bottlenecks, an ETL (extract-transform-load) process was chosen so that a single feature class is created. It means that the data is no longer live, but updated periodically.An ITD Task Scheduler runs the update link every weekday (Monday through Friday). Users involved in a project typically request SMP for geometry at the following link (replace PROJECT_ID with the appropriate alphanumeric string): https://apps.intranet/prjmgt/piw3/location.aspx?project_id=PROJECT_ID The feature class is used in the following applications:ViewLA http://pwgis01/viewlaPIW Intranet https://apps.intranet/prjmgt/piw3Active Construction Projects https://pw.lacounty.gov/cons/acp

Copyright Text: LA County Public Works ITD GIS Unit (gis@pw.lacounty.gov) maintains the update routines for this feature class, combining the geometry created by SMP and attributes from the PIW database. ITD Web Services group oversees the PIW database. http://intranet2/DivPhoneList/CIO.pdf The original geometry is created and edited by Survey/Mapping Division, Mapping & GIS Services section. http://intranet2/DivPhoneList/SMPM.pdf

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 5971099.98969622
YMin: 1358599.99215652
XMax: 6711099.98963208
YMax: 2838599.99202825
Spatial Reference: 102645  (2229)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PROJECT_STATUS_SIMPLE
Field 2: PROJECT_TYPE_SIMPLE
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Construction,Water Resources
  Label: In Construction - Water Resources
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [0, 112, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 2
• Value: Construction,Transportation
  Label: In Construction - Transportation
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [197, 0, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [197, 0, 255, 255]
  Width: 2
• Value: Construction,Capital Improvement
  Label: In Construction - Capital Improvement
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [168, 168, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [168, 168, 0, 255]
  Width: 2
• Value: Development,Water Resources
  Label: In Development - Water Resources
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [0, 197, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [0, 197, 255, 255]
  Width: 2
• Value: Development,Transportation
  Label: In Development - Transportation
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [205, 102, 153, 255]
  Outline:
  Style: esriSLSSolid
  Color: [205, 102, 153, 255]
  Width: 2
• Value: Development,Capital Improvement
  Label: In Development - Capital Improvement
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [255, 255, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 2
• Value: Completed,Water Resources
  Label: Completed - Water Resources
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [122, 142, 245, 255]
  Outline:
  Style: esriSLSSolid
  Color: [122, 142, 245, 255]
  Width: 2
• Value: Completed,Transportation
  Label: Completed - Transportation
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [245, 122, 182, 255]
  Outline:
  Style: esriSLSSolid
  Color: [245, 122, 182, 255]
  Width: 2
• Value: Completed,Capital Improvement
  Label: Completed - Capital Improvement
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [171, 205, 102, 255]
  Outline:
  Style: esriSLSSolid
  Color: [171, 205, 102, 255]
  Width: 2
Transparency: 50
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: false
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PROJECT_ID ( type: esriFieldTypeString, alias: PROJECT_ID, length: 15 )
• PROJECT_NAME ( type: esriFieldTypeString, alias: PROJECT_NAME, length: 150 )
• PROJECT_STATUS ( type: esriFieldTypeString, alias: PROJECT_STATUS, length: 25 )
• PROJECT_SCOPE ( type: esriFieldTypeString, alias: PROJECT_SCOPE, length: 250 )
• BOARD_ACCEPT ( type: esriFieldTypeDate, alias: BOARD_ACCEPT, length: 8 )
• ACTUAL_BOARD_ACCEPT ( type: esriFieldTypeDate, alias: ACTUAL_BOARD_ACCEPT, length: 8 )
• FED_STIMULUS_TYPE ( type: esriFieldTypeString, alias: FED_STIMULUS_TYPE, length: 30 )
• ACTUAL_START ( type: esriFieldTypeDate, alias: ACTUAL_START, length: 8 )
• ACTUAL_FINISH ( type: esriFieldTypeDate, alias: ACTUAL_FINISH, length: 8 )
• PROJECTED_FINISH ( type: esriFieldTypeDate, alias: PROJECTED_FINISH, length: 8 )
• RISK_CATEGORY ( type: esriFieldTypeString, alias: RISK_CATEGORY, length: 10 )
• LEGAL_NAME ( type: esriFieldTypeString, alias: LEGAL_NAME, length: 128 )
• DBA_NAME ( type: esriFieldTypeString, alias: DBA_NAME, length: 128 )
• AWARD ( type: esriFieldTypeDate, alias: AWARD, length: 8 )
• FIELD_ACCEPT ( type: esriFieldTypeDate, alias: FIELD_ACCEPT, length: 8 )
• CONSTRUCTION_BEGIN ( type: esriFieldTypeDate, alias: CONSTRUCTION_BEGIN, length: 8 )
• PROJECT_SUBTYPE ( type: esriFieldTypeString, alias: PROJECT_SUBTYPE, length: 50 )
• CONSTRUCTION_BEGIN_PUBLIC ( type: esriFieldTypeDate, alias: CONSTRUCTION_BEGIN_PUBLIC, length: 8 )
• SUP_DISTS ( type: esriFieldTypeString, alias: SUP_DISTS, length: 50 )
• CENTROID_LAT ( type: esriFieldTypeString, alias: CENTROID_LAT, length: 50 )
• CENTROID_LNG ( type: esriFieldTypeString, alias: CENTROID_LNG, length: 50 )
• ADVERTISE ( type: esriFieldTypeDate, alias: ADVERTISE, length: 8 )
• DESIGN_PLANS_SIGNED ( type: esriFieldTypeDate, alias: DESIGN_PLANS_SIGNED, length: 8 )
• PROJECT_STARTDATE ( type: esriFieldTypeString, alias: PROJECT_STARTDATE, length: 50 )
• PROJECT_ENDDATE ( type: esriFieldTypeString, alias: PROJECT_ENDDATE, length: 50 )
• PROJECT_TYPE ( type: esriFieldTypeString, alias: PROJECT_TYPE, length: 50 )
• PROJECT_SCOPE_DESC ( type: esriFieldTypeString, alias: PROJECT_SCOPE_DESC, length: 2000 )
• PROJECT_BUDGET ( type: esriFieldTypeDouble, alias: PROJECT_BUDGET )
• CONTRACT_COST ( type: esriFieldTypeDouble, alias: CONTRACT_COST )
• MAINTENANCE_DISTRICT ( type: esriFieldTypeString, alias: MAINTENANCE_DISTRICT, length: 10 )
• CON_BEGIN_PUBLIC_DISP ( type: esriFieldTypeString, alias: CON_BEGIN_PUBLIC_DISP, length: 50 )
• CON_BEGIN_DISP ( type: esriFieldTypeString, alias: CON_BEGIN_DISP, length: 50 )
• SHOW_ON_INTERNET ( type: esriFieldTypeString, alias: SHOW_ON_INTERNET, length: 1 )
• PIW_PREFIX ( type: esriFieldTypeString, alias: PIW_PREFIX, length: 10 )
• CITY_COMMUNITY ( type: esriFieldTypeString, alias: CITY_COMMUNITY, length: 2000 )
• ENGINEER_EST ( type: esriFieldTypeDouble, alias: ENGINEER_EST )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• COST_ESTIMATE ( type: esriFieldTypeString, alias: COST_ESTIMATE, length: 2000 )
• COST_ESTIMATE_DISP ( type: esriFieldTypeString, alias: COST_ESTIMATE_DISP, length: 2000 )
• FS_LOCATION ( type: esriFieldTypeString, alias: FS_LOCATION, length: 2000 )
• ORIGINAL_GEOTYPE ( type: esriFieldTypeString, alias: ORIGINAL_GEOTYPE, length: 100 )
• WEBSITE ( type: esriFieldTypeString, alias: WEBSITE, length: 400 )
• PROJECT_LIMIT ( type: esriFieldTypeString, alias: PROJECT_LIMIT, length: 2000 )
• PROJECT_STATUS_SIMPLE ( type: esriFieldTypeString, alias: PROJECT_STATUS_SIMPLE, length: 25 )
• PROJECT_TYPE_SIMPLE ( type: esriFieldTypeString, alias: PROJECT_TYPE_SIMPLE, length: 50 )
• PAYMENT_ID ( type: esriFieldTypeDouble, alias: PAYMENT_ID_NEW )
• COMBINED_CATEGORY ( type: esriFieldTypeString, alias: COMBINED_CATEGORY, length: 500 )
• CONSTRUCTION_END ( type: esriFieldTypeDate, alias: CONSTRUCTION_END, length: 8 )
• COMMUNITY_WKFC_AGRMT ( type: esriFieldTypeString, alias: COMMUNITY_WKFC_AGRMT, length: 2 )
• COMPLIANCE_LOCAL ( type: esriFieldTypeSingle, alias: COMPLIANCE_LOCAL )
• COMPLIANCE_TARGETED ( type: esriFieldTypeSingle, alias: COMPLIANCE_TARGETED )
• CONTRACTOR_NAME ( type: esriFieldTypeString, alias: CONTRACTOR_NAME, length: 300 )
• HIRING_GOAL_TYPE ( type: esriFieldTypeString, alias: HIRING_GOAL_TYPE, length: 60 )
• SHOW_ON_INTERNET_LTWHP ( type: esriFieldTypeString, alias: SHOW_ON_INTERNET_LTWHP, length: 2 )
• SHAPE.AREA ( type: esriFieldTypeDouble, alias: SHAPE.AREA )
• SHAPE.LEN ( type: esriFieldTypeDouble, alias: SHAPE.LEN )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata