Name: LACoPW Project Merged Polygons
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: 8000
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: -1.336005185015117E7
YMin: 3856909.9849584512
XMax: -1.3078925901544338E7
YMax: 4410093.154234494
Spatial Reference: 102100
(3857)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: PROJECT_STATUS_SIMPLE
Field 2: PROJECT_TYPE_SIMPLE
Field 3: null
Field Delimiter: ,
Default Symbol:
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:
[212, 3, 0, 255]
Outline:
Style: esriSLSSolid
Color:
[212, 3, 0, 255]
Width: 2
-
Value: Construction,Road
Label: In Construction - Road
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:
[255, 167, 127, 255]
Outline:
Style: esriSLSSolid
Color:
[255, 167, 127, 255]
Width: 2
-
Value: Development,Road
Label: In Development - Road
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
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