Latest Contributions by MKF62

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

Good call. Thanks for the tip about the CSVs too.  ... View more

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

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

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