Latest Contributions by danan

This would be great for both relationships and joining.  So many times I have to make a temporary copy of a table just so I can create my own join key by calculating 2 or more fields together.  All RDBMS systems can do this, so many of their tables do no have a single unique identifier that will join well, most use joins with compound keys ... View more

We look forward to get this functionality in SDE at earliest convinience. Our workflows require read-only users not being able to create SDE versions. ... View more

I just recieved ESRI's mass mailing about the cloud. They claim to be first. Thats a bald face lie. Cloud GIS is provided by lots of people including, well CouldGIS.com. I digress. There are OGC standards for cloud GIS computing and using multithreaded worker applications for geoprocessing. The "cloud" part can be centralized or decentralized (for example the method the SETI utiliyzes is decentralized). There are already methods to provide what you are looking for, it just isnt in the ArcGIS toolkit. I think you would be better served to find a data cloud provider and not bother petitioning ESRI. The lock-in to their data types and software really limits what you can do with your data. ArcGIS online is what it is, but what you are searching for is out there. Thanks Jason. Haven't read the mailing you're referencing. Could be a garden variety half truth of the sort one often finds in marketing. True in some limited sense and/or unstated sub-context. Par for the course in promotional lit from most vendors. Marketers and developers aren't always on the same page. So I might give them a pass there. Glad to hear there are OGC standards for GIS cloud computing that vendors can be judged against and held accountable to. That's encouraging. Customers can and should petition vendors to satisfy their business needs. While it may be naive to believe we'll get everything we ask for we may at least get a portion of it. So it's worthwhile to try. A good case can be made for customer activism catalyzing innovation. SETI is an interesting case of citizens donating spare compute time to advance non-commercial research. Perhaps not so interesting to for-profit entities like cloud vendors. In an era when NASA receives only one half of one penny out of every tax dollar (I know SETI is now private and no longer associated with NASA), I wish there were more opportunities to donate spare compute time to it and other worthwhile non-profit research causes. A product like ArcGIS Online often gets marketed as a way for citizens to donate their "cognitive surplus" (to borrow a term from Clay Shirky). But not computational surplus. ... View more

datamodel #gdb tools With the loss of XRay for use with ArcGIS Pro and the introduction of some of the new data modeling extensions like Utility Network Extension.  The lack of tooling in ArcGIS to at least create/export a reference document of the data model for people outside the GIS/ICT space to validate is quite frustrating.  Esri have done an excelent job in ArcGIS Pro for updateing schema using the Design dialogs and tools, but exporting the information to an HTML document or Visio would be a fanstatic Add-in to have (something like the old ArcGIS Diagrammer)       Enterprise Architect from Sparx Systems is an option, but a little hard to justify the costs (of both licensing and ICT support) just to export the data model to a human readable form. ‌ ... View more

I like the idea of being able to learn at home, there is little time at work and classes are expensive. ... View more

Hi, thanks for your questions.  ArcGIS Online is not a SaaS version of desktop, it provides organizations with a cloud-based, collaborative content management system for maps, apps, data, and other geographic information.  It's about making the organizations GIS, maps and data available to everyone.  With it you can make and use the organizations maps and data in your work.  Think of it as empowering everyone to participate. One good place to start with what it can do for an organization is with the detailed help system and videos.  Your organization can also participate in the beta program to see first hand what it can do.  Start here with the help system: http://help.arcgis.com/en/arcgisonline/help/010q/010q0000007m000000.htm The ArcGIS Online blog is also full of good info: http://blogs.esri.com/esri/arcgis/ -Paul- Will have to check out the videos and learn more about how this fits into the Esri ecosystem. Thanks for explaining its current incarnation: as a collaboration tool, a publishing tool (with basic editing capabilities) and a medium for getting geospatial data, maps, and apps into the hands of non-GIS professionals. That still squares with what I've heard about Desktop's place--where you go for heavy-duty authoring, analysis, etc. Could ArcGIS Online evolve into a SaaS offering with Desktop feature parity? Or would current lack of bandwidth make this problematic? Those are rhetorical questions as this would be future dev. It would be interesting to apply the Subscription model to a Desktop-Like-Object in the Cloud. No Big Licensing Costs Up Front would break down barriers to heavy-duty analysis work, etc. I've been thinking a lot about metered licensing that would mirror and complement metered infrastructure. But maybe I'm thinking about it the wrong way. And now I'll get off my virtual soap box. 🙂 ... View more

Jake, does this mean that if we are using direct connects that your method of deleting old/orphan SID/SPID's at the SQL level is okay? We stop and restart our services every night and from what I can see of the processes, we have a bunch of orphans from yesterday out there in addition to the ones that started this morning. Will running this command clear those out? Thanks. ... View more

