Designed and developed a client-server Land Administration and Cash Receipts system for the State of Oregon to replace a legacy WANG database and application. The system is used to accommodate state land permitting, leasing, wetland and mitigation projects. Features contact management, mailing, complaint management, violation investigation, and a number of other capabilities. System also features a GIS component for locating state owned land and permitted activity.
System is highly successful and has been in production 2 years. GeoNorth has recently upgraded the system to PowerBuilder 8.0 and is currently providing on-going support services to provide, erosion Control Monitoring Reports, Modifying mitigation process to allow Accurate racking of mitigation bank credit and developing new Work Flow Tracking that is required by new Legislative mandates and to help the Agency comply with new regulations that require DSL to approve permits on a tight schedule. Details:
LAS assists DSL staff in management of State land-related issues. This includes tracking permit/lease applications from citizens, and violations of State law or permit/lease conditions on State lands. Data was initially migrated from DSL’s Wang system.
LAS has a two-way interface between spatial and tabular data, allowing for great flexibility in searching for and analyzing data. All location-specific LAS data can be displayed on the map. Users can jump from a tabular data record to the map, or can move from the map to tabular data records.
LAS utilizes ESRI MapObjects for its map functionality. The map is fully configurable via a map administration tool, which stores all configuration data (i.e. layers, symbolization, etc.) in the centralized database. Additionally, multiple map configurations/profiles can be defined, so that users in different groups can have maps suited to their needs.
The back-end database for LAS is Microsoft SQL Server. The database design, coupled with the LAS application, allows for user-defined attributes to be defined with no programmer effort, and all status values and lookup lists are fully data driven.
