Latest Contributions by BrianO_keefe

So I work for a municipal government. We have begun the adoption of ESRI products over the last several years. We have our Police department on board, some of the smaller departments, and we have plans to eventually get everyone on the same page. But we are starting to run into a problem and I'm wondering if anyone knows if there is a fix or a solution that maybe I'm just unaware of. Our Police department has purchased the bulk of our credits, but our Planning Department has moved in Community Analyst and looking at thousands of credits a year on reporting. We have our Streets and Stormwater people investigating options that would also cost credits, and Fire and... (btw I see what you did there, ESRI... nice little GIS economy development) The point being that I can foresee a moment when Police go to consume credits, and technically they should have them available, but our Planning Department has accidentally consumed into the Police credits and now there is not enough. I'm wondering (hoping) that there is some method for divvying up credits and making sure that Group A doesn't consume Group B's credits. Please tell me there is such a mechanism in place or at least lie to me... ... View more

We've got a truly messed up city. Don't get me wrong, I love it... but I hate Addressing for it sometimes. Some of our streets are LEGITIMATELY named "1234 NORTH STREETNAME AVENUE EAST" whereas others are "4321 SOUTH STREETNAME EAST AVENUE" and it makes my GIS group cringe everytime we hit "glitches" in our various systems due to this insanity. I have recently started phase 1 of my "CREATE AN AUTHORITATIVE ADDRESS DATABASE USING THE LGM" where I have now cleaned up roughly 200,000 georeferenced points for rooftop centroids and pushed that list to the LGM SDE.SiteAddressPoint and now I have built an Address Locator - Single House Locator. I pushed ALL of my addresses based on field names into the LGM. So whereas I have an address 1133 South Wheeling Avenue East, I need the locator find it whether they enter it as "Avenue East" or "East Avenue." Can anyone point me in a direction here? Do I use the MasterStreetName table? ... View more

I have several webmaps for various departments here at the city where I work. We have the parksfinder app, a watershed app, a city council finder, and more. What I'm finding is that my workload almost doubles because I set these maps up. The departments that manage this data need me to provide updates, and correct errors, and more on a regular basis. For the ParksFinder I built a custom Parks Editor map in the WAB. Locked it down. Now the Parks department can open a webmap, click on a park, click edit, and fix the data. This is great except I had to use one of our ESRI AGOL licenses so the Parks group could update ONE map. That isn't going to work moving forward. Another of our maps is in need of regular updates now. I'm trying to minimize MY time involved in order to speed up the process. I mentioned to our DBA what I was working on and he thinks he can whip up a DB View table that an Excel sheet can connect to. This way I can just send the Excel sheet to the right person and they can instantly update the Attributes for certain feature classes on this map. I'm trying to find out if anyone has a better method? If you have map data that needs modification, but you don't have the GIS personnel or licenses to hand out as needed, what do YOU DO to update minor (meaning non-spatial) aspects of your data? ... View more

I work with our local police department to update the Sex Offender web map on a (fairly) monthly basis. What happens is as follows: The Officer responsible for maintaining this data updates the Shapefile of Offenders They save it to a specified folder and open a service ticket requesting the map be updated The service ticket arrives in my e-mail I double click the MODEL I built in Model Builder The Model asks for the location and name of the updated Shapefile I copy-n-paste the URL from my Ticket to the Model It truncates the current Offender SDE database table It appends the new Shapefile to the SDE database table I close the ticket and am done What I would LIKE to do and just don't know where to start with this is... take my model and convert it to a Python script. Then SOMEHOW (and this is where my question comes in) offer a web-front / web-form where the officer INSTEAD of opening a Service Ticket, just opens a web page... pastes the URL to the updated Shapefile (or uploads the Shapefile?)... and hits DONE and it runs my script using that URL to the Shapefile (or the uploaded Shapefile) and updates the database. Once the database is updated the updates propagate smoothly to the web map. Has anyone done anything like this already? Convert a Model to a Web Form? ... View more

I was able to do this in the BETA... is there something I'm missing? Am I going to have to manually change the HTML to get a MAILTO link?! ... View more