Latest Contributions by AlexP_

@JoeBorgione  Thank you for reply. The one I asked about sequence on post was for a different case. This case here is for example, address field, entry address info 1234 NW 102 AVE.  but if an editor re entry the same address. it needs to set up to avoid duplicate . hope this clarify. ... View more

@JoeBorgione  Thank you for clarify. 2) GLOBALID, if I add it, would it be an issue if I need to set up unique identifier/avoid duplicate based on a text field? ... View more

@JoeBorgione  1) All my data are in the same enterprise geodatabase. parcelview is a enterprise geodatabase view under the same enterprise database also. Is it still ok? Also, you mentioned datastore, is it like enterprise database? Correct me if I am wrong. ... View more

@RichardFairhurst  Thank you. It looks like I add this script in ArcGIS Pro python window?  ... View more

Thank you @JoeBorgione  1) Would this still work operate while create a new point feature class on web app builder? 2) is it required GLOBALID? 3) Do I add that attribute rule under new point feature class or under existing polygon feature class?  4) I have a little knowledge with attribute rule. I have existing polygon feature class layer name is parcelview and the field is parent_folio. The new point feature class name is address_edit and the field is parent_folio. Trying to replace what I have. My understanding is "parcel" is the name of feature class? "MyParcels" is another feature class? parcel_id is a field? I am a bit lost. ... View more

Hello @JoeBorgione  Thank you for sharing.  I read and checked out the link you provided. This seems like a lot process for one staff to entry an address from planning dept. The goal here is simple and straight forward entry a full address field (aka "full road name" from "master road name") with unique identifier based on text without duplicate in a table to allow null (similar how "master road names" setting) then apply it to address point feature class.  I just need one table and one feature class because feature class doesn't allowed null on text field as unique identifier. Please advise. Thank you  Alexis ... View more

@JoeBorgione @DanPatterson  in this case, please screenshot. I hope this is answer your question.  have sql server. It is extract to sde. The goal here is to define a query feature class, for example= this field needs to be define query where FIELD1= HELLO then apply a result just like in ArcMap. I just not sure what to write for that in python script standalone. Also, because original it is fgdb. that part is working fine except either original .dat/.txt isn't update to sde table. it used to work and now it stopped working. the zipped folder included other files such as .dat and .txt plus fgdb. i took out of this piece of script . because the script is very long.            ##### Parse and Copy from .dat file ###### if COPY_PARCELDATA_DAT == "YES": #Path to the *.dat for k, v in MDOtherFiles.items(): if '.txt' in k: conf_filename = server_processing_directory + "\\" + "MDShapes\\PA_Data\\"+k data_filename = server_processing_directory + "\\" + "MDShapes\\PA_Data\\"+k.replace(".txt", ".dat") table_name = k.replace(".txt","").strip() table_name = table_name.replace(".dat","").strip() #print table_name #start_time = str(datetime.datetime.now()) # get the current date & time log_write(log_file, '.Started processing '+data_filename+' file') columns = '' types = [] try: with open(conf_filename, 'r') as f: for index, line in enumerate(f): #replace datatypes line = line.strip() #line = line.replace('VARCHAR2', 'VARCHAR') #line = line.replace('NUMBER', 'NUMERIC') types.append(line.split(" ")[1].strip()) columnName = line.split(" ")[0].strip() if index >= 1: columns = columns +','+ columnName +' varchar(100) NULL' else: columns = columns + columnName +' varchar(100) NULL' #print columns connection = pypyodbc.connect('Driver={SQL Server};' 'Server=test;' 'Database=test;' 'uid=test;pwd=test') cursor = connection.cursor()           ... View more

Great. Thank you! @DanPatterson @JayantaPoddar  ... View more

Hello Richard,   Thank you for the information. This data has about 40k and continue to increase. Since these both feature class and table have no unique identifier. The goal here is to join both three fields to be accurate then the fourth field will be transfer or input into the feature class from a table because this feature class doesn't have the fourth field info as needed. this is need to be update weekly. ... View more

@DanPatterson   I just had a requested that need to add text in a field for example "CITY-100" I tried to rerun but it doesn't work. Also, I found out that this type field has long and numeric. Please advise. ... View more

Understood. Thank you for the information @DanPatterson @JayantaPoddar .  very helpful. ... View more