Latest Contributions by IreneEgbulefu1

I built a model that extracts selected attributes from my TCAD feature layer using a polygon feature. I am looking for a way to convert this model to a functional tool through python scripting. The requirement is that when the tool is run, it will prompt the user to enter the polygon feature (any polygon feature that is within the TCAD coverage); the tool will also  prompt the user to select the needed attributes from the TCAD layer feature. So far my model is pretty much functioning manually but I would really want it to be more automated. I have tried to export my model to a python script and tried modifying it but so far there has been no success, thus I am here to seek for help with this. Please see my model and script below and I would really appreciate if I can get help with this here. Here is the script # -*- coding: utf-8 -*- # --------------------------------------------------------------------------- # Extracting Property_IMprvtment_Values_By_ContourPoly.py # Created on: 2018-11-01 14:54:20.00000 # Description: This script will extract selected atrributes from TCAD for any given polygon (in this case I am using a Contour Polygon) # that is used to intersect the TCAD # ------------------------ # Import arcpy module import arcpy import sys import os import datetime import traceback # Database Connection editDB ="C:\Users\EgbuleI\AppData\Roaming\ESRI\Desktop10.5\ArcCatalog\TCAD.sde\TCAD.TC_USER.TCAD_PARCELS" # Local variables: TCAD_TC_USER_TCAD_PARCELS__3_ = "TCAD.TC_USER.TCAD_PARCELS" TCAD_TC_USER_TCAD_PARCELS = TCAD_TC_USER_TCAD_PARCELS__3_ Parcels_on_710f = "C:\\Users\\egbulei\\Documents\\ArcGIS\\Default.gdb\\Parcels_on_710f" Documents__2_ = "C:\\Users\\egbulei\\Documents" Contour710ft_data2_dbf = "C:\\Users\\egbulei\\Documents\\Contour710ft data2.dbf" # Process: Select Layer By Location arcpy.SelectLayerByLocation_management(TCAD_TC_USER_TCAD_PARCELS__3_, "INTERSECT", Parcels_on_710f, "", "NEW_SELECTION", "NOT_INVERT") # Process: Table to Table arcpy.TableToTable_conversion(TCAD_TC_USER_TCAD_PARCELS, Documents__2_, "Contour710ft data2.dbf", "imprv_homesite_val IS NOT NULL AND imprv_homesite_val >0", "PROP_ID \"PROP_ID\" true true false 4 Long 0 10 ,First,#,Database Connections\\TCAD.sde\\TCAD.TC_USER.TCAD_PARCELS,PROP_ID,-1,-1;py_owner_n \"py_owner_name\" true true false 70 Text 0 0 ,First,#,Database Connections\\TCAD.sde\\TCAD.TC_USER.TCAD_PARCELS,py_owner_name,-1,-1;py_owner_i \"py_owner_id\" true true false 4 Long 0 10 ,First,#,Database Connections\\TCAD.sde\\TCAD.TC_USER.TCAD_PARCELS,py_owner_id,-1,-1;py_address \"py_address\" true true false 100 Text 0 0 ,First,#,Database Connections\\TCAD.sde\\TCAD.TC_USER.TCAD_PARCELS,py_address,-1,-1;geo_id \"geo_id\" true true false 15 Text 0 0 ,First,#,Database Connections\\TCAD.sde\\TCAD.TC_USER.TCAD_PARCELS,geo_id,-1,-1;tcad_acres \"tcad_acres\" true true false 8 Double 8 38 ,First,#,Database Connections\\TCAD.sde\\TCAD.TC_USER.TCAD_PARCELS,tcad_acres,-1,-1;GIS_acres \"GIS_acres\" true true false 8 Double 8 38 ,First,#,Database Connections\\TCAD.sde\\TCAD.TC_USER.TCAD_PARCELS,GIS_acres,-1,-1;imprv_home \"imprv_homesite_val\" true true false 4 Long 0 10 ,First,#,Database Connections\\TCAD.sde\\TCAD.TC_USER.TCAD_PARCELS,imprv_homesite_val,-1,-1;land_homes \"land_homesite_val\" true true false 4 Long 0 10 ,First,#,Database Connections\\TCAD.sde\\TCAD.TC_USER.TCAD_PARCELS,land_homesite_val,-1,-1;deed_num \"deed_num\" true true false 50 Text 0 0 ,First,#,Database Connections\\TCAD.sde\\TCAD.TC_USER.TCAD_PARCELS,deed_num,-1,-1;year_built \"year_built\" true true false 2 Short 0 5 ,First,#,Database Connections\\TCAD.sde\\TCAD.TC_USER.TCAD_PARCELS,year_built,-1,-1;Shape_STAr \"Shape_STAr\" false false true 0 Double 0 0 ,First,#,Database Connections\\TCAD.sde\\TCAD.TC_USER.TCAD_PARCELS,Shape.STArea(),-1,-1;Shape_STLe \"Shape_STLe\" false false true 0 Double 0 0 ,First,#,Database Connections\\TCAD.sde\\TCAD.TC_USER.TCAD_PARCELS,Shape.STLength(),-1,-1", "") ... View more

