Jump to

• Request
• Response
• Examples

List GeoRaster Tables

get

{server}/georaster/v1/{datasource}/

List the tables with GeoRaster columns.

Request

Query Parameters

• limit: integer
  Limit the items included in the response, use in conjuntion with offset parameter.

  Examples

  Select an example 10 items

• offset: integer
  The amount of items from the beggining of the collection not to be included in the response.

  Examples

  Select an example Offset 0 Offset 10

There's no request body for this operation.

Back to Top

Response

Supported Media Types

• application/json

200 Response

Return a list of GeoRaster tables with the Georaster column names.

Body ()

Root Schema : georasterTableListResponse

Type: object

Show Source

• count: integer
• hasMore: boolean
• items: array items
• limit: integer
• links: array links
  link to self
• offset: integer

{
    "type":"object",
    "properties":{
        "items":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/georasterTableResponse"
            }
        },
        "hasMore":{
            "type":"boolean"
        },
        "limit":{
            "type":"integer"
        },
        "offset":{
            "type":"integer"
        },
        "count":{
            "type":"integer"
        },
        "links":{
            "type":"array",
            "description":"link to self",
            "items":{
                "$ref":"#/components/schemas/instanceLink"
            }
        }
    }
}

Nested Schema : items

Type: array

Show Source

• Array of: object georasterTableResponse

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/georasterTableResponse"
    }
}

Nested Schema : links

Type: array

link to self

Show Source

• Array of: string

{
    "type":"array",
    "description":"link to self",
    "items":{
        "$ref":"#/components/schemas/instanceLink"
    }
}

Nested Schema : georasterTableResponse

Type: object

Show Source

• georasterColumnName: string
• georasterTableName: string
• links: array links
  link table
• schema: string

{
    "type":"object",
    "properties":{
        "schema":{
            "type":"string"
        },
        "georasterTableName":{
            "type":"string"
        },
        "georasterColumnName":{
            "type":"string"
        },
        "links":{
            "type":"array",
            "description":"link table",
            "items":{
                "$ref":"#/components/schemas/instanceLink"
            }
        }
    }
}

Nested Schema : links

Type: array

link table

Show Source

• Array of: string

{
    "type":"array",
    "description":"link table",
    "items":{
        "$ref":"#/components/schemas/instanceLink"
    }
}

Examples

Select an example

Links

listGeoRasterObjects

Operation: {server}/georaster/v1/{datasource}/{tableName}/{georasterColumnName}

Parameters:

• georasterColumnName: $response.body#/items/0/georasterColumnName
• tableName: $response.body#/items/0/georasterTableName

List GeoRaster Object

401 Response

Authentication information is missing or invalid

Headers

• WWW_Authenticate:

Back to Top

Examples

The following is an example on how to list all tables and GeoRaster columns from datasource1 data source by submitting a GET request using cURL.

curl -X GET "https://localhost:8080/oraclespatial/georaster/v1/datasource1?limit=1&offset=0" -H "Cookie: JSESSIONID=<jsessionid_value>"

The following shows an example of the response in JSON format for the above request.

{
  "items" : [ { 
     "schema" : "HERMAN", 
     "georasterTableName" : "IMAGE_TABLE", 
     "georasterColumnName" : "IMAGE", 
     "links" : [ { 
       "rel" : "canonical", 
       "href" : "http://localhost:8080/oraclespatial/georaster/v1/datasource1/IMAGE_TABLE/IMAGE" 
     } ] 
   } ], 
   "hasMore" : false, 
   "totalResults" : 1, 
   "links" : [ { 
     "rel" : "canonical", 
     "href" : "http://localhost:8080/oraclespatial/georaster/v1/datasource1" 
   }, { 
     "rel" : "self", 
     "href" : "http://localhost:8080/oraclespatial/georaster/v1/datasource1?limit=1&offset=0" 
   } ] 
   }

Back to Top