Jak mohu nastavit, aby výstup z nástroje Make Query Layer byl feature layer

Question

<\/HEAD>Dobrý den<\/P> <\/P> Vytvořil jsem připojení k oracle databázi z ArcGIS Pro,<\/P> Použil jsem nástroj "Make Query Layer" z Geoprocessing tools, po spuštění nástroje byl výstup samostatná tabulka, co mám udělat, abych získal feature layer místo samostatné tabulky,<\/P> při zadávání parametrů v Make Query Layer formuláři parametr shape type zmizel, potřebuji znát důvod. (viz příloha prosím)<\/P> <\/P> Děkuji předem<\/P><\/BODY><\/HTML>

Robert LeClair · Answer

Michael - I test this using a DB View in AGP and attempted to share as a hosted feature layer using the Share Web Layer command.  If I did not enable editing on the feature layer, it published successfully to AGOL.  However, if I enabled editing on the hosted feature layer, it threw an error saying "editable feature services cannot contain database views.  'riverside.gisadmin.Test1DBV is a database view."  Interesting...

mvolz47 · Answer

Can the database view, from a logical view not a materialized view, be used for feature access capability?  I ask because in ArcMap I tried to publish a mapservice with feature access so there would also be a feature layer, but I received High errors stating that virtual columns are not allowed to be used.  I have no problem using the same data source in a standard mapservice.

Robert LeClair · Answer

Here's a link on how to create a Database View in ArcGIS Pro - it acts like a feature class but it's a view of tables with only the attribute columns you want to see in the view.  As an added bonus, it's read-only so no one can edit the data and you can assign privileges on db views too!