raster-info
Retrieve detailed information about raster data stored in a PostGIS table, including metadata and spatial attributes, for efficient data analysis and management.
Instructions
Raster verisinin bilgilerini al
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| raster_column | No | Raster kolonu (varsayılan: rast) | |
| table_name | Yes | Raster tablosu adı |
Implementation Reference
- server.ts:1796-1840 (handler)Handler implementation for 'raster-info' tool. Parses input schema, sanitizes parameters, queries PostGIS for raster metadata (num_bands, width, height, pixel sizes, SRID, envelope, tile_count), and returns JSON response.
case "raster-info": { const { table_name, raster_column } = RasterInfoSchema.parse(args); const sanitizedTableName = table_name.replace(/[^a-zA-Z0-9_]/g, ""); const sanitizedRasterColumn = raster_column || "rast"; const result = await client.query(` SELECT ST_NumBands(${sanitizedRasterColumn}) as num_bands, ST_Width(${sanitizedRasterColumn}) as width, ST_Height(${sanitizedRasterColumn}) as height, ST_PixelWidth(${sanitizedRasterColumn}) as pixel_width, ST_PixelHeight(${sanitizedRasterColumn}) as pixel_height, ST_SRID(${sanitizedRasterColumn}) as srid, ST_AsText(ST_Envelope(${sanitizedRasterColumn})) as envelope_wkt, COUNT(*) as tile_count FROM ${sanitizedTableName} GROUP BY ST_NumBands(${sanitizedRasterColumn}), ST_Width(${sanitizedRasterColumn}), ST_Height(${sanitizedRasterColumn}), ST_PixelWidth(${sanitizedRasterColumn}), ST_PixelHeight(${sanitizedRasterColumn}), ST_SRID(${sanitizedRasterColumn}), ST_AsText(ST_Envelope(${sanitizedRasterColumn})) LIMIT 1; `); return { content: [ { type: "text", text: JSON.stringify( { table_name: sanitizedTableName, raster_column: sanitizedRasterColumn, raster_info: result.rows[0] || null, }, null, 2 ), }, ], }; } - server.ts:120-123 (schema)Input schema validation using Zod for 'raster-info' tool: requires table_name, optional raster_column defaulting to 'rast'.
const RasterInfoSchema = z.object({ table_name: z.string(), raster_column: z.string().optional().default("rast"), }); - server.ts:921-934 (registration)Registration of 'raster-info' tool in the ListTools handler, providing name, description, and input schema.
name: "raster-info", description: "Raster verisinin bilgilerini al", inputSchema: { type: "object", properties: { table_name: { type: "string", description: "Raster tablosu adı" }, raster_column: { type: "string", description: "Raster kolonu (varsayılan: rast)", }, }, required: ["table_name"], }, },