Croatia/Kratki vodici/Oracle HTRS96 - Revision history

Wiki-Dragan.podvezanec: /* Napomena */

2011-05-06T06:23:40Z

Napomena

Wiki-Dragan.podvezanec at 09:08, 19 January 2011

2011-01-19T09:08:42Z

Wiki-Dragan.podvezanec at 09:02, 19 January 2011

2011-01-19T09:02:45Z

Wiki-Dragan.podvezanec at 08:58, 19 January 2011

2011-01-19T08:58:50Z

Wiki-Dragan.podvezanec: Created page with 'T = HTRS96 koordinatni sustav i Oracle = == Uvod == Kako Oracle još uvijek ne podržava novi službeni hrvatski koordinatni sustav (http://…'

2011-01-19T08:57:37Z

Created page with 'T = HTRS96 koordinatni sustav i Oracle = == Uvod == Kako Oracle još uvijek ne podržava novi službeni hrvatski koordinatni sustav (http://…'

New page

[[Category:Croatia/Kratki_vodici|T]]

= HTRS96 koordinatni sustav i Oracle =

== Uvod ==

Kako Oracle još uvijek ne podržava novi službeni hrvatski koordinatni sustav (http://spatialreference.org/ref/epsg/3765/), a u praksi ima potrebe za ovim koordinatnim sustavom, u nastavku slijedi definicija HTRS96 koordinatnog sustava za Oracle:

<code>
-- HTRS96

-- Definicija konverzije

INSERT INTO MDSYS.sdo_coord_ops
(coord_op_id, coord_op_name, coord_op_type, source_srid,
target_srid, coord_tfm_version, coord_op_variant,
coord_op_method_id, uom_id_source_offsets,
uom_id_target_offsets,
information_source,
data_source, show_operation, is_legacy, legacy_code, reverse_op,
is_implemented_forward, is_implemented_reverse
)
VALUES (19851, 'HTRS96 / Croatia TM', 'CONVERSION', NULL,
NULL, NULL, NULL,
9807, NULL,
NULL,
'State Geodetic Administration of the Republic of Croatia.',
'EPSG', 1, 'FALSE', NULL, 1,
1, 1
);

-- Definicija parametara za konverziju

INSERT INTO MDSYS.sdo_coord_op_param_vals
(coord_op_id, coord_op_method_id, parameter_id, parameter_value,
param_value_file_ref, uom_id
)
VALUES (19851, 9807, 8801, 0,
NULL, 9102
);

INSERT INTO MDSYS.sdo_coord_op_param_vals
(coord_op_id, coord_op_method_id, parameter_id, parameter_value,
param_value_file_ref, uom_id
)
VALUES (19851, 9807, 8802, 16.5,
NULL, 9102
);

INSERT INTO MDSYS.sdo_coord_op_param_vals
(coord_op_id, coord_op_method_id, parameter_id, parameter_value,
param_value_file_ref, uom_id
)
VALUES (19851, 9807, 8805, 0.9999,
NULL, 9001
);

INSERT INTO MDSYS.sdo_coord_op_param_vals
(coord_op_id, coord_op_method_id, parameter_id, parameter_value,
param_value_file_ref, uom_id
)
VALUES (19851, 9807, 8806, 500000,
NULL, 9001
);

INSERT INTO MDSYS.sdo_coord_op_param_vals
(coord_op_id, coord_op_method_id, parameter_id, parameter_value,
param_value_file_ref, uom_id
)
VALUES (19851, 9807, 8807, 0,
NULL, 9001
);

-- Dodavanje datuma

INSERT INTO sdo_datums
VALUES (6761, 'Croatian_Terrestrial_Reference_System', 'GEODETIC',
'7019', '8901', '', 'EPSG', NULL, NULL, NULL, NULL, NULL, NULL,
NULL, 'FALSE', NULL);

-- Definicija projekcije

INSERT INTO sdo_coord_ref_sys
VALUES (4761, 'HTRS96', 'GEOGRAPHIC2D', 6402, 6761, 6761, NULL, NULL,
NULL, NULL,
'Cadastral surveys, large scale topographic mapping, engineering survey.',
'EPSG', 'FALSE', NULL,
'GEOGCS["HTRS96",DATUM["Croatian_Terrestrial_Reference_System",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6761"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4761"]]',
NULL, 'TRUE', 'TRUE');

INSERT INTO sdo_coord_ref_system
(srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id,
datum_id, geog_crs_datum_id, source_geog_srid,
projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid,
information_source,
data_source, is_legacy, legacy_code, legacy_wktext,
legacy_cs_bounds, is_valid, supports_sdo_geometry
)
VALUES (3765, 'HTRS96 / Croatia TM', 'PROJECTED', 4400,
NULL, 6761, 4761,
19851, NULL, NULL,
'Cadastral surveys, large scale topographic mapping, engineering survey.',
'EPSG', 'FALSE', NULL, NULL,
NULL, 'TRUE', 'TRUE'
);
</code>

@@ Line 133: / Line 133: @@
 -- GK6 pojekcija bazirana na gore definiranom geografskom sustavu
-Insert into SDO_COORD_REF_SYStem (srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, information_source, data_source, is_legacy,is_valid,supports_sdo_geometry) Values (478006, 'GK zone 6', 'PROJECTED', 4499,1000000125, 1000003007, 18275,'', 'hr.osgeo', 'FALSE', 'TRUE', 'TRUE');
+Insert into SDO_COORD_REF_SYStem (srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, information_source, data_source, is_legacy,is_valid,supports_sdo_geometry) Values (478006, 'GK zone 6', 'PROJECTED', 4499,1000000125, 1000003007, 18276,'', 'hr.osgeo', 'FALSE', 'TRUE', 'TRUE');
 </pre>

← Older revision		Revision as of 08:58, 19 January 2011
Line 1:		Line 1:
−	[[Category:Croatia/Kratki_vodici\|T]]	+	[[Category:Croatia/Kratki_vodici\|O]]

	= HTRS96 koordinatni sustav i Oracle =		= HTRS96 koordinatni sustav i Oracle =

@@ Line 104: / Line 104: @@
               NULL, 'TRUE', 'TRUE'
              );
 </pre>