Latest Contributions by deleted-user-IR249IovB3CN

‎06-29-2017

I've got this same problem, switching high/low to low/high. Has anyone found a solution?

‎04-15-2017

Stumbled across this issue again. Solution: Create a continuous raster with value = 0. Run Cell statistics with all desired rasters, including the continuous raster. The Overlay Statistic = "Sum". Be sure to set "processing extent" in environment settings to "Union of Inputs".

‎03-11-2016

I exported the table from Access as an excel file and attempted the import to the file geodatabase. This initiated the general failure 9999 error. The table was created in the file geodatabase with the correct field names but the fields were empty. I checked the field properties and all fields that were memo type in Access were BLOB type in ArcGIS. As a test I deleted the memo fields in the excel table and attempted the import again. It was successfully imported with all fields populated. Do you know of a simple way to split the memo field and reassemble once it is in ArcGIS as a work around, or any other suggestions? Thanks for your help!

‎03-10-2016

Thank you for the insightful perspective Vince. Unfortunately I am not versed much of what you describe! Any suggestions on how I would determine if the limitation is with the OLE provider? I've come across evidence through other forums/articles that ArcGIS does classify memo as a string in the earlier OLE provider versions such as Micosoft Jet 4.0 OLE DB Provider.

‎03-10-2016

I'm trying to load an Access 2010 database into Arc Catalog through an OLE DB connection using the OLE DB Provider "Microsoft Office 15.0 Access Database Engine OLE DB Provider". Tow of the tables in the Access database contain memo fields (unlimited character length). The database loads/connects correctly but attempting to preview the two tables with memo fields in Arc Catalog I get an error. In Access converting the Access memo fields to Access text fields that have a limited length of 255 solves the problem. Those two tables preview correctly. However I lose data in those fields that were beyond the limit of 255 characters. Does anyone know how to correctly load memo field types? There is no clear segment where splitting the fields would yield meaningful fields so I'd prefer not to attempt that approach. Thank you for any help you can provide.

‎07-18-2012

I think I am missing something here. I have found older (~8 yrs) threads about needing to rename the file extension of the .hgt files obtained from the SRTM data site to .bil and then creating header files for each raster. Is this still the process for using SRTM data in ArcMap? I've found a few older programs (GDAL, LandSerf, various .exe's) to convert but haven't had any luck with them. Since these posts and applications are so old I'm wondering if I have missed a more recent simple solution. I have downloaded V2 30 m SRTM data from the data access site http://dds.cr.usgs.gov/srtm/ as well as .bil files directly from USGS's Earth Explorer. Any guidance is appreciated. Thanks. Matt

‎07-09-2012

This is the solution a colleague of mine came up with to calculate the new date field from 3 exisitng fields of month, day, and year. import system modules import arcpy from datetime import datetime, date, time # set workspace environment env = arcpy.env.workspace = "C:/Files/GIS/Projects/Hypoxia/Shrimp_Hypoxia/AnalysisData.gdb" #Set OverWrite if files already exist arcpy.env.overwriteOutput = True # set local variables inFile = "Full_Dataset_Albers" #Add date field to inFile arcpy.AddField_management(inFile, "DateField","DATE") #Create an UpdateCursor rows = arcpy.UpdateCursor(inFile) #Iterate through each record and update the DateField date with the combination of the 3 fields that provide the components of the date. for row in rows: d_obj = datetime(row.getValue("yr"), row.getValue("mon"), row.getValue("day")) row.DateField = d_obj rows.updateRow(row) del row, rows

‎06-25-2012

Thank you ! Your code worked! Below is my final code with the kernel denisty estimation replacing point density. I still do not understand the for loop though. You create a variable with the name specified by the year list and then an empty layer in the workspace with that name. You are then selecting by attributes in that new layer, but how are the attributes associated with that layer? I thought this was a new empty layer from the arcpy.MakeFeatureLayer_management function? I don't see how the attribute table from the YearFC variable is associated with the new layer. Can you explain? Thank you.

‎06-25-2012

