WMS flash viewer

National Aerospace Laboratory The Netherlands has build a WMS-flash viewer. Check it out at
http://nlr-gis.nlr.nl/beeldblad. Some nice examples of several wms-services worldwide have been provided. You can also download the viewer and implement it on your own services.

ORA-03113: end-of-file on communication channel

If you happen to get this message when (spatial) querying an oracle table. Probably the spatial index is incorrect, because it has been based on wrong dim-information in the user_sdo_geom_metadata table.

- Drop the index
- Correct the diminfo in user_sdo_geom_metadata
- Rebuild the index

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)VALUES ('table', 'LOCfld',MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X', 180000, 220000, 0.005),MDSYS.SDO_DIM_ELEMENT('Y', 380000, 450000, 0.005)),Null);

CREATE INDEX si_ITEM2D on table(LOCfld) indextype is mdsys.spatial_index

edges faces nodes (topology in Oracle 10g)

I always tend to forget this... What exactly are edges, nodes en faces

• The start node and end node for edge E4 are N1 and N2, respectively. The next left edge for edge E4 is E5, but its direction is the opposite of edge E4, and therefore the next left edge for E4 is stored as -E5 (negative E5).
• The previous left edge for edge E4 is E3, and because it has the same direction as edge E4, the previous left edge for E4 is stored as E3.
• The next right face is determined using the negative directed edge of E4. This can be viewed as reversing the edge direction and taking the next left edge and previous left edge. In this case, the next right edge is E2 and the previous right edge is -E6 (the direction of edge E6 is opposite the negative direction of edge E4). For edge E4, the left face is F1 and the right face is F2.
• Edges E1 and E7 are neither leftmost nor rightmost edges with respect to edge E4, and therefore they do not appear in the edge table row associated with edge E4.