Latest Contributions by JosephElfelt1

I developed code that converts the Hopkins cumulative counts into a count of new COVID cases per day for each USA county. This daily case count data is saved in one csv file per month. These csv files are designed to be easy to import into GIS or spreadsheet software and are free for all to use. The only limitation is that your use must be non-commercial. This daily count of new cases per county will be updated each night as the pandemic continues. Here is a PDF file with a bit more background, links to the csv data files and a link that will open an interactive map. https://mappingsupport.com/p2/help/COVID19-new-cases-per-day.pdf Joseph Elfelt Twitter: @mappingsupport https://mappingsupport.com ... View more

I produce maps using Leaflet and the ESRI Leaflet plugin. The state of Arizona has a layer at https://arcgisserver2.morpc.org/arcgis/rest/services/legislative/OhioStateHouse/MapServer/39 that has boundary data for the state legislature districts and supports dynamiclayers. Below is a link to the map I produced using the above layer. My code makes use of the dynamiclayers support to style the fill, lines and labels. This map works fine. https://mappingsupport.com/p2/gissurfer.php?center=32.178995,-110.957794&zoom=10&basemap=USA_basemap&overlay=AZ_state_house_fill,AZ_legislature_yellow_line,AZ_legislature_black_line,AZ_legislature_label&txtfile=https://mappingsupport.com/p2/political/arizona/arizona_legislature.txt However there are a few states where my code is unable to convince the state server to produce dynamic labels even though the server will restyle fill and lines. It is only trying to produce dynamic labels from a few servers that is causing me grief. Hence my question of whether a server admin can turn on dynamiclayers support *except* for dynamic labels. Here is an Ohio layer where I am having this problem. https://arcgisserver2.morpc.org/arcgis/rest/services/legislative/OhioStateHouse/MapServer/0 The following tile call to the Ohio server returns a blank tile. https://arcgisserver2.morpc.org/arcgis/rest/services/legislative/OhioStateHouse/MapServer/export?bbox=-9486140.958303515,5057397.1555377,-9173054.890447434,4932040.429150009&size=1024,410&dpi=96&format=png24&transparent=true&bboxSR=3857&imageSR=3857&dynamicLayers=[{"source":{"type":"mapLayer","mapLayerId":0},"drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,0,0,0],"outline":{"type":"esriSLS","style":"esriSLSDOT","color":[0,0,0,0],"width":0}}},"showLabels":true,"labelingInfo":[{"labelPlacement":"esriServerPointLabelPlacementAboveRight","labelExpression":"\"H-\" CONCAT [DISTRICT]","useCodedValues":false,"symbol": {"type": "esriTS","color": [0,0,0,255],"backgroundColor": [0,0,0,0],"borderLineSize": 0,"borderLineColor": [0,0,0,0],"haloSize": 1.5,"haloColor": [255,255,255,255],"verticalAlignment": "bottom","horizontalAlignment": "left","rightToLeft": false,"angle": 0,"xoffset": -20,"yoffset": 0,"kerning": true,"font": {"family": "Arial","size": 12,"style": "normal","weight": "bold","decoration": "none"}}}]}}]&layers=show:0&f=image Below is the dynamiclayers portion of the above tile call. {"source":{"type":"mapLayer","mapLayerId":0}, "drawingInfo":    {"renderer":       {"type":"simple",       "symbol":          {"type":"esriSFS",          style":"esriSFSSolid",          "color":[0,0,0,0],          "outline":{"type":"esriSLS","style":"esriSLSDOT","color":[0,0,0,0],"width":0}          }       },       "showLabels":true,       "labelingInfo":[          {"labelPlacement":"esriServerPointLabelPlacementAboveRight",          "labelExpression":"\"H-\" CONCAT [DISTRICT]",          "useCodedValues":false,          "symbol":             {"type": "esriTS",             "color": [0,0,0,255],             "backgroundColor": [0,0,0,0],             "borderLineSize": 0,             "borderLineColor": [0,0,0,0],             "haloSize": 1.5,             "haloColor": [255,255,255,255],             "verticalAlignment": "bottom",             "horizontalAlignment": "left",             "rightToLeft": false,             "angle": 0,             "xoffset": -20,             "yoffset": 0,             "kerning": true,             "font":                {"family": "Arial",                "size": 12,                "style": "normal",                "weight": "bold",                "decoration": "none"                }             }          }       ]    } } Is it me? Is it the server? Can anyone shed light on why some servers that support dynamic layers refuse to produce dynamic labels? Joseph Elfelt Twitter: @mappingsupport https://mappingsupport.com ... View more

