vector database select
======================

**Name**:

geoc vector database select

**Description**:

Get a Layer from a Database using a SELECT statement

**Arguments**:

   * -w --database-workspace: The input workspace

   * -l --layer-name: The input layer

   * -s --sql: The input layer

   * -g --geometry-field: The geometry field (name|type|projection)

   * -p --primary-key-field: The primary key field names

   * -o --output-workspace: The output workspace

   * -r --output-layer: The output layer

   * --help : Print the help message

   * --web-help : Open help in a browser



**Example**::

    geoc vector database select -w h2.db -l centroids -o centroids.properties -s "SELECT ST_CENTROID("the_geom") as "the_geom", "id" FROM "polygons"" -g the_geom|Point