Click here to purchase!

Having trouble extracting data from RPS Version 4 for analysis or use in GIS?

With HGI's new RPS v4 custom software solution, you will never have this problem again! The application extracts data from your RPS Version 4 database and writes them to a manageable number of tables in a Microsoft Access file (.mdb). A user can change the fields that are extracted using the application's configuration function. Price: $1,500.

Who can use the application?

• Anyone able to connect to your RPS V4 database can use RPS V4 Extract to extract RPS data
• Any GIS or Microsoft Office user can use the extracted RPS data

What are the benefits?
The RPS V4 Extract application is fast and easy to use. It is a stand alone application that works whether you have a GIS or not. The application:

• Provides quick and easy, up-to-date access to your RPS data
• Virtually connects your Enterprise, including your GIS, to your RPS
• Allows you to easily distribute your RPS data to those who need it most, when they need it

And, because it migrates your RPS data into a flexible format-

RPS V4 Extract maximizes the return on your RPS investment!

What is it exactly that RPS V4 Extract does?
The RPS V4 database has over 256 tables. The RPS V4 Extract application lets you create one table that contains one record per parcel (with assessment information, owner information, inventory information, latest sale information, etc.) The application is delivered as a stand-alone, executable that users can:

1. Extract the most pertinent data from the many different RPS V4 Sybase data tables
2. Write that data to a manageable number of tables in a Microsoft Access file (.mdb)

After users make their choices, the extract application creates a single Microsoft Access file (.mdb file) that can contain one table for each of the table(s) chosen to be created. The tables that can be extracted include:

• The Parcel & Inventory (GIS Extract) Table contains one record per parcel. Data is extracted from the following RPS V4 tables: Parcel, Parcel_to_owner, Owner, Assessment, Land, Residential and commercial buildings, Sales, Historical, and Site. As well as many look up tables.
• The Sales Table contains a record for each sale stored in RPS. If a parcel has never been sold there would be no records for that parcel in this table. If a parcel has been sold 3 times, then there would be 3 records in this table for that parcel.
• The Special Districts Table contains a record for each special district that a parcel occupies. A parcel may be located in many special districts. If a parcel is located in many special districts, then there would be many records in this table for that parcel.
• The Exemptions Table contains a record for each exemption that a parcel qualifies to receive. A parcel may qualify for many exemptions. If a parcel qualifies for many exemptions, then there would be many records in this table for that parcel.
• The All Sites Table contains a record for each site on a parcel. There may be many sites located on a parcel. If a parcel has many sites located on it, then there would be many records in this table for that parcel.

Click here to view or download a sample Access data file containing a complete set of RPS V4 Extract tables extracted from a live RPS V4 database.

How do I buy the RPS V4 Extract application?
Please email us and someone will contact you to fill your order.

How do I find out more about the RPS V4 Extract application?
Please email us and someone will contact you to answer any questions.