Como posso fazer com que a saída do Make Query Layer seja uma feature layer

Question

<\/HEAD>Olá<\/P> <\/P> Eu criei uma conexão com o banco de dados oracle a partir do ArcGIS Pro,<\/P> Usei a ferramenta "Make Query Layer" das ferramentas de Geoprocessamento, depois de executar a ferramenta a saída foi uma tabela independente, o que devo fazer para obter uma feature layer em vez de uma tabela independente,<\/P> sendo que ao inserir os parâmetros no formulário Make Query Layer o parâmetro shape type desaparece, preciso saber o motivo. (veja o anexo por favor)<\/P> <\/P> Obrigado antecipadamente<\/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!