Select *, OL = Case When OrgLink Is Not Null Then '' + OrgLink + '' Else 'N/A' End, ZipLink=Case When Available=1 and State=1 Then'** Download Statewide **' Else 'Not Available Statewide' End, PrjLink=Case When DataLayers.OrgID=1 or DataLayers.OrgID=10 Then'** Download Projection (.prj) file **' Else '

Projection file not available

' End From DataLayers Inner Join DataOrgs on DataLayers.ORGID = DataOrgs.OrgID Where DataLayersID=%DataLayersID% %[LayerName]% Last Updated %[LastUpdate]%

Organization Name	Contact Name	Phone	Email	Web Page
%[OrgName]%	%[OrgContact]%	%[OrgPhone]%	%[OrgEmail]%	%[OL]%

Download Shapefile

%[ZipLink]% The following database error occured: ODBC--call failed. The SQL statement used may contain a syntax error: [Select Distinct County.County, County.Name From DataCounty Inner Join County on DataCounty.County=County.County Where DataLayersID=%DataLayersID%] ** Download Selected County ** %[prjlink]%

Select *, MetaLoc='d:\inetpub\oeb_ftp\statewide\' + TableName + '.txt', MetaDownload='http://geo.ou.edu/oeb/Statewide/' + TableName + '.txt' From DataLayers Where DataLayersID = %DataLayersID% MetaData for %[Layername]%
Note: Metadata reflects statewide extent of layer.

Last Update: %[LastUpdate]%
**Download Metadata**

(You might need to Right-Click the link, then choose Save As...)