2014r2 Release Notes

Module Enhancements

These changes were made to the modules in the desktop and web applications

System Wide

• Inventory Modules
  • Added a Mitigation field for all asset inventory modules. Mitigation is part of the risk analysis calculation and allows agencies to balance risk analysis with steps taken to reduce risk. The risk analysis calculation is now Criticality * Probability of Failure * Mitigation
  • Short WO Comment – This field is now carried over to a New Work Order asset record’s Short Comment field (AS_WO_COMM). This new field is 255 characters in length
• Street Names
  • Increased the Maximum Masks for Street Type for all street address fields to 5x (from 4x)
• Lucity Messenger Application
  • We are dropping support of the Lucity Messenger application

Equipment

• Equipment Inventory
  • Added Uniformat II code/type fields
  • Added Location History grid – this stores information about Plant Processes where the equipment was installed.
  • Added fields to track:
    • Original Costs
    • Inspected Date, Condition and Next Inspection Date
    • Replacement Date & Replacement Costs
    • Consequence of Failure, Probability of Failure, Mitigation, and Risk

Facility

• Facility Sites
  • Added a new tab to display related irrigation modules.
• General Additions
  • Replacement Date and Cost fields
  • Uniformat II Code/Type fields
• Irrigation Modules
  • New modules added to track irrigation systems associated to facility sites. These modules are Node Inventory, Valve Inventory, Valve Inspections, Controller Inventory, Controller Inspections, and Pipe Inventory.

Fleet

• Fleet Inventory
  • Added Current Eval Time field - Now the current Eval information is set by using both the Current Eval Date and Time allowing multiple fuelings/travel logs/work orders to take place on the same day and still update the Odometer, etc… correctly.

General

• Notification Module
  • Notification template bodies now support basic HTML formatting.
• Parcels
  • Parcels module – New module that tracks parcels of land. Users can link multiple addresses to each parcel and can create WOs, PMs, and Requests for the parcels. This module matches ESRI’s local government model.

Plants

• Plant Module
  • Added fields to track:
    • Original Costs
    • Inspected Date, Condition and Next Inspection Date
    • Replacement Date & Replacement Costs
    • Consequence of Failure, Probability of Failure, Mitigation, and Risk
• Plant Process Module
  • Added Slot grid with ability to Install, Uninstall and Swap Equipment.
  • Added Slot History grid to track changes made in the Slot grid.
  • Added fields to track:
    • Original Costs
    • Inspected Date, Condition and Next Inspection Date
    • Replacement Date & Replacement Costs
    • Consequence of Failure, Probability of Failure, Mitigation, and Risk

Sewer

• Equipment Component Library
  • New module used to set up lists of equipment components that can then be loaded into the components grid for a Sewer Pump Station or Sewer Pump.
• Illicit Discharge
  • New module to track instances where things have been illegally dumped into the sewer system.
• Pipe Inventory
  • Increased maximum mask for SWNET.NT_NUMBER to 61x (from 51x)
  • Illicit Discharge grid – New grid on the Overflow Tab. This displays a list of related records from the new Sewer Illicit Discharge module.
• Pumps Inventory
  • Components tab – New tab that allows users to list out individual components of the Pump.
• Pump Station
  • Increased maximum mask for SWSTATN.SN_NODE_NO to 30x (from 20x)
  • Components tab – New tab that allows users to list out individual components of the Pump Station.
• Structure Inventory
  • Increased maximum mask for SWNETMH. MA_MANHOLE to 30x (from 25x)
  • Sampling tab – New tab with fields and sampling grid that display related records and information from the new Sewer Sampling module.
  • Illicit Discharge grid – New grid on the Overflow Tab. This displays a list of related records from the new Sewer Illicit Discharge module.
• Sewer LACP
  • Increased maximum mask for SWLACP.LW_PNUM to 61x (from 25x)
  • Increased maximum mask for SWLACP. LW_USMH to 30x (from 25x)
  • Increased maximum mask for SWLACP. LW_DSMH to 30x (from 25x)
• Sewer Rehab Pipe
  • Increased maximum mask for SWRHPIPE. PR_NUMBER to 61x (from 51x)
  • Increased maximum mask for SWRHPIPE. PR_USMAN to 30x (from 25x)
  • Increased maximum mask for SWRHPIPE. PR_DSMAN to 30x (from 25x)
