IDEA
|
This would be helpful to my organization as well...
... View more
01-28-2021
08:26 AM
|
0
|
0
|
3150
|
POST
|
I have a function that pulls the attributes from a feature layer and uses them in a popupTemplate. It works fine when returning the attributes for the top graphic in a layer, but does not return any of the attributes for any overlapped graphics in the same layer. It returns the OBJECTID, but nothing else unfortunately. Thanks in advance for any help. function getContent(graphic) {
var gr = graphic.graphic.attributes;
var sku = (gr.map_number) ? gr.map_number : '';
map = "'"+sku+"'";
console.log(graphic);
var options = {
query: {
mapid: map
},
responseType: "json"
};
//console.log(options.query.mapid);
var content = esriRequest("../intgeomap/mysqlMapData.php", options).then(function (response2) {
var g = response2.data[0];
var thmb = g.pub_thumb;
if (! thmb) { //check if thumb_graphic field is empty
var image_url = 'not-available.png';
} else {
var image_url = 'https://ugspub.nr.utah.gov/publications/mapthumbs/'+thmb;
}
var pubtitle = (g.pub_name) ? g.pub_name : ' ';
if (g.pub_author && g.pub_sec_author) {
authors = '<div style="margin-bottom:.5em;"><b>Authors:</b> '+g.pub_author+', '+g.pub_sec_author+'<br></div>';
} else if (g.pub_author) {
authors = '<div style="margin-bottom:.5em;"><b>Author:</b> '+g.pub_author+'<br></div>';
} else {
authors = '';
}
if (g.pub_publisher && g.series_id && g.pub_year) {
subTitle = '<div style="margin-bottom:.5em;"><b>Publisher:</b> '+g.pub_publisher+' | <b>Series ID:</b> '+g.series_id+' | <b>Date:</b> '+g.pub_year+'<br></div>';
} else if (g.pub_publisher && g.series_id) {
subTitle = '<div style="margin-bottom:.5em;"><b>Publisher:</b> '+g.pub_publisher+' | <b>Series ID:</b> '+g.series_id+'<br></div>';
} else if (g.pub_publisher && g.pub_year) {
subTitle = '<div style="margin-bottom:.5em;"><b>Publisher:</b> '+g.pub_publisher+' | <b>Date:</b> '+g.pub_year+'<br></div>';
} else if (g.series_id && g.pub_year) {
subTitle = '<div style="margin-bottom:.5em;"><b>Series ID:</b> '+g.series_id+' | <b>Date:</b> '+g.pub_year+'<br></div>';
} else if (g.series_id) {
subTitle = '<div style="margin-bottom:.5em;"><b>Series ID:</b> '+g.series_id+'<br></div>';
} else if (g.pub_year) {
subTitle = '<div style="margin-bottom:.5em;"><b>Date:</b> '+g.pub_year+'<br></div>';
} else if (g.pub_publisher) {
subTitle = '<div style="margin-bottom:.5em;"><b>Publisher:</b> '+g.pub_publisher+'<br></div>';
} else {
subTitle = '';
}
//var publisher = (g.pub_publisher) ? '<tr><td colspan="2">'+g.pub_publisher+ '<br><br></td></tr>' : ' ';
var purchase = (g.bsurl) ? '<div style="margin-bottom:.5em;"><a href="https://www.utahmapstore.com/products/'+g.series_id+' " target="_blank">Purchase Map <img src="https://geology.utah.gov/apps/geoindex/buy3.png" alt="click to purchase" width="16" height="16" border="0" align="absbottom"></a></div>' : ' ';
var pdf = (g.pub_url) ? '<div style="margin-bottom:.5em;"><a href="'+g.pub_url+'" target="_blank">Open PDF <img src="https://geology.utah.gov/images/pdf16x16.gif" alt="pdf" width="16" border="0" align="absbottom"></a></div>' : ' ';
var gis = (g.gis_data) ? '<div style="margin-bottom:.5em;"><a href="https://ugspub.nr.utah.gov/publications/'+g.gis_data+'" target="_blank">Download GIS Data <img src="https://geology.utah.gov/images/zip16x16.gif" alt="GIS zip file" width="16" height="16" border="0" align="absbottom"></a></div>' : ' ';
var usgs = !(g.pub_url) ? '<div style="margin-bottom:.5em;"><a href="https://ngmdb.usgs.gov/ngm-bin/ngm_compsearch.pl" target="_blank">Search USGS for pdf <img src="https://geology.utah.gov/images/pdf16x16.gif" alt="pdf" width="16" border="0" align="absbottom"></a></div>' : ' ';
var popupText = '<div style="height:100%; line-height:1.3em;">'+'<div><img style="text-align:center;display:block;margin-left:auto;margin-right:auto;" src="'+image_url+'" border="0" width="225" ></a></div><hr>'+'<div style="margin-bottom:.5em;">'+'<b>'+pubtitle+'</b>'+'<br></div>'+authors+subTitle+'<hr>'+purchase+pdf+gis+usgs+'</div>';
return popupText;
});
return content;
}
... View more
10-14-2020
10:48 AM
|
0
|
0
|
334
|
POST
|
I am having this issue as well. Were you able to solve this?
... View more
10-14-2020
08:21 AM
|
1
|
1
|
809
|
POST
|
Here is another error that ArcMap 10.6.1 and ArcGIS Pro 2.3 says. It happens when I try to refresh the connection to the sde after the edit session stops working and all of the features disappear: Underlying DBMS error [no connection to the server ::SQLSTATE=] [sdename.sde.GDB_Items]
... View more
01-24-2019
02:55 PM
|
0
|
0
|
1529
|
POST
|
It is running on a linux server with 8gb RAM, 2 cores. It is not just postgresql installed. Python/Apache/PHP are also installed on the server. The geodatabase version is 10.6.1 (release: 106101 sdesvr_rel_low: 93001). I'm using ArcMap 10.6.1 to edit.
... View more
01-24-2019
12:50 PM
|
0
|
0
|
1529
|
POST
|
Thanks for looking into this, here is our environment: PostgreSQL 10.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit
... View more
01-24-2019
12:12 PM
|
0
|
2
|
1529
|
POST
|
Shot in the dark here. Does anyone know why I would be getting the following postgresql log error? I have an enterprise geodatabase loaded on postgresql on linux and I get this error even when doing a simple editing task for more than ten minutes or so. The feature class I create then get's corrupted and crashes arccatalog. 2019-01-23 13:34:02.425 MST [8901] LOG: execute sde_1548275642_3809_161: DECLARE sdecur_3809_161 BINARY CURSOR WITH HOLD FOR select V__68.shape , V__68.objectid from (SELECT /* ArcSDE NORMAL_FILTER */ b.objectid,b.shape FROM ugssde.sde.forfun b WHERE NOT EXISTS (SELECT * FROM ( SELECT SDE_DELETES_ROW_ID,SDE_STATE_ID FROM sde.d68, sde.sde_state_lineages l WHERE SDE_STATE_ID = 0 AND DELETED_AT = l.lineage_id AND l.lineage_name = $1 AND l.lineage_id <= $2 ) d WHERE b.objectid = d.SDE_DELETES_ROW_ID ) UNION ALL SELECT a.objectid,a.shape FROM sde.a68 a INNER JOIN sde.sde_state_lineages l ON a.SDE_STATE_ID = l.lineage_id WHERE NOT EXISTS (SELECT * FROM ( SELECT SDE_DELETES_ROW_ID,SDE_STATE_ID FROM sde.d68, sde.sde_state_lineages l WHERE DELETED_AT = l.lineage_id AND l.lineage_name = $3 AND l.lineage_id <= $4 ) d WHERE (a.objectid = d.SDE_DELETES_ROW_ID) AND (a.SDE_STATE_ID = d.SDE_STATE_ID) ) AND (l.lineage_name = $5 AND l.lineage_id <= $6) ) V__68 where ((V__68.shape && $7) = 't') 2019-01-23 13:34:02.425 MST [8901] DETAIL: parameters: $1 = '230', $2 = '255', $3 = '230', $4 = '255', $5 = '230', $6 = '255', $7 = '380000000500000008001000110F0000200000000000000092AAF9B6A4049DE28EAFB11482CCBF02000082CCBF02C2CCBF020000C2CCBF02' 2019-01-23 13:34:02.432 MST [30562] LOG: server process (PID 8901) was terminated by signal 11: Segmentation fault 2019-01-23 13:34:02.432 MST [30562] DETAIL: Failed process was running: DECLARE sdecur_3809_161 BINARY CURSOR WITH HOLD FOR select V__68.shape , V__68.objectid from (SELECT /* ArcSDE NORMAL_FILTER */ b.objectid,b.shape FROM ugssde.sde.forfun b WHERE NOT EXISTS (SELECT * FROM ( SELECT SDE_DELETES_ROW_ID,SDE_STATE_ID FROM sde.d68, sde.sde_state_lineages l WHERE SDE_STATE_ID = 0 AND DELETED_AT = l.lineage_id AND l.lineage_name = $1 AND l.lineage_id <= $2 ) d WHERE b.objectid = d.SDE_DELETES_ROW_ID ) UNION ALL SELECT a.objectid,a.shape FROM sde.a68 a INNER JOIN sde.sde_state_lineages l ON a.SDE_STATE_ID = l.lineage_id WHERE NOT EXISTS (SELECT * FROM ( SELECT SDE_DELETES_ROW_ID,SDE_STATE_ID FROM sde.d68, sde.sde_state_lineages l WHERE DELETED_AT = l.lineage_id AND l.lineage_name = $3 AND l.lineage_id <= $4 ) d WHERE (a.objectid = d.SDE_DELETES_ROW_ID) AND (a.SDE_STATE_ID = d.SDE_STATE_ID) ) AND (l.lineage_name = $5 AND l.lineage_id <= $6) ) V__68 where ((V__68.shape && $7) = 't') 2019-01-23 13:34:02.432 MST [30562] LOG: terminating any other active server processes 2019-01-23 13:34:02.433 MST [792] WARNING: terminating connection because of crash of another server process 2019-01-23 13:34:02.433 MST [792] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2019-01-23 13:34:02.433 MST [792] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2019-01-23 13:34:02.433 MST [22353] WARNING: terminating connection because of crash of another server process 2019-01-23 13:34:02.433 MST [22353] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2019-01-23 13:34:02.433 MST [22353] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2019-01-23 13:34:02.434 MST [790] WARNING: terminating connection because of crash of another server process 2019-01-23 13:34:02.434 MST [790] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2019-01-23 13:34:02.434 MST [790] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2019-01-23 13:34:02.442 MST [30562] LOG: all server processes terminated; reinitializing 2019-01-23 13:34:02.457 MST [12107] LOG: database system was interrupted; last known up at 2019-01-23 13:32:21 MST 2019-01-23 13:34:02.495 MST [12107] LOG: database system was not properly shut down; automatic recovery in progress 2019-01-23 13:34:02.496 MST [12107] LOG: redo starts at 0/BD9C2368 2019-01-23 13:34:02.497 MST [12107] LOG: invalid record length at 0/BD9E0E78: wanted 24, got 0 2019-01-23 13:34:02.497 MST [12107] LOG: redo done at 0/BD9E0D50 2019-01-23 13:34:02.497 MST [12107] LOG: last completed transaction was at log time 2019-01-23 13:33:51.462835-07 2019-01-23 13:34:02.508 MST [30562] LOG: database system is ready to accept connections
... View more
01-23-2019
01:08 PM
|
0
|
12
|
2519
|
POST
|
Yeah, I guess it's time for tech support. Have you ever had to use the recovery tool? I've followed the documentation line-by-line and it doesn't work for me. Even when trying to use the most basic recovery parameters.
... View more
08-30-2017
10:01 AM
|
0
|
1
|
1070
|
POST
|
Thanks, but I couldn't get that to work either. Not sure what's going on. Do you know if there are more detailed error logs for this kind of issue?
... View more
08-30-2017
09:13 AM
|
0
|
3
|
1070
|
POST
|
Forgot to add that on my first post...my bad. Here it is: restoredatastore --store relational --target db_7gyct-20170824055959004.backup --source-loc \\localhost\DataStoreBackup\relational\dbbackup\db_7gyct-20170824055959004 --data-dir C:\Users\Administrator\Documents\DataStoreRestore --server-url http://<servername>/server --server-admin *** --server-password **** I've tried multiple variations of the --server-url parameter and get the same error.
... View more
08-30-2017
08:26 AM
|
0
|
2
|
1070
|
POST
|
I'm attempting to restore my datastore using the restoredatastore command line utility and I need some help with getting the right syntax for the command I'm writing. When I run it I keep getting a "failed to generate token" as if my password is wrong, but I think the real issue is how I'm writing the url parameter. Does anyone have experience running this utility successfully?
... View more
08-29-2017
04:45 PM
|
0
|
8
|
1657
|
POST
|
Is Pro able to query data from cached map image layers? I haven't been able to figure it out. I can get popups to work when a service isn't cached, but not when it is cached. I can also get cached service popups to work inside of agol. Here are the two services for example: Cached: Layers (MapServer) Not Cached: Geol_30_60 (MapServer)
... View more
08-01-2017
12:42 PM
|
1
|
0
|
396
|
POST
|
I'm going through the process of launching arcgis enterprise on amazon using esri's cloud formation templates and I'm running into a problem. I'm trying to purchase an ssl certificate from godaddy, but they need a csr before they'll issue it. The problem is that I can't get the csr until after the server is set up because the csr is acquired through iis manager. How do I get a csr for the ssl when I can't launch the template stack without an ssl? I'm probably doing something wrong, so I appreciate your advice.
... View more
07-20-2017
05:12 PM
|
2
|
3
|
1267
|
POST
|
I'm trying to develop a map that clusters points from more than one FeatureLayer. Clustering points from one FeatureLayer is simple, but I can't get overlapping points from different FeatureLayers to cluster. Is this possible? Thanks!
... View more
04-27-2016
07:20 AM
|
0
|
1
|
1412
|
POST
|
Has this enhancement been implemented yet? I'm trying to develop a workaround to get rid of the all option, but having difficulty. Thanks.
... View more
10-28-2015
10:38 AM
|
0
|
3
|
453
|
Title | Kudos | Posted |
---|---|---|
1 | 10-14-2020 08:21 AM | |
1 | 08-01-2017 12:42 PM | |
2 | 07-20-2017 05:12 PM |
Online Status |
Offline
|
Date Last Visited |
09-01-2022
04:00 PM
|