EIDT: a little grammar
Hi Thanks for responding.
When I came aboard my company there were some pre-existing SDE databases. I'm not sure how these were created. When I right click on an SDE database and go to the Administration Tab, I am getting my size measurements there. In this particular case, I have 825 MB of data for over 100 different feature classes comsprised of tens of thousands of features. This SDE database was created in 10.3. In looking at some of the feature datasets the geoprocessing history tells me that much of the data was brought in using the Feature Class to Geodatabase tool in the Conversion.tbx. The data in here contains, census tracks, municipal parcels, annotation layers, sewer and water infrastructure and some iterative analysis results among the feaure classes covering at least 4 or 5 towns in Massachusetts. There are points, lines, polygons, tables etc.
![Administration tab of an SDE database with tens of thoudsands of features](/legacyfs/online/451310_Interstate_SDE.png)
After I came aboard we upgraded from ArcServer 10.5 (workgroup) to ArcGIS Enterprise 10.6 using the same SQLServer express instances and same machines.
To illustrate my specs I'll outline the steps I took to demonstrate my problem to Esri Support.
In my workflow I'm in ArcCatalog 10.6.1. I have an Advanced license. I expand the Database Servers icon. Under my arcserver_sqlexpress.gds I right click and select "New Geodatabase". I name it "Test_Support3" I right clicked on the name of the database an imported a feature class of contour lines. These are 5 foot intervals covering a town that's 15 sq miles, highest elevation is 400 ft, When they are in a file geodatabase the size (in Catalog) is listed as 72.92 MB. There are 7 fields in the attribute table: Object ID, a text field (254 characters), 2 doubles, a long integer, a short integer and a geometry (polyline).
I brought this same data in a second by opening ArcGIS Pro, loading the same source feature class into a new map and using the right-click menu on feature class in the table of content to export to a geodatabase.
My third feature class is a polygon feature class of my state's town boundaries with about 10-15 fields in the attribute table. In a file geodatabase this is 412 kb . In ArcCatalog, I right clicked on Test_Suppport3 and made new, empty feature class using the schema of the data I wanted to load, and then I loaded the data. Now I have 3 feature classes in Test_Support3. When I look at the Administration properties it says this is 691 MB.
![Large database with 3 feature classes](/legacyfs/online/451311_Test_Support3.png)
This database has never been edited or versioned. I did try removing the geoprocessing history but it had no impact. For the sake of accuracy I just ran a compression to no avail:
![Compressing didn]()
If you have any suggestion I would very much welcome them! Thank you for the assistance!