• Sewer Rehab Project
  • Increased maximum mask for SWRHPROJP. PP_NUMBER to 61x (from 25x)
  • Increased maximum mask for SWRHPROJP.PP_USMAN to 30x (from 25x)
  • Increased maximum mask for SWRHPROJP.PP_DSMAN to 30x (from 25x)
• Sewer Sampling
  • New module to track samples taken from the sewer system.
• Sewer Sampling Detail Library
  • New module to create template sampling lists.

Storm

• Basin Inventory
  • Increased maximum mask for SMVDBASN.DN_DB_NO to 30x (from 25x)
• Conduit Inventory
  • Increased maximum mask for SMVCONDT.CN_NUMBER to 61x (from 41x)
• Equipment Component Library
  • New module used to set up lists of equipment components that can then be loaded into the components grid for a Storm Pump Station or Storm Pump.
• Pumps
  • Components tab – New tab that allows users to list out individual components of the Pump.
• Pump Station Inventory
  • Increased maximum mask for SMSTATN.PN_NUMBER to 30x (from 20x)
  • Components tab – New tab that allows users to list out individual components of the Pump Station.
• Structures Inventory
  • Increased maximum mask for SMVSTRUC.SN_ST_NO to 30x (from 20x)

Transportation

• Accident Program
  • Added 4 additional Factor dropdown fields.
  • Added 6 additional dropdown fields on the Custom tab.
  • In the Vehicle Dialog, added vehicle speed field.
• Pavement Inspection
  • New Toolkit Function: Replicate Inspection Across Supersegment – Used after creating an inspection for a subsegment. This creates a duplicate inspection for every other subsegment that shares the supersegment.
• Right of Way modules
  • New Toolkit Functions for all Right of Way modules
    • Change Intersection ID for Filterset – Updates the Intersection ID field for all records in the filter.
    • Change Segment ID for Filterset – Updates the Intersection ID field for all records in the filter.
    • Change Subsegment ID for Filterset – Updates the Intersection ID field for all records in the filter.
    • Change Supersegment ID for Filterset – Updates the Intersection ID field for all records in the filter.
• Signs
  • Increased the size of the MUTCD code field from 20x to 35x
• Structure Inventory
  • Added a link to the Roads module.

Trees/Parks

• Art Inventory/Inspections
  • New modules to store information about Art installations at parks and related inspections.
• Checklist Library
  • New module that allows users to setup checklist templates for different types of assets. These checklists can then be loaded into different types of park asset inspections.
• Irrigation Pipes
  • New module to store information about park irrigation pipes.
• Irrigation Nodes
  • New module to store information about park irrigation nodes.
• Park Meter
  • Added a Consumption grid to display consumption records for the meter.
• Park Meter Water Consumption
  • New module that tracks how much water is used at a park meter over the course of a year.
• Park Meter Water Consumption Library
  • New module that allows users to setup important components for the new Water Consumption module.
• Parks
  • Increased side of module window.
  • Added an Art grid.
  • Added grids to link to all four irrigation inventory modules.
• Park Structure
  • Added an Art grid.
• Inspection Modules
  • Added a Checklist grid to each park inspection module. This checklist can be used to customize what the inspection tracks. Includes the following tools:
    • Load Inspection Checklist – Grid tool that allows users to load a checklist template from the Checklist Library.
    • Populate condition/Inspection Date – Grid tool that allows users to populate the inspection date and condition of one or more items in the checklist.

Water

• Access Roads
  • New module to store information about roads that lead to water sites.
• Gates
  • New module to store information about gates that block access roads.
• Construction
  • Updated to track all construction for all new water modules.

Water Distribution

• Backflow
  • Added a link to the Water Site module.
• Distribution Hydrant
  • Added a Flushing Route ID field.
• Distribution Pipes
  • Added a Flushing Route ID field.
• Distribution System Valves
  • Added a Flushing Route ID field.
• Water Site
  • Backflow grid – Displays a list of related Backflow Preventer records.
