Latest Contributions by RobertBorchert

Without spatial analyst it would be very time consuming to do this.  It is doable but will take a lot of work and mathematics Slope is essentially 2 points on different contours and you calculate the Angle from one point to the other. The math is simple use of SOH CAH TOA and you could actually calculate en mass in Excel provided you do the leg work. Going back to my Map Fundamentals class in college.  You place 2 points.  Draw a line to connect them.  Determine the length of the line (hypotenuse) and determine height based on the differences in which contour each point is on.  You will always know one angle is 90 degrees.  However, you won't end up with the nice color map.  But you can have resulting lines with the slope as an attribute. Now to get complicated you can manually make TINs and create polygons from them that you can color based on slope.  But that would take a lot of work Hey rborchert i think that will generate an slope GRAPH. I need a map with diferent colors that indicate the slope in %, with intervals, like this: [ATTACH=CONFIG]31012[/ATTACH] Thanks anyway!!!!!! ... View more

Almost all the slope tools require 3D/Spatial Analyst.  Here is a poor mans idea. Generate Line length between your points and embed them with elevation at their point. then export them to a table which you can bring into Excel and generate a graph based on elevation and length.  it is crude but effective. Hello people I put this thread in this category because I don't know anything about how its done or where it should be. Cartography seemed cool. Here is the thing. I have isolines every 25 m wich I exported from a CAD shape (I don't know if its relevant), and now i wish to make a slope map (and an elevation one if its relationed ;)) setting my own "intervals" in %. Hope you can help me and hope I'm in the correct category 😉 ... View more

It would be helpful if you could post the .csv file instead.  and detail for us the steps you are taking to add a .csv as a feature. It should work.  I have done it with a .csv files of significantly more points than that. What may be happening is it is pushing them to an event layer and often the event layers don't show everything.  Take the event layer that is generated and export it to a shapefile or database and see what happens with the new feature class. I have been researching this issue all day and have tried IE 11, Mozilla, and Chrome browsers.  I have a .csv file of GPS coordinates (latitude/longitude) that I am able to Add under My Content.  I used a sample of 20 records and that file will load, publish as a feature service and display on a map. After I Add a .CSV with more records and publish it, I can see the points in the little preview window under the Feature Service.  When I then try to open that feature service in a new map none of the points will display.  I am at my wits end over this.  The full file is 3,487 points.  I have broken it down to 100, 250, and 500 records and NONE of those will actually display on the map although I am sure that the coordinates mapped correctly.  Is there a bug here?  I Added the whole file yesterday and was able to see all the points, but removed it due to an issue with one of the fields (long story, don't ask).  So now I am really perplexed.  Any assistance would be appreciated.  My esri Account Rep probably wants to strangle me with all the e-mails I have sent him today.  I have attached a picture of the preview window to show that the points do exist....they just won't display in a map for me. Thank you! ~Paula C., OCAC, Syracuse, NY ... View more

It it does not happen with firefox or IE then it is chrome.  Chrome is more streamlined to run faster and it may not be allowing certain scripts or tools to load in it's environment. Are you using Windows XP (still) by any chance? WE've had exactly this (well it sounds like it) flashing black screen when over various panels. It turns out to be graphics card related with XP - to fix it we turned down the Graphic Hardware Acceleration - we found two notches down from the lowest worked fine. Credit here to Martin on our internal help desk, who had seem similar issues with other applications. Not an issue with Windows 7 (afaik) ACM ... View more

I think your best best will be to calculate the x,y values of your points on your lines.  Then in Excel sort your points from low to high and whatever designates a particular line.  Call them something like FromX and FromY For example if it is line called  XXY  sort it Linename and then your sort. at the end of  cell create ToX and ToY for the example. LineName column A Sort        column B FromX     column C FromY     column D ToX        column E ToY        column F in E2 (ToX first blank cell under the headers) =if((A2=A3),C3,"") This will say IF linename for point 1 is the same as point 2 then populate the ToX with the FromX of the 2nd point.  If not leave it blank.  You can then fill in the rest of the rows by dragging it down.  If done correctly you should see blank values for ToX and ToY at all the end points.  Fill in appropriately for ToY and drag it in. Now save it as a .csv.  this will write the values into the cells and remove the formulas.  Then open it back up in excel and delete all the rows with no values in the ToX and ToY Bring the spreadsheet into ArcGIS and use the XY to Line tool and it will build your polylines in correct sorted order and you can attribute them as you wish. This does work.  I  had to create 65000 some spans between all of our transmission structures in our system in sequential order from Structure 1 to whatever on each different line. I have a line that has points evenly spaced on the line. The points are numbered in increasing order along the line. When I use Split Line at Points, my line segments are not ordered with the points. They are appear to be randomly ordered. Is there someway to fix this? I need to at least have the lines numbered such that they are numbered in order so I can extract data to other programs. If this isn't possible, is there a way to create an attribute for each line segment that is equal to the average of the points that are connected to each end of the line. Thanks ... View more

