Geospatial Business Spotlight: The CEDRA Corporation

Company Name:         The CEDRA Corportation

Location:                     1600 Mosley Road, Suite 500, Victor, NY  14564

Website:                      http://www.cedra.com

Employees:                 12

Established:               1985

The CEDRA Corporation offers GIS based software for mapping, civil engineering design and modeling, surveying and database maintenance applications. CEDRA’s AVseriesTM suite of software operates directly within Esri’s GIS software (ArcGIS® 9.x and 10.x), thus eliminating the need to switch back and forth between various software packages. CEDRA software is developed entirely in-house and marketed worldwide to public works agencies, tax assessors, utilities, municipalities and private sector companies.

Complementing CEDRA’s Software Development Division is CEDRA’s Professional Services Division which has performed consulting projects throughout the U.S. and specializes in developing, populating and maintaining GIS databases.   CEDRA’s Professional Services Division offers consulting services to clients for a multitude of applications including CEDRA-specific software solutions or can be totally non-CEDRA software related consulting projects. CEDRA staff is highly proficient in GIS Analysis, Data Capture, Data Conversion, Map Production, Routing and Custom Application Development in toth the desktop and server environments.  As an authorized Esri business partner and reseller, CEDRA has a long history in the use and application of Esri’s GIS suite of software dating back to 1987.

CEDRA’s corporate mission is to provide services and software that improves the efficiency and productiveness of its clients. This goal is achieved by (a) developing software that is production oriented and (b) offering services that enable clients to streamline workflows. CEDRA believes the more automated a workflow can be made, the more efficient a client will be and a higher quality product will be produced. CEDRA offers Expertise, Experience and Commitment when undertaking a project.

Illustrative CEDRA products and services include:

Wayne County E911, Lyons, New York

Under this project CEDRA assisted Wayne County staff in developing the County’s E911 street database. Specifically, the work involved acquiring the NYS Street Address Mapping (SAM) data, extracting the street data for Wayne County, and working with the County in verifying and updating the street center line database for use in the County’s E911 system.

In performing this work, CEDRA staff was on-site at the County’s office performing the work and training County staff in the process. A workflow was developed and adopted by the County. Additionally, a training guide was developed enabling County staff to maintain the street center line data with their own resources. Continue reading

GIS Common Core Part 3: Health and Human Services (HHS)

Through a sequence of articles posted in eSpatiallyNewYork, I have proposed a series of GIS applications which provide a framework for establishing and maintaining  GIS/geospatial programs in local  governments (villages, towns, cities, and counties) across  New York State.  These applications areas are referred to as the Geospatial Common Core, many of which are integrated with local government office and administrative business systems.  Others are utilized in the support of regulatory reporting programs.    Together, the Geospatial Common Core contribute towards building sustainable geospatial capacity for local governments.   This is the third installment of the series.

“GIS Common Core” application areas in New York State local governments

The first article entitled Part 1:  Infrastructure and Asset Management focused on the growing and critical role local government GIS geospatial programs continue to serve in rehabilitating and maintaining the decaying and outdated New York State – and national – public infrastructure.  The second article Part 2:  Work Orders, Permitting, and Inspections (WOPI) published in March 2016 focused on geocentric software packages which are ubiquitous in government programs supporting work flows in areas such public works, health, planning, clerk, assessment, buildings/code enforcement and inspections.  Organizations investing and integrating WOPI systems with GIS will continue to help build long-term sustainable geospatial programs in local governments.

Part 3:  Health and Human Services (HHS)

Health and human services can often be broadly defined from one location to another but for the purposes of this article it includes a wide-range of government programs including, but limited to, public health services, social services, public assistance, youth and veterans programs, disability programs, housing and homeless services, child protection services, as well as the important network of contracted service providers governments rely upon in providing counseling and related support services.  I have long been an advocate of building geospatial capacity in these local government program areas.

Why?

Statewide local government HHS budgets typically dwarf other local government operational program areas with regard to annual appropriations.  While I am not a budget analyst and admittedly it’s sometimes difficult to follow the money trail of appropriations vs. revenues vs. actual tax payer costs in county budgets, here are a few examples to illustrate the size and magnitude of HHS programs in a selected 2017 NYS county budgets (Data/information from County webpages as noted):

  1. Stuben County 2017 Budget. (Page 3).  Pie chart indicates nearly 47% of the appropriated budget dedicated to Health and  Economic Assistance/Opportunity (includes Social Service disciplines) program areas
  2. Ulster County 2017 Budget. (Pages 1 & 2). Table and pie chart indicate nearly 42% of the appropriated budget dedicated to Public Health and Economic Assistance/Opportunity program areas
  3. Erie County 2017 Budget. (Pages 93, 159, and 174). Appropriations (rounded in millions) in Health ($86M), Mental Health ($47M) and Social Services ($591M) account for almost 50% of the $1,455,000,000 recommended general fund budget.  (Note:  There are other references to the 2017 budget being closer to $1.7B). Either way, HHS budgets are a significant portion of the overall county budget
  4. Albany County 2017 Budget. (Page 34). Employee Count table lists 657 of 2,535 County employees (26%) are in the Child, Youth, and Family Services (170), Social Services (308), Mental Health (90), and Dept. of Health (89)
  5. Suffolk County 2017 Budget. (Pages 101 and 366).   Appropriations (rounded in millions) in Health Services ($249M) and Social Services ($628M) account for nearly 30% of a recommended $2.9B budget
  6. Monroe County 2017 Budget. (Pages 157 and 275).  Appropriations (rounded in millions) in Human Services ($536M) and Public Health ($62M) account for nearly 50% of an adopted $1.2B budget
  7. Continue reading

