Geocode It!

GeocodeIt! is a custom application that allows you load addresses from either a file or a database, then run those addresses through a third-party online service to obtain standardized address and location information.

Location data is very important in many types of data warehouse and business information projects. Obtaining standardized address information including addresses and latitude/longitude data enables your data warehouse to perform analyses that simply aren’t possible without it.  Unfortunately, this data can often be expensive to obtain.  Many organizations will run their information through the an API like Google Maps, but be careful!  If you are storing the results of this data in your data warehouse, you are violating the Google terms of service and you could be forced to throw all of your hard work away – see below.

GeocodeIt! uses Geocode.Farm which is a service similar to Google that allows you to store the data locally so that you only need to check the address once.  (A separate subscription from Geocode.Farm is required to run more than 400 addresses per day.)  This software allows you to quickly get up-and-running with your Geocode project.

Contact us today for a free demo and more information on licensing this product.

 


 

Google Terms of Service: https://developers.google.com/maps/terms

Excerpt:

  1. No caching or storage. You will not pre-fetch, cache, index, or store any Content to be used outside the Service, except that you may store limited amounts of Content solely for the purpose of improving the performance of your Maps API Implementation due to network latency (and not for the purpose of preventing Google from accurately tracking usage), and only if such storage:
    1. is temporary (and in no event more than 30 calendar days);
    2. is secure;
    3. does not manipulate or aggregate any part of the Content or Service; and
    4. does not modify attribution in any way.
  2. No mass downloading. You will not use the Service in a manner that gives you or a third party access to mass downloads or bulk feeds of any Content. For example, you are not permitted to offer a batch geocoding service that uses Content contained in the Maps API(s).

Radiology Tracking Board

Efficiency is necessary to run a world-class radiology department. Data Warehouse Consultants developed a virtual tracking board that allows nurses to maintain updates on patients who are getting x-rays, MRI’s and other radiology services across many floors and service rooms. This board enhances communication within the unit and reduces the need to make phone calls by integrating nurses notes with existing event messages that are sent over the internal message router. This solution was developed specifically to meet the needs of radiology departments by combining several available technologies into one integrated solution at a fraction of the cost of other medical software providers.

For a free demo of the virtual tracking board, contact us today!

Neonatal Breastmilk Tracker

intermecData Warehouse Consultants developed a system to help nurses and other caregivers verify that children residing in the Neonatal Intensive Care Unit (NICU) are given the correct mother’s breast milk when the mother chooses that option for her child. Prior to implementation of our solution there was a greater chance that confusion could occur with the breast milk bottles, and children could be given milk from an unrelated mother. There was also no audit trail to confirm the correct breast milk was given if a questionable situation arose. This solution provides mobile technology that verifies a match between the baby and the bottle before the breast milk is given.

Our solution provides a mobile application allowing the NICU caregiver to quickly scan a bar code on the bottle and the wristband of the baby to verify they are a match. It also allows for the common situation of multiple births, where one mother can provide breast milk for several babies. This simple system has been instrumental in reducing errors in breast milk delivery, and for providing an audit trail that confirm the correct milk was provided to each child in the NICU.

Contact us today for a free demo!

International Services Database

Data Warehouse Consultants collaborated with International Services at the Children’s Hospital of Pittsburgh to convert a Microsoft Access database used to track referrals for pediatric services for patients in global locations. The new application is enterprise-class and based on ASP.NET and Microsoft SQL Server technologies. It is used by department staff to monitor referrals and track the workflow of new patient referrals from the time the original referral is received until the time when the patient arrives and receives services at Children’s Hospital.

For a free demo, contact us today!

Vascular Anomalies Database

Data Warehouse Consultants worked with the Pediatric Vascular Anomalies Center at the Children’s Hospital of Pittsburgh to convert a Microsoft Access database used to provide patient care into an enterprise-class web application based on ASP.NET and Microsoft SQL Server. This application is used by department staff to track their own patients over time. Before each patient visit it helps the department to identify patients that are due to return, and easily generates reminder mailings for each patient. Once the patient arrives at the clinic the department uses the application to monitor the activities the patient experiences in the clinic and to track follow-up services and visits.

Contact us today for a free demo of the vascular anomalies database!

Cleft Center Database

Data Warehouse Consultants worked with the Cleft-Craniofacial Center at the Children’s Hospital of Pittsburgh to convert a Microsoft Access database used to provide patient care into an enterprise-class web application based on ASP.NET and Microsoft SQL Server. This application is used by department staff to track their own patients over time. Before each patient visit it helps the department to identify patients that are due to return, and easily generates reminder mailings for each patient. Once the patient arrives at the clinic the department uses the application to monitor the activities the patient experiences in the clinic and to track follow-up services and visits.

For a free demo, contact us today!

Heart Center Database

Data Warehouse Consultants worked with the Heart Center at the Children’s Hospital of Pittsburgh to convert a Microsoft Access database tracking hundreds of thousands of patients into an enterprise-class web application based on ASP.NET and Microsoft SQL Server. This application has evolved to include patient tracking for various areas within the department including Adult Cardiology, Heart Failure and Heart Surgery among other areas. The live HL7 feed from the core EMR provider keeps the department’s database up-to-date, which saves time for heart center staff and allows them to focus on more effective delivery of care.

Contact us today for a free demo!

Neurodevelopment in Rare Diseases

The Children’s Hospital of Pittsburgh’s maintains a world-class Program for the Study of Neurodevelopment in Rare Disorders led by Dr. Maria Escolar. Data Warehouse Consultants has developed an extensive Virtual Medical Home application for this organization that allows them to track and communicate more effectively with their patients around the world. This application has developed over time to include many different functions including communicating with patients, tracking patient development and general improvement of patient care.

Contact us today for a free demo of the virtual medical home application!

Human Services Data Warehouse

The Allegheny County Department of Human Services is on the cutting edge of using business intelligence best practices to provide superior service to clients of programs the county offers. The core of this service is the DHS data warehouse which compiles program data from over 25 data sources within the county. Data Warehouse Consultants was instrumental in the design and deployment of the latest version of this technology. Our firm also developed several customized software applications for use with the data warehouse, which have been valuable tools in digesting and using the vast amount of data now available to program staff.

For a free demo, contact us today!

DWC HL7 Receiver

HL7 messages are the primary method that medical systems use to communicate in real time. This product allows the capture and storage of HL7 messages into a generic schema that can then be used for any purpose. Once the HL7 message is parsed and stored in a database, legacy applications and ETL can be run on the messages to extract the meaningful data for your application. This software has been certified to operate at many large hospitals, and supports multi-threading and error handling required for such operation. This small software service makes it easy to catch HL7 messages without having to use a big EMR.

Please contact us for a free demo and for more information on your specific need.