POST
|
There are some alternatives .... I will not say they are easier or better only cheaper if you are on a tight budget some of these are free or opensource.... At some point in time I have used all of the below.... ( I currently use Robohelp since now I have a software budget ) Sandcastle -- http://shfb.codeplex.com/ Help & Manual - The most popular help authoring and documentation tool HTML Help Workshop and Documentation from Official Microsoft Download Center KEL CHM Creator v.1.4.0.0 | Dumah's blog HelpScribble - Complete Help Authoring Tool - WinHelp hlp, HTML Help chm, Printed Manual and Web Help HelpNDoc | HTML help authoring tool, Word, PDF and eBook documentation generator Hope this helps for those on a tight budget......
... View more
01-13-2015
07:38 AM
|
0
|
0
|
666
|
POST
|
I am an old vb guy struggling to learn python..... for the challenge I attempted to get a python script to work as well..... Bear in mind this is probably sloppy python but it works.... def FindLabel ([TestChar]):
str = [TestChar]
i = str.find(chr(34))
if i > 0:
newStr = str[:i] + " inch"
else:
newStr = str
return newStr
... View more
12-18-2014
09:05 AM
|
1
|
0
|
485
|
POST
|
I edited my previous post to remove quote (really skipping over it ) and shorten the label
... View more
12-18-2014
08:14 AM
|
0
|
1
|
485
|
POST
|
Using VBScript.... Replace( [Name],chr(34)," inch") No advance script or block needed. --- Tested it with null values no issues..... if you simply want to replace " --> inch Re reading you question If you want to shorten your label then you would need an advanced expression: Function FindLabel ( [Name] )
dblQuote = instr( [Name] ,chr(34))
if dblQuote > 0 then
newStr = left( [Name] ,dblQuote - 1) & " inch"
else
newStr = [Name]
end if
FindLabel = newStr
End Function
... View more
12-18-2014
07:37 AM
|
0
|
8
|
1368
|
POST
|
Clair, I am assuming that you have created polygons for "Urban" and "Rural" areas. Now you want to summarize the counts of accidents ("Your Point Data") within those polygons. There are many ways to approach this... one way is documented by this Technical Article http://support.esri.com/cn/knowledgebase/techarticles/detail/30779 I work for a Transportation agency. Most Agencies have "Urban"/"Rural" classifications already done. Road segments generally contain either an attribute or a link to those area classifications. In addidtion many accident reporting agencies append Urban/Rural Classification to the accident locations... Use of these data field would allow you to "Count" by using simply data queries -- no Mapping Necessary..... Again as Dan mentions a measure of density against "Rural"/"Urban" areas is meaningless. At my agency we calculate for example, Fatalies per 100,000,000 vehicle miles traveled -- this is called a fatality rate. This can be calculated at a Rural/Urban area measure. This can be also done for any sort of accident. Or again as Dan mentioned Accidents per unit length of road.
... View more
11-19-2014
06:51 AM
|
0
|
0
|
430
|
POST
|
....?.... Some ways of exiting a python script albeit not gracefully... sys.exit() quit() os.exit() I am not a python programmer, but some pseudo code would go along these lines. Ok, if at the point you are going to write the point file (differences)... It sound like you need to break up your python script into discrete functions then there would be no need to stop? .... def CheckForDifferences(args to do you differences): .... ... ... get your record count return CountOfRecords def CreateFile( your args): ... return def AddToMDX( your args): ... return # Main part of your script if there are no differences then no file will be created no need to stop or exit prematurely. Difference = CheckForDifferences(args); if Difference > 0: CreateFile(your args): AddToMDX(your args);
... View more
11-06-2014
09:50 AM
|
0
|
1
|
932
|
POST
|
Stephen, I am not a Python guy but in VB and C I generally use a Record Count. If the count is zero then exit the process else carry on. These Links my help you to do this in Python http://forums.esri.com/Thread.asp?c=93&f=1729&t=292293 https://community.esri.com/message/78638?sr=search&searchId=dee6a734-2d0e-42c9-8303-aab21bb2c2dc&searchIndex=19#78638 https://community.esri.com/message/56574?sr=search&searchId=46b59d5c-a090-4485-8904-48ce486d82c0&searchIndex=13#56574
... View more
11-05-2014
09:23 AM
|
0
|
1
|
932
|
POST
|
That was my intent ... so give you a starting point. One more tip... when using access to develop your queries I would do it in multiple phases so that any errors can be isolated quickly... Problem set up... if there is no unique unchangeable ID in your GIS data I would create a field in the elevation data (GIS) that is unique and unchangeable. This field will be used to link the developed sql queries back to the GIS so they may be seen in ArcGIS. MS Access: Create a query selecting the Top 5 (individual query) from the GIS data -- save it in access Create a query selecting the Bottom 5 (individual query) from the GIS data -- save it in access Make sure the above query includes all the same fields including the unchangeable ID field. Create a Union query combining #1 and #2 -- save it in access To see the results in ArcGIS, Add the Union Query to the ArcGIS map as a datatable (If you did not know, you can add a named access query to the ArcGIS Map). Join the elevation gis data with the unique unchangeable ID with that same ID in the union query with matching ID's only. The result map should now only show the Top 5 and Bottom 5 results. Hope this is helpful, Ted
... View more
10-24-2014
07:25 AM
|
0
|
0
|
382
|
POST
|
The SQL expression to be used would be dependant upon your database. A SQL Server way of doing would follow this type of logic:
Select Top 5 Min(ElevationFieldName) Elevation, ElevationID from TablewithElevation
Union All
Select Top 5 Max(ElevationFieldName) Elevation, ElevationID from TablewithElevation
(Note that the number of fields and basic data types must be the same in both select statements.) Oracle does not have a Top function and would have to use embedded select statments with a where clause limiting the rows along with the Union. (A bit more complicated -- plenty of examples on google) Access would be similar to SQL Sever This is what comes immediately to mind!
... View more
10-23-2014
10:30 AM
|
0
|
2
|
382
|
POST
|
I only sent a simple example on how this could be accomplished with MS Access. In the example, each facility can have an unlimited amount of chemicals. The database only restriction is that each site can only have one entry for that one particular chemical but can have many different chemicals example ChemicalFacilitiesNeed Table Facility 1 - chemicalA -- Quantity 5 Facility 1 - chemicalB -- Quantity 1 Facility 1 - chemical C -- Quantity 10 .... Faciltiy 2 - chemicalA -- Quantity 100 Facility 2 - chemicalC -- Quantity 2 ... Facility 3 - chemicalC -- Quantity 3 ... The only restriction is that Facility 1 can only have one chemical of each type and the related quantities for that type Facility 1 is identified in the MasterTable chemical are identified in the chemical table Does this make better sense?
... View more
10-16-2014
09:44 AM
|
0
|
0
|
685
|
POST
|
What Richard says is true, however, I do not find this a challenging thing to overcome (the price of the Highways Extension is). A general rule, the events will change location if you added length to the beginning of the route or some sort of alignment has occurred. When these conditions occur, I simply: Export the events to a feature class and calculate their XY coordinates Update my LRS Run a tool I developed in VB.NET ArcObjects This tool snaps the Exported events feature class back to the new LRS. (This can be accomplished all through a manual process) Calculates the new measure Calculates the new offset (if any) Export the data back to a table with the new measures/offset (This will be the new event table). In our shop most of our attribute data resides in databases outside of ArcGis. This is not really a hard process.... Our LRS rarely changes so this is not something I have to do a lot.
... View more
10-10-2014
12:11 PM
|
1
|
0
|
1461
|
POST
|
I am only guessing what your are asking ..... You will have to add a third table to track what chemicals each facility needs. Pictured below is a relationship that was made to allow multiple chemicals of the same type to multiple facilities. I also attached a working database with an example query called ChemicalsNeededByFacilities. Hope this helps, Ted
... View more
09-18-2014
08:27 AM
|
0
|
3
|
685
|
POST
|
If you are using vbscript....make sure the field that this is being calculated to is a string. CStr([Field1]) & CStr([Field2]) It would help is you indicate the script snippet you are using to concatenate the two fields.
... View more
09-17-2014
06:21 AM
|
0
|
0
|
325
|
POST
|
Using a Def Query you may want to try something like this ... Select ..... where DateDiff('h','Timestampdate', now()) > 3 (Note dates always get me confuse you may have to switch the Timestampdate and the Now() function. -- this will only work against an access database.)
... View more
08-28-2014
08:19 AM
|
0
|
0
|
437
|
POST
|
MS Access doe not have a classical "Timestamp". Generally one would create a macro or function to generate this data on a record in access. MS SQL does have a Timestamp. If you are wanting to process or use a comparative script/sql try passing the sql using a DB Pass-through query. This would allow you to use all MS Access functionality instead of your DSN/ODBC translations (your database link?). I believe you would then use the Access "Now()" function to compare the time values. This is all that comes to mind at moment -- hope this can lead you somewhere.
... View more
08-28-2014
07:58 AM
|
0
|
0
|
437
|
Title | Kudos | Posted |
---|---|---|
1 | 10-18-2018 09:46 AM | |
1 | 05-23-2018 08:30 AM | |
8 | 04-18-2019 07:15 AM | |
1 | 02-23-2018 10:08 AM | |
1 | 12-28-2017 07:36 AM |
Online Status |
Offline
|
Date Last Visited |
10-18-2023
06:40 PM
|