Tag Archives: ArcGIS Online (AGOL)

Warren County GIS: A Showcase of Geospatial Content for County and Local Government

Posted on by
Reply

Program’s modest beginning started in the late 1990s with AutoCAD files and a copy of ArcInfo

Now spending a significant amount of time upstate New York in Essex County, we now find ourselves looking for different routes to take back and forth from southeast New York State instead of the “go-to” I87/Northway option every time.  Just to mix things up – the four-plus hour drive going the normal route can get to be a bit monotonous.

So it was in September I came south out of Ticonderoga headed to Hague (yes, named after The Hague in the Netherlands) on the northern end of Lake George – an area I had never been to.  And it did not disappoint.  Though ultimately to State Route 8 (aka Graphite Mountain Road) to a new Adirondacks trailhead:  Swede Mountain Firetower.  Even though the round-trip hike isn’t that long and relatively easy, it was getting late and I didn’t even get out of the car while in the trailhead parking lot.  Instead, making a note to print out a trail map when I got home.  A couple days later and not having a clue what trail maps were actually available, I Googled “Swede Mountain Firetower trail map” and a candidate list of URLs and image options were immediately returned.  Randomly selecting the one below,  the cartography caught my eye and I quickly looked for the map’s author.  There on the bottom left:  Warren County GIS.  

It was quickly then off to the Warren County GIS website.  Which became the genesis of this article.

Warren County GIS

Just by coincidence, this article coincides with the release of the new Warren County GIS Hub as announced by long-time county GIS Administrator, Sara Frankenfeld.  Overseeing a countywide GIS program judiciously developed over the course of more than two decades – from the days of ARC/INFO coverages to 2022 mobile field apps and interactive online viewing applications.  Also available through the program and Hub is a rich repository of dozens of hardcopy maps available for download covering areas such as countywide outdoor recreation, history, demographics, municipalities, planning and the environment and much more.   An amazing amount of content bundled into three main categories:  Web Maps and Apps | Maps for Print | Download Data.

Background

Originally from the northside of San Francisco Bay in Marin County and earning a degree in Geography from Northern Arizona University, Frankenfeld came to the east coast to initially start work with Dutchess County.  After a short stint with NYSDEC she ultimately made her way to Warren County in 1999 where she got started with a copy of ARC/INFO on a standalone computer in the county building basement.   The county had created a new GIS position in the Planning Department to help convert the tax maps to AutoCAD and then over a period of time converting from AutoCAD to ARC/INFO and then later to geodatabase. 

Over the next four years, she was successful in winning over several other departments on the value and usefulness of GIS technology which she accomplished by focusing on easy, visible “wins” such getting people to use the newly available digital tax parcel data (linked to the RPS data) as quickly as possible and making hardcopy maps.  Lots of maps.  The visibility of the Warren County program also expanded by her working with municipal government zoning administrators and assessors and providing access to the new digital parcel data and including zoning maps,  wetlands data, and FEMA floodplain maps.  A New York State Archives and Administration (SARA) grant enabled the development of a parcel viewer app sby AppliedGIS – where she would later go to work for several years – called the Spatial Data Viewer.  The groundwork was also laid for the implementation of ArcIMS and Imagemate Online.  Somehow she also found time to include outreach programs to local schools and GIS Day.  

After a period in the private sector with (then) AppliedGIS/Fountains Spatial, she returned to Warren County in 2013 where she remains today.  

Today’s Environment

