Surveying, Mapping and GIS

Exploring all aspects of mapping and geography, from field data collection, to mapping and analysis, to integration, applications development and enterprise architecture...

  • Geospatial Technology, End to End...

    Exploring all aspects of mapping and geography, from field data collection, to mapping and analysis, to integration, applications development, enterprise architecture and policy
Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

National Spatial Data Infrastructure 2.0

Posted by Dave Smith On 1/28/2009 03:02:00 PM 2 comments

Recently there has been a great deal of discussion about "NSDI 2.0" - and yet it seems there is much confusion about what it is or isn't - and what we should do, or whether we should bother discussing it at all.

History
To step backward in time, it primarily deals with National Spatial Data Infrastructure from a federal perspective, as enacted through the Office of Management and Budget Circular A-16.

This document was originally issued in 1990, followed by Presidential Executive Order 12906, and then subsequently updated in 2002 (which incorporated EO 12906).

OMB Circular A-16 (as revised 2002)

In its present form, the NSDI (if you were to consider it NSDI 1.0) consists of:

  • Defined data themes (geodetic control, orthoimagery, elevation, transportation, hydrography, governmental units, and cadastral information)
  • Metadata (FGDC Metadata Format)
  • The National Spatial Data Clearinghouse (Geospatial One-Stop)
  • Standards (developed only when no existing voluntary standards exist, in accordance with OMB Circular A-119)
  • Partnerships
Within the NSDI, oversight is provided by the Federal Geographic Data Committee (FGDC)

Additionally, A-16 pursues the following:
  • Privacy and Security of raw and processed citizens' personal data and accuracy of statistical data
  • Access to these data, subject to OMB Circular A-130
  • Protection of proprietary interests to these data 
  • Interoperability between various federal agencies' information systems within these data
The NSDI supports the advancement for a Global Spatial Data Infrastructure that coincides with National Security interests. Any Federal system that develops international data in accordance with these systems must follow international voluntary standards as outlined by Circular A-119.

The Current Situation
With the FGDC and OMB mandate, this prior effort more than anything, establishes a framework.  This framework, in turn, is something that individual agencies and data stewards can build to.  Similarly, the recent Office of Management and Budget (OMB) Geospatial Line of Business (GeoLoB) and other initiatives, such as the Federal CIO Council's Federal Enterprise Architecture (FEA) Geospatial Profile 1.1 provide guidance toward harmonizing investment, technology and architecture.  Further, the recently-formed National Geospatial Advisory Committee (NGAC) has been formed under the Federal Advisory Committee Act to provide advice, from a community cross-section, to FGDC.

Here nonetheless remains the challenge of populating this framework.  Many diverse efforts are ongoing, which align with these efforts, such as Imagery For The Nation, such as EPA's Exchange Network, however some of these efforts still lack adequate resources for completion, may have issues with stovepipes, lack of interoperability, lack of access, and so on.

The drivers for completing this work are manifold - such as providing adequate tools for planning, to better allow informed decision-making for such things as roadways and transportation, for analysis of demographics toward broadband investments, for homeland security, for planning improvements to municipal sewers, for protecting natural and archaeological heritage and biodiversity, and so on.   As such, with discussion of massive stimulus and the H.R. 1 bill geared toward many of these things, it is imperative that decisions and investments be made in an informed fashion.

Currently multiple documents of relevance and proposals toward populating this framework and advancing the various initiatives are currently circulating within the GIS community:
All of these speak to the need for populating the NSDI framework.  The questions and differences only remain in approaches.    Many elements are crucial to success, such as:
  • Satisfying clear mandates, requirements and drivers for geospatial data
  • Delivering data in an accessible, vendor-neutral, platform-agnostic and interoperable fashion
  • Leveraging and dovetailing into existing initiatives and investments
  • Partnerships:  Federal/State/Local/Tribal/Academia/NGO/Industry
  • And many more...  These need to be considered carefully.
