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

2767
4
05-04-2017 03:46 AM
kendiekenmoe
New Contributor II

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

0 Kudos
4 Replies
XanderBakker
Esri Esteemed Contributor

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 

0 Kudos
kendiekenmoe
New Contributor II

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

0 Kudos
XanderBakker
Esri Esteemed Contributor
0 Kudos
JakeSkinner
Esri Esteemed Contributor

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');