[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