In 2022, the Warren County GIS program is built totally around the ArcGIS Online (AGOL) environment.   Frankenfeld states AGOL has “totally transformed the workplace” and furthers her two main goals of (1) improving public access to data and (2) streamlining/improving processes for county departments and organizations the GIS program supports.  She, along with GIS Specialist Amanda Beck, have embraced StoryMaps, Dashboards, Hubs and Survey123 in ways to make it easy for non-tech users to create and maintain data and access it.  While many of the combo Survey123/dashboard applications are internal facing, others, like the Lake George Milfoil Harvesting real-time app is available to the public.  And so is the Capital Improvement Project Planning viewer.  Both respond to GIS requests from local municipalities, local organizations including  the Adirondack/Glens Falls Transportation Council (AGFTC), Lake George Park Commission and the Lake Champlain Lake George Regional Planning Board – all of which have tech support contracts the County.  Projects range from data compilation to hardcopy map preparation to creating and supporting online apps.  Usually these three organizations know exactly what they want, but GIS staff we do often try to suggest ways to streamline or improve their requests.  For example, County GIS staff helped AGFTC come up with a method to inventory sidewalk/crosswalk/curb ramps for ADA transition plans that proved really popular and resulted in a training session for all the Metropolitan Planning Organizations (MPO) in the state.

Dashboard for Adirondack/Glens Falls Transportation Council’s Transportation Improvement Program projects.

Having transitioned to ArcGIS Pro to support data editing, cartography and more complex analysis, Warren County GIS staff do a majority of their work in AGOL which includes the mobile pieces Field Maps and Survey123.  They still collect GPS data as needed (usually related to recreation or e911) and support field operations, such as collecting milfoil harvest or infrastructure data, for other users.  They also have Trimble boosters and cell phones which can be checked out to both county staff and municipalities for field data collection along with field worker licenses.   While there are still a few remaining ArcGIS desktop users, most users are using AGOL with named users in Planning, Soil and Water, Public Affairs, the Sheriff’s Department, Office of Emergency Services, Public Works, and Parks and Recreation.  Address and road centerlines are uploaded to the state twice a year and parcel data once a year.  A large current project Sara and Amanda are currently working on is building additional GIS capacity and functionality in County Department of Public Works.

Except for Queensbury which has its own full-time GIS staff person, Warren County GIS supports all municipalities in the County.  At the beginning of the program, Sara had  set up each municipality with desktop GIS as well as providing training and support.  In hindsight and it comes as no surprise this desktop support  was the most time consuming element of her job in the early years.  With the advent of online GIS, County staff has transitioned most of the towns off of desktop GIS, although there are a small number of towns which still use the desktop client.  Most local communities across the County now utilize new AGOL applications.   “We often will take the initiative with projects for the towns that relate to work the County Planning Department is doing such as the Warrensburg buildout analysis“, notes Frankenfeld, “as well advocating the adoption of Field Maps for maintaining water and sewer data.”

New GIS Hub

As noted previously, the new Warren County GIS Hub contains three main areas of content:  Web Maps and Apps | Maps for Print | Download Data.  Each area is then broken down further thematically into categories such as recreation, environment, transportation and infrastructure, planning and zoning, history, citizen reports and more.  With an established user community in County government, most of the time departments and organizations now approach GIS staff directly with applications to develop to support their business needs such as the Safe Pace, Opioid Dashboard, Storm Reporter, TIP viewer, etc).  Other projects have been initiated by GIS staff themselves such as the covid hub and election polling locator.   GIS staff work frequently  with other Planning Department and and apply grant funding to create projects such as History Mapper and the letterboxing challenges (Letterboxing Trail and Historians’ Challenge).

Geospatial viewers are excellent for publishing public transportation systems content. In addition to making time tables and schedules available, ones such as the GGFT also include important public sites such as health care facilities.

Today the COVID Hub is the most popular app though much simplified from early COVID and no longer maintained by the GIS team.   It’s had around 1.5 million views  since its inception in April 2020 – not bad for a county with a population of 64,000   The next most popular is the parcel viewer app (Community Map), which gets about 12k views a month.  After that, the First Wilderness website (about 7k views a month) and the Recreation Mapper which gets a couple hundred views a day, higher in the summer.  Warren County’s primary industry is tourism and is an outdoor recreation destination, so trail maps and recreational resources are popular content and Sara and Amanda spend a substantial amount of time creating and maintaining recreation data and providing access to it.