• Water Flushing Routes
  • The module screen is bigger (desktop only)
  • Moved Custom fields the Attributes tab (desktop only)
  • Removed Node field and Node tab/grid.
  • Combined the Hydrants, Valves and Pipes grids onto the Hydrants tab (desktop only)
    • Hydrants Grid
      • Now allow same hydrant to show up more than once in grid
      • Insert Hydrant Above – New Grid tool which inserts a hydrant anywhere within the grid. Previously you could only add a hydrant to the bottom of the grid
      • View Hydrant in Map – New grid tool that displays one or more selected hydrant records in the map.
    • Hydrant Dialog updated
      • Added Flush Type, Target Flush Duration, # of Nozzles used, Target gpm fields
      • Added a Notes field. This will default from Hydrant Inventory Flushing Comments but can be modified.
    • Valves Grid – These records are now linked to a record in the Hydrant grid.
      • Open Closed Valves – New grid tool that automatically adds all valves that were closed in a previous sequence that have not yet been opened. This provides an easy method for the user to quickly add valves to close in the system. Those valves that should not be opened can simply be deleted from the grid.
      • View Valve in Map – New grid tool that displays one or more selected valve records in the map.
      • Change Hydrant Sequence Number – New grid tool that allows the user to change which record in the hydrants grid the valve is attached to.
    • Valves Dialog updated
      • Designate Open or Close valve prior to flushing hydrant
    • Pipes Grid – These records are now linked to a record in the Hydrant Grid.
      • As pipes are added or deleted from the grid, the Flushing Route’s Total Pipe Length is updated
      • Change Hydrant Sequence Number – New grid tool that allows the user to change which record in the hydrants grid the pipe is attached to.
      • View Pipe in Map – New grid tool that displays one or more selected pipe records in the map.
  • Create Flushing History and WO – New Toolkit that:
    • Creates a Flushing History record.
    • Creates a new Work Order. In the asset grid, the system:
      • Adds a record for the Flushing Route
      • Depending on some new Water Options the following can happen as well:
      • Hydrants in the route’s hydrant grid are added to the work order.
      • Valves in the route’s Valve grid are added to the work order.
      • Pipes in the route’s Pipe grid are added to the work order.
• Water Flushing History
  • The module screen size is bigger. (desktop only)
  • Removed the Node field and Node tab/grid. (desktop only)
  • Moved Custom fields to the Attributes tab. (desktop only)
  • Moved all fields related to date/time flushed and discharge rate to the Hydrant dialog.
  • Combined the Hydrants, Valves and Pipes grids onto the Hydrants tab (desktop only)
    • Hydrants Grid
      • Removed the Set Exercised True, Set Exercised False, and Populate Dates grid tools.
      • View Hydrant Inventory Record – New grid tool that opens the Distribution Hydrant module for the selected record.
      • Create Hydrant Inspection Record – New grid tool that creates a hydrant inspection record for the selected hydrant.
      • Insert Hydrant Above - New Grid tool which inserts a hydrant anywhere within the grid. Previously you could only add a hydrant to the bottom of the grid
      • View Asset from Map - New grid tool that displays one or more selected hydrant records in the map.
    • Hydrants Dialog
      • Added new fields including date/time flushed, discharge rate, discharge volume (calculation), Static and Residual Pressure, Flow at 20 psi (calculation if discharge rate and the two pressures have values), chlorine ok -start and end values, three problem popup fields, total pipe length for this flush (calculated), and a link to the Water Loss record.
    • Valves Grid – These records are now linked to a record in the Hydrant Grid.
      • Removed the Set Exercised True, Set Exercised False, and Populate Dates grid tools.
      • View Valve Inventory Record – New grid tool that opens the Distribution System Valve module for the selected record.
      • Create Valve Inspection Record – New grid tool that creates a valve inspection record for the selected valve.
      • View Asset from Map – New grid tool that displays one or more selected valve records in the map.
    • Valves Dialog
      • This is now a separate dialog.
      • Added checkbox fields for Valve Set to, Exercised Date, and Exercised.
    • Pipes Grid – These records are now linked to a record in the Hydrant Grid.
      • No change except that as the Hydrant Date Flushed is entered, the length of the pipe for the Hydrant and for the Route is updated with the pipe lengths associated with the Hydrant.
      • View Asset from Map – New grid tool that displays one or more selected pipe records in the map.
  • Other Flushing Changes Implemented
    • On Save of a Hydrant Flushing Record:
      • A new Water Loss record is created that stores the Flow Volume in the record
      • The total pipe length cleaned is updated in both the hydrant record as well as the flushing history record. The pipe length is also updated if a pipe is deleted from the grid.
      • The pipes attached to the hydrant have their Last Flushed Date updated with the Hydrant Flush date.
      • Exercised date for valve is set to Hydrant test date, exercised flag is set to Yes.
      • The Last Exercised Date is also updated on the valve inventory record.

