Populate feature class via SQL

Question

Afternoon everyone!  Just wanting to check and see how others are doing this.  I have a sql statement that joins multiple tables that I would like to use to populate data into a non versioned point feature class.  What would be my best method to load the data?  It would be super nice if I could automate this sql to populate the data on a schedule as well.   Any information will be greatly appreciated!  Thanks!

DrewSwayne · Answer

I am currently doing different types of geoprocessing tasks via Transact-SQL in a SQL Server Database using the geometry methods provided here: geometry Data Type Method Reference . A lot of what I am doing occurs using triggers in the database, so when a feature is inserted in a particular feature class via a web service provided through a web app, a trigger then fires to create and insert data in other feature classes to produce on the fly analysis. You definitely have to be careful with ObjectIDs. I don't believe this is necessarily best-practice, but it is currently working without issue, and it's fun!

JasonPlummer · Answer

Andrew!  Whats up man!?!?  How have things been going?  I have a sql statement that pretty much pulls all the information i need, just would like to be able to run that in python to populate a feature class.   I started to look at some cursors and python, but just wanted to make sure i was doing it the best/recommended way?  Any suggestions?  I can give you my personal email.  Thanks man!  Tell everyone i said hey!

AndrewKeith3 · Answer

Jason, whats up, long time, no see?  I think you could accomplish this easily by using python and Task Scheduler.  If you already have the view built in the geodatabase (make sure it includes the SHAPE), you could just call arcpy.CopyFeatures_management (in_features, out_feature_class, {config_keyword}, {spatial_grid_1}, {spatial_grid_2}, {spatial_grid_3}).  I would need more details on your workflow to provide more specifics and clarity if this would be the best approach or not.