Use Hibernate with Oracle and Esri St_geometry type

Can anyone tell me whether I could use Hibernate with esri ST_GEOMETRY type? I have found that Hibernate Spatial does support SDO_Geometry, but nothing for ST_Geometry.

I am using oracle 11g and arcgis 10.2

I just got something working.

It's still beta, but first test are very promising.

I'm working with the WKT/WKB representation to store it in the database.

It looks like this:

@Entity @Table(name = "dau_track") public class DauTrack { @Column(columnDefinition = "st_geometry") @Type(type = "lu.schuller.arcgisStGeometry.WkbStGeometryType") @ColumnTransformer(read = "st_asbinary(shape)", write = "st_geomfromwkb(?,2169)") private Polyline shape;

I created my own Wkb-HibernateType to convert the wkb-data betweent database and geometry-api. I have already implemented JTS and esri-geomeotry as geo-libraries.

The 'columnTransformers' are modifiing the generated hibernate-sql to read and write under wkb-form in the database.

It's currently running under postgresql, but will it also use under Oracle.

If I had some time, I will publish it on github.

GIS Systems Lead Response to COVID-19

Although the coronavirus disease 2019 (COVID-19) pandemic, by definition, was a global event, like all disasters, it was experienced locally by millions of individuals who lost their loved ones, their incomes, and their sense of normalcy.

As the COVID-19 outbreak grew to an epidemic and fears of its metamorphosing into a pandemic began to be considered seriously, Johns Hopkins University (JHU) launched its COVID-19 dashboard. A team led by Lauren Gardner, an epidemiologist and codirector of the Center for Systems Science and Engineering at JHU, created the dashboard using Esri technology. It immediately went viral, with the number of visitors skyrocketing as it became the global reference for the pandemic, while Esri continued providing support to JHU.

“When disease can travel so quickly, information has to move even faster. The intense response generated by the Johns Hopkins dashboard shows how eager people around the world are to track health threats,” explained Dr. Este Geraghty. She is the chief medical officer and health solutions director at Esri. “The dashboard presents targeted, up-to-date information needed to understand the progress of a disease and makes it available in a public, easy-to-digest format.”

Applying Geographic Technology

Organizations have been using mapping for hundreds of years—and GIS in recent decades—to understand the spread and impacts of epidemics. In this century, GIS has played important roles in tracking and helping to contain two other human coronaviruses, SARS-CoV and MERS-CoV. During the Ebola outbreak in 2013, government officials used GIS to site emergency treatment centers, manage bed capacity, and coordinate response efforts. However, GIS use for COVID-19 has been the most comprehensive and effective one to date.

The organizations that applied the geographic technology of GIS to COVID-19 ranged from local to international. The widespread use of GIS for COVID-19 response has demonstrated the power of geospatial thinking and the scalability, speed, and insight provided by GIS. More than simply mapping phenomena, GIS uses geography to furnish context for events in a common reference system. Applying spatial analysis tools, GIS brings out the relationships, patterns, and associations that are often hidden by the complexity of data.

The pandemic has also highlighted the importance of a geospatial infrastructure for effective and informed action in disasters. Johns Hopkins University’s dashboard could deliver the information on COVID-19 that everyone urgently sought because it tapped into the enterprise system for pandemic response provided by the ArcGIS platform and delivered by the Esri Geospatial Cloud. Its speed and scalability have been demonstrated by thousands of organizations around the world that stood up ArcGIS Dashboards and ArcGIS Hubs, and implemented ArcGIS Solutions for responding to the pandemic and ensuring business continuity.

A Common Mission

To help address the pandemic, Esri made all its software, virtual training, and on-call technical assistance freely available not only to all its users but also to any organization anywhere in the world that was battling the pandemic. “Addressing the pandemic can be seen as part of Esri’s common mission of bringing geographic science, GIS technology, and geographic thinking to every organization on the planet—all governments, private companies, academic institutions, and NGOs,” said Jack Dangermond, Esri founder and president, in an announcement in March 2020.

With Esri software, training, and support services came access to the vast trove of authoritative and accurate foundational data from the ArcGIS Living Atlas of the World and business, lifestyle, and other datasets. Combined with the ability of the ArcGIS platform to rapidly ingest, integrate, analyze, and visualize data from sensor, telemetry, and other real-time data sources, organizations could accurately capture the constantly changing picture of the unfolding crisis.

Thousands of organizations across the United States and in numerous countries around the world that were not already using ArcGIS adopted GIS. Esri, through its Professional Services team, has been supporting the outstanding work of local, state, federal, and international organizations as they stand up GIS systems for reacting to the pandemic. To help these organizations work as effectively as possible, Esri has been creating and releasing training materials and white papers that are specific to using GIS for COVID-19.

Esri’s Disaster Response Program (DRP) has also helped thousands of organizations. For more than 25 years, it has provided data, software, configurable applications, and technical support to help communities during large-scale emergencies and natural disasters. Read the accompanying article, “Esri’s DRP Lends Support to Worldwide Efforts Against Pandemic,” to learn more about the DRP.

Esri international distributors in the Middle East, Europe, Asia, and South and Central America have also supported efforts combating COVID-19 in the countries in which they work by providing technical support and training materials to help set up ArcGIS Hub sites and use ArcGIS StoryMaps.

Esri partners around the world are also playing a critical role in helping with this global disaster by contributing discounted or no-cost COVID-19 focused offerings and location-enabled software solutions, content, and implementation services.

Two new initiatives have accelerated the use of GIS to understand and halt the spread of COVID-19. Esri partnered with the World Health Organization (WHO) to provide Esri software and solutions to all international health ministries and their global affiliates, particularly those in developing countries.

A partnership with the Federal Emergency Management Agency (FEMA) has made the Esri platform available to all FEMA partners, which includes nearly all governments and nongovernmental organizations (NGOs) responding to the crisis in the United States.

To ramp up its capacity to support many more users of the Esri Geospatial Cloud, Esri has been optimizing the scalability of ArcGIS Online to handle the creation of billions of map views per day and support the load generated from ArcGIS Dashboards.

In collaboration with its partners and user community, Esri launched the COVID-19 GIS Hub, an ArcGIS Hub site that provides a collection of datasets, applications, and other useful content for planning and response. Because Hub is a software-as-a-service (SaaS) solution that is hosted in the Esri Geospatial Cloud, it doesn’t require hardware or software and greatly reduces deployment and maintenance time. Localized versions of ArcGIS Hub are available in 38 languages.

Two ArcGIS Solutions were created specifically to help organizations with COVID-19 problems. Coronavirus Response is an ArcGIS Solution that supplies a collection of apps and data designed to help users understand and manage the impacts of the pandemic on a community. The Coronavirus Business Continuity Solution is a collection of apps and data for coordinating and reporting information about employees and facilities to get organizations, whether private or public, back to normal.

As the pandemic has unfolded, Esri has developed tools that incorporate mathematical models used by epidemiologists such as the COVID-19 Hospital Impact Model for Epidemics (CHIME) model. At the outset of the pandemic, Esri developed an implementation of CHIME for use in ArcGIS Pro that leverages Susceptible, Infected, Recovered (SIR) modeling and can be used to forecast the curve of the epidemic in terms of its impact on hospitals and visualize those impacts spatially.

Existing GIS Implementations Speed Efforts

One of the hallmarks of the COVID-19 pandemic has been the need for speed. Its rapid spread requires not the perfect plan but an immediate one. That means actionable information, not a flood of data. GIS has been critical to the ability of state and local governments to react to the pandemic. Those that had robust, existing GIS implementations have been well positioned to pull the best data together, analyze it, and rapidly respond.

The State of Maryland rolled out its ArcGIS Hub site, Coronavirus Disease 2019 (COVID-19) Outbreak site, in just four hours on March 14, 2020, and didn’t incur any additional cost because Maryland already used ArcGIS as a statewide enterprise system and its GIS staff members already possessed the necessary skills.

“We were able to step up and use the technology when it really mattered,” said Julia Fischer, the State of Maryland’s geographic information officer. The good working relationship between the state’s information technology department, emergency management agency, and health department helped GIS staff deliver the right data, right away.

“GIS in disaster response is 100 percent necessary.”

The State of Montana benefited from the existing statewide datasets it has maintained and made available for years. Having the right tools, processes, and foundational data layers are critical to optimizing GIS use in an emergency. Erin Fashoway, the state GIS coordinator said, “It’s a no-brainer to use GIS for emergencies. Montana has lots of them.” She sees the key to using GIS for emergencies is not to start using GIS in the middle of an emergency.

By using Survey123 for ArcGIS, Montana gathered data on local conditions throughout the state and in tribal areas that was immediately shared at the Montana Emergency Coordination Center. The information created using the state’s GIS was used by the governor’s task force to drive its decisions.

“There is no doubt in my mind that GIS should be used as a tool to plan for, mitigate, and recover from disasters,” said Fashoway. She believes that “GIS in disaster response is 100 percent necessary.”

Local government, which is the face of government for most people, had to cope with social and economic impacts that originated far away but had close-to-home impacts.

Statewide shelter-in-place orders caused millions of people to lose their jobs and incomes. At the same time, school closures interrupted the free breakfast and lunch programs many families rely on. Food supply chains were disrupted as restaurants closed or adopted limited services and hours at the same time the demand for groceries increased substantially. This dislocation for suppliers and increased demand by grocery stores was exacerbated because they have come to rely on constant shipments and rapid restocking of goods. Widespread panic buying and hoarding compounded these logistics problems, leading to empty store shelves.

The result was food insecurity that was felt early and pervasively. While it was a widespread problem, it required local action to solve. ArcGIS Hub sites and apps supplied residents with current information on local conditions and helped local governments deal with this problem.

For example, Cobb County, Georgia, a longtime, innovative user of GIS, added a web app to its ArcGIS Hub site dedicated to COVID-19 resources. It supplied up-to-date information on grocery inventories of essential items, special hours for at risk people, how crowded stores were, and how well social distancing practices were being followed for area stores. Current data was fed into the app by crowdsourcing data from residents who used Survey123 for ArcGIS to fill out surveys on stores. A story map on the site contained information on area food pantries and government assistance.

Restaurants—a source of food and local employment—have been supported by local governments using GIS. The IT department for the City of Seattle, Washington, created the GIS-based #SupportSeattleSmallBiz app to support local restaurants. Business owners used a simple survey form to populate a web app with information on their status. A public-facing app let residents find restaurants near them and provided phone numbers, website links, and directions. The app made information on more than a thousand businesses quickly available, helping those businesses stay open, keep staff employed, and retain customers.

Recovery Needs a Geographic Context

While the COVID-19 pandemic was initially perceived as a public health crisis, its effects are rippling through society and will be long-lived. COVID-19 is precipitating an economic emergency that has effects both pervasive and growing. This secondary emergency is enmeshed with other social challenges, notably widespread homelessness.

The interrelated nature of these two issues makes GIS the best framework for holistically arriving at policies. ArcGIS tools and data can determine impacts on businesses and the economic well-being of individuals. With a better idea of these conditions, different levels of government can work together and coordinate efforts.

Regional economic recovery is going to be a collaborative process because the effects of COVID-19 don’t neatly stop at city or county boundaries. Placing data in a geographic context helps visualize relationships and perhaps new solutions. Collecting data will allow predictive modeling and shape recovery. This crisis is an opportunity for collaboration and building cooperation that could continue, limiting data hoarding and promoting reciprocal data sharing.

A Framework for Understanding and Responding

GIS professionals across the world have applied GIS in responding swiftly and decisively to the COVID-19 pandemic and demonstrated just how valuable geospatial thinking is. They showed that using a geographic framework for informing decisions is not just applying technology but helping lead organizations to a better way of dealing not only with emergencies but with day-to-day challenges.

Thousands of organizations that had not used GIS much or at all before the pandemic have successfully stood up systems in response to COVID-19 and realized concrete benefits. Geraghty sees the pandemic as an opportunity for organizations to appreciate how valuable a geospatial framework can be to them. She hopes that people will realize the value of looking at their data geospatially not only to be better prepared for the next public health emergency but to develop better methods for handling other problems.

“Taking a geospatial perspective is different. It’s a different way of thinking. It’s more than looking at a map. It’s making spatial decisions and doing spatial analysis which is different in its overall perspective from traditional analysis and statistics. Once you start to think this way, you easily see the value of it and how you can apply it to the challenges that we have at hand,” she said.

Geographic Information Systems and Information Technology

Effective planning for the District of Columbia requires the best information available about the city and the capacity to analyze and communicate it efficiently. Our in-house Geographic Information Systems (GIS) and Information Technology (IT) staff members provide mapping, spatial information and analysis, and planning-related GIS services to the Office of Planning (OP), other District agencies, citizens and a variety of organizations. This group plays a leadership role in GIS within DC government and works closely with the Census State Data Center and others conducting GIS activities inside and outside of DC government. It also manages overall information technology (IT) support for OP.


The Office of Planning&rsquos in-house Geographic Information Systems staff members are a key source of high-quality map products for the Office, other agencies, and the public. A variety of ready-made and custom map products are available, together with a variety of on-line tools for interactive mapping and analysis.

Spatial Data

The Office of Planning&rsquos in-house Geographic Information Systems staff develops and maintains a number of key planning-related data sets for the District, working closely with the Office of Planning&rsquos Census State Data Center, the Office of the Chief Technology Officer&rsquos Geographic Information Systems team, and others. These include Census boundaries like Tracts, Block Groups, and Blocks land use data, neighborhood and neighborhood cluster data Historic Districts and other historic resource information and a variety of data sets describing planning-related initiatives.


The Office of Planning&rsquos in-house Geographic Information Systems staff has long been a lead agency for analysis and presentation of spatial information for the District. Theis group provides analyses for every division within the Office of Planning to help guide planning and preservation decisions. It also works closely with a broad range of other DC agencies to make spatial information available and to put it in context, fostering discussion and analysis for a wide variety of purposes.

GIS Technology

Like the rest of DC Government, OP has chosen GIS software from ESRI as our main tools for mapping and spatial analysis. Our office was the first to develop custom extensions to the standard ArcMap software to improve staff productivity and to help our agency manage the large number of maps we produce each week. These extensions include buttons for making standard maps and for browsing a professionally-managed catalog of spatial data, improved navigation tools and tools for integrating oblique aerial photographs, and tracking tools that log and index every map we make. Together with partners in the Office of the Chief Technology Officer, we have helped distribute these productivity tools to all DC government agencies.

We also recognize that sometimes the simplest tools are the best tools. Our Office has also been the first in DC Government to develop &ldquoRich Internet Application&rdquo tools like Property Quest and DC Walkscape. These are web sites that are attractive and extremely easy to use, yet deliver key information and sophisticated analyses to everyone.


OP works closely with the Office of the Chief Technology Officer (OCTO), which has provided long-term support to help build and grow the GIS capabilities within the Office of Planning. OCTO has developed interactive mapping tools including the DC Guide. We have been pleased to contribute to that effort, and our high-quality cartographic products complement those online tools.

OP staff at all levels continue to work closely with their counterparts at National Capital Planning Commission (NCPC), our sister organization within the federal government.

Demographic information from the Census Bureau and other sources are key to understanding the various places in DC. We work hand-in-hand with the staff of the State Data Center (SDC), part of the Long Range Planning Division, to help make that information available to everyone.

The mission of the State Data Center (SDC) is to provide easy and efficient access to US Census Bureau data through a network of affiliate agencies in the District. The DC Public Library is an affiliate charged with providing historical census information in hard copy and electronic formats.

DC Government&rsquos principal technology GIS partner is Environmental Systems Resources Institute (ESRI). They make the baseline GIS software that we rely on, including ArcView GIS, SDE, and ArcIMS. We also work closely with Google, using a variety of their spatial technologies as well.

The District of Columbia Government has also licensed an archive of detailed oblique aerial images of DC from Pictometry International. Our license allows us to use those images in our products. Others outside of DC government may wish to contact them directly to license individual images for their own purposes.

Geospatial Data

The Iowa Geographic Image Map Server (Orthoserver) provides a wide variety of image products via download or through web map services (WMS). Data coverage includes the entire state of Iowa. Products include:

2004 - 2011 , 2013 - 2019 nat ural color and infrared photos
1930s - 1980s decadal gray scale photos
Hillshade from lidar data, 2007-2010
Early 1990s gray scale photos
1:24000 and 1:100000 topographic maps (USGS DRGs)
1992 and 2002 land cov er/ land use maps

For directions on how to connect to the Iowa Geographic Map Server within ArcGIS Pro, visit here.

For directions on how to connect to the Iowa Geographic Map Server within ArcGIS Desktop (ArcMap), visit here.

Public Data via the Web

The GIS Facility provides data produced by the DNR and data developed by research on campus downloadable through ISU's CyBox storage service. To obtain this data, visit here. The data is zipped so you will need to download the data onto your machine and unzip.

Restricted Data Access - Public Data

The GIS Facility provides data produced by the DNR and data developed by research on campus. This public data can be accessed directly from on campus by those people with an ISU username or from off campus, using the VPN. To connect to the data you have to map a path to the data location. Create a connection in My Computer (not a browser) to:


and be sure to specify your ISU username, if you have not logged in to your machine with that name. If you connect from off campus, you will need to use the VPN method, explained below.

If you have a Mac, the process is as follows:

Go>Connect to Server menu in the Finder and then entering the following URL:

After a connection is made, you will need to provide your ISU credentials.

Natural Resources Geographic Information System (NRGIS) Library

The DNR's NRGIS Library has been retired.

The Library's data has been merged into Iowa Geodata (Click Here), the State's clearinghouse of geospatial data. This is a collaborative space for users and publishers of geospatial data about Iowa.

Restricted Data Access - ESRI Supplied Data

The GIS Facility provides data produced by ESRI that is included with our site license. Only those people with an ISU username will be able to access the data. The GIS Facility allows a user to download the data from CyBox or to connect to the data directly from a server. To download from CyBox, visit here. To connect to the data you have to map a drive to the location. Create a connection in My Computer (not a browser) to:


and be sure to specify your ISU username if you have not logged in to your machine with that name (see image below).

Groundhogs are widely distributed across North America, ranging as far south as Alabama and as far north as Alaska. They build extensive burrows—anywhere from eight to 66 feet long—with multiple entrances and rooms, including bathrooms. Some groundhogs even have more than one burrow. But these mammals tend to keep to themselves, only seeking one another out when it’s time to mate.

After roughly three months of hibernation, evidence suggests that male groundhogs wake up early to prepare for the mating season. As early as February, they leave their burrows to scope out where females are hibernating. Then they go back to sleep for another month or so until it’s time to mate.

Mating season starts in early March, ideal timing as food becomes more abundant—and there’s just enough time to start packing on the body fat they’ll need for the winter ahead.Females welcome a litter of perhaps a half-dozen newborns, which stay with their mother for several months.

A GIS integrates data with spatial information to make a visual representation, allowing for faster data analysis and more powerful data presentation. For a detailed, easy to understand introduction to GIS, see "What is GIS" from GISLounge.

Whatever area of the country (or world) you're interested in there are local entities (governmental, non-governmental and quasi-governmental) that collect and make data available. Search for local governments, community development organizations, regional planning commissions or government organizations, etc. Below are a few resources for data and statistics on the St. Louis Region.

