Latest Contributions by KimberlyGarbade

Hmmm.... Points to lines was the first thing I thought of to, but your description and the picture make it look like it won't work (in my opinion at least), without figuring out how to assign the points the correct order.  Even draws the crossing lines isn't easy because you have to know that "42" is "across" from "41" and not "43"..... Do the points have any other attributes and do you have the centerline of the roadway the points are adjacent to?  Sorry to keep asking questions. ... View more

Just to be clear in my head: Do you want to create a polygon that represents the edge of the roadway? If so I have a few questions:  1) Is it just this one roadway or are their others and do the others intersect this one or each other? 2) Is it always the case that the odd IDs are on one side of the road and the evens on the other, or can they be "mixed"? 3) Do the IDs always increase or decrease as you move along a single roadway in either direction (I.E. could the numbers on one side of the road go 249, 251, 247, 253.... sort of "out of order"))?  ... View more

In ArcMap click the Customize tab and then select Style Manager When the "Style Manage" opens click to expand the "C:\..." folder and select "Color Ramps" Right click in the white space to the right of the partition and select "New" > "Multi-part Color Ramp..." In the Color Ramp dialog that opens click "Add" and Choose "Algorithmic Color Ramp" Double click the Color Ramp image that appears to the left and pick blue for Color 1 and red for Color 2 and click apply. Repeat the last few step to "Add" another algorithmic color ramp under the first this time select red as Color 1 and blue as Color 2 and clip apply.  The results will look like this: When you hit apply you can click on the Name and give it any name you want.  The next time you open your color ramps in ArcMap it will appear as an option.   Hope this helps. K ... View more

When you mention that you see the coordinates with 4 decimal places, what environment/situation is this in? ... View more

I'm guessing it isn't working because your datastore is using a different RDBMS than your expecting. If it's using PostGRE you could try the TO_DATE() or TO_TIMESTAMP() function. TO_DATE is just the DATE and TO_TIMESTAMP is (you guessed it) date and time, if you need to be that specific.  If it's SQL Server you could try CONVERT() ... View more

What type of app are you writing?  First thing that comes to mind is that it sounds like a problem using asncy might be able to solve.  ... View more

If I understand you correctly you would like to add a value to a domain in AGOL. This link should help.  https://support.esri.com/en/technical-article/000012279 ... View more

Sorry.  You are correct.  That does not do what you want (should have tested it). I had to write a customized function (I had to alter the original so ALTER rather than CREATE is shown): ALTER FUNCTION [GISDC].[TotalM] (@geom geometry) RETURNS FLOAT WITH EXECUTE AS CALLER AS BEGIN DECLARE @x integer; DECLARE @y integer; DECLARE @z float; DECLARE @q float; set @x = @geom.STNumPoints(); set @y = 1; set @q = 0 WHILE @y <= @x BEGIN set @z = convert(float, geometry::STGeomFromText(@geom.STPointN(@y).ToString(),0).M); set @q = @q + @z set @y = @y + 1 END; RETURN(@q); END; GO Input test line result     ... View more

Not near a computer but I would think something like Select sum(geometey.M) FROM FeatureTable GROUP BY PolylineID But, like I said, haven't tested it and it in SQL Server speak 🙂 ... View more

When you ordered did they send you an order fulfillment confirmation email... something like that. I seem to remember you need to go to the link provided there and i think they give you step by step directions. I just did this a few months ago myself and I think I'm remembering right. You've probably done this already, but if not I would start there. The only other thing I can think is that maybe you have an old email/account that is confusing the system.  ... View more

I would image you could use Select By Location to find all of the "line points" within 20 feet of a point in point layer one.  Then you could use the same tool with with the search distance set to zero (0) ft, the select type set to "Remove From Current Selection", and the point layer 2 as the selecting features and you should be left with just the point you want (if I understand your original post correctly).  That being said Python offers so much more.  You could step through each point and compare it to not only the other points but customized criteria.  If (for example) your criteria were based on a combo of proximity and attribute values or relationships, they could be addressed specifically.  ... View more

I don't think there is a single tool that can do what you are describing.  A good place to start would be Create point features along a line—ArcGIS Pro | Documentation. This will allow you to create the points every 700 meters along your line, but it would not exclude any points.  For that you would have to use spatial analysis comparing your new points to your two existing point layers....selecting out just the new points you want and discarding the rest.  Then use the resulting points to split your lines. The only other method I can think of is writing a custom script (python probably) that would do everything you describe above. I guess it depends on if how often you are going to run this analysis.  If you are going to run it many times, or you'll want to change up the distance between points, etc. I would write the script.  If it is just a one time analysis I would try the first method. ... View more

You are still going to need a common field between the two datasets (Meter Locations and Meter Measurements).  You mentioned that you only have 6 meters that all of the records in the Flow Measurements table link to.  In the Flow Measurements table is their an ID assigned to the 6 meters (I.E. you take a measurement once a month for 10 years at each of the 6 meters for a total of 720 records; 120 of which are for Meter A-1, 120 for A-2, etc.)?  If this is the case you can add a column to your Meters point feature class and just populate that ID into each of the 6 records.  That would give you the common field you need. ... View more

I think you are going to want to import your Excel file into a geodatabase as a table and then use the "Create Space Time Cube From Defined Locations" geoprocessing tool using the imported table as the "Related Table".  This will create a Space Time cube you can use as input into your Change Point Detection Tool. Create Space Time Cube From Defined Locations (Space Time Pattern Mining)—ArcGIS Pro | Documentation ... View more