Latest Contributions by TedKowal

‎03-18-2016

... one way to do it in VBscript (Original question implied vbScript) dim NumberOfWords, myLabel dim YourField YourField = [YourStringField] ArrayTemp = split(YourField," ") NumberOfWords = UBound(ArrayTemp) + 1 Select Case NumberOfWords case 1 'One word myLabel = YourField case 2 'Two Words myLabel = YourField case 3 'Three words as in your example myLabel = ArrayTemp(1) & "" & ArrayTemp(2) 'Second and Last Word case else 'more than 3 words myLabel = YourField 'or further processing end select

‎03-18-2016

If all else fails one last ditch effort you could use or try is to create a Tif/JPG image of the microstation drawing and geo reference that and use the world file created for the image for the cad. (This is my last resort trick.... sometimes this works)

‎03-15-2016

I had to do something like this a real long time ago... I can give you sort of an outline of the steps I did my memory is not that good.... 1. Extract all the html table column to save it as text (all records) (I believe I had to add a unique Id to the column snippet to link upon later I used the field calculator to insert the additional column code <td>Unique ID</td>) 2. I am assuming that the table snippets are valid complete table codes: add <Html> [ all your table snippets] </HTML> to the file. 3. Using excel import html table ... I got this idea from this web site: HTML TABLE TO EXCEL SPREADSHEET

‎03-15-2016

Generally speaking cad files are drawn to scale. If yours is drawn scale you can use a two control points to create a world file so the dgn may be overlayed -- thus possibly giving you the opportunity to extract the annotations. If it is not drawn to scale then you may be out of luck About georeferencing CAD datasets—Help | ArcGIS for Desktop

‎03-11-2016

Excel has the same problem of the 255 limit within the "Cells". The problem is not so much as reading the memo/blob field as outputting to the display containers for visual inspection. The only work around I found was through programming... Writing a program to Streaming the blob to and from memory or to a text file. Very cumbersome because management thence forth will be programmatic.* I do not believe there is a direct way to read an Access Memo field directly... * You can use this method to split the memo field into 255 length chunks Example Memo parsing into multiple fields (Not complete) ' *********************************************************************** lngLengthOfInputMemoField = Len(recIn!MyMemoField) lngStartSearchAt = 1 Do Until lngStartSearchAt > lngLengthOfInputMemoField - 2 lngFieldBegin = InStr(lngStartSearchAt, recIn!MyMemoField, "|") + 1 lngStartSearchAt = lngFieldBegin lngFieldEnd = InStr(lngStartSearchAt, recIn!MyMemoField, "|") - 1 lngLengthOfField = lngFieldEnd - lngFieldBegin + 1 lngStartSearchAt = lngFieldEnd ' *********************************************************************** ' Create the exploded records ' *********************************************************************** recOut.AddNew recOut!Field1 = recIn!Field1 recOut!Field2 = recIn!Field2 recOut!Exploded = Mid(recIn!MyMemoField, lngFieldBegin, lngLengthOfField) recOut.Update Loop ' *********************************************************************** ' Get the next record ' *********************************************************************** recIn.MoveNext Loop Until recIn.EOF recIn.Close recOut.Close Set recIn = Nothing Set recOut = Nothing Set db = Nothing End Function

‎03-10-2016

I can think of lots of way.... I have not had any need to do this... 1. Create a ini file (you can find vb code for parsing ini files easily on the internet) or create a txt file. 2. on your form start event code your alias translations from the ini or txt file ----- The closest thing I have done to what you want is to create dropdowns Dropdowns forcing the user to select the layer to represent the table of data your program is expecting then within the leave focus event of the layer dropdown read the fields and allow the user to select the appropriate field for the variables or process you want. This could be easily design into tabs on the form or have this form call dialogs or other sub forms.

‎03-10-2016

Have you tried contacting the TX/NM Department of Transportation. Most states have this already in GIS format. FHWA is another good source for GIS Data... Here is a starting site National Highway Planning Network - Tools - Processes - Planning - FHWA

‎03-10-2016

I use Radians for determining Azimuth's and convert it back to 360 degrees.... here is a VB snippet of code I use from an interactive addIn I created. Me.lng/Me.Lat is the user's selected start point of the line destination is the lat/lng of the endpoint. Some Python guru can easily convert this to Python... Public Function GetAzimuth(destination As LatLng) As Double Dim longitudinalDifference = destination.Lng - Me.Lng Dim latitudinalDifference = destination.Lat - Me.Lat Dim azimuth = (Math.PI * 0.5) - Math.Atan(latitudinalDifference / longitudinalDifference) If longitudinalDifference > 0 Then Return azimuth ElseIf longitudinalDifference < 0 Then Return azimuth + Math.PI ElseIf latitudinalDifference < 0 Then Return Math.PI End If Return 0.0 End Function Public Function GetDegreesAzimuth(destination As LatLng) As Double Return RadiansToDegreesConversionFactor * GetAzimuth(destination) End Function

