Latest Contributions by PanGIS

Thank you Joshua Bixby,  I need to covert the first column into the last (string to numeric). I attempted the Replace because I thought I could simplify it but, as you pointed out.....I did not. I cannot convert them to 0 because it will false my analysis (they are temp and other values) I need a NO VALUE ... View more

Hi Dan,  Thank you for your reply. I did not explained myself well. The original table has a field (string type) with numbers and some "nan" values. When I say nan I mean the word "nan". Since I need to convert this values into numbers I remove the word nan by using the python exp.: !ACmodeString!.replace("nan","<Null>"). Now I have that string field populated by numbers and <Null> records. What I need to do is to  convert all these values into integer in a new field (short type). I'll try to upload some data as soon as possible. Here a not very nice example: ... View more

George Thompson Asrujit SenGupta It works guys! thank you!!!! I added some new fields, also the shape so it will show the geometry, and the symbology works. Another question if I may, I am sorry to stress out too much: The query that works is this one: SELECT b.objectid, b.globalid, b.shortname, b.longname, b.shape, r.timestamp, r.room, r.acmode, r.actemp FROM BLKJ_Building b, Readings r WHERE b.shortname = r.room I would like to select the last time stamp only and a range. (the range ideally for a time slider) for last time stamp I've tried this one, but doesn't work. Any idea of what should be the correct one? SELECT b.objectid, b.globalid, b.shortname, b.longname, b.floor, b.shape, MAX(r.timestamp), r.room, r.acmode, r.actemp FROM Building b, Readings r WHERE b.shortname = r.room ... View more

No, it does not meet the minimum requirements. I had a similar issue when I upgraded to server 10.6.1 and my PG was 9.5.10: I was not able to register my database into server. I would recommend to upgrade. ... View more

Hi, have you checked whether your PostGRE vesion meets the minimum requirement for 10.7? PostgreSQL database requirements for ArcGIS 10.7.x and ArcGIS Pro 2.4—System Requirements | ArcGIS Desktop  ... View more

Hi Ahmed, in a previous message you said " Hi Christian, Thanks for your response. I created an online account with my gmail id. Then I purchased the product (ArcGIS Pro 2.4). Got an activation link from Esri and thus did that.    ----> what does the activation link says and what have you done? Afterwards, I downloaded the installer file from esri and installed it. But when I tried to open that I got that message...……" ... View more

What does the Esri Activation email say? Usually, you find all the info there. What kind of license have you purchased? ... View more

Also, when you purchase a license, you should receive an authorization email that allows you to convert your public or create a new organizational account. Have you done it? ... View more

It might be useful to see the following: go to https://marketplace.arcgis.com and login with the agol credential that are linked to the ESRI authorization. Go to Console is ArcGIS PRO listed? if so you can go to manage license and assign the license to your account. ... View more

Great Xander! It works! Thank you ... View more

Thank you for this great feature! Xander Bakker‌ I have a problem though, I tried to get the popup info for features in two different layers overlapping a polygon. this is my code. It works well only if one layer only overlays: // test intersect var intersectLayer =Intersects(FeatureSetByName($map,"Layer1"), $feature) var intersectLayer2 =Intersects(FeatureSetByName($map,"Layer2"), $feature) for (var f in intersectLayer){ return  "Layer 1 info" + "\x0d\x0a" +"Name: " + f.Name + "\x0d\x0a" +"Type: " + f.Type } for (var f in intersectLayer2){ return  "Layer 2 info" + "\x0d\x0a" + "Name: " + f.Name }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Results: If the polygon intersects layer1 and layer2  only layer 1  is shown  (layer1 is the house icon, layer2 the dot) If the polygon intersects layer2: it's ok Here I have even more than one features in layer 2, but still only layer1 shown. if I invert the two variables // test intersect var intersectLayer =Intersects(FeatureSetByName($map,"Layer1"), $feature) var intersectLayer2 =Intersects(FeatureSetByName($map,"Layer2"), $feature) for (var f in intersectLayer2){ return  "Layer 2 info" + "\x0d\x0a" + "Name: " + f.Name }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ for (var f in intersectLayer){ return  "Layer 1 info" + "\x0d\x0a" +"Name: " + f.Name + "\x0d\x0a" +"Type: " + f.Type } I get info for only one dot in layer2: Thanks! ... View more