10 Questions: Dale Morris

Dale Morris is one of New York State’s most recognized and senior GIS statesmen.  With a distinguished civil service career spanning 38 years, he has contributed significantly to the NYS GIS community in many capacities to say the least of directing one of the most established GIS programs in the state at Erie County – and its far reaching influence in western New York.  Ten questions seemed like a slight to an individual with such a body of professional work, so the eSpatiallyNewYork editorial team gave him permission to push it to 15 questions. Or something like that.  Enjoy.

eSpatiallynewyork:  How long have you been with Erie County?

Morris:  I’ve been in the Department of Environment and Planning since 1981. Prior to this I worked as a Planner for the Town of Amherst, NY and before that the Erie and Niagara Counties Regional Planning Board. I graduated from Cornell University with a Master’s Degree in Regional Planning in 1977.

eSpatiallynewyork:  When did you start doing GIS work?

Morris:   Working initially as a Planner for Erie County presented  many opportunities for making and using maps. In the 1980s we were still using Mylar, zipatone, and Leroy Lettering Sets for making maps, which is tedious, time consuming, and not easy to change. I began to investigate the world of digital mapping, which was still in its beginnings as a desktop product. I started with the DOS version of MapInfo. I recall how amazed we all were that we could do something as simple as draw the County and municipal boundaries on-screen. Looking back on it now it all seems so rudimentary!  Regardless of how basic it was, my Division became known for our ability to make computer drawn maps. At that time there wasn’t much concern about the database behind the maps- it was enough to be able to draw and edit maps digitally rather than by hand.

As desktop mapping grew in popularity through the 1990s a number of County departments began independently looking into it. This usually resulted in them calling me to ask for advice or data. Of course, this also meant that everyone was using different systems, and at that time it made exchanging data between systems very difficult or impossible. It was a classic case of disjointed silos of data and applications.

A change in County administration in the late 1990s brought new management in our department, and I was challenged to prepare a white paper for moving the County further forward into the digital mapping world. I proposed creating a new County Division that would be empowered to centralize decisions relating to geospatial technology (by then we could use terms like “geospatial” without getting blank stares!). The Office of Geographic Information Services (OGIS) was born in 2001, and I have been the Director since then. So for me personally, my career started with both feet in the urban planning field, then a gradual shift to one foot in planning and one in digital mapping, and then finally both feet in GIS. I do very little “typical” planning anymore, even though OGIS is part of the Planning Division.

While OGIS is an Office within the Department of Environment and Planning, only a portion of our work is related to this department. We work very closely with our IT shop to maintain and operate the County’s GIS technology infrastructure, and with other departments and outside agencies who either use our enterprise GIS technology or who need direct assistance with their mapping needs.

eSpatiallynewyork:  What’s the relationship between your office and Niagara County?

Morris:  We have a formal Intermunicipal Agreement (IMA) with Niagara County for GIS Services. The agreement is for a five year period and we are well into the second of these five-year agreements. Erie County hosts Niagara County’s geospatial data and provides on-line mapping services to Niagara County. The two counties are connected by a high-speed microwave link, which operates very well. In essence, Niagara County is simply like any other Erie County department that taps into the Erie County enterprise GIS network. In addition to providing Niagara County this service for a fee, the IMA provides a framework for backup of GIS data between the two counties, and as well defines a GIS “mutual aid” protocol for sharing of GIS resources and staff in the event of an emergency.
Continue reading

10 Questions: David Bubniak

I’ve been going back and forth with David Bubniak for several months on doing a piece on his geospatial work and efforts with the Southern Tier Central Regional Planning and Development Board (STC) where he has worked for over a decade.  Covering three counties – Chemung, Schuyler, and Steuben – David’s GIS work with STC covers many program areas. A lifelong Southern Tier resident, he and his wife and their two sons live in Waverly,  New York.  David can contacted at gisstc@stny.rr.com.

eSpatiallynewyork:  How long have you been with Southern Tier Central Regional Planning and Development Board (STC)?

Bubniak:  I   started at STC in 2005 and worked here for a year. I left and went to work for James Sewall in the Elmira office (formally Weiler Mapping). I then returned to STC in 2008 and have been here since. Prior to STC, I worked for the Chemung County Metropolitan Planning Office (MPO)  in the early 90’s as a transportation GIS analyst. I then became the General Manager of Chemung County Transit. I then went back to doing GIS in the Northern Tier of Pennsylvania for Northern Tier Regional Planning.  A good friend of mine is a surveyor and I worked with him on the side periodically over the years doing property surveys, deed research and construction layouts.  Those experiences have helped me significantly over the years understanding how to assist people with GIS. I am the only designated GIS person in STC office though we do have planners that use it often.

