the feature of the view doesn't show on a map

Question

Hello evryone,

i have created a spatial views in Enterprise geodatabade and registred the view succsesufly.

but when i open the view in the map the polygon doesn't show, the table is not empty and when i select a feature in the table i can zoom to it but it doesn't show on the map

the sql code is:

SELECT pat_entite_z1.SHAPE, pat_patrimoine.code_pat, pat_patrimoine.nature_juridique, pat_patrimoine.ligne, pat_patrimoine.conservation, pat_patrimoine.superficie_depot, pat_patrimoine.etat_immatriculation, 'R' || pat_patrimoine.numero_requisition || '/' || pat_patrimoine.index_requisition AS req, 'T' || pat_patrimoine.num_tf || '/' || pat_patrimoine.index_tf AS tf, pat_patrimoine.statut_pat, pat_patrimoine.superficie_defintive, pat_patrimoine.sortie, pat_patrimoine.nature_sortie, pat_patrimoine.obs, pat_patrimoine.ged, pat_patrimoine.depose_par, pat_patrimoine.immatricule_par, pat_patrimoine.verification
FROM pat_patrimoine INNER JOIN pat_entite_z1 ON pat_patrimoine.code_pat = pat_entite_z1.code_pat;

i have also published the view in portal but i have the same problem.

can you help me

thanks

MarlonAmaya · Answer

Hi @solidsnake

Along with the previous suggestions.

* Did you create the view using ArcGIS Pro? If not, go ahead and create the view using Pro and see if you get a different behavior.

Marlon

MMBR · Answer

Query does not have an ObjectID column with unique values.

SELECT
pat_entite_z1.SHAPE,
pat_patrimoine.code_pat,
pat_patrimoine.nature_juridique,
pat_patrimoine.ligne,
pat_patrimoine.conservation,
pat_patrimoine.superficie_depot,
pat_patrimoine.etat_immatriculation,
'R' || pat_patrimoine.numero_requisition || '/' || pat_patrimoine.index_requisition AS req,
'T' || pat_patrimoine.num_tf || '/' || pat_patrimoine.index_tf AS tf,
pat_patrimoine.statut_pat,
pat_patrimoine.superficie_defintive,
pat_patrimoine.sortie,
pat_patrimoine.nature_sortie,
pat_patrimoine.obs,
pat_patrimoine.ged,
pat_patrimoine.depose_par,
pat_patrimoine.immatricule_par,
pat_patrimoine.verification
FROM pat_patrimoine
INNER JOIN pat_entite_z1
ON pat_patrimoine.code_pat = pat_entite_z1.code_pat;

Views in an enterprise geodatabase—ArcGIS Pro | Documentation - read here to learn all the view requirements.

Create Database View (Data Management)—ArcGIS Pro | Documentation

I hope this helps.

VinceAngelo · Answer

(I moved your post to Data Management/Geodatabase Questions, where folks who deal with this will see it.)

Please add the following details:

* What is the registered rowid column of table  pat_patrimoine?
* What is the cardinality of the relationship between pat_patrimoine and pat_entite_z1?
* What column did you register as the rowid for the view?
* What do the following two SQL queries return?SELECT count(*) FROM {viewname};
SELECT count(*) FROM {viewname} GROUP BY {registered_rowid_column};

- V