sr = arcpy.SpatialReference(4326)
# Code to work with desktop
#mxd = arcpy.mapping.MapDocument('CURRENT')
#df = arcpy.mapping.ListDataFrames(mxd)[0]
#mxd.activeView = df.name
env.overwriteOutput = True
# input params
devices = arcpy.GetParameterAsText(3)
combine = arcpy.GetParameterAsText(4)
minDate = arcpy.GetParameterAsText(5)
#devices = "{'04175': '792', '00827': '786'}"
conn = dbutil.getDbConn(db='wtg_gdb')
try:
# ArcTool validation code returns a string of a dict
# eval() converts to actual dict
devDict = eval(devices)
tagList = tuple([int(v) for v in devDict.values()])
if minDate:
startDate = datetime.strptime(minDate, '%m/%d/%Y')
if combine == 'true':
sqlSelect = "SELECT * FROM geodata.v_select_points \
WHERE tag_id IN {0} \
AND feature_type <> 'sample' \
AND timevalue > '{1}'".format(tagList, startDate)
layerName = 'q_tags'
import csv
import datetime
from os import path
# local modules
import dev_tables as tables
import wtg_utils as util
import dev_db_utils as dbutil
# constants
INPATH = path.abspath('\\\\MMIDATA\\Public\\Data')
conn = dbutil.getDbConn('wtg_gdb')
#----------------------------------------------------------------------------
def format_date(str_date, bd):
# '%Y/%m/%d %H:%M:%S' RAW Argos date.csv format
# '%m/%d/%Y %H:%M:%S' DB extract Argos.csv
if bd: # format of incoming string
timevalue = datetime.datetime.strptime(str_date,
"%d/%m/%y %H:%M:%S") #dd/mm/yy
else:
timevalue = datetime.datetime.strptime(str_date, '%m/%d/%Y %H:%M:%S')
return timevalue
#----------------------------------------------------------------------------
#out_csv = arcpy.GetParameterAsText(1)
in_track = 'C:\\CurrentProjects\\Hump18HI\\GIS\\Humps All 2018 Filter.gdb\\tr_1999HI_14'
out_csv = 'C:\\CurrentProjects\\Hump18HI\\GIS\\TestSummary.csv'
# Workspace ************* MAKE ME A UTIL! **************
homeDir = path.dirname(in_track) # GDB FC input
if not homeDir:
workspace = env.workspace # Map Layer input
# strip gdb from homeDir
homeDir = path.dirname(workspace)
out_path = path.join(homeDir, out_csv)
# global
sr = arcpy.SpatialReference(4326)
conn = dbutil.getDbConn(db='mmi_wtg')
con2 = dbutil.getDbConn(db='wtg_gdb')
fmt = '%m/%d/%Y %H:%M:%S'
try:
# prepare CSV
with open(out_path, 'ab') as outFile:
writer = csv.writer(outFile)
writer.writerow(
['Species', 'PTT', 'Sex', 'Tag Type', 'Filter Days', 'Distance'])
# ********* Tool only! Clear selections **********************************
# arcpy.SelectLayerByAttribute_management(in_track,'CLEAR_SELECTION')
# **************************************************************************
