Latest Contributions by ShellyMorgan

‎05-21-2016

I'm having problems projecting data using 10.2.2; yet at work I haven't had a problem projecting data using 10.3.

‎09-22-2014

I need to know how to create a XY Event layer from a Excel table. I using ArcGIS 10.2. I have tried and I get an error message. Also, I tried converting n Excel table to a dbl tabl Ultimately, I need to turn a Excel table to a shape file. I know, we don't use these but......

‎08-19-2013

Can anyone help me with Linear Referencing? I�??ve posted my problem, here on the Forums, and requested help through ESRI for a month now, with no luck. Here is an original message sent to ESRI support. Thank for getting back to me. I am trying to create a map, for our City Public Works department, illustrating pavement conditions along our City streets. We have a report, from the County, designating the pavement conditions; good, bad, poor, etc. However, the report is in an Excel table, with no spatial reference. We need to join the table with our street line feature class; and, create conditions along a route and a unique ID. I hope to use a more efficient process. I've been reviewing ESRI web site for help; like Linear Referencing in ArcGIS and Intersecting Tools for ArcGIS 10- Assign the SLD RouteID. At our City, GIS procedures are done in an Ad-hoc sort of way, interns come & go and standards are not established. In the past this project was done by an intern, and I do not know how the entire project was completed. So, my question is how we can create a map showing our pavement conditions on our City streets. Shelly

‎07-30-2013

William, Thank you for your help. As I mentioned, in my post, I am up-dating our city�??s road condition map, per OCTA Pavement Condition Survey. I short, I was able to complete the task that involved the following; preparing Excel data (from OCTA survey) that has an existing Section ID column, Pavement Condition Index (PCI), Name field etc., and adding a new column, SEGID (numerical). In addition, we have an existing �??Translate�?? table created by a prior intern (a programmer). I created a new Access database and merged these two tables using their common Seg ID fields in a new Access query table. I then joined this table to an existing GIS shapefile using ArcGIS. However, I do not know how this Translate file was created; I am reviewing it for accuracy and the GIS shapefile as well. Ultimately, I�??d like to streamline this process for future use; perhaps create a model. I appreciate any help or suggestions. Shelly Shelly, Our Pavement Management Team has been using GIS to link pavement condition output to pavement segments/shapes drawn using CAD and imported into GIS. The result is a shapefile that can be used to display any number of attributes related to pavement condition, recommended repairs, cost for repair, etc. The linked image below provides a screenshot of this type of data exported to Google Earth. [ATTACH=CONFIG]26258[/ATTACH] https://kimley-horn.securevdr.com/d/s1363cec9d30458e9 The trick, as you mentioned, is to make sure each pavement section has a Unique ID that can be used to link to your pavement management database; I'd be happy to take a quick look to see if the data is ready to be joined using GIS or if you need to use some other descriptors to create a Unique ID on which to base this join. Hope this helps, William Reynolds Kimley-Horn and Associates, Inc. william.reynolds@kimley-horn.com

‎07-23-2013

I need to update my city's public works Pavement Management Plan map. Specifically, it is a street map that illustrates pavement conditions. The County provides the Pavement Management report as an Excel file. A few years back an intern here created an Excel file, called Translate that he joined, in a new Access database, with the County's most recent Excel file. This Translate file must have been coded in a way, so it could be joined on the seg_id field between the two. His process includes a 33 step process. Access has since changed and I tried to complete these steps and rewrite them for streamlining the process, but no luck. There must be a better way! A code, model....something. In addition, I think the Public Works department could utilize ESRI applications. Suggestions? Shelly

‎06-26-2013

I performing a 'Find Data Source' Python script on mxd data files. However, the table report does not automatically open. What do I need to do to read the results? Shelly

‎06-11-2013

I would like to assign to and from cross streets in a street line layer. I followed forum post, ???How to assign ???from??? and ???to??? cross streets to attributes??? (6/2010). I am currently using ArcGIS 10. I have performed a ???Feature Vertices to Points tool (using the ???Start??? option), and Joined the two feature layers together. Now, I need to run a script to associate these start & end points and create to & from attribute intersections. Thanks, Shelly

‎05-20-2013

I would like to analyze population growth, in a portion of Los Angeles and Ventura Counties, with Census data using the Getis-Ord hotspot analysis. I???m including Census data over several decades, for example 1990 to 2010. First, how do I prepare the Census data? Do I combine the data into one table? For selecting a distance band, I understand it will depend on the characteristics of the input dataset. My data, hopefully, will include at least six towns. Shelly

‎04-10-2013

I had a similar situation, I wanted a white background. I went to Properties, Symbology and checked the Invert box. Now, I have a white background, but I zoom in, the image is black. It works.

Online Status	Offline
Date Last Visited	‎07-22-2024 03:14 PM

My Ideas

Latest Contributions by ShellyMorgan

I'm having problems projecting data using 10.2.2; yet at work I haven't had a problem projecting data using 10.3.

Creating a XY Event Layer from a Excel table

Linear Referencing

Re: Creating a map for Pavement Management Program - Public Works

Creating a map for Pavement Management Program - Public Works

Find Data Source report does not open

Creating Street Intersections

Getis-Ord Hotspot analysis for population growth study

Re: How to remove the white background from a TIFF image