Raw Water

• Culvert Inventory
  • New module to store culverts in the raw water system.
• Check Inventory
  • New module to store information about checks within the raw water system.
• Gauge Inventory
  • New module to store gauges within the raw water system.
• Pipe Inventory
  • Now named Raw Water Pipe/Canal Inventory.
  • Added new Active checkbox, Type, Width, Slope %, Pipe Shape fields.
• Service Box Inventory
  • New module to store information about service boxes within the raw water system.
• Service Manifold Inventory
  • New module to store information about service manifolds within the raw water system.
• Spill Inventory
  • New module to store information about spills within the raw water system.
• Structure Inventory
  • New module to store structures within the raw water system.
• Shared Fields
  • Conveyance, Subsystem, Canal Name, Facility Number – New shared fields added to the following modules: Pipes, System Valves, Control Valves, Nodes, Pump Stations, Storage Facilities, Supply Sources, Vaults.

Water Options

• In Flushing Route, Copy Hydrants to Work Orders with Tool – Used by the new Water Flushing Route tool.
• In Flushing Route, Copy Valves to Work Orders with Tool - Used by the new Water Flushing Route tool.
• In Flushing Route, Copy Pipes to Work Orders with Tool - Used by the new Water Flushing Route tool.

Work

• Administration
  • Work Asset Setup
    • New module that lets administrators configure fields from inventory modules to automatically be copied over to the Work Order Asset record. They can set it up to populate the asset record’s User fields and Desc 1 & 2 fields.
• Pm/Template module
  • Added Duration to PM Scheduling Tab so that when the work order is created the duration (in days) is added to the starting date to determine the Projected Completion Date.
• Project Contracts
  • Added several new user fields to Project Contract Details.
• Utilities
  • Utility Locates
    • Added a picklist for Utility Members in the Owed To Dialog
    • Added security for Edit Grid Comments for the Utility grid comment
• Utility Members
  • Added a 255x Notes field in Member Contacts dialog
• Work Orders
  • Assets
    • Added Completion Time.
    • Now data can be mapped to be automatically copied from an asset inventory into select fields in Work Order Assets (ie Description 1, Description 2 and User-Defined fields)
• Work Flow Setup
  • Category Setup
    • Added new fields for Department, Division, Subdivision, Area and Subarea. These values are then defaulted into both Requests and Work Orders when a category is used.
  • All Other Setup Modules
    • All Employee and Equipment look ups will now only display employee and equipment records marked as ‘Active’.

Inventory

• Warehouse
  • Parts Inventory Reorder emails are now sent individually for each warehouse. An email address must be entered on each warehouse.
  • The Parts Transfer pop-up now contains an Employee field with a pop-up list of work flow setup employees.
• Parts
  • The Parts Transfer pop-up now contains an Employee field with a pop-up list of work flow setup employees.

GIS - Desktop

Configuration and Integration

• General Changes
  • We are dropping all support of ArcGIS 10.0 versions.  We are supporting ArcGIS 10.1 and ArcGIS 10.2.
  • We are dropping support of the LiveDataMapUpdater application.  It is replaced by GIS tasks that were made available in Lucity 2014
  • Lucity’s new Parcels module may cause agencies to re-evaluate how they store address information as they can now links these types of features to the Addresses and Parcels modules instead of only the Customer Address module.
  • Inspection feature classes now support two-way synchronization – This allows users to enter inspection information into Lucity and sync it to a feature class or enter the inspection information into the feature class and sync it into Lucity.
  • New Alternative to Lucity’s SOE for Geodatabase updates. – Lucity to Geodatabase updates can now be accomplished via feature services. With this option you no longer need to install and enable the Lucity SOE on an ArcGIS Server map service. Instead you would just need to publish a map service that has the Feature Access capability enabled on it. When edits are made in Lucity the related feature is updated in the feature service using the ArcGIS REST API.

