topic Re: How to split the data for drawing number wise all features from mdb or gdb file? in Python Questions

How to split the data for drawing number wise all features from mdb or gdb file?

santhoshp — Sat, 02 Feb 2019 16:00:59 GMT

Hi Dear Friends,

How to split the data drawing number wise for all features from mdb or gdb file.

I have 8 types of drawing numbers available in data I want to split each drawing number separate data mdb format or gdb format file.

Thanks

Santhosh

Re: How to split the data for drawing number wise all features from mdb or gdb file?

DanPatterson_Retired — Mon, 04 Feb 2019 06:22:14 GMT

sounds like ...

Split By Attributes—Help | ArcGIS Desktop

Re: How to split the data for drawing number wise all features from mdb or gdb file?

santhoshp — Mon, 04 Feb 2019 15:38:55 GMT

Dear Dan Patterson,

yes It is working as a shape file but i nedd direct feature class it's possible or not if it's possible plz help me.

Thanks

Santhosh

Re: How to split the data for drawing number wise all features from mdb or gdb file?

DanPatterson_Retired — Mon, 04 Feb 2019 17:26:02 GMT

make the destination output a geodatabase, or easier still, use Copy Features to bring the shapefile into a gdb, then do the split

Re: How to split the data for drawing number wise all features from mdb or gdb file?

RandyBurton — Sun, 12 Dec 2021 03:19:27 GMT

When you say 'drawing number', are you referring to the DRAWING_REFERENCE field in your data? If so, I'm counting 10 different values.

111-111-AP
C0500-GS-0117-01-EL-FA-A0-03-001-001
C0500-GS-0117-01-EL-FA-A0-B1-001-001
C0500-GS-0117-04-EL-FA-A0-01-001-001
C0500-GS-0117-04-EL-FA-A0-02-001-001
C0500-GS-0117-04-EL-FA-A0-04-001-001
C0500-GS-0117-04-EL-FA-A0-05-001-001
C0500-GS-0117-04-EL-FA-A0-06-001-001
C0500-GS-0117-04-EL-FA-A0-B2-001-001
C0500-GS-0117-04-EL-FA-A0-GF-001-001
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

If this is not what you mean, could you explain 'drawing number'.

Re: How to split the data for drawing number wise all features from mdb or gdb file?

santhoshp — Tue, 05 Feb 2019 16:13:36 GMT

Dear Randy Burton,

In this gdb have DRAWING_REFERENCE field in that different drawing numbers available in gdb.

for example:

C0500-GS-0117-01-EL-FA-A0-03-001-001 this is the drawing number.

Thanks

Santhosh

Re: How to split the data for drawing number wise all features from mdb or gdb file?

RandyBurton — Tue, 05 Feb 2019 17:34:55 GMT

And your version of ArcGIS? 10.5 or 10.6 or Pro ? Looks like Split By Attributes requires one of these versions.

Re: How to split the data for drawing number wise all features from mdb or gdb file?

RandyBurton — Sun, 12 Dec 2021 03:19:30 GMT

The following code will split your features based on DRAWING_REFERENCE and place them in a geodatabase named with the feature class. From here you should be able to copy them into the desired structure with additional scripting. It does appear that domains and subtypes are preserved. I could not get SplitAttributes to create the features inside a dataset, but it might output to shape files.

import arcpy
import os

gdb = r'C:\path\to\folder\COBW_Firealarm\COBW_Firealarm.gdb'
arcpy.env.workspace = gdb
out_folder =  r'C:\path\to\folder\COBW_Firealarm' # geodatabases go here

fields = ['DRAWING_REFERENCE']

for fds in arcpy.ListDatasets('','Feature'):
    print "Processing {}".format(fds)
    sr = arcpy.Describe(fds).SpatialReference
    for fc in arcpy.ListFeatureClasses('','',fds):
        print "\t{}".format(fc) # use fc for name of target geodatabase
        arcpy.CreateFileGDB_management(out_folder, '{}.gdb'.format(fc))
        in_fc = os.path.join(gdb,fds,fc)
        target = os.path.join(out_folder,'{}.gdb'.format(fc))
        # print in_fc
        # print target
        # save split in file geodatabase with name of original feature class
        arcpy.SplitByAttributes_analysis(in_fc, target, fields)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Here's what the output looked like:

Hope this helps.

Re: How to split the data for drawing number wise all features from mdb or gdb file?

santhoshp — Wed, 06 Feb 2019 11:45:51 GMT

Dear Randy Burton,

I am getting error can you give me the solution for this error. I am using ArcGIS 10.1

Attached below image for your reference.

Error Below Code

Processing HVAC
HVAC_Fan

Traceback (most recent call last):
File "C:\path\to\folder\COBW_Firealarm\split drawing.py", line 15, in <module>
arcpy.CreateFileGDB_management(out_folder, '{}.gdb'.format(fc))
File "C:\Program Files\ArcGIS\Desktop10.1\arcpy\arcpy\management.py", line 14458, in CreateFileGDB
raise e
ExecuteError: ERROR 000258: Output C:\path\to\folder\COBW_Firealarm\HVAC_Fan.gdb already exists
Failed to execute (CreateFileGDB).

Thanks

Santhosh

Re: How to split the data for drawing number wise all features from mdb or gdb file?

