Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generating raster data street name coordinates & which projection to use.

470360Oct 16 2008 — edited Oct 17 2008
Dear everyone

I am about to start the process of generating street name attribute data coordinates for previously georastered raster maps. I am doing this by creating shape files over the pixel areas containing the roads in ArcGIS and then converted the shape files to SDO using the conversion program Shape2SDO. Each shape will be linked to a street name. Does anyone know of an easier way to generate this information, possibly using Oracle itself?

The raster data itself is projected using an obsolete projection as that was the projection used by the map which all maps were then georeferenced to. However when the maps are eventually viewed by users, they will be reprojected using a modern projection, so that users will understand the coordinate system in use. The users will be interacting with the maps via their Web Browser, with the maps served using MapViewer.

I am not sure whether I should store the street name coordinates in the coordinate system using by obsolete projection or whether I should use the modern projection that users will be viewing the maps in. Does any one have any views as to which would be easier to work with when creating the PL/SQL programs.

Kind regards

Tim
This post has been answered by Ivan Bush on Oct 16 2008
Jump to Answer

Comments

Keyser

I've tried to reproduce the issue using the EMP table on 20.1 but can't, it works fine

can you put this into your "JavaScript Initialization Code" for the ROWID item, run the page and copy/paste the output from your browser dev tool console

function( options ) {
    console.log(options);
    return options;
}
Vikas Kumar Pandey

Hi there,

Your code is ok and use ROWID in select query.

John like many others

Thank you guys for help, really appreciated!

Added your code in ROWID on Javascript initialization, output:

  1. Object
    1. dataType: "ROWID"
    2. id: "147320781881306831"
    3. isHidden: true
    4. isPrimaryKey: true
    5. isReadOnly: false
    6. name: "ROWID"
    7. staticId: "C147320781881306831"
    8. __proto__: Object

As every row in an interactive GRID has it's own ROWID I assume APEX is aware of that.

Keyser

this is mine from 20.1

  1. Object
    1. dataType: "ROWID"
    2. id: "33623506008920468369"
    3. isHidden: true
    4. isPrimaryKey: true
    5. name: "ROWID"
    6. staticId: "C33623506008920468369"
    7. __proto__: Object

isReadOnly is the only difference, you could try setting that back but i don't see why it would break it

personally I'm not a fan of using ROWID, under certain conditions it can change and that would cause you all sorts of problems...

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/ROWID-Pseudocolumn.html#GUID-F6E0FBD2-983C-495D-98…

is there a reason you aren't using a normal Primary Key for your DML?

1 person found this helpful
John like many others

I initially had it to "value protected" (read only) also to try out if this is the problem....

Now you may laugh: The table HAS a primary and I initially used it but after loading the mask all records in the displayed GRID were blue (selected) and whenever I changed a value in a record and clicked into the same column in another row it took over the values from the previous set record.I don't have this effect using ROWID but nevertheless I can try to set the original PK and see how the save process will handle that. Yes, agree, the official PK of the table should be used...

John like many others

And all this because it's not possible to set an own separator for multiple chosen values (Poup LOV, Checkbox) in the DB (colon is used). So I have to do a replace ", " -> ":" on reading and on storing back from ":" to "," (it's any existing table I can't change it's content because there are load processes expecting a comma separator). The mask is VERY simple but now spending hours for such things... Nevertheless I'm happy for your hints, thank you!

John like many others

Switching back to original PK but of course further problems with Apex: They PK (2 columns) are enterable attributes and Apex has difficulties when set/overwritten by user and PK is visible as such. No more words for that...

John like many others
Answer

Found it...

I had to read the ROWID with an alias like PK_ROWID and use this a identifier inside APEX, then it works!

Maybe this problem won't occur if the source is a table/view. In my case it's an SQL statement.So instead of:
SELECT ROWID, <any other columns>...

I did:

SELECT ROWID AS PK_ROWID, <any other columns>...

Not sure it this is a bug APEX wise but this is a working solution (works also with update and delete).

Marked as Answer by John like many others · Sep 27 2020
1 person found this helpful
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 14 2008
Added on Oct 16 2008
#data, #database-key-features, #plsql, #spatial
6 comments
740 views