• GIS Scheduled Tasks – Originally added in Lucity 2014 with limited capabilities scheduled tasks now allow users to setup a scheduled GIS to Lucity synchronization for all feature classes that are linked to Lucity modules. This, combined with feature services, allow for a more flexible editing environment. No longer are users bound to an ArcMap edit session for syncing simple* GIS edits to Lucity. Edits to the feature service, regardless of who did it and what environment they did it in, will now be picked up by Lucity. Some potential examples:
  • Collector for ArcGIS (iOS & Android)- including disconnected editing
  • Lucity Web Map
  • ArcGIS.com map viewer
  • Any other 3rd party apps that support feature service editing- http://resources.arcgis.com/en/help/main/10.2/index.html#/Using_feature_services_in_a_client_application/0154000005sq000000/
  • *Note: Merges, Splits, Renumbers, and Deletes must still be done in an ArcMap editing environment with the Lucity extension enabled in order for the Lucity inspection, construction, and work history to be properly updated.
• The values entered into the Lucity Last Sync Date field in GIS will now be in UTC
• This is to support the new Scheduled GIS Tasks processing and Esri’s sync enabled feature services.

ArcGIS for Desktop Editing Tools

• Editor Extension
  • The Lucity Last Sync Date field will now be populated with the current datetime in UTC format instead of local.
    • This is to support the new GIS Tasks processing and Esri’s sync enabled feature services.
  • Endpoints for Park and Facility Irrigation Pipes are automatically managed by Lucity extension.
  • Parcel and Address relationships are automatically managed by Lucity extension
  • Raw Water Pipe to/from node types can now include: Culverts, Checks, Structures, Gauges, Spills, Service Boxes, and Service Manifolds
• General Edit Tools
  • Update Spatial Relationships – Automatically updates new hardcoded spatial relationship for maintaining Parcel and Address feature relationships.

ArcCatalog - Configuration Tools

• Edit Map Service - Services configured at the feature class level must now be defined in Lucity Admin > Map Services module.
• Update Feature Class Services - New tool to associate map and feature services to multiple feature classes.
• Connection Properties
  • The edit map service that is associated to the geodatabase can now be edited from the connection properties tab.
  • A new Test Connection button is available with the edit map service, which will validate the map service connection.
• Validate Workspace, Validate Feature Class - The validation results will now include testing of the map and feature service associated to the feature class.
• Scheduled Tasks
  • Added new task type "Sync- GIS to Lucity" in addition to the "Sync- Lucity to GIS"
  • Enabled the ability to schedule the GIS Task
  • Provides processing log details
• Copy GIS Task - New tool that can be used to copy a GIS Task template to other feature classes.
• Update Street Name Domains - Adds ability to create a text domain for composite street name fields. In addition, each of the street component domains will now get applied to all feature class fields that are assigned to the corresponding street component field.
• Update Work Category Domain - New tool to create a domain for work category component fields. In addition, the domain will get applied to all feature class fields that are assigned to a work category component field.

Administration Tool

• General
  • The Title bar now displays the name of the Lucity Client that is currently open. This makes it easier to tell if a user is in Test or Production.
• Dashboard Manager
  • Users can now rename dashboard templates
• Reports
  • Reports can now be grouped together. This makes it easier to find a specific report when using Lucity Web.
• Security
  • Assign Groups to Forms
    • Show Only Views, Not Forms – New check-box that hides all forms in the Available Views/Forms grid.
    • Groups Assigned to View/Forms – New tool that provides a list of views/forms and displays which groups are assigned to each view/form.
• System Settings
  • Exclude Records in Add Mode - Historically, we have always excluded the records in desktop add mode from showing up in the web app.  In Lucity 2014r2 this can be turned off, and will be turned off by default, because it makes the app faster.

Imports

• New Import program designed to replace older import programs. It is capable of setting up simple imports to import data into a single Lucity table. It is also capable of setting up more complicated imports that involve multiple tables. (like Sewer TV Inspection Imports) Finally it can also update existing records in Lucity with new data.
• Note: The older import programs are still currently available but users are encouraged to use the new program to meet their import needs.

Lucity Mobile Server

