ArcSDE View not working

Question

Hi to all,

I created a ArcSDE 9.3 View with the command line "sdetable –o create_view ...." some month ago. In ArcCatalog I can see the table preview, but not the geography preview. This view is published in a ArcGIS Server 10.1 service, so the polygons are not visible in my web application. When I  created, this view works fine. What can i do to see the polygons in the view?.I would greatly appreciate any feedback you could give me.

Hi michele

VinceAngelo · Answer

Even back at 9.3 (which is now retired), the best way to create views was to use SQL to generate the view itself, then use 'sdelayer -o register' to register the view.  This allows for various validation checks, including a SQL query on the registered rowid column (e.g., OBJECTID), to make sure that it contains unique values, and an 'sdetable -o describe' to verify that the rowid column type is mapping to the SE_INT32 datatype.

The only justification for using 'sdetable -o create_view' is the use of SDEBINARY storage (which was deprecated by Oracle's deprecation of LONG RAW) or SDELOB, neither of which was as flexible as SDE.ST_GEOMETRY.

Given the existance of a 10.1 AGS service, I would strongly urge you to move your geodatabase to a supported install (and make sure that SP1 and the follow-on patches have been applied).

- V

MicheleDe_Santis · Answer

Thank you Jake,

yes, this is the command that i used:

sdetable -o create_view -T INFO_VAS_PIANI_COM_CATASTO -t xyz.SIT_VAS01G_PIANI_COM_CATASTO,xyz.TNO_CODICEUNICO_VAS -c "xyz.SIT_VAS01G_PIANI_COM_CATASTO.OBJECTID,xyz.SIT_VAS01G_PIANI_COM_CATASTO.CODICE_PRATICA,xyz.SIT_VAS01G_PIANI_COM_CATASTO.ORIGINE,xyz.SIT_VAS01G_PIANI_COM_CATASTO.COMUNE,xyz.SIT_VAS01G_PIANI_COM_CATASTO.SHAPE,xyz.TNO_CODICEUNICO_VAS.OGGETTO,xyz.TNO_CODICEUNICO_VAS.AREA_CODICE,xyz.TNO_CODICEUNICO_VAS.ENTE_CODICE,xyz.TNO_CODICEUNICO_VAS.CODICE_UNIVOCO_VAS" -a "OBJECTID,CODICE_PRATICA,ORIGINE,COMUNE,SHAPE,OGGETTO,AREA_CODICE,ENTE_CODICE,CODICE_UNIVOCO_VAS" -w "xyz.SIT_VAS01G_PIANI_COM_CATASTO.CODICE_PRATICA=xyz.TNO_CODICEUNICO_VAS.CODICE_CIVILIA" -i sde:oracle10g:/:xyz -u xyz -p xyz@dbistance

JakeSkinner · Answer

Hi Michele,

Did you include the 'SHAPE' field when you created the view?