|
POST
|
... 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
... View more
03-18-2016
08:12 AM
|
0
|
0
|
1502
|
|
POST
|
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)
... View more
03-18-2016
07:28 AM
|
0
|
0
|
1887
|
|
POST
|
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
... View more
03-15-2016
11:00 AM
|
1
|
0
|
1058
|
|
POST
|
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
... View more
03-15-2016
10:46 AM
|
1
|
0
|
1887
|
|
POST
|
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
... View more
03-11-2016
07:44 AM
|
0
|
0
|
1499
|
|
POST
|
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.
... View more
03-10-2016
09:04 AM
|
0
|
1
|
869
|
|
POST
|
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
... View more
03-10-2016
08:20 AM
|
0
|
0
|
568
|
|
POST
|
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
... View more
03-10-2016
07:46 AM
|
0
|
1
|
2731
|
|
POST
|
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
... View more
02-25-2016
08:00 AM
|
2
|
0
|
1967
|
|
POST
|
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.....
... View more
02-19-2016
07:59 AM
|
1
|
0
|
842
|
|
POST
|
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).
... View more
02-11-2016
07:49 AM
|
0
|
0
|
1745
|
|
POST
|
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!
... View more
02-04-2016
09:00 AM
|
0
|
0
|
1745
|
|
POST
|
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
... View more
02-04-2016
08:09 AM
|
1
|
1
|
1980
|
|
POST
|
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
... View more
02-01-2016
11:01 AM
|
0
|
1
|
1980
|
|
POST
|
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!
... View more
01-28-2016
09:06 AM
|
1
|
3
|
1980
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 10-18-2018 09:46 AM | |
| 1 | 05-23-2018 08:30 AM | |
| 9 | 04-18-2019 07:15 AM | |
| 1 | 05-04-2016 08:15 AM | |
| 1 | 03-24-2017 01:22 PM |
| Online Status |
Offline
|
| Date Last Visited |
10-18-2023
06:40 PM
|