Between the Poles: Oracle Database Cloud Service supports Spatial

Geoff Zeiss

About the Author

March 2023

Sun	Mon	Tue	Wed	Thu	Fri	Sat
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31

Links

Lidar News
Gene Roe's laser scanning industry news
Open Source Geospatial Foundation OSGEO
OSGeo was created to support the collaborative development of open source geospatial software and promote its widespread use
Proven guidelines for reducing underground infrastructure damage at airports, university, industrial, and commercial campuses, and towns
There are proven measures that an administration, owner, or municipal government responsible for an airport, university, industrial or commercial campus, or town can undertake to reduce the risk of underground utility damage, the associated disruptions to operations and business and the danger for workers and the public.
Sharing information about the location of underground utilities
The U.S. devotes an estimated $10 billion annually to locating underground infrastructure. Every construction project requiring excavation involves significant efforts in locating underground utilities prior to and during construction to reduce the risk of injuries and unexpected project delays. But this information is rarely shared and the location of underground infrastructure is recaptured over and over again. There are successful examples around the world where municipal and regional governments have helped enable a shared underground utility network database.
Growing evidence of the benefits of an integrated BIM+geospatial full lifecycle approach to construction
Building information modeling (BIM) has been applied to design-build construction projects for many years. A growing number of countries are mandating BIM for public projects. While the UK government has said that "...we know that the largest prize for BIM lies in the operational stages of the project life-cycle", until recently there has not been hard data to support this conjecture. Similarly there has been only anecdotal support for an integrated BIM and geospatial approach for design, build, operate and maintain projects. Now we are beginning to see data from real world projects that offer evidence for the benefits of an integrated BIM+geospatial full lifecycle approach for construction projects.
Progress in geospatial, civil, and BIM interoperability promises efficient workflows for infrastructure
The BIM and geospatial interoperability challenge is the latest symptom of the broader problem of integrating AEC and geospatial workflows, that has contributed to low productivity in the construction sector. After the announcement about a year ago by Jack Dangermond and Andrew Anagnost of a new relationship to build a bridge between Autodesk and ESRI technologies, I thought it a good time to review progress toward interoperability between the AEC and geospatial worlds.
Geography2050: Accurate location information about underground infrastructure is essential for powering our future planet
I thought it would be worth while to include here a talk I gave at GEOGRAPHY 2050 Powering Our Future Planet at Columbia University in New York about the importance of accurate location information about underground infrastructure for the future development of the energy grid. With some notable exceptions accurately recording the location of subsurface infrastructure including oil, gas, electric power and other energy infrastructure is ignored - perhaps this is a case of out-of-sight is indeed out-of-mind. The reality is that knowing the location of underground energy infrastructure is critical for national security, for disaster planning and management, for public safety and for economic efficiency. Everyone is aware of at least one disaster resulting from or exacerbated by not knowing where our energy infrastructure is - the explosions in San Bruno in California (2010) and Belgium (2004) immediately come to mind.
Deep learning enables automated extraction of building footprints and road networks from satellite imagery
Automated feature extraction from satellite imagery has made major progress in the last year. Accurate building footprints extracted from high resolution satellite imagery are becoming available from companies such as Ecopia, which has just announced a partnership with DigitalGlobe, whose satellites are capable of 30 cm (approximately one foot) resolution. Also NVIDIA has demonstrated the ability to automate detection of many road networks using sophisticated algorithms and multi-spectral high resolution imagery.
BIM + geospatial interoperability would avoid another CAD + GIS quagmire
A specific challenge currently facing the AEC and geospatial industries is integrating building information models (BIM) and geospatial infrastructure and building models. There are parallels between what happened in the 1990s in unsuccessfully addressing CAD+GIS interoperability and the current challenge of BIM+geospatial interoperability. But there are also important differences which provide grounds for optimism that the availability of both BIM and geospatial standards, a vibrant open source geospatial community, and a new willingness on the part of major software players in the BIM and geospatial industries will make it possible to successfully address the latest interoperability challenge facing the AEC (architecture, engineering and construction) and geospatial industries.
BVLOS drones improve power line inspections amid increasing fire and storm risks for utilities | Utility Dive
Transmission line inspections for vegetation management and other purposes are essential in ensuring grid reliability and resilience. We saw the devastating effect of vegetation encroachment in the recent California fires, which in part have been blamed on failure to maintain properly cleared transmission lines. With drones that can cover great distances in a single flight and provide detailed and accurate aerial imagery of transmission lines and other infrastructure, it is now possible to almost completely automate this expensive process. Automating transmission line inspections for vegetation management using BVLOS drones not only saves money, but also could improve the resiliency and reliability of the transmission grid.

