[Geomedia-l] RE: Coincidence

Fri Jun 22 14:05:18 CDT 2007

Bill,

You'd need to ask Intergraph as I'm not sure if it's a limitation with GM.
But, assuming it's not, you should be able create a database link between
the two disparate database. You can then create a view in Database A that
talks to Database B, thus "virtually replicating" the data all into one
database. This is a much more clean way as opposed to an export/import.
You could also look at materialized views (snapshots) to accommodate the
same thing.

Finally, I believe a post just came in - but GM Aggregation should also do
the trick....

Jeff

--------------------------------
Jeff Hobbs
GIS Coordinator
San Jose Water Company (NYSE:SJW)
1265 South Bascom Avenue
San Jose, CA 95128
Voice - (408) 279-7833
Fax - (408) 279-7889
jeff_hobbs at sjwater.com
http://www.sjwater.com <http://www.sjwater.com/> 

  _____  

From: geomedia-l-bounces at directionsmedia.net
[mailto:geomedia-l-bounces at directionsmedia.net] On Behalf Of McGuyer,
William C CTR USAF 88 ABW/CEVO
Sent: Friday, June 22, 2007 11:28
To: geomedia-l at lists.directionsmag.com
Subject: [Geomedia-l] RE: Coincidence

I believe I figured out a workaround...I imported the Buildings feature
from the disparate Oracle server into my Oracle server and then ran the
Native Query operator OVERLAPBDYINTERSECT, which gave me the results I was
after. But it would be nice to either have this capability added to GM Pro
or have someone share with me how to do it within GM Pro without having to
import a feature into my Oracle server.

Thanks,
Bill McGuyer 
Oasis Systems, Inc. 
Environmental Management Division 
Wright-Patterson Air Force Base 
Office: 937.257.7039 
Cell: 937.623.8766 
Email: william.mcguyer at wpafb.af.mil 

  _____  

From: McGuyer, William C CTR USAF 88 ABW/CEVO 
Sent: Friday, June 22, 2007 2:14 PM
To: 'geomedia-l at lists.directionsmag.com'
Subject: RE: Coincidence

One other aspect of this spatial query is that I manage the drainage areas
in my local Oracle server but the Buildings feature is managed in a
separate, disparate Oracle server...Native Query seems to only work within
one active Oracle connection.

Bill McGuyer 
Oasis Systems, Inc. 
Environmental Management Division 
Wright-Patterson Air Force Base 
Office: 937.257.7039 
Cell: 937.623.8766 
Email: william.mcguyer at wpafb.af.mil 

  _____  

From: McGuyer, William C CTR USAF 88 ABW/CEVO 
Sent: Friday, June 22, 2007 2:07 PM
To: geomedia-l at lists.directionsmag.com
Subject: Coincidence

List:

I want to run a spatial query to determine which Buildings lie
coincidentally in two or more drainage areas. Buildings are area features
as are the drainage areas. I want output the list to a Data Window, so I
can copy/paste into Excel. To the best of my knowledge, I have not been
able to run this query using any of the spatial query operators--unless I
am not totally understanding how each operator works. There isn't a
"Coincidence" operator.

A simple example of what I am after...Building 23 overlaps drainage areas
4, 6, and 8. I need a list of all of the buildings that coincidentally lie
(overlap) two or more drainage areas.

I am running GM Pro 6 with an Oracle database storing my features. Is
there a simple solution to my query?

Thanks,

Bill McGuyer 
Oasis Systems, Inc. 
Environmental Management Division 
Wright-Patterson Air Force Base 
Office: 937.257.7039 
Cell: 937.623.8766 
Email: william.mcguyer at wpafb.af.mil 

  _____  

From: geomedia-l-bounces at directionsmedia.net
[mailto:geomedia-l-bounces at directionsmedia.net] On Behalf Of Carper,
William J (Joe)
Sent: Friday, June 22, 2007 12:03 PM
To: aphilipp at spaceinfo.ru; geomedia-l at lists.directionsmag.com
Subject: RE: [GeoMedia-l] GeoTIFF: from INGR to ESRI

Alex,

A support worksheet always gives the Intergraph support person more time
to pursue a problem.  Please open a call if you need support.

I have written up some information on this problem, but I don't feel the
public forum is necessarily the best place for me to discuss the
differences between our product and the competition.

Mr. Hobbs and Mr. Haffly both have made cogent comments.  I will add this.

