[Qgis-user] Add a shape within QGIS to a record already in a database layer/table (SQL SERVER)

[Bo Victor Thomsen]

You can create a SQLServer based insert trigger, that checks the new 
record. If the record doesn't contain a geometry object (geometry is 
null) it can create a "dummy" geometry before inserting the record in 
the database, for example a polygon square. The position of the square 
should be determined by some other information in the new record, so 
every dummy square has an unique position.

Regards
Bo Victor Thomsen
Aestas-GIS
Denmark

Den 17-06-2014 09:09, Bernhard Ströbl skrev:
> Hi,
>
> not sure about MySql (I use PostgreSQL). How if you define a default 
> polygon that is used upon inserting a new dataset with null polygon 
> (needs a trigger maybe). You can later change that polygon in QGIS.
> IMHO the better way would be to create the dataset from within QGIS by 
> digitizing the new polygon, though.
>
> Bernhard
>
> Am 17.06.2014 08:54, schrieb Carlos da Ponte:
>> Hi everyone,
>> Is there a way to add a shape (eg polygon) to a record in a database 
>> table
>> added to QGIS, where the record was originally created in a database 
>> form
>> elsewhere.  (probably makes more sense as an example).
>>
>> In my SQL Server database form I create a new record for a mine site 
>> in a
>> table that has a geography field.
>>
>> I then go into QGIS, load the layer/table via the SQL Server 
>> connection.  I
>> now want to create a polygon shape associated with the new mine site 
>> record
>> I created.  Typically I would just edit the existing shape associated 
>> with
>> the record, but since there is no shape associated with this record, it
>> doesnt appear there is a way to create a shape to associate to an 
>> existing
>> record.
>>
>> Is this possible (all of my attempts say no).  Is there a better way for
>> this workflow to happen.  I could create a child table to house the 
>> geometry
>> and then use a key relationship to associate it to the record but I 
>> want as
>> few tables as possible as this adds tables & increases complexity for 
>> novice
>> users.
>>
>> Thoughts?
>> C
>>
>>
>>
>> -- 
>> View this message in context: 
>> http://osgeo-org.1560.x6.nabble.com/Add-a-shape-within-QGIS-to-a-record-already-in-a-database-layer-table-SQL-SERVER-tp5146218.html
>> Sent from the Quantum GIS - User mailing list archive at Nabble.com.
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>>
>> __________ Information from ESET Mail Security, version of virus 
>> signature database 9956 (20140617) __________
>>
>> The message was checked by ESET Mail Security.
>> http://www.eset.com
>>
>>
>
>
>
> __________ Information from ESET Mail Security, version of virus 
> signature database 9956 (20140617) __________
>
> The message was checked by ESET Mail Security.
> http://www.eset.com
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user