Latest Contributions by TedKowal

‎10-30-2017

Without the wildcard you would be comparing ascii value of P to ascii value of P so "in a sense" you are filtering name >= 80 or name <= 80. Please bear in mind a space also has a value....and in some database would influence the results: P[space] <> P "P " <> "P>. So technically my answer to you is yes.... However it can get complicated real quickly with other bumps in the road that I did not mention --- character sets that you are using will have some influence ... My assumption you are using the standard Latin-1 set. Another bump in road is the database you are using.... some database use a dictionary for string comparison and others use a binary operation. So in dictionary sense my example with space would not be correct "P " = "P" whereas in a database using binary operations my answer would be correct "P " <> "P". I was trying real hard in keeping the answer simple..... When you introduce "NULL" values there are even more issues!

‎10-30-2017

Would not a simple cut and paste in an excel file do the same with less steps. Paste table a, Paste table b just to the right of table a

‎10-30-2017

It is because SQL compares strings by Ascii Values when using comparison operators. If you insert a wildcard -- the representative strings returned are included. for example "p" > "P" would return true -- the decimal value for "p" is 112 and the decimal value for "P" is 80 name >= "P%" would compare name with the returned values of "Pxxxxxx" So "P" by itself will be excluded, "Paulding" would be included as well as "p" (lower case has a higher ascii value than uppercase).

‎10-30-2017

KKramer-esristaff‌ 1. Yes I did vote for "Enable ArcGIS Pro. Yes I have contacted support and explained why a GDB is not a solution or work-around for me. I have been doing this since the early 2000's when the GDB first came out and a promised ODBC drivers would follow.....I still have not seen any drivers that would be functional to date in a business sense. 2. It is kinda hard to report on slow performance when "EVERYTHING" is or appears to be slower. From loading data, editing, displaying Aerials, labeling, hell just simple selects. This does not concern me nor is a breaking point ATM ( I can remember feeling ArcMap was slow when it went to version 8 compared to ArcView 3x). Otherwise, I did find everything I need without too much hardship or exploring (had no issue with the interface). I did find everything that I need on a day to day basis -- easily accessible. Of course the graphics look much prettier! But the main use for GIS, for me, is Data (creation, translations and prepping) to share enterprise wide. Thanks for the comments

‎10-27-2017

I recently had a chance to play around with ArcGIS Pro 2. Look and felt nice except for being ungodly slow. I am sure that will change moving forward in its development. However, I did run across a show stopper for me and my agency. We rely heavily on Microsoft Office products and share data between the office products (Outlook, Word, Excel, MS Access, One Note and Visio) and numerous other applications. The personal MS Access database is core to us sharing data. I understand the limitations of the 32 bit drivers -- however there are 64 bit work arounds as well as a 64 bit Access engine which we had to employ for various 64 bit applications. Forcing the File GDB upon our agency is a show stopper. Not one other product outside of ESRI, whereas, 100% of our Agency software products (both 32 bit and 64 bit) versions can read a personal Geodatabase. The GDB is not compatible with anything outside of ESRI. I believe that only leaves a DBF as an option -- are we moving forward? In fact our outside Contracts cannot limit GIS to ESRI formats/products but must be able to accept data from numerous GIS platforms other than ESRI -- again MS ACCESS database has proven over and over to be an essential tool in storing and coverting external data into something we can use. Currently without MS Access there is no possible way for me to go down the ArcGIS pro path. ESRI does not allow editing to a SQL-Lite or SQL Server without special licensing! Any one else facing this situation?

‎10-27-2017

My 2 cents, It sounds like you want to JOIN two tables. But the Key ingredient to make this successful is to have a common key between both tables; then you can see both tables side by side with the rows lined up. With out a common key, this is not doable under standard type practice without very creative logic.

‎10-24-2017

When you do a slice or substring in Python and it starts with "0" then the second number is always the length. This confused me for a while ..... https://www.dotnetperls.com/substring-python

‎10-19-2017

LOL -- We have all been there and STILL make those obvious mistakes

‎10-19-2017