I would suggest simply using mathematics. a² + b² = c² From your excel table. latitude_stca and fac will = a longtude_atca  and  fac = b Distance between the points is c Question.  Regarding unique id you have numbered as 1  is it about 2.886377129 kilometers (or 9469 feet, or 1mi 1396.6yd) away from the centroid? Assuming your lat and long are in meters. IF that is so you can populate your Excel table cell H2 with =(((ABS(C2 - F2) *(10000/90))^2) + ((ABS(D2 - G2) *(10000/90))^2))^(1/2) and drag it down to calculate all the cells. The ^ symbol in Excel performs a square function.  The 10000/90 is converting decimal degrees to kilometers  The ^(1/2) performs the square root function. this is what I came up with. uniqueptzip         latitude_ztcalongitude_ztca fac_id latitude_fac longitude_f  KM                 Miles 1 94501 37.7737968 -122.278123 10735 37.76337 -122.25433 2.886377129 1.793511597 2 94709 37.8792337 -122.2668389 10735 37.76337 -122.25433 12.94855421 8.045858567 3 94601 37.7755447 -122.2187049 10735 37.76337 -122.25433 4.183109881 2.599263973 4 94608 37.836817 -122.2895695 10735 37.76337 -122.25433 9.051487954 5.62433386 5 94501 37.7737968 -122.278123 10735 37.76337 -122.25433 2.886377129 1.793511597 6 94501 37.7737968 -122.278123 10735 37.76337 -122.25433 2.886377129 1.793511597 7 94579 37.6864911 -122.157201 10735 37.76337 -122.25433 13.76361634 8.552314689 8 94501 37.7737968 -122.278123 10735 37.76337 -122.25433 2.886377129 1.793511597 9 94610 37.8114061 -122.2424576 10735 37.76337 -122.25433 5.497946626 3.416265648 10 94579 37.6864911 -122.157201 10735 37.76337 -122.25433 13.76361634 8.552314689 11 94611 37.8294833 -122.2033926 10735 37.76337 -122.25433 9.273343688 5.762188621 12 94501 37.7737968 -122.278123 10735 37.76337 -122.25433 2.886377129 1.793511597 13 94603 37.7365309 -122.1794542 10735 37.76337 -122.25433 8.837855387 5.491588736 14 94803 37.95954 -122.2835546 10735 37.76337 -122.25433 22.03721492 13.6932905 15 94601 37.7755447 -122.2187049 10735 37.76337 -122.25433 4.183109881 2.599263973 16 94609 37.8343906 -122.264374 10735 37.76337 -122.25433 7.969701545 4.952142949 17 94578 37.7061366 -122.1255505 10735 37.76337 -122.25433 15.65831996 9.729628937 18 94601 37.7755447 -122.2187049 10735 37.76337 -122.25433 4.183109881 2.599263973 19 94501 37.7737968 -122.278123 10735 37.76337 -122.25433 2.886377129 1.793511597 20 94501 37.7737968 -122.278123 10735 37.76337 -122.25433 2.886377129 1.793511597 21 94501 37.7737968 -122.278123 10735 37.76337 -122.25433 2.886377129 1.793511597 22 94612 37.8087999 -122.2691955 10735 37.76337 -122.25433 5.311133083 3.300185094 23 94602 37.8043204 -122.2075451 10735 37.76337 -122.25433 6.908361482 4.292656809 24 94501 37.7737968 -122.278123 10735 37.76337 -122.25433 2.886377129 1.793511597 I need to calculate distances between 2 different sets of lat/lon coordinates (one representing zip code centroids, the other representing hospitals).  I created a small test file with 24 records and am trying to use the "XY to Line" tool to get the distances.  For some reason the lines that it outputs are nonsensical.   Clearly I'm doing something wrong with GCS and projection, but I don't know what. I created the zip codes centroids points from Tiger Line polygons, which use GCS North American 1983.   I created the hospital points by geocoding addresses, and they seem to display perfectly when I set them to the same GCS.    Can anyone tell me what I'm doing wrong?  Maybe I need to get out of that GCS and into a projected system right off the bat?? Or is there any easier way to get these distances?   I tried creating a Point Distance table but had other problems with that, and that is a less direct solution anyway because I would then have to somehow lookup values in that table to get distances for my already paired sets of coordinates. ... View more

If you only need to do this once or twice your over thinking it. Simple perform a selection for all feature 1 then field calculate "Very Low" Or create a coded domain for that attribute 1   Very Low 2   Low Etc. That way down the road whenever someone enters the 1, 2, 3 etc... the field will populate with the desired text.  And it will appear as a drop down selection when editing. Dear tech Support Team, I am working on table i want some correction in script for calculating field I have Data in Grid_code field in the form of 1 to 6 In grid_code field there is value 1 to 6 i want 1 is convert as Very low, 2 Is Low, 3 is Moderate, 4 is High and 5 is Very high in Class field i am using following script Dim Output as String If [Class] = 1  Then Output = "Very Low" Elseif [Class] = 2 Then Output = "Low" Elseif [Class] = 3  Then Output = "Moderate" Elseif [Class] = 4  Then Output = "High" Elseif [Class] = 5  Then Output = "Very High" Elseif [Class] = 6  Then Output = "Extreme" Else Output = "xxx" end if Please help me to correct this script or please tell me where i get solution Thanks & Regards Abhishek Misra ... View more