Thanks for the VB Dateserial function. I did not find reference to that in all of my searching. Before I saw this response this is the solution a colleague of mine came up with to calculate the new date field from 3 exisitng fields of month, day, and year. import system modules import arcpy from datetime import datetime, date, time # set workspace environment env = arcpy.env.workspace = "C:/Files/GIS/Projects/Hypoxia/Shrimp_Hypoxia/AnalysisData.gdb" #Set OverWrite if files already exist arcpy.env.overwriteOutput = True # set local variables inFile = "Full_Dataset_Albers" #Add date field to inFile arcpy.AddField_management(inFile, "DateField","DATE") #Create an UpdateCursor rows = arcpy.UpdateCursor(inFile) #Iterate through each record and update the DateField date with the combination of the 3 fields that provide the components of the date. for row in rows: d_obj = datetime(row.getValue("yr"), row.getValue("mon"), row.getValue("day")) row.DateField = d_obj rows.updateRow(row) del row, rows

‎06-22-2012

I am trying to loop through year values in an attribute field of a point feature class and create new point feature classes of all features for each year. For example an FC for 2004, an FC for 2005, and FC for 2006, etc.. The attribute field "yr" is the numeric integer field containing the year values. I want to select all points with "yr" = 2004 and create a new feature class 2004_ELB and so on for the remaining years. My code is below. My SelectLayerByAttribute_management query seems to be incorrect. Beyond that I'm not clear if my loop logic is correct either. Any help is greatly appreciated. # import system modules import arcpy # set workspace environment env = arcpy.env.workspace = "C:/Files/GIS/Projects/Hypoxia/Shrimp_Hypoxia/AnalysisData.gdb" #Set OverWrite if files already exist arcpy.env.overwriteOutput = True # Make a layer from the feature class FC = arcpy.MakeFeatureLayer_management("Full_Dataset_Albers", "FC") #Create a list of years to iterate through to enable selection of each year yrlist = [2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011] print yrlist #Initiate Search Cursor to use in loop of attribute values rows = arcpy.SearchCursor(FC) for row in rows: fieldName = "yr" value = row.getValue(fieldName) for year in yrlist: arcpy.SelectLayerByAttribute_management (FC, "NEW_SELECTION", "yr" = yrlist) arcpy.MakeFeatureLayer_management(YearFC, str(year) + "_ELB")

‎06-22-2012

I'm working on a similar problem and could use some guidance. I am trying to create new feature classes based on an attribute selection loop in python from an existing feature class. I can't figure out how to loop through the attribute values to select in a for loop? Perhaps create a list of unique values and then set up an if then statement? any guidance is much appreciated.

‎06-21-2012

Does anyone know how to use datetime.strptime to calculate a date field using 3 fields that represent year, month, and day? Or perhaps using datetime.strptime to calculate a datefield using a string field of date yyyy/mm/dd?

‎06-20-2012

Thank you Eric. That makes sense. I need to return to the 4th grade math texts! I was thinking linear units not areal units! So the output is the number of points per square kilometer within that cells neighborhood. Sounds so simple now.

‎06-20-2012

This is an old thread but I'm going to take a shot. I need to create a date field from 3 separate numeric fields in my feature class - "yr", "mon", and "day", using python. I can not seem to figure this out. Any help is greatly appreciated! Thanks.

‎06-20-2012

I am also trying to make sense of the density tools. Here are my settings. Spatial units = meters. Output cell size = 1000m, Neighborhood is circle of 50,000m, Area Units = Square Kilometers. The numbers in the output seem very low ranging from 0.2-7.2. The file consists of over 400,000 points. Are these values # of points/km2 within each neighborhood centered on analysis cell? For example, if 2000 points occur in the neighborhood then for the output cell (or analysis cell) the value of that cell will be # of points/neighborhood area(in area units defined here as square Km) or 2000/7853980 Km2 = 0.0002546 pts/km2? Is that correct?

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by deleted-user-IR249IovB3CN

Re: ArcMap 10.3.1 Horizontal Stretched Legend Has Incorrect Label Positions When Override Default Width Selected

Re: Add (SUM) Multiple Rasters of different extents

Re: Access Memo fields in ArcGIS 10.3

Re: Access Memo fields in ArcGIS 10.3

Access Memo fields in ArcGIS 10.3

SRTM HGT raster in ArcGIS 10 - how to convert

Re: How to calculate date field in python script - formatting question

Re: Create new Feature Classes from attribute selection loop

Re: How to calculate date field in python script - formatting question

Create new Feature Classes from attribute selection loop

Re: Make feature layer > Select by attributes loop

Re: How to calculate date field in python script - formatting question

Re: Point Density Question

Re: combining different date and time fields

Re: Point Density Question

Re: ArcMap 10.3.1 Horizontal Stretched Legend Has ...

Re: Add (SUM) Multiple Rasters of different extent...

Re: e00 to Shapefile