Tag Info

Hot answers tagged

10

Check BostonGIS Compare SQL Server 2008 R2, Oracle 11G R2, PostgreSQL/PostGIS 1.5 Spatial Features. If that's too basic: Which topics do you need covered? MySQL is not usable for serious GIS work.


6

This is exactly what Historical Versions (aka Archiving) were created for. Go ahead and Enable Archiving in ArcCatalog. Create a Historical Marker for the initial source version and another one for the end. Then you can open the table in a version created from the first marker, another one for a version in the target marker. A difference cursor will spit out ...


6

You can think of ArcSDE as a spatial data abstraction library used by the GeoDatabase. It has both a client-side library and a server-side component. It stays in between your ArcGIS and Oracle software. The client-side code always runs, well, in-proc to the client. It is shipped/built-in with all the ArcGIS software you may run - no separate installation ...


5

Mmmm, looks like a bug. SG contains the ArcSDE geometry libraries and not the ArcObjects geometry libraries... it is used as a pre-filter before the test hits the ArcObjects geometry libraries. Try this: Omit this line: pSpatialFilter.SearchOrder = esriSearchOrder.esriSearchOrderSpatial; and since you are not saving a reference to the row, there is no ...


5

libogr can read and write both Oracle and PostGIS. Use the ogr2ogr utility to convert your data. http://www.gdal.org/ogr/ http://www.gdal.org/ogr2ogr.html Works well enough for us.


5

