Latest Contributions by DavidBuehler

‎12-08-2021

Figured it out https://survey123.arcgis.com/share/XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX?open=menu or web followed by the fields you want to push. It is right there with no real example in the doc: https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-web-form-url/ba-p/894722

‎12-08-2021

Hello All, What I would like to do is push attributes from a web layer in a web map to a Survey123 form. This is easy if you are pushing to the app version of Survey123. You use something like this: https://survey123.arcgis.app?itemID=xxxxxxxxxxxxxxxxxxxxxxxxxxxxe&field:address={OwnersMailingLabel} or arcgis-survey123://open=web?itemID=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx&field:address={OwnersMailingLabel} What I would like to know is if is possible make the same push to open the form with the attribute transfer and force it to open in a web browser version of the form? And still have the attributes pushover to the form in the web browser? I did find this https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-web-form-url/ba-p/894722 It talks about under the section: "Set the app that will open your survey (open)" using ...?open=web or menu, but the url method in the popup does not seem to honor it.

‎10-08-2021

@XanderBakker I used expression mentioned at the top of this post (https://support.esri.com/en/technical-article/000020624). I am using at 3.12+ Survey, and a webmap in AGOL, it pushes over the the geometry, but it does not push over any other field. It leaves that as the the {} example &field:FacilityID={FacilityID} leaves the field filled with {FacilityID}. Thoughts?

‎08-19-2021

Background - Feature layer is related to the table (table was created in Survey123 Connect in order to get the bind type of GUID) based on GlobalID and GUID. Feature layer will be an existing set of features that now need maintenance records (hence the related records table). Ideally, it would be used in Field Maps and/or Collector. Which currently do not push the related record back though it shows the table is there as a related record table. Which then I would assume would also so in any web maps. Web map has the see related records box checked. Not sure what else I can share with you. If you need something else please let me know because if this can be figured out this a game changer for lots of people. Here is the JSON for the service: { "adminServiceInfo" : { "name" : "rrtestv5", "type" : "FeatureServer", "cacheMaxAge" : 0, "status" : "Started", "database" : { "datasource" : { "name" : "db" } } }, "currentVersion" : 10.81, "serviceItemId" : "fabfe8d3af784fb7a16cc3942bd1bedf", "serviceDescription" : "", "hasVersionedData" : false, "supportsDisconnectedEditing" : false, "hasStaticData" : false, "hasSharedDomains" : false, "maxRecordCount" : 2000, "supportedQueryFormats" : "JSON", "supportsVCSProjection" : false, "supportedExportFormats" : "csv,shapefile,sqlite,gpkg,filegdb,featureCollection,geojson,excel", "capabilities" : "Create,Delete,Query,Update,Editing,Sync", "description" : "", "copyrightText" : "", "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 }, "initialExtent" : { "xmin" : -10064729.121092074, "ymin" : 5558924.3042244306, "xmax" : -10005952.429953229, "ymax" : 5578801.8141854359, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "fullExtent" : { "xmin" : -10064729.121092074, "ymin" : 5558924.3042244306, "xmax" : -10005952.429953229, "ymax" : 5578801.8141854359, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "allowGeometryUpdates" : true, "units" : "esriMeters", "supportsAppend" : true, "supportsSharedDomains" : true, "supportsWebHooks" : true, "supportsTemporalLayers" : true, "layerOverridesEnabled" : true, "size" : 16384, "syncEnabled" : true, "syncCapabilities" : { "supportsAsync" : true, "supportsRegisteringExistingData" : true, "supportsSyncDirectionControl" : true, "supportsPerLayerSync" : true, "supportsPerReplicaSync" : true, "supportsSyncModelNone" : true, "supportsRollbackOnFailure" : true, "supportsAttachmentsSyncDirection" : true, "supportsBiDirectionalSyncForServer" : true }, "supportsApplyEditsWithGlobalIds" : true, "supportsReturnDeleteResults" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsQueryContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsContingentValuesJson" : 2, "editorTrackingInfo" : { "enableEditorTracking" : true, "enableOwnershipAccessControl" : false, "allowOthersToQuery" : true, "allowOthersToUpdate" : true, "allowOthersToDelete" : false, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "xssPreventionInfo" : { "xssPreventionEnabled" : true, "xssPreventionRule" : "InputOnly", "xssInputRule" : "rejectInvalid" }, "layers" : [ { "adminLayerInfo" : { "tableName" : "db_42239.user_42239.rrtestv5_POINT_LAYER", "geometryField" : {"name" : "Shape"}, "xssTrustedFields" : "" }, "id" : 0, "enableUseOfScaleOutReplicasWhenEditable" : true, "name" : "Point layer", "type" : "Feature Layer", "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "CreationDate", "creatorField" : "Creator", "editDateField" : "EditDate", "editorField" : "Editor" }, "editingInfo" : { "lastEditDate" : 1629315116344 }, "relationships" : [ { "id" : 1, "name" : "myRel", "relatedTableId" : 1, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "globalid", "composite" : true } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides " : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsQueryAttachments" : true, "supportsReturningGeometryCentroid" : false, "supportsQueryWithDatumTransformation" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportsQueryAttachmentsWithReturnUrl" : true, "supportsQueryAnalytic" : true }, "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -10064729.121092074, "ymin" : 5558924.3042244306, "xmax" : -10005952.429953229, "ymax" : 5578801.8141854359, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"RedSphere.png","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15}}}, "allowGeometryUpdates" : true, "hasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "isEnabled" : true }, { "name" : "name", "fieldName" : "ATT_NAME", "isEnabled" : true }, { "name" : "size", "fieldName" : "DATA_SIZE", "isEnabled" : true }, { "name" : "contentType", "fieldName" : "CONTENT_TYPE", "isEnabled" : true }, { "name" : "keywords", "fieldName" : "Keywords", "isEnabled" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "globalIdField" : "GlobalID", "typeIdField" : "", "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "CreationDate", "type" : "esriFieldTypeDate", "alias" : "CreationDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "Creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "EditDate", "type" : "esriFieldTypeDate", "alias" : "EditDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "Editor", "type" : "esriFieldTypeString", "alias" : "Editor", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "facid", "type" : "esriFieldTypeString", "alias" : "FacilityID", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "Comments", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "visible" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "GlobalID_Index", "fields" : "GlobalID", "isAscending" : false, "isUnique" : true, "description" : "" }, { "name" : "user_42239.rrtestv5_POINT_LAYER_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index" }, { "name" : "PK__rrtestv5__F4B70D855C3DCA2D", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key" }, { "name" : "CreationDateIndex", "fields" : "CreationDate", "isAscending" : true, "isUnique" : false, "description" : "CreationDate Field index" }, { "name" : "CreatorIndex", "fields" : "Creator", "isAscending" : false, "isUnique" : false, "description" : "Creator Field index" }, { "name" : "EditDateIndex", "fields" : "EditDate", "isAscending" : true, "isUnique" : false, "description" : "EditDate Field index" }, { "name" : "EditorIndex", "fields" : "Editor", "isAscending" : false, "isUnique" : false, "description" : "Editor Field index" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "facid" : null, "Comments" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,gpkg,shapefile,filegdb,featureCollection,geojson,csv,excel,imageCollection", "supportedExportFormats" : "csv,shapefile,sqlite,gpkg,filegdb,featureCollection,geojson,excel", "supportedContingentValuesFormats" : "JSON, PBF", "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing,Sync", "exceedsLimitFactor" : 1 }, { "adminLayerInfo" : { "tableName" : "db_42239.user_42239.rrtestv5_RRTESTV5T2", "geometryField" : null, "xssTrustedFields" : "" }, "id" : 1, "enableUseOfScaleOutReplicasWhenEditable" : true, "name" : "rrtestv5t2", "type" : "Table", "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1629314788379 }, "relationships" : [ { "id" : 1, "name" : "myRel", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "GUIDID", "composite" : true } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides " : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsApplyEditsWithGlobalIds" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsReturningGeometryCentroid" : false, "supportsQueryWithDatumTransformation" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportsQueryAnalytic" : true }, "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "globalIdField" : "globalid", "typeIdField" : "", "fields" : [ { "name" : "objectid", "type" : "esriFieldTypeOID", "alias" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "globalid", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeGUID", "length" : 38, "nullable" : false, "editable" : false, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "Facility ID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATE", "type" : "esriFieldTypeDate", "alias" : "Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSPECTOR", "type" : "esriFieldTypeString", "alias" : "Inspector", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDITION", "type" : "esriFieldTypeString", "alias" : "Condition", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "visible" : true, "domain" : { "type" : "codedValue", "name" : "cvd_CONDITION", "codedValues" : [ { "name" : "Excellent", "code" : "Excellent" }, { "name" : "Very Good", "code" : "Very Good" }, { "name" : "Good", "code" : "Good" }, { "name" : "Fair", "code" : "Fair" }, { "name" : "Poor", "code" : "Poor" }, { "name" : "Very Poor", "code" : "Very Poor" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "COMMENTS", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "GUIDID", "type" : "esriFieldTypeGUID", "alias" : "GUID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "CreationDate", "type" : "esriFieldTypeDate", "alias" : "CreationDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "Creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "EditDate", "type" : "esriFieldTypeDate", "alias" : "EditDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "Editor", "type" : "esriFieldTypeString", "alias" : "Editor", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "visible" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "UK_rrtestv5_RRTESTV5T2_globalid", "fields" : "globalid", "isAscending" : true, "isUnique" : true, "description" : "nonclustered, unique" }, { "name" : "PK__rrtestv5__5242E6323C0B1297", "fields" : "objectid", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,gpkg,shapefile,filegdb,featureCollection,geojson,csv,excel", "supportedExportFormats" : "csv,shapefile,sqlite,gpkg,filegdb,featureCollection,geojson,excel", "supportedContingentValuesFormats" : "JSON, PBF", "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing,Sync", "exceedsLimitFactor" : 1 } ] }