If you still looking take a look at the MSI tablet.  WindPad 110W-224US   $449   AMD Z-Series APU Processors �?�  Windows 7 Home Premium �?�  10" 1280x800 wide-view, multi-point touch screen with IPS �?�  AMD Radeon�?� HD 6250 Discrete-Class Graphics �?�  4GB DDR3 memory with 64GB mSATA SSD storage capacity I have an MSI Laptop for my personal computer at home and it is a very well built machine. Windows 7 You don't have to mess around with emulators. you can stick directly with your ESRI Software and tools. ... View more

Projection always matters. Generally your best bet it to have all features in the same projection.   I like to use personal geodatabases a lot as you can import features into a common feature dataset and have them converted to the same projection. However, sometimes the best projection for one feature is not the same as for another. If both features are in the same projection then do it in their projection. QUOTE=ian31590;358548]Hello all, this question may seem rudimentary, but Its been bugging me and I want to confirm. If say I have 2 polygon layers, zipcode and city boundary for example, and I want to clip the zipcodes using my city boundary, does it matter what projection I do it in (assuming both layers have the same projection)?  I.e. if Zipcode X is inside my city boundary using web mercator, it will still be inside my city boundary if I switch both layers to any other projection?. The projection will only change physical measurements such as distances and areas but not the relative relationship between my polygons. thank you all for the help ... View more

Can you post an example of your spreadsheet.  more importantly an example of the X,Y being used. What projection do you think the spreadsheet is using and what projection is your MXD using Adding a lat/long data layer from Excel to a basemap oriented to  a desired lat/long position. The points do not appear. Zooming to the full extent of the layer, the points show in a location far removed from the basemap. Display properties of  the layer appear as "m" rather than "dd" as in the Excel worksheet. ... View more

Happens sometimes. could be an issue with which version of office it was generated in and there could be imbedded macros or something. Try creating the table first in the geodatabase and then using the data loader. Or open the file in Excel and save it as a .csv then import the .csv to a table Hello, I am trying to import an excel worksheet into a file geodatabase using the Table to Geodatabase (multiple) tool within ArcCatalog but everytime I run it Arc gives me an error saying that "Failed to execute (Copy Rows)". I have imported many excel files into the same file geodatabase recently but at that time no errors were encountered, so that is why I don't understand why I get error this time. I think it is because this time the excel worksheet has some cells that have information in multiple pararaphs so the data in the same cell is separated by spaces. Please let me know what the issue is this time and how I could fix it or work around it to get the excel worksheet into the file geodatabase. Thanks ... View more

rborchert Can I do this in one shot with a few thousand line segments? Do you mean merge them together? Yes you can.  I would do it in segments however.  Often stream data is supplied broken all over the place.  I would select a selection of a couple hundred and merge them. Just make sure that it should have all the same stream data.  For our purposes all that matters to us is the name of the stream.  Now you will most likely end up with multipart features and the little segments are probably not snapped together. What you can try is first make a copy of your streams.  Then build a geometric network on them and have the snap tolerance set up and try to have it automatically snap the end segments together ... View more

Copy the attributes from the line to the polygon. In an edit session in the attributes window right click the stream and select copy attributes.  right click on the polygon in the attributes window and paste attributes. As as previously mentioned if all the polyline segments contain the same data then you can merge them together. question:  I have a line file that dissects a polygon.  This polygon is varying distance away from the line feature that runs down the middle.  Think stream center line line and polygon stream boundary. to Complicate this the line feature is broken up into small segments where as the polygon is not as detailed. What I am trying to accomplish here is do a buffer of a specific location.  If I use the center line if may not find the location, as its not truly representing the width of the stream.  If I use the polygon I don't get the information from the line.  If I buffer to find the polygon, then spatial query to get the line in the polygon I will be grabbing more lines due to the size of the polygons (I could inadvertently grab a stream segment 1/2 mile down stream), I would then have to do another query to find the lines in an optimal location in regards to the original buffer. I think it might be wise to do some up-front development on the layers themselves to make things easier in the long run.  What I was thinking of is trying to offset the line (left and right) to the polygons border.  I cant simply buffer the line feature because I need to to represent the boundary of the stream, as this width varies. Or some way of buffering the line feature (creating a polygon feature) not by a specified width but until it hits the polygon border...is this possible? Or Merger the Polygon into one, then break the polygon based on the length of the line segments.  I can then do a simply spatial query to get the data from the line to the polygon. Any other thoughts on 1-3 above?  Is number 3 possible? Getting the data into a format we can use...data from the line a newly created polygon (based on original poly boundaries) ... View more