POST

Try the event "update" which is part of inherited class "Layer". Also try other events "updateend" and "updatestart" Layer  API Reference  ArcGIS API for JavaScript 3.31
... View more
01202020
05:56 PM

0

6

333

POST

As far as the line geometries are connected, each line geometry first coordinate and last coordinate are identical. Polygon geometries can be constructed by passing the coordiantes from Polyline geometry into Polygon Geometry as below. From your post, I assume you are thinking of solution specifically for intersection lines into multiple geometries? In that case it is two step process, convert the grey lines into single polygon geometry and apply the intersection function to generate the polygons. var polyline = { type: "polyline" , // autocasts as new Polyline() paths: [ [ 111.3 , 52.68 ], [ 98 , 49.5 ], [ 93.94 , 29.89 ], [ 111.3 , 52.68 ] ] }; var polygon = { type: "polygon" , // autocasts as new Polygon() rings: polyline.paths };
... View more
12192019
09:42 PM

0

0

164

POST

Hi Joshua, thanks for responding to my question. I want to do this within the database rather in client. As this Oracle function needs to be used by other stored procedures in processing the data in the Oracle database.
... View more
12192019
03:37 PM

1

1

191

POST

Posting this question for discussion and resolution to calculate the mid point of a Line/Polyline in SDE.ST_Geometry on Oracle Spatial Database. This question is also posted in ArcGIS Ideas.Mid Point function in SDE.ST_GEOMETRY After exploring the Oracle Spatial functionalities and searching for similar problems in other blogs. I could able to create the custom function which calculates the midpoint of a polyline in SDE.ST_Geometry. The methodology is as below:  Convert the SDE.ST_Geometry object into Oracle SDO_GEOMETRY  Use SDO_LRS capabilities of Oracle Spatial to find the mid point coordinate of a line geometry.  Convert the returns Ordinates into SDE.ST_Geometry or WKT format Is there are any other better way or options available within SDE? * As this work around works only in Oracle * The similar work around/custom function can be developed if the Enterprise Geodatabase is PostgreSQL/PostGIS ST_Line_Interpolate_Point
... View more
12192019
05:29 AM

0

3

310

IDEA

Work around solution to achieve this is to use Oracle Spatial function as below create or replace function get_line_midpoint (line_in IN sde.st_geometry)  RETURN sde.st_geometry RETURN VARCHAR2 IS wkt_geometry clob; ora_geometry sdo_geometry; mid_x number(10,6); mid_y number(10,6); mid_point_geom sde.st_geometry; BEGIN SELECT sde.ST_AsText(line_in) INTO wkt_geometry FROM DUAL; ora_geometry := SDO_UTIL.FROM_WKTGEOMETRY(wkt_geometry); mid_x:= sdo_cs.transform(SDO_LRS.CONVERT_TO_STD_GEOM(SDO_LRS.LOCATE_PT(SDO_LRS.CONVERT_TO_LRS_GEOM(ora_geometry, 3), SDO_GEOM.SDO_LENGTH(ora_geometry,3)/2)),8307).SDO_POINT.X; mid_x:= SDO_LRS.CONVERT_TO_STD_GEOM(SDO_LRS.LOCATE_PT(SDO_LRS.CONVERT_TO_LRS_GEOM(ora_geometry, 3), SDO_GEOM.SDO_LENGTH(ora_geometry,3)/2)).SDO_POINT.X; mid_y:= sdo_cs.transform(SDO_LRS.CONVERT_TO_STD_GEOM(SDO_LRS.LOCATE_PT(SDO_LRS.CONVERT_TO_LRS_GEOM(ora_geometry, 3), SDO_GEOM.SDO_LENGTH(ora_geometry,3)/2)),8307).SDO_POINT.Y; mid_y:= SDO_LRS.CONVERT_TO_STD_GEOM(SDO_LRS.LOCATE_PT(SDO_LRS.CONVERT_TO_LRS_GEOM(ora_geometry, 3), SDO_GEOM.SDO_LENGTH(ora_geometry,3)/2)).SDO_POINT.Y; ora_geometry := SDO_UTIL.FROM_WKTGEOMETRY('point (' mid_x  ' '  mid_y ')'); return 'point (' mid_x  ' '  mid_y ')'; EXCEPTION WHEN OTHERS THEN raise_application_error(20001,'An error was encountered  'SQLCODE' ERROR 'SQLERRM); END;
... View more
12192019
05:12 AM

0

0

89

IDEA

Work around solution to achieve this is to use Oracle Spatial function as below create or replace function get_line_midpoint (line_in IN sde.st_geometry)  RETURN sde.st_geometry RETURN VARCHAR2 IS wkt_geometry clob; ora_geometry sdo_geometry; mid_x number(10,6); mid_y number(10,6); mid_point_geom sde.st_geometry; BEGIN SELECT sde.ST_AsText(line_in) INTO wkt_geometry FROM DUAL; ora_geometry := SDO_UTIL.FROM_WKTGEOMETRY(wkt_geometry); mid_x:= sdo_cs.transform(SDO_LRS.CONVERT_TO_STD_GEOM(SDO_LRS.LOCATE_PT(SDO_LRS.CONVERT_TO_LRS_GEOM(ora_geometry, 3), SDO_GEOM.SDO_LENGTH(ora_geometry,3)/2)),8307).SDO_POINT.X; mid_x:= SDO_LRS.CONVERT_TO_STD_GEOM(SDO_LRS.LOCATE_PT(SDO_LRS.CONVERT_TO_LRS_GEOM(ora_geometry, 3), SDO_GEOM.SDO_LENGTH(ora_geometry,3)/2)).SDO_POINT.X; mid_y:= sdo_cs.transform(SDO_LRS.CONVERT_TO_STD_GEOM(SDO_LRS.LOCATE_PT(SDO_LRS.CONVERT_TO_LRS_GEOM(ora_geometry, 3), SDO_GEOM.SDO_LENGTH(ora_geometry,3)/2)),8307).SDO_POINT.Y; mid_y:= SDO_LRS.CONVERT_TO_STD_GEOM(SDO_LRS.LOCATE_PT(SDO_LRS.CONVERT_TO_LRS_GEOM(ora_geometry, 3), SDO_GEOM.SDO_LENGTH(ora_geometry,3)/2)).SDO_POINT.Y; ora_geometry := SDO_UTIL.FROM_WKTGEOMETRY('point (' mid_x  ' '  mid_y ')'); return 'point (' mid_x  ' '  mid_y ')'; EXCEPTION WHEN OTHERS THEN raise_application_error(20001,'An error was encountered  'SQLCODE' ERROR 'SQLERRM); END;
... View more
12192019
05:12 AM

0

0

54

IDEA

I could not able to find the way to calculate the midpoint of the line geometry in the SDE database where the geometries are stored in SDE.ST_GEOMETRY object. There needs to be a function in ST_GEOMETRY object to create a mid point of a line and polyline. Currently the midpoint calculating is possible in ArcGIS Geoprocessing tool. The similar function should be made available in SDE.ST_Geometry functions (SQL functions used with ST_Geometry—Help  ArcGIS Desktop ) which helps in processing the data within the database server.
... View more
12072019
07:16 AM

0

1

241

IDEA

I could not able to find the way to calculate the midpoint of the line geometry in the SDE database where the geometries are stored in SDE.ST_GEOMETRY object. There needs to be a function in ST_GEOMETRY object to create a mid point of a line and polyline. Currently the midpoint calculating is possible in ArcGIS Geoprocessing tool. The similar function should be made available in SDE.ST_Geometry functions (SQL functions used with ST_Geometry—Help  ArcGIS Desktop ) which helps in processing the data within the database server.
... View more
12072019
07:16 AM

0

1

206

POST

Hi Ken, have you tried to find the intersection of two polygons? This should result in a single polygon of overlapping part of A and B polygons. Regards Ashok Esri Australia
... View more
10292019
05:24 PM

0

0

72

POST

Hi Daniel, Duplicate the layers and enable the label on each layer with different respective fields. in respective label field layer, set the visibility. Regards Ashok Esri Australia
... View more
10292019
05:20 PM

0

0

45

Online Status 
Offline

Date Last Visited 
11112020
02:25 AM