‎08-18-2021

@KhaledHassen - I have a successfully created the table and relationship, however nothing pushes and/or errors out in Fieldmaps/Collector/Web map. Cannot see or push to the related table. Here is the hosted service: https://services2.arcgis.com/SZYqn7iYnvAZ1Q4U/arcgis/rest/services/rrtestv5/FeatureServer I get a service error code 1000 Unable to submit. Thoughts?

‎07-28-2021

Try this again - Workflow is similar to my original solution - https://community.esri.com/t5/data-management-questions/comparing-two-feature-classes-and-updating-one-of-them/m-p/247407#M14075 This time it is do an end around the versioning issue with a Survey123 table (backend in SDE). To my understanding based on this article Survey123 based feature services (tables) in SDE cannot be versioned- https://doc.arcgis.com/en/survey123/desktop/create-surveys/survey123withexistingfeatureservices.htm#:~:text=The%20data%20cannot%20be%20versioned,before%20enabling%20attachments%20on%20either. Let's say I have a related table to versioned sanitary lines, the related table has to be versioned as well. Since Survey123 cannot handle versioned data, I cannot push to that table directly. I think I need one table to service the Survey123 form, and the the other to fulfill the relationship. My thinking was compare the two tables and move the new records from Survey123 to the related table, based on globalIDs. Here is what I have come up with thus far. Not sure if I have to do an edit session (I think I do since one of them is versioned). I also get this error: Message File Name Line Position Traceback <module> C:\Users\Dbuehler\Desktop\scripts\TryUpdatingWW.py 74 RuntimeError: Underlying DBMS error [[Microsoft][ODBC Driver 17 for SQL Server]Syntax error, permission violation, or other nonspecific error] [COMGIS3.GIS.SanCleanings_Test] Any help will be much appreciated, import arcpy import sys import os print "Looping through and adding and deleting" #Looping through each feature class and building a list of comparsions. Then adds or deletes them to the SDE feature class. def createMatchingFieldList(fc1, fc2): lst1 = [fld.name for fld in arcpy.ListFields(fc1)] lst2 = [fld.name for fld in arcpy.ListFields(fc2)] return list(set(lst1) & set(lst2)) def createWhereClause(fc, fld_name, value): if len(arcpy.ListFields(fc, fld_name)) == 1: fld = arcpy.ListFields(fc, fld_name)[0] if fld.type == "String": where = "{0} = '{1}'".format(arcpy.AddFieldDelimiters(fc, fld_name), value) else: where = "{0} = {1}".format(arcpy.AddFieldDelimiters(fc, fld_name), value) return where def getPrimaryFieldValues(fc, field): return [r[0] for r in arcpy.da.SearchCursor(fc, [field])] def getSelectCursor(fc, flds, whereClause): return arcpy.da.SearchCursor(fc, flds, whereClause) def diff(a, b): return list(set(a) - set(b)) #source = arcpy.GetParameterAsText(0) #destination = arcpy.GetParameterAsText(1) #fieldName = arcpy.GetParameterAsText(2) source = 'Database Connections/GIS Editor to COMGIS3.sde/COMGIS3.GIS.SanCleanings_Test' destination = 'Database Connections/GIS Editor to COMGIS3.sde/COMGIS3.GIS.SanCleanings_Test2' fieldName = "globalid" # Start an edit session. Must provide the workspace. edit = arcpy.da.Editor(r'C:\Users\Dbuehler\AppData\Roaming\ESRI\Desktop10.7\ArcCatalog\GIS Editor to COMGIS3.sde') # Edit session is started without an undo/redo stack for versioned data # (for second argument, use False for unversioned data) edit.startEditing(False,False) # Start an edit operation edit.startOperation() # create a list of field names which are in both featureclasses flds = createMatchingFieldList(source, destination) sourceValues = getPrimaryFieldValues(source, fieldName) destinationValues = getPrimaryFieldValues(destination, fieldName) additions = diff(sourceValues, destinationValues) #deletions = diff(destinationValues, sourceValues) with arcpy.da.InsertCursor(destination, flds) as insertCursor: for a in additions: where = createWhereClause(source, fieldName, a) insertRows = getSelectCursor(source, flds, where) for r in insertRows: insertCursor.insertRow(r) #for d in deletions: # where = createWhereClause(destination, fieldName, d) # with arcpy.da.UpdateCursor(destination, flds, where) as deleteCursor: # for d in deleteCursor: # deleteCursor.deleteRow() # Stop the edit operation. edit.stopOperation() # Stop the edit session and save the changes edit.stopEditing(True) print "Success"

