Latest Contributions by TheoFaull

‎03-28-2017

Yes clicking select all does show the total number, however I'm still not able to browse the attribute table. I want to scroll down to the bottom. But the 'bottom' of the table is still record no.2000:

‎03-28-2017

FGDB. Thanks for the help Neil. I've gone for the method posted earlier now. Where I create a new dataset with a date tag added to the end of the feature class name. I just have to remember to resource the MXDs to this new layer after every update.

‎03-28-2017

I'm in ArcMap, viewing the attribute table for a point feature class... '0 out of *2000 Selected'... Why has it put this limit on the attribute table? There should be 25,000 ish records. On the map itself, 25,000 points do display/draw however. I do have a definition query but this should exclude around about 500 records only.. This issue only occurs with File Geodatabase feature classes. Sourced to a shapefile copy of the dataset, this issue doesn't happen. What's going on? Lot's of questions I've had recently! ArcGIS Desktop 10.4

‎03-28-2017

Is that 'Truncate Table' you use? And does your method work even if there's a LOCK file on the data?

‎03-28-2017

Hi. I have a script created in Python 2.7.10. It runs without issue on a machine with 2.7.10 installed: (spreadsheet>>>XY Event Layer>>>Feature Class) But on a machine with 2.6.5 installed, it errors. Why is this?: Is it because I'm trying to make an XY event layer from a sheet within an Excel spreadsheet, and I don't have Microsoft Office installed on this second machine (no licence)? Screenshot below shows the spreadsheet needed for the XY event layer, and it's showing up as an unassociated file type (no program found to open it). I didn't think Microsoft Office would be needed for Python to be able to extract a sheet. I've also experimented with making a CSV version of the file and pointing the script to use that, but the same error appears. Any thoughts most welcome!!!

‎03-27-2017

Of course. I haven't gone into details just yet and thoroughly appreciate Mitch's response. But anyway, there are 20 fields and 25,000 records. All the data in these records is subject to change, excluding a couple of ID fields. What I think I really need is to delete the existing shapefile, and replace with the updated version. However a LOCK file originating from the server (which accesses the shapefile) stops me from deleting this dataset. I need a script which: 1. Stop Server GIS service 2. Delete Points.shp 3. Create updated version of Points.shp in same directory with same name. 4. Start Server GIS service

‎03-27-2017

Bruce Harold‌ Yes it's the stopping service and starting service I can't figure out. We have ArcGIS Desktop 10.4 with Python 2.7.10 and ArcGIS for Server 10.0 with Python 2.6.5 on our seperate server machine (we host a lot of mapping data on this server including a web map interface which the whole company use. It's old but it works and we're reluctant to upgrade the software (no time to!))

‎03-27-2017

Yes true, but two duplicate records may not always be identical. The newer one may have updated information within it. So how could the script decide which record is the newer and updated record? Thus keeping it.

‎03-27-2017

Thanks Bruce but the data contains 1000s of records containing confidential tenant information. I doubt I'd be allowed to share In an ideal world, I just need a simple script that deletes the existing dataset and places the new, updated dataset in the same directory and with the same name. That way all the MXDs won't need to be re-sourced each time. The reason I can't do this method is because of an ever present LOCK file on the existing dataset (it's under constant access by our GIS server...). Maybe a script that says: 1. Stop Server GIS service 2. Delete Points.shp 3. Create updated version of Points.shp in same directory with same name. 4. Start Server GIS service

‎03-27-2017

Also when appending the new dataset to the original, I want the new dataset to take priority over the existing one. ie. if two records match, then old records are overwritten by the new ones.

‎03-27-2017

Dissolve won't work as it create a new dataset. It's crucial to me that the final dataset, is the existing one. (Lots of ArcMap MXDs link to that shapefile.)

‎03-27-2017

There are multiple seperate points that share the exact same coordinates. So dissolving based on that would combine points together that are infact independent of each other. There is a unique ID field however... I could dissolve the appended dataset based on that field?

‎03-27-2017

That's only available with an advanced license though. I only have Basic And yes most of the records are duplicates. Maybe there is away to only append records that are new...

‎03-27-2017

thank you very much! I would improvise if I knew how to. I'm still learning the ropes you see... cheers!

‎03-27-2017

I have two point shapefiles, both have the exact same fields in them. There are some new records AND some duplciate records when comparing the two datasets. I want to use the append tool as I don't want to create a new dataset, I just want to add data to the existing original shapefile. However, when I append the two shapefiles, matching records are appended, thus leaving lots of duplicate records. How can I tell my script to only append new records and ignore duplicates?

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by TheoFaull

Re: Attribute table not displaying all records...

Re: Appending- how to avoid duplicates?

Attribute table not displaying all records...

Re: Appending- how to avoid duplicates?

Python script works in 2.7 but not 2.6?

Re: Appending- how to avoid duplicates?

Re: Appending- how to avoid duplicates?

Re: Appending- how to avoid duplicates?

Re: Appending- how to avoid duplicates?

Re: Appending- how to avoid duplicates?

Re: Appending- how to avoid duplicates?

Re: Appending- how to avoid duplicates?

Re: Appending- how to avoid duplicates?

Re: Python help- changing output file name if name already exists

Appending- how to avoid duplicates?

Re: Appending- how to avoid duplicates?

Re: Appending- how to avoid duplicates?

How to make WebMap App URL private?

Re: Mosaic to new raster

Re: How to add a North arrow into the Print widget...