EPSG:4278

GEOGCS["OSGB70",DATUM["D_OSGB_1970_SN",SPHEROID["Airy_1830",6377563.396,299.3249646]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]]

+proj=longlat +ellps=airy +no_defs 

proj4.defs("EPSG:4278","+proj=longlat +ellps=airy +no_defs");

<?xml version="1.0" encoding="UTF-8"?>
 <gml:GeodeticCRS xmlns:epsg="urn:x-ogp:spec:schema-xsd:EPSG:1.0:dataset" xmlns:gml="http://www.opengis.net/gml/3.2" xmlns:xlink="http://www.w3.org/1999/xlink" gml:id="epsg-crs-4278">
   <gml:metaDataProperty>
      <epsg:CommonMetaData>
         <epsg:type>geographic 2D</epsg:type>
         <epsg:revisionDate>2004-01-06</epsg:revisionDate>
         <epsg:changes>
            <epsg:changeID xlink:href="urn:ogc:def:change-request:EPSG::2003.370" />
         </epsg:changes>
         <epsg:show>true</epsg:show>
         <epsg:isDeprecated>false</epsg:isDeprecated>
      </epsg:CommonMetaData>
   </gml:metaDataProperty>
   <gml:identifier codeSpace="OGP">urn:ogc:def:crs:EPSG::4278</gml:identifier>
   <gml:name>OSGB70</gml:name>
   <gml:domainOfValidity xlink:href="urn:ogc:def:area:EPSG::1264" />
   <gml:scope>Geodetic survey.</gml:scope>
   <gml:ellipsoidalCS xlink:href="urn:ogc:def:cs:EPSG::6422" />
   <gml:geodeticDatum xlink:href="urn:ogc:def:datum:EPSG::6278" />
</gml:GeodeticCRS>

<?xml version="1.0" encoding="UTF-8"?>
 <gml:GeographicCRS gml:id="ogrcrs23502" xmlns:gml="http://www.opengis.net/gml/3.2">
  <gml:srsName>OSGB70</gml:srsName>
  <gml:srsID>
    <gml:name gml:codeSpace="urn:ogc:def:crs:EPSG::">4278</gml:name>
  </gml:srsID>
  <gml:usesEllipsoidalCS>
    <gml:EllipsoidalCS gml:id="ogrcrs23503">
      <gml:csName>ellipsoidal</gml:csName>
      <gml:csID>
        <gml:name gml:codeSpace="urn:ogc:def:cs:EPSG::">6402</gml:name>
      </gml:csID>
      <gml:usesAxis>
        <gml:CoordinateSystemAxis gml:id="ogrcrs23504" gml:uom="urn:ogc:def:uom:EPSG::9102">
          <gml:name>Geodetic latitude</gml:name>
          <gml:axisID>
            <gml:name gml:codeSpace="urn:ogc:def:axis:EPSG::">9901</gml:name>
          </gml:axisID>
          <gml:axisAbbrev>Lat</gml:axisAbbrev>
          <gml:axisDirection>north</gml:axisDirection>
        </gml:CoordinateSystemAxis>
      </gml:usesAxis>
      <gml:usesAxis>
        <gml:CoordinateSystemAxis gml:id="ogrcrs23505" gml:uom="urn:ogc:def:uom:EPSG::9102">
          <gml:name>Geodetic longitude</gml:name>
          <gml:axisID>
            <gml:name gml:codeSpace="urn:ogc:def:axis:EPSG::">9902</gml:name>
          </gml:axisID>
          <gml:axisAbbrev>Lon</gml:axisAbbrev>
          <gml:axisDirection>east</gml:axisDirection>
        </gml:CoordinateSystemAxis>
      </gml:usesAxis>
    </gml:EllipsoidalCS>
  </gml:usesEllipsoidalCS>
  <gml:usesGeodeticDatum>
    <gml:GeodeticDatum gml:id="ogrcrs23506">
      <gml:datumName>OSGB_1970_SN</gml:datumName>
      <gml:datumID>
        <gml:name gml:codeSpace="urn:ogc:def:datum:EPSG::">6278</gml:name>
      </gml:datumID>
      <gml:usesPrimeMeridian>
        <gml:PrimeMeridian gml:id="ogrcrs23507">
          <gml:meridianName>Greenwich</gml:meridianName>
          <gml:meridianID>
            <gml:name gml:codeSpace="urn:ogc:def:meridian:EPSG::">8901</gml:name>
          </gml:meridianID>
          <gml:greenwichLongitude>
            <gml:angle gml:uom="urn:ogc:def:uom:EPSG::9102">0</gml:angle>
          </gml:greenwichLongitude>
        </gml:PrimeMeridian>
      </gml:usesPrimeMeridian>
      <gml:usesEllipsoid>
        <gml:Ellipsoid gml:id="ogrcrs23508">
          <gml:ellipsoidName>Airy 1830</gml:ellipsoidName>
          <gml:ellipsoidID>
            <gml:name gml:codeSpace="urn:ogc:def:ellipsoid:EPSG::">7001</gml:name>
          </gml:ellipsoidID>
          <gml:semiMajorAxis gml:uom="urn:ogc:def:uom:EPSG::9001">6377563.396</gml:semiMajorAxis>
          <gml:secondDefiningParameter>
            <gml:inverseFlattening gml:uom="urn:ogc:def:uom:EPSG::9201">299.3249646</gml:inverseFlattening>
          </gml:secondDefiningParameter>
        </gml:Ellipsoid>
      </gml:usesEllipsoid>
    </gml:GeodeticDatum>
  </gml:usesGeodeticDatum>
</gml:GeographicCRS>

4278=GEOGCS["OSGB70",DATUM["OSGB_1970_SN",SPHEROID["Airy 1830",6377563.396,299.3249646,AUTHORITY["EPSG","7001"]],AUTHORITY["EPSG","6278"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4278"]]

PROJECTION
	"proj=longlat"
	"ellps=airy"
	"no_defs"
END

<?xml version="1.0" encoding="utf-8"?>
<Map srs="+proj=longlat +ellps=airy +no_defs">
	<Layer srs="+proj=longlat +ellps=airy +no_defs">
	</Layer>
</Map>

INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 4278, 'EPSG', 4278, '+proj=longlat +ellps=airy +no_defs ', 'GEOGCS["OSGB70",DATUM["OSGB_1970_SN",SPHEROID["Airy 1830",6377563.396,299.3249646,AUTHORITY["EPSG","7001"]],AUTHORITY["EPSG","6278"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4278"]]');

GEOGCS["OSGB70",DATUM["OSGB_1970_SN",SPHEROID["Airy 1830",6377563.396,299.3249646,AUTHORITY["EPSG","7001"]],AUTHORITY["EPSG","6278"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4278"]]