‎07-28-2021

Back in 2014, I had help figuring comparing two lists. It would add records from Table A that were not in Table B, and delete records from Table B that were not in Table A. See: https://community.esri.com/t5/data-management-questions/comparing-two-feature-classes-and-updating-one-of-them/m-p/247407#M14075 My new use for this is based on a Survey123 limitation. As I understand it based on (https://doc.arcgis.com/en/survey123/desktop/create-surveys/survey123withexistingfeatureservices.htm#:~:text=The%20data%20cannot%20be%20versioned,before%20enabling%20attachments%20on%20either.), when using a feature layer/table to base the survey on and push back to, the data cannot be versioned. My goal is to have a related table on versioned data, which causes the related table to be versioned, that stores the records collected from the Survey123 form. To end around the versioned issue, what I think the best solution is, is to have a separate table that meets the Survey123 criteria to push to, then push the new records to versioned table so the relationship will work. I think comparing globalids should be the field to compare on, and really all I need to do is push adds only. I am not sure if I need an edit session or not, and I do get this error: Underlying DBMS error [[Microsoft][ODBC Driver 17 for SQL Server]Syntax error, permission violation, or other nonspecific error] Any suggestions, help, insight will be greatly appreciated. Below is what I have: import arcpy import sys import os print "Looping through and adding and deleting" #Looping through each feature class and building a list of comparsions. Then adds or deletes them to the SDE feature class. def createMatchingFieldList(fc1, fc2): lst1 = [fld.name for fld in arcpy.ListFields(fc1)] lst2 = [fld.name for fld in arcpy.ListFields(fc2)] return list(set(lst1) & set(lst2)) def createWhereClause(fc, fld_name, value): if len(arcpy.ListFields(fc, fld_name)) == 1: fld = arcpy.ListFields(fc, fld_name)[0] if fld.type == "String": where = "{0} = '{1}'".format(arcpy.AddFieldDelimiters(fc, fld_name), value) else: where = "{0} = {1}".format(arcpy.AddFieldDelimiters(fc, fld_name), value) return where def getPrimaryFieldValues(fc, field): return [r[0] for r in arcpy.da.SearchCursor(fc, [field])] def getSelectCursor(fc, flds, whereClause): return arcpy.da.SearchCursor(fc, flds, whereClause) def diff(a, b): return list(set(a) - set(b)) #source = arcpy.GetParameterAsText(0) #destination = arcpy.GetParameterAsText(1) #fieldName = arcpy.GetParameterAsText(2) source = 'Database Connections/GIS Editor to COMGIS3.sde/COMGIS3.GIS.SanCleanings_Test' destination = 'Database Connections/GIS Editor to COMGIS3.sde/COMGIS3.GIS.SanCleanings_Test2' fieldName = "globalid" # Start an edit session. Must provide the workspace. edit = arcpy.da.Editor(r'C:\Users\XXXXXXXXX\AppData\Roaming\ESRI\Desktop10.7\ArcCatalog\GIS Editor to COMGIS3.sde') # Edit session is started without an undo/redo stack for versioned data # (for second argument, use False for unversioned data) edit.startEditing(False,False) # Start an edit operation edit.startOperation() # create a list of field names which are in both featureclasses flds = createMatchingFieldList(source, destination) sourceValues = getPrimaryFieldValues(source, fieldName) destinationValues = getPrimaryFieldValues(destination, fieldName) additions = diff(sourceValues, destinationValues) #deletions = diff(destinationValues, sourceValues) with arcpy.da.InsertCursor(destination, flds) as insertCursor: for a in additions: where = createWhereClause(source, fieldName, a) insertRows = getSelectCursor(source, flds, where) for r in insertRows: insertCursor.insertRow(r) #for d in deletions: # where = createWhereClause(destination, fieldName, d) # with arcpy.da.UpdateCursor(destination, flds, where) as deleteCursor: # for d in deleteCursor: # deleteCursor.deleteRow() # Stop the edit operation. edit.stopOperation() # Stop the edit session and save the changes edit.stopEditing(True) print "Success"

