flux-plan-zone-code-mapinfo-style.sql

SELECT PFI,
       SCHEME_CODE,
       LGA_CODE,
       LGA,
       ZONE_NUM,
       ZONE_STATUS,
       ZONE_CODE,
       ZONE_DESCRIPTION,
       GAZ_BEGIN_DATE,
       PFI_CREATED,
       UFI,
       UFI_CREATED,
       CASE ZONE_CODE
           WHEN 'B1Z' THEN
               'Pen (1,2,0)  Brush (2,15784442,16777215)'
           WHEN 'B2Z' THEN
               'Pen (1,2,0)  Brush (2,14726642,16777215)'
           WHEN 'B2Z' THEN
               'Pen (1,2,0)  Brush (2,14726642,16777215)'
           WHEN 'B4Z' THEN
               'Pen (1,2,0)  Brush (2,10049958,16777215)'
           WHEN 'C1Z' THEN
               'Pen (1,2,0)  Brush (2,15784442,16777215)'
           WHEN 'C2Z' THEN
               'Pen (1,2,0)  Brush (2,12750002,16777215)'
           WHEN 'CA' THEN
               'Pen (1,2,0)  Brush (2,16777215,16777215)'
           WHEN 'CDZ1' THEN
               'Pen (1,2,0)  Brush (2,376258,16777215)'
           WHEN 'CDZ2' THEN
               'Pen (1,2,0)  Brush (2,376258,16777215)'
           WHEN 'FZ' THEN
               'Pen (1,2,0)  Brush (2,14614509,16777215)'
           WHEN 'FZ2' THEN
               'Pen (1,2,0)  Brush (2,14614509,16777215)'
           WHEN 'GRZ' THEN
               'Pen (1,2,0)  Brush (2,16758223,16777215)'
           WHEN 'GRZ1' THEN
               'Pen (1,2,0)  Brush (2,16758223,16777215)'
           WHEN 'GRZ2' THEN
               'Pen (1,2,0)  Brush (2,16758223,16777215)'
           WHEN 'GRZ3' THEN
               'Pen (1,2,0)  Brush (2,16758223,16777215)'
           WHEN 'GRZ4' THEN
               'Pen (1,2,0)  Brush (2,16758223,16777215)'
           WHEN 'GRZ5' THEN
               'Pen (1,2,0)  Brush (2,16758223,16777215)'
           WHEN 'GRZ8' THEN
               'Pen (1,2,0)  Brush (2,16758223,16777215)'
           WHEN 'GWAZ' THEN
               'Pen (1,2,0)  Brush (2,13426841,16777215)'
           WHEN 'GWZ' THEN
               'Pen (1,2,0)  Brush (2,13421721,16777215)'
           WHEN 'GWZ1' THEN
               'Pen (1,2,0)  Brush (2,13421721,16777215)'
           WHEN 'GWZ2' THEN
               'Pen (1,2,0)  Brush (2,13421721,16777215)'
           WHEN 'GWZ3' THEN
               'Pen (1,2,0)  Brush (2,13421721,16777215)'
           WHEN 'GWZ4' THEN
               'Pen (1,2,0)  Brush (2,13421721,16777215)'
           WHEN 'IN1Z' THEN
               'Pen (1,2,0)  Brush (2,15773826,16777215)'
           WHEN 'IN2Z' THEN
               'Pen (1,2,0)  Brush (2,13411968,16777215)'
           WHEN 'IN3Z' THEN
               'Pen (1,2,0)  Brush (2,12540186,16777215)'
           WHEN 'LDRZ' THEN
               'Pen (1,2,0)  Brush (2,16754329,16777215)'
           WHEN 'MUZ' THEN
               'Pen (1,2,0)  Brush (2,14241101,16777215)'
           WHEN 'NRZ' THEN
               'Pen (1,2,0)  Brush (2,16765388,16777215)'
           WHEN 'NRZ1' THEN
               'Pen (1,2,0)  Brush (2,16765388,16777215)'
           WHEN 'PCRZ' THEN
               'Pen (1,2,0)  Brush (2,6409254,16777215)'
           WHEN 'PPRZ' THEN
               'Pen (1,2,0)  Brush (2,10607538,16777215)'
           WHEN 'PUZ1' THEN
               'Pen (1,2,0)  Brush (2,16777113,16777215)'
           WHEN 'PUZ2' THEN
               'Pen (1,2,0)  Brush (2,16777113,16777215)'
           WHEN 'PUZ3' THEN
               'Pen (1,2,0)  Brush (2,16777113,16777215)'
           WHEN 'PUZ4' THEN
               'Pen (1,2,0)   Brush (2,16777113,16777215)'
           WHEN 'PUZ5' THEN
               'Pen (1,2,0)  Brush (2,16777113,16777215)'
           WHEN 'PUZ6' THEN
               'Pen (1,2,0)  Brush (2,16777113,16777215)'
           WHEN 'R1Z' THEN
               'Pen (1,2,0)  Brush (2,16758223,16777215)'
           WHEN 'RDZ1' THEN
               'Pen (1,2,0)  Brush (2,15731376,16777215)'
           WHEN 'RDZ2' THEN
               'Pen (1,2,0)  Brush (2,16756736,16777215)'
           WHEN 'RGZ1' THEN
               'Pen (1,2,0)  Brush (2,16751052,16777215)'
           WHEN 'RGZ2' THEN
               'Pen (1,2,0)  Brush (2,16751052,16777215)'
           WHEN 'RGZ3' THEN
               'Pen (1,2,0)  Brush (2,16751052,16777215)'
           WHEN 'SUZ1' THEN
               'Pen (1,2,0)  Brush (2,14613130,16777215)'
           WHEN 'SUZ2' THEN
               'Pen (1,2,0)  Brush (2,14613130,16777215)'
           WHEN 'SUZ3' THEN
               'Pen (1,2,0)  Brush (2,14613130,16777215)'
           WHEN 'SUZ4' THEN
               'Pen (1,2,0)  Brush (2,14613130,16777215)'
           WHEN 'SUZ5' THEN
               'Pen (1,2,0)  Brush (2,14613130,16777215)'
           WHEN 'SUZ6' THEN
               'Pen (1,2,0)  Brush (2,14613130,16777215)'
           WHEN 'UFZ' THEN
               'Pen (1,2,0)  Brush (2,10085375,16777215)'
           WHEN 'UGZ1' THEN
               'Pen (1,2,0)  Brush (2,15643828,16777215)'
           ELSE
               NULL
       END AS MI_STYLE
FROM Flux.dbo.PLAN_ZONE;