nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

From data table to spatial view

PamelaLandy

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

Encontre mais publicações marcadas com

Accepted answers

All comments

DavidPike

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.

PamelaLandy

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.

DavidPike

I've not implemented it myself but

Spatially Enabling a Table

Looks promising.

Anonymous User

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

PamelaLandy

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

MatthewCarey

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

CraigSwadner

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

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.