Latest Contributions by TedKowal

Andrew, Dates are handled differently depending on what database you are using?  Are you querying a shapefile, file geodatabase, personal geodatabase, sql server, postgis, oracle ....   all these have different formats to address when dealing with date data.   Please give the database type from which you want to apply the where clasue to, this will help folks properly answer you questions.  Each of the different databases has there own unique way of handling "Time" -- Generally speaking, using format statements are a way of striping off the time portion, also converting to Month, day and year to make your comparisons is another.  At first glance, it seems that you could search for your date directly... it is not appearent from your question if you are working with true dates (you mentioned that EXP_CST is a date field then in your are comparing a string with a date -- this will not work with all databases to it is important to mention what database you are working with. Look here under dates and time to see how to covert string dates to dates ....for the various types databases. SQL reference for query expressions used in ArcGIS—ArcGIS Pro | ArcGIS Desktop  ... View more

would not the where if it is passed to the oracle database be something like this .... date_column BETWEEN SYSTIMESTAMP - INTERVAL '30' DAY http://www-01.ibm.com/support/docview.wss?uid=swg21262277 ... View more

This discussion is not about speed but of compatibility with products which use the gis data outside of ESRI.  Even though, slower, in the end due to the work effort - you reach your destination much faster.  No I do not have data sets that large (as you indicated) that I use day to day, however I have worked with sets from the state in the neighborhood 4 Million records.  Yes the MS database is slow even the 64 bit drivers, however the start to finish of transferring the data outside of ESRI to other products did not appreciable change.  The work effort in translating the data from the file database to a compatible one far far far far exceeded the slowness of Access.  In addition using MS Access did not introduce other unforeseen errors -- with access no additional programming was necessary to accomplish end goals. Remember the story about the Hare and Tortoise! ... View more

I am running access 2013 and I have no problems importing dbase files?  BTW why do a double import .accdb holds old .mdb tables very well as links?  The whole point about using a personal geodabase is that .mdb file is compatible with a countless other applications and process without having to do any additional work.  The newer access versions link very well to older dbase files, sql server, oracle, post gis and countless other types of databases. Not to mention directly compatible with countless other programs.  The esri file database is ONLY compatible with ESRI products.  The power and mystery that brought me to ESRI was its compatibility with DATA.  I also have been working with the ESRI 64bit drivers for access and have found them OK and work reasonable with reasonable speed unlike vangelo-esristaff  seems to infer.  Additionally, the reason for Access is not for speed, but for compatibility and the lessing of the work effort to reach the end result.  So even with slower speeds, I reach my end point much quicker with fewer mistakes due to many black boxes resident in the ESRI formats. ... View more

Sometime when working with the field calculator the random function seems to hold a static seed as if the function throught the calculation remains as a static variable...I have ran into problems using random numbers in the past within the field calculator so have moved that logic to the database in my shop ..... Resetting the seed.... would that help?  Python: Random System time seed - Stack Overflow  ... View more

So in further reading, what you are trying to do is compare to lists against each other.  The python solution discussed is a good one and very flexible.  However, an alternative, there are SQL solutions to this as well.  Depending on the Database you are using .... I use the following SQL model for comparison..  DECLARE @v1 VARCHAR(MAX) = 'Lime, Tequila, Salt, Sugar',         @v2 VARCHAR(MAX) = 'Party, Fun, TGIF'; SELECT CASE WHEN EXISTS (   SELECT 1     FROM dbo.Split(@v1) AS a     INNER JOIN dbo.Split(@v2) AS b     ON a.Item = b.Item ) THEN 1 ELSE 0 END;‍‍‍‍‍‍‍‍‍‍‍ If your database does not support this type of operation then create two temporary tables fill in the temp tables built from the field lists from both layers then do a simple join. Again the Python solution is excellent, but I wanted to give an alternate path to the same problem. ... View more

The ODBC driver would have to have a "FULL" SQL implementation!  The current pGDB is very limited on the SQL side. ... View more

I am using 64 bit MS Access libraries in various other applications that require 64bit access including the buggy 64bit odbc drivers..... I have not noticed any appreciable speed changes? ... View more

Reading you request, it sounds like you are trying to match one set1 (700) things against another set2 (400,00) based upon one field....   Have you tried using a SQL query? Select a.matchingsetfield, a.fieldstodisplay, b.fieldstodisplay  From set1 as a Join set2 as b On a.matchinsetfield = b.matchingsetfield;‍‍‍‍‍‍‍‍‍‍ ... View more

If you are using any database other than a GDB, you can open up MS Access, connect to the tables you wish and export easily to one excel file from any number of tables or views..... Vote here to keep this extremely flexible and useful tool !  Enable ArcGIS Pro to access ESRI Personal Geodatabases ... View more

I am not an expert but after many years of looking for a similar solutions the only way I have run across is to create a font on your system that matches the cell and use the style manager to control it - extremely time consuming !  This work around was far too cumbersome for me and I have resorted to creating and maintaining a picture library for all my sign types when I need them in GIS. ... View more

Dan is correct .... but ..... One trick I use is a template macro to copy the data I want to another sheet... this is a vary straightforward excel macro.... In excel create a macro (This example will copy data starting on Row 5 down to Row 8 Column "C": Sub PasteData()     Dim rng1 As Range     'this is where you want to place your data     Set rng1 = Sheets("Sheet2").Range("A1")     'Set your range as the starting Row to the last Row you want copied     Sheets("Sheet1").Range("A5:C8").Copy _             Destination:=rng1 End Sub‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I am glad you are making progress!  No workaround is perfect (each comes with its own set problems).  WKT allows you to mix geometries and can handle most of the basic types spatial queries; however, doing any real complex types of spatial queries will eventually mean you will have to develop your own spatial programs to perform them with WKT especially if you are using mix geometries. ... View more

Even though I never experienced the bug....I see that the work-around is a View.  My reason for using view are to: Simplify complex queries into more simplier ones (Makes debugging issues much easier) Simplify Joins and Relationships Cast various datatypes into more generic ones   eg  Varchar --> String or Text  (even though esri does not have issues with this one other applications outside of GIS do) Glad you found workarounds for your issue.  I am sure someone will find this thread helpful. ... View more

It is not only with ESRI products..... try date join with a SQL-Server table to an Oracle table.         Can be a nightmare of workarounds.  Personally I make views setting the join fields in a common format as calculated fields and when I need to use the ESRI table join -- I join it against a "View" which is set up for a simple run of the mill esri table join this is even effective when using date ranges. ... View more