You can run the command "desc [feature class name];" in SQL Plus (Or any other way you access oracle" Look at the Shape columns data type, that should tell you which Geometry type is used, for instance: SQL> desc roads; Name NULL? Type ------------------------------------ OBJECTID NOT NULL NUMBER(38) FNODE_ NUMBER(38) ...


5

The OGC WKT and WKB specifications never explicitly addressed how to encode higher dimensionality, so it would not be surprising if Oracle either (a) did not encode those dimensions at all or (b) did so in a way that is not consistent with formats PostGIS can ingest. Absent any examples of Oracle output, I'm just guessing. You might find that a ...


5

It looks like you are hitting a known issue. NIM034235 IFieldChecker.ValidateTableName should check that table names do not exceed the workspace's maximum number of characters. mackayj80 describes the issue in this Esri blog post.


5

Keep in mind what you are doing -- You are asking the database to return all features within the display envelope AND whose ids are in the first 1000. And you are likely doing so with a spatial constraint first option. Yes, it is very normal to see poor performance under such circumstances. Best practice for rendering very large tables is not to. This ...


4

Thesis by Shamal Kiran Matty (2012) 'Comparative study of Oracle Spatial and Postgres Spatial' discusses quite a lot of issues that might be of interest here. From the summary: However, the research done as a part of this thesis suggests that PostGIS is more advantageous over Oracle Spatial for the reasons stated below: Cost Savings Ease ...


4

I believe that the issue was triggered by loading an XML geodatabase export into SDE. The original export had geodata that was owned by a user that did not exist in the database when the data was loaded. Consequently, the data became owned by the user specified in the connection (instead of the user referenced in the geodatabase) Thus: Original SDE ...


4

If I understand your question corrrectly IMO the answer is no. Versioning simply stated tracks changes to existing data within the database. I used to use a modelbuilder script to check incoming shape files for "diff" in both the spatial and attributes, make a selection of the new differing data and then export that to a seperate file for import to my db. ...


4

I haven't used the Query layer but I assume it needs to be a valid oracle layer? Which means you would have to add an entry for the layer to the user_sdo_geom_metadata table (see here) and also creating a spatial index (see there)


4

To follow-up on PolyGeo's answer, the Describe object is certainly where it should be, but it isn't. Database queries may be the best way to go here. Although, if you have the SDE command-line binaries, another option would be to try doing something like this (yes it's a hack, but might work): import subprocess output = subprocess.check_output("sdelayer ...


4

Why not just do a Select Layer by Location instead of setting the geoprocessing extent? Alternatively, you could use a SearchCursor and stop after the 500th row.


4

The OpenGeo Suite sounds like your best all in one solution http://opengeo.org/products/suite/integration/ Though understanding the steps will help your build the web mapping application you want, here are some useful links that show you what can be achieved. Editing "OpenLayers provides vector editing capabilities previously only available on desktop ...


4

Postgis, spatialite and Qgis mainly use GDAL/Proj definitions with EPSG codes as ID for CRS. You find a lot of them at spatialreference.org, but that database is a bit outdated. For Dutch RD, there is EPSG:28991 Amersfoort/RD Old EPSG:28992 Amersfoort/RD New Oracle used their own SRID up to release 10.1, and switched to EPSG codes as of release 10.2 ...


4

The UNION ALL does not perform the same as what you want to achieve. Like the manual says, it is really an alternative to a combined mask. For example, the "+" in expression "MASK=INSIDE+COVEREDBY" stands for an inclusive OR, and so can be replaced by a UNION ALL, that also represents an inclusive OR. But you want to do something else: you want to find out ...


4

In GIS applications, often times the SELECT * FROM portion of the SQL expression is typically supplied for you, effectively leaving the user to just enter the WHERE clause. Additionally, applications often abstract the SQL language to make it easier for their customers to use & understand (who may not know the ANSI SQL standards), choosing to implement ...


4

You actually have to install both 32bit and 64bit Oracle clients to get everything working properly. The article you show in your screenshot is referencing ArcGIS desktop (not the background processing), which is still a 32bit program. You will have to have the 32bit client to connect with ArcGIS Desktop and other 32bit programs. You'll also need the 64bit ...


3

Using Spatial Database Connection in ArcCatalog http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Making_an_ArcSDE_service_connection_from_ArcGIS_Desktop_to_a_geodatabase_in_Oracle/002n0000008n000000/


3

As long as you have gdb connections to both you will be able to use esri (catalog) tools to move data between. You will want to double check your CRS for support in both spatial databases. If you don't use esri tools you will have to register your data in sde. You simply mention that oracle supports spatial without saying that your data is in oracle spatial. ...


3

check this out: I collected the information to include the projection EPSG:3857 in Oracle Spatial https://www.inf.unibz.it/dis/wiki/doku.php?id=students:minnerebner:oracle:addingsrid


3

At least two things can cause this - maybe more. The views should be added to Oracle's own spatial metadata catalog. This has been discussed a few times on MapInfo-L, see http://groups.google.com/group/mapinfo-l/browse_thread/thread/8088c4afeadeb1c6?pli=1. The other problem could be that you don't have a primary key in your view. For MapInfo Pro to be able ...


3

Creating a view joining parcels and permits is advisable. You can use it in other situations as well (data querying etc.). See a sample of doing so in Joining spatial and not spatial table in oracle.


3

Oracle database can access web-based services (incl. REST) via built-in UTL_HTTP package. You formulate & set-up the request, send it and receive & process the response. I don't have any experience with the package, but your workflow seems to be doable. Update The code could be like this: DECLARE req utl_http.req; resp utl_http.resp; name ...


3

For Windows Service You can create and register an ArcSDE service on Windows servers from an MS-DOS prompt using the sdeservice command. http://resources.arcgis.com/en/help/install-guides/arcsde-application-server-oracle/10.2/index.html#/Creating_an_ArcSDE_service_on_Windows_using_the_sdeservice_command/00940000006w000000/ For creating the ...


3

There are actually SQL standards, see also this Wikipedia article, but this standard is only implemented by major object-relational databases like PostgreSQL or MySQL. What QGIS uses in its field calculator is kind of a custom query language with a syntax that resembles SQL but is far away from implementing any standard. The QGIS documentation says that ...


2

It looks as though you are using a scopira server (research council of canada). You can find more info here... Scopira It utilizes rdp files which are not of oracle decent. The format is described more here... RDP format As far as converting to a mainstream GIS it looks like these are a text file so you may be able to decipher the format and use something ...


2

You can try writing triggers for the database, checking for valid values (trigger restriction) and update the field accordingly. Check the following links: Parts of a Trigger Types of Triggers If possible, you can do the same validation at the form (GUI) level and provide the user with some drop-down option. You can also try putting these in a separate ...



Only top voted, non community-wiki answers of a minimum length are eligible