Va. county puts all land data into one site

Fairfax County's repository for land use data combines multiple databases and makes it easier for county employees, land developers and residents to access real-time information about property history.

Fairfax County, Va., has developed a repository for land use data that will make it easier for county employees, land developers and residents to access real-time information about zoning changes, county land ordinances and property history.

The land data repository, based on the MarkLogic 5 database, will boost the productivity of county employees who have to search through multiple databases to find pertinent information and give residents, who now have to search through a plethora of websites for home history data, a single website to access information, according to a Fairfax County IT executive.

Fairfax is the Washington metropolitan area’s largest county, with a population of about 1 million people. About 87 percent of the county’s 395,000 multifamily and single-family homes are wired for the Internet. As a result, “there is a large expectation by the land development community and citizens to have access to land use data,” Woodrow Bellamy, branch chief for the land use team within Fairfax’s Department of Information Technology, said Nov. 16 at the MarkLogic Government Summit 2011 in Washington, D.C.


Related coverage:

How data wizardry can revive America’s cities

North Carolina uses analytics to manage pension fund risks


Giving the county workforce and the public easy access to that information was not easy because the volumes of data resided in disparate systems and in different formats. Systems included Oracle databases, 30-year old mainframe applications, and PDF files.

Land use data is vital to a wide range of constituents. All properties must adhere to Fairfax County land use ordinances. Proposals for commercial and residential development must be reviewed and approved by a variety of Fairfax County agencies.

Land development organizations need to know the history of land or property to determine the total cost of developing a property. They need to know whether the building has asbestos, whether there is a well on the property or whether the previous owners had a property statement indicating that they would put in traffic lights.

Prospective home buyers would want to use the database to see whether a property with a deck or basement put in by the previous owner complies with Fairfax County standards. Or they might want to know whether the home was under investigation for overcrowding. During the housing market collapse a few years ago, some homeowners made makeshift basements and apartments within their homes.

Public officials and residents need access to that type of information, Bellamy said. But the information was all in different databases.

After evaluating several vendors and doing a proof of concept, Fairfax County brought in MarkLogic in July 2011 to consolidate data into a single, searchable database, Bellamy said. MarkLogic 5 is a hybrid database consisting of analytic, content management and search capabilities, which can ingest and analyze structured and unstructured data.

Mainframe data was converted by the end of August. It was put into a test database, and Bellamy’s team showed it to the six agencies it supports. They started using it right away, Bellamy said. In fact, the mainframe systems are being shut off Nov. 18, about a month a head of schedule.

“Several constituent agencies, when we told them we were going to shut down the 30-year-old mainframe system and put [the data] into a searchable database, said, ‘Sure, Woodrow. We’ll see you in a couple of years.' ” However, they were given a demo in September and are now relying strictly on MarkLogic to search this 30-year-old data, Bellamy said.

Bellamy wanted a searchable engine that did not require extensive training for end users, one in which they could just “mouse, click and go.” The repository contains property history and information can be searched by tax map identification, by address or by keywords. For instance, typing in the word "heliport" quickly brings up data on all the heliports in Fairfax and their permits.

“Anyone can access the data,” Bellamy said. The data can be spatially displayed by geographic information systems such as ESRI, which the county uses.

The county needed a repository that also would fit within its infrastructure and didn’t require an extensive number of servers, Bellamy said. The repository works with the county’s VMware environment in which several servers have the capability of running other applications as well.

Bellamy’s team also wanted a system that was based on a fixed-cost model. Some database providers charge by the number of records used, some by the amount of space used, or by the number of indexes they may have built. MarkLogic offered a fixed-cost model wherein the application server, database and indexes are all on one single server. That enables the county to reap the benefits of its investment quickly.

The county is now looking to extend the repository to the public in December and into January 2012.

Bellamy said the repository could possibly be extended for other uses beyond land use incorporating human resources or financial data.



X
This website uses cookies to enhance user experience and to analyze performance and traffic on our website. We also share information about your use of our site with our social media, advertising and analytics partners. Learn More / Do Not Sell My Personal Information
Accept Cookies
X
Cookie Preferences Cookie List

Do Not Sell My Personal Information

When you visit our website, we store cookies on your browser to collect information. The information collected might relate to you, your preferences or your device, and is mostly used to make the site work as you expect it to and to provide a more personalized web experience. However, you can choose not to allow certain types of cookies, which may impact your experience of the site and the services we are able to offer. Click on the different category headings to find out more and change our default settings according to your preference. You cannot opt-out of our First Party Strictly Necessary Cookies as they are deployed in order to ensure the proper functioning of our website (such as prompting the cookie banner and remembering your settings, to log into your account, to redirect you when you log out, etc.). For more information about the First and Third Party Cookies used please follow this link.

Allow All Cookies