I have designed a survey using Survey123 Connect for ArcGIS and had some images  on it. these images display very well while on the Form preview but when I publish the survey, the images disappears from the published version. Please can someone tell me what could be causing this problem. Screenshots of the preview version and published versions are shown below. also I am putting here the excel spreadsheet I used for the design. ... View more

I have some features (Road, Drainage and Parcels - Line, Point and Polygon) data. The spatial attributes of these features are captured by drawing them into arcmap and then stored feature class in a feature dataset  in a geodatabase that is on MSSQL2012 database on Server A. The non spatial attributes of these features are existing on another DEVSQL2012 on Server B. I am able to connect to the different databases using ArcCatalog Database connection and so able to view both the spatial and non-spatial data separately. I am now trying to create a database View from my ArcCatalog to join the spatial table on Server A  to  the non-spatial table on Server B.  But I keep getting various errors. Please does anyone has an idea how I can get this resolved. SELECT [DEVSQL2012].TVR_CIPS.dbo.Projects.Id, TVR_CIPSdboProjectsName TVR_CIPS.dbo.Projects.Name, TVR_CIPS.dbo.Projects.ProjectTypeId, TVR_CIPS.dbo.Projects.ProjectManagerId, TVR_CIPS.dbo.Projects.IsFunded, TVR_CIPS.dbo.Projects.Scope, TVR_CIPS.dbo.Projects.FundSource, TVR_CIPS.dbo.Projects.TotalEstimatedCost, TVR_CIPS.dbo.Projects.Consultant, TVR_CIPS.dbo.Projects.Contractor, TVR_CIPS.dbo.Projects.LocationLimits, TVR_CIPS.dbo.Projects.GISId, TVR_CIPS.dbo.Projects.StatusId, TVR_CIPS.dbo.Projects.PermalinkMapURL, TVR_CIPS.dbo.Projects.CIPDocURL FROM TVR_CIPS.dbo.Projects INNER JOIN  [Frussmolt\TVR3PRD02].PublicWorks.TC_USER.CIP_Point_Only ON [DEVSQL2012].TVR_CIPS.dbo.Id = [Frussmolt\TVR3PRD02].PublicWorks.TC_USER.CIP_Point_Only.Project_ID Here is the error I'm getting  I don't understand why it is seeing that column as invalid. the column is supposed to be a Yes or No (0 and 1) though the field datatype for this column is 'Short integer', Could this be a problem? ... View more

