Latest Contributions by JayHodny

Hello!  I am developing a simple bus route map and app.  I am trying to change the color of the bus stop name to match the bus stop symbol and route color.  I am adding HTML in the field values in a field called 'Description' which has the bus stop names.  In the screen shot of the attribute table from ArcGIS Pro, the red and green (not shown) snippets seem to work and change the text to red or green.  I am getting nowhere with the orange color.  I have tried hexadecimal values, <font color="...> etc., nothing gives me an orange text color.  The text stays black (see the second screen shot as a conceptual example). I do not have much HTML experience.  I don't know if the <clr> tag works for the red, blue, and green colors only?  Perhaps what I am trying to do in the attribute table in ArcGIS Pro can't be done?  The color formatting would need to extend from Pro to an AGOL feature service for a web map and app too.  Many thanks in advance. ... View more

Hello.  We are working with spatial views created in MS SQL Server Management Studio.  We have linked servers allowing us to retrieve data (e.g., code violations) from other SQL databases and then join these data with parcel information retrieved from our ArcGIS sde SQL database.  We then publish the view as AGOL hosted feature service (for public access as we do not have ArcGIS Enterprise/Portal yet).  We noticed the published feature service does not honor the record count of the spatial view feature class when the service is published from ArcGIS Pro.  If we pull the view into Desktop and publish to AGOL, the record count is honored.  Desktop prompts us for a unique ID field during the “drag and drop” into the map frame from Catalog – Pro does not prompt for a unique ID.  We are creating a dynamic unique ID attribute in the spatial view query on the server-side to ensure all records are returned.    We don’t understand why publishing from Pro would drop records - which is undesirable.  We do not know how to remedy such an occurrence, so we publish from Desktop as a work around.  We theorize that multiple records having identical information in each field (e.g., more than one of the same code violations in the same parcel, etc.) are being treated as one record when publishing to AGOL via Pro, ignoring the dynamically calculated unique ID values.  We want to show all the code violations, even if they are the same, by parcel.  Any thoughts? ... View more

Please define the 'search tolerance' function (what is it, what does it do, units, etc.) in the configuration panel.  Also, why are the feature services ordered opposite in the app as opposed to the web map Table of Contents?  Is there a way to arrange the services in the list?  Thanks! ... View more

I have a rental permit dataset.  In retrieving the data through an SQL spatial view I calculate the number of days until the permit will expire or has expired.  Positive values indicate days until the permit expires.  Negative values are the number of days since the permit expired.  I would like to use a pie chart to show the number and percent of expired permits that are 30, 60, 90, and 180+ days past their expiration date.  Is this possible?  I have tried several combinations of filters, slice configurations, etc. with no luck.  Thanks in advance. ... View more

Hello GeoNet community.  I have a script where I am pulling data from a vendor's database through their API and populating a CSV file.  Is there a way to pass these data into an existing feature service hosted on ArcGIS Online, so the results of the query are displayed in a web ArcGIS application?  The CSV file would be updated every minute.  Thanks in advance. ... View more