  1. Open ArcMap with a new, empty map, and add the dataset that has a defined coordinate system that needs to be transformed to a new coordinate system.
  2. Click View > Data Frame Properties > Coordinate System tab.
  3. In the 'Select a Coordinate System:' box, open Predefined, select the output coordinate system, and click Apply.
  4. In the Geographic Coordinate System Warning dialog box that appears, click Yes.
  5. Click on the Transformations button, and in the Geographic Coordinate System Transformations dialog box, verify that the correct geographic coordinate system is selected in the 'Convert from. ' box.

To help with similar issues in the future, download the EPSG Geodetic Parameter Dataset of coordinate systems, datum transformation parameters, and get other useful information at the EPSG Web site.

Hundreds of thousands of organisations in virtually every field are using GIS to make maps that communicate, perform analysis, share information and solve complex problems around the world. This is changing the way the world works.

Identify problems

Use GIS to illuminate issues that are driven by geography. This map reveals geographic insights into the problem of fly-tipping.

Monitor change

If a picture tells a thousand words, a map tells a thousand pictures. This map shows the changing British landscape from the Ice Age to the Present.

Manage & respond to events

GIS delivers real time situational awareness. This map shows how a water utility company can monitor its network and respond dynamically to leaks and other disruptions affecting the network.

Perform forecasting

New Housing Developments need to be carefully planned and those affected by the work need to be properly informed. ArcGIS provides tools for identifying potential development sites through to sharing views during the full lifecycle.

Set priorities

GIS helps to set priorities based on spatial analysis. Gathering information from the community and analysing crime patterns police can identify target areas and plan strategically to address crime.

Understand trends

GIS helps you gain insight into data that might be missed in a spreadsheet. This map explores how to build healthy communities including how the geographic prevalence of diabetes is increasing in some areas more than others.

Use Hibernate with Oracle and Esri St_geometry type - Geographic Information Systems


Seminole County GIS is a geospatial resource for not only county and city staff, but its businesses and residents as well. Our GIS Library has over 300 layers of information. We also maintain digital aerial photography (historic and current).

The Information Kiosk is designed to help locate popular geographic features within Seminole County. Just enter an address and find information about that address - property information including owner, jurisdiction, land use and zoning, flood zone utility information including hydrant location, providers political representation and school information. Turn on a host of geographic layers including parks, trails, protected areas, commercial facilites, target areas, bus stops and more.

Looking for specific information such as location of an Emergency Shelter or Fire Station? Want to check the Zoning of a particular parcel? Looking to visit a County Facility, Library or a Neighborhood Park? Check out Seminole County's Gallery of Maps. These are a series of maps and apps designed to be simple and easy to use.

Also take a look at a host of other interesting interactive maps, both internal and external, or download and print some static maps (pdf).

All our maps are best viewed on Internet Explorer 11 or higher, and Chrome.

GIS Data is available for download as Esri ArcGIS geodatabases. Please note that our web maps are down between 5 and 7 pm on Fridays for maintenance. Use the My Resident Page . This provides a listing of information.

How does GIS benefit Seminole County?

Watch a few employee testimonials on how GIS is transforming how we do business at Seminole County

Geographic Information Systems (GIS)

GIS data is provided 'as is'. The maps and data provided are provided for illustration purposes only, and are not suitable for site-specific decision making. St. Mary's County specifically disclaims any warranty, either expressed or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular use. The entire risk as to quality and performance is with the user of the data. In no event will St. Mary's County or its staff be liable for any direct, indirect, incidental, special, consequential, or other damages, including loss of profit, arising out of the use of these data even if St. Mary's County has been advised of the possibility of such damages.

Use this link to submit questions about the web map or issues with the data. For data issues such as incorrect property boundaries or addresses, please be sure to include the relevant tax account ID. The more information you can provide, the better we will be able to research and resolve your issue. Please include an email address so that we may confirm with you that the issue is resolved. Thank you.

Watch the video: GIS Tools: ArcMapArcGIS Tool for connecting points (October 2021).