I created a python script to reconcile all edits on the users versions, then  post the reconciled version to a QAQC and then to the sde or dbo default version. After this process the script will proceed to compress analyze and rebuild indexes for the tables in the sde database. This script will be scheduled on windows scheduler to run silently at 2:00am on Thursday and  Saturday morning when users are offline. If there should be any error encountered, the script is to print the errors and also generate a log file containing the errors and store the logfile with date and time in the specified drive location. Since the script was scheduled to run behind scene on windows scheduler, it was difficult for me to see errors when it happens. This was a big issue because users edits weren't reflected on our default database after sometime due to the error encountered by the script, his actually necessitated the need for a functional logfile that will enable me identify the errors. The initial problem I had was that  the script executed very well but could only print the errors on the screen but it generates an empty logfile. This was corrected by putting in 3 lines at the end of the script to get it to write the printed errors intothe logfile, save it with time and date. The Initial Script - executes but generates an empty log file # This script will reconcile and post all edits made in child versions of Natural Resources Geodatabase to QA\QC and then to SDE default database,it will go further to compress the database, analyze and rebuild the indexes on the database tables. # Script developed by Irene F. Egbulefu - GIS Analyst ( TNR Dept) import arcpy import sys import os import datetime import traceback # Database Connection editDB ="Database Connections\\Frogmouth_Natural_ResourcesTC.sde" # Current Day Day = time.strftime("%m-%d-%Y", time.localtime()) # Current Time Time = time.strftime("%I:%M:%S %p", time.localtime()) # Set workspace workspace = editDB # Set the workspace environment arcpy.env.workspace = workspace arcpy.env.overwriteOutput = True try:     # Start Time     print 'Process Started at ' + str(Day) + " " + str(Time) # block new connections to the PublicWorks Geodatabase on Frogmouth Server.     print "Blocking Connections..."     arcpy.AcceptConnections(editDB, False)     # disconnect all users from the PublicWorks Geodatabase on Frogmouth Server.     print "Disconnecting Users..."     arcpy.DisconnectUser(editDB, "ALL") # Get a list of all child versions besides QAQC and DEFAULT to pass into the ReconcileVersions tool.     ver1List = [ver1.name for ver1 in arcpy.da.ListVersions(editDB) if ver1.name != 'TC_USER.QA/QC' and ver1.name != 'sde.DEFAULT'] # Execute the ReconcileVersions tool with QAQC Target Version and do not delete child versions     print "Reconcile/post versions to QAQC...."     arcpy.ReconcileVersions_management(editDB, "ALL_VERSIONS", "TC_USER.QA/QC", ver1List, "LOCK_ACQUIRED", "ABORT_CONFLICTS", "BY_OBJECT", "FAVOR_TARGET_VERSION", "POST", "KEEP_VERSION") # Extract QAQC version from the list of versions to pass to ReconcileVersions tool.     ver2List = [ver2.name for ver2 in arcpy.da.ListVersions(editDB) if ver2.name == 'TC_USER.QA/QC'] # Execute the ReconcileVersions tool with DEFAULT Target Version and do not delete QAQC version     print "Reconcile/post QAQC to DEFAULT..."     arcpy.ReconcileVersions_management(editDB, "ALL_VERSIONS", "sde.DEFAULT", ver2List, "LOCK_ACQUIRED", "ABORT_CONFLICTS", "BY_OBJECT", "FAVOR_TARGET_VERSION", "POST", "KEEP_VERSION") # Run the compress tool.     print "Compressing database..."     arcpy.Compress_management(editDB)     # /////////////////////////////////// ANALYZE DATASETS AND CALC STATISTICS /////////////////////////////////////     # NOTE: Rebuild indexes can accept a Python list of datasets.     # Get a list of all the datasets the user has access to.     # First, get all the stand alone tables, feature classes and rasters.     dataList = arcpy.ListTables() + arcpy.ListFeatureClasses() + arcpy.ListRasters()     # Next, for feature datasets get all of the datasets and featureclasses     # from the list and add them to the master list.     for dataset in arcpy.ListDatasets("*", "Feature"):         arcpy.env.workspace = os.path.join(workspace, dataset)         dataList += arcpy.ListFeatureClasses() + arcpy.ListDatasets()       # reset the workspace     arcpy.env.workspace = workspace     # Concatenate all datasets into a list     datasetList = [ds for ds in dataList]         print "rebuilding indexes"     # Execute rebuild indexes     # Note: to use the "SYSTEM" option the workspace user must be an administrator.     arcpy.RebuildIndexes_management(workspace, "NO_SYSTEM", datasetList, "ALL")     print('Rebuild Complete')         print "analyzing datasets"     arcpy.AnalyzeDatasets_management(workspace, "NO_SYSTEM", datasetList, "ANALYZE_BASE", "ANALYZE_DELTA", "ANALYZE_ARCHIVE")     print "analysis complete"     #Allow the database to begin accepting connections again     print "Set databases to allow connections..."     arcpy.AcceptConnections(editDB, True) # \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ script initiation, Rec/Post process error handling \\\\\\\\\\\\\\\\\\\\\\\\\\\\\ except:     print 'An error occured'     failMsg = '\nSCRIPT FAILURE IN SCRIPT INITIATION OR RECONCILE-POST PROCESS, \n'     failMsg += 'Most recent GP messages below.\n'     failMsg += arcpy.GetMessages() +'\n'     failMsg += '\nTraceback messages below.\n'     failMsg += traceback.format_exc().splitlines()[-1]     print failMsg     # \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ write error log info\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ # move to working directory     os.chdir (u'Y:\\TOOLS\\Logs\\') ## define function with variable filename and the format of the timestamp     def timeStamped(filename, fmt='%m-%d-%y-%H.%M.%S-{filename}'):        return datetime.datetime.now().strftime(fmt).format(filename=filename) ## assign local variable filename and use whatever file name and extension you need     filename = timeStamped('Natural_ResourcesTC_toQC_Log.txt') ## Create the logfile and assign write permission     Open(filename, "w") ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Final corrected script - executes and generates logfile, prints errors on the screen and also writes error information  into the logfile it # This script will reconcile and post all edits made in child versions of Natural Resources Geodatabase to QA\QC and then to SDE default database,it will go further to compress the database, analyze and rebuild the indexes on the database tables # Script developed by Irene F. Egbulefu - GIS Analyst ( TNR Dept) import arcpy import sys import os import datetime import traceback # Database Connection editDB ="Database Connections\\Frogmouth_Natural_ResourcesTC.sde" # Current Day Day = time.strftime("%m-%d-%Y", time.localtime()) # Current Time Time = time.strftime("%I:%M:%S %p", time.localtime()) # Set workspace workspace = editDB # Set the workspace environment arcpy.env.workspace = workspace arcpy.env.overwriteOutput = True try:     # Start Time     print 'Process Started at ' + str(Day) + " " + str(Time) # block new connections to the PublicWorks Geodatabase on Frogmouth Server.     print "Blocking Connections..."     arcpy.AcceptConnections(editDB, False)     # disconnect all users from the PublicWorks Geodatabase on Frogmouth Server.     print "Disconnecting Users..."     arcpy.DisconnectUser(editDB, "ALL") # Get a list of all child versions besides QAQC and DEFAULT to pass into the ReconcileVersions tool.     ver1List = [ver1.name for ver1 in arcpy.da.ListVersions(editDB) if ver1.name != 'TC_USER.QA/QC' and ver1.name != 'sde.DEFAULT'] # Execute the ReconcileVersions tool with QAQC Target Version and do not delete child versions     print "Reconcile/post versions to QAQC...."     arcpy.ReconcileVersions_management(editDB, "ALL_VERSIONS", "TC_USER.QA/QC", ver1List, "LOCK_ACQUIRED", "ABORT_CONFLICTS", "BY_OBJECT", "FAVOR_TARGET_VERSION", "POST", "KEEP_VERSION") # Extract QAQC version from the list of versions to pass to ReconcileVersions tool.     ver2List = [ver2.name for ver2 in arcpy.da.ListVersions(editDB) if ver2.name == 'TC_USER.QA/QC'] # Execute the ReconcileVersions tool with DEFAULT Target Version and do not delete QAQC version     print "Reconcile/post QAQC to DEFAULT..."     arcpy.ReconcileVersions_management(editDB, "ALL_VERSIONS", "sde.DEFAULT", ver2List, "LOCK_ACQUIRED", "ABORT_CONFLICTS", "BY_OBJECT", "FAVOR_TARGET_VERSION", "POST", "KEEP_VERSION") # Run the compress tool.     print "Compressing database..."     arcpy.Compress_management(editDB)     # /////////////////////////////////// ANALYZE DATASETS AND CALC STATISTICS /////////////////////////////////////     # NOTE: Rebuild indexes can accept a Python list of datasets.     # Get a list of all the datasets the user has access to.     # First, get all the stand alone tables, feature classes and rasters.     dataList = arcpy.ListTables() + arcpy.ListFeatureClasses() + arcpy.ListRasters()     # Next, for feature datasets get all of the datasets and featureclasses     # from the list and add them to the master list.     for dataset in arcpy.ListDatasets("*", "Feature"):         arcpy.env.workspace = os.path.join(workspace, dataset)         dataList += arcpy.ListFeatureClasses() + arcpy.ListDatasets()       # reset the workspace     arcpy.env.workspace = workspace     # Concatenate all datasets into a list     datasetList = [ds for ds in dataList]         print "rebuilding indexes"     # Execute rebuild indexes     # Note: to use the "SYSTEM" option the workspace user must be an administrator.     arcpy.RebuildIndexes_management(workspace, "NO_SYSTEM", datasetList, "ALL")     print('Rebuild Complete')         print "analyzing datasets"     arcpy.AnalyzeDatasets_management(workspace, "NO_SYSTEM", datasetList, "ANALYZE_BASE", "ANALYZE_DELTA", "ANALYZE_ARCHIVE")     print "analysis complete"     #Allow the database to begin accepting connections again     print "Set databases to allow connections..."     arcpy.AcceptConnections(editDB, True) # \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ script initiation, Rec/Post process error handling \\\\\\\\\\\\\\\\\\\\\\\\\\\\\ except:     print 'An error occured'     failMsg = '\nSCRIPT FAILURE IN SCRIPT INITIATION OR RECONCILE-POST PROCESS, \n'     failMsg += 'Most recent GP messages below.\n'     failMsg += arcpy.GetMessages() +'\n'     failMsg += '\nTraceback messages below.\n'     failMsg += traceback.format_exc().splitlines()[-1]     print failMsg     # \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ write error log info\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ # move to working directory     os.chdir (u'Y:\\TOOLS\\Logs\\') ## define function with variable filename and the format of the timestamp     def timeStamped(filename, fmt='%m-%d-%y-%H.%M.%S-{filename}'):        return datetime.datetime.now().strftime(fmt).format(filename=filename) ## assign local variable filename and use whatever file name and extension you need     filename = timeStamped('Natural_ResourcesTC_toQC_Log.txt') ## Create the logfile and assign write permission     f = Open(filename, "w")     f.write(failmsg)     f.close()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Hi All I have some datasets: Parks, Park facilities and ParkTrails. These have many-to-many relationship; i.e a park can have multiple facilities and there may be multiple park trails on a single park I would like to publish this data to ArcGIS Server, and issue queries on it, so that I can get a single result for a single Park. Currently, when mapping  say a pack I get all other parks and facilities as well as Park line and this is somehow confusing and a lot of information to digest at a time when the result is drawn by a text search. Please does anyone have an idea how I can create a spatial view that will generate a unique Object ID field for repeated geometries to enable me publish a park layer with say uniquely identified facilities and park lines. I am using MSSQL Database server 2012 and ArcGIS 10.4. I would also not want to tamper with my data storage type. I have tried creating the view from my MSSQL interface but  on bringing it across to ArcCatalog or ArcMap, I keep getting the OID error (ObjectID)and some other errors as shown in the screenshot attached here. Also at some point, the feature displays on ArcMap to show just  one feature either polygon data or the Line data but when I try to view the attribute table it gives me another error screenshot 2   ... View more