‎02-25-2016

Good question! I have no idea but also would like know if possible. My workaround is to create an image tif, jpg, gif ... of the title block and place it as a graphic into ArcMap

‎02-19-2016

I do not necessarily do allot of web programming, nor do I use "Brackets" code editor... Generally when you start off programming you need to build a programming environment -- your IDE aka Brackets generally does not contain everything you need to program. I suspect you are programming for the web so some fundamental things you will need (I assuming you are using the ArcGIS api ..) 1. Web server 2. Brackets 3. Any custom JS libraries you are using to be downloaded and installed properly ... this includes dojo (or at minimum..your scripts must reference the path locations of the libraries you are using) 4. Properly located/installed ArcGIS libraries Simple answer to your question, not knowing your problems is Yes there are other things you need to install/locate. Everyone's environment can be different (no one solution). If this is not your problem then giving specific errors along with the offending code can help others isolate your difficulties and provide better or more appropriate answers to your question. Hope this helps.....

‎02-11-2016

Wes Miller Wes you most certainly can set up a model, .net and even powerscipt to the task manager to do that. However in my shop GIS is under engineering not IT and getting the IT folks to make sure the scripts are running has been very problematic -- for me just easier to do myself with a batch file run from my local machine... (Yes I use my local task manager to run the batch).

‎02-04-2016

This is exactly why I do not work with file GDB's! There are no "reliable" ODBC connectors that can attached with any degree of stability. 99.99% of the folks in my Shop are not GIS'rs, work with Word and Excel and do not have arcmap. So I work strictly with SQL Server and MS Access (mainly MS Access slow migration to SQL server) where there is mutual support for attaching and linking to the data stores. 99% of my GIS work is to provide data to the non-GIS folk. The bad side of doing this -- I cannot run with the speed and efficiency provided by the file GDB's. my 2 cents!

‎02-04-2016

Yes ... append all the individual centerlines into one Feature Class (assuming they are all defined the same way) and they all contain a field identifying what route the line is. busline1,busline2,buline3, .... ---> append to a fc called Buslines Once you have the Buslines FC (my example above) create a Linear Reference Feature Class (or use the create routes tool) from that identifying the route field and the length as your measure ---> Busroutes -- Be sure when you QA your individual centerlines segments are drawn in the same direction (my personal rule is the direction of travel) Some references About creating routes from existing lines—Help | ArcGIS for Desktop Create Routes—Help | ArcGIS for Desktop

‎02-01-2016

John, This can be combined into one feature Class... say for example: Feature Class: BusRoutes (PolylineM) ObjectID Route (Identifies specific Bus Routes eg.. Route1, Route1A,Route2 [your names may differ]) AnyInfo pertaining to the complete BusRoute Length ObjectID Route Length Status WeekendOnly 1 Route1 10.5 A False 2 Route1A 15.6 A True 3 Route2 8.5 I False Additonally you may have other tables relating to the bus route say BusStops Table BusStops (tabular data aka spreadsheet) ObjectID,Route,Bus_MilePost,Location,Sheltered ..... Now comes the power of linear referencing..... You can take your spreadsheet and "event map" them to the BusRoute Line. the result will be a point feature of all your bus stops! Ted

‎01-28-2016

John, Your approach is good as any. Some things to watch out for: 1. You have a circular reference -- one recommendation is to stop the end point slightly before the start leaving a small gap. Have that embedded in you rules. 2. Create your Route naming convention before you collect your gps data. 3. Assign your route number to your GPS points when collected (very important) 4. Milepost or you linear unit of measure can be obtained by Filtering your GPS points to the route then "snapping" the point to the Linear Referenced line (all points snapped belong to the same route) then pick off the measure. (Examples/Scripts/Code available on Geonet) but the trick is to filter the snapping to only the lines where the route numbers are the same as the routes in the GPS. -- (Avoidance of using the Near tool which snaps to the closest line) -- my 2 cents Good luck!

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

My Ideas

Latest Contributions by TedKowal

Re: Label expression

Re: unprojected CAD

Re: How may I extract HTML tables from a column in a shapefile?

Re: unprojected CAD

Re: Access Memo fields in ArcGIS 10.3

Re: VB.NET Addin settings

Re: County Road layer-TX/NM

Re: Get line direction/orientation as a numeric field

Re: Import CAD Title Blocks into ArcMap

Re: New to development, Code editor question(brackets)

Re: Is there a way to connect to features and tables in a file geodatabase (gdb) through Micorsoft Access?

Re: Is there a way to connect to features and tables in a file geodatabase (gdb) through Micorsoft Access?

Re: linear referencing for public bus routes

Re: linear referencing for public bus routes

Re: linear referencing for public bus routes

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