Warren County GIS provides technical support to the Lake Champlain Lake George Regional Planning Board which extends beyond the Warren County footprint. This viewer contains both American Community Survey and 2020 Census data for areas in the five north country counties covered by the Regional Planning Board

Though the application was closed in August, another public facing app focused on the American Recovery Plan Act (ARPA).  Survey123 was customized to create an application for those organizations interested in applying for ARPA funding.  The applications were made available to committee members for review through a Dashboard, and scoring was completed using another Survey123 form.

American Recovery Plan Act (ARPA) grant monies provides funding for investment in a wide ranges of community programs and services including geospatial efforts in the rehabilitation and mapping of infrastructure systems.

Sara’s Law

There probably aren’t many geospatial professionals working today across the Empire State that are familiar with Sara’s own little piece of New York State GIS history.  The year was 2002 and it was during her first stint with Warren County.  While using a GPS unit to map the locations of fire hydrants in the North Creek area, she was “challenged” by the professional surveying community of mapping features in a manner/way she was not qualified to do so.   Her post to New York State GIS listserve at the time describing the events read:

“In January, I(Sara) was contacted by an investigator from the New York State Education Department’s Office of Professional Discipline.  They had received a complaint from a surveyor stating that I was surveying without a license.  I was using a Trimble Pathfinder Pro XR GPS unit to collect fire hydrant locations and then plot them on a reference map.  Two investigators met with myself, our planning director, and our county attorney.  The investigators were unfamiliar with GPS and GIS and were basically on a fact-finding mission.  The investigation has progressed, and today we met with the two investigators, an attorney from the Office for Professional Discipline and a surveyor from the New York State Board of Licensed Engineers and Land Surveyors.  The state’s attorney told us at the beginning of the meeting that after reviewing the facts in the case, they do feel that we are guilty of practicing surveying without a license.  She then gave our county attorney a chance to state our case, which I thought he did very well. We were informed that the board will make a decision within the next week.”

At the time, it WAS a really big deal in the statewide geospatial and surveying communities – particularly New York State Association of Professional Land Surveyors (NYSAPLS) and the subject of much discussion and debate.  Significant in that it marked, for the first time, the visible intersection of emerging GIS/geospatial technologies and the professional discipline of surveying – and by extension, engineering in New York State.    While legislation (A01927 & S04396) was proposed in the 2007/2008 timeframe looking to “enhance the definition of land surveying with current standards and tools, i.e., GPS”, nothing was ultimately passed.  And along the way over the course of several years, the discussion and the proposed legislation became known as “Sara’s Law”.  

Little did she know the backpack GPS unit she was using in 2001 in North Creek would one day be the beginning of bringing these different, but similar geospatial technologies together as they are today.   Sara’s place in NYS GIS lore is secure.  

Summary

In addition to the broad presence the Warren County GIS program has throughout county government, it also represents the great relationship and guidance county geospatial programs can provide and offer to local governments.   Local governments that often have both limited financial and technical resources can benefit greatly from county GIS which have technical expertise and infrastructure in place.  A model that can be replicated in other areas across New York State.   

Contact

Sara Frankenfeld
GIS Administrator
Warren County GIS
Warren County Municipal Building
Lake George, NY 12845
frankenfelds@warrencountyny.gov
518-761-6410

GeoSpatial Business Spotlight: H2M

Posted on by
Reply

Location:        Corporate Office in Melville, New York /  10 Other locations 

Website:          www.h2m.com

Employees:    372 in Melville / 110+ in satellite offices

Established:   1933

H2M is a multi-disciplined professional consulting and design firm focusing in the fields of architecture, engineering, and environmental sciences. From treatment facilities to public safety buildings, land surveying and road reconstruction, and from site assessment to remediation, H2M has helped design and build throughout many communities across New York State since 1933.

