Oracle spatial, openlayers, GeoServer development Geographic Information System Summary

thanks to open source, the use of openlayers+geoserver GIS development is very simple, fully can apply to develop MIS system experience, I summarized here as three steps:

1. Data preparation

2. Data release

3. Data presentation

I will follow this idea to introduce, first of all, the data release:

First, the data release

GIS data sources are various, have vector data, have raster data, have text database, have relational database, because I usually use Oracle spatial database and postgis,oracle more, so I use Oracle as an example to illustrate, other comprehend by analogy, At least most of the things I've met are like this.

Using Oracle to manage spatial data can be completely considered a relational database, which is why I can apply the experience of MIS system, Oracle spatial database adds a spatial object mdsys.sdo_geometry to store spatial data, like varchar, int these types are the same, but this type is an object.

It is important to note that this spatial object needs to create a spatial index to be published correctly, and to create a spatial index is now defined in the metadata table, and below I will sample how to create a spatial database table for the underlying point-line polygon in the spatial graph:

SQL code

2. --Create a table
4. Create table T_point
6. (
8. ID number,
10. name Nvarchar2,
12. Position Mdsys. Sdo_geometry
14. );
18. Create table T_line
20. (
22. ID number,
24. name Nvarchar2,
26. Position Mdsys. Sdo_geometry
28. );
32. Create table T_area
34. (
36. ID number,
38. name Nvarchar2,
40. Position Mdsys. Sdo_geometry
42. );
46. --Create spatial index
48. INSERT INTO user_sdo_geom_metadata (Table_name,column_name, Diminfo)
50. VALUES (
52. ' T_point ',
54. ' POSITION ',
56. Mdsys. Sdo_dim_array (
58. Mdsys. Sdo_dim_element (' X ', -180,180,0.005),
60. Mdsys. Sdo_dim_element (' Y ', -90,90,0.005),
62. Mdsys. Sdo_dim_element (' Z ', -9000,9000,0.005)
64. )
66. );
68. CREATE INDEX idx_t_point_pos on t_point (POSITION) Indextype is Mdsys.  Spatial_index;
72. INSERT INTO user_sdo_geom_metadata (Table_name,column_name, Diminfo)
74. VALUES (
76. ' T_line ',
78. ' POSITION ',
80. Mdsys. Sdo_dim_array (
82. Mdsys. Sdo_dim_element (' X ', -180,180,0.005),
84. Mdsys. Sdo_dim_element (' Y ', -90,90,0.005),
86. Mdsys. Sdo_dim_element (' Z ', -9000,9000,0.005)
88. )
90. );
92. CREATE INDEX idx_t_line_pos on t_line (POSITION) Indextype is Mdsys.  Spatial_index;
96. INSERT INTO user_sdo_geom_metadata (table_name, COLUMN_NAME, Diminfo)
98. VALUES (
100. ' T_area ',
102. ' POSITION ',
104. Mdsys. Sdo_dim_array (
106. Mdsys. Sdo_dim_element (' X ', -180,180,0.005),
108. Mdsys. Sdo_dim_element (' Y ', -90,90,0.005),
110. Mdsys. Sdo_dim_element (' Z ', -9000,9000,0.005)
112. )
114. );
116. CREATE INDEX idx_t_area_pos on t_area (POSITION) Indextype is Mdsys.  Spatial_index;

Now you can see that the spatial table is created, and we can operate like a normal relational database, using an insert example to illustrate:

SQL code

2. --Insertion point
4. INSERT INTO t_point (ID, name, position)
6. Values
8. (1, ' Test point ',
10. Mdsys. Sdo_geometry (3001,
12. NULL,
14. NULL,
16. Mdsys.sdo_elem_info_array (1, 1, 1, 4, 1, 0),
18. Mdsys.sdo_ordinate_array (24.886436,
20. 102.784423,
22. 0,
24. 1,
26. 0,
28. 0
30. )
32. )
34. );
36. --Insertion Line
38. INSERT INTO t_line (ID, name, position)
40. Values
42. (1, ' Test line ', Mdsys. Sdo_geometry (3002,
44. NULL,
46. NULL,
48. Mdsys.sdo_elem_info_array (1, 2, 1),
50. Mdsys.sdo_ordinate_array (0, 0, 0, 0, 90, 0, 200, 90, 0, 200, 0, 0)
52. ));
54. --Insert Face
56. INSERT INTO t_area (ID, name, position)
58. Values
60. (1, ' Test area ', Mdsys. Sdo_geometry (3003,
62. NULL,
64. NULL,
66. Mdsys.sdo_elem_info_array (1, 1003, 1),
68. Mdsys.sdo_ordinate_array (0, 0, 0, 0, 90, 0, 200, 90, 0, 200, 0, 0, 0, 0, 0)
70. ));

The above code constructs a spatial object, the description of which can refer to the relevant documentation, which is not explained in detail here. Ready data can be released after the data, data release is one of the less technical content of the manual work, you can refer to a series of articles here: http://www.cnblogs.com/beniao/archive/2011/01/08/1930822.html

After the data is published, the data can be presented, and the data display can be applied to the MIS control concept, as follows:

1. Create a Map control

2. Create a layer

3. Add layers to the map

4. Add other controls to the map

The following code shows the details:

JS Code

2. Initialize Map
4. var map = new Openlayers.map (' map ');
6. var map = New Openlayers.map ({
8. Div:"map",
10. MAXEXTENT:[97.027587,21.166484,106.739502,29.31642],
12. Center:New Openlayers.lonlat (101.857909,24.726875)
14. });
16. New Layer
18. var ol_wms = New OpenLayers.Layer.WMS (
20. "Openlayers WMS",
22. "Http://10.180.80.206:9000/geoserver/wms",
24. {layers: "sdgis:dqj"}
26. );
30. Add a Map control
32. Map.addcontrol (new OpenLayers.Control.LayerSwitcher ());
34. Map.addcontrol (new OpenLayers.Control.MousePosition ());
36. Map.addcontrol (new OpenLayers.Control.Scale ());
38. Layer Join Map
40. Map.addlayers ([ol_wms]);
42. Map.zoomtoextent ([97.027587, 21.166484, 106.739502, 27.467659], true);

Oracle spatial, openlayers, GeoServer development Geographic Information System Summary