Latest Contributions by TedKowal

I have never done this in a model but to get you started perhaps: 1. Create a starting custom script in the model that runs at the beginning  2. That script checks the system data or some other stored date ie project date from your dataset?   3. Compare dates if current date later than checked date then stop model.... Some help references to get you started: Stop—Help | ArcGIS for Desktop  Using a Python Startup/Shutdown Script or PythonCaller to Perform Geoprocessing with Arcpy - FME Knowledge Center  ... View more

I have a ws script which is essentially vb script..I run for extracting data from cvs files which separates first last email ... you may find it helpful:         MyArray = Split(lineRead,",")         ' MyArray(0) contains "FullName".         ' MyArray(1) contains "spaces".         ' MyArray(2) contains "email".         'set MyArray(1) to uppercase             Fullname = UCase(MyArray(0))             Email = (MyArray(2))             WScript.Echo Fullname & " " & Email                                                 namearray = Split(Fullname," ")             testname = UBound(namearray)                     If testname = "2" Then                 Firstname = namearray(0)                 Middlename = namearray(1)                 Lastname = namearray(2)                         ElseIf testname = "1" Then                 Firstname = namearray(0)                 Middlename = " "                 Lastname = namearray(1)             Else                 WScript.Echo "Name not right"             End If                                                                     WScript.Echo Firstname             WScript.Echo Middlename             WScript.Echo Lastname‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I do believe VBScript is no longer supported in Pro.  You will have to re-write your scripts into Python. ... View more

LOL - one of the most flexible databases at there and what does ESRI do.... remove it in pro as an option.  I deal with multiple platforms and data each and every day... MS Access is my collector and workhorse shaping the data for input into other data sources and APPLICATIONS.... not one of which understands a file geodatabase.   Now if I go to the herculean task of migrating to a file geodatabase - It doe not accept 60% of standard SQL.....    How this relates to ordering fields (it was a brainless operation in MS Access). Enable ArcGIS Pro to access ESRI Personal Geodatabases ... View more

If your question is about getting lost within Lists of Lists and how to reference particular elements within python... maybe this would help python - Access item in a list of lists - Stack Overflow   Again as Joshua indicated we are only guessing at what you need? ... View more

Kanchana,   You have be given many different ways on approaching your problem.  All of them valid and workable.  There is no direct magic code to perform what you want directly.  If you wish to script such code that would require advance coding and gis knowledge.  Using some else's, code does require you to install and download all required modules the code requires (You have been given this). Searching Youtube I did find a lot of videos describing some of the techniques mention in this thread by other people... so maybe one of these video will help you? List of videos describing how to covert a shapefile to KML: convert shapefile to kml - YouTube  ... View more

No sir your are incorrect -- ESRI has been pushing that this is a 32 bit or 64 bit issue, as with Access.  If they give the ability to insert an 32 bit OLE object like Word..Powerpoint...Excel ... then access should be included.  Also ESRI fails to mention the 64 bit drivers for the same products that are available....  I know, on my part, the inability to use Access in future is a show stopping event and I have to start planning to use other products in the happenstance that MS Office platform and MS Access will not be accepted as a data sources.  I have not even looked at Pro since I discovered that it cannot read a personal geodatabase.   The inability for the File geodatabase to be integrated, queried using standard SQL, no external interface and compatible with 3rd party products Prisons my data behind ESRI software.   DATA openness was the draw that made ESRI great, differentiate itself from the others that relied on closed files structures to store and use data...yes those are faster but even slower open access provided much more valued results and workflow.  Are we yet going to go back and repeat past mistakes? Again I say this is most definitely related problem and issue and voting to Enable ArcGIS Pro to access ESRI Personal Geodatabases  would most definately assure that the insertion of OLE objects can continue to occur. ... View more

I am sure the module owner would help you get started cleder (Christian Ledermann) · GitHub  ------------ GitHub - cleder/pygeoif: Basic implementation of the __geo_interface__  GitHub - cleder/fastkml: Fast KML processing for python  GitHub - GeospatialPython/pyshp: This library reads and writes ESRI Shapefiles in pure Python.  ... View more

Without ArcGIS installed.... geo_file_conv/shp_to_kml.py at master · cleder/geo_file_conv · GitHub   But you will have to trackdown the additional modules and install them in your environment. ... View more

Your issue is closely related to Enable ArcGIS Pro to access ESRI Personal Geodatabases Please vote to have MS Access Databases enabled in Pro. ... View more

This video help me the first time I used pyodbc... Python connection to Access Database using pypyodbc - YouTube  ... View more

IN VB: IF right([Field],1) = "." then    [Field] = Trim(Left([Field],LEN([Field])-1)) ELSE    [Field]=Trim([Field]) END IF ... View more

IF right([Field],1) = "." then    [Field] = Trim(Left([Field],LEN([Field])-1)) ELSE    [Field]=Trim([Field]) END IF ... View more

This still baffles me when it occurs....  some of the things I try when it does: 1.  Zoom in very close then slowly zoom out (some times the event layer appears) 2.  Open up the event attribute table, select a record and right click and choose the zoom to option. 3.  Convert event layer to a shape file Finally if all else fails... I find a way to ad an ObjectID (one that arcmap recognizes) to the overlay table...most of the time it is creating a false feature class so ArcGis puts in the ObjectID then populate it with the event data...then use that table for event mapping....  <---- This is painful but when all else fails this generally works  ...  After 15 years, I still don't know why this happens --- when it does it is very random occurrence. You can always use Make Table Query(Something I always forget and end up doing it the hardway described above) to get a recognized ObjectID field into the data table.... Some good information can be found here:  Fundamentals of ObjectID fields—Help | ArcGIS for Desktop  ... View more

I do a down dirty Straight Line Diagram by using Linear Referencing systems: For my use, I map out/drawn  5 Expressways as equal length lines.  For each line I created a "Route" with the starting Mile point value and ending Milepoint value.  From there I simply event map the attributes against the created routes... in my example I event mapped intersections with no offset against the linear referenced roads. Same Linear Routes showing Pavement condition and Resurfacing Projects...... ... View more