Latest Contributions by ChaimSchwartz3

Are you saying that the ESRI workgroup geodatabase (SQL server express) is supported in ArcGIS Pro? I'm pretty sure it's not, or at least it was not one year ago when I looked into this. ... View more

Thank you Robert, I hope to find the time to work on it. If anybody does find something similar I'd love to hear. Basically what I want is simmilar to this application: http://www.urisa.org/clientuploads/directory/Documents/ESIG/2016%20Winners/Nomination_URISA_ESIG_Award-Hamilton_SPIDER.p… , maybe with a small enhancement like this: https://plnkr.co/edit/XynXRS7c742JPfCA3IpE?p=preview . Thanks Chaim   ... View more

Did you see this 2012 thread ?GIS in Water/Wastewater Treatment Plants  It has some interesting details, but I too am looking for something up to date and maybe some more examples of the actual uses. ... View more

Thanks! for me running it in or outside of ArcMap definitely made a change. ... View more

Thanks Hillary  - your questions and Richard's answers were helpful to me as well. Since you were mentioning your program crashed, and since I believe adding the "if" check will only be able to improve your speed to some extent, I was wondering if you are running the code within an ArcMap session? When running Richard's code on a +500,000 records versioned .sde on my not-too-sophisticated computer at work it will also crash at times, but running it as a standalone script (Through IDLE) works. ... View more

Hi Richard, Thank you very much for this great post. Just wanted to let you know that using your code on a versioned .sde I was able to reduce the time for my workflow from 8:56 minutes (using model builder and field calculator) to 3:13 minutes, which is a great improvement, updating 19 fields for ~1000 records within a +500,000 records database. Thanks! Chaim ... View more

Helped me too, thanks! ... View more

I need this too, but will mention that if the "Dashboard Theme" in the Web App Builder answers all your needs (and it's pretty cool) then you can use that and use the WAB search widget. ... View more

Hi Ted, Yes I voted there... I read your discussion and totally agree with what you've written there. A FGDB ODBC or an editable SQL-lite would actually be even a preferred option for me since they don't include a 2 GB limitation, but any of these or the personal GDB seem to be just outside of ESRI's radar since (1) They're shifting people away from ESRI formats and products or (2) these are not usually enterprise solutions which, it seems, ESRI is more focused on. BUT, here's the thing: I work for an enterprise organization, we do have ORACLE and ArcGIS server as our foundation, but since typically an end-user like me does not have free access to these platforms that are centrally managed, we need a flexible and robust solution for anything that is not an enterprise big-deal implementation project. My message to ESRI would be - please keep us, the end users, in mind, because eventually it is us who drive the organization forward. ... View more

Just wondering, since we're considering similar stuff, why you won't connect directly from Access to your enterprise (Oracle?SQL Server?) via ODBC and run your queries, and thereby skip the pGDB step? ... View more