At my operations, we have collectors that submit data in Lat/Long from GPS, phones and other devices. I too use a linear route system, Dan Patterson (suggestion has got me intrigued never thought about doing it that way). But to get back to your question...I have a requirement that each lat/long must have a "Route" number associated to it. With that, I had to develop a program that would: filter my route system by the route number, create a point for the lat/long, then "SNAP" the point to the linear referencing system (Note due to filtering there would be only one line to snap too) then read/calculate the "Measure." (your case it would be Mileage) I use ArcObject along with dot Net programming to accomplish this. Although I have never tried...but theoretically you could perform all the steps manually without any special licensing....I know arc-objects honors all licensing and this bit I use that follows the above steps uses only that that is found with a standard GIS license. (If the models would accept Linear Referencing techniques like returning the measure...this could be incorporated within a model).... but alas the modeling tools do not.

‎10-19-2017

I believe that is true only if you purchase Roads and Highways to have linear referencing online. To answer Ragnhild Tveit , I handle pavement Inspection and resurfacing in house and collect the attributes by linear referencing. The outside collectors and editors edit excel spreadsheets with the data I wish collect along with the route and begin milepost(BMP) and end milepost(EMP). This data can be "Event Mapped" to the Linear Referenced Route and be managed as a Data table within your Database. Here is a sample spreadsheet created from a Data Table in which I store the attributes... All these cross multiple segments.

‎10-16-2017

Just a side comment, the query (WhereClause) you are setting is an exact match. Typically, in experience, in dealing with text types of searches, the user either cannot spell, don't know the whole name or only has partial information. An exact matching whereclause will not handle this type of situation. An old reference I used, much of which is still valid which explains how to use the like operator and wild cards within your WhereClause. "STREET_NAME" LIKE '%Blue Bird%' IQueryFilter.WhereClause Property Just a side note!

‎10-12-2017

I have yet to make Pro work for me... I spend more time trying to figure out why it crashes on me! So atm I have put it aside till there is more stability. I will keep your thoughts in mind and look at the webinar. Thanks

‎10-11-2017

I am an old time VB'r Round function was not initially part of vbscript got added later on! I am a dinosaur too and have used the CINT function for quick rounding for many years In any event... I am pretty much switched over script wise to python now; application wise I am still using vb.net or until they take that away too!

‎10-10-2017

Alternatively: "Pipe ID: " & [ID_PIPE] & vbNewLine & [DIAM_INCH] & " in." & vbNewLine & CInt([LENGTH_FT]) & " ft." I believe if using the field calculator it only accepts Vbscript which is not as rich in functions as VBA or VB ... The CInt will perform the .5 or higher rounding automatically.

‎10-03-2017

I am an old vb'r .... hate python but got to go with the changes..... I found this site useful in starting to migrate my scripts over to python. http://vb2py.sourceforge.net/cgi-bin/convert.py This is only a short term fix.... but it help move my stuff quickly with little re-writes. But basic functions are not hard.... Trim !myField!.strip() or rstrip() or lstrip() A good useful source I use is Python Reference (The Right Way) - DRAFT — Python Reference (The Right Way) 0.1 documentation

Online Status	Offline
Date Last Visited	‎10-18-2023 06:40 PM

My Ideas

Latest Contributions by TedKowal

Re: Doubt on "Select By Attributes" In ArcMap

Re: Append Table to End of Table

Re: Doubt on "Select By Attributes" In ArcMap

Re: ARC GIS Pro Data Sharing

ARC GIS Pro Data Sharing

Re: Append Table to End of Table

Re: Python: If Then with Left Equivalent

Re: Stupid person trying to use ArcGIS Pro

Re: How to export calibrated Route to table

Re: Is it possible to register attributes for parts of a line segment?

Re: WhereClause Street name , House number, Postal code

Re: how to round labels

Re: how to round labels

Re: how to round labels

Re: WHAT HAPPENED TO THE ARCVIEW FUNCTIONS LIKE TRIM, EXTRACT, SUBSTITUTE, ETC? HOW CAN I DO THOSE THINGS IN ARCGIS 10.51?

Re: Overpass and Underpass detection for intersect...

Re: Import of Objects (word-documents, pdf, ...) i...

Re: ArcGIS Pro (.mdb)?

Re: I am trying to calculate a field where i want ...

Re: Date (date field - mm/dd/yyyy) to String (stri...

Cartography and Maps