EDMS INTEGRATION

A common challenge faced by local governments is how to increase visibility and access to key departmental data sets such as electronic documents. Because such data typically resides in specialized systems, it's traditionally been difficult for all agency staff to access and use this data.

Integrating your specialized data sets with GovClarity™ solves this problem and helps you maximize your existing data investments and accelerate decision making by putting information in the hands of your end-users.

The code sample below shows an example data integration between GovClarity™ and an Electronic Document Management System. In this example, documents reside in Microsoft® SharePoint™ and are linked to parcels via APN and displayed on the map.

In this example, a city has documents in Microsoft® Sharepoint™ that it wishes its employees to be able to locate using a map. Each document has metadata associated with it and if that includes an APN (Assessor Parcel Number) then it should be used to for the location of the document on the map. The example takes advantage of a table that has been built that correlates APNs to parcel and/or property data with better accuracy. If there is no APN then the document record is given a location just outside the city boundaries. These records can be moved at a later time to their proper location from within GovClarity by using the Edit Geometry command.

The sample is in three parts written in C#. The first is code to read from the source of the data which in this case is either SharePoint™ or SharePoint™ Online. The example depends on the Document Id Service being activated in SharePoint™. Click on the Data Reader link to view the code.

Note: you must have an active GovClarity™ account to run the sample

The second part of this sample shows how to take an APN in whatever format and locate the parcel and/or property record for that APN. If an exact match cannot be found, it will return an approximate location based on where the other properties on the same page of the assessors book are located. Click on the APN Resolver link to view the code.

The third and final part of this sample contains the main program that reads the data using the DataReader class, finds the parcel/property data using the ApnResolver class, and adds the data to a map layer so it can be visualized. Click on the Program link to view the code.

• View all GovClarity™ Documentation