Latest Contributions by HalilSiddique

Hi all, What i want to do is to identify all the permissions a particular user has for a particular layer what sde command do i need to run to get this info? or do I have to use SQL plus (if so what would the script look like?) Cheers Halil ... View more

Hi all, Does anyone know how to increase the print quality of prints. I am using the myPrint widget, from here http://www.arcgis.com/home/item.html?id=07e56ade38874471acff6e6f973ed04d. I have attached a couple of examples. Is the quality of printing better in AGS 10? (we are still on 9.3.1) Cheers halil ... View more

Hi all, Can someone advise me on how to remove the first 15 characters in a field I have the following code # Import system modules import sys, string, os, arcgisscripting # Create the Geoprocessor object gp = arcgisscripting.create(9.3) # Overwrite data gp.OverwriteOutput = 1 # Allow fields not to be appended gp.qualifiedFieldNames = "false" # Local variables... inputView = "Database Connections\\UNIFORM BIZTALK.sde\\UNI72LIVE.LLPG" inputPoint = "Database Connections\\UNISDE on singapore 5155.sde\\UNISDELIVE.UFRM_BLPU_POINT" featurePoint = "UFRM_BLPU_POINT_Layer" llpgView = "GIS_LLPG_SOURCE_View" SDELayer = "Database Connections\\CORPDATA.sde\\ESRIGIS.CORPDATA.BLPU_Property_Points_NEW" try:     # Process: Make Feature Layer...     gp.MakeFeatureLayer_management(inputPoint, featurePoint, "", "", "KEYVAL KEYVAL VISIBLE NONE;UPRN UPRN VISIBLE NONE;CREATEDBY CREATEDBY VISIBLE NONE;MODIFIEDBY MODIFIEDBY VISIBLE NONE;DATE_CREATED DATE_CREATED VISIBLE NONE;DATE_MODIFIED DATE_MODIFIED VISIBLE NONE;STATUS STATUS VISIBLE NONE;TRANSACTION_TYPE TRANSACTION_TYPE VISIBLE NONE;SYMBOL SYMBOL VISIBLE NONE;X X VISIBLE NONE;Y Y VISIBLE NONE;LOGICAL_STATUS LOGICAL_STATUS VISIBLE NONE;ACCURACY ACCURACY VISIBLE NONE;ADDRESS ADDRESS VISIBLE NONE")     print "1 - Make BLPU points into a View - Complete"         # Process: Make Table View...     gp.MakeTableView_management(inputView, llpgView, "", "", "S_NAME S_NAME VISIBLE NONE;LOCALITY_NAME LOCALITY_NAME VISIBLE NONE;TOWN_NAME TOWN_NAME VISIBLE NONE;COUNTY_NAME COUNTY_NAME VISIBLE NONE;START_NO START_NO VISIBLE NONE;START_SFX START_SFX VISIBLE NONE;END_NO END_NO VISIBLE NONE;END_SFX END_SFX VISIBLE NONE;DESCRPT DESCRPT VISIBLE NONE;SO_START_NO SO_START_NO VISIBLE NONE;SO_START_SFX SO_START_SFX VISIBLE NONE;SO_END_NO SO_END_NO VISIBLE NONE;SO_END_SFX SO_END_SFX VISIBLE NONE;SO_DESCRPT SO_DESCRPT VISIBLE NONE;POSTCODE POSTCODE VISIBLE NONE;POST_TOWN POST_TOWN VISIBLE NONE;ORGANISATION ORGANISATION VISIBLE NONE;UPDATED_D UPDATED_D VISIBLE NONE;BLPU_CLASS BLPU_CLASS VISIBLE NONE;BLPU_CLASS_DESC BLPU_CLASS_DESC VISIBLE NONE;LOGICAL_STATUS LOGICAL_STATUS VISIBLE NONE;UPRN UPRN VISIBLE NONE")     print "2 - Make LLPG into a View - Complete"         # Process: Add Join...     gp.AddJoin_management(featurePoint, "UPRN", llpgView, "UPRN", "KEEP_COMMON")     print "3 - Join Points to table - Complete"         # Process: Delete Features...     gp.DeleteFeatures_management(SDELayer)     print "4 - Delete the features in the SDE later - Complete"     # Process: Append...     gp.Append_management(featurePoint, SDELayer, "TEST", "", "")     print "5 - Append the updated BLPU to SDE layer - Complete"         print "Done" except:     print "Error has occured"     print gp.getmessages() When the Add Join occurs, it calls the field UNI72LIVE_LLPG_BLPU_CLASS_DESC I just want the field to be called BLPU_CLASS_DESC, and i want this to occur for all the fields that have "UNI72LIVE_LLPG_" as part of the field name. Anyone got any idea on how to do this? Cheers halil ... View more

