Tag Info

Hot answers tagged

18

I am not aware of an ArcObjects way to get it, but you can enable the Size column in the Customize menu -> ArcCatalog Options -> Contents tab: This works on file geodatabases but not on SDE geodatabases (in that case you could use some DBMS-specific queries to determine it though). It does not work on personal geodatabases.


16

Give a look at this post on my blog: http://www.paolocorti.net/2008/06/06/spatial-database-for-postgres-and-arcgis-users-how-to-choose/ Basically you have 2 options: use PostGis with ArcSde (so you need an ArcSde license, and ArcEditor if you need to edit data) use zigGIS: http://www.obtusesoft.com/ (note that is not tested on ArcGis 10.0). You will just ...


13

Check out this function from by Bjorn Kuiper to test if a field exists : def FieldExist(featureclass, fieldname): fieldList = arcpy.ListFields(featureclass, fieldname) fieldCount = len(fieldList) if (fieldCount == 1): return True else: return False with the following example of use: if (not FieldExist(myFeatureClass, ...


11

It's been a while since this question was updated, so briefly ArcGIS 10.1 and ArcGIS 10.2 both natively support PostGreSQL and PostGIS data types. Included in the help for both versions is a walkthrough of gettting set up, and configuring tables to use the PostGIS geometry types.


11

you can use arcpy: import arcpy myField = "test" env.workspace = "D:/test/data.gdb" fcs = arcpy.ListFeatureClasses() for f in fcs: fieldList = arcpy.ListFields(f) for field in fieldList: if field.name == myField: print f Beside this you can use os.walk for files in your drive as: path = r"C:" for root, dirs, files in ...


10

If you are convenient with Python then writing script for this task is preferred. Take a look at these key things: Get a list of featureclasses/shapefiles in gdb/folder - ListFeatureClasses. In the bottom of this help article there is also an example "Copy shapefiles to a geodatabase" which you can use to start writing script. Check for existence of ...


10

I may be too late, but in case someone else comes across this forum for the same problem (as I did ;)). This is because you have to install the correct files for your client: http://resources.arcgis.com/en/help/main/10.1/index.html#/Setting_up_a_connection_to_PostgreSQL/002p0000003q000000/. It took me a while to figure this out as the ESRI online ...


8

I have a few posts on doing it with 9.3. The first is here and you can get to the rest of them from there: http://geobabble.wordpress.com/2008/05/28/using-arcsde-93-with-postgresql-part-1/ I've done it once with 10.0 and have had no issues. I will say that, when using PostgreSQL and PostGIS with ArcSDE, that I strongly recommend sticking to whatever ...


7

You are using the wrong option, you need to use the 'Database Connections' versus 'Database Servers' option. You can setup 'A Spatial Database Connection' from here.


7

public void Irow(ITable table, string nameOfFrstField , string nameofSecField) { int fieldFrstIndex = table.FindField(nameOfFrstField); int fieldSecIndex = table.FindField(nameofSecField); //insert row IRow row = table.CreateRow(); //initalize all of the default field values for the new row. ...


7

You need to finish the polygon's construction with double click, right-click>Finish Sketch or F2 before saving edits.


6

No. The closest you're going to get is with personal or workgroup SDE. Those editions let you create databases from ArcCatalog but you still need to run the post-install initially to set up a SQL Server Express instance. If you're using enterprise, you're stuck with the post install (or the command line tools :)).


6

For better performance, consider using IRowBuffer and an insert cursor with client-side buffering enabled (e.g. pass in true for the useBuffering parameter of the ITable.Insert method). See "Using insert cursors" in the Creating features help topic for more info.


6

I would use the ITable interface if it is a standalone table. List<int> OIDList = new List<int>(); ICursor pCursor = pTable.Search(null,False); while((pRow = pCursor.NextRow) != null)) { OIDList.Add(pRow.OID); }


5

I think you'll have to configure some major database pooling, so that your two servers appear as one. Then, connecting clients won't (and shouldn't) know which server they are actually connecting to, and you can tinker with the back ends as much as you like. Now, this is only an ideal solution if your backup is for availability - or if you want to take the ...


5

As for me I would recommend choosing python scripting for this task (arcpy). Here are some ideas: Use ListDatasets for getting all datasets. Use ListFeatureClasses for getting all featureclasses. Use SearchCursor for querying data. Take a look at Describe function - it also can be very usefull for some tasks. UPDATE: Have found after posting: @Aragon ...


5

Here is a model that looks like it duplicates the process you have listed above. There are a couple of things different than the procedure you have outlined above. Instead of using a while loop to increment through the features, there is a Feature Selection Iterator that loops directly over the features in a featureclass. What is nice about this iterator ...


5

You should try this, Add XY coordinates to your featureclass, then Dissolve on the X,Y fields. This should remove your stacked, duplicate features. You can then join the attributes from your source file. You may need to concatenate X,Y to form a single field for the join.


5

The free version of ET Geowizards will do this. Basic -> Sort shapes. I just tested it on a v10 File Geodatabase and it works. It has to create a new feature class though.


5

In answer to another question I said that it is possible to use Summary Statistics to do the equivalent of PULLITEMS (old speak for reorder fields). That technique works well on Tables only but there is another script available now that says it works on both feature classes and table. UPDATE I would also recommend the Answer to another Question which was ...


5

I'm not sure why you got no warning message. My machine prompts me with the typical Windows message of "Are you sure you want to delete this? Yes/No" if I use the delete key on anything. In fact if I delete a folder (not a geodatabase or any kind of individual file, feature class, etc.) using the key, it does send it to the Recycle Bin. I'm on 10.2 on Win 7 ...


4

Its under your user profile, AppData\Esri\ArcCatalog folder, it varies a little from 9.3.x and 10, but that should get you to the main location. Just look for the .sde files.


4

As mentioned in the comments you can reorder fields with ArcGIS Diagrammer. I posted a more general step by step in this answer: How to update the length property of a feature class field?


4

Attachments can be enabled only on feature classes stored within a geodatabase (this can be any type of geodatabase - personal, file, or enterprise). You cannot attach your files to a shapefile because there is no container the data can be stored in. To convert your shapefile to a geodatabase, you can use a GP tool Feature Class To Feature Class ...


4

you need to use this code within ArcMap and the field calculator. Add your feature class in the table of content, right click on it to open the table, right click on the name of the field and launch the field calculator. Then you check for codeblock and copy the code you mentioned. now for your code snippets, here is what I would do rec=0 def ...


4

Unfortunately, I think pulling out a backup is your only hope but you can also vote for an ArcGIS Idea entitled ArcCatalog Recycle Bin.


4

Sounds like the original model was developed in ArcMap. If you look at the syntax section of the help for the Select Layer By Attribute tool it explicitly states the data type of the input layer to be a feature layer or table view. If you are running your model from ArcCatalog and navigating to the dataset in the folder then you are accessing the source data ...


3

Here's a simple script that would run in same directory and check for and delete shapefiles... You can just run it from IDLE or ArcGIS python window or you could create a toolbox and add it as a script and add parameters. import arcpy, sys OutputFC = sys.path[0] + "\\downloaded1.shp" if arcpy.Exists(OutputFC): ...


3

Sorry to say your not going to find a quick way to do it as of SP2; primarily because Metadata is badly broken @ ArcGIS 10. I really would not expect that sample code you see to work cleanly, I suspect it might even damage the metadata. Your real only option is going to be to do it manually.We undertook a major metadata update project over the last 2 months ...


3

One way to automate the processing of this would be with Python by working through a list of the feature classes, and the using an updatecursor/deleteRow statement to delete the unneeded records. import arcpy workspace = r"c:\yourworkspace\yourgeodatabase.gdb" #assuming file geodatabase arcpy.env.workspace = workspace #Part 1 -- create list of feature ...



Only top voted, non community-wiki answers of a minimum length are eligible