Latest Contributions by NikeshPatel

Hoping to find some help. I have a table of records that assigns a record of work to each individual Shape in a street centerline table where there is a common ID match (Made using SQL, below). There are multiple shapes for each record of work which means the SQL pulls in over 1000 records for only a 100 different record of work performed.  I want to condense that table so there is only one multipart feature for each record, but also maintain all the information from the record. If I use tools such as Dissolve, join features etc, all attribute information is lost.  SELECT Table A. WorkID Table B. EID Table C. Shape FROM Table A inner join Table B on Table A.[WORKID] = Table B.[WORKID] and TABLE A.[DESCRIPTION] like 'Quote' inner JOIN Table C ON Table C.[ID] = Table B.[EID] order by WE.[WORKORDERID] DESC Is there a way in SQL to join all the shape fields together, or what geoprocessing steps can I take to get to my end result? ... View more

I'm really trying to display a line chart in our Arcgis Dashboard that utilizes an expression counting the same value from multiple fields.  Submitter Choice 1 Choice 2 Choice 3 John 1 5 6 Amy 5 2 8 Alex 6 4 5 So, Ideally I would like visualize 5 has the highest count currently as users submit their surveys. I was trying to refer to the samples (https://arcg.is/38SEWWz), but I'm still left a little stumped).     Struggling for ideas ... View more