|
POST
|
I apologize in advance for what are probably dumb questions/interpretations, but I am not a DBA of any sort and (extremely unfortunately) am wildly out of my realm of expertise on this project. I'm the only person they have that has any resemblance of database knowledge, thus I've been tasked with this migration project (hurray...). So, all that said, I would still like to try to understand what you're describing if you don't mind explaining further. I'm going to start at the "ORDER BY" part of your post first; are you saying that you're reordering/restructuring the fields of your feature class before you export to the FGDB for optimization purposes? Then, if you back up to the first part of your post about the spatial index optimization, it sounds like you use the SQL you have to recreate an empty table in the PG database, but you're reordering fields(?) again to create a more efficient spatial index (and potentially match the adjustments made when you exported data to your FGDB). After doing that, you register the table with the geodatabase and load your data into the empty table from the now-optimized data you exported to the FGDB. Am I way off (I am assuming I am)?
... View more
03-15-2021
07:37 PM
|
0
|
2
|
6115
|
|
POST
|
Thanks - I forgot to put the most important part of this all in my post (will edit), but I will not have access to our old server during migration. Unfortunately, all I'll have to work with is the backups I take with me (.bak files from MSSQL and the stuff I'm porting to fgdb/csv). I guess maybe once I mint the new PostgreSQL database as a enterprise geodatabase, then I just copy/paste layers over from my FGDB. That might be the only way to do it, I guess.
... View more
03-15-2021
10:46 AM
|
0
|
3
|
6153
|
|
POST
|
My organization who piggybacks off software from our umbrella organization may be moving to a new umbrella organization. They use PostgreSQL while we are currently using MSSQL. Unfortunately, I will no longer have access to the database server once we move, thus my "migration" is really more like a restore operation. I'll have .bak files from MSSQL and I've also placed our data in FGDB and CSV files for preservation. I'm looking for strategies to successfully migrate our databases without doing a massive rebuild from scratch. Has anyone done this; is this possible? Any advice?
... View more
03-15-2021
10:28 AM
|
0
|
9
|
6186
|
|
POST
|
Whoops, I should have updated this! I realize you said you were using this script before and it just stopped working so my answer may not apply, but I found out for my purpose I was using the wrong tool altogether. I was trying to use the export function instead of the extract data function. When I used the extract data function instead, it worked how I wanted it too. If I recall right, if I have an Administrator role in my organization (not just a group manager/owner), I could extract anybody’s data in the group as long as the user was part of our organization. If the user is outside the organization, you will be unable to extract their data. To me the documentation is rather unclear about how export and extract data differ. From what I can gather in the documentation, it sounds like export is for exporting an entire service and extract data is for querying and exporting only certain features (or all the features if you so choose). If you find that export is what you need, you need to be the owner of the service (which you said works), but you need have an Administrator role in your organization to export anything owned by anyone else in the group, not just the owner/manager of the group, as per the documentation. If you're trying to export a service that's owned by a group member that is not within your organization, you will be unable to do so, just like the extract data tool.
... View more
02-23-2021
03:08 PM
|
0
|
0
|
2414
|
|
POST
|
Found out it's saving a service draft anyway despite getting no option to save. Service drafts are located here: C:\Users\<user name>\AppData\Local\ESRI\Desktop<version number>\Staging
... View more
02-01-2021
10:20 AM
|
1
|
0
|
1028
|
|
POST
|
I'm trying to save a service draft to fix another issue, but when I close the Service Editor it does not prompt me with the option to save a draft like it should. As far as I can tell, there is no other way to save a service draft and that's problematic. I'm on ArcMap 10.7. Current workflow I'm following: 1) Run script tool, process succeeds 2) Share as geoprocessing service 3) Overwrite existing service 4) Service Editor opens > Analyze 5) Errors appear. Click the "x" on the service editor window to exit Here is where no prompt to save the service draft appears. Is there somewhere I can find the service draft in windows explorer?
... View more
02-01-2021
10:16 AM
|
0
|
1
|
1032
|
|
POST
|
Okay, I think I understand now. Feature templates can be edited locally, published to server, and then used with Smart Forms. You just can't edit the template online unless it's hosted. On another note, I can build a form, but the problem is that it requires me to add the fields Shape.STArea() and Shape.STLength(). It makes them a required field, but it also makes them uneditable (Allow mobile users to edit checkbox is unable to be checked) and it doesn't automatically calculate so I am unable to submit features on the mobile app if they're on my form. I wonder if I made actual feature templates it would go away.
... View more
01-13-2021
10:52 AM
|
0
|
5
|
8259
|
|
POST
|
I'm trying to convert my popups used in Collector to Smart Forms. To do this I opened the Field Maps web app with my map and then hit the convert button. This worked out, but I get a message at the top that says I do not have permission to edit the templates and that they are read only: If I use the collector-like popups in Field Maps, all the fields are editable, but after conversion on the FM web app, it says it's read only. If I click on the "templates" shown above, as expected they are not editable. I'm trying to understand why that would be. The templates shown are not true feature templates and I'm wondering if that's the issue. When this feature class was created, I used subtypes and domains to control what attributes can be entered, I never specifically created feature templates. Other things of note: These are not hosted feature layers, they are coming from our Server (Enterprise 10.7) I have an administrator account and that account owns this web map
... View more
01-13-2021
08:07 AM
|
0
|
7
|
8271
|
|
POST
|
I kind of understand why Collector populates a 0 in numeric fields when null values are disallowed, but I have 15 fields to fill out in Collector and backspacing the 0 away for everyone before entering my value is very very annoying. Is there a way to get it to just start out as blank and have the field be required? I've noticed the fields that are text and required can still be submitted as blank (on iphones at least) because they are populated as "" strings which also defeats the purpose of being required. It's pretty frustrating.
... View more
01-12-2021
10:01 AM
|
1
|
0
|
733
|
|
POST
|
Wish I could delete questions on the new Geonet but I can't, so I'll just post my "answer" (e.g. my stupidity) anyway. I think I was confusing "Web Layer" with "Feature Layer" (aka feature service) maybe? I'm still not clear on if it's a terminology difference or they are actually two different things. Regardless, I was trying to overwrite a feature service because when you publish a map service, the feature service gets published up too - the web layer and feature layer icons for AGOL look very similar so I was getting caught up in that in the Catalog > Portal > My Content pane. What I should have been doing was overwriting the map service. To do this I went to the Catalog Pane, expanded my server down to the map service I wanted to overwrite and then right-clicked it and hit "Overwrite."
... View more
12-17-2020
11:12 AM
|
0
|
0
|
2493
|
|
POST
|
I'm working in Pro and I am trying to overwrite a web layer that currently exists on my AGOL account. It is hosted by our server and is not hosted by AGOL. I am logged into my account when in Pro and if I go to Catalog > Portal > My Content, all my map and feature services appear here. The layer I want to overwrite is included in this window, however when I go to Share > Overwrite Web Layer and the new dialog window appears, it shows nothing in My Content. How do you fix this? To better illustrate what I'm saying, this is my Catalog pane: This is the dialog box when I try to overwrite a web layer:
... View more
12-17-2020
09:45 AM
|
0
|
1
|
2509
|
|
POST
|
Yes, that's true. I can manage it all on the server side, was just wondering if there was a way to do it on the Pro side of things. There isn't based on this text I found: Starting with ArcGIS Enterprise 10.8.1, new data stores are viewed, created, and managed as items in your portal content. It is possible to add and manage data stores without creating portal items if you use ArcGIS Server Manager, but it is not possible from ArcGIS Pro. https://pro.arcgis.com/en/pro-app/latest/help/sharing/overview/manage-registered-data-stores.htm If I'm understanding what this says correctly, because we don't use portal, we now can only manage our database registrations from Server Manager.
... View more
12-17-2020
09:39 AM
|
0
|
0
|
2132
|
|
POST
|
This seems like there should be an obvious answer, but I can't find a way to view registered database connections and folders like the Server Properties dialog box of ArcMap: Documentation states something about going to Share > Manage > Data Stores, but our server is not federated and we do not have Data Store installed. Just the ArcGIS Enterprise Server is installed (we do not use a portal). Where do I go to view these connections and validate them?
... View more
12-16-2020
06:22 AM
|
0
|
2
|
2162
|
|
POST
|
I'm trying to figure out why I can't export data from my group. According to export tool documentation, you either need to own the service or be an administrator; I am an administrator for our organization (role = org_admin when I print it in python): https://developers.arcgis.com/python/api-reference/arcgis.gis.toc.html#arcgis.gis.Item.export What am I misunderstanding here? When I run this code, I get an error that says "You do not have permissions to access this resource or perform this operation" gis = GIS("https://www.arcgis.com", username="xxx", password="xxx")
myRole = gis.users.me.role #org_admin
gID = gis.groups.search('title: "NBCI Maps"')[0].id
grp = Group(gis, gID)
content = grp.content()
for item in content:
if "Markup" in item.title:
markup = item
hm = markup.export('test', 'File Geodatabase') The user who has published a markup layer (feature collection) to the group is also a member of our organization. If I go on arcgis online on desktop and log in with my administrator account, I have the capability via the "Analysis > Manage Data > Export Data" function in the web map to export the same data I'm trying to access with python (owned by a different user). There should be no reason I can't do it in Python from what I can tell. Would love some insight on this.
... View more
11-18-2020
12:13 PM
|
1
|
3
|
2525
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 06-18-2020 10:31 AM | |
| 2 | 09-16-2025 02:17 PM | |
| 3 | 09-12-2025 09:26 AM | |
| 1 | 08-16-2023 05:11 PM | |
| 1 | 02-27-2024 06:48 AM |
| Online Status |
Offline
|
| Date Last Visited |
09-16-2025
02:16 PM
|