Latest Contributions by forestknutsen1

‎04-21-2016

Yes, that is the method that I have used in the past. But that does not support sorting with the time field which is a requirement in this case.

‎04-20-2016

Sure that makes sense. But it must be doing some sorta parsing because in ArcCatalog it looks like this:

‎04-20-2016

I have date and time data in two field in a csv file that I will be appending to a SDE feature class. I have created two fields in the target feature class for the data--date and time--and set the data type to date for both. One goal we have is for the data to be sortable by the time field. I have tested it in ArcGIS 10.1 and it looks like it is working fine. However, when I look with a database tool I see that the time records have a weird date added to them, which I am guessing is just a esri place holder for the date. Screeshot from TOAD So, is this the best practice for storing time? We are on: SDE 10.1 oracle11g Thanks, Forest

‎04-12-2016

I see. Will it be the same inputs every time? Not just some "random" collection of feature classes. Do you need them all in the same feature class in the end or only the report? I think if the input feature classes are static and you need them in one feature class: I would create a "base" empty feature class and use the append tool with field mapping. Then you would still need to do the concatenation. One could then use calculate field tool for this part. Sorry to say I am not much good with model builder--I would use a python script for it. Also, if you did go the python route and all you need is the report you can use a search cursor and run over each feature class after the clip. Do the concatenation inside python and output a csv, tsv, txt, or whatever and skip the append and field mapping object...

‎04-12-2016

Are all of the features in different feature classes? Is that why you can not just export the attribute table? If so, why not merge them together if they have more or less the same schema (field names, etc.). If not you could use field mapping to make sure that "key" fields end up in the same place in the output, e.g. one feature class has a "NAME" field containing the area name but the other one has a "AREA_NAME" field.

‎03-12-2016

Yep, it is just not in that location, but in program files. PyCharm is fine with the location. It is just when I go to seclude a task the windows system does not see the right install of python, so it fails on the import arcpy line. Anyway, I guess I will have to get on to our IT people who packaged Arc up for distribution within the organization and see if they changed the location... Thanks for the input. I am still wondering why windows will not honor me setting the path, pythonhome, and pythonpath values in the system environment to the non standard location.

‎03-12-2016

Dan Patterson wrote: since you are trying to use an unconventional installation. Basically everything works well when ArcMap or ArcGIS Pro are allowed to install their version of python in their preferred location. Hmmm.... this (C:\Program Files (x86)\Python27\ArcGIS10.1) is not the normal location for 10.1? This is where it shows up on my machine I have not tried to modify the arc install of it or installed other versions of python. This is a clean new build. If this is not the normal location then perhaps I have a non-standard install of arc....

‎03-11-2016

So, I recently got a new machine and I am having some frustration importing arcpy. It works fine in PyCharm but does not work when run from the command line. An import test in IDLE: From the command line: IDLE is pointing to the wrong install of python: PyCharm is pointing to the right location which I set: I have set the PYTHONHOME to the ArcGIS location: C:\Program Files (x86)\Python27\ArcGIS10.1 but this makes python not work at all in the cmd. I have also tried setting the PYTHONPATH sys values as: C:\Program Files (x86)\Python27\ArcGIS10.1 C:\Program Files (x86)\Python27\ArcGIS10.1\DLLs C:\Program Files (x86)\Python27\ArcGIS10.1\lib C:\Program Files (x86)\Python27\ArcGIS10.1\lib\plat-win C:\Program Files (x86)\Python27\ArcGIS10.1\lib\lib-tk C:\Program Files (x86)\Python27\ArcGIS10.1 C:\Program Files (x86)\Python27\ArcGIS10.1\lib\site-packages C:\Program Files (x86)\ArcGIS\Desktop10.1\bin C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy C:\Program Files (x86)\ArcGIS\Desktop10.1\ArcToolbox\Scripts I have also SET PATH=%PATH%;C:\Program Files (x86)\Python27\ArcGIS10.1 (which I recall fixing this problem in the past); however, it is now also not doing the trick. I can import arcpy using the python interpreter in the command line: and it is in the module list: Thanks for any help!

‎03-10-2016

I do not have experience with the collector app; however, if one looks on Google play one can see the version of the Android OS needed. Looks like 4.0 or higher is fine. I would imagine that any new tablet will satisfy this, but I would still check. Also make sure it has a GPS on board and is not using cell networks/wi-fi only for location. Collector for ArcGIS - Android Apps on Google Play We do have over 20 Samsung tabs deployed in the field that have a custom app for GPS data collection. We are currently using Samsung tab 4 10.1; however, we are looking for a new device as the tab 4 is now getting old. We have looked at ASUS and Lenovo products. I would be interested in what tabs you decide to look at....

‎03-07-2016

You could try using the Generate Near Table—Help | ArcGIS for Desktop it will also provide a table of features and the distance to near features.

‎02-26-2016

Great! Thanks Dan and Adrian.

‎02-25-2016

How do I change the "base point" (the small x) for a polygon when I am moving it?

‎02-25-2016

I have been using PyCharm for sometime now.

‎02-22-2016

If your shapefiles or feature classes have an unknown coordinate system one could try the below workflow. Find the coordinate system used to make the original data. Open the ArcMap doc where the shapes are displaying correctly. Then open the data frame proprieties. Then go to the coordinate system tab. Note the system in the Current coordinate system field. Now use define projection to set the system in the problem data sets. Then export to KML most likely with Layer to KML Hope this helps

‎02-12-2016

PPDM is in fact the best source for this information. May organizations have corporate memberships. All one needs is a email address from the corporation that holds the membership to get access.

Online Status	Offline
Date Last Visited	‎11-12-2025 11:02 AM

My Ideas

Latest Contributions by forestknutsen1

Re: Time in a field SDE best practice

Re: Time in a field SDE best practice

Time in a field SDE best practice

Re: Identifying Features that fall into an AOI then displaying them in a Report

Re: Identifying Features that fall into an AOI then displaying them in a Report

Re: Import arcpy problems

Re: Import arcpy problems

Import arcpy problems

Re: android tablet specs

Re: Arcgis desktop has encountered a serious application error

Re: Change "base point" for polygon snapping

Change "base point" for polygon snapping

Re: What do you use as a Python editor?

Re: Properly exporting to KML for use in Google Maps

Re: API (American Petroleum Institute) Numbers or US Well Numbers

License Manager Options 11.3 for ArcGIS Pro

Re: Create database view which will show records o...

Re: Steps to Restore Feature Classes / Tables from...

Field map alternatives for windows 11

Add routing service to json for JS app