Geospatial Support in Water Supply Systems

H2M has built its engineering practice around its service to water clients working directly with municipal water suppliers and private water utilities. The company’s work in this space has grown significantly over the past five years and is built on decades of combined municipal and private A/E experience. Recent work has focused on supporting public and private water systems to comply with new U.S. Environmental Protection Agency (EPA) Revisions to the Lead and Copper Rules which require an initial inventory by October 16, 2024. One of the rule’s requirements mandates the inventory must be made publicly available online for systems serving a population of more than 50,000 people.

H2M’s primary water-related consulting includes, but is not limited to, comprehensive and cost effective water engineering, water quality analysis, distribution system mapping, water storage tank inspections, water quality testing services, lead service line (LSL) inventory, leak distribution analysis, main break mapping, hydraulic (pipe) modeling, and a full suite of online and mobile mapping applications utilizing industry leading GIS software solutions. Fully integrated GIS applications include access to maintenance logs, field notes, spur maps, tap cards, valve sketches, as-build drawings, and photos.

The scanning and indexing of historical hardcopy records of water system features adds great context and valuable information to new GIS-based applications

Complaint tracking, customer notification, and work order management functions are also supported by H2M as many infrastructure GIS systems are integrated with Enterprise Asset Management (EAM) programs such as Cartegraph, IBM Maximo, Cityworks, Tyler, AssetWorks, Infor, and Lucity. These systems often consume published GIS map services, ensuring dynamic connectivity for real-time data analysis and review.

In the realm of field data collection, mapping and viewing software is augmented by powerful mobile apps. ESRI’s suite of mobile software products includes Field Maps, Survey 123, Workforce, and QuickCapture. These mobile apps can be augmented by connecting to external GNSS devices for real-time coordinate correction and higher accuracy data collection.

H2M’s work in the water system space includes the delivery of dashboards to which have become increasingly popular among administrators and decision makers providing a direct and “live” link to water system databases. Such dashboards access to pie charts, spreadsheets, photos, and mapping/viewing windows

Illustrative Projects:

Greenlawn Water District

H2M assisted the Greenlawn Water District in meeting new EPA lead service line inventory requirements by accurately geocoding each of their 12,017 service accounts and creating a data schema that complies with New York State Department of Health requirements. H2M reviewed multiple sources of information to determine service material including approximately 12,000 tap cards, dozens of hardcopy record replacement maps, and municipal records that include date of construction. Based on this information, H2M created an inspection map in ArcGIS Online which allows the District to determine areas with unknown service material and suspected lead which requires further investigation. H2M deployed Esri Field Maps as well as a Survey123 inspection form for the District to record their field inspections. This allows the District to easily document field inspections with notes and pictures, which are tied directly to the core GIS inventory data. Furthermore, H2M created multiple dashboards in ArcGIS Online that provide a dynamic snapshot of known and unknown service line material. This enables the District to quickly see the quantity of accounts that require further investigation and action, should replacement be required.

Online map viewers are easily configured to visually classify the types of water system materials owned by both the water district and by property owners

Village of Garden City Water Department

H2M was tasked to perform the Village-wide Lead Service Line (LSL) inventory and to develop a searchable, map-based data repository within its existing ArcGIS Online environment. As part of this work, H2M’s geospatial team reviewed several thousand individual records provided by the Village, including Excel spreadsheets, Building permits, plumbing permits, and nearly 1500 engineering plans. Information pertaining to water service material was transposed from the source materials to the GIS data. Source documents were also attached to the GIS data to facilitate simplified, map-based retrieval in the future. In addition to scanned documents, H2M incorporated information from engineer field observations, customer reports, and date of construction, as documented by the Nassau County assessor’s office.

Every street-side and customer-side water service within the Village is mapped and catalogued by its documented material and status.

