|
POST
|
@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
03-22-2021
10:21 AM
|
0
|
0
|
5285
|
|
POST
|
@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
03-22-2021
09:02 AM
|
0
|
2
|
5291
|
|
POST
|
@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
03-22-2021
08:56 AM
|
0
|
4
|
5295
|
|
POST
|
@RichardFairhurst Thank you. It looks like I add this script in ArcGIS Pro python window?
... View more
03-22-2021
08:31 AM
|
0
|
1
|
4379
|
|
POST
|
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
03-22-2021
08:27 AM
|
0
|
0
|
5301
|
|
POST
|
Hello, I am a bit rusty with survey123 and webapp builder. Please correct me if anything. I have ArcGIS Pro 2.7.1, sde, ArcGIS server, AGOL, map/feature service. Not sure which app is best to apply. I have a staff as an editor to create new point feature class. I have a few questions. 1) set up pull data from existing polygon feature class parcel number field into point feature class in a parcel number field every time create a new point. I saw something with geopoint or javascript from survey123? or is there a better other method? 2) how to set up concatenate fields ? 3) how to set up a field to avoid duplicate/repeat? Please kindly advise. Thank you Alex EDIT: I haven't apply GLOBAL ID yet. 1) set up pull data from existing polygon feature class parcel number field into point feature class in a parcel number field every time create a new point. I saw something with geopoint or javascript from survey123? or is there a better other method? Are these info correct below? https://community.esri.com/t5/arcgis-survey123-questions/pulldata-quot-geopoint-quot-location-quot-reversegeocode-other/m-p/818224#M15160 https://community.esri.com/t5/arcgis-survey123-blog/understanding-reverse-geocoding-in-survey123-3-0/ba-p/891644 2) how to set up concatenate fields ? Survey123 I found this link that might work for me. https://community.esri.com/t5/arcgis-survey123-questions/can-survey123-auto-concatenate-text-and-integers-times-from/m-p/810805 3) how to set up a field to avoid duplicate/repeat? I still can't find it. anyone kindly point this out for me? for example. not to reuse the same information in the field.
... View more
03-22-2021
08:04 AM
|
0
|
0
|
896
|
|
POST
|
Hello, I am not sure if I am in the right group. I have AGOL web app, arcgis pro 2.7.1, sde, feature service and map service arcgis server. I have a staff as an editor. I am trying to figure out how to set up pull data from polygon feature class parcel number field into point feature class in a parcel number field every time create a new point. If this way doesn't work, please correct me. Please kindly advise. Thank you. Alex
... View more
03-22-2021
07:41 AM
|
0
|
16
|
7050
|
|
POST
|
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
03-20-2021
01:42 PM
|
0
|
0
|
2020
|
|
POST
|
Hello, ArcGIS Pro 2.7.1 and sde. I have a question. I need to set up a unique identifier on text field to avoid repeat. For example, a staff entry an address information 1234 NW 103 AVE UNIT 123. I am unable to find enough information. I found a piece of information from ArcGIS documentation. please let me know what step by step is. "If a single string field is used as the unique identifier, ArcGIS must map those unique values to an integer. This is done in ArcGIS anytime the system needs an Object ID attribute, such as when creating a map selection or opening the attribute table. ArcGIS adds an attribute called ESRI_OID and stores a unique integer value in it. This attribute is only part of the layer definition; the underlying database table is not altered."
... View more
03-19-2021
02:31 PM
|
0
|
1
|
5633
|
|
POST
|
@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
03-19-2021
01:24 PM
|
0
|
0
|
2027
|
|
POST
|
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
03-19-2021
12:40 PM
|
0
|
3
|
4412
|
|
POST
|
I have arcgis pro 2.7.1 and sde. How do I join more than one fields in feature class and table? I see it is allowed only one field from join. Please advise. Thank you Alex
... View more
03-17-2021
09:13 AM
|
0
|
5
|
4439
|
|
POST
|
@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
03-16-2021
09:58 PM
|
0
|
3
|
3437
|
|
POST
|
Understood. Thank you for the information @DanPatterson @JayantaPoddar . very helpful.
... View more
03-16-2021
06:46 PM
|
0
|
0
|
3445
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 07-30-2021 01:32 PM | |
| 1 | 04-01-2025 12:12 PM | |
| 1 | 05-12-2021 10:12 AM | |
| 1 | 07-25-2018 12:53 PM | |
| 1 | 08-06-2018 12:27 PM |