Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About AshokVanam1
AshokVanam1
New Contributor III
since
08-01-2018
11-11-2020
20
Posts created
12
Kudos given
1
Solutions
3
Kudos received
My Ideas
(2 Idea Submissions)Latest Contributions by AshokVanam1
|
POST
|
Try the event "update" which is part of inherited class "Layer". Also try other events "update-end" and "update-start" Layer | API Reference | ArcGIS API for JavaScript 3.31
... View more
01-20-2020
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
12-19-2019
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
12-19-2019
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 mid-point 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
12-19-2019
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
12-19-2019
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
12-19-2019
05:12 AM
|
0
|
0
|
54
|
|
IDEA
|
I could not able to find the way to calculate the mid-point 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
12-07-2019
07:16 AM
|
0
|
1
|
241
|
|
IDEA
|
I could not able to find the way to calculate the mid-point 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
12-07-2019
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
10-29-2019
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
10-29-2019
05:20 PM
|
0
|
0
|
45
|
Activity Feed
- Kudoed Re: How to know when a VectorTileLayer is finished rendering? (ArcGIS API for JavaScript) for UndralBatsukh. 01-22-2020 03:44 PM
- Got a Kudo for Re: Mid Point of a Polyline in SDE. 01-21-2020 06:38 PM
- Posted Re: How to know when a VectorTileLayer is finished rendering? (ArcGIS API for JavaScript) on ArcGIS API for JavaScript Questions. 01-20-2020 05:56 PM
- Kudoed How to convert a line to polygon in JS API 4.x for JonKwong. 01-20-2020 05:40 PM
- Kudoed Re: Mid Point of a Polyline in SDE for JoshuaBixby. 12-21-2019 05:50 PM
- Posted Re: How to convert a line to polygon in JS API 4.x on ArcGIS API for JavaScript Questions. 12-19-2019 09:42 PM
- Posted Re: Mid Point of a Polyline in SDE on Geodatabase Questions. 12-19-2019 03:37 PM
- Posted Mid Point of a Polyline in SDE on Geodatabase Questions. 12-19-2019 05:29 AM
- Tagged Mid Point of a Polyline in SDE on Geodatabase Questions. 12-19-2019 05:29 AM
- Tagged Mid Point of a Polyline in SDE on Geodatabase Questions. 12-19-2019 05:29 AM
- Tagged Mid Point of a Polyline in SDE on Geodatabase Questions. 12-19-2019 05:29 AM
- Tagged Mid Point of a Polyline in SDE on Geodatabase Questions. 12-19-2019 05:29 AM
- Posted Re: Mid Point function in SDE.ST_GEOMETRY on Data Management Ideas. 12-19-2019 05:12 AM
- Posted Re: Mid Point function in SDE.ST_GEOMETRY on Developers Ideas. 12-19-2019 05:12 AM
- Posted Mid Point function in SDE.ST_GEOMETRY on Data Management Ideas. 12-07-2019 07:16 AM
- Posted Mid Point function in SDE.ST_GEOMETRY on Developers Ideas. 12-07-2019 07:16 AM
- Tagged Mid Point function in SDE.ST_GEOMETRY on Developers Ideas. 12-07-2019 07:16 AM
- Tagged Mid Point function in SDE.ST_GEOMETRY on Data Management Ideas. 12-07-2019 07:16 AM
- Tagged Mid Point function in SDE.ST_GEOMETRY on Developers Ideas. 12-07-2019 07:16 AM
- Tagged Mid Point function in SDE.ST_GEOMETRY on Data Management Ideas. 12-07-2019 07:16 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
11-11-2020
02:25 AM
|