« FERC Order 745 vacated: negawatt does not equal a megawatt | Main | New York State moves toward Utility 2.0 »

October 15, 2014

Oracle Database Cloud Service supports Spatial

At Oracle Open World in San Francisco 2014, September 28–October 2 the Oracle Spatial and Graph SIG held a Meetup. By way of background Oracle Spatial and Graph support geospatial data and analytics for land management and GIS, mobile location services, sales territory management, transportation, LiDAR analysis and location-enabled Business Intelligence. The graph features include RDF graphs for applications ranging from semantic data integration to social network analysis to linked open data and network graphs used in transportation, utilities, energy and telcos and drive-time analysis for sales and marketing applications.

There were several very interesting discussions at the Meetup that revealed some interesting aspects of Oracle Spatial itselef and its interoperability with other products such as ESRI ArcGIS, Autodesk Map3D, and Bentley. These are taken from a summary recorded by Nick Salem moderator of the Meetup.

The Meetup was attended by about 20 users came from industries such as rail, local city government, national land management agencies, and defense. The SIG Board and members of the Oracle Spatial product development team joined up with them in the Oracle Technology Network Lounge.

Some of the most interesting discussion topics include new features in Oracle Spatial 12c and real world experience interoperating Oracle Spatial with CAD and GIS products from other vendors.

Oracle’s new Database Cloud Service offering now includes Spatial.
A new Oracle Spatial 12c SDO_POINTINPOLYGON function can be used to ingest large point datasets (point clouds) without the overhead of creating a spatial index.
Bechtel has developed a way to use ESRI ArcGIS versioning with Oracle Workspace Manager (OWM). They have developed in-house custom tools to usefeature-level metadata to be able to retrieve spatial content from their project and public spatial databases, as well as to compile the revision history of layers in the database to retrieve maps impacted by changes to individual features.
Dan Geringer, Oracle Spatial Solutions Architect, advised that other large enterprises have also successfully implemented OWM with ESRI ArcGIS.
Bulk processing and interoperability are two of the important advantages of Oracle Spatial for enterprises. Bechtel has large project-based deployments of Autodesk and Bentley CAD systems, and has worked with Autodesk in recent years to successfully write spatial data to their Enterprise GIS Oracle Spatial database from Autodesk Map 3D. They also have developed a GIS Desktop Procedure that details the required Autodesk client software configuration for Oracle Spatial and ESRI ArcSDE database connections. They will be updating it for use with Autodesk 2014 and 2015 clients.
Latest version of MapViewer (11.1.1.7) supports HTML5 and JSon and the ability to work in disconnected mode. Standalone, web-based vector editing is also available. Wish Li and Jayant Sharma demonstrated MapViewer on mobile devices, an Android phone and an iPad.

Posted at 11:30 AM in CAD, Data versioning, Interoperability, Leveraging CAD data, Long transactions, Mobile, Spatial Databases, Web/Tech | Permalink

Comments

The comments to this entry are closed.

Between the Poles

Geoff Zeiss

March 2023

Links

October 15, 2014

Oracle Database Cloud Service supports Spatial

Comments

RSS Feed

Search

Categories

Recent Posts

Archives