I have all of my data in an Oracle database (Gas Enterprise Model). I need to join the pipe (Line) with the meter (point) in order to have the attributes of both for a report. A query on geometry in Oracle definitely did not work and doing an overlay analysis in Map3D strips the attribute data when I create a buffer. There is nothing to join on for the tables, A Network analysis will not work because the lines are for services and don't have their connected distribution.
If anyone has any ideas on something else to try it would be appreciated.
Solved! Go to Solution.
Solved by deetersmith. Go to Solution.
O.K. I haven't run through it completely, but it appears that if don't get properties to move forward when buffering, does an intermediate step of performing an "identity" topology overlay get you towards the goal? You'd think this would be core spatial analysis functionality, so there must be a way to make it work.
Save parts of the oracle data (line and meters) to SDF and post them or email them to me. you can message me if you need the email addy.
I was able to get an answer using an SQL statement in SQL Developer. When I finally remembered the data checker function in M3D I was able to do some minor changes on one that used the geometry for the basis of the query and it worked very well. If anyone needs the SQL statement as a guide let me know and I will post it.
This is the statement I used to find the answer for points on lines and the attribute information for both. I used SQL Developer to run the process.
select a.fid,a.diameter_nominal,a.pipe_material,b.hte_location_id,b.site_address
from okaloosagas_2012.vw_ga_pipe a,OKALOOSAGAS_2012.vw_ga_risers b
where a.fid !=b.fid
and SDO_RELATE(a.geom,b.geom, 'mask=ANYINTERACT')='TRUE'