The hope is that the community can have an open, informed discussion of these elements and proposals, along with all of the key context, history and background.  And hopefully adequate open forums will become available for doing so.

Additional Information on ST_Geometry Issues

Posted by Dave Smith On 4/09/2008 07:04:00 PM 0 comments


Some additional information received relative to ST_Geometry issues:

There is a second Software Alert you should be aware of as it may impact your Oracle customers using our 9.2 ST_Geometry spatial type with Oracle 10g R2. This may result in incorrect query results under certain conditions. Our HQ marketing group will also send a newsflash email to all the BPs with additional details.




Summary of the Problem
An Oracle RDBMS bug (Patch 6756089) has been encountered that can cause spatial selections to be wrong for feature classes using ST_Geometry (ESRI’s implementation of a SQL type for Spatial).
When a feature is inserted into a table that stores features using ST_Geometry, its envelope calculation can be truncated, leading to incorrect results with a spatial selection.


Who is affected?
This Oracle bug affects Oracle 10g users of ArcSDE 9.2 geodatabases using the spatial type (ST_GEOMETRY) to store their features and where the precision goes beyond the 5th decimal place. Again, this problem only affects users that work with geometry data that has an x,y decimal precision greater than 5 (e.g.; 11.1234567 will be truncated to 11.12345).


What is ESRI doing about it?
ESRI submitted a problem report to Oracle. Oracle has acknowledged, repaired, and patched the defect (Patch 6756089 and 6867052). Additionally, ESRI is building a utility to update the envelope and spatial index for each feature class once the Oracle patch has been installed.






Additional info on second reported ST_Geometry issue


There is a second Software Alert you should be aware of as it may impact your Oracle customers using our 9.2 ST_Geometry spatial type with Oracle 10g R2. This may result in incorrect query results under certain conditions. Please read the notice below and inform your customers as appropriate.


Software
Alert for Oracle 10g DBMS Patch 6756089 and 6867052


Communication to Our Users
April 3, 2008



Summary of the Problem
An Oracle RDBMS bug (Patch 6756089) has been encountered that can cause spatial selections to be wrong for feature classes using ST_Geometry (ESRI’s implementation of a SQL type for Spatial). When a feature is inserted into a table that stores features using ST_Geometry, its envelope calculation can be truncated, leading to incorrect results with a spatial selection.


Who is affected?
This Oracle bug affects Oracle 10g users of ArcSDE 9.2 geodatabases using the spatial type (ST_GEOMETRY) to store their features and where the precision goes beyond the 5th decimal place. Again, this problem only affects users that work with geometry data that has an x,y decimal precision greater than 5 (e.g.; 11.1234567 will be truncated to 11.12345).


What is ESRI doing about it?
ESRI submitted a problem report to Oracle. Oracle has acknowledged, repaired, and patched the defect (Patch 6756089 and 6867052). Additionally, ESRI is building a utility to update the envelope and spatial index for each feature class once the Oracle patch has been installed. We expect our utility to be available by the end of the week of March 31. It will be available as a download from the ArcSDE download page (the
same location as hot fixes and service packs).


