POST
|
In 1700 there is now a spatial query but it is not quite what i need. I am hoping to create an add-in in order to query layer based on a certain distance from from a kml point or polygon. Anyone have any ideas if this is feasible? I was thinking I may be able to use polygon.get point on all the points and do a SearchByDistance on each point adding them to my collection.
... View more
06-23-2011
11:07 AM
|
0
|
9
|
1744
|
POST
|
I have never had a chance to try this but you may want to look into it. http://www.codeproject.com/KB/grid/multicolumn_sort.aspx
... View more
05-10-2011
05:00 AM
|
0
|
0
|
183
|
POST
|
Donna, The file number is text as it may contain letters. We just call it a number internally as it has always been called that. I am using a variable in the search and can do a UCase there no problem. My issue is that i need to convert the data i am searching through to UCase also and can not find a way to do that. The reason i need to convert is because this tool I am devoloping will not just search my file numbers but any field from any feature I have selected and that may include different cases for text fields. looking at datagridview.fill I do not see any way to specify the columns. I would actually like to do this as well and was planning on looking into it further. I will let you know what i find.
... View more
04-11-2011
08:24 AM
|
0
|
0
|
212
|
POST
|
So my next problems with my Search Add-in.. 1) The search is case sensitive and I would like it not to be. I was going to use UCase on the search string and the column data. However, since I am using table.search there is no select statement to use UCase on the column I am searching. 2) I would like to use LIKE in the where clause for my columns formatted as numbers. That would mean i need to CAST them as a string. As in the case of the issue abouve, since there is no select statement I can't perform a CAST on the field I am searching. Any ideas are appreciated.
... View more
04-08-2011
06:42 AM
|
0
|
0
|
642
|
POST
|
There is a tool called Export Feature Attribute to ASCII that I just tried for the first time a moment ago. You might look at that, and then see if you can figure out a way to automate importing that into access. Certainly you could import it manually... Good Luck! Joe- Thanks mentioning that tool. I was able to develop a workflow as follows. Import policies to my DB and have a query run that selects only the new policies. I have a model that uses that query to geocode and return an ASCII file to a specific location. I then import the ASCII file into DB and a query appends the new records to my previously geocoded policies. There are a few manual steps but better than geocoding hundreds of thousands of records monthly. I may be able to even update this weekly.. Thanks again!!
... View more
04-07-2011
04:48 AM
|
0
|
0
|
496
|
POST
|
Donna - Good news. It did actually work. I had the old add-in stuck in cache and my updated code didn't go through. Thanks for your help.. searchCriteria.WhereClause = "File_Numbe LIKE'%" & SrchTxt & "%'" Try Dim rows As RowCollection = layer.Table.Search(searchCriteria)
... View more
04-06-2011
08:46 AM
|
0
|
0
|
642
|
POST
|
Donna- That did not work for me. It allows me to search for an exact match put does not work for a partila match. ie- I can search for 1234 and find the file but if i try 12 it does not find 1234. Thanks. Brian
... View more
04-06-2011
05:01 AM
|
0
|
0
|
642
|
POST
|
Thanks Joe. I probably could have worder that better. I will keep digging to see what i can come up with.
... View more
04-04-2011
12:04 PM
|
0
|
0
|
496
|
POST
|
Joe- That does help a little bit. I already have an odbc connection to the access database. I actually use it in a model to geocode the addresses and output to a file geodatabase. I can't figure out how to geocode back to teh access database. Is there any documentation on that? Does it matter that I am using an access 2007 accdb?
... View more
04-04-2011
11:35 AM
|
0
|
0
|
496
|
POST
|
Probably not your issue but i figured I would share. I had a computer where the My Documents was pointed to a location I did not have permissions to. The application will crash in this isntance as it is trying to create and ArcGIS Explorer folder somewhere where it can't.
... View more
04-04-2011
09:48 AM
|
0
|
0
|
147
|
POST
|
I encountered same problem. Because, I have already added add-in to ArcGIS Explorer. Error message said that the assenbly '***' has already loaded from a different location. When I delete the add-in that is already added, I can load add-in. Your computer already has add-in? Please look at the following on your computer. C:\Documents and Settings\<User Name>\Application Data\ESRI\arcgis explorer\AddIns ArcExplorer can only load your add-ins once. If you manually add the add-in to your application and then try to load it from a config you will get the error. If you will be using the app config with the add-ins already added just remove them from your ArcExplorer Resouces - Manage Add-ins.
... View more
04-04-2011
09:46 AM
|
0
|
0
|
454
|
POST
|
You need to place your add-in on a tab to reference it. Here is how I usually do it. Go in and modify your config. Click customizations in the left column (right above add-ins). Click "Tabs" and click "Add New" from the menu on the right. Name it whatever you want. Click that new tab and the click "New Group" Name that whatever you want. Click that new group and select "Add Custom Control" from the right hand column. Click "Choose File" to select your add in. You should then be able to see your tools under the tab you created. There are also options available to set when and where you see the tab but you canplay around with that later. Let me know if you have any questions.
... View more
04-04-2011
09:43 AM
|
0
|
0
|
454
|
POST
|
So i have roughly 500K policies that I geocode monthly from an access database. The access database is populated from a Microstrategy report as I do not have direct access to the policy server. Most of the policies have previously been geocoded. The geocoded results are currently saved in a file geodatabase. I would like to create a workflow where I would only have to geocode new policies and not all policies every month. Any ideas? Can ArcCatalog geocode back to an access database? PS. I only have an ArcView license. Thanks in advance.
... View more
04-04-2011
05:38 AM
|
0
|
7
|
629
|
POST
|
Donna- Actually this thread started yesterday. I think you were looking at my "joined date". Anyhow, I have still not found a solution and am still investigating.
... View more
03-31-2011
07:39 AM
|
0
|
0
|
642
|
Title | Kudos | Posted |
---|---|---|
2 | 03-19-2024 04:36 AM | |
1 | 11-15-2023 12:55 PM | |
1 | 08-01-2023 12:01 PM | |
1 | 07-26-2023 04:51 AM | |
9 | 07-06-2023 05:02 AM |
Online Status |
Offline
|
Date Last Visited |
yesterday
|