Spatial

Log in to follow, share, and participate in this community.
Filter by tag
  • sdo_nn with distance parameter vs sdo_within_distance

    I had a colleague ask me what the difference was between using the sdo_nn operator with a distance specified and a sdo_batch_size of 0 vs using sdo_within_distance. I explained the high level difference but was unable...
    user1287681
    last modified by user1287681
    sdo_nn with distance parameter vs sdo_within_distance

    in Spatial

      Back
    • sdo_within_distance optimization

      I am using srid 4326 and am trying to optimize a spatial query that uses sdo_within_distance. The query has to compare 20 million geometries against 10 million geometries and return pairs that are with 50 meters of ea...
      user1287681
      last modified by user1287681
      sdo_within_distance optimization

      in Spatial

        Back
      • 3D compound polygons not supported in 11g?

        Hi all,   I modified the example presented in the 11g R2 Spatial Developer's Guide, section 2.7.4., to produce a compound polygon in 3D. My spatial object looks like this:   mdsys.sdo_geometry (3003, null,...
        Matti Siren
        last modified by Matti Siren
        3D compound polygons not supported in 11g?

        in Spatial

          Back
        • SDO_LRS.LOCATE_PT and 3306 type geometry

          I have noticed in some cases while new geometry is created using SDO_LRS.CONCATENATE_GEOM_SEGMENTS 3306 type occurs. This happens when those geometry elements are separated (there is a gaps between them). A result&nbs...
          SDO_LRS.LOCATE_PT and 3306 type geometry

          in Spatial

            Back
          • Create the Geom columns (oracle 11g)

            I have a table with data about cities, where it has a column for latitude and longitude to another. I want to load this table for GeoServer, but I need to create a geom column.. How can I convert the latitude and lo...
            Create the Geom columns (oracle 11g)

            in Spatial

              Back
            • Problem transforming geometry

              Hi,     I have a geometry in a certain projection  (French Lambert II Centre) which I would like to transform in Lambert 93. It doesn't work and I don't understand why...   The request : select ...
              ngodelu
              last modified by ngodelu
              Problem transforming geometry

              in Spatial

                Back
              • Plot a geometry along a Polyline

                Hi,   I need to plot a 2006 geometry along polyline in Oracle Spatial and store the resulting geometry as a single sdo_geometry. I calculated the sdo_distance between the two points and derived the number of seg...
                1010855
                last modified by 1010855
                Plot a geometry along a Polyline

                in Spatial

                  Back
                • one to many relation

                  Hi, I have two tables one with point geometry and another table without any geometry.   SQL> select idnumber, geometry from arp;   IDNUMBER          GEOMETRY...
                  don123
                  last modified by don123
                  one to many relation

                  in Spatial

                    Back
                  • Point inside polygons

                    I am trying to figure out a way to get the ids for all the polygons under which a common point falls. Eg if a city(point) falls under a county,state and country I would like pass the co-ordinates for the city and get ...
                    NathanT
                    last modified by NathanT
                    Point inside polygons

                    in Spatial

                      Back
                    • Find Ten Nearest Neighbours within same table

                      1.   Hi All,   Fi   I need to find  ten nearest neighbours of a point and count them in a column.   Below is the example.   Co   Count of these ten nearest neighbours ...
                      CrackerJack
                      last modified by CrackerJack
                      Find Ten Nearest Neighbours within same table

                      in Spatial

                        Back
                      • Using join in the query statement in map builder

                        Hi All,   I have two tables one which has the geometry for the spatial feature and one which has the attributes for the spatial feature. I would like to use a join in my select statement in map builder.Following...
                        NathanT
                        last modified by NathanT
                        Using join in the query statement in map builder

                        in Spatial

                          Back
                        • split arc (curves) into line or polyline

                          Hi,   I have try find a solution how too split/explore Arc(curves) to line segment. Does anyone have this experience, plz give me a clue how to start..   Thanks alots. // Antonio Dang
                          split arc (curves) into line or polyline

                          in Spatial

                            Back
                          • Oracle Spatial and Graph Blog - new posts

                            Hi,   The official Oracle Spatial and Graph blog is open, with articles on technical topics of interest and product news -- straight from the development and product teams. Check it out  at https://blogs....
                            jeanihm
                            last modified by jeanihm
                            Oracle Spatial and Graph Blog - new posts

                            in Spatial

                              Back
                            • Getting started with Oracle Spatial on Oracle RDBMS 12c

                              Hi,   I have an Oracle RDBMS 12cR1 SE. Oracle Spatial is a special feature in an Oracle database to store "spatial/geographic" in a relational model structure.   My questions are the following:   1)...
                              user8058501
                              last modified by user8058501
                              Getting started with Oracle Spatial on Oracle RDBMS 12c

                              in Spatial

                                Back
                              • SDO_GEOMETRY and datapump query - not possible?

                                Using 11.2.0.3   Hi folks,   I move spatial data quite a bit with Oracle datapump but almost always I just toss entire tables about.  Recently I was thinking about using the query functionality of dat...
                                Paul Dziemiela
                                last modified by Paul Dziemiela
                                SDO_GEOMETRY and datapump query - not possible?

                                in Spatial

                                  Back
                                • 3D compound coordinate system for SRID 82027

                                  Hello all,   after the migration of the geo data from oracle  10.2.0.1.0  to  11.2.0.3.0  we have following problem: SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT matches the geo data as invalid. ...
                                  3D compound coordinate system for SRID 82027

                                  in Spatial

                                    Back
                                  • bypassing the spatial index

                                    Hi,   Could someone please answer by questions?:   I was reading the "Pro Oracle Spatial" book and it has the following about the two stage filtering when using spatial operators: "In some cases, however,...
                                    udadi
                                    last modified by udadi
                                    bypassing the spatial index

                                    in Spatial

                                      Back
                                    • the sample data about ndm

                                      Hi, I am trying to understand the new features of oracle 11gR2. I have a oracle 11gR2 installation and trying out the NDM TUTORIAL. I am facing the following problems: I tried to download the sample data (.dmp)fo...
                                      774822
                                      last modified by 774822
                                      the sample data about ndm

                                      in Spatial

                                        Back
                                      • Spatial Data Licensing for a client demo

                                        Hi ,   We are working on demos for customer on OBIEE maps with Google. However, due to the data in the spatial tables, we are able to see only US states and cities. We want to demo Google maps with European citi...
                                        user263065
                                        last modified by user263065
                                        Spatial Data Licensing for a client demo

                                        in Spatial

                                          Back
                                        • *LI/Oracle Spatial Summit '14 -- Call for Proposals Extended!*

                                          The LI/Oracle Spatial/HERE/LocationTech Summit is extending our Call for Proposals to Feb. 20.   If you haven't submitted a use case proposal yet, there's still time to do so.   Visit http://www.locati...
                                          jeanihm
                                          created by jeanihm
                                          *LI/Oracle Spatial Summit '14 -- Call for Proposals Extended!*

                                          in Spatial

                                            Back

                                          Actions