Latest Contributions by JamesFitzgerald

Hello, It's called Extract Values to Points in Spatial Analyst. Thanks J ... View more

Hello, You should not join the OBJECTID Header. You should only join the PT field. The only problem is that you will not carry over the PT's with no trees.  Do you still want the points with no trees. If you do not care about the PT locations with No Trees then join with PT. Also, if the PT doesn't join, then check and make sure they are formatted either as number or text. If you do need the location with no trees, then you need to determine how many have no trees. TO DO THIS:      1. I would use ADD Field to the second table and name it CODE and populate it with 'A'      2. Join the first table to the second table.      3.Export table      3. Go to Attribute table and query the column CODE. Use Code= A. Click on 'Selected Records' button. Then      click on 'switch selection.' This will show all of the PT with No Trees. I would then populate the DBH with 0 to        show there was no tree DBH taken.      4. So now you can join the table to shapefile. Or Table Query. Hope I have helped J ... View more

Hello, So, I believe when you join the tables it is only joining to one of the matches in the OBJECTID. Do the 1200 features have the same OBJECTID's (features) as the 188 OBJECTID's (features). Are they different? About the mismatched points...I have no idea! I would be willing to look at your data. James ... View more

Hello, I used the table query to join a database to a point shapefile through 'Make Table Query.'  Are you working with a CSV file or a database file. You may have to convert to a database file.dbf and export it into your geodatabase. You need a unique identifier "Column Header" to make the join between your shapefile and table. The 'Make Table Query' exports a table with all your column headers you want. I think the problem is your data originating from either you table, point shapefile, and/or unique identifiers. BTW, I did not use quotations in my expression. I can look at your data if you like to get a better idea. I created data to match your data. My data consisted of a File Geodatabase, Point, and a table. Let me know if I can assist, James ... View more

Hello, i had a similar issue. Did you copy and paste the chart into the map layout or did you insert graphic or chart? Thanks ... View more

Hello, Have you joined the CSV file the point.shp? Do you have an unique identifier to make the join? Does the CSV have LAT and LONG? Thanks J ... View more

Hello, First Question: Coastline reference. You could use an aerial image to drop several points by starting an edit session with the point.shp (with your XYZ and coordinates data). For your new points, you could calculate geometry for X field and Y field. Then, also populate the depth field with 0. Another option or addition to above, you could run the interpolation and clip (Data Management) using a shapefile for you Area of Interest. You could also Extract by Mask after you run the interpolation using a shapefile  for area of interest. Second Question: Maybe you could partition by creating an overlapping grid.shp or maybe just a grid.shp. If go this route you can create a grid, then export the points within grid.shp. You then do the analysis of interpolation on the points, merge, and check your data. You could also use a smaller dataset- Not sure if need every point. Hope this helps James ... View more

Hey, This managed to burn about 45 minutes of my day by working on it and showing it to co-workers. We went from two digits to three digits. Awesome! James ... View more

Thanks! The code you all provided is very useful. I understand, and this will be very useful when I cannot not change the attributes to label. Thanks James ... View more

Hello, The code is based on a single point then draws the polygon based on the point's X and Y positions. So if you have over one point it will draw more than one polygon.  For my project I needed to create a bunch of squares based on a certain square feet area. You can enhance the code to draw as you want. To draw a building's foot print you are going to have to alter the dimensions of below: highX = lowX + 162.2539    highY = lowY + 123.2639 I believe the math can be done. Look at trigonometry. I will look and see if I can find any supporting documentation. Thanks ... View more

Hey, You will create one point.shp or many. The polygon is drawn based on the location of the point.shp XY. James ... View more

Hey, So you created a point shapefile? Send me your code you have been working on. James ... View more

Also, You may be able to cut... #Populates a field with DONE so the delete cursor will find and delete.        #This will enable a clean attribute table so dublicates will be eliminated.        arcpy.CalculateField_management("GC_R20","File", "\"Done\"", "PYTHON", "")        print "Process for new polygons is complete"  ... View more