A few weeks ago I got interested in producing a COVID map that showed recent trends in cases and deaths *per day* going back 14 days. Of course the first problem was that there was no handy data set I could grab that had case and death counts by day. To solve that problem I wrote code to process the JHU cumulative count data into daily counts. That code automatically runs each night and given that this process has been working well for a bit now, I feel comfortable sharing this resource. This daily count data can be used by anyone for any non-commercial purpose. If you use this data in a project please credit: Joseph Elfelt, MappingSupport.com (linked to https://mappingsupport.com) The daily counts my code produces are in a delimited text file at https://mappingsupport.com/p2/disaster/coronavirus/_covid_prior_14_day_data.txt The field delimiter is ^. Since there are commas in the data, do not convert ^ to a comma. Column definitions: 1. Code. 1=county, 2-state, 3-USA, 4-province/territory, 5-country (I have to tweak my software to add the country value for Canada) 2. Used to sort the data 3. Name of location. 4. 14 day linear regression. cases, deaths 5. 7 day linear regression. cases, deaths 6. latitude longitude centroid The next 14 columns have a date label in the file. The value in each ‘cell’ is cases, deaths. The last column shows the 14 day totals for cases, deaths. Each night just after midnight Pacific time my code runs and the oldest date column is deleted and a new date column is added. Finally, if you are curious, below is a link to a map I produced. Click the basemap button to see a list of the overlays you can turn on/off. When the map opens each symbol represents a county where the number of cases is trending up over the last 7 days. How much of the upward trend in cases is explained by increased testing? Great question! Legend Red - upward trend Green - downward trend Triangle - Prior 7 days Circle - prior 14 days Open the map: https://mappingsupport.com/p2/gissurfer.php?center=36.734061,-99.052734&zoom=4&basemap=USA_basemap&overlay=County_boundaries,State_boundary,County_bad_trend_in_cases&txtfile=https://mappingsupport.com/p2/disaster/coronavirus/covid_14_day.txt Joseph Elfelt Redmond, WA Twitter: @mappingsupport https://mappingsupport.com ... View more

While I am generally knowledgeable about using the ArcGIS Server REST API to work with dynamic MapServer layers, this is the first time I have tried to turn on labels. Below is a call for a tile that will display a single green circle. The value of POITYPE is Visitor Center. I would like the label ‘Visitor Center’ to appear near the green circle. Alas, I have been unable to conjure up just the right syntax to make that happen. What am I missing? https://mapservices.nps.gov/arcgis/rest/services/NationalDatasets/NPS_Public_POIs/MapServer/export?bbox=-12205302.24789184,4667760.897033789,-12200410.278081588,4665802.198183983&size=1024,410&dpi=96&format=png24&transparent=true&bboxSR=3857&imageSR=3857&dynamicLayers=[{'source':{'type':'mapLayer','mapLayerId':0},'definitionExpression':"upper(POITYPE)='VISITOR+CENTER'",'drawingInfo':{'renderer':{'type':'simple','symbol':{'type':'esriSMS','style':'esriSMSCircle','color':[0,255,0,255],'size':8,'outline':{'color':[0,0,0,255],'width':1.5}}}},'showLabels':true,'labelingInfo':{'labelPlacement':'esriServerPointLabelPlacementAboveRight','labelExpression':[POITYPE],'useCodedValues':false,'symbol':{color:[0,255,255,255],'size':8,'fontFamily':'Arial','fontStyle':'normal','fontWeight':'bold','fontDecoration':'none'}}}]&layers=show:0&f=image Joseph Elfelt @mappingsupport https://mappingsupport.com ... View more

I curate a massive list of USA-based ArcGIS server addresses. Earlier today I posted an update that includes a section listing the public-facing FeatureServer layers I know about that meet the following two criteria. 1. COVID-19 related 2. Cover the USA If you know of any MapServer or FeatureServer or WMS layers that meet *both* of the above criteria, please let me know and I will add them to the list. I will include a note identifying the source of the data or the party doing the data collection. The COVID-19 layer list starts at page 7 of this PDF file: https://mappingsupport.com/p/surf_gis/list-federal-state-county-city-GIS-servers.pdf I included a link to the GISsurfer map (Lealet + GIS) I produce that can display these layers. Joseph Elfelt Redmond, WA Twitter: @mappingsupport https://mappingsupport.com ... View more

I just finished adding a big bunch of USA-based government ArcGIS server addresses to the list I curate. There are now 2,200+ addresses for ArcGIS servers from the federal level down to the city level. Most of the recent updates were for counties and cities.  This is a curated list with weekly updates that fix or flag any bad links. Open the list (PDF file): https://mappingsupport.com/p/surf_gis/list-federal-state-county-city-GIS-servers.pdf And in doing that work I realized there are several ways that anyone can help improve this list. Of course if you know of any additional ArcGIS server addresses (not portals!) then I would enjoy adding those to the list. But here are a couple less obvious ways that anyone can help. 1. County *or* city It is certainly possible that I mistakenly listed a server address that mainly has county data under the ‘City’ heading for that state - or vice versa. If you happen to spot such a mistake, please let me know. My contact link is in the list. 2. County *and* city Some counties and cities have pooled their resources and one or the other will operate a GIS server with data for both jurisdictions. When that happens I would like to include a note in the list linking those jurisdictions. To clarify, I would like to identify servers with a significant (i.e. more than just a few layers) amount of data for more than one jurisdiction. And thanks to Micah Babinski for a real nice article in the national URISA newsletter. I belong to WAURISA but not the national group. As a result I only happened to recently see the article from earlier this year. See p.12. https://www.urisa.org/clientuploads/directory/Documents/The%20GIS%20Professional/2019/MayJune2019.pdf Finally, I am continuing to work on the beta version of GISsurfer v2.0. The goal of this beta version is to let anyone surf ArcGIS data almost as easily as you surf the internet. No GIS savvy required!  For the curious among you the following link is for a page with brief instructions and a link to the beta code. A new feature in the beta version is the ability to make a link that (1) starts GISsurfer and (2) automatically opens the sidebar and displays the table of contents for an ArcGIS server. GISsurfer beta info and link: https://mappingsupport.com/p2/gissurfer-beta.html Joseph Elfelt Twitter: @mappingsupport https://mappingsupport.com ... View more

I am working with a MapServer layer that support dynamic layers.  The data is tornado damage going back a number of years.  My goal is to select only 2019 data. This tile call displays all the data: https://services.dat.noaa.gov/arcgis/rest/services/nws_damageassessmenttoolkit/DamageViewer/MapServer/export?bbox=-11767…  In order to select 2019 data I add the following dynamicLayers parameter with a definition expression: &dynamicLayers=[{"source":{"type":"mapLayer","mapLayerId":0},"definitionExpression":"stormdate > DATE '2019-01-01'"}] Here is the tile call with the dynamicLayers parameter added.  This call displays...nothing. https://services.dat.noaa.gov/arcgis/rest/services/nws_damageassessmenttoolkit/DamageViewer/MapServer/export?bbox=-11767633.378559455,5058296.783799826,-9001224.450862357,3957603.5764932865&size=1131,450&dpi=96&format=png24&transparent=true&bboxSR=3857&imageSR=3857&layers=show:0&f=image&dynamicLayers=[{"source":{"type":"mapLayer","mapLayerId":0},"definitionExpression":"stormdate > DATE '2019-01-01'"}] Where did I mess up? ... View more