eSpatiallynewyork:  When did you start doing GIS work?

Bubniak: I started using GIS in 1993. I attended Mansfield University and graduated with a Geography degree with an emphasis in Planning. We used Atlas GIS for projects. I worked part time at the Chemung County Planning department right after I graduated in December 1994.  My first project was mapping senior citizen migration from rural areas back into the City of Elmira for the Department of Aging. When I started at the Executive Transportation Committee for Chemung County (Chemung County MPO) in 1995 I used Unix based  pcARC/INFO and AutoCad. I taught myself how to use both just by studying the manuals and using them for projects. I then started to use ArcView when it was released.

eSpatiallynewyork:  What GIS products do you now use/promote? 

Bubniak:  I use both web and desktop applications. I use ArcGIS server as well as ArcGIS online for my web apps. I do promote both web and desktop apps. I have people using ArcView, ArcReader and ArcGIS Explorer.  I have the Elmira Water Board using ArcGIS desktop with several departments accessing data over their network using ArcGIS Explorer (desktop). The Chemung County Stormwater Coalition uses a combination of ArcGIS online, local data, and data through ArcGIS server.

eSpatiallynewyork:  What agencies/organizations do you work with most closely?

Bubniak:  I do a lot of work for Chemung County departments and towns. I do get involved with the state from time to time. I function sort of as the GIS coordinator for Chemung County but not on formal basis. I work with the Stormwater Coalition, public works, Elmira Water Board, Real Property. I do work and assist several of the bigger towns in the county.

eSpatiallynewyork:  Tell us about the “Southern Tier Central Mapping Application for Local Governments”

Bubniak:  I have four basic parcel viewers. I have one for each county then one for the whole region. They all run the same data from a SQL database.  Chemung and Schuyler Counties connect their county sites to their SDG Imagemate Online application.  I have a Chemung County site tailored to soil and water, Public works and local code officials.  Many county departments and officials use it for their GIS. I have a bunch of project specific web apps I built using ArcGIS for Flash and Silverlight including one for the Keuka Lake Watershed,  a planning tool, and the Susquehanna-Chemung Action Plan.  Those apps utilize other public services and data to cover the whole area. It really depends on the application and the need.

eSpatiallynewyork:  In your capacity with STC, what professions do you work with the most on a day-to-day basis? 

Bubniak:  In addition to my daily responsibilities with TC, I work with several other (government, county, local governments, nonprofits, what?) disciplines including engineering, public works, planning/economic development,  transportation, code enforcement and emergency services.   In many respects and functions I serve as a GIS consultant (though not paid as one) to many organizations and governments across the three county region.

eSpatiallynewyork:  Making maps anymore or is everything online now?

Bubniak:  Mostly everything has gone online, though I still make maps from time to time.  Well designed hard copy maps are always still needed for meetings and discussions.  There is no substitute.

eSpatiallynewyork: From your perspective and experience in the Southern Tier, do you think decision makers and elected officials value GIS technology as a necessity or a “nice to have”?

Bubniak:  For many years it was a “nice to have” and called a cool technology toy.   Though more recently the culture and understanding of geospatial technology has changed within government and among elected officials to considering it much more as a “necessary” tool.

eSpatiallynewyork:  Assuming money and administrative support were in place, what are a couple cost effective (and needed) geospatial applications which you feel STC could develop and available for the three county area?

I would like to have an application or applications similar to how the Town of Southampton, NY is making GIS services available on their website.  They have a fee-based viewer (ePortal).   for Land Manger GIS that was presented at the last New York State GIS Conference.

eSpatiallynewyork:  So what’s next?  What are you working on now?

Bubniak:  Chemung County has just purchased an ELA license from ESRI. I am going to be designing, building multi-user databases and setting up applications for the county. We are going to be implementing a true enterprise system and get away from our current departmentalized GIS systems.

I am currently working on an application to allow  Elmira City Council members to report issues they want resolved. This will be done on tablets and cut out a huge amount of paper work and will bring in a geospatial component at the same time.

Eventually we plan on getting social services involved.   Once we get this off the ground and get things going we are going to look how to improve services in this area of government.  While at Sewall we designed a web application for social services to locate day cares, employers, transit routes and client locations which I believe has potential for regional and county governments.

 eSpatiallynewyork:  So what are you doing when you are not working?

Bubniak:  For many years I competed in power lifting but hurt my shoulder and don’t participate anymore.   I enjoy the outdoors and hunt.    We bought a starter home  many years ago and since then I’ve completely redone the house doing all of the plumbing, electrical, drywall, flooring, etc., myself.    It’s a great location on a dead end road and we own 40 acres.

Both of our boys – ages 9 and 14 – are involved in travel sports (baseball, track/cross country, Tae Kwon Do) so following them around to games and practices is one of our main “hobbies” now – which is all worth it.