Hi all, I have the following script, but for some reason in my shapefile (Step 5) , its does not keep the field name for the Joined fields. # Name: BLPU_VIEW.py # Author: Halil Siddique # Description: This scripts will  Join the BLPU Point layer and the GIS_LLPG_SOURCE view. # Date: 21/07/2011 # Create the Geoprocessor object import arcgisscripting gp = arcgisscripting.create(9.3) # Allow Overwrite gp.OverwriteOutput = 1 # Set Workspace gp.Workspace = "C:\\datadump" datadump = gp.Workspace # Input variables from SDE inputPoint = "C:\\TestData on CORPGIS.sde\\TESTDATA.BLPU_POINT" inputView = "C:\\TestData on CORPGIS.sde\\TESTDATA.GIS_LLPG_SOURCE" BLPU_TEST = "C:\\TestData on CORPGIS.sde\\TESTDATA.BLPU_TEST" # Input variables from datadump folder # Allow Unqualified field names gp.QualifiedFieldNames = "UNQUALIFIED" ##################################################################### try:         # Create Feature Layer from BLPU point     gp.makeFeatureLayer_management(inputPoint, "point_lyr")     print "1 - ", inputPoint, "is now a feature layer"     # Export GIS_LLPG_SOURCE to datadump to get OID     gp.copyrows_management(inputView, "GIS_LLPG_SOURCEExport")     print "2 - ", "inputView", "has been exported to", datadump     # Create Table View from GIS_LLPG_SOURCE     gp.makeTableView_management("GIS_LLPG_SOURCEExport", "GIS_LLPG_SOURCEView")       print "3 - GIS_LLPG_SOURCE is now a table view"      # Join BLPU_POINT layer  with GIS_LLPG_SOURCE     gp.AddJoin_management("point_lyr", "UPRN", "GIS_LLPG_SOURCEView", "UPRN")     print "4 - ", "Points has been joined to GIS_LLPG_SOURCE"         # Export Joined Point layer     gp.copyFeatures_management("point_lyr", "READY_FOR_SDE")     print "5 - ", "Joined points has been exported to", datadump     # Delete features from SDE layer     gp.deletefeatures(BLPU_TEST)     print "6 - ", "BLPU_TEST features deleted"     # Upload new BLPU points     gp.append_management("C:\\datadump\\READY_FOR_SDE.SHP", BLPU_TEST, "NO_TEST","")     print "7 - ", "new BLPU points uploaded"     except:     print "Error has occured"     print gp.getmessages() My field names end up becoming   GIS_LLPG_S   GIS_LLPG_1   GIS_LLPG_2   GIS_LLPG_3   GIS_LLPG_4   GIS_LLPG_5   GIS_LLPG_6   GIS_LLPG_7   GIS_LLPG_8   GIS_LLPG_9   GIS_LLP_10   GIS_LLP_11   GIS_LLP_12   GIS_LLP_13   GIS_LLP_14   GIS_LLP_15   GIS_LLP_16 Anyone got any ideas or workarounds? Cheers halil ... View more