• Added server-side support for offline inventory/inspections and requests on Android tablet.
• Added server-side support for toolkits for Lucity Mobile Android and iOS products.
• Added server-side support for Open Form from Identify for Lucity Android tablet.
• Added server-side support for Open in a new View on Lucity Mobile Android and iOS products.
• Added server-side support for GIS editing on Lucity Mobile Android and iOS products.
• With the ability to take data offline we are now caching data on the mobile server for offline usage. Due to this the required disk space has increased for the mobile server. We suggested 1GB to 10GB of disk space.

REST API

• There is a new template available for clients who want a fully customizable citizen web application.

Services

• Lucity Scheduler Service – This is a new service that combines the Email Generator, Request Generator, and Spatial Updater services and adds a new GIS Scheduled tasks process.
  • The Email and Request Generators’ settings are now configured using the new Lucity.EmailSetup.exe found where the services are installed.
  • The reply email sent by the request generator now includes a link to the request.
  • The new GIS Scheduled tasks process syncs changes made in Lucity and GIS feature classes.

Web

General

• The Title bar now displays the name of the Lucity Client that is currently open. This makes it easier to tell if a user is in Test or Production.
• Changes to field Default Values no longer require an IIS reset. They just require an admin to go into the Lucity Admin tool and clear all web app caches.
• Common IDs - If users are creating a new inventory record and leave the Common ID blank the system can automatically populate it for them. If you do want to manually set the common id for a module an admin needs to edit the form for the module and set the common id field to not required.
• Options - Users can now change module options within Lucity Web. All options are found under Modules > General > Options.

Tools

• Filters
  • New Reserved Words added.
    • NEXT – Allows users to see a set of records that have a date in the future. This lets users set how far into the future the range of dates will start, and how far into the future the range will end.
    • LAST - Allows users to see a set of records that have a date in the past. This lets users set how far into the past the range of dates will begin, and how far into the past the range will end
    • TODAY - Allows users to see a set of records that have a date matching today.
    • CURRENTWEEK1-7 – Allows users to see records with a date that falls within the current week. There are 7 versions of the Reserve Word. Each number indicates a different start day. CURRENTWEEK1 goes from Sunday to Sunday, 2 goes from Monday to Monday, etc…
• Reports
  • Reports can be grouped together. This makes it easier to find a specific report.
  • Reports can be run and automatically emailed to the current user.

Views/Grids/Forms

• Editable Grids
  • Drop down lists for Work Order Resources are now filterable dropdowns. That means that a user should click in the field and begin to type the code or name of the resource. The field will instantly begin to search for a matching record. These records will be displayed as a dropdown. The user can select the correct resource from the drop down or they can continue to type to filter further.
  • Labels now appear above each resource type that let the user know how many resources of that type are selectable because they are associated to the work order category.
• Field Properties
  • A new button on a form now allows users, with the correct permissions, to view and modify global field properties.

Work Functionality

• When a work flow setup item (task, problem, employee) is selected on a work order, but is not associated to the category yet, the user is asked if they want to associate the item to the category.

Webmap

• Web Map Selector – New Tool that allows users to load different webmaps.
• Table of Contents – Now has a zoom to layer tool.
• Edit Tools - Editing features is now available in the Webmap. This is dependent on new GIS Configuration options.
• Selection Tool – New Select by Rectangle Tool. There is now a button to switch between selection modes.
  • The last used mode for the selection tool will be saved for next time.
• Water Isolation Valve Trace – New tool that allows users to trace water pipes to find isolation valves.
• Property Viewer – This Lucity Web tool is now available in the map. It displays a list of records that are related to the currently selected asset based on address.
• Create Inspection – New Tool that allows users to create an inspection for a selected asset.

Module Toolkits newly available in the web

Work Requests

• Close Request for Current Filter
• Close Request for Selected Records
• Change Request Status for Current Filter
• Change Request Status for Selected Records
• Change Supervisor for Current Filter
• Change Supervisor for Selected Records
• Associate Work Order with Same Problem
• Associate Any Work Order
• Associate Work Order with Same Infrastructure
• Associate Work Order with Same Problem and Infrastructure
• Associate Work Order that is not complete
• Associate Work Order with Same Street Block

Water Sites

• Change Address/Contact info for Current Filter
• Change Address/Contact info for Selected Records

New Modules available for editing in Lucity Web with Lucity 2014r2

Equip

General

Park

Sewer

Storm

Street

Water

Work