下载PDF
MarkLogic Helps Fairfax County Residents Become More Civic-minded
技术
- 应用基础设施与中间件 - 数据库管理和存储
适用行业
- 城市与自治市
适用功能
- 商业运营
服务
- 系统集成
挑战
Fairfax County wanted to upgrade their existing Police Events application. This application allowed the public to search, filter, and map police service calls by type, location, and date, and access preliminary police investigation data from Fairfax County's 9-1-1 call center. With more than a half-million data points from all over the county, the data overwhelmed the existing Oracle relational database. The county's GIS database contained data from more than 800 different sources, including libraries, schools, hospitals, most of which have unique schemas, making it difficult to sort through and access. Only a small amount of GIS data was available via the previous Fairfax GIS search application, which was JavaScript-based. This legacy application did not provide the flexibility to constrain searches to specific data layers without customization. The existing database had to search layer by layer, one column at a time, making searches slow and difficult. The county has approximately 800 distinct layers in its GIS database and most have their own specific data schema. For non-GIS staff this can make sifting through all of the information very difficult. The ability to add new datasets as they were identified and provide a set of tools for loading and enrichment was tough. Also, returning information in a variety of formats including JSON, XML, and KML was not possible, and data needed to be RESTful to keep in accordance with current practices.
关于客户
Fairfax County, Virginia is one of the largest counties in the nation, with more than one million residents and a budget larger than that of four states combined. The Fairfax County Department of Information Technology (DIT) uses modern information technologies to improve citizen access to government information and services, including a wide variety of mapping data from the county's geographic information system (GIS). The DIT's goal is to provide the community with convenient access to appropriate information and services through technology.
解决方案
Fairfax County wanted to put more geospatial information directly into the hands of county residents. In order to do so, the Police Events app needed an enterprise-grade NoSQL database solution that could handle the volume of data that the old, relational database couldn't. The department tested several NoSQL databases, including various open source solutions. MarkLogic's Enterprise NoSQL database platform outperformed them all, giving Fairfax County DIT the ability to make complicated queries to its GIS database, and making that data easily accessible to users. MarkLogic gave the department the infrastructure it needed to improve query times on GIS database searches, as well as the ability to make more of that data accessible to the public. MarkLogic was an obvious choice for Fairfax County DIT due to its enterprise-level performance, geospatial support, and unrestricted search capabilities across unrelated data in a geographic context.
运营影响
数量效益
相关案例.
Case Study
Turning A Stadium Into A Smart Building
Honeywell created what it called the “intelligent system” for the National Stadium in Beijing, China, turning the venue for the opening and closing events at the 2008 Summer Olympics into a “smart building.” Designed by highly controversial artist Ai Weiwei, the “Bird’s Nest” remains one of the most impressive feats of stadium architecture in the world. The 250,000 square meter structure housed more than 100,000 athletes and spectators at a time. To accommodate such capacity, China turned to Honeywell’s EBI Integrated Building Management System to create an integrated “intelligent system” for improved building security, safety and energy efficiency.
.png)
Case Study
Smart Street Light Network (Copenhagen)
Key stakeholders are taking a comprehensive approach to rethinking smart city innovation. City leaders have collaborated through partnerships involving government, research institutions and solution providers. The Copenhagen Solutions Lab is one of the leading organizations at the forefront of this movement. By bringing together manufacturers with municipal buyers, the Copenhagen Solutions Lab has catalyzed the development and deployment of next-generation smart city innovations. Copenhagen is leveraging this unique approach to accelerate the implementation of smart city solutions. One of the primary focus areas is LED street lighting.
Case Study
Buoy Status Monitoring with LoRa
The Netherlands are well-known for their inland waterways, canals, sluices and of course port activities. The Dutch Ministry of Infrastructure indicates that there are thousands of buoys and fixed items in and near water environments that would profit from IoT monitoring. One of the problems with buoys for example, is that they get hit by ships and the anchor cable breaks. Without connectivity, it takes quite some time to find out that something has happened with that buoy. Not to mention the costs of renting a boat to go to the buoy to fix it. Another important issue, is that there is no real-time monitoring of the buoys at this moment. Only by physically visiting the object on the water, one gains insight in its status.
Case Study
China Mobile Smart Parking
Smart Parking, powered by NB-IoT technology, is making it easier for drivers to find free parking spots. Cities can better manage their parking assets and maximize the revenue available to them as a result. Drivers searching for parking create congestion and pollution by circling and hunting for available parking. Smart Parking services are able to significantly ease these problems by guiding a driver directly to a parking space.
Case Study
Barcelona Case Study
Barcelona’s heavy traffic and its associated high levels of pollution were the primary factors that motivated some companies and universities to work on strategies for improving traffic in the city centre. Bitcarrier is one of the technologies involved in the In4Mo Project, whose main objective is to develop the applications that form the core of smart mobility, one of the fundamental pillars of the smart city concept.
