A lot of these projects are either departmental or the result of a self-service project handed-off to the IT organization to be “right-sized” and transitioned from the desktop to a server-hosted solution. In less-formal solutions, the “ODS” layer in this diagram may be little more than a small database on an existing server with lookup tables populated by a weekly scheduled SSIS package or stored procedure. More and more of the projects I inherit from consulting customers and previous developers resemble the following diagram: Perhaps a related topic for another time but always consider options to incorporate enterprise scale with modern analytics. I love tools like Power Query and Power BI Desktop to develop simple BI solutions quickly. Consequently, by using this approach, you are also removing the safety net and limiting options to scale and expand the solution. The bottom line, before getting into the weeds on this topic, is that there are cases where I think it makes perfect sense to skip the usual steps of staging, transforming and modeling data into a relational data mart. The more experience I gain with these newer tools in business settings has me ever thinking about using best practices and the right approach for scaling BI solutions of all sizes. The alleged advantage of sourcing data directly from within the modeling tool might seem to suggest that a formal ETL process and dimensional modeling exercise is unnecessary. I’m including SSAS Tabular on the “self-service” list because it is derived from Power Pivot and often used for “quicker” IT-managed BI projects.
Includes a statewide file geodatabase and address locators.Ĭlick on the product name in the list above to view more detailed metadata and access data download links.Self-service data modeling tools like Power BI Desktop, Power Pivot and SSAS Tabular promote the advantage of using data from multiple data sources.
Other points are located as assessor parcel centroids.ģ) Statewide Address Points for Geocoding - Basic address points with fields added to facilitate geocoding inside ArcMap. The points for the most part represent building centroids. Where more than one address is located at a single location multiple points are included (i.e. A geographic community name is appended to the street name field when a neighborhood OR sub-community value exists due to multiple MSAG communities or an address community name.Ģ) Basic Address Points - Points features with each point having an address to the building/floor/unit level, when that information is available. This export includes the MassGIS master address ID and the site name. Data Productsĭata exports from the MAD available for download include:ġa) Basic Address List - A tabular listing of addresses without units or MassGIS’ master address ID.ġb) Advanced Address List - A tabular listing of all addresses to the building/floor/unit level, when that information is available the street name is parsed to its various parts. It is a best practices guide for the creation and storage of addresses for Massachusetts Municipalities. As the database is very dynamic with changes being made daily, the data available for download will be refreshed weekly.Ī Statewide Addressing Standard for Municipalities is another useful asset that has been created as part of this ongoing project.
At present, the MAD contains 3.2 million address records and 2.2 million address points. The MAD contains both tabular and spatial data, with addresses being mapped as point features. The MAD was also validated for completeness using the Emergency Service List (a list of telephone land line addresses) from Verizon. Addresses from utilities were “anonymized” to protect customer privacy.
Statewide deployment of this new 9-1-1 call routing system was completed in 2018.Īddress sources include the Voter Registration List from the Secretary of the Commonwealth, site addresses from municipal departments (primarily assessors), and customer address lists from utilities. MassGIS developed and is maintaining the map and address information that are at the heart of this new system. MassGIS is working very closely with the State 911 Department in the state’s Executive Office of Public Safety and Security on the Next Generation 911 Emergency Call System.