Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About KellyArmstrong
KellyArmstrong
Occasional Contributor II
since
02-04-2015
12-07-2023
123
Posts created
125
Kudos given
1
Solutions
142
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(4 Idea Submissions)Latest Contributions by KellyArmstrong
|
POST
|
Thank you for that tip. I have decided to create an UPDATE query in pgAdmin instead of creating a query table.
... View more
06-14-2021
07:08 AM
|
0
|
0
|
1118
|
|
POST
|
Is there a way to assign which tab is selected when "Show Related Records" is chosen? I have two related tables, but the one that opens up by default isn't the one I want to open by default. I have attached a screenshot of what I am describing:
... View more
06-14-2021
07:07 AM
|
0
|
0
|
337
|
|
POST
|
I got it to work. This is what I did in pgAdmin: CREATE OR REPLACE VIEW v_flare_ends_global AS SELECT DISTINCT tbl_flare_ends.globalid, tbl_media_2.media_table, tbl_media_2.media_name, tbl_media_2.media_date_added, tbl_media_2.media_path, tbl_media_2.media_table_id FROM tbl_flare_ends JOIN tbl_media_2 ON tbl_flare_ends.originaloid = tbl_media_2.media_table_id_integer WHERE tbl_media_2.media_table::text = 'tbl_flare_ends'::text; ALTER TABLE v_flare_ends_global OWNER TO sde; GRANT ALL ON TABLE v_flare_ends_global TO sde;
... View more
06-10-2021
03:33 PM
|
0
|
2
|
1143
|
|
POST
|
Vince, I am guessing a query table might be the best solution? Something like this? SELECT sde.sde.tbl_flare_ends.globalid FROM sde.sde.tbl_flare_ends INNER JOIN sde.sde.tbl_media2 ON sde.sde.tbl_flare_ends.originaloid = sde.sde.tbl_media2.media_table_id_integer WHERE media_table = 'tbl_flare_ends'
... View more
06-10-2021
02:40 PM
|
0
|
0
|
1143
|
|
POST
|
Vince, Yes, I apologize. I should have stated I want to obtain Globalid's and copy them to another table as GUID's. Both are in a single Enterprise geodatabase. The table I am looking to populate the GUID field with the globalid's has 55,000 rows... I have tried creating a query table, but that failed. I have also tried utilizing joins, but when joining the GlobalID field doesn"t come along...
... View more
06-10-2021
01:39 PM
|
0
|
0
|
1145
|
|
POST
|
In our old mapping system, all images and attachments were saved to a folder on our web server. The table was populated with the url. Would I be able to accomplish this workflow with Integromat and Survey123?
... View more
06-10-2021
09:38 AM
|
1
|
2
|
523
|
|
POST
|
I have a standalone table that has an id field named "media_table_id". I also have a feature class that has an id field with those same values and it has a globalid field. I would like to be able to populate my standalone table with the globalid's from the feature class, where the id's match and contains 'tbl_flare_ends" from the layername field in the standalone table. Would I need to write an sql to do this? Something like: standalone.media_table_id = feature_class.id_field WHERE standalone.layername = 'tbl_flare_ends' ? Or would I have to do some type of join to populate globalid values that match the criteria?
... View more
06-09-2021
09:11 AM
|
0
|
1
|
771
|
|
POST
|
I have a standalone table that has an id field named "media_table_id". I also have a feature class that has an id field with those same values and it has a globalid field. I would like to be able to populate my standalone table with the globalid's from the feature class, where the id's match and contains 'tbl_flare_ends" from the layername field in the standalone table. Would I need to write an sql to do this? Something like: standalone.media_table_id = feature_class.id_field WHERE standalone.layername = 'tbl_flare_ends' ? Or would I have to do some type of join to populate globalid values that match the criteria?
... View more
06-09-2021
09:05 AM
|
0
|
6
|
1170
|
|
POST
|
Thanks Dan. When joining, it does not bring the globalid field with, so I am not able to calculate a new field with those values...
... View more
06-09-2021
07:12 AM
|
0
|
0
|
630
|
|
POST
|
Dan, Even if the stand-alone table / related table has multiple entries with the same objectid?
... View more
06-08-2021
03:52 PM
|
0
|
2
|
663
|
|
POST
|
I have a standalone table that has an id field named "media_table_id". I also have a feature class that has an id field with those same values and it has a globalid field. I would like to be able to populate my standalone table with the globalid's from the feature class, where the id's match and contains 'tbl_flare_ends" from the layername field in the standalone table. Would I need to write an sql to do this? Something like: standalone.media_table_id = feature_class.id_field WHERE standalone.layername = 'tbl_flare_ends' ? Or would I have to do some type of join to populate globalid values that match the criteria?
... View more
06-08-2021
03:01 PM
|
0
|
4
|
708
|
|
IDEA
|
Why not just use Collector to move the current point, then click on a link you create to open the survey and then capture that data?
... View more
05-13-2021
01:44 PM
|
0
|
0
|
638
|
|
POST
|
@ZacharySutherby , It doesn't, but that is because I am dealing with a related table, and its ID is 1. In the form_id column, I have the related table name.
... View more
05-11-2021
02:20 PM
|
0
|
2
|
2197
|
|
POST
|
I am having the same issue. I get: "The custom feature service submission url is not compatible with this survey (Parent layer id 0 not found for table 'table_name')"
... View more
05-11-2021
08:12 AM
|
0
|
4
|
2203
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 03-31-2021 02:14 PM | |
| 2 | 12-08-2021 09:45 AM | |
| 1 | 07-30-2021 09:32 AM | |
| 1 | 04-23-2021 08:10 AM | |
| 1 | 09-30-2021 06:50 AM |
Activity Feed
- Got a Kudo for Append Field Mapping - Can you enter values to populate field?. a week ago
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 03-25-2024 03:35 AM
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 02-02-2024 01:34 AM
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 01-29-2024 09:30 AM
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 01-17-2024 09:55 AM
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 01-04-2024 12:33 PM
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 12-18-2023 09:40 AM
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 12-07-2023 12:54 PM
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 11-21-2023 11:36 AM
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 10-27-2023 04:12 PM
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 10-11-2023 08:58 PM
- Kudoed Re: URL link from related table in popup? for Blevins_Mark. 10-05-2023 01:34 PM
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 08-23-2023 07:59 AM
- Got a Kudo for Field Maps: Enter Inspection/Maintenance/Service to All or Multiple Selected Features (Hydrants)? NOT Just One at a Time.... 08-23-2023 07:55 AM
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 08-17-2023 01:00 PM
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 08-16-2023 10:21 PM
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 08-07-2023 01:10 PM
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 08-07-2023 01:10 PM
- Got a Kudo for Add Related/Maintenance Record to All Selected Features. 08-07-2023 01:09 PM
- Got a Kudo for Re: How do you remove thousand comma separators on ArcGIS web map labels and tables?. 05-30-2023 12:15 PM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
12-07-2023
01:19 PM
|