| Renewal of GIS software license maintenance agreement W/ ESRI |
| Program Summary |
 |
| Title: |
Renewal of GIS software license maintenance agreement W/ ESRI |
| GovCB Opps ID : |
ADP11981981860001009 |
| Solicitation No.: |
141-1042-07 |
Posted Date:
|
Dec 20, 2007 |
| Due Date: |
Dec 27, 2007 |
|
| Description |
|
|
|
| Sole Source Notice |
|
|
| Land Administration System (LAS) and CASH System Support, etc. |
|
|
|
|
|
| Issued By |
State Lands, Department of
775 Summer St NE
Salem, Oregon
97301
|
|
| Contact: |
|
Eric Andersen |
| Phone: |
|
1 (503) 986-5228 |
| Fax: |
|
1 (503) 378-4844 |
| Email: |
|
eric.andersen@state.or.us |
|
| |
|
|
| Opportunity # |
| 141-1042-07 |
|
| Closing Date & Time |
12/27/2007 4:00 PM
|
| Time Zone |
| Pacific Time |
| Approx. Time Remaining |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Issued For |
State Lands, Department of
775 Summer St NE #100
Salem, Oregon
97301
|
|
|
|
|
|
|
|
| |
| Opportunity Summary |
1. GENERAL STATEMENT
The State of Oregon through its Department of State Lands (Department or DSL or Agency)
needs continued maintenance and development support for the Land Administration System
(LAS), the Cold Fusion web site that is linked to the LAS Database and the CASH Accounting
System. The Agency intends to award a contract to Geo-North LLC.
The proposed changes of the new contract are intricately tied to the design of the LAS,
Cold Fusion and CASH Systems. The LAS, Cold Fusion and CASH Systems are now tightly
integrated systems. A change in one system requires a complete understanding of the other
systems.
The Agency has only one IT Staff member who is familiar with these systems. Therefore,
there is limited time for Agency IT Staff to work with a contractor, especially one that is
not already familiar with the systems.
LAS data is now available all day every day on the web. The Agency depends on the web
component of LAS to maintain its statutory timelines and to solicit comments from the
public as well as other State Agencies. Any downtime of these systems would have
unacceptable impact on the Agency's workload.
In the new contract GIS tools will be integrated with the Powerbuilder code of the LAS
System to create a seamless user experience where LAS Sites can be both created and
analyzed. GeoNorth has extensive experience as a GIS consulting firm and in providing GIS
solutions for state and local governments.
GeoNorth has bid for and won every support contract for the past seven years. The last RFP
for LAS Support only had one bidder. The bidder was GeoNorth.
Recently it has been harder to find contractors that code in Powerbuilder. GeoNorth has
many years of Powerbuilder experience.
Considering the complex integration of the LAS/CASH/Cold Fusion Systems and the modest
budget the Agency has allocated for the anticipated changes it is certain that a new
contractor would spend most of the contract dollars on a learning curve just trying to
understand the complex integration between the two systems. It is certain that it would not
be cost effective for the Agency to start over with a new contractor that has never seen
the LAS/CASH Systems before.
2. DESCRIPTION OF THE LAS SYSTEM
The LAS System is a client server system developed in PowerBuilder version 10.0 utilizing
the PFC code libraries. The system runs against a backend Microsoft SQL 7.0 database. The
database will be migrated to MSSQL 2003 sometime in Summer 2005.
As an indicator of the system's scope and complexity, the database contains about 220
tables and some 60 stored procedures. The LAS System has about 40 standard reports and
allows the user to develop complex ad hoc queries using a GUI interface. The LAS System is
generally a light duty system with usually no more than 10 or 15 users logged in at any
time.
The LAS System utilizes the ESRI Map Objects version 2.2 (an Active X control) and allows
GIS analysis of 40,000 sites stored in the database. The system tracks applications,
authorizations, complaints, violations, land use notices, mitigation projects, wetlands,
land parcels, projects and players (applicants).
The LAS System has integrated document management system. Currently documents of many
types are scanned and or directly linked to the data in LAS.
The LAS system is accessed by users in the Salem office of the Department of State Lands,
and also via the states WAN at the Department's Bend office. The Department of State Lands
has a Active Directory based Windows 2000 network. All of the Agency workstations run
either Windows XP or Windows 2000.
Portions of the LAS database are ported to the web via a Cold Fusion MX Web application
server. As time goes on the Department would like to move more transactions to the web.
Moving more of the Agencies business to the web is seen as a means of both lowering costs
and increasing service to the public.
The CASH System is the Agencies system for tracking cash receipts. The CASH System is
integrated with the LAS System and it also interfaces with the States SFMS System.
3. SERVICES TO BE PROVIDED
Las Support and Development
Software maintenance and incident support.
The Department needs continued maintenance and support for the LAS/CASH and LAS/Web Cold
Fusion MX Systems. In a system as complex as LAS and CASH coding errors or inconsistency in
the data come up from time to time. These issues need to be resolved as they occur.
The LAS and CASH Systems are the main business systems at the Department. Making changes to
the LAS/CASH System is even more problematic now that LAS data is available 24x7 on the
web. Making changes to an existing business system that is in constant use is not a trivial
exercise. The Department relies upon the vendor to make changes to a system in constant use
without negatively affecting other parts of the system.
New Features to be added to the System
LAS/CASH Integration Related tasks
The LAS/CASH Systems have been recently integrated to allow the CASH System to generate
invoices from fees that originate in the LAS System. A query interface is needed to allow
agency staff to determine the source of funds. Other tasks that need to be accomplished
are building an SFMS System export interface and fee maintenance screens within LAS.
Rework of the LAS Documents Interface.
The LAS System currently has a document management component. This component needs to be
revised so that documents can be managed and retrieved from multiple systems. For instance
the e-Permits System will need to access documents loaded into LAS. The Cold Fusion web
system needs to be able to access some of the same documents. The document changes should
also work well with documents that are built with Adobe Forms Factory.
Complaints/Violations to be reworked into "Enforcement Action"
Complaint and Violation records need to be reworked into a new type of record
called "Enforcement Action." These two items need to be linked to increase staff data entry
efficiency. Currently there is no relationship with the data in Complaints and Violations.
Site and players information should be maintained as a group much as is currently done with
Applications and Authorizations. New reports are needed to help gauge the effectiveness of
Agency enforcement efforts.
Rework the Mitigation Component of LAS
In general the vision would be to consolidate the PTP (PIL) and Mitigation Bank screens as
tabs in the physical mitigation screen and create new entries in the Physical Project Type
for PTP, Bank Withdrawal, or Hybrid type of Mitigation.
Integrate GIS Functionality with LAS
The LAS System needs to be integrated with ArcGIS Server. This integration would allow LAS
sites that are defined as GIS polygons to be analyzed using the all of the GIS datasets
that the Agency has accumulated as well as allowing the use of the latest GIS tools.
Specifically the integration will allow for new LAS sites to be defined as tax lots as
defined by county provided GIS datasets. LAS needs to be provisioned allow new sites to be
created by non-GIS staff. From the site record in LAS a user can quickly open up a 'zoomed
in' browser based view of the site along with previously defined GIS layers. Optionally it
is desirable to allow the LAS program to be launched from a browser view that displays LAS
sites along with other GIS layers. If for instance a user clicked on a link representing a
specific authorization the LAS System would start up and the specific authorization detail
screen would be displayed.
By offering a path from LAS to GIS and from GIS to LAS the systems can at least at an
elementary level to be considered integrated.
Anticipated development tasks consist of the following:
A. Design a geodatabase model in the GIS to store Site features.
B. Using the existing coordinates representing sites, capture taxlots and attribute with
LAS information. Import parcel features (taxlots, sections, etc) into the new Site layer
(s) and load into ArcSDE. Manual efforts will be needed to capture parcels where taxlot
layers do not exist.
C. Load other base map data into ArcSDE and updating ArcIMS services to reference data in
ArcSDE.
D. Develop an ArcView application which references base map data in ArcSDE. The user has
a local instance of the site data to create site features and assign a LAS id. A site
editing tool is developed to simplify the creation and attribution of the site feature. A
data management utility will be developed and used to import new and modified site features
into ArcSDE for publishing purposes. Site features then would be accessible from the
ArcIMS application for view and query purposes.
E. When creating a record in the LAS system, if the user provides township, range, section
information, or a taxid for a parcel, an application would locate the land parcel from the
existing data to auto create the site feature in the site layer. The LAS ID would
automatically be assigned. Additional customization would allow the user to launch ArcIMS
from LAS to view the location of the LAS site for the currently selected LAS record.
Customization would also be needed to allow the LAS application to receive a request from
the ArcIMS application to select the corresponding LAS record for a selected site feature.
Convert as many LAS sites as practical to GIS Polygons
Analyze old sites in the LAS System, Convert many of them to Polygons.
Whenever possible older point style sites need to be converted from the old "center of
section" type of site to a more meaningful GIS polygon style site based on the tax lot that
is indicated on the site record. Doing this conversion would make older site data much more
useful in the ArcIMS environment.
4. PROTEST
Per OAR 125-247-275(3) an affected person may protest the determination that the services
are available from only one source. Per OAR 125-247-0710(3), written protests must include:
1. A detailed statement of the legal and factual grounds for the protest;
2. A description of the resulting harm to the Affected Person; and
3. The relief requested.
Written protests must also reference the Sole Source Notice number (141-1042-07), must be
signed by an authorized representative, and must be delivered in hard copy to the following
address by December 27, 2007 at 4:00PM. Emails and faxes are not accepted.
State of Oregon
Attn: Eric Andersen
Department of State Lands
775 Summer St NE #100
Salem, Oregon 97301
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Control # 975364 |
|
|
|
|
|
|