Veolia North America (formerly SUEZ Water New Jersey

Veolia owns, operates, and maintains a network of hundreds of miles of transmission and distribution infrastructure serving more than a million residents in numerous municipalities/institutions throughout the State. In advance of the proposed State of New Jersey lead service line regulations, Veolia launched a comprehensive lead service line replacement (LSLR) program in 2019. Veolia sought assistance from H2M architects + engineers (H2M) as Construction Administrator and Construction Observer to support the regulatory compliance goals and ensure detailed records of field activity, including digital mapping in a GIS framework.

The initial scope of the 2021 LSLR program was characterized by the performance of dig-and-determine for1,900 services and the replacement of approximately 1,200 (lead and non-lead) lines within the Veolia Hackensack Public Water System Identification (PWSID), which has since been expanded to 4,600 dig and determines and 2,500 replacements.

The most challenging portion of compliance for Veolia and H2M was in the identification, cataloging, mapping,and replacement of lead service lines in systems. Service line inventories must result in the categorization of services as either: LSL, brass with suspected leaded gooseneck requiring replacement, galvanized requiring replacement, or non-lead.  Particularly vital to the success of this effort was the creation and maintenance of a set of standards intended to document compliance with the updated federal Lead and Copper Rule and ensure continuity of critical infrastructure data for future operations. To accomplish this, H2M utilized a novel, tablet-based data collection tool to document each crew’s daily activities and ensure immediate QA/QC access to the Veolia leadership team.

H2M’s work has ensured Veolia remains EPA compliant and ahead of the new requirements schedule.

 Hicksville Water District

Since 1996, H2M has supported the Hicksville Water District and as part of this work, a service line material inventory was created for the District utilizing Geographic Information Systems (GIS) technology. Leveraging existing District data which exists in both hardcopy and digital format (tap cards, record replacement maps and date of construction records) and combining with field collected datasets, H2M continues to assist the District in meeting EPA Lead and Copper regulations. This also includes complying with public/private water system data standards established by New York State Department of Health.

ESRI’s ArcGIS Online provides an excellent framework to establish and serve easy-to-use map viewers that will allow residents to look up service material by either address or account number. H2M’s efforts support compliance with the regulation and increased transparency for the municipality.

Water distribution systems built before the 1950s often had distribution networks that were built with lead piping

Summary:

The team of GIS professionals maintain technical fluency in the constantly-changing
GIS industry software and practices including the ESRI and AutoCAD platforms.
Software flexibility and expertise in deploying need-based solutions ensures H2M’s clients have the information they need to continue to provide the highest level of service to our communities.  A more detailed description of H2M’s capabilities and geospatial work in the water systems industry can be found in this presentation.

In addition to applying and creating solutions for the water systems sector, H2M’s geospatial team also provides client services in the following areas:

  • BIM Integration
  • Community Planning
  • Data Conversion
  • Digitization of Records
  • Environmental Data Analysis
  • Geodatabase Design
  • Geospatial Analysis
  • GPS Data Collection
  • Hydraulic Modeling
  • Mobile Application Development
  • Municipal Asset Management
  • Online Mapping
  • Raster Analysis
  • Special District Mapping
  • Wetland Delineation

H2M is an ESRI Business Partner and was recognized with their ArcGIS Online Specialty designation for the continued deployment of successful online and mobile mapping solutions.

Contact:

Christopher M. Kobos, PMP
Director of GIS Services
H2M architects + engineers
538 Broad Hollow Road, 4th Floor East, Melville, NY 11747
tel 631.756.8000 x1731 | direct 631.392.5359 | mobile 516.946.9832 | fax 631.694.4122

LAMP: The Authoritative Liquor License Mapping Application for New York State

Posted on by
Reply

Its not too often one bumps into New York State Liquor Authority (SLA) GIS staff along the geospatial trail across the Empire State, but over there on the sidelines, agency staff continue to maintain an admirable web mapping application entitled  New York State Liquor Authority Mapping Project (LAMP).  I was able to catch up with William Cowley, Public Information Officer for the State Liquor Authority (SLA), to find out more about the 2021 release of LAMP.

Current LAMP Application

With the current version of the application finalized in March of this year, LAMP features an impressive tool kit to explore the vast statewide SLA database containing locational data on active, pending, and inactive permit data for beer, wine, and liquor establishments.  The data can be filtered even more specifically to show those locations which are categorized by:

  • On Premise Liquor
  • On Premise Wine
  • On Premise Beer
  • Off Premise Liquor
  • Off Premise Wine
  • Off Premise Beer
  • There are also permits for manufacturing and wholesale

In addition to serving as a great public information outreach tool, the application also serves as a useful utility and reference tool for applicants seeking a liquor license anywhere in the state.  The user online HELP documentation is excellent and available for download as well.

A 750-foot default search around 148 Martine Ave. in White Plains identifies 23 locations with active NYS liquor licenses, two pending, and 21 former or inactive licenses. Icons are colored coded to match active, pending, or inactive licenses keyed to the Legend box in the lower right-hand corner of the viewing screen (which can be expanded on the live online version).

Nearing almost ten years old, LAMP was originally launched in February 2012.  SLA staff assisted in the original development and launch of LAMP with consultant support from Fountains Spatial.  The 2021 LAMP update was completed with the assistance from Troy-based Cogent Technologies.  The viewing application is built on top of a customized version of ArcGIS Online (AGOL) and utilizes a SQL database to store SLA master data.  Updated daily, the application contains approximately 54,000 active and pending licenses.  The database is built on top of the application process which starts here.  The site makes use of the New York State Geocoding Service with the Google geocoding service as a backup.  LAMP is hosted by New York State Office for Information Technology Services.

Mapping Tools

The viewer includes an impressive user toolbox with several functions being AGOL defaults (i.e. scale dependency of map features, identify tools, .  Others have been customized to provide increased functionality and use of the data.  While changing base maps, scale dependency rendering of data, searching by address or user placed pin, or exporting search results to a CVS file are standard AGOL fare, LAMP offers some cool extended functions including, but not limited to:

    • Query results displayed as a new layer in map legend
    • Customized symbology for all feature types
    • A “measuring” tool which creates both a list of the closet (8) licensed facilities as well as within the 200’ and 500’ regulatory buffer areas (see below). A sample of a proximity report can be downloaded here.
    • An uber robust printing tool with advanced functions to create hardcopy maps
    • Easily include and attribute table view – below the main map window – of a particular layer

There are many other functions well documented and available in the application as well.

Image above highlights customized features in the LAMP application including expanded printing functions and creating new layers which are shown in the layer legend.

While the permitting process does not require the use of LAMP,  most applicants find it useful to identify prior licenses at their chosen location.  The locations of Public/Private Schools and Places of Worship are also included in the application because under the Alcoholic Beverage Control Law, SLA may not issue full liquor licenses (for bars/restaurants or for liquor stores) if the location is within 200-feet of a school or place of worship.  There is also a “500-foot law” which the agency must consider if there are already three or more active liquor licenses within 500 feet of the proposed location.

Integration with SLAM

In an interesting use and application of the SLA database, reference is made to BetaNYC’s SLAM viewer.  Used by community boards when reviewing liquor license applications and sidewalk cafe applications, the public facing tool aggregates information about active liquor licenses, sidewalk cafe licenses, 311 complaints about bars/restaurants/clubs, and restaurant health inspections in NYC onto a single map.   Statewide liquor licensing data can be downloaded from Open Data NY here.

SLAM effectively integrates numerous open data datasets including those from New York City and SLA. Users can zoom to particular addresses and click on relevant features to collect information that may be needed to review a license application. The tool is rendered through Carto – a Web mapping service

Contact:

William Crowley
Public Information Officer
New York State Liquor Authority
William.Crowley@sla.ny.gov