Where and when can I get the patch from Oracle?
There are a number of platforms to patch. To date, Oracle has only provided patches for the Linux, Sun Solaris and Windows (32-bit) platforms for Oracle 10g. Please go
to Oracle’s MetaLink page (http://metalink.oracle.com/) to check patch availability and to download the patch when it becomes available for any given platform needed.

The patch description for Linux and Sun Solaris is:
Patch:
6756089
Description: USING A DBMS TYPE IN OCI AND FLOATS ARE BEING ROUNDED OFF
Product RDBMS Server
The patch description for Windows is as follows:
Patch: 6867052
Description: ORACLE 10.2.0.3 PATCH 19 BUG FOR MICROSOFT WINDOWS 32BIT


ESRI Products and Versions that are affected by this Oracle bug
Any ArcSDE client application (e.g., ArcGIS 9.2, ArcIMS 9.2) that uses ArcSDE 9.2 for Oracle 10g (and service packs) with the ST_Geometry spatial type


Additional Information
Q. How do I know if I have the problem?
A. If you are using ArcSDE 9.2 for Oracle 10g, storing features as the spatial type (ST_GEOMETRY), and have greater than 5 decimal places of precision, you should assume the problem exists, even if you have not seen incorrect spatial query results.


Q. When should I install the Oracle patch?
A. As soon as it becomes available for your platform. After installation of the Oracle patch, please be sure to download the utility provided by ESRI to fix the envelope and update your spatial index.


Q: I've noticed that Oracle has released the patch for version 10.2.0.3 on some platforms. What does that mean to our customers that have upgraded or are planning to upgrade to 10.2.0.4? Do they need to drop back a patch release in order to install this? Apply the patch again?
A: We do not know the answer to this yet. We’ll provide the answer in KB34527 when we know it.


Q. What do I do if Oracle has not released a patch for my environment?
A. Contact your Oracle account team, reference the Oracle Metalink and tell them
you need the patch.


Q: Is the utility to fix the envelopes and re-create the spatial index for each feature class available for download?
A: Not yet. We expect to put it up on the ArcSDE download page (where patches are downloaded) by the end of the week of March 31.


Q: Will we have documentation that explains this problem in more detail?
A: Yes, please see KB article 34527.


Q. Does this issue impact our customers that are using the SDO_Geometry type?
A. No. Oracle Spatial (SDO_GEOMETRY) does not store the envelope of the geometry as an attribute of the object.


Q. Is Oracle 9i affected?
A. No, this problem is in 10g only.






Related ongoing discussion in ESRI forums:


http://forums.esri.com/Thread.asp?c=158&f=2291&t=250200&mc=8


Just got this item...

Software Alert for ArcGIS Server 9.2 with Oracle
10.2.0.4

April 4, 2008

Introduction

Recently two ESRI customers have reported problems to ESRI Technical Support after upgrading to Oracle 10.2.0.4. The Oracle upgrade appears to be deleting some schema elements we require for the spatial type (ST_GEOMETRY). Uninstalling the upgrade to restore the prior version of Oracle does not work. ESRI is in contact with Oracle and we are working together to understand and quickly resolve the problem in this Oracle 10.2.0.4 patch upgrade.

ESRI is strongly recommending that all Oracle based customers do not upgrade to Oracle patch version 10.2.0.4 until ESRI has certified this Oracle patch release with ArcGIS Server 9.2. If you have already upgraded to Oracle 10.2.0.4 and have questions, please contact ESRI Technical Support or your local international distributor as soon as possible.

Summary of the Problem:

ArcSDE 9.2 instances create PUBLIC synonyms for the SDE ST_GEOMETRY and subtypes; along with several geometry, relation and assessor operators and functions. Upgrading to Oracle 10.2.0.4 causes ArcSDE 9.2 instances to fail during several operations including "create feature class" when the reference to ST_GEOMETRY now refers to MDSYS.ST_GEOMETRY (a.k.a. SDO_GEOMETRY).

Please note: At ESRI, we have not been able to successfully roll back from the Oracle 10.2.0.4 to the previous Oracle release.

Oracle Spatial User Conference

Posted by Dave Smith On 2/08/2008 07:24:00 AM 0 comments

Oracle Spatial User Conference
Thursday, March 13, 2008
Washington State Trade & Convention Center
Seattle, Washington USA

The agenda touches on some of my own hotbutton issues - integrating Oracle Spatial with Virtual Earth, Business Intelligence and other areas...

http://gita.org/events/annual/31/Oracle.asp

Seeking Web GIS Applications Developers...

Posted by Dave Smith On 8/08/2007 09:18:00 AM 1 comments

For the mashup artists, AJAX gurus, ArcIMS experts, .NET jockeys out there...
Synergist Technology Group, Inc. is currently looking for GIS web applications developers, for its Pennsylvania and Northern Virginia locations.

Requirements:

Strong background in web-based GIS applications development.


  • DHTML, CSS, and JavaScript;

  • ASP.NET, C#, VB.NET, or Java

  • ESRI ArcIMS

  • Web Services (XML, SOAP, JSON, REST, OGC)

  • Understanding of spatial databases
Desired Skills:

ArcGIS Server, Oracle Spatial query and analysis, mashups and exposure to Microsoft Virtual Earth, Google Earth, Google Maps, good documentation and communication skills.

Additionally, a background in emergency response, transportation, facilities management or environmental science may be very useful.

Applying:

Applicant must be a US Citizen or have US Permanent Resident Status

Interested applicants should respond with a current curriculum vitae and salary requirements to dsmith[@]synergist-tech.com.

Synergist Technology Group, Inc. - A Service-Disabled Veteran-Owned Small Business (SDVOSB) specializing in geospatial technology, environmental science, transportation and emergency response.

Help Wanted

Posted by Dave Smith On 2/24/2007 07:55:00 PM 2 comments

We currently have several positions open in SynTechGp:



Industry Job Title: Software Quality Engineer Sr

Required skills: Excellent Communication skills, Experience- CMMI Environment, Oracle PL/SQL

Desired skills: Experience with Test Tools, eg. Test Partner

Specific Job Description: Must be skilled at assessing project/client needs and coordinating project development form inception to deployment. Must have excellent communcation skills.

Standard Job Description: Develops, modifies, applies, and maintains standards for quality operating methods, processes, systems and procedures. Provides coordination and guidance in preparation of technical appraisals of programming languages and systems, computational software and related technology, and the integration of computers into the overall functions of scientific computation, and data acquisition, transmission, and processing. Ensures that corrective measures meet acceptable reliability standards.

Develops overall operating criteria to ensure implementation of the software quality program according to project, process and contract requirements and objectives. Ensures that project and process control documentation are compliant with requirements, objectives and/or contract. Reviews software design, change specifications, and plans against contractual and/or process requirements. Reviews include applicable specifications, materials, tools, techniques, and methodologies. Performs or directs verification of software requirement allocations, traceability, and testability.

Security Clearance: Other

Typical Minimums: Bachelors degree from an accredited college in a related discipline, or equivalent experience/combined education, with 5 years of professional experience; or 3 years of professional experience with a related Masters degree. Considered career, or journey, level.

Work Location: Arlington, VA



Industry Job Title: Business Appl Prgrmr Sr

Required skills: Informatica ETL tool (v7.x), Oracle , C, Perl, and Korn Shell, Strong understanding of OLTP, dimensional modeling exp., optimizing large data loads, UNIX Solaris scripting, PL/SQL programming

Desired skills: PL/SQL web tool kit, Business Objects, Cognos, SQL Loader, Configuration Management, TOAD

Specific Job Description: Design and develop transformation processes to load data from source to target. Develop and tune ETL mappings and sessions Code and document scripts and stored procedures for data warehousing processes. Performance and tuning of ETL tool for parallel loads and cache optimization Document ETL processing systems. Work with business transformation teams to define and derive application integration requirements. Maintain knowledge of Enterprise Application Integration, planning, design, analysis and methodologies. Familiarity with administrative tasks within Informatica platform such as stopping/starting Informatica repository and server processes, performing code migration, backup and restore of Informatica repository, and security administration. Strong SQL programming and stored procedure development skills process oriented focused on standardization, streamlining, and implementation of best practices. Sharing knowledge by effectively documenting work. Maintain expert level of knowledge in area of expertise. Develop and maintaining a thorough knowledge of the assigned applications, functional areas or projects. Work with the team to ensure the quality of coordinated business functions.Respond quickly and effectively to production issues and taking responsibility for seeing those issues thru resolution. Participate in project planning.Participate in design and maintenance of enterprise architecture.

Standard Job Description: Plans, conducts, and coordinates programming application activities. Writes business applications computer software that contains logical and mathematical solutions to business problems or questions. Develops statements of problems, designs systems and programs, and writes programs in computer language for solution by means of data processing equipment. Applies knowledge of computer hardware and software, subject matter to be programmed in business applications, information processing techniques used, and information gathered from system users to develop software. Corrects program errors, prepares operating instructions, compiles documentation of program development, and analyzes system capabilities to resolve questions of program intent, output requirements, input data acquisition, programming techniques, and controls.

Security Clearance: Other

Typical Minimums: Bachelors degree from an accredited college in a related discipline, or equivalent experience/combined education, with 5 years of professional experience; or 3 years of professional experience with a related Masters degree. Considered career, or journey, level.

Work Location: Arlington, VA



Industry Job Title Programmer Analyst Sr Stf

Required skills: Documentum, Documentum Web Publisher, Documentum Content Server, Documentum Administrator, Documentum Content Intelligent ServicesDocumentum Foundation Classes, Web Services

Desired skills: JAVA, Oracle 10i

Specific Job Description: Experience in all phases of Software Development Lifecycle from requirements analysis to implementation and support of computer application systems using available and current technologies. Three to four years of experience in the administration and development of content management applications using Documentum Content Server. Experience in the design and development of Documentum Content Server-based applications using such tools as Documentum Administrator, Application Builder, Business Object Frameworks, Documentum Foundation Classes, Workflow Manager, WebTop/WDK, Desktop, DQL, DMCL, Java/J2EE, DocBasic, Visual Basic, XML, XSLT, XHTML. Other tools used include Oracle 9i Database and Application Server, Apache, Tomcat, Oracle JDeveloper, SQL, Java Script, VBScript, Visual Studio, ASP, .NET, Lotus Domino, Lotus Notes, Web Services and AJAX. Must be experienced with Documentum Web Publisher 5.3 SP3 or above. Must be able to create SOA compliant Web Services.

Standard Job Description: Builds and codes applications and/or modules using languages such as C++, visual basic, ABAP, JAVA, XTML, etc. Provides patches and upgrades to existing systems. May design graphical user interface (GUI) to meet the specific needs of users. Prepares operating instructions, compiles documentation of program development, and analyzes system capabilities to resolve questions of program intent, output requirements, input data acquisition, programming techniques, and controls. May build add-on modules using application program language.

Security Clearance: Public Trust

Typical Minimums: Bachelors degree from an accredited college in a related discipline, or equivalent experience/combined education, with 14 years or more of professional experience; or 12 years of professional experience with a related Masters degree. Considered an expert, authority in discipline.

Work Location: Arlington, VA



Industry Job Title: Business Process Anlyst Sr Stf

Required skills: CMMI Level 3 familiarity. 10+ years SDLC experience. Team lead experience. 7+ years requirements engineering experience. Excellent verbal and written communication skills.

Specific Job Description: Leads Requirements Team for a major Federal Program. Responsibilities include implementing CMMI Level 3 processes, mentoring team members, refining Requirements Engineering processes, developing System Requirements specifications, facilitating Requirements and Design sessions with stakeholders and technical staff, translating business requirements into technical requirements, etc.

Standard Job Description: Analyzes business and technical processes to formulate and develop new and modified business information processing systems, such as production and inventory control systems, financial tracking systems, marketing and human resources systems. Represents the business unit to define requirements and business cases for the technology developments. Coordinates with business and technology teams, ascertaining system requirements, such as program functions, output requirements, input data acquisition, and system techniques and controls. Requires knowledge of e-commerce tools, computer system capabilities, business processes, and work flow.

Security Clearance: Other

Typical Minimums: Bachelors degree from an accredited college in a related discipline, or equivalent experience/combined education, with 15 years or more of professional experience; or 13 years of professional experience with a related Masters degree. Considered an expert, authority in discipline.

Work Location: Arlington, VA



These are all positions on a multi-year federal program. As software contractors on federal programs, all applicants must be US Citizens or hold US Permanent Resident Status.

To apply, email your resume to dsmith (at) synergist-tech.com

Search