Watershed Assessment, Tracking & Environmental ResultS

RAD Oracle Spatial Projections

Note that adding custom projections to your Oracle database requires verifying that given SRIDs are not being used by another custom projection.

Albers Equal-Area Conic NAD83

INSERT INTO MDSYS.sdo_coord_ref_sys (
   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 (
   1000001, --adjust as required by your current system setup
   'Equal-Area Projection (North America)',
   'PROJECTED',
   4400,
   NULL,
   20006,
   2000006,
   NULL,
   NULL,
   NULL,
   'Oracle',
   NULL,
   'TRUE',
   NULL,
   'PROJCS["Equal-Area Projection (United States)",GEOGCS["NAD 83",DATUM["NAD 83",SPHEROID["GRS 80",6378137,298.2572221010002]],PRIMEM["Greenwich",0],UNIT["Decimal Degree",0.0174532925199433]],PROJECTION["Albers Conical Equal Area"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-96.0],PARAMETER["Standard_Parallel_1",29.5],PARAMETER["Standard_Parallel_2",45.5],PARAMETER["Latitude_Of_Origin",23.0],UNIT["Meter",1.0]]',
   NULL,
   'TRUE',
   'TRUE'
);
COMMIT;