Latest Contributions by SethPaine1

Your ObjectId field is all in caps.  Two lines above the line that threw the error (line 89), try changing "objectid" to "OBJECTID" ... View more

Hi Simon, I am running the tool in ArcMap 10.6.1 but the version shouldn’t have too much impact unless its really old. Try copying the file and folder in this zip to the same location and adding to ArcMap. The script may need editing if your .sqlite file format is substantially different than mine. Cheers, Seth Seth Paine Geographic Information Systems Specialist Office of Spill Prevention and Response California Department of Fish and Wildlife 1700 K Street, Suite 250 Sacramento, CA 95811 Office Phone: (916)324-9817 Seth.Paine@Wildlife.ca.gov<mailto:Seth.Paine@Wildlife.ca.gov> http://www.wildlife.ca.gov/OSPR ... View more

I created a script to export a Survey123 SQLite database to a file geodatabase: arcpy - Importing Survey123 SQLite Database from Device - Geographic Information Systems Stack Exchange  ... View more

I created a script to export a Survey123 SQLite database into file geodatabase feature classes: arcpy - Importing Survey123 SQLite Database from Device - Geographic Information Systems Stack Exchange  ... View more

I created a script to allow importation of a Survey123 SQLite database downloaded from a device into a geodatabase: arcpy - Importing Survey123 SQLite Database from Device - Geographic Information Systems Stack Exchange  ... View more

I get this error running from ArcMap 10.5 when when I insert my script tool into a ModelBuilder model.  Both the original script tool and the ModelBuilder tool are set to run in the foreground.  I do not get the error if I use the script tool outside of ModelBuilder. ... View more

As you suggested, I made a toolbox tool from the script and it works perfectly for points.  A funny thing happens when I try it with polygons though (after changing the feature type to POLYGON in the script).  It seems to work and produces a polygon layer, complete with a table representing the duplicated features.  But the polygons will not draw.  If I zoom to the full extent of the feature class, it zooms to the world, but if I zoom to any particular feature, the extent does not move at all.  I don't really need this tool for polygons right now, but am curious as to that particular behavior. PS, what do you normally work on with GIS?  Any tips for learning python without taking expensive ESRI classes? Cheers, Seth ... View more

That did the trick.  Thank you!  Much appreciated. ... View more

Yes, the input is projected in NAD_1983_UTM_Zone_10N ... View more

Hi, I was trying that script and returned this error: Traceback (most recent call last):   File "C:\Python27\ArcGIS10.2\Lib\site-packages\pythonwin\pywin\framework\scriptutils.py", line 326, in RunScript     exec codeObject in __main__.__dict__   File "D:\ArcGIS Tools\CreateDuplicateRecordsOnCountField.py", line 28, in <module>     main()   File "D:\ArcGIS Tools\CreateDuplicateRecordsOnCountField.py", line 14, in main     arcpy.CreateFeatureclass_management(path, name, "POINT", fc_in, "SAME_AS_TEMPLATE", "SAME_AS_TEMPLATE", fc_in)   File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\management.py", line 1800, in CreateFeatureclass     raise e ExecuteError: ERROR 000622: Failed to execute (Create Feature Class). Parameters are not valid. ERROR 000628: Cannot set input into parameter spatial_reference. Any ideas on how to solve this? Thanks! ... View more

I did develop a terribly tedious work around (I am not skilled in python).  I first exported my points to a personal geodatabase.  Then, using Access, I followed the process I found here within the personal geodatabase: Creating duplicate rows - microsoft.public.access.queries I created a table [tblNums] with a single numeric field [Num] and values from 1 to the maximum quantity (1-102 in my case). Then I created a a make-table query of my current table and tblNums (do not link the two tables). I set the criteria under the [Num] field to:   <=[Count] This created a number of duplicate records for each original record equal to the number in my original Count field. I then imported the table into ArcMap, and exported as a new table to give it an OID field.  Then I took my original point feature class and populated two coordinate fields.  Next I joined my original feature class point data table to my new table with replicas (based on a Unique ID).  I then created two coordinate fields in my new table and copied the coordinates from the origin table.  Then I removed the Join.  Lastly, I projected my new table with duplicates based on the coordinate data. It did work, and now I have my original point data with duplicate overlaying features based on the number in my count field.  But I wouldn't want to incorporate this process into a regular work flow. ... View more

HI, I want to get the average distance of a set of points from the start of a route.  However, my point feature class has points that represent multiple records.  In this case, the each point may represent many salmon redds (spawning beds).  I want to know average location of spawning beds per year along a river route, but since each point represents multiple beds, calculating the mean distance of the points along the route under-represents points with multiple beds. Therefore, if I can generate a feature class where each point represents an individual spawning bed, I can then calculate mean distance along the route. Cheers, SP ... View more