I've succesfully migrated ST_GEOMETRY databases with datapump. This is how: 1. Use 11.2.0.4 or apply the patch as mentioned before 2. Grant permissions GRANT EXECUTE ON sys.dbms_pipe TO public; GRANT EXECUTE ON sys.dbms_lock TO public; GRANT EXECUTE ON sys.dbms_lob TO public; GRANT EXECUTE ON sys.dbms_utility TO public; GRANT EXECUTE ON sys.dbms_sql TO public; GRANT EXECUTE ON sys.utl_raw TO public; GRANT EXECUTE ON sys.DBMS_CRYPTO TO public; -- DBMS_CRYPTO appears to be needed to create the ST_GEOMETRY data type and as the user SDE doesn't exist yet we grant it to public to avoid permission errors 3. Import SDE schema without indexes/constraints etc (this is the content of the .par file): userid = "/@TARGETDATABASE as sysdba" directory = DMPDIR dumpfile = ORADUMP.DMP logfile = oraimpdp_stap1.log EXCLUDE = CONSTRAINT,REF_CONSTRAINT,INDEX,TABLE_STATISTICS,TRIGGER,REFRESH_GROUP SCHEMAS       = SDE 4. Verify import by fixing invalid objects Exec dbms_utility.compile_schema( 'SDE', compile_all => FALSE ); SELECT * FROM DBA_OBJECTS WHERE STATUS <> 'VALID' ORDER BY OWNER, OBJECT_NAME; 5. Import USER schemas without indexes/constraints etc (this is the content of the .par file): userid = "/@TARGETDATABASE as sysdba" directory = dmpdir dumpfile = ORADUMP.DMP logfile = oraimpdp_stap2.log EXCLUDE = CONSTRAINT,REF_CONSTRAINT,INDEX,TABLE_STATISTICS,TRIGGER,REFRESH_GROUP SCHEMAS       = GEO,REF,TOPO 6. Verify import by fixing invalid objects Exec dbms_utility.compile_schema( 'GEO', compile_all => FALSE ); SELECT * FROM DBA_OBJECTS WHERE STATUS <> 'VALID' ORDER BY OWNER, OBJECT_NAME; 7. Import SDE & USER schema indexes/constraints etc (this is the content of the .par file): userid = "/@TARGETDATABASE as sysdba" directory = dmpdir dumpfile = ORADUMP.DMP logfile = oraimpdp_stap3.log SKIP_UNUSABLE_INDEXES = Y INCLUDE = CONSTRAINT,REF_CONSTRAINT,INDEX,TABLE_STATISTICS,TRIGGER,REFRESH_GROUP SCHEMAS       = SDE,GEO,REF,TOPO 8. Update statistics EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'SDE', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE); EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'GEO', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE); EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'REF', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE); EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'TOPO', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE); You might need to remove the REFRESH_GROUP option if these objects don't exists in the dmp file. (You can just try and if you get an error just remove it) ... View more

Survey results are now available: Geodatabase Modeling and Design Tool Survey quantitative results ... View more

Maybe, the day when we can use ArcGIS Desktop 10.1 to directly edit feature classes in a non-SDE database, that day will be the end day for ArcSDE. Right, ESRI staff? I'm not sure if ESRI want to get rid of ArcSDE. I do prefer the fact that MapInfo can directly write back to Oracle spatial data tables. However that is not to say that everything else about MapInfo is better than ArcGIS. I only used MapInfo for digitising in the past but people I speak to locally say they prefer ArcGIS on the whole. Just ashame though that one can't write directly back to Oracle. I only want to do that so I can write more advanced and at times easier SQL queries on my data and even commit those changes outside of ArcMap, since the ArcMap Jet SQL is rather basic in comparison. ... View more

Survey results are now available: Geodatabase Modeling and Design Tool Survey quantitative results ... View more

I'm helping organize a Special Interest Group at the 2011 Int'l UC to facilitate discussion about GDB modeling: Description from UC agenda: http://events.esri.com/uc/2011/infoWeb/OnlineAgenda/?fa=ofg_details_form&ScheduleID=2755 “This Special Interest Group will discuss available and forthcoming GDB design tools, patterns, and emerging issues. The group will provide participants with an opportunity to communicate their database design and modeling requirements to Esri staff who will be present.” For more information visit:http://spatialdba.com Please take a minute to fill out the following survey: http://spatialdba.com/limesurvey/index.php?sid=72916〈=en ... View more