[Qgis-user] Where can I get a shapefile made from a table of co-ordinates to map a bird monitoring project ?

[Adrian Wooster]

Stephen,

When you say "database", if you have a Postgres database with the
PostGIS extension then you can add a geometry column with something
like:
SELECT AddGeometryColumn('my_schema', 'my_table','the_geom',27700,'POINT',2);
UPDATE my_schema.my_table SET the_geom = ST_SetSRID(ST_Point(easting,
northing),27700);

Replace 27700 with your own projection - I'm in the UK and 27700 is
the UK's Ordnance Survey projection. Once you have the geometry
column, you can add it to QGIS by simply adding a PostGIS layer. (You
will also need a column of unique integers)

Otherwise, if you export your table to a CSV file, you can load it
directly into QGIS using the "Add delimited text layer" below the
"Layer/Add Layer" menu. When you click on it there are options to
specify the X and Y co-ordinate columns.

Adrian

On 11 August 2015 at 08:09, Stephen Routledge <rout at netc.net.au> wrote:
> Dear Qgis list,
>
> Where can I get a shapefile made from a table of co-ordinates to map a bird
> monitoring project ?
>
> I have a data base with 11 fields with 52 eastings and northings which I
> would like to map.
>
> Where can I get a shape file made to fit my QGIS 2.8 WIEN software OS X
> 10.8.5 operating system. (EPSG :4326, WGS 84)
>
> Can anyone please help? I have been struggling with this for a week and my
> brain has come to a brick wall….
>
> Any easy solution and a nudge in the right direction would be much
> appreciated.
>
> Yours sincerely
>
> Stephen Routledge
> Project Manager
> Swamps Rivers & Ranges
> 0467224124
> http://swampsriversandranges.org/
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user