1.      The appearance of "TIFFOpen: C:\Temp\TEST_GT_FINAL.tif: Cannot
open. failure in listgeo", with the absence of GeoTIFF tags in the
'Display Header' output indicates that the file is open or cached in
GMPro.  GMPro locks the file (this is a minor bug we're hoping to fix in
GMPro v6.1), causing the 'failure in listgeo'.  If you exit GMPro and look
at the file again, you will see the complete set of GeoTIFF tags.

2.      The 'unknown tag' messages are not an issue.  They are not GeoTIFF
tags, but are (proprietary?) TIFF tags.  TIFF spec says applications must
ignore such tags if they are not understood.

3.      The mere presence of GeoTIFF tags in an image does not indicate
the file is a valid GeoTIFF file.  Some applications write selected
GeoTIFF tags into their output files and are able to place those images
correctly.  But those applications may not handle valid GeoTIFF files from
other sources, and their output images would not be seen as valid GeoTIFF
by other applications.  GeoMedia is not guilty of this error.

Thanks,

        Joe

-----Original Message-----
From: Alex Philippov [mailto:aphilipp at spaceinfo.ru]
Sent: Thursday, June 21, 2007 9:29 PM
To: Carper, William J (Joe); geomedia-l at lists.directionsmag.com
Subject: RE: [Geomedia-l] GeoTIFF: from INGR to ESRI

Hi, Joe!

In other post I wrote that main problem is:

I can't open GeoTIFF prepared in I/RAS C v7.2 and/or GMP v6.0

 in ArcGIS v9.0.

Steve Frost wrote that this problem was solved in ArcGIS v9.2.

But I haven't v9.2. 

You ask about header of my files. OK, in attachment you can find

GeoTIFFs and headers (from Display Header and listgeo).

I make two variants of sample raster (via GM and I/RAS C) that is

georeferenced in geographic coordinate system (Lon, Lat).

 [See GeoTIFF metadata dumps in attachment.] 

They looks some different, but every raster is well open

 in GeoMedia and I/RAS C. 

However, if I try to open this rasters in ArcGIS then I receive

 message box: "One or more layers is missing spatial reference

 information. Data from those layers cannot be projected."

Nevertheless, after I press OK both rasters displays well in

 geographic CS (Lon/Lat). 

But I can't display it in any other CS, except GCS.

Third variant is IRASC GeoTIFF with corrected georefer. by ArcCatalog +

aux file.

vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

 Hey, ALL! Can anybody try to open this GeoTIFFs in ArcGIS v9.2?

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Your responses will be very appreciated! Thanks in advance!

R.,

  Alex Philippov

-----Original Message-----

From: geomedia-l-bounces at directionsmedia.net

[mailto:geomedia-l-bounces at directionsmedia.net] On Behalf Of Carper,

William J (Joe)

Sent: Wednesday, June 20, 2007 6:22 PM

To: geomedia-l at lists.directionsmag.com

Subject: RE: [Geomedia-l] GeoTIFF: from INGR to ESRI

Hello Alex,

Can you give me an idea what errors you have experienced?  Our GeoTIFF

meets all standards for both TIFF and GeoTIFF, so I'm not sure what we

can do.  

Send me a header of a file from ESRI which GeoMedia can't read, and a

header from one of our files that they can't read, and I'll try to

identify the problem.

It would be good if you could open a support request at the Intergraph

website as well.

Thanks,

  Joe

-----Original Message-----

From: geomedia-l-bounces at directionsmedia.net

[mailto:geomedia-l-bounces at directionsmedia.net] On Behalf Of Alex

Philippov

Sent: Wednesday, June 20, 2007 8:32 AM

To: geomedia-l at lists.directionsmag.com

Subject: [Geomedia-l] GeoTIFF: from INGR to ESRI

Hi, list!

What is the best way to preparing GeoTIFF in INGR environment (GM, I/RAS

C, ISRU...) for using it in ESRI's ArcGIS?

How to transmit a georeference?

Can I have a SINGLE (!) GeoTIFF file which can be correctly opened in

both lines - INGR and ESRI?

Thx in adv!

Regards,

  Alex Philippov

  SpaceInfo

  gis_n_map at yahoo.com

  +7-(495)-2628518 (work)

  +7-(495)-9696556 (mob.)

No virus found in this outgoing message.

Checked by AVG Free Edition. 

Version: 7.5.472 / Virus Database: 269.9.4/860 - Release Date: 6/21/2007

5:53 PM

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.directionsmedia.net/pipermail/geomedia-l/attachments/20070622/22485955/attachment-0001.html