Select to view content in your preferred language

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

671
4
04-12-2023 04:17 PM
solidsnake
Emerging Contributor

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

 

Tags (2)
0 Kudos
4 Replies
MarceloMarques
Esri Regular Contributor

Please open a ticket with esri technical support to investigate this further, it can be an invalid geometry or the spatial index needs to be rebuilt among other known issues with view, e.g. the view must have only one column named "shape".

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |
0 Kudos
MarceloMarques
Esri Regular Contributor

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.

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |
VinceAngelo
Esri Esteemed Contributor

(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

0 Kudos
MarlonAmaya
Esri Contributor

Hi @solidsnake 

Along with the previous suggestions.

  1. 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

0 Kudos