Skip to main content

Questions tagged [db2]

IBM DB2 is a relational model database server that can be made spatially aware and thus integrate with a number of GIS products.

Filter by
Sorted by
Tagged with
0 votes
0 answers
42 views

Add database connection DB2/400 (iSerie / IBM i)

We are finding it difficult to connect to the DB2/400 database, it is the same DB2 for IBM i. Usually we use a Java package called jt400.jar that encompasses the JDBC driver to DB2 for IBM i. The ...
MARCELO's user avatar
0 votes
0 answers
35 views

DB2 will only accept SRID's: 0, 1 and 4326?

I'm sure I'm doing something wrong here or just not understanding how this works but I cannot get DB2 to accept any coordinates that aren't either in SRID's 0, 1 or 4326. I'm trying to add data to a ...
Yndigo Dream's user avatar
0 votes
0 answers
59 views

DB2 ST_AREA function with SRID: 4326 returns wrong units

On any other database system with a an SRID of 4326, ST_Area returns a value in meters. However, DB2 returns decimal degrees by default. I get that I can specify meters as an argument but why return ...
Yndigo Dream's user avatar
0 votes
1 answer
40 views

Is my install really missing Spatial Functions in DB2 Spatial Extender?

I'm running a number of Spatial Functions in DB2 (11.5 LUW) and getting back errors such as: SQL Error [42884]: No authorized routine named "ST_ENDPOINT" of type "FUNCTION" having ...
Yndigo Dream's user avatar
0 votes
0 answers
43 views

How do you use negative coordinates with SRID 0 and DB2 Spatial?

I'm trying to store pure Geometry values in DB2 on a flat plane, no spatial reference or projection, apologies on the nomenclature as I might be a little off, basically planar cartesian coordinates. ...
Yndigo Dream's user avatar
1 vote
0 answers
19 views

Geometry Collection Support for DB2

At first glance it looked like DB2 supported Geometry Collections but this doesn't appear to be the case. I've tried adding a WKT like: GEOMETRYCOLLECTION (POINT (40 10), LINESTRING (10 10, 20 20, 10 ...
mxcolin's user avatar
  • 61
2 votes
1 answer
69 views

Geoserver/geotools DB2 extension support

I'm evaluating the migration of a postgis/postgres database to a DB2 spatial db. A Geoserver instance is connected to the postgis datasources, so I know there is an extension available for making the ...
SebaGra's user avatar
  • 153
1 vote
0 answers
52 views

While storing feature in ArcGIS 10 web application getting Class is not licensed for use [closed]

I have tried googling this issue Class is not licensed for use but I could not found Any Solution . I am using ArcGIS Server 10.0 of 32 bit and IBM DB2 32 bit,there is no problem while ...
Radhika's user avatar
  • 19
1 vote
1 answer
91 views

Polygon dissolve in DB

I have a polygon feature class with more than 100,000 polygons in DB2 table. I would like to dissolve them based on a single field to reduce the row numbers. Is there any commands / SQL in DB2 to ...
Hegde's user avatar
  • 11
6 votes
1 answer
1k views

Accuracy of planimetric geometry vs. ellipsoidal model

I'm examining the two geospatial options for IBM's DB2 database. In particular I am interested in the accuracy between these two options and whether it's worth it (the more accurate representation isn'...
Catchwa's user avatar
  • 171
3 votes
1 answer
190 views

Viewing ST_MULTIPOLYGON data from ArcSDE DB2

We have inherited some tables that were created with ArcGIS/ArcSDE, and the data in these is still being used by our main web application to perform some spatial lookups. The queries are pretty ...
dave.c's user avatar
  • 131
2 votes
1 answer
420 views

Has anyone successfully made a FeatureLayer from a view in DB2 and ArcSDE 10?

Lately it seems like every new ESRI feature fails for me - I must be cursed. I'm testing the use of a FeatureLayer to see if helps display and query features using the JavaScript API 2.0. This layer ...
Tim Rourke's user avatar