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
Hi Michele,
Did you include the 'SHAPE' field when you created the view?
Thank you Jake,
yes, this is the command that i used:
sdetable -o create_view -T INFO_VAS_PIANI_COM_CATASTO -t XXXX.SIT_VAS01G_PIANI_COM_CATASTO,XXXX.TNO_CODICEUNICO_VAS -c "XXXX.SIT_VAS01G_PIANI_COM_CATASTO.OBJECTID,XXXX.SIT_VAS01G_PIANI_COM_CATASTO.CODICE_PRATICA,XXXX.SIT_VAS01G_PIANI_COM_CATASTO.ORIGINE,XXXX.SIT_VAS01G_PIANI_COM_CATASTO.COMUNE,XXXX.SIT_VAS01G_PIANI_COM_CATASTO.SHAPE,XXXX.TNO_CODICEUNICO_VAS.OGGETTO,XXXX.TNO_CODICEUNICO_VAS.AREA_CODICE,XXXX.TNO_CODICEUNICO_VAS.ENTE_CODICE,XXXX.TNO_CODICEUNICO_VAS.CODICE_UNIVOCO_VAS" -a "OBJECTID,CODICE_PRATICA,ORIGINE,COMUNE,SHAPE,OGGETTO,AREA_CODICE,ENTE_CODICE,CODICE_UNIVOCO_VAS" -w "XXXX.SIT_VAS01G_PIANI_COM_CATASTO.CODICE_PRATICA=XXXX.TNO_CODICEUNICO_VAS.CODICE_CIVILIA" -i sde:oracle10g:/:XXXX -u XXXX -p XXXX@dbistance
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