Manage Consent Preferences

Strictly Necessary Cookies - Always Active

We do not allow you to opt-out of our certain cookies, as they are necessary to ensure the proper functioning of our website (such as prompting our cookie banner and remembering your privacy choices) and/or to monitor site performance. These cookies are not used in a way that constitutes a “sale” of your data under the CCPA. You can set your browser to block or alert you about these cookies, but some parts of the site will not work as intended if you do so. You can usually find these settings in the Options or Preferences menu of your browser. Visit www.allaboutcookies.org to learn more.

Sale of Personal Data, Targeting & Social Media Cookies

Under the California Consumer Privacy Act, you have the right to opt-out of the sale of your personal information to third parties. These cookies collect information for analytics and to personalize your experience with targeted ads. You may exercise your right to opt out of the sale of personal information by using this toggle switch. If you opt out we will not be able to offer you personalised ads and will not hand over your personal information to any third parties. Additionally, you may contact our legal department for further clarification about your rights as a California consumer by using this Exercise My Rights link

If you have enabled privacy controls on your browser (such as a plugin), we have to take that as a valid request to opt-out. Therefore we would not be able to track your activity through the web. This may affect our ability to personalize ads according to your preferences.

Targeting cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.

Social media cookies are set by a range of social media services that we have added to the site to enable you to share our content with your friends and networks. They are capable of tracking your browser across other sites and building up a profile of your interests. This may impact the content and messages you see on other websites you visit. If you do not allow these cookies you may not be able to use or see these sharing tools.

If you want to opt out of all of our lead reports and lists, please submit a privacy request at our Do Not Sell page.

Save Settings
Cookie Preferences Cookie List

Cookie List

A cookie is a small piece of data (text file) that a website – when visited by a user – asks your browser to store on your device in order to remember information about you, such as your language preference or login information. Those cookies are set by us and called first-party cookies. We also use third-party cookies – which are cookies from a domain different than the domain of the website you are visiting – for our advertising and marketing efforts. More specifically, we use cookies and other tracking technologies for the following purposes:

Strictly Necessary Cookies

We do not allow you to opt-out of our certain cookies, as they are necessary to ensure the proper functioning of our website (such as prompting our cookie banner and remembering your privacy choices) and/or to monitor site performance. These cookies are not used in a way that constitutes a “sale” of your data under the CCPA. You can set your browser to block or alert you about these cookies, but some parts of the site will not work as intended if you do so. You can usually find these settings in the Options or Preferences menu of your browser. Visit www.allaboutcookies.org to learn more.

Functional Cookies

We do not allow you to opt-out of our certain cookies, as they are necessary to ensure the proper functioning of our website (such as prompting our cookie banner and remembering your privacy choices) and/or to monitor site performance. These cookies are not used in a way that constitutes a “sale” of your data under the CCPA. You can set your browser to block or alert you about these cookies, but some parts of the site will not work as intended if you do so. You can usually find these settings in the Options or Preferences menu of your browser. Visit www.allaboutcookies.org to learn more.

Performance Cookies

We do not allow you to opt-out of our certain cookies, as they are necessary to ensure the proper functioning of our website (such as prompting our cookie banner and remembering your privacy choices) and/or to monitor site performance. These cookies are not used in a way that constitutes a “sale” of your data under the CCPA. You can set your browser to block or alert you about these cookies, but some parts of the site will not work as intended if you do so. You can usually find these settings in the Options or Preferences menu of your browser. Visit www.allaboutcookies.org to learn more.

Sale of Personal Data

We also use cookies to personalize your experience on our websites, including by determining the most relevant content and advertisements to show you, and to monitor site traffic and performance, so that we may improve our websites and your experience. You may opt out of our use of such cookies (and the associated “sale” of your Personal Information) by using this toggle switch. You will still see some advertising, regardless of your selection. Because we do not track you across different devices, browsers and GEMG properties, your selection will take effect only on this browser, this device and this website.

Social Media Cookies

We also use cookies to personalize your experience on our websites, including by determining the most relevant content and advertisements to show you, and to monitor site traffic and performance, so that we may improve our websites and your experience. You may opt out of our use of such cookies (and the associated “sale” of your Personal Information) by using this toggle switch. You will still see some advertising, regardless of your selection. Because we do not track you across different devices, browsers and GEMG properties, your selection will take effect only on this browser, this device and this website.

Targeting Cookies

We also use cookies to personalize your experience on our websites, including by determining the most relevant content and advertisements to show you, and to monitor site traffic and performance, so that we may improve our websites and your experience. You may opt out of our use of such cookies (and the associated “sale” of your Personal Information) by using this toggle switch. You will still see some advertising, regardless of your selection. Because we do not track you across different devices, browsers and GEMG properties, your selection will take effect only on this browser, this device and this website.