POST
|
I'm happy I can help a little! As for verifying your query that one is tough no matter what because you're going to need to verify the correct number of records. If you are able to have the data maintainers verify, that is always good because no one will know the data better, maybe they even have an SSRS report or something similar from another system that can give you the correct number of records you should be looking for in your query. You will really need to learn the data well if you want to be sure of your SQL query results (this is true across the board with any data you'll ever interact with and build systems to update). If you have a DBA who is good with SQL you might reach out to them for good resources and help! Good Luck!
... View more
05-17-2018
02:50 PM
|
0
|
9
|
2548
|
POST
|
Database Management tools are: SQL Developer Studio for Oracle, Microsoft SQL Server Management Studio for SQL, PgAdmin III for PostgreSQL. They are the tools provided by the database software for managing the database. I am no longer using the views - the performance of the views was very slow. In Oracle, with "in" statements like mine, if I had hard coded values like this: SELECT *
FROM myTable
WHERE value in (1,2,3...1001); It would not have worked, because oracle only allows 1000 values in such a statement, but selecting values in another table is fine. You probably don't need to worry about this but it has caused issues for me in the past so I wanted to make sure to share it. Do you have multiple inspections in your inspection table for one manhole? From what I can tell it looks like you have duplicate ParentGUIDs in your related table - you'll need a way to only look at current or active ones. I do this in my tables with the "ACTIVE = 'YES'", that way old contact information (no longer 'active') isn't a factor.
... View more
05-17-2018
11:26 AM
|
3
|
11
|
2548
|
POST
|
Sure! I don't use the GP tool, but you could. More info here: Create Database View in ArcGIS Desktop I usually use the database management tools to prototype the view's SQL Script and then use ArcCatalog to create the actual view, however I've recently revisited this problem and changed my approach entirely. I have a feature class of addresses, and a related table of what is essentially contact information. The contact data in the related table are updated with 4 options from the web app front end: Contacted, Not Contacted, Attempted, and Other. To symbolize the address layer by what's in the related tables I added the address layer to my Table of Contents 4 times, and used separate definition queries for each one (renaming them to match the query used). The definition query is just the "WHERE" clause of a SQL expression, which means you can select from other tables in your Enterprise Geodatabase easily. for example my "Not Contacted" layer's definition query looks like this: EID in (SELECT EID from PS.CANVASS_FIRE_EVW where ACTIVE = 'Yes' and CONTACTED = 3) Our EID is a GUID, so you could use Esri's Global IDs for this as well (and that would be better, I'm just working with some real legacy data). What's happening here is I am selecting only the features in my address feature class with a unique identifier (EID) that is also in the related table (PS.CANVASS_FIRE), is ACTIVE, and has the CONTACTED status I am looking for (3 in this case is Not Contacted). This nicely gets around Oracle's 1,000 value limit for "in" statements as well by using the related table for the values. If your related table is versioned you need to use the versioned view (indicated with the _evw and created by SDE automatically when you version a table or feature class). This allows your symbology to be updated live as the data is updated, rather than after a compress.
... View more
05-17-2018
07:46 AM
|
4
|
14
|
9730
|
POST
|
Hello everyone, I am trying to replace an old VB Dockable Window add-in we've had around for a while before we upgrade to ArcGIS Desktop 10.5 and I am having some trouble. I've been working on it for a few days but have finally hit a brick wall (with my head... repeatedly). The tool basically has a dropdown menu of several layers that don't have to be in the map document and allows the user to search for, say, an address or quarter section grid number, and then zooms the user to that location. It's been around since long before my time here, and when I suggested using the built-in Find tool people didn't want to always have the layers in the map so it got shot down. I've accomplished replacing the adding with a Python Add-in partly, but I am running into some trouble - the old VB add-in was able to show options like a lookahead or autocomplete feature - i.e. type in 123 and it would pop the dropdown of the combobox down with a sorted list of the 10 most likely items you are looking to zoom to that start with 123. I have a search cursor that can get me the item array for that lookahead ability, however I cannot find how to get the combobox to dropdown with the code and when I set the combobox.items equal to the array and call the refresh() method to show the new items, it moves the typing cursor in the search combobox back to the beginning of the string. I have two questions I guess. 1) Can I automatically pop open the combobox's dropdown list when someone starts typing? 2) Does anybody know a way to either prevent the typing cursor from moving to the beginning of the combobox string within the refresh() or onEditChange methods or to maybe get the length of the string typed into the combo box and in the code, manually put the typing cursor there? Right now I'm doing this in the combobox onEditChange method: self.items = sorted(lookAheadItems[:10])
self.refresh() lookAheadItems is just an array populated with a search cursor any time there are more than 3 characters typed into the combobox. Every time it's triggered the cursor (not the search cursor, the insert text cursor) moves back to the beginning of the string. Can I prevent that somehow? Thank you!
... View more
06-02-2017
04:59 PM
|
1
|
1
|
837
|
POST
|
Here's our Dynamic Values table! We've been using it to replace some old production mapping 3rd party extensions and it's working beautifully. Doesn't quite do everything but we wrote some python tools for the rest and it all balanced out! Thanks for making a good Swiss army knife of data entry and data hygiene!
... View more
03-15-2016
03:57 PM
|
0
|
0
|
1578
|
POST
|
Has anyone had any luck using the Attribute Assistant to automatically update a M:N relationship class? I have a building and parcel layer that are joined with a simple M:N relationship class - I can have multiple buildings in one parcel, and a building can also be in more than one parcel (not sure why... just the IT guy haha). The problem is, I can't seem to get the Attribute Assistant to update the relationship class join table automatically when a new building is created or it's geometry is modified. It works for 1:M relationships where there's a primary and foreign key in the related tables themselves, but with many-to-many relationships, since it's using the intermediate table that is part of the relationship class, it has some trouble. I've experimented with Create Linked Records targeting the relationship class table with no success yet.
... View more
01-15-2016
04:00 PM
|
0
|
0
|
3254
|
POST
|
I ran into this problem recently - I created a view through ArcCatalog that joined my related table to my feature class, but with simplified attributes (not using all of them, this was just for visuals). I then published this view as a map service. Publish your Feature Service with the editable feature class and related table normally. Then add both to your map! Remove popups on the map service for the view, and your Collector edits will change the symbology! It does require you to move the map around a little though to get it to refresh, but if you are setup with Operations Dashboard, those updates show up within seconds.
... View more
12-24-2015
09:54 AM
|
11
|
16
|
9732
|
POST
|
Hi Christian, It looks like the version number in the Add-in Manager window is 6.26.2015. Is there reallya hotfix for it? Thanks, Jerry
... View more
11-25-2015
02:05 PM
|
0
|
1
|
461
|
POST
|
I am using the Attribute Assistant with ArcGIS for Desktop 10.2.2 to help with some workflows for our Data and Maps team. We have had some of the changes go very smoothly, but are encountering an error with a manual rule using the LINK_TABLE_ASSET method to snag a value from a table and bring it into the feature class. We get an error message in a ESRI.ArcGIS.Editor message box: Steps to reproduce: Make a geodatabase and copy the DynamicValue table to it with its domains Create a new point or polygon feature class and add an text field Create a new table and add a text field to copy from Create a rule in the DynamicValue table Table Name is the name of the point or polygon feature class Field Name is the field in that feature class you want the value from the table to be stored in Set Value Method to LINK_TABLE_ASSET Value infor should be [Table Name]|[Field Name] – referring to the table you are copying data from, and the specific field you want to copy from. Save everything Create a new point or polygon Open the table and select the line Click the Run Manual Rules button on the Attribute Assistant toolbar Say no when it asks if you want to run the rule on the selected features. Try to run it again. Even if you select a different feature, or clear the selecting and select a different feature, the error will appear. Workaround: It originally seemed impossible to get past the error without restarting ArcMap, however, you can clear the selection and run the manual rule again (it will say that nothing is selected), then select the features you need to link and run the manual rules again, it works. Has anyone seen this before? Is this an issue with our use of the rule, or the method itself? I think it’s a bug with the way selecting “No” is handled by the Attribute Assistant but I hate assuming that.
... View more
11-25-2015
01:09 PM
|
0
|
3
|
4625
|
Title | Kudos | Posted |
---|---|---|
4 | 05-17-2018 07:46 AM | |
3 | 05-17-2018 11:26 AM | |
1 | 06-02-2017 04:59 PM | |
11 | 12-24-2015 09:54 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|