topic Re: From data table to spatial view in Geodatabase Questions

From data table to spatial view

PamelaLandy — Sat, 02 May 2020 03:48:31 GMT

Hi all ,

I have an a table with x, y coordinates in my DB oracle . that I have an a GDB on for my spatial side, how can I convert that table to a point layer inside my GDB. I have tried doing a view but it is still a nonspatial datatable when I view it in desktop arcmap

Re: From data table to spatial view

DavidPike — Sat, 02 May 2020 11:29:05 GMT

Hi Pamela,

If you go to 'Add Data' and point to your table, it will then get added to ArcMap Table of Contents (TOC) on the left-hand-side.

If you then right click on the table, go to 'Display XY' where a popup will then appear for you to specify your coordinate columns and coordinate system (be very aware of the coordinate system you are using, is it lat long or NAD etc?). when you click 'OK' the data should be displayed spatially in your map frame.

At the moment, that data is only being displayed on the fly and does not 'exist' in a spatial context. The final step is to right-click on the newly added displayed data in the TOC and --> Data --> export Data to save it as a shapefile (.shp) or a feature class within a GDB.

Re: From data table to spatial view

PamelaLandy — Sun, 03 May 2020 18:17:54 GMT

Hi Dave , It is a possibility but in postgres I have seen that through a line like this in the view , it is possible to give it the spatial reference

st_point((table.attrlong)::double precision, (table.attrlatt)::double precision, 4326) AS shape

Although I already configured the libst_shapelib.so library I am still looking for the same in oracle.

Re: From data table to spatial view

DavidPike — Sun, 03 May 2020 18:34:01 GMT

I've not implemented it myself but

Spatially Enabling a Table

Looks promising.

Re: From data table to spatial view

Anonymous User — Sun, 03 May 2020 23:36:57 GMT

Hi Pamela

You can use sde.st_point or sde.st_geometry for creating the spatial view. Make sure you add anumeric unique identifier (similar to an OBJECTID field).

You can also try "Make query layer" from ArcGIS Desktop, but this do not create the view in the database, so in the mxd...

Regards

Jesús de Diego

Re: From data table to spatial view

PamelaLandy — Mon, 04 May 2020 04:51:57 GMT

Hi Jesus , Do you have an example or reference for how to generate a spatial view from a table ( points coord(x y) ) using the sde.st_point or sde.st_geometry in oracle.

Thanks in advanced

Re: From data table to spatial view

MatthewCarey — Tue, 12 May 2020 14:56:07 GMT

Hi Pamela, here's an example based on one that's worked for me:

CREATE OR REPLACE FORCE EDITIONABLE VIEW "SCHEMA_NAME"."VIEW_NAME" ("ID", "SHAPE", "JOB_NUMBER") AS
SELECT ID, sde.st_geometry(device_longitude,device_latitude,null,null,4326) SHAPE, JOB_NUMBER

FROM the_source_non_spatial_table;

Database people will have to excuse me if the syntax is poorly done, I'm a bit of an amateur at it.

I guess you can do a similar thing in an Insert or Update statement to make it a permanent point feature class. When you do that you're supposed to create the ObjectID the right way, there's a reference here:

How To: Populate an ArcSDE maintained row ID column when inserting a new ST_Geometry feature with SQL in Oracle

Hope this helps!

Matt

Re: From data table to spatial view

CraigSwadner — Tue, 12 May 2020 18:28:27 GMT

Select * into tablename from view

Craig Swadner (GIS Coordinator)

City of Cape Coral

1015 Cultural Park Blvd.

Cape Coral, Fl 33990

Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net