how to publish a views layers as map service arcgis server 10.3
In case you are referring to a query layer (What is a query layer?—Help | ArcGIS Desktop ) that shouldn't be a problem. Just remember to register the data source in the data store of Server:.About registering your data with ArcGIS Server—Documentation | ArcGIS Enterprise
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
You may need to register the table with the geodatabase:
Workflow: Create tables with SQL and register them with the geodatabase—Help | ArcGIS Desktop
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');