Sorry for this, it was obviously meant for another mailinglist.
Please ignore it.
On Tue, Feb 18, 2014 at 8:47 AM, andrea antonello <
[email protected]> wrote:
> [Moving this post by Mark from users to devel list]
>
> At the moment the vectorlabel branch has the logic to retrieve a set label
> for a geometry.
>
> The implementation of the setting of the styles for labels has not yet be
> done as well as the actual painting.
>
> In the last 2 weeks I have been working on the the development of views
> for for border LINESTRING in preparation for geopaparazzi VIEW support.
>
> While doing so I have corrected faulty line-segments, but also checked the
> results based on data from the official treaties where the territory was
> exchanged - where the size of the Exclaves/Enclaves were given in hectors.
>
> SELECT PKUID,soldner_linestring,name,admin_level,belongs_to_01,
> belongs_to_02,valid_since,valid_until,
> name || ' ['||round(ST_Area(ST_BuildArea(soldner_linestring)),2) ||' m² =
> '||(round(ST_Area(ST_BuildArea(soldner_linestring))/10000,2))|| ' ha'||']'
> FROM berlin_ortsteile_segmente
> WHERE
> (
> ((valid_since >= '1938-04-01') AND (valid_since <= '1945-08-31') AND (
> valid_until <= '3000-01-01')) AND
> (name LIKE '%E_klave%')
> )
> ORDER BY valid_until,name,belongs_to_01;
>
> returning for one sample: 'Exklave Erlengrund [5135.33 m² = 0.51 ha]'
> - which corresponded to the officlal data of '0.51 ha'
>
> ---
>
> At the moment it is planned to support only one specific field of the
> table row being displayed.
>
> SELECT soldner_linestring,name FROM ....
>
> that could replaced with something like this:
>
> SELECT soldner_linestring,name || ' ['||round(ST_Area(ST_BuildArea(
> soldner_linestring)),2) ||' m² = '||(round(ST_Area(ST_BuildArea(
> soldner_linestring))/10000,2))|| ' ha'||']'
> FROM ....
>
> would as such not cause any problems - as long a a correct SQL-Syntax is
> being used.
>
> For this it would be better to create a LabelDataPropertiesActivity.java
> instead of incorporating this into the present Lines/Points/
> PolygonsDataPropertiesActivitiy.java classes.
>
> There would be a field for
> - style.labelsize
>
> a list-box for the List of fields retrieved from SpatialVectorTable.
> getLabelList()
> a text-field for the selected-label from SpatialVectorTable.getLabelField()
> or style.labelfield
> a checkbox for a user-defined label
> - the class would check if getLabelField() is contained in getLabelList()
> -- if yes: it is NOT user defined: checkbox is OFF
> --- a selection of the list-box would REPLACE the value in selected-label
> -- if no: it is user defined: checkbox is ON
> --- a selection of the list-box would INSERT the value in selected-label
>
> In this way there would be no need to add an extra field to the style-table
>
> ---
> DataListActivity could be adapted to have AFTER the ImageButton
> zoomtoButton
> - a checkbox to enable/disable label showing
> - a ImageButton to call LabelDataPropertiesActivity
>
> In this way a user could quickly turn on/off the label support, WITHOUT
> going into the LabelDataPropertiesActivity
>
> ---
> There would be no way to check if the user-defined syntax is correct
> - it would be up to the user to insure that they are using a valid
> SQL-Syntax
> - care must be take to insure that "'" would be properly handled when
> inserting / updating the style-table
>
>
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