DanPatterson_Retired — Wed, 06 Feb 2019 11:53:12 GMT

check the folder in the error message... the geodatabase already exists and you can't overwrite it.

Re: How to split the data for drawing number wise all features from mdb or gdb file?

RandyBurton — Sun, 12 Dec 2021 03:19:33 GMT

I am assuming that the picture in my last post is generally what you are looking for.

As Dan Patterson‌ mentioned, since the database exists you can't overwrite it. You can delete it with code or just use it. A line of code could be added to check for the existence of the database.

As seen in your attached jpeg, you are getting a second error:

object has no attribute 'SplitByAttributes_analysis'

Split By Attributes was added at version 10.5 and Pro. Since you are at 10.1, we will need a different solution. I would suggest looping through your datasets and features and using Select Layer By Attribute with a where clause, something like:

arcpy.SelectLayerByAttribute_management('FA_Box', 'NEW_SELECTION', 
     where_clause = "DRAWING_REFERENCE = 'C0500-GS-0117-01-EL-FA-A0-03-001-001'")‍‍‍‍‍‍‍‍‍‍

If records are selected, then copy them to the appropriate database. Hope this helps.

Re: How to split the data for drawing number wise all features from mdb or gdb file?

DanPatterson_Retired — Wed, 06 Feb 2019 19:46:47 GMT

10.1?! missed that

https://www.arcgis.com/home/item.html?id=15ca63aebb4647a4b07bc94f3d051da5

the original split by attribute... can't remember if it works on that old a version.

but it has the coolest page icon, if I may say so

Re: How to split the data for drawing number wise all features from mdb or gdb file?

RandyBurton — Sun, 12 Dec 2021 03:19:36 GMT

Since you are using 10.1, I experimented with SelectLayerByAttributes. I found it easiest to code to work with one geodatabase (the one in your zip file). I first ran a script to get a list of the unique attributes used in the DRAWING_REFERENCE fields of all the features in the gdb. Since the drawing reference is rather long, I paired it with a shorter substring. This is what the gdb looks like in catalog:

Each feature is appended with the short substring; in this case, GF is highlighted. Here's the code:

import arcpy
import os

gdb = r'C:\Path\to\COBW_Firealarm.gdb'
arcpy.env.workspace = gdb # needed for ListDatasets

fields = ['DRAWING_REFERENCE']

draw_ref = [ # unique values in DRAWING_REFERENCE fields, name append value
    [ '111-111-AP','AP' ],
    [ 'C0500-GS-0117-04-EL-FA-A0-01-001-001', '01' ],
    [ 'C0500-GS-0117-04-EL-FA-A0-02-001-001', '02' ],
    [ 'C0500-GS-0117-01-EL-FA-A0-03-001-001', '03' ],
    [ 'C0500-GS-0117-04-EL-FA-A0-04-001-001', '04' ],
    [ 'C0500-GS-0117-04-EL-FA-A0-05-001-001', '05' ],
    [ 'C0500-GS-0117-04-EL-FA-A0-06-001-001', '06' ],
    [ 'C0500-GS-0117-01-EL-FA-A0-B1-001-001', 'B1' ],
    [ 'C0500-GS-0117-04-EL-FA-A0-B2-001-001', 'B2' ],
    [ 'C0500-GS-0117-04-EL-FA-A0-GF-001-001', 'GF' ]
    ] # name append keeps feature name from becoming too long


for fds in arcpy.ListDatasets('','Feature'):

    print "\nProcessing {}".format(fds)

    for fc in arcpy.ListFeatureClasses('','',fds):
        print "\t{}".format(fc) # use fc for name of target geodatabase
        in_fc = os.path.join(gdb,fds,fc)
        if arcpy.Exists('temp_layer'):
            arcpy.Delete_management('temp_layer')
        arcpy.MakeFeatureLayer_management(in_fc,'temp_layer')
        ref_num = 0
        
        for dr in draw_ref: # loop through drawing reference list
            # dr[0] = DRAWING_REFERENCE field value
            # dr[1] = a substring of DRAWING_REFERENCE used in naming new feature class
            arcpy.SelectLayerByAttribute_management('temp_layer',
                                                    'NEW_SELECTION',
                                                    where_clause = "DRAWING_REFERENCE = '{}'".format(dr[0]))
            count = int(arcpy.GetCount_management('temp_layer').getOutput(0))

            if count > 0:
                ref_num += 1
                new_fc = os.path.join(fds, "{}_{}".format(fc,dr[1]))
                print "\t\t{}  -- count: {}".format(new_fc,count)
                # write the selected features to a new featureclass
                arcpy.CopyFeatures_management('temp_layer', new_fc)

        print "\t\t{} total new features".format(ref_num)

arcpy.Delete_management('temp_layer')
print "\nDone."‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

For the next steps, you can use a script to loop through the draw_ref list, making a copy the first gdb, deleting the features that don't match the current value in the draw_ref list, and repeat until each drawing reference has its own gdb.

Hope this helps.

Re: How to split the data for drawing number wise all features from mdb or gdb file?

santhoshp — Sun, 10 Feb 2019 11:55:40 GMT

Dear Randy Burton,

I really appreciate you for helpling thank you somuch.

Thanks

santhosh