New answers tagged oracle
To follow up the top answer, a lot of online company's use Oracle real time scheduling systems (formerly Sidewinder) to organise and route their deliveries, (which uses the oracle spatial routing functionality). They are usually looking for GIS analysts to keep the underlying maps up to date.
Oracle DBMS is is capable of storing spatial data either through custom formats (like Esri) or native (Oracle Spatial). This means it is worth learning for GIS Analyst because you will be able to interact with the DBMS either by using SQL/PLSQL/spatial SQL functions (for analysis and data retrieval, and you can do a lot with those spatial functions without ...
I would say that there are two ways. The most obvious is that Oracle has an Oracle Spatial module with lot's of GIS functionnalities. The second is that Oracle, as a RDBMS, is also used as a third party software for the table storage and analysis. The experience you get by managing an RDBMS like Oracle should thus be easy to valorize for a GIS job.
The actual error message is "ORA-00972: identifier is too long". This has nothing to do with the maximum size or value of a column, but rather that an identifier such as a table name or column name is too long (more than 30 characters). That said, I see nothing wrong with the SELECT statement you use - unless the interface you use adds something to make it ...
Those ArcPy functions utilize the SgShape functions lower in the API stack. The ST_GEOMETRY object was built using some of those same functions, but doesn't expose them all (just the set that implements those required by Spatial Types and Functions implementation, which doesn't include LRS). The LRS primitive list exposed at the ArcSDE API isn't large: ...
You also need to select the primary key, sometimes this isn't set on views
Version 2.4 of Qgis has Layer Files (QLR) which can be used instead of OVF/VRT files to do this.
I believe one can still import the data with the Map_Tools. This is a java Program: once a connection is established from the map tool to a DB, one may start importing the data with Tools->RDF Installer
Of course, right after I post this I find the answer. At 10.2, ESRI automatically enabled Standardized Querying which removes the ability to use database specific functions in queries on ArcGIS Server map services. The instructions to disable this setting can be found here: http://resources.arcgis.com/en/help/main/10.2/index.html#//015400000641000000 It ...
Top 50 recent answers are included