‎05-05-2021

Thanks Jim, I appreciate the assist. I have tested it out and tied it in with some modifications.

‎04-13-2021

I am trying to mimic a rating system call PACP for sewer rating. Grading happens on a series of potential of 12 issues. Each issue is individually rated 1 through 5, with 5 being the worst if recorded. I am looking to specifically create these three calculations based on the following scenario. The following observations were made - Grease- severity 4 Rags – severity 2 Brick/Masonry – severity 3 Pipe – severity 5 Sewage – severity 4 Calculation 1: Quick Maintenance Rating: Example 5142 1st digit is the highest severity grade 2nd digit is the total number of occurrences of the highest severity grade 3rd digit is the second highest severity grade 4th digit is the total number of occurrences of the second highest severity grade Calculation 2: Maintenance Pipe Rating: Solution from Calculation 1 is basis for this rating: (highest severity grade x number of occurrences) + (next highest severity grade x number of occurences) Example: 5142 - (5x1)+(4x2)= 13 Calculation 3: Maintenance Pipe Rating divided by the total number of maintenance pipe defects Example: Maintenance Pipe Rating = 13 Total number of pipe defects = 5 Solution = 2.6 I can get some of these to make sense such as using max to find which was the max severity rating. I can get a "total" of a rating by simple addition by using a if statement, and division of the sum by the rating number itself. After which I just cannot wrap my head around it. What I need is a way to actually tie the max number and the second highest number to counts for each. One way I though was using the Large function like in Excel, but that does not exist in Survey123. Can I actually pull these three calculations off? Attached is my survey thus far.

‎04-13-2021

Hi Tim, I did work this out with ESRI tech support. Projection tool is the way to go. I did find a bug with using the project tool with feature dataset not carrying over the attachments. However, manual recreation of relationships is the way to go. I simply reprojected all my data, and am setting this back up.

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by DavidBuehler

Re: Force Web Browser version of Survey123 to open from Web Map with pushed attributes

Force Web Browser version of Survey123 to open from Web Map with pushed attributes

Re: Trouble with passing XY coordinates Collector via Arcade Expression

Re: Adding related table to ArcGIS Online feature layer

Re: Adding related table to ArcGIS Online feature layer

Compare two tables and copy over missing records

Compare and Add - Python

Re: Calculating Max and Second Max with counts of each in Survey123

Calculating Max and Second Max with counts of each in Survey123

Re: Best way to reproject data that has stand-alone table relationships