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