nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Write Point Geometry out to a Feature Service from XML, after DMS to DD Conversion.

Gene_Sipes

I am polling an external website for XML data that will then update a hosted feature service with point data for stream gauges. One of the issues with the XML data is that the lat and long are in DMS as strings. To solve this I am using field calculators to extract the degrees, minutes, and second values, convert them to double type values, and perform simple math to convert them to decimal degrees. That all works well. The issue I am having is figuring out how to write those converted latitude and longitude values out to the hosted feature service as geometries. I am curious if the fact that the latitude and longitude values are being calculated on the fly, and so is the geometry, that when I go to build my geometry those calculated latitude and longitude values only exist in memory and are not available to the "toPoint()" function. I have even tried breaking out the latitude, longitude, and geometry calculations to their own field calculator processors, but no luck. It's really hard to explain what issue I am encountering, so I appreciate it if you have read this far, and maybe you have some suggestions?

GeoEventService_FieldCalculatorsForLatLongGeometry.PNG

FieldMapper.PNG

Teresa_Blader_2-1731712066601.png

Teresa_Blader_1-1731712005648.png

Finde mehr Beiträge mit dem Tag

2023 UC Technical Workshops

Accepted answers

Gene_Sipes

Ok I worked it out.

I needed to set up my input definition to include the two new fields that I was going to convert my DMS values to DD values to. Then in the geo event service, set up my field calculators to convert the values from DMS to DD and store in those new fields. Finally map them out to my output. Screenshots below for each piece of the pie. Hopefully someone gets something from this in the future!

XML Feed:
https://hayscounty.wetec.us/WETMap/public/hayswlpublic.xml

Input Definition with new fields highlighted:

XML Input Connector:

Hosted feature service output connector, make sure Update only is "NO":

Output Definition, with geometry output:

Geoevent Service outputs to a hosted feature service, and sends email.

Example Field Calculator that converts the XML DMS string value to a double DD value.

In the field mapper, using the DD values for latitude and longitude to construct the geometry.

Data mapped to hosted feature service.

All comments

JeffSilberberg

In the Field Calculator Add Mapping - Geometry and in the Arcade use the point() function.

Replacing my $feature fields with your calculated ones.

Point({"x":$feature.longitude,"y":$feature.latitude,"spatialReference":{"wkid":4326}})

Gene_Sipes

I'll give it a try. Should I just do all of my calculations within a field mapper? That is convert my laititude, longitude, and geometry all from one field mapper processor. Rather than trying to use seperate field calculators for each operation? I have pasted images of my setup below.

This is what ends up happening. My latitude and longitude correctly convert, but geometry is null.

JeffSilberberg

Your arcade expression needs to be something more along the lines of --

Where you create two variables to contain the lat/lon in Degrees and then use them in the point() function.

You could sider using convertDirection() or just use the formula you have already locally.

var lat_dd = ConvertDirection($feature.latitude, angleType: DMS, angleType: DEGREES); //Not Tested

var lon_dd = ConvertDirection($feature.longitude, angleType: DMS, angleType: DEGREES); //Not Tested

return(Point({"x":lat_dd,"y":lon_dd,"spatialReference":{"wkid":4326}}));

https://developers.arcgis.com/arcade/function-reference/geometry_functions/#convertdirection

Gene_Sipes

That makes sense, but I am not sure how to write more than one line expressions in the field calculator or the field mapper.

JeffSilberberg

I either Field Calc or Field Map, click on the Configure Arcade Expression. Be sure to test/run it after you have it built.

Gene_Sipes

Ah man... I gues my version doesn't have that button. I am using 10.9.1 (build 28388).

From my screenshot you can see it is bare bones. What version do you have?

JeffSilberberg

Sorry, the difference is geoEvent versus Velocity.

Maybe build the Arcade in NotePad++ and then pater it as a line into that.

I do not currently have a geoEvent I can access to get the corresponding action.

Gene_Sipes

Yea, no dice. I built the expression in VS Code and pasted into the field mapper for the geometry, but it writes out a null value for geometry.

Logs are citing that I have invalid field mapping for both my Point function and my variables lat_DD and long_DD

Thanks for you help so far.

Gene_Sipes

Ok I worked it out.

XML Feed:
https://hayscounty.wetec.us/WETMap/public/hayswlpublic.xml

Input Definition with new fields highlighted:

XML Input Connector:

Hosted feature service output connector, make sure Update only is "NO":

Output Definition, with geometry output:

Geoevent Service outputs to a hosted feature service, and sends email.

Example Field Calculator that converts the XML DMS string value to a double DD value.

In the field mapper, using the DD values for latitude and longitude to construct the geometry.

Data mapped to hosted feature service.

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.