Latest Contributions by RobertBorchert

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

Road Center lines Water (lakes and streams) Sections (dependent on level of scale) Townships Counties States (dependent on level of scale) Countries  (dependent on level of scale) Municipalities Other considerations may be parcels sidewalks/trials buildings Air photos. If you click the Add Data Drop Down button and select Add Basemap the default basemaps from ESRI are decent basic basemaps. what are  major dataset in any base map production? ... View more

Your making this way to hard. if you have a the muni code list simply add the table to an ArcGIS Session.  Join the feature to the table muni table via the 4 digit code.  then populate your name field with the name field from the muni table. Total time to set this up should be less than 2 minutes.  Then depending on your system configuration a little more time to perform the calculation. If it is a recurring operation MS Access is quick and easy as well.  Have your 4 digit code table in there as a LUT. Create a query that joins the 2 tables and perform the update with the double click of a query. ... View more

Make sure the layer are labeling with is on top. Make sure you labels are not set to background draw first. then either mask your labels with a really small halo or a really tight box. I recently created a map with a UTM grid. Unfortunately, the grid lines appear over the top of several labels in my map (See example).  Is there anyway to fix this and have the labels on top of the grid lines instead? [ATTACH=CONFIG]30060[/ATTACH] ... View more