how to publish a views layers as map service arcgis server 10.3?

Question

how to publish a views layers as map service arcgis server 10.3

JakeSkinner · Answer

Hi Kendie, You may need to add a spatial index. Ex: create table tree (code_barre varchar(50), essence varchar(50), coordo_x float, coordo_y float, geometry sde.st_geometry); insert into tree (code_barre,essence,coordo_x,coordo_y,geometry) values ('H501XZ0', 'tge2','123', '123',SDE.ST_GEOMETRY(12,5,null,null,4012)); insert into tree (code_barre,essence,coordo_x,coordo_y,geometry) values ('H501XZ9', 'tge2', '150', '123', SDE.ST_GEOMETRY(11,8,null,null,4012)); insert into tree (code_barre,essence,coordo_x,coordo_y,geometry) values ('H501XZ01', 'tge2', '123','150', SDE.ST_GEOMETRY(11.05,7.085,null,null,4012)); CREATE INDEX tree_indx on tree(geometry) INDEXTYPE is SDE.ST_SPATIAL_INDEX PARAMETERS ('st_grids=100,300,900 st_srid=4012');‍‍‍‍‍‍‍

XanderBakker · Answer

You may need to register the table with the geodatabase:

Workflow: Create tables with SQL and register them with the geodatabase—Help | ArcGIS Desktop

kendiekenmoe · Answer

ok i create a this

create table tree (

code_barre varchar(50),

essence varchar(50),

coordo_x float,

coordo_y float,

geometry sde.st_geometry);

with SQL develloper, went i insert data in my table my table look like view in arcmap

insert into tree (code_barre,essence,coordo_x,coordo_y,geometry) values (‘H501XZ0’, 'tge2','123', '123',SDE.ST_GEOMETRY(12,5,null,null,4012));

insert into tree (code_barre,essence,coordo_x,coordo_y,geometry) values (‘H501XZ9’, 'tge2', '150', '123', SDE.ST_GEOMETRY(11,8,null,null,4012));

insert into tree (code_barre,essence,coordo_x,coordo_y,geometry) values (‘H501XZ01’, 'tge2', '123','150', SDE.ST_GEOMETRY(11.05,7.085,null,null,4012));

went i finish i go to Arcmap but i dont see any think but the attribute table data